javaandroidcsvfilepathopencsv

AndroidStudio can't find CSV file. Tried Absolute File Path & Relative File Path


I've created a simple Android app that displays text to the user.

Now I'm attempting to implement a CSVReader to retrieve text from a CSV file. After hours of trying different things.

I finally implemented an open source CSVReader (At least it's not giving me any compile errors anymore).

Now when I run the app, it crashes and I get a "file not found" exception. Either I'm not placing my CSV file in the correct location, I'm not referencing the correct file path, or both.

I've tried using the absolute file path (ex. starting with my C:/Users/Tim/AndroidStudioProjects/...).

I've also tried using a relative path starting with the Assets folder (ex. "Assets/SOCIAL_POSTS.csv") and nothing I've tried has worked.

I've tried looking for similar Questions on Stack Overflow, and I've tried several variations of file paths and nothing has worked so far. What do you think I should try next?

Here is a link to this project on GitHub.

The code pointing to the CSV file is under

app > src > main > java > com > example > tim > inspiredquestions

The CSV file is called SOCIAL_POSTS.csv and it is under

Assets > SOCIAL_POSTS.csv

Final note: I've used StackOverflow for debugging help for a year now, but this is the first question I've asked.

Thank-you for your patience! I'm trying to be as self-reliant as I can, but I'm going on a limb and asking for help. I'm sure this problem has a simple answer I'm overlooking.


Solution

  • I finally figured out the answer. I added this:

        final CSVReader csvReader = new 
    CSVReader(new InputStreamReader(c.getAssets().open("SOCIAL_POSTS.csv") 
    

    to my load function in Game.java after looking at the answer to this question.

    Previously I had put my CSV file in an assets folder under app/src/main but I didn't know how to access the file properly until reviewing that SO post.