Solved

Enable Android User to Send Data To SQL

Posted on 2013-10-30
7
523 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
Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

 
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

Edgartown IT Case Study

Learn about Edgartown's quest to ensure the safety and security of the entire town's employee and citizen data. Read the case study!

Question has a verified solution.

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

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…
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
This video is in connection to the article "The case of a missing mobile phone (https://www.experts-exchange.com/articles/28474/The-Case-of-a-Missing-Mobile-Phone.html)". It will help one to understand clearly the steps to track a lost android phone.

737 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