...
Campo | ID |
Indirizzo email | 111 |
prefisso sms | 222 |
numero sms | 333 |
numero completo sms (prefisso sms + numero sms) | 444 |
...
Campo
...
ID
...
Indirizzo mail
...
111 – Valore fisso
...
Cognome
...
2
...
Nome
...
3
...
Data di Nascita
...
4
...
Nazionalità
...
5
...
Sesso
...
6
...
Telefono
...
7
...
Campo | Posizione nei record del file |
Nome | 1 |
Cognome | 2 |
Data di Nascita | 3 |
Codice fiscale | 4 |
Sesso | 5 |
Nazionalità | 6 |
Indirizzo mail | 7 |
Telefono | 8 |
Come si può vedere, il codice fiscale non compare in anagrafica e quindi non potrà essere importato. Per esso si dovrà indicare un campo vuoto nella riga di mappatura che sarà
3;2;4;;6;5;111;7
Mentre le altre righe del file (cioè dalla seconda in poi) avranno un formato di questo tipo:
Mario;Rossi;1975-07-3;rssmro75g13f103h;M;ITALIAN;mario.rossi@provider.com;12345678
Paola;Verdi;1981-01-11;vrdpol81h11f234u;F;ITALIAN;paola.verdi@provider.com;987654321
Pierino;Prati;1945-03-12;prtprn45c12o256h;M;ITALIAN;pierino.prati@provider.com;
Manuela;Cabrini;1990-04-29;cbrmnl90h29m945i;M;ITALIAN;manuela.cabrini@provider.com;
| The CSV file must contain a header row that maps the values contained in that column to a corresponding field in the MailUp system. In MailUp there are:
- Some special fields that are reserved for e-mail, mobile phone number, and mobile phone number + country code.
- Customizable personal data fields. Personal data fields (e.g. first name, last name, etc.) have a numeric ID that goes from 1 to 11 (1 to 40 if the Marketing+ package has been added to your account).
Special Fields
MailUp contains the following special fields, which cannot be modified.
Campo | ID |
E-mail address | 111 |
Mobile phone number's country code | 222 |
Mobile phone number | 333 |
Complete mobile phone number (country code + number) | 444 |
Personal Data Fields
This is just an example of personal data fields in MailUp. They are customizable, meaning that field #2 does not have to be the Last Name. In your MailUp admin console, you will find them under Manage > Personal Data Fields.
Field Name | Field ID |
E-mail address | 111 (cannot be altered, see above) |
First Name | 1 |
Last Name | 2 |
Company | 3 |
City | 6 |
Country | 8 |
Gender | 9 |
Date of Birth | 10 |
Let's say that your CSV file contains these columns:
Field Name | Position in the CSV file |
First Name | 1 |
Cognome | 2 |
Date of Birth | 3 |
Gender | 4 |
Country | 6 |
E-mail address | 7 |
City | 8 |
The columns in your CSV file need to be mapped to the corresponding fields in MailUp, so you will need to add a header row to the CSV file with the following values:
1,2,10,9,8,111,6
Note that the e-mail address will use the special value "111". The other columns use the ID of the corresponding field in MailUp.