0
edits
Changes
no edit summary
'''Notes:'''
* If any of the data to be imported contains commas and you are creating a '''csv''' file from Excel you should export the data using pipes (|) as the separators rather than commas. To do this you need to change the settings on your PC prior to creating the '''csv''' file. The method of doing this depends on your PCs Operating System, but is roughly outlined below:
Start -> Settings -> Control Panel -> Regional Settings.
Click the "Number" tab and in the "List Separator" field,
Replace the current default separator with the one you want to use (such as the pipe symbol | ).
* If you use Microsoft Excel to create a '''csv''' file it is recommended that you open the document with Notepad to review the contents prior to Autoloading. If any of the data within the Excel document had line breaks within cells it will create a line break in the '''csv''' document. Each new line in the '''csv''' document will start a new record, thus you must ensure all inner-cell line breaks are removed from either Excel or the '''txt''' document.
* Alternately when performing a CSV import, any columns that have line breaks or delimiters within the content can be contained within double quotes. NOTE: Any double quotes within that content MUST be escaped with a backslash \ in front of the double quote so they aren't treated as the closing quote of the column. Exampleof a 4-column CSV:
1st Record|Draft|"This content"|555-1212
2nd Record|Submitted|"That content"|123-4567
6th Record|Submitted|"Normal Content again"|111-2233
===Autoloader Constraints===