Solved

Enable Android User to Send Data To SQL

Posted on 2013-10-30
7
521 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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
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

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

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

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
When table data gets too large to manage or queries take too long to execute the solution is often to buy bigger hardware or assign more CPUs and memory resources to the machine to solve the problem. However, the best, cheapest and most effective so…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

861 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