Re: Best way to send bulk SMS

2020-08-31 Thread Loyc Cossou 
Hi Rene,

You're right. The table is indeed "send_sms". I misstyped the request.
But the issue is the same.

What can be the other problem?

--
loyc Cossou

[image: Mailtrack]
<https://mailtrack.io?utm_source=gmail_medium=signature_campaign=signaturevirality5;>
Sender
notified by
Mailtrack
<https://mailtrack.io?utm_source=gmail_medium=signature_campaign=signaturevirality5;>
31/08/20
à 09:11:45

Le dim. 30 août 2020 à 20:03, Rene Kluwen  a écrit :

> As I recall it should be the send_sms table that you need to insert to.
>
> Or at least the table that is indicated in the sql-insert-table config
> value.
>
>
>
> == Rene
>
>
>
> *Van:* Loyc Cossou 
> *Verzonden:* zondag 30 augustus 2020 12:10
> *Aan:* Rene Kluwen 
> *CC:* kannel users@kannel.org 
> *Onderwerp:* Re: Best way to send bulk SMS
>
>
>
> Hi,
>
>
>
> I tried and got the same result. Almost, be the first sql that I ran was
> successful as the SMS was delivered. But the other SQL commands got
> unsuccessful.
>
> Here is the command:
>
> *INSERT INTO `sent_sms` SET *
>
> *`momt` = 'MT',*
>
> *`sender` = 'senderHere',*
>
> *`receiver` = 'numberHere',*
>
> *`msgdata` = 'TheTestOfTheMessage',*
>
> *`time` = UNIX_TIMESTAMP(NOW()),*
>
> *`smsc_id` = 'existingSMSC',*
>
> *`service` = 'existingService',*
>
> *`sms_type` = 2,*
>
> *`coding` = 0,*
>
> *`dlr_mask` = 19,*
>
> *`dlr_url` = 'kfghgf',*
>
> *`pid` = 0,*
>
> *`alt_dcs` = 0,*
>
> *`boxc_id` = 'TestHi',*
>
> *`meta_data` = '?smpp?',*
>
> *`priority` = 0*
>
>
>
> Any advise?
>
>
>
> Thanks
>
>
>
>
> --
> loyc Cossou
>
>
>
> [image: Afbeelding verwijderd door afzender. Mailtrack]
> <https://mailtrack.io/?utm_source=gmail_medium=signature_campaign=signaturevirality5;>
>
> Sender notified by
> Mailtrack
> <https://mailtrack.io?utm_source=gmail_medium=signature_campaign=signaturevirality5;>
>  30/08/20
> à 11:07:29
>
>
>
> Le jeu. 20 août 2020 à 14:22, Loyc Cossou  a écrit :
>
> Let me give a try again.
>
>
>
> I'll update you soon.
>
>
>
> Thanks for your response;
>
>
> --
> loyc Cossou
>
>
>
> [image: Afbeelding verwijderd door afzender. Mailtrack]
> <https://mailtrack.io/?utm_source=gmail_medium=signature_campaign=signaturevirality5;>
>
> Sender notified by
> Mailtrack
> <https://mailtrack.io?utm_source=gmail_medium=signature_campaign=signaturevirality5;>
>  20/08/20
> à 14:22:22
>
>
>
> Le jeu. 20 août 2020 à 13:55, Rene Kluwen  a
> écrit :
>
> It should work. What values are you inserting?
>
> What do your log files say?
>
>
>
> == Rene
>
>
>
> *Van:* Loyc Cossou 
> *Verzonden:* donderdag 20 augustus 2020 14:26
> *Aan:* Rene Kluwen 
> *CC:* kannel users@kannel.org 
> *Onderwerp:* Re: Best way to send bulk SMS
>
>
>
> Hi,
>
>
>
> I already SQLBox, but seems I need to improve my expertise.
>
>
>
> Currently SQLbox handles all the traffic from SMPPBox well. But when I try
> to manually insert the data in the "send" table it never delivers the SMS -
> I might be wrong somewhere.
>
>
>
> Regards
>
>
> --
> loyc Cossou
>
>
>
> [image: Afbeelding verwijderd door afzender. Mailtrack]
> <https://mailtrack.io/?utm_source=gmail_medium=signature_campaign=signaturevirality5;>
>
> Sender notified by
> Mailtrack
> <https://mailtrack.io?utm_source=gmail_medium=signature_campaign=signaturevirality5;>
>  20/08/20
> à 13:02:10
>
>
>
> Le jeu. 20 août 2020 à 08:11, Rene Kluwen  a
> écrit :
>
> Sqlbox is an alternative, or otherwise the commercial Speedbox add-on.
>
>
>
> == Rene
>
>
>
> *Van:* users  *Namens *Loyc Cossou
> *Verzonden:* donderdag 20 augustus 2020 02:26
> *Aan:* kannel users@kannel.org 
> *Onderwerp:* Best way to send bulk SMS
>
>
>
> Hi,
>
>
>
> I have a complete Kannel Setup working fine ( kannel, SQLBox, SMPPBox).
> It's great for sending SMS 1 by 1 and excellent for my SMPP Clients.
>
>
>
> Now I struggle in sending bulk SMS. So far the only way is to make a
> program that sends 1 by 1 in loop. I would like to know if kannel offers
> another way to send SMS in Bulk more easily.
>
>
>
> Any suggestion Please?
>
>
>
> Kind regards.
>
>
> --
> loyc Cossou
>
>
>
> [image: Afbeelding verwijderd door afzender. Mailtrack]
> <https://mailtrack.io/?utm_source=gmail_medium=signature_campaign=signaturevirality5;>
>
> Sender notified by
> Mailtrack
> <https://mailtrack.io?utm_source=gmail_medium=signature_campaign=signaturevirality5;>
>  20/08/20
> à 01:22:43
>
> [image: Afbeelding verwijderd door afzender.]
>
> [image: Afbeelding verwijderd door afzender.]
>
> *Fout! Bestandsnaam niet opgegeven.*
>
> [image: Afbeelding verwijderd door afzender.]
>

