Log file through database

Log file through database SearchSearch

SMS & MMS Technical Forum » NowSMS Support - SMS Issues (Product Support Only) » Log file through database « Previous || Next »
Author Message
Hassan Jamil
New member
Username: Elev8

Post Number: 2
Registered: 05-2018
Posted on Monday, May 14, 2018 - 06:02 am:   

Hi,

Is there is any chance I can get track of log file through database.

As you can see we can get the track of logfile through text document.
2018-05-07 11:24:15,SMTPIN,,hassanjamil543@gmail.com,0415xxxxxx,,2B9DB976.REQ

This will require alot of manual process handling to get track of records.Is there is anyway that we can connect this logfile to SQL database.

Thanks,
Hassan
Des - NowSMS Support
Board Administrator
Username: Desosms

Post Number: 5914
Registered: 08-2008
Posted on Monday, May 14, 2018 - 03:16 pm:   

Hi Hassan,

There is no built-in facility that transfers the log information to a database.

Essentially, the log files are CSV files. If you Google CSV file to database and add additional keywords for the type of database you want to use, there should be some examples that can help you out.

--
Des
NowSMS Support
Hassan Jamil
New member
Username: Elev8

Post Number: 3
Registered: 05-2018
Posted on Tuesday, May 15, 2018 - 12:10 am:   

Hi Des,

Do you have any idea where these csv files are saved? so that I can have a look.

Regards,
Hassan Jamil
Des - NowSMS Support
Board Administrator
Username: Desosms

Post Number: 5917
Registered: 08-2008
Posted on Tuesday, May 15, 2018 - 03:28 pm:   

Hi Hassan,

They are in the directory that NowSMS is installed in, with the file extension of .LOG (except in some older installations which may use \ProgramData\NowSMS instead).

E-Mail to SMS is an odd case, because it is processed by the MMS module, and are recorded in the MMSC-yyyymmdd.LOG files. Other SMS submissions (web, API, SMPP) are recorded in SMSWEB-yyyymmdd.LOG.

--
Des
NowSMS Support

Add Your Message Here, or click here to create a new discussion topic.
Post:
Bold text Italics Underline Create a hyperlink Insert a clipart image
Posting Information:
This is a private posting area. Only registered users and moderators may post messages here.
Click here to create an account.
Username:
Password:
Options: Automatically activate URLs in message
Action:

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