Help Toolbar (select a button to browse other online help sections)Home Index Tutorials Resources Search Tabs & Menus Button Bar Table & Data Display
eNETEmployer allows you to import time sheet data from third party systems via a comma-separated values spreadsheet (.CSV). Time sheet hours can be applied to all earning types (hourly, salary, commissions, etc.). Initially developed for use with Advanced Tracker's timesheet files, this special import format can be used with any comma-separated spreadsheet.
Note: This special import format only works when importing hours into the Earning Items screen.
|View step-by-step tutorial|
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
In plain text form, the .CSV file would be appear as follows:
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.
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.
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).
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.