Smartstaff
1,385
edits
Changes
→Defining the Column Mapping
: [[Image:Auto9.png|thumb|none|900px]]
* The '''number of columns ''' you select determines the number of fields you can map.* The '''field name ''' is selected from the Field combo box.
* In order for the update to succeed, a single field is required to match an upload record to an existing database record this is indicated as the Identifier field. Customer data will generally be an account number type field.
* The ''' Table header ''' field is only required if you are using the HTML Table feature or when loading an XML or JSON file.
* The '''Duplicate Match Beahviour''' drop-down allows user to specify the behaviour whenever multiple records are matched using the Identifier field(s).
** Update Unique Match Only - will only update when one matching record is found
