- Sales1-877-762-2519
- Support Lines
- North America1-877-862-2519
- Australia1800 223 198
- United Kingdom+44 (0) 80 0048 8810
- Other Countries+800-6622-5192
Before you can start using the Time Workbench to export time you’ll need to ensure a export format for your third-party app is in place. A default CSV export format exists, that will create a CSV file based solely on the data columns you've included in the export.
You might want to create a custom format to include fields that are exportable that don't display on the Time Workbench interface, such as client and time off booking ID, or to define fixed value columns, or to export to an FTPS server.
To add an export file format:
All the file formats that are currently available for use when exporting time display.
A row displays, with a drop-down Value field and a label that matches it.
Be sure to add columns in the order you want them to display (i.e. the first column should appear first). You can reorder them, if needed.
The label will be the column header in the exported file. If necessary, update the label to match the requirements of the app you'll be importing into.
A Fixed Value column is available in this list, which you can use to define values that don't change, like your company code. If you select Fixed Value, an additional field will display, where you can enter the value.
The file format you added will now be available to select when you carry out an export.
Note that: