Employee Import

The Employee Import utility has been provided to allow Employee Information to be added or maintained within MYOB IMS Payroll in larger volumes without using the standard application interface. Employee data is imported from a data file and applied programmatically to the payroll company.

The Employee Import utility (accessed from the Tools menu) is only enabled when the payroll period is closed. Access to the import option is restricted if User Security is enabled and the user does not have access to the Payroll Processing section of the program and Employee Maintenance ability.

Screen Items and Buttons

Import File Name Displays the path and file name of the data file you are importing

Columns In Data File Displays the list of columns that have been included in the data file. The list of column names is only displayed after the data file has been verified

Display Error Report When this box is ticked the error listing will be displayed on screen if errors are detected

Print Error Report When this box is ticked the error listing will be printed to your default windows printer if errors are detected

Automatically Embed Double Quotes If string fields within the data file have not been encased with Double Quotes then select this option

Print Setup Allows you to select which printer the error listing should be printed to and to modify the settings for that printer

Progress Graphically displays the progress of the operation currently underway.

Select File Allows you to select the data file you wish to import.

Verify Allows you to verify the data file you wish to import.

Import Allows you to import the verified data file.

Exit Allows you to exit the import utility and return to the payroll application.

Further Information

A Functional Specification document, Field Specification table (Microsoft Excel) and Field Description table (Microsoft Excel) are available on MYOB IMS Payroll Education Centre website. In addition, a data file template containing sample header records has been provided that you can use as a basis for creating your own import files in Microsoft Excel (or other spreadsheet application).