How to import data in the Reservation object using a CSV file
Step-by-step guide
First, please remove the following columns: B25__START_DATE__C,B25__END_DATE__C,B25__LOCAL_START_TIME__C,B25__LOCAL_END_TIME__C
These fields will be set automatically when the data is imported.
To get the desired result, you have two options:
1. Keep using B25__STARTLOCAL__C,B25__ENDLOCAL__C like in the file you sent us. In this case make sure to replace the 'Z' in the values with the timezone of the user performing the import. For me that would be '+0200' because I am located in GMT+02:00. I assume for you this should be '+530' or 'IST' (both are accepted).
2. Instead of the local times, use B25__START__C,B25__END__C. In this case make sure to replace the 'Z' in the values with the timezone of the resource of the reservation. For the resource in question that would be '+0530' or 'IST'
If you are in the same timezone as all the targeted resources, it does not matter if you use B25__STARTLOCAL__C,B25__ENDLOCAL__C or B25__START__C,B25__END__C. In either case the values should look like this: '2019-09-03T13:30:00.000IST'