Need to get pointed in the right direction

Hi Karl

Where will it be stored on the PC? Database?

Tim

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

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

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.

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

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

Erel, You are a genius!!

I had not even considered that.


Karl