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
SQL Message Log Table
sp_NewPost Add Reply sp_NewTopic Add Topic
January 5, 2018
3:27 pm
Henk Helmantel
Admin
Forum Posts: 932
Member Since:
May 28, 2013
sp_UserOfflineSmall Offline

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

January 4, 2018
4:24 pm
Kris
Guest
Guests

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

January 4, 2018
3:50 pm
Henk Helmantel
Admin
Forum Posts: 932
Member Since:
May 28, 2013
sp_UserOfflineSmall Offline

Which gateway device do you use and what protocol is used to send the SMS messages (SMPP or HTTP)?

Regards, Henk

January 4, 2018
3:15 pm
Kris
Guest
Guests

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

January 4, 2018
2:38 pm
Henk Helmantel
Admin
Forum Posts: 932
Member Since:
May 28, 2013
sp_UserOfflineSmall Offline

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

January 4, 2018
12:03 pm
Kris
Guest
Guests

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

Forum Timezone: Europe/Amsterdam

Most Users Ever Online: 494

Currently Online:
7 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

Member Stats:

Guest Posters: 497

Members: 0

Moderators: 0

Admins: 1

Forum Stats:

Groups: 2

Forums: 3

Topics: 771

Posts: 2659

Newest Members:

, Henk Helmantel

Administrators: Henk Helmantel: 932