Exports

What is an Export?

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

How to get an Export

Once you are happy with your search query and results, you can either:

  1. Click the Export button in the top right hand of the page

OR

  1. Select the records you are looking for (if your search result is not specific enough)

  2. Click the Export button in the top right hand of the page

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.

What will appear in your Export

Trips

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)

Bookings

Columns that appear in the CSV file:

  • ID

  • Date Created

  • Contact Full Name

  • Code

  • Status

  • 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

  • Brand

  • Hotel (this column will be duplicated for as many Hotels as are on the Trip record)

  • Gateway (this column will be duplicated for as many Gateways as are on the Trip record)

  • Departure Date

  • 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

  • Trip Planner (this column will be duplicated for as many Trip Planners as are on the Trip record)

  • Balance Date

  • 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)

Contacts

Columns that appear in the CSV file:

  • ID

  • Date Created

  • 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

  • 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

  • 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

Columns that appear in the CSV file:

  • ID

  • Date Created

  • Name

  • Type

  • Mandatory Status

  • Brand

  • Year

  • Destination

  • Hotel

  • Program Period

  • Travel Week

  • Status

  • Supplier Name

  • Contract Date

  • File Number

  • Locator

  • Cost Currency

  • Price Currency

  • Contacts Full Name

  • Total Bookings

  • Total Travelling Bookings

  • Total Rooms

  • Total Rooms Used

  • Total Rooms Available

  • Total Cost

Columns that appear in the CSV file:

  • ID

  • Date Created

  • Created By

  • Type

  • Transaction Number

  • Status

  • Amount

  • Amount Allocated to Inventory

  • Currency

  • Form of Payment

  • Card Type

  • Transaction Date

  • Cleared Date

  • Gateway Info

  • Contact Full Name

  • Booking Code

  • Inventory Name

  • Trip Name

  • Booking Status

  • Active Credit Card

  • Auto Charge Credit Card