Solved

Enable Android User to Send Data To SQL

Posted on 2013-10-30
7
520 Views
Last Modified: 2016-02-11
I have an android app that allows my users to send me data about the android version they are using and the apps that they would like custom icons for. Currently my users can click on a button and the info is compiled into a zip file that is emailed to me. I am wondering if there is a way to leverage my SQL server from my hosting account.

I'm certainly not looking for a solution in one post. I am just hoping to get some directions to some resources that might be available out there and maybe some suggested approaches.
0
Comment
Question by:spaced45
  • 4
  • 3
7 Comments
 
LVL 16

Expert Comment

by:DcpKing
ID: 39613247
If the content isn't too big then you'd hardly need to zip it up - just send it encoded in plain text. Then receive the email with an email client like TheBat! which stores the emails as text. A little reverse engineering of the file structures should let you write a very small program - in VBScript or Python - to extract the data out and into a csv file. After that a small dose of SSIS and you've a table with data!

hth

Mike
0
 
LVL 1

Author Comment

by:spaced45
ID: 39613253
That makes perfect sense the files are really not that big. I think this is certainly worth exploring. I have done this before for a website form using php and MySQL could u direct me to some resources that could help me do something similar in an android app? I think that should give me everything I need to be on my way. Thank you.
0
 
LVL 1

Author Comment

by:spaced45
ID: 39613256
TheBat!? Could you explain?
0
Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

 
LVL 16

Expert Comment

by:DcpKing
ID: 39613258
You've already written an android app to send email? Just keep the text in the email body rather than stuffing it into a zip file. If you haven't then take a look here for an intro. You can also google "writing android apps" to find other resources for beginners. For the email part look for the JavaMail API for GMail.

As for the back end part, I wrote one rather a long time ago using a development tool called Paradox, pulling the email into variables, parsing it, and dumping it into tables. Afterwards it got pushed into SQL Server, I believe. So it's certainly possible!

hth

Mike
0
 
LVL 16

Accepted Solution

by:
DcpKing earned 500 total points
ID: 39613259
TheBat! and some other email clients store their received emails in text files, so the enterprising programmer can simply write a program to raid these files, looking for content. Personally I use an editor called UltraEdit for examining strange files (in text or hex, conveniently). Eudora is another email client that keeps its data in open text (or used to).

hth

Mike
0
 
LVL 1

Author Comment

by:spaced45
ID: 39615823
This was great information. I have plenty to go on now. I do appreciate all of your assistance.
0
 
LVL 16

Expert Comment

by:DcpKing
ID: 39617700
Well thank you!! I wasn't expecting points for just that!! Good luck with your project.
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Viewers will learn how the fundamental information of how to create a table.

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question