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 Guest History to RDP from another System

Load guest history information from another system into RDP.  Also see Uploading Travel Agent Information

Procedure for Loading Guest History from Another System into RDP

After purchase of the RDP upload program, please follow the procedure below:

  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
Guest Type 1 6
Guest Number 7 6
Last/First Name 13 22 Smith/John
Address-1 35 22
Address-2 57 22
City 79 16
State 95 2
Zip Code 97 10
Home Phone 107 12 970-845-1140
Business Phone 119 12 970-845-1140
Country 131 12
Source of Business Code 143 2
Credit Card Name 145 8
Credit Card Number 153 16
Credit Card Expiration 169 4 YYMM
Email Address 173 40
Housekeeping Comment 213 20
Comment-2 233 12
Comment-3 245 12
Comment-4 257 20
Comment-5 277 20
Comment-6 297 20
Comment-7 317 20
Comment-8 337 20
Comment-9 357 20
Total columns for 1 record in a fixed-length text file: 377.

Guest History Notes

Guest History 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
Guest Number 1 6
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