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 file. The fields should be in the order below
and the length of each field is also listed. If some fields are not used, leave this field blank with the appropriate spaces.
Note: For timeshare system, contact
RDP Support for details on the upload procedures.
After purchase of the RDP upload program, 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.
- Cleaned up the file to remove any incomplete or duplicate records. If your
current software does not have a clean up utility, export the data to an Excel
spreadsheet, and then manually 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 the owner number is 3-digits, this field can be
"001 " (001 and 5 spaces).
-
If owner types are not used, make this field Blank.
- The upload will not work if the exact formats specified below are not used. Note:
this procedure requires many hours of 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.
- If a field is not used, 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 |
| Notes |
3000 or less |
| |
|