5.12. Import Daily Time

1. Import Structure

• This must be defined in the Import Loader Format window, found in System Admin -> Data -> Data Import, using the I_TimeSheet_SHRM_I_TimeSheet_SHRM_ID table with the Tab Separated - Format.

• In the Format Field tab, you must select from the list of available columns, all those that will make up the file to be imported (all the columns in the Time Sheet table).

2. Import File - mapped on the import structure created at point 1.

• The import file needs to be mapped correctly to the import structure defined above.

• The format of the file needs to be Text (tab delimited).

3. Temporary Import

• System Admin -> Data -> Data Import -> Import File Loader.

• Select the file constructed at step 2 and the import format from step 1.

  • Press the Process button.

4. Actual Import from Temporary Table

• Hours Management -> HRM Setup -> Import Time Sheet.You can click on the Import Time Sheet button from any line.

• Process parameters:

  • Period - select the month corresponding to the imported time sheet;

  • Timekeeper - select the timekeeper corresponding to the employees in the imported time sheet;

  • Import Options:

    • Delete old/existing records - this option erases all the records in the Import Time Sheet window;

    • Delete old imported records - this will erase all the records that have Yes in the Imported field in the Import Time Sheet window;

    • Only Validate Data - the imported data are verified, but not imported. The verification will return the OK message, or other error messages if the data are not correct;

    • <None> - only the data import will be done.

The imported data will be visible in the Time Sheet window and they will be moved to the Monthly Time Attendance Form corresponding to the period selected for the import.

Starting with version 13.12, the import process will automatically enter the department that the employee belongs to, based on the information in the Work Place tab of the Employees window.