[SalesForce] How to Associate Holiday and Business Hours in Data Import

Is there a way to insert/update Holidays and create the association to an existing Business Hour? In the UI this is achieved by clicking into the Business Hour, clicking the "Add/Remove" button under Holidays and adding the Selected Holidays. I have a lot of Holidays to add and I'd like to be able to create this relationship via a data import if possible. I have to deploy to multiple sandboxes, so a solution via data import or code would be ideal.

Side note: I'm aware of the limitations on querying the junction between Holidays and Business Hours (see here: Business Hours and Holiday Affiliation), but I'm still hoping there might be a solution around the import.

Thanks in advance for any guidance!

Best Answer

Official word from Salesforce Support: At this time, this is not a part of standard salesforce functionality.

So it looks like the Holiday/Business Hour association can only be accomplished manually on the UI. Please go vote on this Idea if you're running into the same problem: https://success.salesforce.com/ideaview?id=087300000006n4CAAQ

Related Solutions

[SalesForce] Business Hours and Holiday Affiliation

Based on this idea it looks like the junction isn't exposed.

The BusinessHours.isWithin method does take holidays into account but only holidays that have been linked to the Business Hours passed into the method.

[SalesForce] Creating Holidays and Business Hours in Test Code

I was a bit curious and I actually verified what you said

Business Hour Data is available in Test Code Context. Holidays, however are not, you have to create your own.

Are you sure about that? Because it returns my holiday. I made my test on api 28.0 and 29.0

I've created one Holiday and run exactly the same test.

@isTest
private class TestBusinessHours {

    @isTest static void test_method_one() {
        List <BusinessHours> records = [select id from BusinessHours where isDefault = true];
        System.assert(records.size() == 1);

        List <Holiday> holidays = [Select Id From Holiday];
        System.assert(holidays.size() == 0);
    }
}

Here is my result:

14:22:30.554 (1554897000)|SOQL_EXECUTE_BEGIN|[5]|Aggregations:0|select id from BusinessHours where isDefault = true
14:22:30.573 (1573725000)|SOQL_EXECUTE_END|[5]|Rows:1
14:22:30.574 (1574225000)|SOQL_EXECUTE_BEGIN|[8]|Aggregations:0|select Id from Holiday
14:22:30.575 (1575604000)|SOQL_EXECUTE_END|[8]|Rows:1
14:22:30.575 (1575763000)|EXCEPTION_THROWN|[9]|System.AssertException: Assertion Failed
14:22:30.575 (1575909000)|FATAL_ERROR|System.AssertException: Assertion Failed

Class.TestBusinessHours.test_method_one: line 9, column 1
14:22:30.575 (1575927000)|FATAL_ERROR|System.AssertException: Assertion Failed

Class.TestBusinessHours.test_method_one: line 9, column 1

Maybe add @isTest in your SimpleTest Mehtod ;-)

Best Answer

Related Solutions

[SalesForce] Business Hours and Holiday Affiliation

[SalesForce] Creating Holidays and Business Hours in Test Code

Related Topic