Support forum

sp_Search Search
Advanced Search
Advanced Search

— Forum Scope —




— Match —





— Forum Options —





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

sp_Search Search
Go to Bottom
sp_TopicIcon
Extracting Logs
sp_NewPost Add Reply sp_NewTopic Add Topic
November 14, 2022
10:55 am
Sorin
Guest
Guests
Go to Top
5sp_Permalink sp_Print sp_QuotePost Quote

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: 1488
Member Since:
May 28, 2013
sp_UserOfflineSmall Offline
sp_UserWebsite
Go to Top
4sp_Permalink sp_Print sp_QuotePost Quote

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
Go to Top
3sp_Permalink sp_Print sp_QuotePost Quote

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: 1488
Member Since:
May 28, 2013
sp_UserOfflineSmall Offline
sp_UserWebsite
Go to Top
2sp_Permalink sp_Print sp_QuotePost Quote

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
Go to Top
1sp_Permalink sp_Print sp_QuotePost Quote

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.

sp_NewPost Add Reply sp_NewTopic Add Topic
Go to top
Forum Timezone: Europe/Amsterdam

Most Users Ever Online: 529

Currently Online:
4 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

Member Stats:

Guest Posters: 672

Members: 0

Moderators: 0

Admins: 1

Forum Stats:

Groups: 2

Forums: 3

Topics: 1141

Posts: 3899

Newest Members:

, Henk Helmantel

Administrators: Henk Helmantel: 1488