Import contacts

To import contacts into your Marketing section you have to prepare a .CSV document. To prepare a .CSV document one must open spreadsheet document (Example: Excel), where you type in all your contacts and their details. Each information about the contact must be written in its own column. Certain personalized information about your contacts will have to be added to your marketing section as new attributes and those have to be prepared in advance.
To prepare customer’s attributes, please read Attributes in the Marketing section or see the tutorial.

Important

Each contact in your .csv file should contain at least one unique identifier. Identifiers that are checked by the system are ID numbers, CODES, and DEFAULT EMAIL addresses.

• During your first import, an ID number will be automatically assigned to each imported contact. After that, you can use that same ID number for any updates.
• CODE can be assigned to contacts either manually or automatically.
• DEFAULT EMAIL address is the third and the most common identifier which is assigned to each contact manually.

After the import, you can see the ID number and code by clicking the View button in your contacts list.

Before the first import, we suggest you prepare a file with all the contact information. If you decide to prepare import files with codes and emails, make sure, each contact gets a unique and only one time used code. If you only decide to use emails, then all the codes and IDs will be given to contacts automatically.

Warning!

Every import of new contacts will override already existing contacts if one of the three unique identifiers will match the already existing one.
Example: If your contacts list already includes a contact with CODE number 101, and you prepare a new import file that also contains CODE number 101, then the latest import will override the already existing one. This way you can lose already existing contacts.

OUR ADVICE

Our advice is to import contacts with Codes and emails and let the system give them automated ID numbers. Once the amount of contacts grows, you can always export them, arrange them by identifiers (either codes or IDs) and edit them or add new ones and then import them back.

IMPORTING CONTACTS WITH MULTIPLE CONTACT DETAILS

When importing contacts with multiple contact information of the same type (Example: contact with more than one email address), you must first import those contacts with only one contact information of the same type. After contacts are imported, you can manually add the other information of the same type.
If you wish to import more contact info with the importer, then you must identify the contact by the code and add the new contact info in the .csv file. The system will add the contact info to the existing one.

IMPORTING CONTACTS WITH ADDRESSES

When it comes to importing contacts with addresses, make sure you put each info in a separate column and ALWAYS add all the required info: FIRST NAME, LAST NAME, EMAIL, STREET, STREET/HOUSE NUMBER, POSTAL CODE, CITY/TOWN, AND COUNTRY. Without all this information the import will fail.

IMPORTING SHOP USERS

When importing shop users you need to import them with an address. You have the option to set both the shipping and the billing address.

To create an import document (CSV) with ease, we have prepared a table of content you can import when adding contacts to DG1 marketing to facilitate the process of importing contacts.

*

