Organize traffic in a database.

Organize traffic in a database. SearchSearch

SMS & MMS Technical Forum » NowSMS Support - SMS Issues (Product Support Only) » Organize traffic in a database. « Previous || Next »
Author Message
Luis Claudio
New member
Username: Agentelu

Post Number: 12
Registered: 11-2018
Posted on Sunday, April 26, 2020 - 04:53 pm:   

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
Posted on Monday, April 27, 2020 - 05:10 pm:   

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

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