Field: Points timestamp

From Catglobe Wiki
Jump to: navigation, search



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