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 18, 2016
10:26 am
Henk Helmantel
Admin
Forum Posts: 1487
Member Since:
May 28, 2013
sp_UserOfflineSmall Offline

We have not tested the Portech MV-374 with Diafaan SMS Server, only the Portech MV-370, and I can't give you much information about the use of the Portech MV-374 device.

In general, Diafaan SMS Server must be able to log in to the Portech modem with a telnet connection and send AT commands to use the device. Your log shows that the telnet connection to port 8023 does not give a 'login' response when Diafaan SMS Server opens the connection. You can try to use a telnet program like PuTTY to set up manual connections to the Portech MV-374 modem ports to see which ports work and whether opening multiple concurrent connections to the device work as well as a single connection.

Regards, Henk

December 16, 2016
4:00 pm
Peter
Guest
Guests

Hello Henk

Thank you so match for your answers, the script works very well. -_-

I have change (",") by (";") on the script
I have use 2 colums in my CSV file(A and B) because it is already with semicolon format.

Result: The script sent all of the sms in the csv file using the 8123 port of my prothech MV-374 gateway whitch support 2 modules=4 SIM cards .

Furthermore, when i want use the 8023 port (second port), by adding another GSM modem, i receive the following message by "show logs":

- Open port: TCP/IP:115200,n,8,1:10.43.11.203:8023
> AT&FE0

- Timeout
- Port closed

Do you now how i can send the sms using two port together ? in order to use 4 SIM cards.

Thank you for your reply

December 16, 2016
10:08 am
Henk Helmantel
Admin
Forum Posts: 1487
Member Since:
May 28, 2013
sp_UserOfflineSmall Offline

Hello Peter,

The most likely reason for this behavior is that the format of the CSV file is not what the script expects. Each line in the CSV file should contain
two fields, separated by comma's. The first field is the destination number and the second field is the text of the message. The field should be quoted if it contains reserved characters like the comma or a new line character. E.g.:

+11111111111,"First message"
+12222222222,"Second message,
two lines"

Your post suggests that you use the semicolon (';') as the field separator. It is possible to use the semicolon but you'll have to change line 47 of the script to 'parser.SetDelimiters(";");' to change the field separator character.

Regards, Henk

December 15, 2016
6:14 pm
Peter
Guest
Guests

I have tested the SendMessagesFromCSVFile.cs script.

The script removes the CSV file but don't send the messages list to the recipients (column 1: mobile numbers;column 2: corresponding text message).

Thank you for your help

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: 1487
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: 1487
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: 529

Currently Online:
3 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