CrazyEngineers
  • Receive and Store SMS in database

    GP17

    Member

    Updated: Oct 26, 2024
    Views: 1.2K
    Hi Friends,

    I want to know, how to recieve sms from gsm modem and store it in database (SQL, or other).Could anybody help me on this subject?? (Urgent)..Thank you in advance..
    0
    Replies
Howdy guest!
Dear guest, you must be logged-in to participate on CrazyEngineers. We would love to have you as a member of our community. Consider creating an account or login.
Replies
  • bill190

    MemberJul 29, 2010

    I don't know anything about SMS, however I have done just about everything with Perl scripts running on UNIX including SQL for databases... So I thought I would search google.com for the terms: sms receive perl ...and it looks like there are many options available! Here is that search...
    <a href="https://www.google.com/#hl=en&safe=off&q=sms+receive+perl&aq=f&aqi=&aql=&oq=sms+receive+perl&gs_rfai=&fp=577449e654f14c7e" target="_blank" rel="nofollow noopener noreferrer">Google</a>

    Then you can use Perl and SQL and the MySql database on a UNIX system. And with that setup talk to most databases. All sorts of information about that on the internet. FYI a web hosting company called pair.com in Pittsburgh, U.S. has UNIX servers, perl, and MySql along with Telnet, FTP, etc.
    Are you sure? This action cannot be undone.
    Cancel
  • tomastamm

    MemberNov 27, 2010

    you have to check #-Link-Snipped-# with Api connection, they redirect all sms to you via HTTP POST request
    Are you sure? This action cannot be undone.
    Cancel
  • smsrecv

    MemberFeb 21, 2011

    That's exactly what SMS Enabler program can do. You can find it here: <a href="https://smsenabler.com" target="_blank" rel="nofollow noopener noreferrer">Receive SMS on PC or Website using SMS Software</a>
    Are you sure? This action cannot be undone.
    Cancel
  • GP17

    MemberFeb 21, 2011

    smsrecv
    That's exactly what SMS Enabler program can do. You can find it here: <a href="https://smsenabler.com" target="_blank" rel="nofollow noopener noreferrer">Receive SMS on PC or Website using SMS Software</a>
    Thanks for your reply. Is it will split the received sms according to some parameters??
    Are you sure? This action cannot be undone.
    Cancel
  • smsrecv

    MemberFeb 21, 2011

    What does it mean "split sms" ?
    It inserts messages directly into a database table as they are received. If you use , for example, Microsoft SQL server, then you can create a trigger on that table and do whatever you want with the inserted messages in that trigger.

    Another option: SMS Enabler can also post received messages to a webserver via HTTP, so you can process messages in a web script. (e.g. written in PHP). You can insert messages into a database using this script.
    Are you sure? This action cannot be undone.
    Cancel
  • GP17

    MemberFeb 21, 2011

    Actually i will receive a string of sms, and i want to split the received sms into some sub string. Then store in a database.. I'm using SQL server, but do not have a great knowledge on that. I'm just beginner in SQL. Don't know how to process the data once it is stored in database..Could you please help me?
    Are you sure? This action cannot be undone.
    Cancel
Home Channels Search Login Register