How to send SMS text messages in CSV file format

This guide provides you detailed information on how you can send SMS text messages in CSV file format with Ozeki NG SMS Gateway. Please follow the configuration guide below to be able to apply this solution.

It is possible to export Excel tables into CSV file format. In this way data of the table will be structured in a table of lists form. In the created CSV file each line corresponds to a row of the original table. Within a line, fields are separated by commas, and each field belongs to one table column. (Please see Figure 1 for an Excel table and Figure 2 for an exported CSV file from the table).

Finally you will be able to send data in CSV file format via SMS text messages with the help of a File user in Ozeki NG SMS Gateway. This solution allows you to send text messages in a simple file format instead of Excel tables.

Configuration

Figure 1 demonstrates the Excel table that will be exported into CSV file format.

excel table
Figure 1 - Excel table

On Figure 2 you can see the CSV file after the export.

csv file after export
Figure 2 - CSV file after export

In Ozeki NG SMS Gateway go to "Add new user or application" and click on "install" next to File user interface to create a new file user (Figure 3).

create a file user in ozeki ng sms gateway
Figure 3 - Create a file user in Ozeki NG SMS Gateway

On General tab select CSV from the dropdown menu as File format and click on "OK" (Figure 4).

csv as file format
Figure 4 - CSV as File format

Now the CSV file needs to be copied into smsout folder (by default it is in c:\smsTemp\smsout\). Then Ozeki NG SMS Gateway sends out the messages (Figure 5).

ozeki ng sms gateway sends out the messages
Figure 5 - Ozeki NG SMS Gateway sends out the messages

On Figure 6 you can see the sent messages in "Sent" folder in Ozeki NG SMS Gateway.

sent messages in ozeki ng sms gateway
Figure 6 - Sent messages in Ozeki NG SMS Gateway

More information