Summary

Use this command to import timebands from a third party software package or from a file which meets the format criteria.

TimeMaster DBF format fields

26 fields are imported for each record (listed in bold):

BuildThisField(pTBFile, lsFieldList, 'EmployeeCode');

BuildThisField(pTBFile, lsFieldList, 'Date');

BuildThisField(pTBFile, lsFieldList, 'StartTime');

BuildThisField(pTBFile, lsFieldList, 'EndTime');

BuildThisField(pTBFile, lsFieldList, 'ReasonCode');

BuildThisField(pTBFile, lsFieldList, 'BreakAmount');

BuildThisField(pTBFile, lsFieldList, 'BreakCode');

BuildThisField(pTBFile, lsFieldList, 'RequirementCode');

BuildThisField(pTBFile, lsFieldList, 'WorkAreaCode');

BuildThisField(pTBFile, lsFieldList, 'LocationCode');

BuildThisField(pTBFile, lsFieldList, 'DepartmentCode');

BuildThisField(pTBFile, lsFieldList, 'Dim1Code');

BuildThisField(pTBFile, lsFieldList, 'Dim2Code');

BuildThisField(pTBFile, lsFieldList, 'Dim3Code');

BuildThisField(pTBFile, lsFieldList, 'Dim4Code');

BuildThisField(pTBFile, lsFieldList, 'PositionCode');

BuildThisField(pTBFile, lsFieldList, 'TaskCode');

BuildThisField(pTBFile, lsFieldList, 'ShiftCode');

BuildThisField(pTBFile, lsFieldList, 'ShiftGroupCode');

BuildThisField(pTBFile, lsFieldList, 'Type1Code');

BuildThisField(pTBFile, lsFieldList, 'Type2Code');

BuildThisField(pTBFile, lsFieldList, 'Type3Code');

BuildThisField(pTBFile, lsFieldList, 'Type4Code');

BuildThisField(pTBFile, lsFieldList, 'AwardCode');

BuildThisField(pTBFile, lsFieldList, 'RateCode');

BuildThisField(pTBFile, lsFieldList, 'RateAmount');

Note: Of these 26 fields, the first 4 are compulsory.

Datatypes

The datatypes of these 26 fields are:

'EmployeeCode' Char, 12

'Date' Date

'StartTime' Integer

'EndTime' Integer

'ReasonCode' Char, 12

'BreakAmount' Integer

'BreakCode' Char, 12

'RequirementCode' Char, 12

'WorkAreaCode' Char, 12

'LocationCode' Char, 12

'DepartmentCode' Char, 12

'Dim1Code' Char, 12

'Dim2Code' Char, 12

'Dim3Code' Char, 12

'Dim4Code' Char, 12

'PositionCode' Char, 12

'TaskCode' Char, 12

'ShiftCode' Char, 12

'ShiftGroupCode' Char, 12

'Type1Code' Char, 12

'Type2Code' Char, 12

'Type3Code' Char, 12

'Type4Code' Char, 12

'AwardCode' Char, 12

'RateCode' Char, 12

'RateAmount' Double, 11, 4

File format

A timeband in a CSV import file uses the following format:

1005,20090615,555,975,,0,,,,,,,,,,,,,,,,,,,0,20.09

Where:

EmployeeCode = 1005

Date = 20090615

StartTime = 555

EndTime = 975

ReasonCode is empty (no value)

BreakAmount = 0

All the other fields are empty (no value) except for

RateCode = 0 and

RateAmount = 20.09