3.4-Import Subscribers from File

a) Importing Subscribers from a File

If you have a subscription list in excel or notepad file and you want to get it imported, instead of adding one by one. Then Mumara's answer is yes, you can do it with our Import tool. In left Navigation menu under Subscribers Tab, click on “Import Subscribers from a File” and you’ll be shown the following page.

Figure#3.4.1: Import Subscribers

Importing Subscriber Emails

Now there are two options to upload the file before it gets ready for import.

1-      Click on “Choose File” button and select if from your computer.

2-      Upload it via FTP in /import_file folder under your product installation directory.

Note: If there isn’t any folder with the specific name already, then you need to create a folder named “import_file” (without quotes) and give writable permission (chmod 777) to it.

If going with option 2, then select the second option from first dropdown which will allow you to choose from already uploaded files. It will now display another dropdown menu which will contain all uploaded files available for import. Select your file which you want to import -> Select Subscriber List where you want all subscribers within the uploaded list to get imported -> Select the format -> Select Status as unconfirmed (if not already confirmed) and press Start Import.

b) Duplicates 

Recent product upgrades has added new options to take appropriate actions for the duplicates, while importing the file. You can select one of the following options while importing the file.

b.1) Skip

Selection of this option will skip the duplicate contacts while importing the file, and will not import the duplicate contacts.

b.2) Ignore

Ignore action for the duplicates to complete the process of importing without making any changes or affecting the duplicates. 

b.3) Overwrite

Selecting this option will replace the existing duplicated entry in the selected subscriber list(s) with the new matching record details in the importing file. It will eventually delete the existing entry to overwrite it with the new match in the importing file.

b.4) Update

Unlike overwrite, selecting this option will not delete the existing entry, rather it will just update the duplicate values, and leave the other fields as it is. Like if it finds that the contact email is duplicate, while other fields that exist in the subscriber lists(First Name, Last Name etc.) doesn't exist in the importing file, it will just update the contact email and leave the other fields without making any changes. It doesn't delete the existing entry, just update the duplicate values. 

On the next screen, Mumara reads the headers of your file and displays separately along with database fields for the selected subscription list in drop down. For example, have a look on the figure below.

Figure#2.4.2: Reading the Header

Headers in Importing File

In the above mentioned instance, we have tried to import a CSV file containing four columns with headers i.e. Email Address, First Name, Last Name, and Company. So in this step Mumara displays the headers of the file and besides the header of the file, shows the database fields in the dropdown list against every column's header. Map the correct fields for every column. Have a look on the figure below for a better idea of how it looks?

Figure#2.4.3:Mapping the Fields

Mapping the Headers

Once you choose your correct fields for correct headers, you can proceed to import the subscriber’s details from the file to a list. Click on NEXT button to start import. The figure below shows how it looks while your data is getting imported into the selected list.

Figure#2.4.4:Importing Details from File

Importing in Progress

The Import undergoes several background operations as listed in the figure above. Below is the short summary of some of these background operations.

a) Reading File

This function reads your file and count total number of subscribers/rows inside. This function isn’t responsible for performing any query other than reading the file.

b) Filtering the file and getting ready to import

During this function, Mumara copies your data to a temporary table to make it available for filtration. Filtration would include removing duplicates and invalid emails from the imported list.

c) Removing Duplicates

It removes the duplicate entries/emails from the imported list.

d) Removing Invalid Emails

This function removes all invalid emails. Invalid emails are those which have invalid format or doesn’t look like an email address.

e) Importing Data

Once the duplicates and invalid emails have been removed from the list you just imported, Mumara starts the actual import from the temporary table to the actual table and your list gets ready to be used.

All of the above features are using advanced techniques and highly optimized queries, which make the things, go real fast. It also involves some technical optimization in your server libraries which you can look in our support desk.

Note: Just CSV or TXT format works with this import.