Home Software Sales Crystal KB Contact Us
RDP Support  


RDPWin KB IRM.Net RDPWin3 & PCI Compliance Search

Uploading Owners to RDP
From Another System

Load owner information from another system into RDP.   Please call RDP Sales for a quote.

Procedure for Loading Owners
from Another System into RDP

Resort Data Processing will convert existing owner databases.  The source file must be an Excel or ASCII file in fixed field format.  Each record should be terminated with a Carriage Return and Line Feed.  The fields should be in the order below and the length of each field is also listed.  If some fields are not used, please leave this field blank with the appropriate spaces.

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

  1. 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.
  2. 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 an Excel spreadsheet, and then manually go through and delete any duplicates and incomplete records.
  3. If a numeric owner number is used, left zero fill the number.  It is not necessary to zero fill all eight characters.  For example, if you have 3-digit owner numbers, this field can be "001     ". (001 and 5 spaces)
  4. If owner types are not used, make this field Blank.
  5. Timeshare systems:  If using floating weeks, don't use the timeshare arrival & departure date fields.
  6. 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.
  7. 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
Owner Type * 6
Owner Number 8
Last/First Name 24      Format: Smith/John
Address-1 24
Address-2 24
City 16
State 2
Zip Code 10
Country 12
Spouse Name 24
Phone-1 12      Format: 303-476-9244
Phone-2 12
Room Number 8
TimeShare: Arrival Date 6       Format: 940421
TimeShare: Departure 6       Format: 940421
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
Email Address 40
 

Owner Notes

Owner 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 Owner Number field match the correct owner number field from the file above.

Field Length
Owner Number 6
Notes 3000 or less
Support Home  RDPWin3 & PCI Compliance Enhancement Requests Open A Web Support Ticket
Training 3rd Party Interfaces RDP Sales Website Contact Us

 Facebook     Twitter      LinkedIn   TODF