Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Comma-delimited file is a delimited text file that uses a comma to separate values. The file type can be .TXT or .CSV

NOTE: if using a .CSV open with Notepad as the leading zero will disappear if the column format is not Text type   

Create the Import File:

On the desktop of your computer, right click the screen > new > Text document. it should make a new .TXT file.
The file has the following format:
Image Added

Column 1

Employee id
Column 2Pay category
Column 3Numbers of Hours
Column 4Amount

If the value is not there leave them blank.

Create a new import interface:

Steps:

  1. Go to Configuration > Interfaces > Paycard import interfaces.
  2. Click on (+) sign to create a new interface.
  3. On Details tab add Code and Name of the new layout
    File Type= Comma delimited file
    Additional settings: only check The file provides payroll category numbers
    Image Added
  4. Click on “Filed mapping” tab.
  5. Select the Source field from the drop down list and enter the source column from the file.
  6. Click “Add” button to add new line.
  7. Click on the Save button.
    Image Added

Batch the payroll using new interface:

Steps:

  1. Go to Payroll > Process Paycards > Batch Payroll.
  2. Make the selection > click Next.
    Image Added
  3. Select import interface name and browse for the file to be imported.
  4. Click next (at the bottom)
    Image Added
  5. Click Run Payroll
    Image Added
    A successful import will produce the following screen
    Image Added
  6. To check the imported data: Go to Payroll > Process Paycards > Edit Paycards
  7. Double click on your employee.
    Image Added
  8. If the entry is incorrect review the import file.  You can Overwrite on the Batch Paycard wizard as many time as you want.
    Image Added