What you need

You need two files:

• A CSV file with the data you want to import
• An IMP file that tells Sage 50 Payroll Ireland how to handle the data

Create an IMP file

The IMP file lists the database tables and fields you want to import. You can create it using Notepad or WordPad.

View available fields

1. Log in to a payroll.
2. Go to Help, then select System Information.
3. Select the link beside Program Directory.
4. Locate MICW.DDL, then right-click and choose Open with.
5. Select Notepad or WordPad.

 TIP: Don’t import employee year-to-date values. These update when you retrieve an RPN or process payments. Enter other year-to-date values manually in the ETP tab. 

Example IMP file

[tables]
table1=Employee
[Employee]
record=EMPLMAST
key=EMPLOYEE
field1=employee
field2=name
field3=first
field4=addr1
field5=addr2
field6=addr3
field7=addr4
data=C:\EXAMPLE.CSV
create=yes
blank=yes
decimals=yes
audit=Yes
verbose=Yes

Create a CSV file

The CSV file contains the data to import. Its fields need to match those in the IMP file.

Important: The CSV and IMP file names must match exactly. For example: 

• NewStarters.csv
• NewStarters.imp

If the names differ, the import won’t work.

Example CSV file

001,Smith,Sam,Waterstone House,Moycullen,Galway,
002,Jones,Bill,Citywest,Tallaght,Co Dublin,

Data validations and limits

• The system validates mandatory fields and ignores invalid entries
• The system creates imported codes, department, cost centre, etc, only in Employee Details, not at payroll level
• The system ignores extra fields in the CSV
• There's a limit of 2048 characters, including commas, for each record line

Import the data

1. Open Sage 50 Payroll Ireland and log in.
   Tip: Take a backup before you start.
2. Go to Miscellaneous.
3. Select Data Import, then Data Import.
4. Browse to the IMP file and select Open.
5. When prompted, select Yes to view the import log.
6. Check the details are correct.

 TIP: Always review the import log after each import.