Setup Import Paycard for tab-delimited file

A tab-delimited text file is a file containing tabs that separate information with one record per line. A tab delimited file is often used to upload data to a system. The most common program used to create these files is Notepad (.TXT)

 

Steps:

  1. Open your Layout by Notepad and check the structure of this layout.
    Example: (.TXT) file might change. This depends on software provider.
  2. Go to Configuration > Interfaces > Paycard import interfaces.
  3. Click on (+) sign to create a new layout.
  4. On Detaills tab add Code, Name of the new layout.
    File Type = Fixed length file
    Additional settings: only check Import file has a header record.
  5. Click on tab “Filed mapping”.
    This is an Example base of the (.TXT) file in step 1.
  6. Click Add button to add the line.
  7. Click on the Source field cell to activate the drop down list. Select the datasource, enter the Start and End position.

    Employee Number:  Base on (.TXT) file Step 1 Employee number start in the position tab number 2 and stop in number 14.
  8. Repeat the steps for each source field, and click on save button (check-mark symbol).
  9. Go to Payroll > Process Paycards > Batch Payroll.
  10. Make the selection > click Next.
  11. Select import interface name and browse for the file to be imported. Click next (at the bottom).
  12. Click Run Payroll.

    A successful import will produce the following screen
  13. To check Employee paycard Go to Payroll > Process Paycards > Edit Paycards.
  14. Double click on your employee.
  15. If the entry is not coming or is in the wrong place, review and check your (TXT) File until your fields coming in the right place. You can Overwrite on the Batch Paycard wizard as many time as you want.
 
Be the first to review this article