Contact support

Integrations & Payroll Export

Overwatch CSV File format

OW can import asset lists in the form of csv files with the extension .alf (eg, Staff.alf) with the following line format:

AssetName, AssetListName, Keylist, Information, Action

Where:

  • AssetName is a free form string
  • AssetListName is a free form string
  • Keylist is an array of key value /name pairs of the format "KeyValue:keyName;KeyValue:KeyName"
  • Information is a free form string
  • Action is a single character of "A" for add or "D" for delete

Examples:

  1. To add an asset with the name Bob Smith, a member of Staff and who has two cars registration ABC123 and AAA111 you would have a line of "Bob Smith", "Staff", "ABC123:Primary Car; AAA111:Second Car", "Started 01/01/202", "A"
  2. To delete an asset called Fred Jones you would have a line of "Fred Jones", "", "", "", "D"

Note that a single CSV file can contain a mix of adds and deletes. To add these use the import button on the asset management window