Importing Timecards and Hourly Rates

Adagio Payroll version 4.2.06 supports multiple hourly pay rates and allows overriding hourly pay rates during timecard entry.

If you do not import Timecards into 21st Century, disregard this notice!

If you have been importing timecards into C21, you must take steps to accommodate this new feature, even if you don’t intend to use it. (This does not apply to anyone using a custom timecard import that was developed by our staff.)

If you import Timecards and DO NOT intend to use multiple hourly pay rates and overriding hourly pay rates during timecard entry, you must restore the old style timecard import configuration file.

  1. Make sure that there is no one in C21 on any computer.
  2. Open the My computer window on your C21 server and find your ..\AdagioPR\data folder. In this folder, you will find a file called timecard_import.cfg. This is the new import definition file that was installed with the recent upgrade. Re-name this file to “NEW_timecard_import.cfg.bak”.
  3. Your original timecard import configuration file was archived during the upgrade. It is now called timecard_import.cfg.bak. Right-click the file and choose rename. Call the file timecard_import.cfg.
  4. Restart C21 and continue with processing payroll as you normally would.

If you import timecards and you DO intend to use multiple hourly pay rates and overriding hourly pay rates during timecard entry feature, you must modify the C21 timecard import configuration file and the process that generates the timecard import file you use.

Modify the configuration file:

  1. Make sure that there is no one in C21 on any computer in your system.
  2. Open the My computer window on your C21 server and find your ..\AdagioPR\data folder. In this folder, you will find a file called timecard_import.cfg. This is the new import definition file that was installed with the recent upgrade. Re-name this file to “NEW_timecard_import.cfg.bak”.
  3. Your original timecard import configuration file was archived during the upgrade. It is now called timecard_import.cfg.bak. Right-click the file and choose rename. Call the file timecard_import.cfg.
  4. Now open this file with Notepad, or similar.
  5. Add the hourlyRate field in the position as it will be in your import file.

    Example Before:
    column_list = employeeID, timecardEndDate, incomeFactorID, hour

    Example After:
    column_list = employeeID, timecardEndDate, incomeFactorID, hours, hourlyRate
  6. Save this file to c:\AdagioPR\data\timecard_import.cfg (Note that this is a different file name. It is the location that the program expects when processing timecards.) You will be asked if you wish to replace this file, say 'yes'.

Make the corresponding change to the program that produces the file to be imported.

If you do not wish to utilize the new features, you will need to rename the configuration file. Take the following steps:

  1. Browse to the configuration file in your program folder. Your configuration file is at ..\data\timecard_import.cfg.bak. Where .. is the location of your program folder.
  2. Right-click on the file and rename it to ..\data\timecard_import.cfg.