Import staff in bulk rather than individually

Core HR > Account Data > Import Data

 

Importing staff

To start a new file import, go to Core HR > Account data > Import data and click Create new.

Open the Type dropdown list and select ‘Staff’. This name may change depending on your chosen terminology.

The purple bar under the file selection will then update to include a ‘Click here’ link for downloading a CSV template that includes all the fields necessary to get importing.

More general information on preparing import files can be found in Importing data overview.

 

Staff import requirements

ColumnField NameData TypeLength LimitExampleDescription
AID*String20ST1001A unique identifier for the staff record. An ID can be comprised of text and/or numbers up to 20 characters in length. If the ID used belongs to an existing deleted staff, it will be un-deleted.
BFirst name*StringJohnThe staff's given name. This will be used when the system communicates with them.
CLast nameStringSmithThe staff's surname. While this field is not required for general use of the system it is required for most payroll integrations to work.
DPermissionsReferenceSP1001The Permission profile associated with the staff, which dictates what they can view and which tasks they can perform in the staff Area. Permission profiles can be created and edited on the 'Settings -> staff permissions' page of your account. This field defaults to first non-deleted permission profile.
EPictureStringhttps://ento.com/staffpics/john.smith.jpgA photo of the staff, used within the system to help you visually identify them. The file you upload should be in .png, .jpg, or .jpeg format. The file will be resized to 120x120 pixels on upload and should be no larger than 4MB.
FMobileNumber0412345578The staff's mobile phone number. This should be a 10-digit Australian number starting with 04. It should not contain anything other than digits. The mobile number can also be used by the staff as their login username.
GMobile notifyY/NyesIf the system should send notifications to the staff's mobile phone.
HEmailStringjohn@example.comThe staff's email address. This should be a single string of text containing an @ symbol and at least one full stop. The email address can also be used by the staff as their login username.
IEmail notifyY/NyesIf the system should send notifications to the staff's email address.
JTemp passwordStringGrfe4532Fill in if you would like to specify a new temporary password the staff needs to use to log in. If not specified and the staff is new, a random password will be generated.
KDOBDate1990-12-09
LGenderString255Male/Female
MNotesLong StringHas CPR cert.The notes field can be used to store extra pieces of information. For example, a list of their qualifications, additional contact methods, or general remarks on their work quality. staff never see what you have written here.
NCommencement dateDate2010-12-09
OTermination dateDate2015-12-09
PBase rateNumber10.343.235The standard hourly cost of the staff. This field can hold up to three decimal points and defaults to ‘0’.
QAwardReferenceAW1001An award is a set of rules the system follows to cost employee shifts accurately and warn you about potential rostering and pay issues. Awards are configured on the 'Settings -> Awards' page of your account. This field defaults to first non-deleted award.
RPay scheduleReferencePS1001The pay schedule defines the pay cycle your staff is on. pay schedules are configured on the 'Settings -> Company Settings' page of your account. This field defaults to first non-deleted pay schedule which most companies only have one of.
SWeekly ordinary hoursNumber3.338.000The ordinary amount of hours the staff is contracted to work per week. For casuals this would be 0 and for full-time staff it would be 38. This field defaults to '0' and can hold numbers with up to three decimal points.
TWork scheduleReferenceOS1001Work schedules let you define the normal (or contracted) daily split of your full-time or part-time staff's 'ordinary hours'. These definitions are then used when multiple day leave requests are made - so the system knows how many hours of leave to subtract on each day. The split is also used to make budget reports more accurate. For casuals, (zero ‘ordinary hours'), you don’t need to set a work schedule.
UAnnual leave balanceNumber10.10432.4567896523The current annual leave balance. Can be have up to 10 decimals and defaults to 0.000 on staff creation.
VPersonal leave balanceNumber10.1083.7652354132The current personal leave balance. Can be have up to 10 decimals and defaults to 0.000 on staff creation.
WLong service leave balanceNumber10.1010.0004560544The current long service leave balance. Can be have up to 10 decimals and defaults to 0.000 on staff creation.
XTime in lieu balanceNumber10.107.6000000000The current time in lieu balance. Can be have up to 10 decimals and defaults to 0.000 on staff creation.
YPrimary areaReferenceAR1001The area where the staff primarily or most commonly works. Used by the system when determining manager/s to send leave and unavailability requests too. This field defaults to first non-deleted area.
ZPrimary roleReferenceRO1001The role where the staff primarily or most commonly works. Used to group the staff on the roster builder and sort them towards the top of suggestion lists when shifts need filling for said role. This field defaults to first non-deleted role.
AARolesReference ListRO1001,RO1002,RO1003A comma separated list of the role IDs the staff can work, including their primary role. Each must match a predefined, non-deleted role ID or it will be ignored.

* Mandatory   1 Enterprise Only

 

Other relevant articles

Import Data Overview

Was this article helpful?

Import staff
4.2 of 33 votes