Import locations in bulk

Core HR > Account Data > Import Data


Importing locations

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 ‘Locations’. 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.


Location import requirements

ColumnField NameData TypeLength LimitExampleDescription
AID*String20AR10001A unique identifier for the area. 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 area, it will be un-deleted.
BName*StringSt Kilda storeThe name of the area, usually based on a department or store location, e.g. "Kitchen" or "Brisbane".
CAddressString9 Cubitt St, Cremorne VIC 3121, AustraliaThe full address where the area is located, including the country. The address will be used to power weather forecasts on the %roster% builder.
DTime zone*String40Australia/VictoriaMust match a TZ name as per
EGroup one¹Reference20G110001The group one the area falls in. Must match the ID of an existing non-deleted group one.
FGroup two¹Reference20G210001The group two the area falls in. Must match the ID of an existing non-deleted group two.
GGroup three¹Reference20G310001The group three the area falls in. Must match the ID of an existing non-deleted group three.
HMonday openingTime06:30The time you need at least one staff in to start opening the area, in HH:MM format.
IMonday openTime07:00The actual open time of the area, in HH:MM format.
JMonday closeTime17:00The actual close time of the area, in HH:MM format.
KMonday closingTime17:30Time time you need at least one staff rostered on until to close the area, in HH:MM format.
LMonday shutY/NnoIf the area is shut on this day. This field defaults to 'no'.
MTuesday openingTime06:30As above.
NTuesday openTime07:00As above.
OTuesday closeTime17:00As above.
PTuesday closingTime17:30As above.
QTuesday shutY/NnoAs above.
RWednesday openingTime06:30As above.
SWednesday openTime07:00As above.
TWednesday closeTime17:00As above.
UWednesday closingTime17:30As above.
VWednesday shutY/NnoAs above.
WThursday openingTime06:30As above.
XThursday openTime07:00As above.
YThursday closeTime19:00As above.
ZThursday closingTime19:30As above.
AAThursday shutY/NnoAs above.
ABFriday openingTime06:30As above.
ACFriday openTime07:00As above.
ADFriday closeTime17:00As above.
AEFriday closingTime17:30As above.
AFFriday shutY/NnoAs above.
AGSaturday openingTime08:30As above.
AHSaturday openTime09:00As above.
AISaturday closeTime16:00As above.
AJSaturday closingTime16:30As above.
AKSaturday shutY/NnoAs above.
ALSunday openingTime09:30As above.
AMSunday openTime10:00As above.
ANSunday closeTime14:00As above.
AOSunday closingTime14:30As above.
APSunday shutY/NnoAs above.

* Mandatory   1 Enterprise Only


Other relevant articles

Import Data Overview

Was this article helpful?

Import locations
3.57 of 21 votes