Overview
A Travel Agent is a business that can be added and utilized in RMS for Reservations, Accounts Receivable, and the Corporate Portal. The Travel Agent import provides a convenient method for transferring all travel agents into RMS.
Â
Import Information
- The import file must be in a comma delimited .csv format, see template attached at the end of this article.
- Microsoft Excel is able to save using a .csv format that should match these requirements.
- The fields within this file must not contain commas.
- RMS is able to determine whether the first record is a header record.
- Country names in the 'Country' field must match the RMS List of Countries.xlsx, see attached list of countries at the end of this article.
Â
Import Field Order
| Order | Field Name | Field Type | Required | Unique | Max Characters | RMS Equivalent |
|---|---|---|---|---|---|---|
1 |
Agent Name | Alpha Numeric | Y | Y | 50 | Short Description |
2 |
Address Line 1 | Alpha Numeric | N | N | 50 | Address Line 1 |
3 |
Address Line 2 | Alpha Numeric | N | N | 50 | Address Line 2 |
4 |
Town/Suburb | Alpha Numeric | N | N | 50 | Town/Suburb |
5 |
State | Alpha Numeric | N | N | 3 | State |
6 |
Postcode | Alpha Numeric | N | N | 15 | Postcode |
7 |
Phone | Alpha Numeric | N | N | 15 | Phone |
8 |
Fax | Alpha Numeric | N | N | 15 | Fax |
9 |
Alpha Numeric | N | N | 100 | ||
10 |
GL Acc Code | Alpha Numeric | N | N | 50 | GL code for Commission |
11 |
Notes | Alpha Numeric | N | N | None | Â |
12 |
Legacy Agent ID | Alpha Numeric | N | N | 20 | Travel Agent Spare1 |
13 |
IATA | Alpha Numeric | N | N | 50 | Â |
14 |
Wholesaler | Yes/No | N | N | 1 | 1 for Wholesaler | Blank or 0 for Travel Agent |
| 15 | Address Line 3 | Alpha Numeric | N | N | 20 | Address Line 3 |
| 16 | Trading As | Alpha Numeric | N | N | 50 | Trading As |
| 17 | Spare 2 | Alpha Numeric | N | N | 50 | Spare 2 |
| 18 | Spare 3 | Alpha Numeric | N | N | 50 | Spare 3 |
| 19 | Spare 4 | Alpha Numeric | N | N | 50 | Spare 4 |
| 20 | Spare 5 | Alpha Numeric | N | N | 50 | Spare 5 |
| 21 | Credit Hold | Yes/No | N | N | 3 | Â |
| 22 | Billing Note | Alpha Numeric | N | N | No Max | Â |
| 23 | External Ref No | Alpha Numeric | N | N | Â N/A | Â |
| 24 | Booking Source | Alpha Numeric | N | N | Â N/A | Â |
| 25 | City Master | Alpha Numeric | N | N | Â N/A | Â |
| 26 | Hide from Guest Portal | Yes/No | N | N | Â N/A | Â |
| 27 | Agent Allotment | Yes/No | N | N | Â N/A | Â |
| 28 | Country | Alpha Numeric | N | N | N/A | See attached RMS List of Countries.xlsx |
| 29 | Status | String | Y | Y | Â | Value = Active or Inactive |
Â
Import Validation
To ensure that your data is clean, consistent, and ready for the Live production environment after it has been validated and imported into the Training environment, follow these steps:
In the side menu of RMS Training, go to Setup > Travel Agent for data review.
- Select the 'Edit' icon aligned with a Travel Agent.
- Review the Travel Agent Name.
- Verify the Travel Agent Address, Phone, Email and any other details included on the import file.
Â
Downloadable Import File
The attached import file below contains the required file format for a travel agent import. Download the file and review the column headers. Populate the file with the travel agent data, ensuring that each field corresponds to the appropriate column.
Â
| Â | > Next Article: |
| Â | Data Validation & Trial Imports |
Â
Â
Comments
0 comments
Please sign in to leave a comment.