Smartstaff, administrator
3,320
edits
Changes
→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.
* '''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)
