|
|
|
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
|
