Before proceeding with the import and assignment of users to a list, it is necessary to create a list as illustrated in the dedicated article.

Once the list has been created from Other -> Email marketing -> User List Management -> Add new List (top right), we assign it a code and a name.

The code that we will assign to the list in this step will be the one that we will later insert into our csv file.

Once the list has been created, let’s create the file to be imported.

You can see the detailed import procedure in this article.

The necessary fields within the file are:

f_ricevi_newsletter : if we are doing an import of newsletter subscribers this field must be set to 1 for all users as they have accepted the newsletter

f_ricevi_comunicazioni_commerciali: 0 if the user has not accepted; 1 if you accepted

f_ricevi_newsletter_TS and f_ricevi_communicazioni_commerciali_ts is of the type 2023-09-22 12:09:28 and indicates the date and time of subscription to the newsletter and commercial communications.

f_attivo: 1 indicates that the user is active on Adabra, 0 if they are inactive. Obviously, if the user is deactivated, he will not be used.

List : code of the list in which you want to insert the user

mantieni_liste_attuali: 1 if we want the user to remain subscribed to all the lists to which he was previously assigned, in addition to the one entered in the current import, 0 if we want him to be deleted from the other lists and kept only as a subscriber to the current list.

It is also possible to add additional optional fields to the csv columns such as Name, Surname, gender, etc.

In order for the import to be successful, the file must be correctly mapped with the structure on Adabra.

The values with which to map the columns passed in the csv is selected in the second step of the subscriber import, visible below

Here it is necessary to select in the right column with the drop-down menus, the field that you want to be associated with the value within the csv, indicated in the left column.

Once you are done with this step, the csv will be imported.

In the User Import tab we will then be able to view if the upload has been successful or, if there are errors, download the list to understand what has not been correctly imported.