Timekeeping - Importing Time Data

Before you begin

Before you begin importing time data, you must first update the employee database. If there are newly hired employees, you must first create their employee records. Their employee numbers will be needed during the validation of the time data.

To add new employees, go to EMPLOYEES and enter all the pertinent employee data.

Importing Time Data


1. Copy the data file DBPROXPRO.

• The DBPROXPRO is the file that contains the time data. It is where the proximity electronic timekeeping software stores the data. This software is a 3rd party software independent from the New Payroll.
• To import the data from DBPROXPRO, simply create a copy of this file and save it into the New Payroll directory. The DBPROXPRO is usually stored in the c:\Program Files\ProxPro\. 
• The New Paryoll directory is c:\GreatLab\. Save a copy of DBPROXPRO in this location c:\GreatLab\Database.

2. Import the time data.

• To import the time data, 

1. Enter the cut-off date. In the COMMAND PANEL, under DATE RANGE, enter the cut-off date in the FROM field. You only need to specify the FROM date. The TO date is not necessary. What the program will do is to import all time data from the date you specified up to the current date. To ensure that your time data are complete, enter a cut-off date that is one day earlier. Don't worry. The program has a facility to ignore duplicate records.
2. Click the tab TIMEKEEPING and click IMPORT TIME DATA. The program will confirm if you have entered the correct date. If you did not, simply cancel the task. Otherwise, you may proceed by clicking OK.

What the program does

The New Payroll extracts every time record from the time data file based on the date you specified. Then, it checks the card number in every record against the employee records. If a match is not found, it is purged into a data file. This purged data is displayed at the end of the task.

What to do in case of a no matched employee

If there's no employee match, you have to verify the data and enter the correct card number. If you don't have any other source to verify the incorrect card number, you can leave the records as is. You may need these data to verify a time entry.You can delete though the older records.