Support forum

Advanced Search

— Forum Scope —




— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters

sp_TopicIcon
Extracting Logs
sp_NewPost Add Reply sp_NewTopic Add Topic
November 14, 2022
10:55 am
Sorin
Guest
Guests

Thanks for the fast response.

I think I've identified the issue, I repurposed a MS SQL connector (changed the ODBC connection string) because I didn't want to have to configure each field by hand, and it was using a different SQL dialect.
I've now created a Maria DB connector from scratch and it seems to be working fine. I will confirm in a few days.

November 14, 2022
9:43 am
Henk Helmantel
Admin
Forum Posts: 1375
Member Since:
May 28, 2013
sp_UserOfflineSmall Offline

Hello Sorin,

When the option 'Log all messages to SQL/Excel Connector...' in the advanced general settings is set to the right SQL Connector then all the messages should be logged in the SQL database.

If you send me the configuration file (menu options 'File-export-Configuration') and the event log file (menu options 'File-export-Event log') I will have a look at it to see what the issue could be. You can send the two files to email address 'dms@diafaan.com'.

Regards, Henk

November 12, 2022
2:20 pm
Sorin
Guest
Guests

Hello!

I've created a dedicated SQL connector using Maria DB for saving logs (for billing purposes), but not all the sent messages are stored there.
I haven't been able to figure out a pattern of what iss missing, but there are quite a lot of messages missing.
What am I missing ?

August 4, 2022
3:58 pm
Henk Helmantel
Admin
Forum Posts: 1375
Member Since:
May 28, 2013
sp_UserOfflineSmall Offline

Hello Emmanuel,

The best way to keep a record of each outgoing and/or incoming SMS is to use an (extra) SQL Connector to store the log in an SQL database. Normally an SQL Connector only stores the outgoing messages that are sent from the same SQL Connector but in the advanced options you can set one SQL Connector that stores all the messages in Diafaan SMS Server.

Another option is to set the logging options (select 'Actions-Options-Logging') to 'Remove log items after 1 day' and select the 'Save removed items to XML file'. This will store all log items to XML files after one day.

Regards, Henk

August 4, 2022
4:00 am
Emmanuel Cielo
Guest
Guests

To justify the cost for purchasing this product, is there a way to easily extract the logs? Logs needed are the failed and sent/delivered logs of the sms sent. Thank you.

Forum Timezone: Europe/Amsterdam

Most Users Ever Online: 494

Currently Online:
14 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

Member Stats:

Guest Posters: 642

Members: 0

Moderators: 0

Admins: 1

Forum Stats:

Groups: 2

Forums: 3

Topics: 1067

Posts: 3647

Newest Members:

, Henk Helmantel

Administrators: Henk Helmantel: 1375