Help Toolbar   (select a button to browse other online help sections)

Home  Index  Tutorials  Resources  Search  Tabs & Menus  Button Bar  Table & Data Display

Work Hours Import Format

eNETEmployer allows you to import time sheet records from third party systems via a comma-separated values spreadsheet (.CSV). Time sheet data can be applied to all earning types (hourly, salary, commissions, etc.) and can be split between different departs using the Distributions feature.

Import Format:

The required format of the work hours file is : <employee#>, <earning#>, <hours>.

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).

0001 2 72.00
0002 2 72.00

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

001,1,80.00
003,1,80.00
005,1,65.00

In the examples above, the import file will apply 72 hours to earning number 2 for two employees.

Note: The values shown above are alphanumeric. They must match each column exactly. For example, of 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 0001 having a total of 72 hours applied to earning number 1 while splitting the cost allocation between two different departments.

0001 1 36.00 sales
0001 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 0001 having a total of 80.5 hours (72.00 + 8.5 = 80.5)

0001 1 72.00
0001 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 0001 needed a correction, you would simply make the changes as needed and then import the entire file once again. Employee 0001 would have the corrected hours applied and all of the other employees would see no change (i.e. their hours would be replaced with the same hours as the previous file import).

To perform a work hours import:

  1. Open the Earnings Items screen. This is the only screen that can be used to import worked hours.
  2. Choose the Browse button and locate the desired import file.
  3. Select the file and then click Open. You are returned to the Earning Items screen where the chosen file name now appears beside the Import button.
  4. Choose the Import button to import the work hours. Upon successful import the program will displays a message stating the number of rows that were processed.


See also: