If you’re new to SuperControl and you want to import your guest database into SuperControl follow these steps. The document should be created in Excel which will allow you to save the file in the correct format.
1. Ensure your data is formatted to the exact requirements from the table below.
- The columns should match and be listed in the same order as below.
- The columns must be filled in as much as possible. If any columns are blank you will need to add a blank space.
- You must use a specific data type for the ISO country codes and Subscribed fields. See notes below.
| Field name | Data type | Notes |
|---|---|---|
| Title |
Character |
|
| First name | Character |
|
| Last name | Character |
|
| Email address |
Character |
|
| Address line 1 |
Character |
|
| Address line 2 |
Character |
|
| Town/City |
Character |
|
| County/Region |
Character |
|
| Post code |
Character |
|
| Country |
Two letter ISO country code |
You must use the appropriate "ALPHA 2" ISO country code. Click here to find the correct code. |
| Telephone |
Number | |
| Alt Telephone |
Number | |
| Mobile telephone |
Number | |
| Subscribed | Enter the subscription ID. If multiple subscription options have been ticked, they can be separated by a comma eg. 123, 456 |
You can find your subscription options within "Admin subscription options". If you haven't added these before your import make sure you add them first so you can obtain the ID's required for the import. |
| Your ref |
Character |
|
| Source |
Character |
Example:
Note: You should NOT include the column headings, these are shown in the example for clarity.
2. Once you have your spreadsheet formatted correctly go to File > Save as > From the “Save as type” drop down select Text (Tab delimited) and click Save.
3. In SuperControl go to Database > Import records.
4. Click Choose file and select your Tab delimited file and click Open.
5. Click Upload.
6. Click Proceed with Import.
7. If you don’t receive any errors then you have successfully imported your guest records.