Guide on how to bulk import travel bookings for administrators using a spreadsheet file import. This is helpful where there is a high volume of travel bookings which will be difficult to add individually
- Navigate to the Administration Area from Map View
- Click on "Itineraries" link
- Click on "+ Import" button
- Review the list of import templates shown which are accepted in the platform, then:
- Copy the required template in Excel
- Enter the travel booking fields accordingly in the same order
- You must follow the formatting example in the templates exactly
- ie Departure date is YYYYMMDD and Departure time is HHMM
- Save the template as a CSV file
- Then drag and drop or "choose file" to import the travel bookings file
- Green - full import has been successful
- Red - something has gone wrongThe progress line will show:
It is Recommended to always check a couple booking references after an import is successfully completed to ensure all has been imported correctly into the platform.
Red Import Fail:
- There may be something obviously wrong on the import file in the formatting, the system may inform you which cell/field is reporting the error. Review the import file and check for any instances where the format may be incorrect.
- If you do not know the cause of the failed import, contact the Solace Support team and send through securely the travel booking file you wish to import. We must receive the original file in order to diagnose the problem.