Sending Message Via Updatind a DB

2007-09-18 Thread Jins
hello, i heard it is possible to sent sms by updating db and by using sqlbox... i have installed standalone sqlbox with kannel.can someone please tell me about the table design for the sqlbox to work

Sending Message Via Updatind a DB

2007-09-18 Thread Jins
hello, i heard it is possible to sent sms by updating db and by using sqlbox... i have installed standalone sqlbox with kannel.can someone please tell me about the table design for the sqlbox to work -- Jinson Abraham, Torque Technology Solutions, T-BIC, Park Center, Technopark, Trivandrum.

Re: Sending Message Via Updatind a DB

2007-09-18 Thread preeteesh kakkar
Hi, Below is table format for send_sms table CREATE TABLE IF NOT EXISTS %S (sql_id bigint(20) not null auto_increment primary key, momt enum('MO', 'MT', 'DLR') null, sender varchar(20) null, receiver varchar(20) null, udhdata blob null, msgdata text null, time bigint(20) null, smsc_id

international mobile number formats

2007-09-18 Thread Iain Dooley
hi all, i've gone through the WTNG and Wikipedia and started compiling a parseable file format of all the country codes, mobile prefixes and number of digits to expect after the prefix. some countries i could not determine the information for (i was working quite quickly so it's possible

Re: Sending Message Via Updatind a DB

2007-09-18 Thread Jins
Thanks a lot..But the table will be there already in the DB..Now the issue is when i update the send_sms table,the entered field will be transferred to sent_sms table but my sqlbox is getting terminated giving a log as below... 2007-09-18 03:52:48 [23846] [0] INFO: MYSQL: server version

RE: international mobile number formats

2007-09-18 Thread Δημήτρης Ευμορφόπουλος
I still don't get what would this be useful for?? And ok, this is a nice compilation of data, but it should be maintained since numbering plans in the world change every Wednesday and Thursday. Who is going to maintain it and how will it be useful when numbering plans change? What about

stat:UNDELIV err:036

2007-09-18 Thread Arnar Gestsson
Hi guys, I've been sending SMS to numbers through and SMPP connection, when I request a Delivery Report for a given SMS I get the following message back, 2007-09-18 14:06:31 Receive DLR [SMSC:smscid] [SVC:tester] [ACT:] [BINF:] [from:account] [to:] [flags:-1:-1:-1:-1:2]

Deleting Received SMS from Kannel Modem

2007-09-18 Thread preeteesh kakkar
Hi All, I have a Kannel Gateway configured but my modem doesn't deletes any sms it receives. I want to delete a sms as soon as its received. I read that i need to send AT+CMGD=1,4 to delete all sms. Can someone tell me where i can do this in kannel and how can i have sms deleted from

RE: Deleting Received SMS from Kannel Modem

2007-09-18 Thread info.ubichip
Hello, Could you please precise if you are using the memory from the modem or the sim memory in your kannel configuration ? I noticed something in some modem from nokia, whatever you tell kannel to use the handset memory, you have to wait until the sim sms memory is full before the read

Re: international mobile number formats

2007-09-18 Thread Alejandro Guerrieri
I can tell you about Argentina, for instance. - Country code is 54. - City codes are two digits. - Buenos Aires (the capital) is 11. - Phone numbers are 8 digits. - Inside Argentina, use prefix 15 to access a celluar phone from a fixed line. - Inside Argentina, prefix 15 is optional from another

Re: international mobile number formats

2007-09-18 Thread Alejandro Guerrieri
Sorry, 15-11-12345678 Should be 15-12345678 And 0-11-15-12345678 from another city. Regards, Alejandro On 9/18/07, Alejandro Guerrieri [EMAIL PROTECTED] wrote: I can tell you about Argentina, for instance. - Country code is 54. - City codes are two digits. - Buenos Aires (the capital)

Re: Deleting Received SMS from Kannel Modem

2007-09-18 Thread preeteesh kakkar
Hi, Thanks for reply can you tell me how can i check which i am using i.e. modem memory or sim memory. How can i tell kannel which to use? On 9/19/07, info.ubichip [EMAIL PROTECTED] wrote: Hello, Could you please precise if you are using the memory from the modem or the sim memory in your

RE: Deleting Received SMS from Kannel Modem

2007-09-18 Thread info.ubichip
From the Kannel guide, take a look in this 2 parameters : sim-buffering boolean Whether to enable the so-called SIM buffering behavior of the GSM module. if assigned a true value, the module will query the message storage memory of the modem and will process and delete any messages found