Home > Importing Data > Travel Agent Import

Travel Agent Import

Overview

This file allows the import of Travel Agent records from a standard Comma Delimited file into the RMS system.

 

You must be able to provide a CSV file in the format as indicated below. It may be necessary to seek technical advice in order to create your file in the format that RMS requires.

 

Sample File - Pending

Important InformationEdit section

  • The file to be imported must be in a comma delimited CSV format (Field Delimiter).
  • If a data field within this file contain commas, it should be surrounded with "double quotes" (Text Delimiter).
  • Line returns should be replaced with the pipe character '|'. (Usually found on the backslash key).
  • Microsoft Excel is able to save using a CSV format that should match these requirements.
  • RMS is able to determine whether the first record is a header record or not, thus it is not necessary to strip the header record (field names) prior to the import
  • Legacy Agent ID's are saved to Travel Agent Spare Field 1 and used by subsequent imports to look up reservations.

Field Order - All fields must not contain commasEdit section

Order Field Name Field Type Required Unique Max Characters RMS Equivalent

1

 Agent Name Alpha Numeric Y Y 100 Travel Agent
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
5 State Alpha Numeric N N 3 State
6 Postcode Alpha Numeric N N 10 Postcode
7 Phone Alpha Numeric N N 25 Phone
8 Fax Alpha Numeric N N 25 Fax
9 Email Alpha Numeric N N 100 Email
10 GL Acc Code Alpha Numeric N N 30 G/L Acc Code
11 Notes Alpha Numeric N N 4000 Notes
12 Spare1 Alpha Numeric N N 50 Agent Spare 1

 

You must to post a comment.
Last modified
17:29, 15 Jul 2015

Tags

Classifications

This page has no classifications.
For support assistance with this article, click once on the Live Support image below
 
btn_LS_on.png
Powered by MindTouch ®