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
Load sms to be sent from stored procedure
sp_NewPost Add Reply sp_NewTopic Add Topic
May 26, 2017
1:24 pm
Diego Caprino
Guest
Guests

Hi, that's perfect. It's working.

I need to work with SPs to generate the SMS content, using the client's information.

Thanks. I will be testing it before buying.

May 25, 2017
10:21 am
Henk Helmantel
Admin
Forum Posts: 740
Member Since:
May 28, 2013
sp_UserOfflineSmall Offline

Hello Diego,

I am not entirely sure how you would use a stored procedure in SQL Server to generate the SMS messages. In general, you only have to fill the MessageTo and MessageText fields of the MessageOut database table. Diafaan SMS Server then reads the records from the table, removes the records and sends the messages. The MessageLog table is used by Diafaan SMS Server to log the sent or failed SMS messages, it should not be used to insert your own messages.

A minimal SQL query to send an SMS message is:

INSERT INTO MessageOut
(MessageTo,MessageText)
VALUES
('+54115377xxxx','test 4');

The error:
'300, Error: No active SMS gateway available to send this message.'
means that Diafaan SMS Server is not able to route the message to one of the gateways. It is possible that you have no gateway defined for the SQL Connector, the gateway(s) may not be available or you have another routing filter enabled that prevents a valid route of the message to one of the gateways.

Regards, Henk

May 24, 2017
4:16 pm
Diego Caprino
Guest
Guests

Hello, I need to load the [MessageOut] table, using a stored procedure in SQL SERVER.

I was trying to use something like:

INSERT INTO MessageLog
(SendTime,MessageFrom,MessageTo,MessageText,
MessageType,MessageId,StatusCode,Gateway,
MessagePDU,StatusText,ErrorCode,ErrorText,
UserId,UserInfo,Connector,MessageParts)
VALUES (getdate(),'','+54115377xxxx','test 4',
'sms.automatic','1:+54115377xxxx:12',200,'GSM ARNETGO',
'test','test','','',
'1','','',1)

But It's not working, I don't know how to complete the MessagePDU field, on the logs I see:
300, Error: No active SMS gateway available to send this message.

is there any way to load de messageout table? I don't want to use http, c#, vbnet. just a simple stored procedure. I need to send aprox 10.000 sms every day per simcard.

Thanks

Forum Timezone: Europe/Amsterdam

Most Users Ever Online: 494

Currently Online:
8 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

Member Stats:

Guest Posters: 439

Members: 0

Moderators: 0

Admins: 1

Forum Stats:

Groups: 2

Forums: 3

Topics: 656

Posts: 2250

Newest Members:

, Henk Helmantel

Administrators: Henk Helmantel: 740