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.
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...
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:
INNER JOIN Contacts ON Contacts.Number = MessageOut.MessageTo
Number = '+441234567890' AND
MessageOut.Id IN (SELECT
...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]
Last message sent to this number:
...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?
Most Users Ever Online: 494
Currently Browsing this Page:
Guest Posters: 546
Newest Members:, Henk Helmantel
Administrators: Henk Helmantel: 1073