Time Card Import from Time Clock Software

Top  Previous  Next

AccuBuild can import time card records from third party time clock programs.  The export file must be in an Ascii format and contain the required data.  The Time Card Import Tab is used to set up the default settings for the time card import and these settings are stored in the company file AsciProp.adt.   Be sure to review the document titled Business Rules for Time Card Import for more information.

 

oTime Card Import Provider - Identifies the third party company providing the time card system.  Besides the AccuBuild Excel Template, NOVATime Technology, Inc. is the only option at this time.

 

oTrans Code Cross Reference  -  These fields identify the transaction codes within the Ascii file that will correspond to the AccuBuild time card transaction codes for regular pay and overtime pay.

 

oAscii File Type - Identifies the type of Ascii file as Delimited or Fixed Length records.  For delimited text you will need to enter the Quote Symbol and the Delimiter Symbol to be used in the delimited text file. Note:  Only fixed length Ascii files are supported at this time.

 

oAscii File - Identifies the name and path of the Ascii file to be imported.  Use the Browse button on the right to locate the file and set the path.

 

oAscii Spec File -  This file holds the layout design for the Ascii file.  The spec file is a simple text file that contains one line for each field and each line contains three settings: the AccuBuild field name, the starting position of the field in the Ascii record, and the length of the field.  
 
The following is an example of an Ascii specification file:

 

E_NO,1,6

TRANS_DESC,7,3

HOURS,10,8

JOB,27,8

PHASE,35,7

 

Note:  When using a third party time clock system where the state code is not included in the import file and the state code does not exist on the job, the system will default to the employee state code, or first state code of the employee if multiple state codes exist, so that the state code no longer needs to be set up on the job for time card import purposes. (Version 8.5.0.2)

 

oReset to Default Settings - This button will load the AccuBuild defaults for the selected Time Card Import Provider.

 

 

Pr_P_TimeCardImport