GoMeddo Reservation Data Import Considerations
- Jérôme Vincendon (Unlicensed)
- Luuk Koetsier (Unlicensed)
- Tim Schuitemaker
- Maarten Lapere
This page explains which fields to use to import data in the Reservation object using a CSV file. For general information on how to import data in Salesforce, please have a look at this article.
To import the reservation times correctly, there are two options:
Use B25__StartLocal__c and B25__EndLocal__c, and use your user's timezone for each field
Use B25__Start__c and B25__End__c, and use the target Resource's timezone for each field
The first option is recommended if you are importing data for Resources in multiple timezones, because then you can apply the same timezone to every time field. If the Reservations you are importing are all in the same timezone as your user, then it does not matter which option you choose.
Make sure that you do not attempt to write to the following fields, as these fields are set automatically by GoMeddo:
B25__Start_Date__c, B25__End_Date__c, B25__Local_Start_Time__c, B25__Local_End_Time__c
If you are not familiar with the date formats accepted by Salesforce's Data Loader, please refer to this article: Salesforce Developers
Example Scenario
We have two Resources in two different timezones: Moscow (+3:00) and Bangalore (+5:30).
We are importing two Reservations, one for each Resource. They both start at noon, and they both last one hour.
If we use the first option, we will need to use the user's timezone. Let's say you are located in Amsterdam with timezone +2:00.
The resulting CSV will look something like this:
B25__Title__c | B25__Resource__c | B25__StartLocal__c | B25__EndLocal__c |
|---|---|---|---|
Reservation 1 (Moscow) | <Moscow record Id> | 2019-09-03T12:00:00.000+200 | 2019-09-03T13:00:00.000+200 |
Reservation 2 (Bangalore) | <Bangalore record Id> | 2019-09-03T12:00:00.000+200 | 2019-09-03T13:00:00.000+200 |
If we use the second option, our CSV will look something like this (note the different column headers for the time fields):
B25__Title__c | B25__Resource__c | B25__Start__c | B25__End__c |
|---|---|---|---|
Reservation 1 (Moscow) | <Moscow record Id> | 2019-09-03T12:00:00.000+300 | 2019-09-03T13:00:00.000+300 |
Reservation 2 (Bangalore) | <Bangalore record Id> | 2019-09-03T12:00:00.000+530 | 2019-09-03T13:00:00.000+530 |
The advantage of the first option is that the Resource's timezone does not matter. All the times have the same timezone.
The advantage of the second option is that it does not matter who runs the import, the times will always be correct.
Related articles