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:
- 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 an
Excel spreadsheet, and then manually go through and delete any duplicates and incomplete records.
-
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)
-
If owner types are not used, make this field Blank.
-
Timeshare systems: If using floating weeks, don't use
the timeshare arrival & departure date fields.
- 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 |
| 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 |
|