|
|
|
|
|
The import file must be a text file with one line per timesheet line. The fields on the line can be separated by commas (CSV format) or by Tab characters (Tab delimited). The first line of the file must contain the version number 7.10
Field |
Format |
Size |
Job Code |
Alpha |
8 |
Cost Centre Code |
Alpha |
4 |
Component Code |
Alpha |
4 |
Product Code |
Alpha |
16 |
Quantity |
Numeric |
- |
Cost Price |
Numeric |
- |
Markup |
Numeric |
- |
Unit Sell Price |
Numeric |
- |
Date |
Date |
- |
Description |
Alpha |
60 |
Reference |
Alpha |
20 |
Comment |
Alpha |
60 |
Custom 1 |
Alpha |
30 |
Custom 2 |
Alpha |
30 |
An empty or null field in the import file is imported as the appropriate default, in the same way as manually entered timesheet lines. No validation is done on import other than to ensure that the Code fields are converted to upper case. After importing, you can validate the data, and make amendments before posting. The typical use for importing timesheets is to provide an easy way to import data from a payroll system. The IMS Payroll Partner is one example that provides a built in export facility for JC.
After import, the file is deleted and a backup copy saved in (for example, C:\Accredo\Import). The backup copy has the original name with the extension ".BAK". Previously imported files will be renamed ".BK1", ".BK2", and so on. If you need to re-import (or examine) a timesheet import file, restore the backup copy from the Import folder.
Example timesheet import file:
7.10,Cost Centre Code,Component Code,Product Code,Quantity,Cost,Markup,Unit Sell,Date,Description,Reference,Comment,Custom1,Custom2
1003,FIN,LAB,LABOUR,0.68,11,50,,2/9/2025,description,reference,comment,custom1,custom2
1003,FIN,LAB,LABOUR,3.748
1003,FIN,LAB,LABOUR,7.496