Upload Timekeepers for one Office and one Client

You can save time by creating an Excel .csv file using the provided sample file.  Consider using the Export all Timekeepers feature to assist with creating the file.

The following image displays a sample Excel .csv file that uploads 3 existing timekeepers:

1. Click on "Timekeepers" in the top menu bar, select "Upload timekeepers" and select the radio button beside the option "New Timekeeper submission & Overwrite existing profiles".
2. To upload a file, click Choose File and select the appropriate file.
3. Specify the Office you want to assign to these timekeepers by selecting the appropriate checkbox from the list of Offices and Clients. Timekeepers can be assigned to one Office from this screen (or multiple Offices). Select the appropriate clients from the Clients list and Click the "Next" button. (Note: If you are uploading client-specific timekeeper profiles make sure to populate the clientCode column in the sample .csv file.)  
   
   
   
4. The file is checked for errors and duplicates and a preview screen opens.  (Note: If you see a "Data Access Failure" message after you click Next, a timekeeper has been assigned multiple times to a client, instead of once. Review your file to look for this scenario.)
   
   
5. Review the preview screen. Use the Status column to review the validity of each entry.  (Note: If you receive an error stating that the timekeeper upload file does not comply to the Collaborati Timekeeper upload format specification, check the timekeeper file for format issues and upload again.)
   • New Record—The Timekeeper information is valid and will be uploaded without errors
   • Already Exists; Update—A timekeeper with this ID already exists and any changes will be added to the existing record
     Note: The existing records are updated with new information if the Overwrite existing timekeeper profiles check-box is selected on the previous screen.
   • Error: Incomplete—Required timekeeper information is missing. These timekeepers will not be added to the system. You can go back to your file and correct these errors, and then upload again.
   • New Record Association for Some Selected Offices; Update Record for Existing and Create New Office Associations—The Timekeeper's new office was assigned and the existing office is still assigned.
   • Conflicting Display Code for Timekeepers in Selected Offices: Do Not Update—The Timekeeper could not be updated or created due to another Timekeeper's display code.
   • Error: Must select the Office identified as a Timekeeper's Home Office for the Timekeeper—The Timekeeper's Home Office was not selected in the previous step.  Try removing the Timekeeper's Home Office or choosing a different Home Office.
   • New Record Association for Some Selected Offices; Do Not Update Record for Existing and Do Not Create New Office Associations—The Timekeeper was assigned only to the selected office.  The previous office that the Timekeeper was assigned to was removed.  Also the Home Office was removed.
6. After verifying the information, Click the "Submit" button to assign the Timekeeper(s).