GoMeddo Reservation Data Import Considerations

Owned by Jérôme Vincendon (Unlicensed)
Last updated: Aug 02, 2023
2 min read

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:

  1. Use B25__StartLocal__c and B25__EndLocal__c, and use your user's timezone for each field

  2. 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

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

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