How to Bulk Upload Salesforce Business Hours

Share this article...

Once, I was dealing with was a company based in the UK with customers all over the world. To best serve them, and to align the company with their new SLA’s, they would need all of the time zones they use in Salesforce as Business Hours.

I thought it would be best to bulk upload every time zone that Salesforce recognizes, and then let them assign to their customers as they see fit. This is the way I did it…

The Preparation

The first thing I did was extract some existing Business Hours using the Data Loader. This would give me a good idea of the kind of format I would need. Below is what I got, pretty straight forward (I’ve removed Tues-Friday for ease of viewing).

businesshopurs.JPG
  • NAME: The name you want to assign to a particular time zone.
  • ISACTIVE: Whether this particular timezone can be used or not.
  • ISDEFAULT: Only one default can be active at any one time, this is the timezone a case will default to if there is none selected.
  • MONDAYSTARTTIME/ENDTIME: The ISO format for entering time that Salesforce uses.
  • TIMEZONESIDKEY: The text string ID that Salesforce uses to assign a particular timezone.

This is the format you will need to prepare your data in for upload. Here are all the TIMEZONESIDKEY you will need to bulk upload Salesforce Business Hours:

READ MORE: TIMEZONESIDKEY in Salesforce – The Complete List

The Upload

I was really happy with my excel spreadsheet creation and tried to upload everything with the Salesforce Dataloader. However, it didn’t work. The Data Loader would not mass upload into the BusinessHours object. I gives the error: “Monday Start: value not of required type: 08:00:00.000Z”. I tried all the different variations of this ISO time format to no avail.

After a few hours of research I found out that only 3rd party data loaders work. If you haven’t had any exposure to the likes of dataloader.io or workbench, they are cloud, browser based dataloaders and I’ve included links to them at the bottom of this page.

READ MORE: The 6 Best Data Loaders for Salesforce (Pros & Cons)

Results

It worked! There were a few errors with uploading a few business hours but these were created manually. I’ve included a link to the CSV file that I used to upload these business hours as its pretty easy just to change the start and end times if you have a similar requirement to mine. Happy uploading!

 Useful Links

Business Hours full CSV

TIMEZONESIDKEY list

Dataloader.io

One thought on “How to Bulk Upload Salesforce Business Hours

  1. Hmm it looks like your website ate my first comment (it was extremely long) so I guess I’ll just sum it up what I had written and say, I’m thoroughly enjoying your blog.
    I too am an aspiring blog blogger but I’m still new to the whole thing.
    Do you have any suggestions for novice blog writers?
    I’d certainly appreciate it.

Add Comment