Support forum

Home Support forum Using Diafaan SMS Server Load sms to be sent from stored pro…

Load sms to be sent from stored procedure

Add Reply

Add Topic

May 26, 2017
1:24 pm

Diego Caprino

Guest

Guests

Quote

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: 1488

Member Since:
May 28, 2013

Offline

Quote

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

Quote

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

Add Reply

Add Topic

Forum Timezone: Europe/Amsterdam

Most Users Ever Online: 529

Currently Online:
5 Guest(s)

Currently Browsing this Page:
1 Guest(s)