| Exporting
To export data as a comma or tab delimited text file, follow the export link from the Merchant Control Panel. Pick the table you wish to export and then fill in the parameters on the next screen:
- File name to save to
- Field delimiter
- Line terminator
- Enclosed by
- Row ranges
- Escaped by
For a file suitable for Microsoft Excel use the following parameters:
- field delimiter (,) (comma)
- Choose Windows for line terminator
- Enclosed by " (double quote)
- Escaped by " (double quote)
Please note that carriage returns in the description field may not export properly.
Importing
To import a comma or tab delimited text file into the database, follow the import link from the Merchant Control Panel. Pick the table you wish to import and then fill in the parameters on the next screen:
- Upload File (Use the browse button to select)
- Field delimiter
- Line terminator
- Beginning rows to ignore
- Enclosed by
- Escaped by
- Import Mode
For a file saved as a csv file in Microsoft Excel use the following parameters:
- field delimiter (,) (comma)
- Choose Windows for line terminator
- Enclosed by " (double quote)
- Escaped by " (double quote)
- Rows to ignore 1 (If you have a heading row)
Choose the desired mode: replace mode or append mode. Please note that carriage returns in the description field may not export properly. |
