We're here to help.

Browse articles, help and advice to get the most out of Ento.

Import shifts

Importing shifts into Ento can be a useful way to work with a large number of shifts

Core HR > Account Data > Import Data

Importing shifts

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

Shift import requirements

The import will require shift date, label, type, and role ID, as indicated by the asterisk* in the field header of the CSV template file.
Other data can be included, but is not required:

  • Shift ID (if generated in another system, otherwise leave blank)
  • employee ID
  • Shift start time
  • Shift end time
  • Break length
  • Break start time


Once you have created your import file, use the File ‘Select’ button to select your file for uploading. Only the ‘Create’ mode is available for shift file imports.

Notes

Shifts imported into a date range not covered by an existing schedule (featuring the location containing the shifts role) will be ignored.
Shifts imported into date ranges that are covered by existing published schedules will be automatically marked as published and accepted by any allocated employee .
The most common reason for file import failure is not customising the date field format to YYYY-MM-DD.
Double check role IDs, and ensure the Type is ‘shift’ for regular shifts (may be on call or call out if these shift types are used in your account).
For error troubleshooting and more on file import types and modes, check out the Importing data overview article.

Shift exports

You can export shifts from an existing roster, which uses the Custom shifts CSV format. This will allow you to work with your data in a spreadsheeting program before creating a new Shifts.CSV import file.
Use the tips on creating a Export templates – Custom shifts CSV template, and check you have the fields required for the shifts import:

Shift import requirements

Name Data type Length limit Example Mandatory Description
Date Date 2014-11-05 Yes
The date the shift starts on.
Label String 09:00-17:00 Yes
This is the actual name of the shift, as it will appear on your roster and in communication.
Type Reference shift Yes
The type of shift. A ‘shift’ shift is the most common and what new shifts default to. An ‘on call’ shift can be rostered then clocked into any time by the staff – creating a call out which you can add special loadings to.
Role ID String RO10001 Yes
Must match a predefined, non-deleted role ID that belongs to an area that is covered within a roster for the date.
Staff ID String ST10001 No
Must match a predefined, non-deleted staff ID, or be left blank (unassigned).
Start time Time 09:00 No
The shift’s start time, in HH:MM format. Mandatory if a matching shift label is not found, ignored if it is.
End time Time 17:00 No
The shift’s end time, in HH:MM format. Mandatory if a matching shift label is not found, ignored if it is.
Break length Number 3,0 30 No
The length of the shift’s break (in any), in minutes. Must be shorted than the length of the shift. ‘0’ or an empty field is treated as no break. Ignored if shift label is found.
Break start Time 13:00 No
The start time of the break (if any), in HH:MM format. Must fall between the start and end time of the shift and fit the break. If left blank or break length won’t fit before the end of the shift, break start will be put in middle of shift.
ID String SH0001 No
A unique identifier for the shift record. An ID can be comprised of text and/or numbers up to 20 characters in length.

Where to now?

Export templates – Custom shifts CSV

Other relevant articles

Import data overview

Clocking in, requesting leave and more

New manager? Start here!

A closer look at how it all works

Quick answers to common questions

Get the most out of Ento

Popular topics

Create rosters, edit shifts, use fill-in finder, and learn about publishing and costing

In its simplest form, Ento is software that you and your staff can access over the Internet, via a web browser or one of our specially built apps

There are several ways you can capture time and attendance information for comparison against what was rostered.

There are three ways you can access your Staff area - the Website, iPhone or Android.

Capture and review data for staff clocking in and out before it’s sent to payroll. Here’s what you need to know.

Wondering how to set up Auto-recharge? Want to check your credit or renewal date? Making a one off payment? What is an Active staff member?

Create or update multiple records, or sync data from existing HR, payroll & POS systems using CSV templates for file imports

Find the answer to Frequently Asked Questions relating to this topic.

Hook directly into Xero and send through your Ento timesheets for an easy payroll process

Find the answer to Frequently Asked Questions relating to this topic.

Export your timesheet data in one easy file for direct import into MYOB AccountRight

Find the answer to Frequently Asked Questions relating to this topic.

Live chat support

Start a live chat.

Email support

Call support

Call on 03 9999 1234.

Book a demo of Ento