Help Toolbar   (select a button to browse other online help sections) Home  Index  Tutorials  Resources  Search  Tabs & Menus  Button Bar  Table & Data Display

---

Extended Import Format

eNETEmployer provides an extended import format to support exported data from other systems that do not share the program's internal ID. This format is flexible and allows you to use one or more columns to identify a unique employee. You can then update any number of columns during the update process.

The extended format includes an instruction line at the top of the file to specify the headers of the ID columns. The instruction line ends with '!!!' as shown below.

The required format is: IDCOLUMNS("Column1"&"Column2"&"Column3")!!!

For example:

IDCOLUMNS("Employee No.")!!!
"Surname";"Given Name";"Employee No.";"Gender";"Template"
"Jon";"Doe";"0002";"male";"hourly"

Examples:

Setup Employee - Update

Setup Employee - Create

YTD Ded Ben Employee - Update

 

---

See Also:

• Importing (an Overview of Import Types)
• Importing Employees (and other data) from a Spreadsheet File
• Importing Employees from a Different Payroll (the Employee Database)
• Importing Employee Work Hours
• Custom Work Hours Import Format
• Extended Import Format (for importing other item types)