Import Templates + Data Input Tips Follow

    Topics Covered
  • Template downloads
  • Data inputs
    Target Users
  • Employee
    Required Permissions
  • N/A

Template Downloads

Data Input Tips

To help ensure your data imports work as best as possible, we have collected various Tips that will help ensure your imports go smoothly.

Example: Template Data Columns

mceclip0.png

Column Tip
Title

Title is the Name of the employee, please use the FirstName LastName format and avoid commas. 

Example: John Doe or Jane Doe

Post

The Post column must match 1 to 1 a post name listed in the Who's Where Post dropdown.

mceclip1.png

Status

The Status column must match 1 to 1 a status option found in the Who's Where Status dropdown

mceclip2.png

Section

The Section column must match 1 to 1 a section name listed in the Who's Where Section dropdown

mceclip3.png

TypeOfEmployee

The TypeOfEmployee column must match 1 to 1 a TypeOfEmployee option found in the Who's Where TypeOfEmployee dropdown

mceclip4.png

Start_Date

The Start_Date should be entered in the following format:

dd/mm/yyyy

Example: 07/30/2020

End_Date

The End_Date should be entered in the following format:

dd/mm/yyyy

Example: 07/30/2020

TimeIn

TimeIn should be entered in the following format:

h:mm AM/PM

Examples:

  • 7:45 AM
  • 8:30 PM
TimeOut

TimeOut should be entered in the following format:

h:mm AM/PM

Examples:

  • 7:45 AM
  • 8:30 PM

 

Was this article helpful?
4 out of 6 found this helpful
Return to top

Comments

0 comments

Article is closed for comments.