OZEKI NG SMS Gateway
"The World's most reliable SMS gateway software!"
info@ozekisms.com
Tel.: 00 36 52 532 731
Overview Quick start Download Manual How to buy FAQ Contact Us
OZEKI NG SMS Gateway - Product Guide

SMS from/to file Contents | SearchSMS from shared files

Home > Product Manual > Installation Guide > Users and applications > SMS from/to file > CSV file format

SMS Gateway SMS Gateway Home

  Product Manual
  Introduction
  SMS technology
  Installation Guide
  Prerequisites
  Download Information
  Installation Steps
  Service Provider Connections
  Users and applications
  Standard user
  SMPP user
  SMS from/to database
  Autoreply SMS from database
  Autoreply SMS using a script
  Simple autoreply SMS
  SMS from/to file
  CSV file format
  SMS from shared files
  SMS through E-mail
  SMS via HTTP Request
  SMS via colour protocol
  Application starter SMS
  SMS Voting
  SMS from MS Outlook
  SMS from/to FTP server
  PDF Request in SMS
  SMS to WCF service
  SMS Forwarder
  RSS to SMS
  Linux
  User Guide
  Developers Guide
  Examples and Solutions
  Appendix
  FAQ
  Feature list
  Commercial Information
  Search
 


Automated phone calls?
Ozeki Phone System XE VoIP PBX software is an advanced PBX built for automated voice calls and 2 way SMS messaging. It has outstanding APIs for software developers. It can be used for:

Phone calls from SQL
Phone calls from HTTP
Voice and SMS applications

Callcenter developers
If you are working on telephone solutions, please check out the Ozeki VoIP SIP SDK.
It can be used to create VoIP client and server software.

Contact Us!
If you wish to get further information, do not hesitate to contact us!

E-mail: info@ozekisms.com

If you have a technical question, please submit a support request on-line.

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.


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

Dig deeper!
People who read this also read...


How to send SMS from a Text file
How to send SMS from shared files
Quick start guide
GSM modem connection
IP SMS connection
service provider connection





Next page: SMS from shared files
Copyright © 2000 - 2014 Ozeki Informatics Ltd.
All rights reserved

Software PBX for Windows | VoIP SDK   |   Legal information   |   Privacy policy   |   Terms of use
Please, address your inquiries to info@ozekisms.com