Importing the csv file to Sqlite database in android

Question

I have successfully exported the csv file of my android application database. Now what i want to do is by browse option selecting i can import that csv file and replace it with existing database tables (like as restore). I have a table in sqlite database name members.

Id  == Name == Phone number
1   == Abhi == 11111111
2   == Ram  == 111111223
3   == Alex == 891273932

I want to restore the csv file in to my phone database in android application.

Thanks

SQLite supports CSV importing by default. May not work well with complex CSVs though. Read : https://www.sqlite.org/cvstrac/wiki?p=ImportingFiles — C--, Apr 28 '18 at 14:39

score 0 · Answer 1 · answered Apr 05 '16 at 14:26

0

First you have to set separator string, then you can import you csv file to the desired Table.

Here am assuming separator as comma(,)

.separator ","
.import your_csv_file.csv your_table_name

If you use .help, you might notice something interesting :

sqlite> .help
...
.help                  Show this message
.import FILE TABLE     Import data from FILE into TABLE
...
.separator STRING      Change separator used by output mode and .import
...

answered Apr 05 '16 at 14:26

Ramkee

900
1
10
27

It should be mentioned this is from a sqlite shell. The question was asking how to do it in Android – OneCricketeer Apr 05 '16 at 14:32
Fine, can i delete this answer? – Ramkee Apr 05 '16 at 14:35
It is a reasonable answer, just needs more clarification on how to get the database file into Android – OneCricketeer Apr 05 '16 at 14:36

score 0 · Answer 2 · edited May 23 '17 at 12:31

Try this:

FileReader file = new FileReader(fileName);
BufferedReader buffer = new BufferedReader(file);
String line = "";
String tableName ="TABLE_NAME";
String columns = "_id, name, phonenumber";
String str1 = "INSERT INTO " + tableName + " (" + columns + ") values(";
String str2 = ");";
 
db.beginTransaction(); 
while ((line = buffer.readLine()) != null) {
    StringBuilder sb = new StringBuilder(str1);
    String[] str = line.split(",");
    sb.append("'" + str[0] + "',");
    sb.append(str[1] + "',");
    sb.append(str[2] + "',");
    sb.append(str[3] + "'");
    sb.append(str[4] + "'");
    sb.append(str2);
    db.execSQL(sb.toString());
} 
db.setTransactionSuccessful(); 
db.endTransaction();

Taken from: Import .csv file to Sqlite in Android

Importing the csv file to Sqlite database in android

2 Answers2