RE: Best way to send bulk SMS

2020-08-30 Thread Rene Kluwen 
As I recall it should be the send_sms table that you need to insert to.

Or at least the table that is indicated in the sql-insert-table config value.

 

== Rene

 

Van: Loyc Cossou  
Verzonden: zondag 30 augustus 2020 12:10
Aan: Rene Kluwen 
CC: kannel users@kannel.org 
Onderwerp: Re: Best way to send bulk SMS

 

Hi,

 

I tried and got the same result. Almost, be the first sql that I ran was 
successful as the SMS was delivered. But the other SQL commands got 
unsuccessful.

Here is the command:

INSERT INTO `sent_sms` SET 

`momt` = 'MT',

`sender` = 'senderHere',

`receiver` = 'numberHere',

`msgdata` = 'TheTestOfTheMessage',

`time` = UNIX_TIMESTAMP(NOW()),

`smsc_id` = 'existingSMSC',

`service` = 'existingService',

`sms_type` = 2,

`coding` = 0,

`dlr_mask` = 19,

`dlr_url` = 'kfghgf',

`pid` = 0,

`alt_dcs` = 0,

`boxc_id` = 'TestHi',

`meta_data` = '?smpp?',

`priority` = 0

 

Any advise?

 

Thanks

 


--
loyc Cossou

 


 
<https://mailtrack.io/?utm_source=gmail_medium=signature_campaign=signaturevirality5;>
 

Sender notified by 
 
<https://mailtrack.io?utm_source=gmail_medium=signature_campaign=signaturevirality5;>
 Mailtrack 30/08/20 à 11:07:29 



 

Le jeu. 20 août 2020 à 14:22, Loyc Cossou mailto:loycos...@gmail.com> > a écrit :

Let me give a try again.

 

I'll update you soon.

 

Thanks for your response;


