An export is a CSV file, received by email, of a specific search query. For more details on how to use search, click here.
Only the following record types can be exported: Trips Bookings Contacts Inventories Transactions
Only the following record types can be exported:
Trips
Bookings
Contacts
Inventories
Transactions
Once you are happy with your search query and results, you can either:
Click the Export button in the top right hand of the page
OR
Select the records you are looking for (if your search result is not specific enough)
The results will be emailed to you in a CSV.
If you have multiple Groupdesk logins, the export will be sent to the email associated with the account you used for the search.
You only need to click ‘Export’ once. If you are exporting a very large amount of data (ie: thousands of lines) you may need to wait a few minutes for your export to appear. You can check the status of your export in the Bulk Jobs page of Groupdesk.
Exporting too many records at once may result in your export not being processed by Groupdesk. For best results, please limit exports to a maximum of 2,000 booking records or 5,000 for the rest of the record types.
Columns that appear in the CSV file:
ID
Date Created
Name
Code
Status
Account (this column will be duplicated for as many Accounts as are on the Trip record)
Gateway (this column will be duplicated for as many Gateways as are on the Trip record)
Trip Planner (this column will be duplicated for as many Trip Planners as are on the Trip record)
Brand
Destination (this column will be duplicated for as many Destinations as are on the Trip record)
Hotel (this column will be duplicated for as many Hotels as are on the Trip record)
Departure Date
Travel Week
Program Period
Balance Date
Total Bookings
Traveling Bookings
Active / New Joiner / Completed Bookings
Overdue Bookings
Waitlist Bookings
No Show Bookings
Pending / Cancelled / Default / Unconfirmed Bookings
Total Rooms Used
Account Travel Region (this column will be duplicated for as many Accounts as are on the Trip record)
Contact Full Name
Contact Email
Contact Phone (this column will be duplicated for as many phone numbers as are on the Contact record)
Contact Date of Birth
Contact Address
Student Number
Trip Name
Trip Code
Trip Year
Types
Med Sent
Comp Sent
Deluxe Sent
Premium Sent
Insurance Purchase Date
Insurance Inventory Name
Room Type
Occupancy
Referred By
Referred By Email
Room Number
Trip Currency
Total Base Price
Total Travel Taxes
Total Add-Ons Price
Total Insurance Price
Total Bookings Discounts
Discounts Descriptions
Total Bookings Fees
Fees Descriptions
Total Price
Total Paid
Current Due
Balance Due
Active Credit Card
Auto Charge Credit Card
Passport Surname
Passport Given Name
Passport Number
Passport Nationality
Passport Date of Birth
Passport Place of Birth
Passport Expiry
Passport Issuing Authority
Passport Date of Issue
Emergency Contact Full Name (this column will be duplicated for as many Emergency Contacts as are on the Contact record)
Emergency Contact Email (this column will be duplicated for as many Emergency Contacts as are on the Contact record)
Emergency Contact Phone (this column will be duplicated for as many Emergency Contacts as are on the Contact record)
Parent Full Name (this column will be duplicated for as many Parent Contacts as are on the Contact record)
Parent Email (this column will be duplicated for as many Parent Contacts as are on the Contact record)
Parent Phone (this column will be duplicated for as many Parent Contacts as are on the Contact record)
Full Name
Date of Birth
Address
Email
Phone (this column will be duplicated for as many Phone numbers as are on the Contact record)
Account
Trips (this column will be duplicated for as many Trips as are on the Contact record)
Type
Related Contact Full Name (this column will be duplicated for as many Related Contacts as are on the Contact record)
Related Contact Type (this column will be duplicated for as many Related Contacts as are on the Contact record)
Related Contact Phone (this column will be duplicated for as many Related Contacts as are on the Contact record)
Related Contact Email (this column will be duplicated for as many Related Contacts as are on the Contact record)
Medical Information
Mandatory Status
Year
Destination
Hotel
Supplier Name
Contract Date
File Number
Locator
Cost Currency
Price Currency
Contacts Full Name
Total Travelling Bookings
Total Rooms
Total Rooms Available
Total Cost
Created By
Transaction Number
Amount
Amount Allocated to Inventory
Currency
Form of Payment
Card Type
Transaction Date
Cleared Date
Gateway Info
Booking Code
Inventory Name
Booking Status
Cheque Identifier