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 <loycos...@gmail.com> Verzonden: zondag 30 augustus 2020 12:10 Aan: Rene Kluwen <rene.klu...@chimit.nl> CC: kannel users@kannel.org <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&utm_medium=signature&utm_campaign=signaturevirality5&;> Sender notified by <https://mailtrack.io?utm_source=gmail&utm_medium=signature&utm_campaign=signaturevirality5&;> Mailtrack 30/08/20 à 11:07:29 Le jeu. 20 août 2020 à 14:22, Loyc Cossou <loycos...@gmail.com <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&utm_medium=signature&utm_campaign=signaturevirality5&;> Sender notified by <https://mailtrack.io?utm_source=gmail&utm_medium=signature&utm_campaign=signaturevirality5&;> Mailtrack 20/08/20 à 14:22:22 Le jeu. 20 août 2020 à 13:55, Rene Kluwen <rene.klu...@chimit.nl <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 <loycos...@gmail.com <mailto:loycos...@gmail.com> > Verzonden: donderdag 20 augustus 2020 14:26 Aan: Rene Kluwen <rene.klu...@chimit.nl <mailto:rene.klu...@chimit.nl> > CC: kannel users@kannel.org <mailto:users@kannel.org> <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&utm_medium=signature&utm_campaign=signaturevirality5&;> Sender notified by <https://mailtrack.io?utm_source=gmail&utm_medium=signature&utm_campaign=signaturevirality5&;> Mailtrack 20/08/20 à 13:02:10 Le jeu. 20 août 2020 à 08:11, Rene Kluwen <rene.klu...@chimit.nl <mailto:rene.klu...@chimit.nl> > a écrit : Sqlbox is an alternative, or otherwise the commercial Speedbox add-on. == Rene Van: users <users-boun...@kannel.org <mailto:users-boun...@kannel.org> > Namens Loyc Cossou Verzonden: donderdag 20 augustus 2020 02:26 Aan: kannel users@kannel.org <mailto:users@kannel.org> <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&utm_medium=signature&utm_campaign=signaturevirality5&;> Sender notified by <https://mailtrack.io?utm_source=gmail&utm_medium=signature&utm_campaign=signaturevirality5&;> Mailtrack 20/08/20 à 01:22:43 Fout! Bestandsnaam niet opgegeven.
