Support forum

The script snippet is based on the headers of the 'SendMessagesFromCSVFile.cs' script from the Scripting Pack. As a minimum you have to add the following lines from the the 'SendMessagesFromCSVFile.cs' script to your own script:

- On line 3:
// AddReference Microsoft.VisualBasic.dll

- On lines 9 and 10:
using System.IO;
using Microsoft.VisualBasic.FileIO;

Regards, Henk

I have updated the script snippet to eliminate the error message.

Regards, Henk

The following script snippet reads a CSV file when a message is received from number '+5555555555' and forwards the message to all numbers in the first field of each row of the CSV file. The snippet is based on the 'AddReference' and 'using' header definitions in the 'SendMessagesFromCSVFile.cs' script example file.

		private string csvNumbersFileName = @"c:\temp\numbers.csv";
		private void OnMessageReceived(string fromAddress, string toAddress, string message, string messageType,
																		string messageId, string smsc, string pdu, string gateway,
																		DateTime sendTime, DateTime receiveTime)
		{
			try {
				if (fromAddress == "+5555555555") {
					if (File.Exists(csvNumbersFileName)) {
						using (TextFieldParser parser = new TextFieldParser(csvNumbersFileName)) {
							parser.TextFieldType = FieldType.Delimited;
							parser.SetDelimiters(",");
							while (!parser.EndOfData) {
								//Processing row
								string[] fields = parser.ReadFields();
								// The first field in the row is the destination number
								if (fields.Length >= 1) {
									PostSendMessage(fields[0], "", message, "", "", "", "", 0);
								}
							}
						}
					}
				}
			}
			catch (Exception ex) {
				PostEventLog(ex.Message, ex.ToString(), EventLog.Error);
			}
		}

Regards, Henk

Hello Leo,

Diafaan SMS Server does not have the built-in functionality to import SMS messages from a CSV file and send them. But it is possible to use a Scripting Connector with a custom script to import CSV files.

You can find an example C# script to import CSV files in the Scripting Pack on the download page. The script is called 'SendMessagesFromCSVFile.cs', it is located in the 'ConnectorScripts' folder of the ZIP file.

Regards, Henk