Previous | Next Main Index:   Frames | No Frames
Document:   Frames | No Frames

WS Editor Online Database Editor

General Information
Accessing WS Editor
Configure Setup File Filenames
Converting tab-delimited Excel © Spreadsheets
Conversion Options
Backup Filename Conventions

General Information
Accessing WS Editor
WS Editor will require the setup file defined in $default_setup_file, located in the DEFINE VARIABLES section at the top of ws_editor.cgi:
$default_setup_file = 'outlet_editor.setup';
WS Editor adds .setup to the filename listed in $default_setup_file and the filename defined in setup= in query strings if the filename does not end in .setup.
Online Demo:   No Query String
Requires outlet_editor.setup, defined in $default_setup_file.
Online Demo:   ?
Configure Setup File Filenames
WS Editor will print a drop down select element listing setup files ending in _editor.setup. A minimum of two setup files is required.
Filenames may be configured to display database filenames or a phrase in the drop down select element.
When WS Editor detects more than one . (dot), _ (underscore), or a ~ (tilde) in the filename, _editor.setup is removed from the filename and the remaining portion of the filename is translated for display using the following character substitutions:
_ (underscore)  converted to  single space
~ (tilde)       converted to  " sort by "
Drop down select for filenames below:  
Multiple WS Editor setup files may be configured for the reseller's database,, with a different primary sort field defined in $category_fld_num of each setup file, associating each file's filename with the name of the primary sort field defined in the file.
$category_fld_num in outlet_editor.setup must match $category_fld_num in outlet.setup. WebStore's product database must always be sorted by the field defined in $category_fld_num in outlet.setup.
Converting tab-delimited Excel © Spreadsheets
WS Editor will convert tab-delimited spreadsheets, with or without " (double-quote) text quantifiers, to WebStore's | (pipe) delimited format.
WS Editor's internally defined file extension for tab-delimited spreadsheets is .txt. The spreadsheet's filename is constucted by appending .txt to the database filename defined in $data_file in outlet_editor.setup:
Upload to the /Databases sub-directory as an ASCII text file.
Line termination characters will be corrected at the time of conversion if you upload this file in BINARY mode. Records merged into the existing database are corrected. The contents of the original spreadsheet are never altered.
WS Editor checks for the presence of the database's spreadsheet,, on each script process. When a spreadsheet is detected with a byte count greater than zero, WS Editor immediately switches to it's spreadsheet conversion page and remains locked on this page until a conversion option is submitted, converting or deleting the spreadsheet from the /Databases sub-directory.
Spreadsheets with a byte count equal to zero are ignored by WS Editor.
Spreadsheet Conversion Options:
The following options are listed on WS Editor's spreadsheet conversion page:
  Merge records in and  
 Group/AddMaintain existing Item Id's in
 Group/Remove  Maintain existing Item Id's in
 Sort/AddAssign sequential Item Id's in
 Sort/RemoveAssign sequential Item Id's in
  Replace records in with  
 Sort/AddAssign sequential Item Id's in
 Sort/Remove  Assign sequential Item Id's in
  File Options  
   Backup original and
Example backup filename:
Delete - Do not merge or replace files
No backup files created
Id numbers present in the spreadsheet are always discarded.
Group/Add and Group/Remove functions maintain the existing database id numbers present in, sorts the records according to the ascending/descending selections for the primary and secondary sort fields, and assigns id numbers to merged records from the spreadsheet beginning with the largest id number found in, plus 1.
Sort/Add and Sort/Remove functions remove the existing database id numbers present in, sorts the records according to the ascending/descending selections for the primary and secondary sort fields, and assigns sequential id numbers, beginning with 1.
Group/Add and Sort/Add functions add  COMMENT:  Category Name  category headers for each category present in the database. Double spacing is added between each category grouping in the database.
Group/Remove and Sort/Remove functions remove all  COMMENT:  Category Name  category headers detected in the database. Double spacing is removed from the database.
Backup Filename Conventions:
The backup filenames for the original database and spreadsheet are constructed by inserting the date and time of conversion into each filename using the following format:

1999 - Year     09 - Hour
  09 - Month    30 - Minutes
  07 - Day      25 - Seconds
                AM - AM/PM
Index | Top of Page