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
Script CSV File
sp_NewPost Add Reply sp_NewTopic Add Topic
March 22, 2017
10:27 am
Henk Helmantel
Admin
Forum Posts: 730
Member Since:
May 28, 2013
sp_UserOfflineSmall Offline

There is no other configuration setting necessary after you have created the Scripting Connector and replaced the default script with the 'SendMessagesFromCSVFile.cs' script.

The fact that the CSV file disappears means that the script is working. I can think of only two reasons why the messages still don't show up in the send log:
1. The format of the CSV file is still incorrect.
or
2. You are using the script in a Scripting Gateway instead of a Scripting Connector

When you are certain that the two point above are not the cause of the problem, you can try to set debugging points in the script to find out what goes wrong. You can use the 'PostEventLog' function in the script to write debug information to the event log of Diafaan SMS Server.

Regards, Henk

March 21, 2017
4:28 pm
LucasRodrigues
Guest
Guests

Hi Henk, ty for answer,

I change my files to format, butt file is removed and dont registri logs.

Have other configuration is needed to register the logs files ??

March 21, 2017
2:10 pm
Henk Helmantel
Admin
Forum Posts: 730
Member Since:
May 28, 2013
sp_UserOfflineSmall Offline

Hello Lucas,

The script expects a CSV file with two fields per line, the destination number and the message text, separated by comma's. For instance:

+51980477570,Teste
+51980477570,meloa
etc...

Regards, Henk

March 21, 2017
11:39 am
LucasRodrigues
Guest
Guests

Hi Everyone,

I have a problem with script to import CSV file to Diafaan, i putt messages.csv on c:\temp\, when i start Diafaan the file desaper, butt on send Queue or send log dont show a information.

in CSV file i use this collumns

ID MessageTo MessageFrom MessageText MEssageType Gateway UserId UserInfo Priority Scheduled ValidityPeriod IsRead IsSent

is right?

i am using a emulator gateway, i want to buy the software, butt i need this function working.

Ty for help.

test CS file i using:

ID;MessageTo;MessageFrom;MessageText;MEssageType;Gateway;UserId;UserInfo;Priority;Scheduled;ValidityPeriod;IsRead;IsSent
1;51980477570;51980477570;Teste;SMS;1;;;;;;;
2;51980477570;51980477570;meloa;SMS;1;;;;;;;
3;51980477570;51980477570;Teste;SMS;1;;;;;;;
4;51980477570;51980477570;meloa;SMS;1;;;;;;;
5;51980477570;51980477570;Teste;SMS;1;;;;;;;
6;51980477570;51980477570;meloa;SMS;1;;;;;;;
7;51980477570;51980477570;Teste;SMS;1;;;;;;;
8;51980477570;51980477570;meloa;SMS;1;;;;;;;
9;51980477570;51980477570;Teste;SMS;1;;;;;;;
10;51980477570;51980477570;meloa;SMS;1;;;;;;;
11;51980477570;51980477570;Teste;SMS;1;;;;;;;
12;51980477570;51980477570;meloa;SMS;1;;;;;;;
13;51980477570;51980477570;Teste;SMS;1;;;;;;;
14;51980477570;51980477570;meloa;SMS;1;;;;;;;
15;51980477570;51980477570;Teste;SMS;1;;;;;;;
16;51980477570;51980477570;meloa;SMS;1;;;;;;;
17;51980477570;51980477570;Teste;SMS;1;;;;;;;
18;51980477570;51980477570;meloa;SMS;1;;;;;;;
19;51980477570;51980477570;Teste;SMS;1;;;;;;;
20;51980477570;51980477570;meloa;SMS;1;;;;;;;
21;51980477570;51980477570;Teste;SMS;1;;;;;;;
22;51980477570;51980477570;meloa;SMS;1;;;;;;;
23;51980477570;51980477570;Teste;SMS;1;;;;;;;
24;51980477570;51980477570;meloa;SMS;1;;;;;;;
25;51980477570;51980477570;Teste;SMS;1;;;;;;;
26;51980477570;51980477570;meloa;SMS;1;;;;;;;
27;51980477570;51980477570;Teste;SMS;1;;;;;;;
28;51980477570;51980477570;meloa;SMS;1;;;;;;;
29;51980477570;51980477570;Teste;SMS;1;;;;;;;
30;51980477570;51980477570;meloa;SMS;1;;;;;;;
31;51980477570;51980477570;Teste;SMS;1;;;;;;;
32;51980477570;51980477570;meloa;SMS;1;;;;;;;
33;51980477570;51980477570;Teste;SMS;1;;;;;;;
34;51980477570;51980477570;meloa;SMS;1;;;;;;;
35;51980477570;51980477570;Teste;SMS;;;;;;;;

Forum Timezone: Europe/Amsterdam

Most Users Ever Online: 494

Currently Online:
2 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

Member Stats:

Guest Posters: 434

Members: 0

Moderators: 0

Admins: 1

Forum Stats:

Groups: 2

Forums: 3

Topics: 651

Posts: 2226

Newest Members:

, Henk Helmantel

Administrators: Henk Helmantel: 730