--
loyc Cossou

 


 
<https://mailtrack.io/?utm_source=gmail_medium=signature_campaign=signaturevirality5;>
 

Sender notified by 
 
<https://mailtrack.io?utm_source=gmail_medium=signature_campaign=signaturevirality5;>
 Mailtrack 20/08/20 à 14:22:22 



 

Le jeu. 20 août 2020 à 13:55, Rene Kluwen mailto:rene.klu...@chimit.nl> > a écrit :

It should work. What values are you inserting?

What do your log files say?

 

== Rene

 

Van: Loyc Cossou mailto:loycos...@gmail.com> > 
Verzonden: donderdag 20 augustus 2020 14:26
Aan: Rene Kluwen mailto:rene.klu...@chimit.nl> >
CC: kannel users@kannel.org <mailto:users@kannel.org>  mailto:users@kannel.org> >
Onderwerp: Re: Best way to send bulk SMS

 

Hi,

 

I already SQLBox, but seems I need to improve my expertise.

 

Currently SQLbox handles all the traffic from SMPPBox well. But when I try to 
manually insert the data in the "send" table it never delivers the SMS - I 
might be wrong somewhere.

 

Regards


--
loyc Cossou

 


 
<https://mailtrack.io/?utm_source=gmail_medium=signature_campaign=signaturevirality5;>
 

Sender notified by 
 
<https://mailtrack.io?utm_source=gmail_medium=signature_campaign=signaturevirality5;>
 Mailtrack 20/08/20 à 13:02:10 



 

Le jeu. 20 août 2020 à 08:11, Rene Kluwen mailto:rene.klu...@chimit.nl> > a écrit :

Sqlbox is an alternative, or otherwise the commercial Speedbox add-on.

 

== Rene

 

Van: users mailto:users-boun...@kannel.org> > Namens 
Loyc Cossou
Verzonden: donderdag 20 augustus 2020 02:26
Aan: kannel users@kannel.org <mailto:users@kannel.org>  mailto:users@kannel.org> >
Onderwerp: Best way to send bulk SMS

 

Hi,

 

I have a complete Kannel Setup working fine ( kannel, SQLBox, SMPPBox). It's 
great for sending SMS 1 by 1 and excellent for my SMPP Clients.

 

Now I struggle in sending bulk SMS. So far the only way is to make a program 
that sends 1 by 1 in loop. I would like to know if kannel offers another way to 
send SMS in Bulk more easily.

 

Any suggestion Please?

 

Kind regards.


--
loyc Cossou

 


 
<https://mailtrack.io/?utm_source=gmail_medium=signature_campaign=signaturevirality5;>
 

Sender notified by 
 
<https://mailtrack.io?utm_source=gmail_medium=signature_campaign=signaturevirality5;>
 Mailtrack 20/08/20 à 01:22:43 







Fout! Bestandsnaam niet opgegeven.

Re: Best way to send bulk SMS

2020-08-30 Thread Loyc Cossou 
Hi,

I tried and got the same result. Almost, be the first sql that I ran was
successful as the SMS was delivered. But the other SQL commands got
unsuccessful.
Here is the command:

*INSERT INTO `sent_sms` SET *
*`momt` = 'MT',*
*`sender` = 'senderHere',*
*`receiver` = 'numberHere',*
*`msgdata` = 'TheTestOfTheMessage',*
*`time` = UNIX_TIMESTAMP(NOW()),*
*`smsc_id` = 'existingSMSC',*
*`service` = 'existingService',*
*`sms_type` = 2,*
*`coding` = 0,*
*`dlr_mask` = 19,*
*`dlr_url` = 'kfghgf',*
*`pid` = 0,*
*`alt_dcs` = 0,*
*`boxc_id` = 'TestHi',*
*`meta_data` = '?smpp?',*
*`priority` = 0*


Any advise?

Thanks


--
loyc Cossou

