Reporting or DB

Reporting or DB SearchSearch

SMS & MMS Technical Forum » NowSMS Support - SMS Issues (Product Support Only) » Archive through August 22, 2012 » Reporting or DB « Previous || Next »
Author Message
Shahaz Roy
New member
Username: Shahazroy

Post Number: 8
Registered: 07-2012
Posted on Tuesday, July 24, 2012 - 09:03 am:   

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
Posted on Friday, July 27, 2012 - 05:42 am:   

waiting for reply please.
Shahaz Roy
New member
Username: Shahazroy

Post Number: 11
Registered: 07-2012
Posted on Friday, July 27, 2012 - 05:44 am:   

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
Posted on Friday, July 27, 2012 - 01:32 pm:   

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
Posted on Monday, July 30, 2012 - 06:45 am:   

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
Posted on Tuesday, July 31, 2012 - 02:27 pm:   

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

Login Login / Register Logout Logout Search Last 30 Days Topics Topics