Home RDP Sales Contact Us Training  
RDP Support  

     Open a Web Support Ticket
RDPWin
Knowledge Base		 RDP-DOS
Knowledge Base		 IRM and IRM.Net
Knowledge Base		 Crystal
Knowledge Base
         

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:

  1. The source file must be sent to RDP 30 days prior to the start of the installation or an additional charge will be assessed.
  2. The source file must be a text file with 1 record per line or an Excel spreadsheet. No other formats will be accepted.
  3. 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.
  4. If a text file is submitted, the fields should be in fixed-length format.
  5. 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.
  6. 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 Starting Column Length Format
Travel Agent  Number  1  8
Agency Name 9 24
Address-1  33 24
Address-2 57 24
City 81 16
State 97 2
Zip Code 99 10 81658-2130
Country 109 12
Phone-1 121 24 970-845-1140
Phone-2 145 12 970-845-1140
E-Mail Address 169 40
Comment-1 209 40
Comment-2 249 40
Comment-3 289 36
Comment-4 325 20
Comment-5 345 20
Comment-6 365 20
Comment-7 385 20
Comment-8 405 20
Comment-9 425 20
Comment-10 445 10
Comment-11 455 10
Comment-12 465 5
Total columns for 1 record in a fixed-length text file: 470

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 Starting Column Length Comment
Travel Agent Number 1 8 Must match Travel agent number from main file
Notes 7 3000 Max

Home RDPWin RDP-DOS IRM/IRM.Net Open A  Web Support Ticket
Version 2.xxx Upgrade to RDPWin Link to Marketing Site Contact Us
Training Vendor Interfaces Troubleshooting RDP Sales Website