BASIC
ID	The ID number is a unique number of the contact. At the first import, the ID must NOT be written, but it must be added to your .csv when UPDATING the import.
Code	The code will be generated automatically.
First name	Mandatory field. Use any letters. Example: John
Middle name	Optional. Use any letters. Example: Paul
Last name	Use any letters. Example: Fitzgerald
Full name	Use any letters and put a space between the first, middle, and last name. Example: John Paul Fitzgerald
Username	This can be created automatically or you can write your own. Note that the username must be written as one word.
Gender	Write the gender with a word. Example: Male
Date of birth (YYYY-MM-DD) Date of birth (DD.MM.YYYY) Date of birth (MM/DD/YYYY)	Write the date in one of the following three date formats: Example: 1981-06-22 Example: 22.06.1981 Example: 06/22/1981
CONTACTS
Default E-mail *	Mandatory field. This email will be used as the customer’s default email address. Write emails only in the email format. Example: john@mydomian.com
Default Telephone	This number will be set as the customer’s default telephone number. Use numbers only. Example: 123456798
Default Mobile	This number will be set as the customer’s default mobile number. Use numbers only. Example: 3562564
E-mail	Write emails only in the email format. Example: john@mydomian.com
Country calling code	Do not use the + sign. Only use the number of the country’s calling code. Example: 44
Telephone	Use numbers only. Example: 1 123456798
Mobile	Use numbers only. Example: 41 3562564
SHIPPING ADDRESSES (MAIN ADDRESS)	When you’re only adding customers, this address will be used as their main address. If you are importing shop users, this address will be used as their shipping address. Note! When adding the address of your contacts, you must add all the information marked with * but there are several options on how to add certain data.
First name (Shipping)	Use any letters. Example: John You can set a different first name for the shipping address.
Last name (Shipping)	Use any letters. Example: Paul You can set a different last name for the shipping address.
Telephone(Shipping)	Use numbers only. Example: 3562564 This telephone number will be used for the shipping address.
Country calling code (Shipping)	Do not use the + sign. Only use the number of the country’s calling code. Example: 44 This country calling code will be used for shipping address only.
Use either! Street with No. (Shipping) * OR Street (Shipping) * Street No. (Shipping) *	Use only one option. Add the street with number. Example: Kensington avenue 101 OR Use letters only. Example: Kensington avenue Use numbers or numbers and letters. Example: 303
Unit No. (Shipping)	Write the number or the name of the apartment, suite, etc.
Use either! Town/City (Shipping) * Postal code (Shipping) * OR Town with postal code (Shipping) * OR Postal code with town (Shipping) *	Use only one option. Write the name of the town or the city in a separate column. Example: London Use capital letters and/or numbers only and write the postal code in a separate column. Example: W2 3XA OR Write both the name of the town and the postal code in one column. Example: London SW1A 2AA. OR Write the postal code followed by the name of the town or the city in one column.
Country (Shipping) *	You must write the name of the country according to the ISO standards. Click Country ISO codes ✕ Name ISO2 ISO3 Slovenia SI SVN Afghanistan AF AFG Åland Islands AX ALA Albania AL ALB Algeria DZ DZA American Samoa AS ASM Andorra AD AND Angola AO AGO Anguilla AI AIA Antarctica AQ ATA Antigua & Barbuda AG ATG Argentina AR ARG Armenia AM ARM Aruba AW ABW Australia AU AUS Austria AT AUT Azerbaijan AZ AZE Bahamas BS BHS Bahrain BH BHR Bangladesh BD BGD Barbados BB BRB Belarus BY BLR Belgium BE BEL Belize BZ BLZ Benin BJ BEN Bermuda BM BMU Bhutan BT BTN Bolivia BO BOL Caribbean Netherlands BQ BES Bosnia & Herzegovina BA BIH Botswana BW BWA Bouvet Island BV BVT Brazil BR BRA British Indian Ocean Territory IO IOT Brunei BN BRN Bulgaria BG BGR Burkina Faso BF BFA Burundi BI BDI Cape Verde CV CPV Cambodia KH KHM Cameroon CM CMR Canada CA CAN Cayman Islands KY CYM Central African Republic CF CAF Chad TD TCD Chile CL CHL China CN CHN Christmas Island CX CXR Cocos (Keeling) Islands CC CCK Colombia CO COL Comoros KM COM Congo - Kinshasa CD COD Congo - Brazzaville CG COG Cook Islands CK COK Costa Rica CR CRI Côte d’Ivoire CI CIV Croatia HR HRV Cuba CU CUB Curaçao CW CUW Cyprus CY CYP Czech Republic CZ CZE Denmark DK DNK Djibouti DJ DJI Dominica DM DMA Dominican Republic DO DOM Ecuador EC ECU Egypt EG EGY El Salvador SV SLV Equatorial Guinea GQ GNQ Eritrea ER ERI Estonia EE EST Ethiopia ET ETH Falkland Islands FK FLK Faroe Islands FO FRO Fiji FJ FJI Finland FI FIN France FR FRA French Guiana GF GUF French Polynesia PF PYF French Southern Territories TF ATF Gabon GA GAB Gambia GM GMB Georgia GE GEO Germany DE DEU Ghana GH GHA Gibraltar GI GIB Greece GR GRC Greenland GL GRL Grenada GD GRD Guadeloupe GP GLP Guam GU GUM Guatemala GT GTM Guernsey GG GGY Guinea GN GIN Guinea-Bissau GW GNB Guyana GY GUY Haiti HT HTI Heard & McDonald Islands HM HMD Vatican City VA VAT Honduras HN HND Hong Kong SAR China HK HKG Hungary HU HUN Iceland IS ISL India IN IND Indonesia ID IDN Iran IR IRN Iraq IQ IRQ Ireland IE IRL Isle of Man IM IMN Israel IL ISR Italy IT ITA Jamaica JM JAM Japan JP JPN Jersey JE JEY Jordan JO JOR Kazakhstan KZ KAZ Kenya KE KEN Kiribati KI KIR North Korea KP PRK South Korea KR KOR Kuwait KW KWT Kyrgyzstan KG KGZ Laos LA LAO Latvia LV LVA Lebanon LB LBN Lesotho LS LSO Liberia LR LBR Libya LY LBY Liechtenstein LI LIE Lithuania LT LTU Luxembourg LU LUX Macau SAR China MO MAC Macedonia MK MKD Madagascar MG MDG Malawi MW MWI Malaysia MY MYS Maldives MV MDV Mali ML MLI Malta MT MLT Marshall Islands MH MHL Martinique MQ MTQ Mauritania MR MRT Mauritius MU MUS Mayotte YT MYT Mexico MX MEX Micronesia FM FSM Moldova MD MDA Monaco MC MCO Mongolia MN MNG Montenegro ME MNE Montserrat MS MSR Morocco MA MAR Mozambique MZ MOZ Myanmar (Burma) MM MMR Namibia NA NAM Nauru NR NRU Nepal NP NPL Netherlands NL NLD New Caledonia NC NCL New Zealand NZ NZL Nicaragua NI NIC Niger NE NER Nigeria NG NGA Niue NU NIU Norfolk Island NF NFK Northern Mariana Islands MP MNP Norway NO NOR Oman OM OMN Pakistan PK PAK Palau PW PLW Palestinian Territories PS PSE Panama PA PAN Papua New Guinea PG PNG Paraguay PY PRY Peru PE PER Philippines PH PHL Pitcairn Islands PN PCN Poland PL POL Portugal PT PRT Puerto Rico PR PRI Qatar QA QAT Réunion RE REU Romania RO ROU Russia RU RUS Rwanda RW RWA St. Barthélemy BL BLM St. Helena SH SHN St. Kitts & Nevis KN KNA St. Lucia LC LCA St. Martin MF MAF St. Pierre & Miquelon PM SPM St. Vincent & Grenadines VC VCT Samoa WS WSM San Marino SM SMR São Tomé & Príncipe ST STP Saudi Arabia SA SAU Senegal SN SEN Serbia RS SRB Seychelles SC SYC Sierra Leone SL SLE Singapore SG SGP Saint Martin SX SXM Slovakia SK SVK Solomon Islands SB SLB Somalia SO SOM South Africa ZA ZAF South Georgia & South Sandwich Islands GS SGS South Sudan SS SSD Spain ES ESP Sri Lanka LK LKA Sudan SD SDN Suriname SR SUR Svalbard & Jan Mayen SJ SJM Swaziland SZ SWZ Sweden SE SWE Switzerland CH CHE Syria SY SYR Taiwan TW TWN Tajikistan TJ TJK Tanzania TZ TZA Thailand TH THA Timor-Leste TL TLS Togo TG TGO Tokelau TK TKL Tonga TO TON Trinidad & Tobago TT TTO Tunisia TN TUN Turkey TR TUR Turkmenistan TM TKM Turks & Caicos Islands TC TCA Tuvalu TV TUV Uganda UG UGA Ukraine UA UKR United Arab Emirates AE ARE United Kingdom GB GBR U.S. Outlying Islands UM UMI United States of America US USA Uruguay UY URY Uzbekistan UZ UZB Vanuatu VU VUT Venezuela VE VEN Vietnam VN VNM British Virgin Islands VG VGB U.S. Virgin Islands VI VIR Wallis & Futuna WF WLF Western Sahara EH ESH Yemen YE YEM Zambia ZM ZMB Zimbabwe ZW ZWE here to find the correct representation of the country.
Country State (Shipping) *	The state must be written according to ISO 3166-2 Code format or simply with a name. USA States ✕ Name Code Alabama AL Alaska AK Arizona AZ Arkansas AR California CA Colorado CO Connecticut CT Delaware DE District of Columbia DC Florida FL Georgia GA Hawaii HI Idaho ID Illinois IL Indiana IN Iowa IA Kansas KS Kentucky KY Louisiana LA Maine ME Maryland MD Massachusetts MA Michigan MI Minnesota MN Mississippi MS Missouri MO Montana MT Nebraska NE Nevada NV New Hampshire NH New Jersey NJ New Mexico NM New York NY North Carolina NC North Dakota ND Ohio OH Oklahoma OK Oregon OR Pennsylvania PA Puerto Rico PR Rhode Island RI South Carolina SC South Dakota SD Tennessee TN Texas TX Utah UT Vermont VT Virginia VA Washington WA West Virginia WV Wisconsin WI Wyoming WY Example for the United States Canada Provinces ✕ Name Code Alberta AB British Columbia BC Labrador LB Manitoba MB New Brunswick NB Newfoundland NF Nova Scotia NS Nunavut NU North West Territory NT Ontario ON Prince Edward Islands PE Quebec QC Saskatchewen SK Yukon YT Example for Canada Provinces of Italy ✕ Name Code Agrigento AG Alessandria AL Ancona AN Arezzo AR Ascoli Piceno AP Asti AT Avellino AV Bari BA Barletta-Andria-Trani BT Belluno BL Benevento BN Bergamo BG Biella BI Bologna BO Bolzano/Bozen BZ Brescia BS Brindisi BR Cagliari CA Caltanissetta CL Campobasso CB Carbonia-Iglesias CI Caserta CE Catania CT Catanzaro CZ Chieti CH Como CO Cosenza CS Cremona CR Crotone KR Cuneo CN Enna EN Fermo FM Ferrara FE Firenze FI Foggia FG Forlì-Cesena FC Frosinone FR Genova GE Gorizia GO Grosseto GR Imperia IM Isernia IS L'Aquila AQ La Spezia SP Latina LT Lecce LE Lecco LC Livorno LI Lodi LO Lucca LU Macerata MC Mantova MN Massa-Carrara MS Matera MT Medio Campidano VS Messina ME Milano MI Modena MO Monza e della Brianza MB Napoli NA Novara NO Nuoro NU Ogliastra OG Olbia-Tempio OT Oristano OR Padova PD Palermo PA Parma PR Pavia PV Perugia PG Pesaro e Urbino PU Pescara PE Piacenza PC Pisa PI Pistoia PT Pordenone PN Potenza PZ Prato PO Ragusa RG Ravenna RA Reggio di Calabria RC Reggio nell'Emilia RE Rieti RI Rimini RN Roma RM Rovigo RO Salerno SA Sassari SS Savona SV Siena SI Siracusa SR Sondrio SO Taranto TA Teramo TE Terni TR Torino TO Trapani TP Trento TN Treviso TV Trieste TS Udine UD Valle d'Aosta/Vallée d'Aoste AO Varese VA Venezia VE Verbano-Cusio-Ossola VB Vercelli VC Verona VR Vibo Valentia VV Vicenza VI Viterbo VT Example for Italy Cantons of Switzerland ✕ Name Code Uri UR Svitto SZ Obvaldo OW Nidvaldo NW Lucerna LU Zurigo ZH Glarona GL Zugo ZG Berna BE Friburgo FR Soletta SO Basilea Città BS Basilea Campagna BL Sciaffusa SH Appenzello Esterno AR Appenzello Interno AI San Gallo SG Grigioni GR Argovia AG Turgovia TG Ticino TI Vaud VD Vallese VS Neuchâtel NE Ginevra GE Giura JU Example for Switzerland Prefectures of Japan ✕ Name Code 北海道 1 青森県 2 岩手県 3 宮城県 4 秋田県 5 山形県 6 福島県 7 茨城県 8 栃木県 9 群馬県 10 埼玉県 11 千葉県 12 東京都 13 神奈川県 14 新潟県 15 富山県 16 石川県 17 福井県 18 山梨県 19 長野県 20 岐阜県 21 静岡県 22 愛知県 23 三重県 24 滋賀県 25 京都府 26 大阪府 27 兵庫県 28 奈良県 29 和歌山県 30 鳥取県 31 島根県 32 岡山県 33 広島県 34 山口県 35 徳島県 36 香川県 37 愛媛県 38 高知県 39 福岡県 40 佐賀県 41 長崎県 42 熊本県 43 大分県 44 宮崎県 45 鹿児島県 46 沖縄県 47 Example for Japan States of Malaysia ✕ Name Code Johor MY-01 Kedah MY-02 Kelantan MY-03 Melaka MY-04 Negeri Sembilan MY-05 Pahang MY-06 Perak MY-08 Perlis MY-09 Pulau Pinang MY-07 Sabah MY-12 Sarawak MY-13 Selangor MY-10 Terengganu MY-11 Wilayah Persekutuan Kuala Lumpur MY-14 Wilayah Persekutuan Labuan MY-15 Wilayah Persekutuan Putrajaya MY-16 Example for Malaysia
BILLING ADDRESSES (MAIN ADDRESS)	This address will be used as the billing address when importing shop users. When you’re only importing marketing customers, this address should not be used. Note! When adding the address of your contacts, you must add all the information marked with * but there are several options on how to add certain data.
First name (Billing)	Use any letters. Example: John You can set a different first name for the billing address.
Last name (Billing)	Use any letters. Example: Paul You can set a different last name for the billing address.
Telephone(Billing)	Use numbers only. Example: 3562564 This telephone number will be used for the billing address.
Country calling code (Billing)	Do not use the + sign. Only use the number of the country’s calling code. Example: 44 This country calling code will be used for billing address only.
Use either! Street with No. (Billing) * OR Street (Billing) * Street No. (Billing) *	Use only one option. Add the street with number. Example: Kensington avenue 101 OR Use letters only. Example: Kensington avenue Use numbers or numbers and letters. Example: 303
Unit No. (Billing)	Write the number or the name of the apartment, suite, etc.
Use either! Town/City (Billing) * Postal code (Billing) * OR Town with postal code (Billing) * OR Postal code with town (Billing) *	Use only one option. Write the name of the town or the city in a separate column. Example: London Use capital letters and/or numbers only and write the postal code in a separate column. Example: W2 3XA OR Write both the name of the town and the postal code in one column. Example: London SW1A 2AA. OR Write the postal code followed by the name of the town or the city in one column.
Country (Billing) *	You must write the name of the country according to the ISO standards. Click Country ISO codes ✕ Name ISO2 ISO3 Slovenia SI SVN Afghanistan AF AFG Åland Islands AX ALA Albania AL ALB Algeria DZ DZA American Samoa AS ASM Andorra AD AND Angola AO AGO Anguilla AI AIA Antarctica AQ ATA Antigua & Barbuda AG ATG Argentina AR ARG Armenia AM ARM Aruba AW ABW Australia AU AUS Austria AT AUT Azerbaijan AZ AZE Bahamas BS BHS Bahrain BH BHR Bangladesh BD BGD Barbados BB BRB Belarus BY BLR Belgium BE BEL Belize BZ BLZ Benin BJ BEN Bermuda BM BMU Bhutan BT BTN Bolivia BO BOL Caribbean Netherlands BQ BES Bosnia & Herzegovina BA BIH Botswana BW BWA Bouvet Island BV BVT Brazil BR BRA British Indian Ocean Territory IO IOT Brunei BN BRN Bulgaria BG BGR Burkina Faso BF BFA Burundi BI BDI Cape Verde CV CPV Cambodia KH KHM Cameroon CM CMR Canada CA CAN Cayman Islands KY CYM Central African Republic CF CAF Chad TD TCD Chile CL CHL China CN CHN Christmas Island CX CXR Cocos (Keeling) Islands CC CCK Colombia CO COL Comoros KM COM Congo - Kinshasa CD COD Congo - Brazzaville CG COG Cook Islands CK COK Costa Rica CR CRI Côte d’Ivoire CI CIV Croatia HR HRV Cuba CU CUB Curaçao CW CUW Cyprus CY CYP Czech Republic CZ CZE Denmark DK DNK Djibouti DJ DJI Dominica DM DMA Dominican Republic DO DOM Ecuador EC ECU Egypt EG EGY El Salvador SV SLV Equatorial Guinea GQ GNQ Eritrea ER ERI Estonia EE EST Ethiopia ET ETH Falkland Islands FK FLK Faroe Islands FO FRO Fiji FJ FJI Finland FI FIN France FR FRA French Guiana GF GUF French Polynesia PF PYF French Southern Territories TF ATF Gabon GA GAB Gambia GM GMB Georgia GE GEO Germany DE DEU Ghana GH GHA Gibraltar GI GIB Greece GR GRC Greenland GL GRL Grenada GD GRD Guadeloupe GP GLP Guam GU GUM Guatemala GT GTM Guernsey GG GGY Guinea GN GIN Guinea-Bissau GW GNB Guyana GY GUY Haiti HT HTI Heard & McDonald Islands HM HMD Vatican City VA VAT Honduras HN HND Hong Kong SAR China HK HKG Hungary HU HUN Iceland IS ISL India IN IND Indonesia ID IDN Iran IR IRN Iraq IQ IRQ Ireland IE IRL Isle of Man IM IMN Israel IL ISR Italy IT ITA Jamaica JM JAM Japan JP JPN Jersey JE JEY Jordan JO JOR Kazakhstan KZ KAZ Kenya KE KEN Kiribati KI KIR North Korea KP PRK South Korea KR KOR Kuwait KW KWT Kyrgyzstan KG KGZ Laos LA LAO Latvia LV LVA Lebanon LB LBN Lesotho LS LSO Liberia LR LBR Libya LY LBY Liechtenstein LI LIE Lithuania LT LTU Luxembourg LU LUX Macau SAR China MO MAC Macedonia MK MKD Madagascar MG MDG Malawi MW MWI Malaysia MY MYS Maldives MV MDV Mali ML MLI Malta MT MLT Marshall Islands MH MHL Martinique MQ MTQ Mauritania MR MRT Mauritius MU MUS Mayotte YT MYT Mexico MX MEX Micronesia FM FSM Moldova MD MDA Monaco MC MCO Mongolia MN MNG Montenegro ME MNE Montserrat MS MSR Morocco MA MAR Mozambique MZ MOZ Myanmar (Burma) MM MMR Namibia NA NAM Nauru NR NRU Nepal NP NPL Netherlands NL NLD New Caledonia NC NCL New Zealand NZ NZL Nicaragua NI NIC Niger NE NER Nigeria NG NGA Niue NU NIU Norfolk Island NF NFK Northern Mariana Islands MP MNP Norway NO NOR Oman OM OMN Pakistan PK PAK Palau PW PLW Palestinian Territories PS PSE Panama PA PAN Papua New Guinea PG PNG Paraguay PY PRY Peru PE PER Philippines PH PHL Pitcairn Islands PN PCN Poland PL POL Portugal PT PRT Puerto Rico PR PRI Qatar QA QAT Réunion RE REU Romania RO ROU Russia RU RUS Rwanda RW RWA St. Barthélemy BL BLM St. Helena SH SHN St. Kitts & Nevis KN KNA St. Lucia LC LCA St. Martin MF MAF St. Pierre & Miquelon PM SPM St. Vincent & Grenadines VC VCT Samoa WS WSM San Marino SM SMR São Tomé & Príncipe ST STP Saudi Arabia SA SAU Senegal SN SEN Serbia RS SRB Seychelles SC SYC Sierra Leone SL SLE Singapore SG SGP Saint Martin SX SXM Slovakia SK SVK Solomon Islands SB SLB Somalia SO SOM South Africa ZA ZAF South Georgia & South Sandwich Islands GS SGS South Sudan SS SSD Spain ES ESP Sri Lanka LK LKA Sudan SD SDN Suriname SR SUR Svalbard & Jan Mayen SJ SJM Swaziland SZ SWZ Sweden SE SWE Switzerland CH CHE Syria SY SYR Taiwan TW TWN Tajikistan TJ TJK Tanzania TZ TZA Thailand TH THA Timor-Leste TL TLS Togo TG TGO Tokelau TK TKL Tonga TO TON Trinidad & Tobago TT TTO Tunisia TN TUN Turkey TR TUR Turkmenistan TM TKM Turks & Caicos Islands TC TCA Tuvalu TV TUV Uganda UG UGA Ukraine UA UKR United Arab Emirates AE ARE United Kingdom GB GBR U.S. Outlying Islands UM UMI United States of America US USA Uruguay UY URY Uzbekistan UZ UZB Vanuatu VU VUT Venezuela VE VEN Vietnam VN VNM British Virgin Islands VG VGB U.S. Virgin Islands VI VIR Wallis & Futuna WF WLF Western Sahara EH ESH Yemen YE YEM Zambia ZM ZMB Zimbabwe ZW ZWE here to find the correct representation of the country.
Country State (Billing) *	The state must be written according to ISO 3166-2 Code format or simply with a name. USA States ✕ Name Code Alabama AL Alaska AK Arizona AZ Arkansas AR California CA Colorado CO Connecticut CT Delaware DE District of Columbia DC Florida FL Georgia GA Hawaii HI Idaho ID Illinois IL Indiana IN Iowa IA Kansas KS Kentucky KY Louisiana LA Maine ME Maryland MD Massachusetts MA Michigan MI Minnesota MN Mississippi MS Missouri MO Montana MT Nebraska NE Nevada NV New Hampshire NH New Jersey NJ New Mexico NM New York NY North Carolina NC North Dakota ND Ohio OH Oklahoma OK Oregon OR Pennsylvania PA Puerto Rico PR Rhode Island RI South Carolina SC South Dakota SD Tennessee TN Texas TX Utah UT Vermont VT Virginia VA Washington WA West Virginia WV Wisconsin WI Wyoming WY Example for the United States Canada Provinces ✕ Name Code Alberta AB British Columbia BC Labrador LB Manitoba MB New Brunswick NB Newfoundland NF Nova Scotia NS Nunavut NU North West Territory NT Ontario ON Prince Edward Islands PE Quebec QC Saskatchewen SK Yukon YT Example for Canada Provinces of Italy ✕ Name Code Agrigento AG Alessandria AL Ancona AN Arezzo AR Ascoli Piceno AP Asti AT Avellino AV Bari BA Barletta-Andria-Trani BT Belluno BL Benevento BN Bergamo BG Biella BI Bologna BO Bolzano/Bozen BZ Brescia BS Brindisi BR Cagliari CA Caltanissetta CL Campobasso CB Carbonia-Iglesias CI Caserta CE Catania CT Catanzaro CZ Chieti CH Como CO Cosenza CS Cremona CR Crotone KR Cuneo CN Enna EN Fermo FM Ferrara FE Firenze FI Foggia FG Forlì-Cesena FC Frosinone FR Genova GE Gorizia GO Grosseto GR Imperia IM Isernia IS L'Aquila AQ La Spezia SP Latina LT Lecce LE Lecco LC Livorno LI Lodi LO Lucca LU Macerata MC Mantova MN Massa-Carrara MS Matera MT Medio Campidano VS Messina ME Milano MI Modena MO Monza e della Brianza MB Napoli NA Novara NO Nuoro NU Ogliastra OG Olbia-Tempio OT Oristano OR Padova PD Palermo PA Parma PR Pavia PV Perugia PG Pesaro e Urbino PU Pescara PE Piacenza PC Pisa PI Pistoia PT Pordenone PN Potenza PZ Prato PO Ragusa RG Ravenna RA Reggio di Calabria RC Reggio nell'Emilia RE Rieti RI Rimini RN Roma RM Rovigo RO Salerno SA Sassari SS Savona SV Siena SI Siracusa SR Sondrio SO Taranto TA Teramo TE Terni TR Torino TO Trapani TP Trento TN Treviso TV Trieste TS Udine UD Valle d'Aosta/Vallée d'Aoste AO Varese VA Venezia VE Verbano-Cusio-Ossola VB Vercelli VC Verona VR Vibo Valentia VV Vicenza VI Viterbo VT Example for Italy Cantons of Switzerland ✕ Name Code Uri UR Svitto SZ Obvaldo OW Nidvaldo NW Lucerna LU Zurigo ZH Glarona GL Zugo ZG Berna BE Friburgo FR Soletta SO Basilea Città BS Basilea Campagna BL Sciaffusa SH Appenzello Esterno AR Appenzello Interno AI San Gallo SG Grigioni GR Argovia AG Turgovia TG Ticino TI Vaud VD Vallese VS Neuchâtel NE Ginevra GE Giura JU Example for Switzerland Prefectures of Japan ✕ Name Code 北海道 1 青森県 2 岩手県 3 宮城県 4 秋田県 5 山形県 6 福島県 7 茨城県 8 栃木県 9 群馬県 10 埼玉県 11 千葉県 12 東京都 13 神奈川県 14 新潟県 15 富山県 16 石川県 17 福井県 18 山梨県 19 長野県 20 岐阜県 21 静岡県 22 愛知県 23 三重県 24 滋賀県 25 京都府 26 大阪府 27 兵庫県 28 奈良県 29 和歌山県 30 鳥取県 31 島根県 32 岡山県 33 広島県 34 山口県 35 徳島県 36 香川県 37 愛媛県 38 高知県 39 福岡県 40 佐賀県 41 長崎県 42 熊本県 43 大分県 44 宮崎県 45 鹿児島県 46 沖縄県 47 Example for Japan States of Malaysia ✕ Name Code Johor MY-01 Kedah MY-02 Kelantan MY-03 Melaka MY-04 Negeri Sembilan MY-05 Pahang MY-06 Perak MY-08 Perlis MY-09 Pulau Pinang MY-07 Sabah MY-12 Sarawak MY-13 Selangor MY-10 Terengganu MY-11 Wilayah Persekutuan Kuala Lumpur MY-14 Wilayah Persekutuan Labuan MY-15 Wilayah Persekutuan Putrajaya MY-16 Example for Malaysia
NOTIFICATIONS
Global - All channels	1 - checked (YES), 0 - unchecked (NO)
Global - Email	1 - checked (YES), 0 - unchecked (NO)
Global - SMS	1 - checked (YES), 0 - unchecked (NO)

