- Quick start guide
- System requirements
- Installation guide
- Administrators guide
- Mobile networks
- User guide
- Developers guide
- Service providers
- SMPP client
- SMPP server
- User authentication
- Reporting database
- Report into SQL Txt
- Failed queries
- Multipart SMS
- Report MSSQL fast
- Powershell script
- Performance tuning
- Sender ID
- Short code
- Error detection
- OZX server
How to save all SMS messages into a CSV
This guide gives you the steps to take to save all SMS messages going through your system into a CSV text file. This file can be later loaded into Microsoft Excel, WPS Office or any other spreadsheep application.
The reporting system can save messages going through the system into different sources, such as databases, txt files, etc. One of the most popular choice is using CSV files to save a log of each message. You are able to open reporting system from the Edit menu Reporting option as you can see it on the Figure 1.
In the Reporting menu click on the Create new SMS Reporter button and than select Csv reporting type (Figure 2).
The details page of the Csv reporter allows you to configure the file location and when will be created an independent .csv file for the selected period by the SMS Gateway. The separator character used to separate items in the list (Figure 3).
From the Admin user you can send SMS message. Provide the recipient address, the message and click on the OK button (Figure 4).
Now in the folder what you set in the Csv reporter details page you can see the .csv text file is created. The default folder is C:\Ozeki (Figure 5).
Finally if you are open the .csv text file you can see that all the sent and received sms messages are stored as the Figure 6 shows. This file can be later loaded into Microsoft Excel, WPS Office or any other spreadsheep application.
- High performance SQL reporting
- How to find out which SQL queries were not executed
- How to save the PDU count of Multipart SMS into a database
- High performance database reporting settings for MS SQL
- Powershell script to load SQL into mySQL