Help CentreUsing SuperControl ImportingHow can I import all my guest details into SuperControl?

How can I import all my guest details into SuperControl?

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
Booleen 1/0
If a person has subscribed to receive mailings enter 1. If they should not receive mailings select 0.
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.

2 Comments

J SPRECKLEY

Please give an excel spreadsheet example, as the data could not be presented in a vertical column. Surly this is a horizontal line of column?

Rosie Georgeson

Hi there,

The fields names above would be column headers in an excel spreadsheet. I have included a screen shot in the above article to allow you to see the layout.

Kind regards
Rosie

How can we make this page better for you?

E-Mail me when someone replies to this comment