Add new import

1. To start a new import, navigate to the Site field in the header of your DG1 Admin section. Click the SITE dropdown menu and select the site to which you will import contacts.

2. Navigate to Audience in the Marketing section of your DG1 platform.

3. Click Import.

3. Enter details about the import:

• Using site: This field indicates the site, which the customer will be imported for. Example: DG1 Shop
• Name: Name of your new import.
• Segment: Add contacts into a segment. Segment is a group of contacts that can be added with Import or by filters. You can import all contacts to one segment directly or you can filter them through a variety of characteristics. Example: Let’s say you had a prize game and you would now like to import contacts to your database. It’s recommended that you create a segment called Prize game rather than creating a new mailing list. Segmenting your contacts will really help you because you will be able to use the same contacts for different purposes and promotions. It’s better to have only a few mailing lists and more segments within mailing lists.

Note

Choosing a segment is not mandatory! You have to add contacts to Mailing lists, at least the default one!

For more information on how to create a new Segment see DG1 Targeting manual.

• Country code: Choose a country calling code if all your contacts in .csv file have the same country calling number. This way you do not have to manually add country calling codes to your .csv file. If you have international contacts list in the .csv file, it has to contain a column with all country calling codes.
• Subscribe contacts to refers to “one to one” communication with your contacts outside mailing lists. Recommendation: leave them as they are.
• Choose the mailing list to which you want to import contacts. Click in the window and choose your mailing list or leave it set to Default.

