Solved

Enable Android User to Send Data To SQL

Posted on 2013-10-30
7
525 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
MS Dynamics Made Instantly Simpler

Make Your Microsoft Dynamics Investment Count  & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.

 
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

Turn Insights into Action

Communication across every corner of your business is essential to increase the velocity of your application delivery and support pipeline. Automate, standardize, and contextualize your communication processes with xMatters.

Question has a verified solution.

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

In this post we will learn how to make Android Gesture Tutorial and give different functionality whenever a user Touch or Scroll android screen.
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

691 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