how to import CSV file in SQLite data in android?

Question

public class MainActivity extends Activity {
    Context context;
    SQLiteDatabase db;
    public static final String CONTACTS_TABLE_NAME = "contacts";

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);

        db.execSQL(
            "create table contacts " +
            "(id integer primary key, name text,dt1 text,dt2 text, dt3 text,)"
        );

        String mCSVfile = "contacts.csv";
        Log.e("shashank ", "" + mCSVfile);
        AssetManager manager = context.getAssets();
        InputStream inStream = null;
        try {
            inStream = manager.open(mCSVfile);
            Log.e("shashank inStream ", "" + inStream);
        } catch (IOException e) {
            e.printStackTrace();
        }

        BufferedReader br = new BufferedReader(new InputStreamReader(inStream));
        Log.e("shashank br ", "" + br);
        String line = "";
        String tableName = "contacts";
        String columns = "id, name, phone, email, discipline,place";
        String str1 = "INSERT INTO " + tableName + " (" + columns + ") values(";
        String str2 = ");";
        Log.e("shashank ", "" + str1);
        Log.e("shashank ", "" + str2);

        db.beginTransaction();
        try {
            while ((line = br.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();
        } catch (IOException e) {
        }
    }
}

Beginner in android. I want to import CSV file and upload in SQLIte database .please can u suggest me.how should I create a database in this class.

get this link in this post how to create db.this SQLiteDatabase db;????

Have you done to importing csv file to your application successfully?? — Raghav Mehta, Feb 04 '16 at 06:58
in Assets folder CSV file there.but I want to import that file by this code.we should import that file in SQLiteOpenHelper or activity? — Shashank Priyadarshi, Feb 04 '16 at 07:03
after create table i did insert CSV file in DBHelper class that is r8 way? — Shashank Priyadarshi, Feb 04 '16 at 07:18

score 1 · Answer 1 · answered Feb 04 '16 at 08:05

1

There is an extra comma in your create table contacts statement.

And your column names are not matching with the column names in INSERT INTO query.

answered Feb 04 '16 at 08:05

chalitha geekiyanage

6,464
5
25
32

how to import CSV file in SQLite data in android?

1 Answers1