Bulk Loading Customer Data
It is possible to load customer data from an external source into Activation Pro and RLM Cloud. To do this, create a tab-delimited file with all the customer data. Once you have this file, in the Admin → Database tab, you will see Bulk-Load Customer database data at the bottom of the form. Browse to your file, then press Upload File. Your customer data will be loaded.
Warning
Reprise STRONGLY suggests you upload a file with one customer first, so that you can verify your upload data format. If something goes wrong, you can delete this customer and try again.
This file MUST be tab-delimited, and it MUST contain all 26 fields below, in the order below. Only the contact name and email are required to be non-empty:
Data |
Item meaning |
Data type |
---|---|---|
contact |
Contact person name |
string (60) |
contact_type |
Contact type (types defined in the contact_types table) |
string (60) |
title |
Job Title |
string (60) |
phone |
Phone # |
string (20) |
fax |
Fax # |
string (20) |
Email address |
string (60) |
|
notes |
General notes |
string (60) |
company |
Company name |
string (60) |
addr1 |
Address line 1 |
string (60) |
addr2 |
Address line 2 |
string (60) |
addr3 |
Address line 3 |
string (60) |
city |
City |
string (60) |
state |
State |
string (60) |
zip |
Zip/Postal code |
string (60) |
country |
Country |
string (60) |
Notes |
Company notes |
string (255) |
u1 |
Company User-defined |
string (60) |
u2 |
Company User-defined |
string (60) |
u3 |
Company User-defined |
string (60) |
u4 |
Company User-defined |
string (60) |
u5 |
Company User-defined |
string (60) |
u6 |
Company User-defined |
string (60) |
u7 |
Company User-defined |
string (60) |
u8 |
Company User-defined |
string (60) |
u9 |
Company User-defined |
string (60) |
u10 |
Company User-defined |
string (60) |