Field: Points timestamp



Field: Points timestamp

Field: Points timestamp
Type	Datetime
General Description	This is the timestamp on when points were inserted or withdrawn. This information will only be used if points column is not empty for an imported row.
Import Group	Points timestamp must follow this format: ‘yyyy-mm-dd hh:mm:ss’. If an import does not specify a points timestamp import column then the value set when importing will be the current time. If an import does specify a points timestamp import column but the value for any row is NULL then the value will also be seen as current time.
Business Rules	The column name should be ‘Points timestamp’ in order to be mapped automatically when checking the ‘Auto Map’ function. Points timestamp must follow this format: ‘yyyy-mm-dd hh:mm:ss’. If an import does not specify a points timestamp import column then the value set when importing will be the current time. If an import does specify a points timestamp import column but the value for any row is NULL then the value will also be seen as current time.
Auto mapping	In order to ensure auto mapping then the column name in the Excel must fit with the given name in import. This name is language dependent as shown: UK: Points timestamp DK: Point tidsstempel
Validation	If the timestamp of any column is not legal then an error will occur during validation. Error type: ERROR (the import job will not be allowed to be executed).
Notes	Please refer to points help file to know more on importing points Back to: Field: Points