Import EATS Transactions

With the Workcube Import EATS Module, you can upload the XML files created for the days off, shifts, and working days of the employees in your organization to the system.

You can authorize your employees to view and create a single branch, multiple branches, or all branches in order to upload the prepared EATS import files and view the uploaded files. With this function of Workcube, it provides the opportunity to be used only by the employees you authorize.

Route: HR  > Personnel-Payroll > Attendance and Control > Import EATS 

Import EATS

      1. Adding file: Click the "+" icon to open the import document types and upload the relevant file. 

      2. File processing: By clicking on the relevant icon, the uploaded files get operated on the system.

      3. File removal: If there is incorrect data in the uploaded file or it is missing something, the relevant import file can be deleted by clicking the "-" icon.

      4. File viewing: The corresponding icon provides to view the uploaded files.

      5. Branch Listing: It provides the opportunity to select the options to view the uploaded files individually or on a branch basis.

      6. Date Range: It performs the process of listing the uploaded files by selecting the date range (Start-End) of the uploaded files.

      7. Import File Upload: It provides the process of uploading the prepared import file to the system by selecting it from your computer.

      8. Branch: Indicates the area where the branch to be imported is selected.

      9. Document Type: The import file to be loaded refers to the field in which the document type is selected in the system.

Import EATS Document Types

Workcube:

The transfer process starts from line 1 of the file, so the field names should be on the first line. There will be a total of 9 fields in the document. Marked fields are required.

The fields order should be as follows:

 1- EATS No *

 2- Day *

 3- Month *

 4- Year *

 5- Starting Time *

 6- Starting Minute *

 7- Ending Time *

 8- Ending Minute *

 9 - Overtime - Leave ID * (Work ID: Working Day FM: -1, Weekly Holiday FM: -2, Public Holiday FM: -3, Night Work FM: -4, Working Day: -5 Weekly Holiday: -6 General Holiday: -7 Day off: Leave Category ID)

Multiport:

The file extension must be txt and the fields must be separated by spaces. The transfer process starts from the 1st line of the file, so the first line should be the field names.

There will be a total of 4 fields in the document;

    1- EATS No.

    2- Start Date

    3- Start Time

    4- Branch Code

XML Base:

The file extension must be XML. The transfer process starts from the 1st line of the file, so the first line should be the field names.

There will be a total of 2 fields in the document, respectively;

    1- EATS No.

    2- Start Date

ERK:
The transfer process starts from the 1st line of the file, so the first line should be the field names.

There will be a total of 7 fields in the document;

    1- EATS No.

    2- Day

    3- Month

    4- Year

    5- Hour

    6- Minute

    7- Start Date

TXT File:

The file extension must be txt and the fields must be separated by spaces.  The transfer process starts from the 1st line of the file, so the first line should be the field names.

There will be a total of 4 fields in the document, respectively;

    1- EATS No.

    2- Start Date

    3- Start Time

    4- Branch Code

The file extension must be CSV and the fields must be separated by semicolons (;). The transfer process starts from the 2nd line of the file, so the field names should be in the first line.

There will be a total of 4 fields in the document, respectively;

    1- Identity Number

    2- Working Hours

    3- Month

    4- Year

Free Time:

 The file extension must be txt and the fields must be separated by commas (,).

 There will be a total of 5 fields in the document, respectively;

    1- Device number: If there is no device number, enter 001.

    2- EATS Number.

    3- Enter 1 (One) in this field.

    4- Date

    5- Hour

EM Nideka X659 UTC:

 The file extension must be txt and the fields must be separated by commas (,).

 There will be a total of 5 fields in the document;

    1- Device number: If there is no device number, enter 001.

    2- EATS Number.

    3- Enter 1 (One) in this field.

    4- Date

    5- Hour

TA:

 The file extension must be csv and the fields must be separated by commas (;).

 There will be a total of 5 fields in the document, respectively;

    1- Device number: If there is no device number, enter 001.

    2- EATS Number.

    3- Enter 1 (One) in this field.

    4- Date

    5- Hour

TA EATS: 

The file extension must be CSV and the fields must be separated by semicolons (;).  The transfer process starts from the 2nd line of the file, so the first line should be the field names.  Data must be entered in the import file in time format (HH: MM). Each line of the import file corresponds to one day.  There will be a total of 26 fields in the document:

1. PDKS Number or Employee Number

 2. Name: Employee Name

 3. Surname: Employee Surname

 4. Date: The date on which the PDKS import operation will be recorded.  It should be entered as \DD.MM.YYYY\

 5. Zip code (Can be left blank)

 6. Normal Day: Normal working hours on weekdays

 7. Absenteeism: It will create a leave record opened under the name of absence.

 8. Week Holiday: It will record in the Week Holiday field.

 9. SSK Day: SSK Hour Day (This field is inactive. The system will display the SSI Day.

 10. Weekday Working Hours: Weekday working hours

 11. Night Work: Night work time

 12. General Holiday Working Hours

 13. Weekend Working Hours

 14. Paid Leave: Creates a leave record opened under the name of paid leave.

 15. Free Leave: Creates a leave record opened under the name of free leave.

 16. Visit: Creates a leave record opened under the name of Visit.

 17. Report: Creates a permission record opened under the name of the report.

 18. Annual Leave: It creates a leave record opened under the name of annual leave.

 19. Marriage Permit: It creates a permission record opened under the name of Marriage Permit.

 20. Death Permit: It creates a leave record opened under the name of Death Permit.

 21. Maternity Leave: It creates a leave record opened under the name of maternity leave.

 22. Excuse Permit: It creates a record of permission opened under the name of excuse leave.  

 23. General Holiday Day: Enters the General Holiday field.

 24. Control: Do not enter any value in this field.  (can be filled as \'0\')

 25. Process ID: The ID of the permit process must be entered

 26. Category ID: Permission Category ID must be entered.  Otherwise, it should be entered as 0!