Find Jobs
Hire Freelancers

Android SMS gateway app that syncs to a database

$250-750 USD

Completed
Posted about 12 years ago

$250-750 USD

Paid on delivery
The task is to write an Android application that will query data from a MySQL database to the phone, queue basic SMS messages, and send them in a somewhat continuous fashion. It will also save all incoming messages to the same database. Target OS is Android 2.2-2.3 Design The UI is very minimal. The complexity is in the automation required to collect queued messages from the database, send them, marked them as sent, and periodically check & queue any new outgoing messages. The database contains all the message details - the outgoing phone number, the body of the text, and several maintenance flags (sending status, bad phone number?, ref_code). The UI consists of a running count of ( queued | sent | failed ) messages and a few settings that can be modified by the user (ability to turn on/off saving of incoming messages, ability to set quiet hours). It should also provide notifications of any errors encountered. This is a "turn it on and leave it alone" type of app which allows a remote manager to send SMS on a variety of cell networks worldwide, provided one user is running the gateway app on that network. Key features: – syncs to a mysql database – sends queued messages – saves received messages – only pulls and sends messages intended for that user’s phone (user's phone number is the lookup key here) – has a few error management features UI features – when you start the app it forms a connection to the mysql database and checks for queued messages that are linked to that phone. - WAITS between 5 and 10 seconds before sending each next queued message. (5-10 should be a random interval. This appears to decrease network sending errors) – continues to check for new messages every 15 minutes, and sends new messages if any – has a button to turn off the “store received messages in database” (default is on) – provides a running report on number of messages queued, delivered (since starting app session), and failed – SET QUIET HOURS (doesn’t send between 11pm and 6am by default, but can be changed) – Can it check & queue new messages while working continuing to send previously queued messages. - Updates the database and changes the message status from "queued" to "sent". This may require a storing a local copy of the queued data. Wish List Debugging Features – BAD NUMBER: receives error messages about failed delivery of an SMS message. Displays the count failed on device and updates the database with a “bad phone number” flag. I've been told it is tricky, so this is not required, but desired. - NO CREDIT: I've been told that it is very difficult for the app to know if the phone is out of credit, so "checking credit" and stopping outgoing messages would be a nice wish-list feature, but I don't expect it. The priority is functional prototype, UI design is not essential. Another developer will be able to make any modifications to SQL database and guide you on any vague aspects. Intended countries: Kenya, Uganda, Tanzania Intended device: Huawei Ideos phone running Android 2.2 or similar.
Project ID: 1408001

About the project

9 proposals
Remote project
Active 12 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
This is my first time using Freelancer.com but I have experience with sql databases and already have a code base to pull from for sending sms messages and storing them in a database.
$300 USD in 30 days
0.0 (0 reviews)
3.0
3.0
9 freelancers are bidding on average $408 USD for this job
User Avatar
Hi, Please check PM.
$500 USD in 6 days
4.9 (30 reviews)
7.2
7.2
User Avatar
Hi, please read your message for portfolio.
$500 USD in 15 days
5.0 (15 reviews)
5.3
5.3
User Avatar
I am a professional Android developer. I am interested in your project and also ready to handle it effectively
$400 USD in 14 days
4.8 (16 reviews)
5.2
5.2
User Avatar
Hello Marc, I have been working recently on a similar app, and I am confident I can complete this one successfully.. Please check your PM for more details..
$400 USD in 30 days
5.0 (7 reviews)
4.3
4.3
User Avatar
Hi, Please check PM for details.
$450 USD in 20 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Similar project is ready with free web-hosting of mysql so you won;t have to pay for hosting charges etc. All you have to have is internet connection to get the work done. if you want screen-shot then tell me.
$275 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, Please check PM. I have detailed the plan how I am going to tackle this task. Thanks
$500 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello Sir, It will be our pleasure to work on your project as we can do it confidentially. Please check your private message box for the portfolio and details. Best Regards
$350 USD in 2 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Washington, United States
4.8
4
Payment method verified
Member since Nov 23, 2010

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.