| Log file through database |  Search
|
|
NowSMS Support Forums ⬆ NowSMS Support - SMS Issues ⬆ Archive through June 03, 2020 ⬆ |
◄ ► |
| Author | Message | |||
| Hassan Jamil New member Username: Elev8 Post Number: 2 Registered: 05-2018 |
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 |
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 |
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 |
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 | |||
