Philip M.
- Forum posts: 1
Oct 17, 2011, 10:16:59 PM via Website
Oct 17, 2011 10:16:59 PM via Website
Hi,
I am trying to build an Android app that downloads a space delimited .txt file each time the app is run which is
then imported into an SQlite db so that a query can be run and the data displayed on the app.
Each time the app runs I want the data overwritten with the new .txt file data.
1) What is the best way to retrieve the .txt data file for the app/db to use?
2) How can I import this into a SQlite db? I know that you can use sqlite> .separator ','
sqlite> .import data.txt tablename - on the console, but how do I code this into my app so that it occurs each time
the app is loaded?
I'd be very grateful for any help.
I am trying to build an Android app that downloads a space delimited .txt file each time the app is run which is
then imported into an SQlite db so that a query can be run and the data displayed on the app.
Each time the app runs I want the data overwritten with the new .txt file data.
1) What is the best way to retrieve the .txt data file for the app/db to use?
2) How can I import this into a SQlite db? I know that you can use sqlite> .separator ','
sqlite> .import data.txt tablename - on the console, but how do I code this into my app so that it occurs each time
the app is loaded?
I'd be very grateful for any help.
Recommended editorial content
With your consent, external content is loaded here.
By clicking on the button above, you agree that external content may be displayed to you. Personal data may be transmitted to third-party providers in the process. You can find more information about this in our Privacy Policy.