• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 536
  • Last Modified:

Enable Android User to Send Data To SQL

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
spaced45
Asked:
spaced45
  • 4
  • 3
1 Solution
 
DcpKingCommented:
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
 
spaced45Author Commented:
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
 
spaced45Author Commented:
TheBat!? Could you explain?
0
Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

 
DcpKingCommented:
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
 
DcpKingCommented:
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
 
spaced45Author Commented:
This was great information. I have plenty to go on now. I do appreciate all of your assistance.
0
 
DcpKingCommented:
Well thank you!! I wasn't expecting points for just that!! Good luck with your project.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now