| Reporting or DB |  Search
|
|
NowSMS Support Forums ⬆ NowSMS Support - SMS Issues ⬆ Archive through August 22, 2012 ⬆ |
◄ ► |
| Author | Message | |||
| Shahaz Roy New member Username: Shahazroy Post Number: 8 Registered: 07-2012 |
is there any reporting system available for nowsms. I am using trial version of 60days and email to sms facility. or is there a way to connect nowsms with MS-SQL or mysql. so that i can build my own reports. thanks | |||
| Shahaz Roy New member Username: Shahazroy Post Number: 10 Registered: 07-2012 |
waiting for reply please. | |||
| Shahaz Roy New member Username: Shahazroy Post Number: 11 Registered: 07-2012 |
basically I want to make reports of this service usage. how many sms sent using email to sms service. | |||
| Des - NowSMS Support Board Administrator Username: Desosms Post Number: 4051 Registered: 08-2008 |
For historical reporting, the SMSOUT-yyyymmdd.LOG (year month day) files record details about SMS messages sent out. The logs are fairly straight-forward. I've been looking for a link that explains the format. I know there has got to be a better description somewhere, but this should get you started: http://support.nowsms.com/discus/messages/1/5804.html One note however ... e-mail to SMS is recorded slightly different in the logs, because there is not NowSMS account information associated with the transaction. In place of the IP address, it has the text "SMTP sender" before the e-mail address that submitted the message. -- Des NowSMS Support | |||
| Shahaz Roy New member Username: Shahazroy Post Number: 12 Registered: 07-2012 |
thanks, but I want to connect the nowSMS to any Database, i want the logs to be created in Database not in log files. | |||
| Des - NowSMS Support Board Administrator Username: Desosms Post Number: 4054 Registered: 08-2008 |
In most scenarios, I would recommend the accounting callback interface (http://www.nowsms.com/tag/accounting-callbacks). However, those callbacks are not well suited for an environment that makes heavy use of SMTP to SMS. They work well with HTTP, SMPP and the other protocols. I'm sorry, but those log files are the only record provided. -- Des NowSMS Support | |||
