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
Scheduling SMS messages
sp_NewPost Add Reply sp_NewTopic Add Topic
April 6, 2012
9:13 pm
Luis Villar
Guest
Guests

Hi Henk, I found out what my problem was, I installed the Diafaan server on a separate machine than where the database is installed and that machine was 1 hour ahead therefore my 15 seconds of delay was not working because for the server that had the Diafaan both messages where 1 hour past due their sending. I fixed the time and it is now working perfect.

Thank you for your quick response

Luis

April 6, 2012
5:09 pm
Henk Helmantel
Guest
Guests

Hi Luis,

Please check if you have added the name of the database field ('Scheduled') in the SMSOutScheduled property of the Advanced settings of the SQL Connector. If that is the case, it should work.

The SQL Connector reads only those records where the value of the Scheduled field is smaller than the current date. It might not work for some databases or some date/time functions (we tested with MySQL and Microsoft SQL Server). If you still have problems, please send the Configuration file to dms at diafaan dot com and I will have a look at it. (Select File-Export-Configuration to save the configuration to file).

Regards, Henk

April 6, 2012
7:18 am
Luis Villar
Guest
Guests

Hello, my name and I am evaluating your product and so far after a few installation and configuration bumps I got it working and it works great. the only thing I have not been able to do is to schedule a SMS message. I am using the SQL Connector.
I add two messages at the same time but I want the first message to be sent immediately and the second message 15 seconds later. I put in the "Scheduled" field on the MessageOut table get date() on the first message and then on the second I put "DATEADD(SECOND,15,GETDATE())" on the "Scheduled" field so that it is schedule to be sent 15 seconds later but both messages are sent at the same time, immediately. what else do I need to do to use the Schedule feature.

Thank you for your assistance.

Forum Timezone: Europe/Amsterdam

Most Users Ever Online: 494

Currently Online:
7 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

Member Stats:

Guest Posters: 364

Members: 0

Moderators: 0

Admins: 1

Forum Stats:

Groups: 2

Forums: 3

Topics: 532

Posts: 1844

Newest Members:

, Henk Helmantel

Administrators: Henk Helmantel: 551