Thanks Henk. I will try this solution.
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.
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?
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.
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?
Most Users Ever Online: 494
Currently Browsing this Page:
Guest Posters: 354
Newest Members:, Henk Helmantel
Administrators: Henk Helmantel: 519