Location of database and csv files

[devlei]

I am struggling to get B4A to open and read existing sqlite and csv files, and I suspect it has to do with their location.

From the "Text Files" documentation in the "Getting Started & Tutorials" forum, I can see that for File.DirDefaultExternal the location is
<storage card>/Android/data/<package>/files/.

But where is this on my desktop computer?

 

[Erel]

You cannot directly access your desktop file system from the emulator. This folder is inside the emulator own file system.

 

[devlei]

Thanks for the response, Erel.

Where do I place any existing sqlite or csv files that I want my B4A app to read?

 

[Erel]

Go to the Files tab in the right pane and add the required files.
These files get packaged in the APK file and are accessed with File.DirAssets.

It is not possible however to open a SQLite database in this folder. You can use DBUtils.CopyDBFromAssetsFolder to copy the file from this folder to a regular folder.

 

[devlei]

Thanks, I used DBUtils.CopyDBFromAssetsFolder to copy the file to File.DirDefaultExternal and was able to access the data.

Now I have added and edited data, but the next time I run the app I am back to the same old problem of it not being able open the file in the File.DirDefaultExternal location.

How do I open this updated database file when I run the app again?

 

[klaus]

There should be no problem the second time as you had access to the database the first time, otherwise you could also use Files.DirInternal.

Best regads.

 

[devlei]

Thanks, Klaus.

I am just busy going through your SQLiteDB example and hopefully that will help me resolve this issue. If not, I will post again.

 

[devlei]

It seems like the SQLiteDB example uses Files.DirInternal.

The problem with that for my app is that I need to be able to synchronise the sqlite db from the device with the desktop as there is a companion desktop app that also needs to access that same sqlite db.

Any suggestions on how to achieve that?

 

[klaus]

Yes, SQLiteDB uses Files.DirInternal.
Perhaps try using Files.DirRootExternal.

Best regards.

 

[devlei]

I will try that.

If I use the Files.DirRootExternal, in what folder do I place my existing sqlite db during development using the emulator?

 

[klaus]

You can also use Files.DirRootExternal with the emulator.
You to setup the emulator for sdcard and set in the IDE in the Project menu 'Can Install To External Storage'. Just tried it.

Best regards.