Need to get pointed in the right direction

[karld]

My wife (A.K.A. Taskmaster) has decided that I have to write an app for her.

It will go like so.

She will input body measurements into her phone or tablet. (No problem with this part)

The tricky part for me is that she will need to get the info off the phone and into a database on a PC.

What is the best way to move the data off the phone? Email? Setup a web server on the PC? This will not be able to be accessed from the Internet for security reasons.

I just need a pointer in the right direction on this.

 

[timwil]

Hi Karl

Where will it be stored on the PC? Database?

Tim

 

[Ricky D]

I don't have a physical phone to try all this out on but I believe if your device has an external sd card you would save the sqlite db onto there.

When you connect the device to the PC you should be able to copy the db into a folder on the PC where an application you write (I use C#) would read the data and voila... in theory.

Does the device have an external sd card?

regards, Ricky

 

[Erel]

There are several options. I recommend you to check B4AServer: B4AServer - simplifies development of enterprise in-house Android applications

 

[karld]

Thanks for the pointers..

The PC will use either an access db, or MySql. Probably code it in VB.

Moving an SD card would be problematic for the wife. She is NOT technical, shall we say. (You should see how many SD cards I've had to buy for her camera....)

I'll checkout b4a server option. Since we have WiFi available here that might work the best.

The program she eventually wants to import this data into uses an Access database.

I'll let ya'll know how this project turns out.

 

[karld]

I've been playing with the b4a server code. I got the example working fine. I actually have the php script up and running on her webserver.

Seems to work fine. Now I am looking for a little advice on the best way to actually move the data from the phone to the pc database.

I've been considering creating a csv file and transfering it, then parsing it into the database.

I also am thinking about just having the phone app create an sql dump from the sqlite database and transfering that file over and running it against the database on the pc.

Anyone have any experience doing this? Any better ideas?

Karl

 

[Erel]

You can just send the whole database if it is not too large.

 

[karld]

Erel, You are a genius!!

I had not even considered that.


Karl