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
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
Figure 1 demonstrates the Excel table that will be exported
into CSV file format.
Figure 1 - Excel table
On Figure 2 you can see the CSV file after the 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).
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).
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).
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.
Figure 6 - Sent messages in Ozeki NG SMS Gateway
SMS from shared files