Moving Clock-in and Clock-out data into SAP system.

Requirement:

Time recording data - Clock-in and Clock-out is recorded by a time recording machine. This data (only first-in and last-out events are needed) needs to be moved into the SAP system but there is no requirement to calculate overtime i.e. the actual time recorded is not processed to get overtime details. Therefore the clock-in and clock-out data after loading in SAP system is just used in TM only to determine whether an employee is absent or present and for leave accrual.

Therefore I am trying to move this data into SAP using flat file into CC1TEV table and then post it to 2011 i.e. Time event infotype. But am getting an error because the format of the flat file seems to be incorrect (log displays truncated data in the file columns/fields ).

Need help:

(1) regarding this correct file format (2) Whether the approach taken by me is correct.