If you would like to delete specific notifications for your imported contacts, select mailing lists and delete notifications by clicking x’s. Example: click the to delete a notification.

• Import document: Upload file through file selector.
• File encoding: You have to select the same file encoding as in the import file (Example: UNICODE UTF 8).
• Contains Headers: Check, if your import file contains the headers row. (Example: Name, Last name, Address etc.).
• Field separator: Choose the same as when you were saving your import file as .csv (Example: comma).
• Field enclosure: Choose the same as when you were saving your import file as .csv (Example: double quotation mark).
• Processing activity permissions - due to GDPR legislation you must select all the types of information for which you claim you have acquired a proper consent in the document you are about to import. Depending on the type of data, please select options under Marketing newsletter OPT-IN and/or options under Personalization & profiling consent.
• To create your own consent please go to Advanced -> Processing activities and click Add .

In your Import preview select headers, if they have not been recognized from .csv file. Above each column click Skip and select the attribute to which the information in column refers to.
If you already had headers in your import file, the selection will be done automatically but it might not recognize all headers. So follow the above instructions. If your import document does not include headers, you will have to add them manually.
Example: Import did not recognize certain headers and you will have to manually add them by clicking the arrow and choosing the right one.

4. To save click Submit .
5. Click Actions and choose Import.
6. Refresh page and the contacts will be imported.

Note

When importing contacts you should select a header (or the system will automatically detect it). If the header is an attribute and your .csv file has no value for this attribute, the default value of this attribute will be added automatically after import. To avoid this situation make sure you do NOT import a csv. file with empty attribute columns.

To view results of your import click Actions and select Results.

To view the status of your imports click List and choose the import you would like to check. Click Actions and after that Results. See the succeeded and failed contacts. By clicking Show reason you will see a reason explaining why the import of that contact has failed.

Export the failed contacts by clicking Export failed . Then select your preferred export type (either excel, CSV, ods, etc.) Once the file is downloaded to your computer, you can open it, correct the wrong data, save the file and import it back to your platform following the same process as with your other imports.

How to save .CSV file

In your spreadsheet go to:

1. Save as.
2. Select file type: .csv.
3. File name.
4. Keep the current format.
5. Character set = UNICODE UTF-8.
6. Field delimiter is a comma (you can choose another).
7. Text delimiter (example: “quote mark”) will be added automatically - quote all text cells (check).
8. OK.