[image: Mailtrack]
<https://mailtrack.io?utm_source=gmail_medium=signature_campaign=signaturevirality5;>
Sender
notified by
Mailtrack
<https://mailtrack.io?utm_source=gmail_medium=signature_campaign=signaturevirality5;>
30/08/20
à 11:07:29

Le jeu. 20 août 2020 à 14:22, Loyc Cossou  a écrit :

> Let me give a try again.
>
> I'll update you soon.
>
> Thanks for your response;
>
> --
> loyc Cossou
>
> [image: Mailtrack]
> <https://mailtrack.io?utm_source=gmail_medium=signature_campaign=signaturevirality5;>
>  Sender
> notified by
> Mailtrack
> <https://mailtrack.io?utm_source=gmail_medium=signature_campaign=signaturevirality5;>
>  20/08/20
> à 14:22:22
>
> Le jeu. 20 août 2020 à 13:55, Rene Kluwen  a
> écrit :
>
>> It should work. What values are you inserting?
>>
>> What do your log files say?
>>
>>
>>
>> == Rene
>>
>>
>>
>> *Van:* Loyc Cossou 
>> *Verzonden:* donderdag 20 augustus 2020 14:26
>> *Aan:* Rene Kluwen 
>> *CC:* kannel users@kannel.org 
>> *Onderwerp:* Re: Best way to send bulk SMS
>>
>>
>>
>> Hi,
>>
>>
>>
>> I already SQLBox, but seems I need to improve my expertise.
>>
>>
>>
>> Currently SQLbox handles all the traffic from SMPPBox well. But when I
>> try to manually insert the data in the "send" table it never delivers the
>> SMS - I might be wrong somewhere.
>>
>>
>>
>> Regards
>>
>>
>> --
>> loyc Cossou
>>
>>
>>
>> [image: Afbeelding verwijderd door afzender. Mailtrack]
>> <https://mailtrack.io/?utm_source=gmail_medium=signature_campaign=signaturevirality5;>
>>
>> Sender notified by
>> Mailtrack
>> <https://mailtrack.io?utm_source=gmail_medium=signature_campaign=signaturevirality5;>
>>  20/08/20
>> à 13:02:10
>>
>>
>>
>> Le jeu. 20 août 2020 à 08:11, Rene Kluwen  a
>> écrit :
>>
>> Sqlbox is an alternative, or otherwise the commercial Speedbox add-on.
>>
>>
>>
>> == Rene
>>
>>
>>
>> *Van:* users  *Namens *Loyc Cossou
>> *Verzonden:* donderdag 20 augustus 2020 02:26
>> *Aan:* kannel users@kannel.org 
>> *Onderwerp:* Best way to send bulk SMS
>>
>>
>>
>> Hi,
>>
>>
>>
>> I have a complete Kannel Setup working fine ( kannel, SQLBox, SMPPBox).
>> It's great for sending SMS 1 by 1 and excellent for my SMPP Clients.
>>
>>
>>
>> Now I struggle in sending bulk SMS. So far the only way is to make a
>> program that sends 1 by 1 in loop. I would like to know if kannel offers
>> another way to send SMS in Bulk more easily.
>>
>>
>>
>> Any suggestion Please?
>>
>>
>>
>> Kind regards.
>>
>>
>> --
>> loyc Cossou
>>
>>
>>
>> [image: Afbeelding verwijderd door afzender. Mailtrack]
>> <https://mailtrack.io/?utm_source=gmail_medium=signature_campaign=signaturevirality5;>
>>
>> Sender notified by
>> Mailtrack
>> <https://mailtrack.io?utm_source=gmail_medium=signature_campaign=signaturevirality5;>
>>  20/08/20
>> à 01:22:43
>>
>> [image: Afbeelding verwijderd door afzender.]
>>
>> [image: Afbeelding verwijderd door afzender.]
>>
>

Re: Best way to send bulk SMS

2020-08-20 Thread Loyc Cossou 
Let me give a try again.

I'll update you soon.

Thanks for your response;

--
loyc Cossou

