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
Received Time in SQL Connector shows NULL
sp_NewPost Add Reply sp_NewTopic Add Topic
June 20, 2018
10:32 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

No, that is not possible. The SMS system does not have the concept of a reply to another message. Every message stands on its own and there is no way to know 100% sure that a received message is a reply to another message. Diafaan SMS Server therefore does not fill in the UserId field for received messages.

Regards, Henk

June 20, 2018
8:25 am
Rhog
Guest
Guests
Go to Top
3sp_Permalink sp_Print sp_QuotePost Quote

Thank you Henk. I've filled all the database fields in the advance setting. In my database messagein table, all fields are filled correctly except the UserId. Before, the value was NULL, but now it's just empty. All I want is to save the UserId who sent the message. Am I able to do that, and how? Thank you again for your help, Henk.

June 19, 2018
9:58 am
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 Rhog,

For outgoing messages you can check if the 'SMSLogReceiveTime' property in the advanced settings of the SQL Connector points to the correct database field name. For incoming messages check the 'SMSInReceiveTime' property.

Regards, Henk

June 19, 2018
6:35 am
Rhog
Guest
Guests
Go to Top
1sp_Permalink sp_Print sp_QuotePost Quote

Hi Henk,

I was wondering how can I record the received time for my Sql connector. I've searched in the connector setting but I can't find it. There is a setting for the Send Time, but I don't find setting for Received Time.

Thank you for the help.

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

Most Users Ever Online: 529

Currently Online:
6 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