Database Intergation

Database Intergation SearchSearch
Author Message
Waleed Hameed
New member
Username: Waleed_k

Post Number: 2
Registered: 02-2007
Posted on Wednesday, February 28, 2007 - 11:57 am:   

Hello, this issue has been discussed before but I still have no idea how to implement the explained solution. In previous post for Bryce, it was clear but I am still missing the more technical explanations.

//
Posted on Tuesday, July 22, 2003 - 05:05 pm:

--------------------------------------------------------------------------------
Hi Anthony,

Sorry for the delay replying to your message here. I believe you also posted it to our support mailbox where I replied directly on Friday (otherwise someone else asked the same question).
_________________________________________________

We don't integrate directly with any databases. However, our HTTP interface makes it quite easy to integrate with a database. When an SMS message is received, the gateway can call an HTTP script running on another web server, passing the details of the message. Then you can use the scripting language of your choice to integrate in with a database (log the SMS message into your database, query the database to determine how to respond to the message, etc.).

Does that make sense, or do you need more information?

-bn
//__________________________________________

I would like to know more about how to integrate with DB, Is it to log the sms to txt file first the work on it or am i wrong.

THANKS FOR ALL THE HELP.

Waleed Hamed
SIE JEAN CHARIE
New member
Username: Siejc

Post Number: 1
Registered: 02-2007
Posted on Wednesday, February 28, 2007 - 12:04 pm:   

I have configure an HTTP connexion to an SMSC. I have successfully send message via my web browser.

I need to give my url to the SMSC IT so that they could route sms to my nowsms gateway.

Could someone give it to mee

THANK YOU FOR YOUR HELP

Waleed Hameed
New member
Username: Waleed_k

Post Number: 3
Registered: 02-2007
Posted on Friday, March 02, 2007 - 12:24 pm:   

Hello,

I would like to ask again for any help considering the Database integration and the 2-Way SMS service.

I have managed to configure most of issues.
1- I am using N70 Nokia as modem.
2- I define VBscript for writing the SMS on txt file in this example. http://support.nowsms.com/discus/messages/1/333.html

BUT the script didn’t do any thing. I have taken in consideration every aspect. Like the files paths.

So what I am asking for as well. How I can test if the 2way sms is working actually and if the script is willing to do its job?!!!!
Is it by sending SMS to the modem SIM card number!!!!

Well I would be pleased with your support and I need to meet some dead line soon next week.

Regards.

Waleed Hamed.
Bryce Norwood - NowSMS Support
Board Administrator
Username: Bryce

Post Number: 6950
Registered: 10-2002
Posted on Wednesday, March 07, 2007 - 09:21 pm:   

Sorry, I have been away from the discussion board for awhile.

There are two questions here, and I believe they are addressed by my responses in other threads:

First, the issue fo the N70 and it's inability to route received SMS messages to NowSMS:
http://support.nowsms.com/discus/messages/1/20144.html

Second, routing received SMS messages to a database:
http://support.nowsms.com/discus/messages/1/20158.html

-bn
Waleed Hameed
New member
Username: Waleed_k

Post Number: 6
Registered: 02-2007
Posted on Thursday, March 08, 2007 - 10:48 am:   

Hello Bryce,
Many thanks that made it clear. I used Nokia 9810i at home and it was receiving SMS but the script didn’t work to create file and log the sms in.

Well just to make sure I am testing the 2-way services basically right.
What I am doing is defining the command prefix as "*" and save the script code in the specific path. I made sure all the mentioned saving and creating paths are right, and the cscript.exe is there (although I tried to use wscript.exe as well).
To test: I send SMS from any mobile to the number of the modem. And I would expect the script will be triggered and a file will be created to log the SMS.

I have been reading through all the discussion bored and you got super supports tips that should be clear to overcome this. But I am still facing the problem.

Many thanks again, I am looking forward to your advice.

Regards

Waleed Hamed
MSc. Mobile Cmputer System
Staffordshire University.
Waleed Hameed
New member
Username: Waleed_k

Post Number: 7
Registered: 02-2007
Posted on Thursday, March 08, 2007 - 02:35 pm:   

Hello,
I start using sony ericsson w900 and it is sending and receiving. but still the 2way commande is not excuting.
I have the SMS in to SMS-IN folder and the SMS-yyyymmdd.log one as well.
as I assume the 2-way commande should take the SMS and run the script with out diracting the SMS into SMS-IN. in other words, If the commande is excuted I would have file crated and I am not expacting to see SMS in SMS-IN folder.

plz coract me if i am wrrong. and why the 2-way is not doing good?

thanks.
application/octet-stream
namedarg.vbs (1.0 k)
application/octet-stream
SMSDEBUG.LOG (5.9 k)
Bryce Norwood - NowSMS Support
Board Administrator
Username: Bryce

Post Number: 6979
Registered: 10-2002
Posted on Monday, March 12, 2007 - 09:45 pm:   

Hi Waleed,

I think our discussion is split amongst multiple threads.

I made an observation about your 2-way script not running over in this other thread:

http://support.nowsms.com/discus/messages/485/20179.html

Command Prefix needs to be * ... not "*" ... (the "quotes" are just delimiters that I use sometimes in explanations, but that are not meant to actually be input ... sorry if that is confusing) ...