|
The Text File Containing Times |
  
|
|
The Text File Containing Times |
|
The text file for Clock-In is called Clock-In.CSV. The CSV stands for character separated values. When e-PayDay® goes to process the file it will expect it to be in the parent folder in e-PayDay®'s data path. When it is processed it will be deleted. The next time Clock-In is used, a fresh file will be created.
The format of the file is "EmpClockID", "IN/OUT", "Time", "Date"
A sample Clock-In.CSV file with only two entries is below
"2001", "0", "09:00", "13/01/2003"
"2001", "<", "17:00", "13/01/2003"
The first line indicates the employee with employee DBID 2 in the first company ("2001") clocked IN ("0") at 9am("09:00") on the 13/01/2003. The line below indicates that the same employee clocked OUT ("<") at 5pm ("17:00") on the same day.
The text file can be opened at any time before processing. A situation that would warrant this, would be where an employee has used Clock-In after a time designated to be when the pay period ends. Perhaps the pay clerk was running late with processing the file. In this case the file would be opened and the last line deleted. After processing the file, the line that was deleted could be entered in the next file that is created.
Another situation could be where an employee has forgotten his EmpClockID and uses somebody elses. When the pay clerk is notified, they can open up the text file, find the line and change the EmpClockID.