Custom Work Hours Import Format

eNETEmployer allows you to import time sheet data from third party systems via a comma-separated values (.CSV) file. Time sheet hours can be applied to all earning types (hourly, salary, commissions, etc.). This special import format can be used with any program that can export a comma-separated values (.CSV) file.

Note: This special import format only works when importing hours into the Earning Items screen.

View step-by-step tutorial

The Import Format:

The required format of the work hours file is:

<employee#>, <earning#>, <hours>. No header is required.

In a spreadsheet, a sample import file would appear as follows (where the first column is the employee number, the second column is the earning number, and the third column is the work hours to be applied).

001 1 80.00

002 1 80.00

003 1 80.00

001	1	80.00
002	1	80.00
003	1	80.00

In plain text form, the .CSV file would be appear as follows:

001,1,80.00
002,1,80.00
003,1,80.00

In the examples above, the import file will apply 80 hours to earning number 1 for three employees.

Note: The values shown above are alphanumeric. They must match each column exactly. For example, if your employee number is 001 in the payroll, entering "1" in your import file would be incorrect.

Splitting hours between departments:

You can also allocate the hours to different departments using the Distributions feature. The required format is:

<employee#>, <earning#>, <hours>, <distribution name>

For example, the following import file will result in employee number 001 having a total of 72 hours applied to earning number 1 while splitting the cost allocation between two different departments.

001	1	36.00	sales
001	1	36.00	factory

Multiple earning entries:

If an earning appears more than once, the results will be added together. For example, the following import file will result in employee number 001 having a total of 80.5 hours (72.00 + 8.5 = 80.5).

001	1	72.00
001	1	8.5

Overwriting a previous import:

Each time a file is imported, it will overwrite the pre-existing hours. Therefore, importing the same file multiple times will have no effect.

This can also be useful if you need to make corrections to a file. For example, if employee 001 needed a correction, you would simply make the changes as needed and then import the entire file once again. Employee 001 would have the corrected hours applied and all of the other employees would see no change.

See Also: