PhoneBook files

The files that can be imported as PhoneBook are text files and CSV files

Import PhoneBook

CSV Files

As Wikipedia says: "A comma-separated values (CSV) file stores tabular data (numbers and text) in plain-text form. Plain text means that the file is a sequence of characters, with no data that has to be interpreted as binary numbers. A CSV file consists of any number of records, separated by line breaks of some kind; each record consists of fields, separated by some other character or string, most commonly a literal comma or tab. Usually, all records have an identical sequence of fields."
For example:

Name Telephone Number Address City
Alan 3286457382 Via Po, 15 Rome
Bob 3284536782 Via Piave, 20 Florence
Mary 3208965864 Via Tevere, 1 Bologna
John 3897564732 Via Arno,8 Turin

The example above can be represented in the CSV format as follows:

Name, Telephone Number, Address, City
Alan , 3286457382, "Via Po, 15", Rome
Bob, 3284536782, "Via Piave, 20", Florence
Mary, 3208965864, "Via Tevere, 1", Bologna
John, 3897564732, "Via Arno,8", Turin

It should be noted that the field separator character is a comma ("," and if this character is reported in the content of a field, the latter must be enclosed in double quotes. Actually, commas are used as field separator characters only in the English-speaking world, while romance-speaking countries tend to prefer semicolons ";". This is because commas are used as decimal separator in this case.
As CSV files are normal text files, you can edit them with any kind of text editor like WordPad, notepad, etc. You can delete or add a line, copy and paste, etc.. However, the most suitable application is Microsoft Excel, which allows the users to upload these files as tables and edit them as required (delete lines or columns, add lines, etc.) and then re-save them in the CSV format. Microsoft Excel also enables the users to upload data tables, save them as CSV files and then import them in the Control Panel (Save as -> Other formats, then choose the CSV file format in the "Save as" option). The CSV files used in SMS Gateway can also have several fields, but we only focus on those containing the contact Name and Telephone Number.
Actually, the only field required for transmitting text messages is Telephone Number, while the name field can be useful only if the imported CSV file is used as a Phone Book in which it is possible to select the message recipient. Conversely, if you want to send text messages to all the contacts of the imported CSV file, you do not need to know the owners of each single number. In any case, when you import a CSV file, the Control Panel asks you to determine the Name and Phone Address fields. If the Name field is lacking, you can indicate any other field in place of it, even the Phone Address field. It should be noted that the header line including the field names is not mandatory for CSV files. If it is lacking, you can determine the Name and the Phone Address fields based on the content.
Now let's see how to import a CSV file in the Control Panel.
By pushing the "New PhoneBook" button, a window automatically opens and allows you to choose the CSV file to be imported. A folder automatically opens, which is always the last selected one, so if you put all your CSV files into a single folder and then push the "New PhoneBook" button, you can comfortably select the file to be imported.
Once selected the file to be imported, another window opens in which you have to determine the Phone Address and Name field. After the confirmation, the CSV file is uploaded in the Control Panel and its data are shown in a table. Once imported the data, you can send a text message to all the data selected with the "Send to selected" button.
The Phone Book of your mobile phone is displayed directly in the Control Panel, without rewriting any single contact, thanks to CSV files. The CSV (Comma Separated Values) file format is widely used for importing and exporting data tables in spreadsheets and databases. The Google App Store offers several free Apps that allow customers to send the phone book of their mobile phone to their computers in the form of CSV files. These apps are generally very user-friendly. Actually, you just need to enter the e-mail address to which the contact list of your mobile phone has to be sent and you will receive it there as a CSV file attached. Then, you have to import this CSV file in your Control Panel, and the Phone Book of your mobile phone will be displayed on your PC. In order to perform this operation, you can use whatever App you like. We have used the "EXPORT" by Aurelien Texier App which seemed quite efficient: you just have to enter the e-mail address and there you will receive the Contacts.csv file as an attachment containing the phone book of your mobile phone. One of the advantages resulting from the use of CSV files is that they are a widespread standard format, which allows the customers to import in their Control Panel the phone book of their mobile phone, as well as large databases containing telephone numbers saved as CSV files from various spreadsheets or other databases.

Text files

This option is easier.It proposes a TextBox where you must enter mobile phone numbers followed by the Enter key. Alternatively, you can run the Copy and Paste from a text file or from a column of Excel telephone numbers