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