How to Import Timecards

This help document will walk users through how to import time from third party timeclocks that users wish to create timecards for. The import feeds are written by the reports team. Once written, users may follow the below steps to run the import.

The timecard import process is broken into four parts:

  1. Once Import is selected, the system takes the document users have selected and reads through the document
  2. During the mapping process, the system reads through the data and maps everything back to an employee and assignment under the selected customer and locates the hours, adjustment information, units if applicable, and pay code information
  3. Data integrity checks will let users know if anything wasn't mapped correctly during the mapping process. If an employee couldn't be mapped based on the ID that was used those will appear during this step for correction. This can be employee Id, the MSP Time Report ID, or an SSN for example
  4. During posting, everything that has been mapped and passed the integrity check will be sent into to time entry

To locate the timecard import:

 Navigate to Pay/ Bill and expand Other in the upper navigation tree

Once in "Other" select Timecard Import. To import a new file select the + icon

After selecting the + icon, a secondary window will populate. Within this window select the import  "Feed Type" you wish to use, if there are multiple they will also appear here.

Once the feed type is selected, select the customer that you will be importing time for.  All of your customers that will be using imports will be linked to the import they're using and will appear in the drop down:

The Weekend Bill is always going to be the open Weekend Bill from Pay/Bill:

For the file name, you'll need to use the folder icon to navigate to where the saved file with hours are stored from the customer you're importing. 

Once you've located the file, select the save icon:

Once you hit save, you will be brought to the worksheet page beneath Timecard import. Under step one you will have the opportunity to select a new document if you selected the wrong one, or you can hit the import button to start the process. 

Once you've hit import, the Map button will become available. At any time should you realize there was a typo on the document you can update the document and re-import it to fix any mapping issues resulting from the typo.

Selecting map will go through and locate the employees that are on the imported document. The system will let you know how many employees were mapped, and you can use this to validate whether or not all the employees you’re expecting have been located. Once you’re ready select the Run Check button to begin the integrity check on the data in the file.

If any errors occur (for instance if an employee in the file couldn’t be mapped or an employee has two open assignments at the current customer and the import doesn’t know which to choose), they will occur now and you’ll be told how many there are. To view these errors and and correct them you can use the view button.

Under the view area is also where you can see any warnings brought up in the integrity check. Warnings are not hard stops and won’t prevent you from posting the data to time entry. On the right hand side you can also see how the data was mapped. The assignment, WEB, employee name and SSN, and Reg/OT/Total hours from the imported document are listed.

Once everything has passed the integrity check and all errors have been resolved or excluded select post, allowing the transactions to be created in time entry.

If you do a lot of time entry through the timecard import you can add the TCFeedID column to the time entry screen to sort on your imports. That column will relate back to the ID field from the worksheet page and the ID column on the Timecard Import page. 

Timecards that come over from a timecard import are also automatically thrown into a proofing session the name of whoever posted them. You can review the timecards in time entry or go straight to proofing.

Related Articles