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
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: 1518
Member Since:
May 28, 2013
sp_UserOfflineSmall Offline

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

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: 1518
Member Since:
May 28, 2013
sp_UserOfflineSmall Offline

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

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.

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: 681

Members: 0

Moderators: 0

Admins: 1

Forum Stats:

Groups: 2

Forums: 3

Topics: 1160

Posts: 3962

Newest Members:

, Henk Helmantel

Administrators: Henk Helmantel: 1518