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
Licensed: Requirement to send multiple users with different messages from CSV
sp_NewPost Add Reply sp_NewTopic Add Topic
December 3, 2015
12:55 pm
Licensed User of the
Guest
Guests

Thanks Henk. I will try this solution.

December 2, 2015
2:53 pm
Henk Helmantel
Admin
Forum Posts: 553
Member Since:
May 28, 2013
sp_UserOfflineSmall Offline

Using an SQL Connector with a multi-user database like Microsoft SQL Server (Express) or MySQL is the best way to send different messages to a list of numbers with Diafaan SMS Server. The SQL Connector will read the records from the database, remove the records and send the messages one by one with the GSM modem or SMPP connection.

There is another solution if you really want to use a .CSV file, but it requires using (and perhaps changing) a C# script:
I have added a script to the Scripting Pack for Diafaan SMS Server that reads in a .CSV file from a specific location and sends a message for each row in the .CSV file.

To use the script, add a new Scripting Connector, replace the default script with the 'SendMessagesFromCSVFile.cs' script from the Scripting Pack and (optionally) change the 'csvFileName' parameter in the script to the full path and file name you want to use. You can then take a .CSV file, move or copy it to the specified location and the script will automatically read the information from the file, remove the file and send the messages.

Regards, Henk

December 2, 2015
12:45 pm
Licensed User of the
Guest
Guests

How should I send different messages to multiple users? Can we develop an SQL connector to fetch from tables and send by SMS. Is there any better solution than this?

December 2, 2015
11:40 am
Henk Helmantel
Admin
Forum Posts: 553
Member Since:
May 28, 2013
sp_UserOfflineSmall Offline

Diafaan SMS Server does not have an import feature to import a list of messages from a .CSV file and put them in the message queue.

Regards, Henk

December 2, 2015
10:14 am
Licensed User of the
Guest
Guests

Can I give a input as CSV which has one column contact info (Mobile number) and next column have the messages to send. Is it possible to load and send in single shot?

Forum Timezone: Europe/Amsterdam

Most Users Ever Online: 494

Currently Online:
11 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: 1847

Newest Members:

, Henk Helmantel

Administrators: Henk Helmantel: 553