Organize traffic in a database. | Search |
NowSMS Support Forums ⬆ NowSMS Support - SMS Issues ⬆ Archive through June 03, 2020 ⬆ |
◄ ► |
Author | Message | |||
Luis Claudio New member Username: Agentelu Post Number: 12 Registered: 11-2018 |
Hi, What is the best way to obtain information from users and messages sent in a database or other system. Is there a document that describes the structure of text files so that I can separate the information and send it to a database? | |||
Des - NowSMS Support Board Administrator Username: Desosms Post Number: 6142 Registered: 08-2008 |
Hi, The log files are text based comma-delimited files. A.) The SMSOUT-yyyymmdd.LOG records all messages submitted to an upstream SMSC connection (and also records SMS connectivity errors). Examples: 2020-04-27 04:47:44:251,System,,SMPP - 192.168.0.40:9000,SMPP Failure -- Unable to connect to SMPP server at 192.168.0.40:9000 2020-04-27 04:48:45:569,535648B0,192.168.0.106,999999999,OK -- SMPP - 192.168.0.40:9000,SubmitUser=smpp;SMSCRouteName=smpp1;Sender=1234;Text="ok" There are basically two types of log entries that are included in SMSOUT logs. 1.) The date/time is always the first item in a log entry. 2.) The second item is either a request id or the text "System". If the second item is a request id, then the fields that follow are: 3.) IP address that submitted message 4.) Recipient phone number 5.) Status (OK -- SMSC name; Retry pending -- SMSC name; or Error info -- SMSC name). 6.) Message details. This information varies, but is generally semi-colon delimited key=value pairs with message details For the "System" entries, these entries denote a problem communicating with an SMSC, and the fields that follow are: 3.) blank 4.) SMSC name 5.) Error information B.) The SMSWEB-yyyymmdd.LOG records all client message submissions (despite the name, both HTTP and SMPP client submissions are recorded). Example: 2020-04-27 05:42:06:547,192.168.0.106,smpp,535648C2,Text,Recip=99999999;Sender=smpp;Text="t est" 1.) date/time 2.) IP address that submitted message 3.) User account that submitted message 4.) request id 5.) Message type 6.) Message details. This information varies, but is generally semi-colon delimited key=value pairs with message details C.) The SMSIN-yyyymmdd.LOG records all messages received from an upstream SMSC connection. Example: 2020-04-27 14:05:37:211,777777777,NowSMSModem - VZW,Text="Test";SMSCRouteName=VZW;Recip=99999999 1.) date/time 2.) sender/source address 3.) SMSC Name 4.) Message details. This information varies, but is generally semi-colon delimited key=value pairs with message details -- Des NowSMS Support |