Import Templates + Data Input Tips Follow

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

 

Comments

0 comments

Article is closed for comments.