Support forum
Diafaan SMS Server does not have an option to load a CSV file to the MessageOut table of a database. In fact, it does not have any built-in option to import a list of messages from a .CSV file.
It is possible to use a Scripting Connector with a custom script that imports the messages from a CSV file. You can find an example script in the Scripting pack on the download page of this website. The script is located in the folder 'ConnectorScripts\SendMessagesFromCSVFile'.
Regards, Henk
4:24 pm
Hi Henk
Its not a big issue as i can check from the GW logs, i have just come across another issue but should i create a new Topic for it?
Issue i have is I am trying to upload a csv file to the MessageOut table but doesnt matter how i put the csv file it just wont load do you have a template i can work from to upload via csv?
Many Thanks
Kris
Which gateway device do you use and what protocol is used to send the SMS messages (SMPP or HTTP)?
Regards, Henk
3:15 pm
Hi Henk
Right ok that wont help me as the Gateway i have has more than 1 port so it wouldn't tell me, is their anything that may be added in the future?
Many Thanks
Kris
Hello Kris,
The MessageLog table in the SQL Connector does not have a field for the number of the modem port that sent the message, only for the name of the gateway that is associated with the port. The only way to get the number of the port that sent the message is to specify the number as the name of the gateway.
Regards, Henk
12:03 pm
Hi, i have installed and tested with great success with the Diafaan server and just wanted to ask that is it possible to have the message from Column like the MessageTo column from the MessageIn Table.
MessageIn Table has MessageTo column which shows the port of the GW it was sent too which is perfect and what i need, however on the MessageLog table it doesnt show me which port sent the message and only which Gateway was used.
Is their anyway to see what port sent the message i sent at all?
Many Thanks
Kris
Most Users Ever Online: 529
Currently Online:
6 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
Member Stats:
Guest Posters: 672
Members: 0
Moderators: 0
Admins: 1
Forum Stats:
Groups: 2
Forums: 3
Topics: 1141
Posts: 3899
Newest Members:
, Henk HelmantelAdministrators: Henk Helmantel: 1488