> Support > Database Marketing > Migrating address fields

Migrating address fields


To use the new Print Card Campaigns you will have to use the Address field. If you already have addresses in your database as separate fields e.g. a field for Street, City, Suburb. Follow the steps below to migrate those fields to the address custom field.

  1. Go to Database Marketing > Contacts > Contact List. Select the "Export" button and select the fields; First Name, Email and your current address fields e.g. Street, City etc
  2. Create an Address Custom field if you haven't already via Settings > Contact Database > Custom Fields > Add Field. Ensure the Input Type: "Address".
  3. Download your csv export onto your computer via clicking the name of the file after the "Please click to Download File:" You will see this in the top of your webconsole.
  4. Go to Contacts > Import Contacts. Choose this CSV as the "File to Import". Choose the Delimiters to be "Comma", Choose Update Duplicates to "Yes" then proceed next.
  5. Map up your columns in the CSV to the fields in your database. You will see the "Address" field you have is split up into the relevant sections (Address Line 1, Address Line 2, City, State, Postcode, Country). Please see the address below as an example. Remember Address Line 2 is optional.
  6. Check back through your Contact List to ensure all the data has been carried across into the new address field.
  7. Delete the old address fields.

Address Example:

  1. Address Line 1 -> 25 ADELAIDE ST
  2. Address Line 2 (optional) -> Building D
  3. City -> BRISBANE
  4. State -> QLD
  5. Postcode -> 4000
  6. Country -> AUSTRALIA


You may also be interested in...

Was this information helpful?
Rating:  
12345 
Sign up to our mailing list
 
Qantas Business Rewards | Snap Print and Design

Earn 1 Qantas Point for every $1 spend at your local Snap Centre. Find out more

Platinum Partners

Platinum Partner | Snap Print and Design

Silver Partners

Silver Partner | Snap Print and DesignSilver Partner | Snap Print and Design