[image: Mailtrack]
<https://mailtrack.io?utm_source=gmail_medium=signature_campaign=signaturevirality5;>
Sender
notified by
Mailtrack
<https://mailtrack.io?utm_source=gmail_medium=signature_campaign=signaturevirality5;>
20/08/20
à 14:22:22

Le jeu. 20 août 2020 à 13:55, Rene Kluwen  a écrit :

> It should work. What values are you inserting?
>
> What do your log files say?
>
>
>
> == Rene
>
>
>
> *Van:* Loyc Cossou 
> *Verzonden:* donderdag 20 augustus 2020 14:26
> *Aan:* Rene Kluwen 
> *CC:* kannel users@kannel.org 
> *Onderwerp:* Re: Best way to send bulk SMS
>
>
>
> Hi,
>
>
>
> I already SQLBox, but seems I need to improve my expertise.
>
>
>
> Currently SQLbox handles all the traffic from SMPPBox well. But when I try
> to manually insert the data in the "send" table it never delivers the SMS -
> I might be wrong somewhere.
>
>
>
> Regards
>
>
> --
> loyc Cossou
>
>
>
> [image: Afbeelding verwijderd door afzender. Mailtrack]
> <https://mailtrack.io/?utm_source=gmail_medium=signature_campaign=signaturevirality5;>
>
> Sender notified by
> Mailtrack
> <https://mailtrack.io?utm_source=gmail_medium=signature_campaign=signaturevirality5;>
>  20/08/20
> à 13:02:10
>
>
>
> Le jeu. 20 août 2020 à 08:11, Rene Kluwen  a
> écrit :
>
> Sqlbox is an alternative, or otherwise the commercial Speedbox add-on.
>
>
>
> == Rene
>
>
>
> *Van:* users  *Namens *Loyc Cossou
> *Verzonden:* donderdag 20 augustus 2020 02:26
> *Aan:* kannel users@kannel.org 
> *Onderwerp:* Best way to send bulk SMS
>
>
>
> Hi,
>
>
>
> I have a complete Kannel Setup working fine ( kannel, SQLBox, SMPPBox).
> It's great for sending SMS 1 by 1 and excellent for my SMPP Clients.
>
>
>
> Now I struggle in sending bulk SMS. So far the only way is to make a
> program that sends 1 by 1 in loop. I would like to know if kannel offers
> another way to send SMS in Bulk more easily.
>
>
>
> Any suggestion Please?
>
>
>
> Kind regards.
>
>
> --
> loyc Cossou
>
>
>
> [image: Afbeelding verwijderd door afzender. Mailtrack]
> <https://mailtrack.io/?utm_source=gmail_medium=signature_campaign=signaturevirality5;>
>
> Sender notified by
> Mailtrack
> <https://mailtrack.io?utm_source=gmail_medium=signature_campaign=signaturevirality5;>
>  20/08/20
> à 01:22:43
>
> [image: Afbeelding verwijderd door afzender.]
>
> [image: Afbeelding verwijderd door afzender.]
>

RE: Best way to send bulk SMS

2020-08-20 Thread Rene Kluwen 
It should work. What values are you inserting?

What do your log files say?

 

== Rene

 

Van: Loyc Cossou  
Verzonden: donderdag 20 augustus 2020 14:26
Aan: Rene Kluwen 
CC: kannel users@kannel.org 
Onderwerp: Re: Best way to send bulk SMS

 

Hi,

 

I already SQLBox, but seems I need to improve my expertise.

 

Currently SQLbox handles all the traffic from SMPPBox well. But when I try to 
manually insert the data in the "send" table it never delivers the SMS - I 
might be wrong somewhere.

 

Regards


--
loyc Cossou

 


 
<https://mailtrack.io/?utm_source=gmail_medium=signature_campaign=signaturevirality5;>
 

Sender notified by 
 
<https://mailtrack.io?utm_source=gmail_medium=signature_campaign=signaturevirality5;>
 Mailtrack 20/08/20 à 13:02:10 



 

