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
– Raghav Mehta, Commented Feb 4, 2016 at 6: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
– Shashank Priyadarshi, Commented Feb 4, 2016 at 7:03
after create table i did insert CSV file in DBHelper class that is r8 way? — Shashank Priyadarshi
– Shashank Priyadarshi, Commented Feb 4, 2016 at 7:18

chalitha geekiyanage · Accepted Answer · 2016-02-04 08:05:42Z

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 4, 2016 at 8:05

chalitha geekiyanage

6,9625 gold badges28 silver badges35 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

how to import CSV file in SQLite data in android?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related