Changes

Auto Loader

956 bytes removed, 18:24, 9 September 2022

→‎GENERAL tab

: [[Image:AutoFile.png|thumb|none|400px]]

 

'''Defining the Record Type'''

: [[Image:Auto5b.png|thumb|none|400px]]

 

'''Activate Autoloader'''

'''FILE LAYOUT''' Tab

The File Layout section is used to determine the number of columns in the file, the delimiter between the columns and the use of a '''HTML table''' to display the dataField Delimiter.

: [[Image:Auto8.png]]

* '''Ignore Lines''' - You can specify the number of rows to ignore from the beginning of the file. This can be used to ignore column headers, if they exist as the first row in any file.

* '''Field Delimiter''' - drop-down list showing the delimiter options used to separate different values in the file into different columns. Will not be presented when the File Type is XML or JSON.

* '''Use HTML Table''' - An HTML table is very useful where imported data contains multiple records and a single record set of fields exists within SmartSimple. For example, if you wished to import multiple lines of sales information into a single text box field you would enable the HTML table feature and then map all the fields into a single field indicating the column and row delimiters. Will not be presented when the File Type is XML.

* '''Column Delimiter''' - free text field to allow entry of any delimiters required to separate different values in the file into different columns. Will not be presented when the File Type is XML or JSON.

* '''Row Delimiter''' - free text field to allow entry of any delimiters required to separate different values in the file into different rows. Will not be presented when the File Type is XML or JSON.

* '''Record Node Name''' - Only presented when the File Type is XML.

* '''Record Node Filter''' - Only presented when the File Type is XML.

* The '''number of columns''' you select determines the number of fields you can map.

* '''Identifier'''. Enable the column that you have identified as the identifier.  This is important when you are updating existing records. Single/multiple field(s) is/are required to match an uploaded record to an existing record within the system.  

* The''' Table header''' field is only required if you are using the HTML Table feature or when loading an XML or JSON file. You can fill out this section with the column headers of the file you want to upload.

* '''Field '''is selected thru a dropdown box. (see the Reference section below for information on standard field names)

• ← Older edit
• Newer edit →

Mark Bridger

Smartstaff, administrator

3,579

edits