Nightly import overwriting badge ID numbers

Client reported that whenever they manually updated the employee's Badge ID numbers inside Time & Attendance the automatic integrations were changing it back to the incorrect ID.

• Time & Attendance

• ExecuTime

• Integrations

• Scheduled System Jobs

Checking the employee build mapping table Badge ID was not set to update. However the Adhoc Employee Information import file had the incorrect badge ID number assigned to the employee. 

The Adhoc Employee Information Import is a flat file import that was created to allow a flexible way to mass assign employee information data to employee records. The values that this import can assign to an employee record are values that are not commonly handled by the payroll system and thus are often not able to be brought in via the standard employee import. For example, the import does not allow importing department or location data but does allow importing badge numbers and email addresses.

Because the Adhoc file ran had the incorrect Badge ID every night when the Scheduled System Job ran, it would change the badge ID back to the incorrect ID.

There are two resolutions for this issue.

Resolution one:

1. Login to Time & Attendance with Admin access

2. Click System Admin

3. Click Schedule System Jobs

4. Click the Pencil Icon

5. Uncheck the Active box

This will deactivate the job which will prevent the job from changing the Badge ID 

Resolution two:

1. Login to Time & Attendance with Admin access

2. Click System Admin

3. Click Schedule System Jobs

4. Click the Preview action

5. Open the CSV file that was downloaded

6. Edit the employee in questions Badge ID field to correct number

7. Save the CSV

8. Click Upload an import Job file

9. Click Choose File and then Upload now after you select the CSV file you edited.

This will fix the Adhoc file so that way when it runs its no longer changing the Badge ID to the incorrect value.