Uploading Travel Agents to
RDP From Another System
It is possible to load travel agent information from another system into
RDP. Please call RDP Sales for a quote.
Procedure for Loading Travel Agents
from Another System into RDP
After purchase of the RDP upload program, please follow the procedure:
- The source file must be sent to RDP as an Excel spreadsheet 30 days prior to the start of the installation or
an additional charge will be assessed.
No other formats will be accepted.
- The file should be cleaned up and any incomplete or duplicate records should be eliminated.
If your current software does not have a clean up utility, export the data to the text file or
Excel spreadsheet and then manually go through and delete any duplicates and incomplete records.
- The upload will not work if the exact formats specified below are not used. Please
note that, this procedure requires many hours of expensive programming time. You may have to
hire an outside resource to provide this data, RDP does not extract the data, we simply convert
it and upload it, once the file is complete.
- The following are the typical fields that are converted and the length of each field. If a
field is not used, please leave the field blank with the appropriate number of spaces or leave the
Excel column blank. If a format is listed below, this is the format the source file should use.
If a field cannot be formatted as shown, please inform the RDP sales representative when the file
is submitted.
| Field |
Length |
Format |
| Agent Number |
8 |
|
| Agency Name |
24 |
|
| Address-1 |
24 |
|
| Address-2 |
24 |
|
| City |
16 |
|
| State |
2 |
|
| Zip Code |
10 |
81658-2130 |
| Country |
12 |
|
| Phone-1 |
24 |
970-845-1140 |
| Phone-2 |
12 |
970-845-1140 |
| E-Mail Address |
40 |
|
| Comment-1 |
40 |
|
| Comment-2 |
40 |
|
| Comment-3 |
36 |
|
| Comment-4 |
20 |
|
| Comment-5 |
20 |
|
| Comment-6 |
20 |
|
| Comment-7 |
20 |
|
| Comment-8 |
20 |
|
| Comment-9 |
20 |
|
| Comment-10 |
10 |
|
| Comment-11 |
10 |
|
| Comment-12 |
5 |
|
Travel Agent Notes
Travel Agent notes can also be uploaded, which are free form. A separate fixed-length text file should be submitted with the following
fields. It is critical that the Guest Number field match the correct guest
number field from the file above.
| Field |
Length |
Comment |
| Agent Number |
8 |
Must match Travel agent number from main file |
| Notes |
1-3000 |
|
|
