You can import the following sets of data. Click on the relevant category to download a sample file.

• Team member
• Location
• Area
• Leave Balance (see note below)
• Sales Data
• Schedule
• Timesheet (see also Bulk upload of timesheets to Deputy for more detailed help)
• Training Module
• Training Record

The importer is accessed differently whether you are on our Premium or Enterprise plans.

First, click on 'Enterprise' to access the Enterprise dashboard.

Under 'Custom Development', click 'Import Data'.

Clicking this will bring you straight to the importer.

To access the importer, you will need to add this backend link to your Deputy URL:

/exec/import/import_data

For example, your URL may look like this:

testURL[region].deputy.com/exec/import/import_data

This will bring you straight to the importer.

To get started, access the wizard using the instructions above based on your Deputy plan.

In the drop-down box, select the type of data you would like to import.

In this example, we'll upload 'Area' data.

Looking at the import file, we will add two new areas to two different locations.

Now simply upload your file. You can drag and drop the file into the box, or click 'Import from Excel/CSV' and selecting the file.

Now we will need to map the fields. This will ensure that the correct data is imported.

Fields:

• Company - Refers to the business name
• Operational Unit Name - The area you would like to add/import
• Show on Roster - Whether the area will appear in your schedule
• Active - If you would like the area to be active

These fields may vary based on the type of import.

The Sample Record Data can help you clarify and confirm that you have mapped the correct fields. Click 'Next' when you are ready to continue.

On the next page, you can edit any details that may be incorrect.

If there are any areas you do not want to add, but were included in the file import, you can simply unselect the checkbox for the corresponding area.

Click 'Next' to continue. A progress bar will appear which will update you on the status of your import.

After the import is complete, you can go to the relevant page to confirm the changes.

In the example used, the 'Delivery' area was imported to Bob's Burgers. We can now see it in the Areas list.

When using the Leave Balance import template the first column specifies "Employee".

This field actually supports the employee's name OR the unique Employee Record ID given to the employee in Deputy.

For the removal of ambiguity in the case of two employees with the same name, it is preferable to use the Employee's Record ID in this field.

Enterprise customers can access the Employee's Record ID by downloading the csv file in their People tab.

Premium account customers should contact support if they need to access their employee's Record ID for Leave Balance Import purposes.