right now if u want scheduling u got to do it on the app side i'm not sure it would be a good idea to put it into sqlbox.. sqlbox job is sending the messages, any scheduling u may want to do can be easily done on your app, with schedules tables, and a cronjob that reads them and feeds into sqlbox when needed
On Tue, Mar 4, 2008 at 4:18 PM, Alejandro Guerrieri <[EMAIL PROTECTED]> wrote: > sqlbox sits inbetween smsbox and bearerbox, and catches all traffic going in > and out. If you queue a message using the HTTP interface on smsbox, it will > overgone the same DLR methods as before (if you use sql storage it will > write an entry there and wait for the answer to update it). > > I'm not sure about MT enqueuing directly on sqlbox, never tried it that way > with DLR's. > > Regarding scheduling, that would require a "WHERE" on the sql (eg, compare > the "time" field with the local timestamp and only select messages where > time >= timestamp). The way it is now (one query per message) could be > overkill on large volumes, but with the patch for group selects and adding > an index on the field could be easily implemented. > > Regards, > > Alejandro > > > > On Tue, Mar 4, 2008 at 3:52 PM, akif dinc <[EMAIL PROTECTED]> wrote: > > > > > > the idea with scheduling was having the message send at a given time/date. > like send message on the 12. of october 2008. > > also one question i would like to ask is if how to find the relation > between the sent message and the delivery report to it. i've a smpp > connection and use sqlbox, it works for testing at the moment very well. > before using sqlbox i updated via a self written php file a databasetable > with the delivery report status. > > after using sqlbox do i have to keep track of the send messages or can > sqlbox somehow do this for me? > > i wonder if there is still need for futher db tables or if i can handle > all with the existing sent_sms. where my needs would be restricted to know > what status the message at the moment has (like delivered, pending, etc.) > > > > thank you very much in advance, > > > > > > ________________________________ > Date: Tue, 4 Mar 2008 12:26:34 -0200 > > From: [EMAIL PROTECTED] > > To: [email protected] > > Subject: Re: sqlbox kannel and scheduling > > > > > > > > > > >From what I've learned from the source code, no, sqlbox reads messages > one by one (I've made a patch to retrieve batches of messages) without any > kind of sorting or scheduling. > > > > So, if you insert 100K messages at once, they will be retrieved one by one > and not necessarily on the same order of insertion. > > > > The only scheduling you'll get is when messages are on the kannel's store > (that's when sqlbox insert the messages to bearerbox). > > > > Hope it helps, > > > > Alejandro > > > > > > 2008/3/4 akif dinc <[EMAIL PROTECTED]>: > > > > > > hello, > > > > does sqlbox support sheduling? > > > > > > > > > > ________________________________ > Direkter Zugriff zu Hotmail und Messenger! Kostenloses Update für Ihren > Internet Explorer! > > > > > > -- > > Alejandro Guerrieri > > Magicom > > http://www.magicom-bcn.net/ > > LinkedIn: http://www.linkedin.com/in/aguerrieri > > ________________________________ > Mit Live Search: Ihre Stadt in der Vogelperspektive! Erleben Sie neue > Blickwinkel! > > > > -- > Alejandro Guerrieri > Magicom > http://www.magicom-bcn.net/ > LinkedIn: http://www.linkedin.com/in/aguerrieri
