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
Display last message sent to a contact
sp_NewPost Add Reply sp_NewTopic Add Topic
December 6, 2018
10:52 am
Henk Helmantel
Admin
Forum Posts: 1487
Member Since:
May 28, 2013
sp_UserOfflineSmall Offline

Hello Robert,

This is not possible in Diafaan SMS Server, the Email Connector does not have access to the contact lists from the Web Connector and is therefore not able to retrieve the contact name from a mobile number.

It is not easy to add this functionality to Diafaan SMS Server, the connectors and gateways function independently from each other and do not have access to each other's database. I will add your suggestion to the list of requested features for Diafaan SMS Server but this is not a feature that we are likely to implement in the next few versions of Diafaan SMS Server.

Regards, Henk

December 5, 2018
3:48 pm
Robert Wilson
Guest
Guests

Hi,

Would it be possible for the email connector to do a lookup in the Web Connector database, for the latest/last message that was sent to a particular number which has been received, then append this as a variable/field to the email message that is sent out on template?

I'm far from a coding expert, but logically I see it flow like the following...

For instance:

1. User sends a message to '+441234567890' saying "Hello, this is a test."

2. Message is received by user on their mobile. They send a reply: "Yes, I have received."

3. Message is received by Diafaan server. Diafaan does a query lookup into the WebConnector DB with a query such as:
-----------------
SELECT
Contacts.FirstName,
Contacts.LastName,
Contacts.Name,
MessageOut.MessageText,
Contacts.Number
FROM
MessageOut
INNER JOIN Contacts ON Contacts.Number = MessageOut.MessageTo
WHERE
Number = '+441234567890' AND
MessageOut.Id IN (SELECT
Max(MessageOut.Id)

FROM
MessageOut
GROUP BY
MessageOut.MessageTo)
-----------------
...this runs and uses incoming ReceivedFrom number to run the query WHERE number = 'xxxx' against. The MessageText is then passed along to a variable which can be used in the Email connector template, so the email can be formatted as:

Received from: [ContactName] [number]
Message:
[Message]

Last message sent to this number:
[LastMessage]

...It's conceivable that this could also be used to display the Contact Name as a variable too, which would be ideal.

Please can you let me know your thoughts on this if possible?

Thanks.

Forum Timezone: Europe/Amsterdam

Most Users Ever Online: 529

Currently Online:
5 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

Member Stats:

Guest Posters: 671

Members: 0

Moderators: 0

Admins: 1

Forum Stats:

Groups: 2

Forums: 3

Topics: 1140

Posts: 3897

Newest Members:

, Henk Helmantel

Administrators: Henk Helmantel: 1487