Smartstaff
1,385
edits
Changes
→File Layout
: [[Image:Auto8.png]]
* '''Number of Columns ''' - The number of columns you select is used to define the number of columns in the upload file, and the number of fields that can be updated in the database.
** The maximum number of fields that can be updated is 100 fields in a single file.
** If more than 100 fields are required, then you will need to create two upload files.
* '''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.
===Defining the Column Mapping===