Import

When importing data it is very important that the columns and data in the csv file are formatted correctly as outlined on the import page. It is recommended to backup your websites current data before importing any new data.

Importing Data

To import data from a csv file click the import button next to the csv file you want to import. A preview of the data contained in the file will be shown so you can make sure everything looks in order before initiating the import process. Nite there is a checkbox to ignore blank cells. If checked the import process will ignore any blank cells/data. However if it is unchecked the import process will use the blank data to clear any existing data on the item. If you don’t want a particular column of data being imported and overwriting existing data you can remove it from the csv file before uploading it. The item’s ID column however must always be present. You can upload a csv file from your computer to add it to the list using the file upload option however if the file is more than a few MB you may need to upload it into the cms backup directory via FTP instead.

Downloading & Opening CSV Files

Any csv files that have been uploaded or exported by the CMS are listed on the import page and can be downloaded using the download link. The csv file can be opened in any spreadsheet program. When opening/importing the file make sure to set the pipe character as the delimeter and all columns as text.

Deleting CSV Files

For security reasons csv files should not be left on the server any longer than necessary. To delete csv files off the server select the check boxes beside the files you want to delete and click the delete selected button. Make sure any file downloads have completed before deleting files.

CMS Help - Import