Android - Import CSV File Into SQLite Database

Question

I want to enable my users to be able to import their CSV files into their SQLite Database, for now it will only be for one table which is called Inventory

How would I do it so that the user can select where the CSV file is within the app and then load in the data to the database WITHOUT replacing what is already there?

Can you please show to the community what have you done so far? — AuroMetal
– AuroMetal, Commented Oct 22, 2015 at 14:50
So far I've been looking online and only found examples where CSV files are in an Asset folder which I don't think is going to help me [link] (stackoverflow.com/questions/16672074/…) Roughly third answer down, and so far haven't found much as to allowing users to select a file from a directory — Sjharrison
– Sjharrison, Commented Oct 22, 2015 at 14:53

Community · Accepted Answer · 2017-05-23 12:24:37Z

1

you must read content of csv file and add content to database. this is for read from csv file.

edited

you can using this for read any csv file from storage

public class MainActivity extends AppCompatActivity {

    private static final int REQUEST_CODE = 1;

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);

        Intent intent = new Intent(Intent.ACTION_GET_CONTENT);
        intent.setType("file/*");
        startActivityForResult(intent, REQUEST_CODE);

    }

    @Override
    protected void onActivityResult(int requestCode, int resultCode, Intent data) {
        super.onActivityResult(requestCode, resultCode, data);

        if(resultCode == RESULT_OK){
            if(requestCode == REQUEST_CODE){
                Uri fileUri = data.getData();

                Log.i(getClass().getName(), "fileUri" + fileUri);
            }
        }
    }
}

edited May 23, 2017 at 12:24

CommunityBot

11 silver badge

answered Oct 22, 2015 at 14:50

Mohammad Hossein Gerami

1,3881 gold badge12 silver badges28 bronze badges

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

2 Comments

Sjharrison Over a year ago

Hi @Hossein, thanks for the link, however how would I do it so that the user selects which CSV file to import

Mohammad Hossein Gerami Over a year ago

added file chooser for selecting any csv file

Collectives™ on Stack Overflow

Android - Import CSV File Into SQLite Database

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related