Le jeu. 20 août 2020 à 08:11, Rene Kluwen mailto:rene.klu...@chimit.nl> > a écrit :

Sqlbox is an alternative, or otherwise the commercial Speedbox add-on.

 

== Rene

 

Van: users mailto:users-boun...@kannel.org> > Namens 
Loyc Cossou
Verzonden: donderdag 20 augustus 2020 02:26
Aan: kannel users@kannel.org <mailto:users@kannel.org>  mailto:users@kannel.org> >
Onderwerp: Best way to send bulk SMS

 

Hi,

 

I have a complete Kannel Setup working fine ( kannel, SQLBox, SMPPBox). It's 
great for sending SMS 1 by 1 and excellent for my SMPP Clients.

 

Now I struggle in sending bulk SMS. So far the only way is to make a program 
that sends 1 by 1 in loop. I would like to know if kannel offers another way to 
send SMS in Bulk more easily.

 

Any suggestion Please?

 

Kind regards.


--
loyc Cossou

 


 
<https://mailtrack.io/?utm_source=gmail_medium=signature_campaign=signaturevirality5;>
 

Sender notified by 
 
<https://mailtrack.io?utm_source=gmail_medium=signature_campaign=signaturevirality5;>
 Mailtrack 20/08/20 à 01:22:43

Re: Best way to send bulk SMS

2020-08-20 Thread Loyc Cossou 
Hi,

I already SQLBox, but seems I need to improve my expertise.

Currently SQLbox handles all the traffic from SMPPBox well. But when I try
to manually insert the data in the "send" table it never delivers the SMS -
I might be wrong somewhere.

Regards

--
loyc Cossou

[image: Mailtrack]

Sender
notified by
Mailtrack

20/08/20
à 13:02:10

Le jeu. 20 août 2020 à 08:11, Rene Kluwen  a écrit :

> Sqlbox is an alternative, or otherwise the commercial Speedbox add-on.
>
>
>
> == Rene
>
>
>
> *Van:* users  *Namens *Loyc Cossou
> *Verzonden:* donderdag 20 augustus 2020 02:26
> *Aan:* kannel users@kannel.org 
> *Onderwerp:* Best way to send bulk SMS
>
>
>
> Hi,
>
>
>
> I have a complete Kannel Setup working fine ( kannel, SQLBox, SMPPBox).
> It's great for sending SMS 1 by 1 and excellent for my SMPP Clients.
>
>
>
> Now I struggle in sending bulk SMS. So far the only way is to make a
> program that sends 1 by 1 in loop. I would like to know if kannel offers
> another way to send SMS in Bulk more easily.
>
>
>
> Any suggestion Please?
>
>
>
> Kind regards.
>
>
> --
> loyc Cossou
>
>
>
> [image: Afbeelding verwijderd door afzender. Mailtrack]
> 
>
> Sender notified by
> Mailtrack
> 
>  20/08/20
> à 01:22:43
>
> [image: Afbeelding verwijderd door afzender.]
>

RE: Best way to send bulk SMS

2020-08-20 Thread Rene Kluwen 
Sqlbox is an alternative, or otherwise the commercial Speedbox add-on.

 

== Rene

 

Van: users  Namens Loyc Cossou
Verzonden: donderdag 20 augustus 2020 02:26
Aan: kannel users@kannel.org 
Onderwerp: Best way to send bulk SMS

 

Hi,

 

I have a complete Kannel Setup working fine ( kannel, SQLBox, SMPPBox). It's 
great for sending SMS 1 by 1 and excellent for my SMPP Clients.

 

Now I struggle in sending bulk SMS. So far the only way is to make a program 
that sends 1 by 1 in loop. I would like to know if kannel offers another way to 
send SMS in Bulk more easily.

 

Any suggestion Please?

 

Kind regards.


--
loyc Cossou

 


 

 

Sender notified by 
 

 Mailtrack 20/08/20 à 01:22:43