To bulk import multiple workplaces:

  1. Click Admin > Workplaces.
  2. Instead of clicking on the "Create New Workplace"  button, click on the ellipses, then Import Workplaces.
  3. Always download a new copy for each import (as sometimes the templates change; you'll get an error uploading an old version), by clicking the "Download template" button. Do not do this step if you are only updating currently existing workplaces.
  4. Fill out the spreadsheet. The following fields are mandatory for the upload, and you won't be able to import without them:
    1. Workplace Name
    2. Type
    3. Email
    4. Phone Number
    5. Address (Street Number, Name, Suburb, State, Postcode, Country)
  5. All other fields are optional and can be updated or entered another time, either by bulk import again or individually.
  6. Save the spreadsheet template to your computer.
  7. Back on Op Central, click import, select your spreadsheet. As soon as you click Import and select your spreadsheet, it will automatically upload straight away. 
  8. You will get a success message if the template imported without error, and then all the new workplaces will display.
  9. If there is an error on the spreadsheet, you will see an error on the screen and the system will download a copy of the error report. This will highlight in green all the errors. Majority of the time it's simply missing information, or that the Type isn't entered exactly the same as what's currently in the system. 
  10. Fix the errors, save the spreadsheet, and import again. 

 

To bulk update workplace information:

  1. Click Export Workplaces instead of Import Workplaces. This will download a spreadsheet of all the workplaces and the data. 
  2. Update the information on that spreadsheet and save it. You cannot change Workplace Names in bulk. See note below.
  3. Follow the same import instructions above (steps 2 & 8) to immediately update all the information in the system. 

Important Note: Workplaces are unique by name, not by email/phone number/etc. If you change a name on an export/import sheet, it will create a NEW workplace. Workplace Names can only be changed by going into the individual workplace details.