Contact Support


    Travel Agent Import

    Information on the requirements for the Travel Agent Import available in RMS.

    Import Information

    • The file to be imported must be in a comma delimited .csv format.
    • 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.


    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

    Email

    Alpha Numeric

    N

    N

    100

    Email

    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 RMS List of Countries.xlsx
    29
    Status
    String
    Y
    Y

    Value = Active or Inactive


    Sample File

    Travel Agent Import.csv

    Was this article helpful?

    Send Feedback

    Can’t find what you’re looking for?

    Contact Support