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&utm_medium=signature&utm_campaign=signaturevirality5&> Sender notified by Mailtrack <https://mailtrack.io?utm_source=gmail&utm_medium=signature&utm_campaign=signaturevirality5&> 31/08/20 à 09:11:45 Le dim. 30 août 2020 à 20:03, Rene Kluwen <rene.klu...@chimit.nl> 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 <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 > > > > [image: Afbeelding verwijderd door afzender. Mailtrack] > <https://mailtrack.io/?utm_source=gmail&utm_medium=signature&utm_campaign=signaturevirality5&> > > Sender notified by > Mailtrack > <https://mailtrack.io?utm_source=gmail&utm_medium=signature&utm_campaign=signaturevirality5&> > 30/08/20 > à 11:07:29 > > > > Le jeu. 20 août 2020 à 14:22, Loyc Cossou <loycos...@gmail.com> 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&utm_medium=signature&utm_campaign=signaturevirality5&> > > Sender notified by > Mailtrack > <https://mailtrack.io?utm_source=gmail&utm_medium=signature&utm_campaign=signaturevirality5&> > 20/08/20 > à 14:22:22 > > > > Le jeu. 20 août 2020 à 13:55, Rene Kluwen <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> > *Verzonden:* donderdag 20 augustus 2020 14:26 > *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 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&utm_medium=signature&utm_campaign=signaturevirality5&> > > Sender notified by > Mailtrack > <https://mailtrack.io?utm_source=gmail&utm_medium=signature&utm_campaign=signaturevirality5&> > 20/08/20 > à 13:02:10 > > > > Le jeu. 20 août 2020 à 08:11, Rene Kluwen <rene.klu...@chimit.nl> a > écrit : > > Sqlbox is an alternative, or otherwise the commercial Speedbox add-on. > > > > == Rene > > > > *Van:* users <users-boun...@kannel.org> *Namens *Loyc Cossou > *Verzonden:* donderdag 20 augustus 2020 02:26 > *Aan:* kannel users@kannel.org <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&utm_medium=signature&utm_campaign=signaturevirality5&> > > Sender notified by > Mailtrack > <https://mailtrack.io?utm_source=gmail&utm_medium=signature&utm_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.] >