Copy dbKnihy.sqlite from ...Documents/.... to ASD

I couldn't get to the original post from April 2023, so I started a new one...Sorryyyy...
In Android 13, I want to copy the file dbKnihy.sqlite from the folder...Documents/... to ASD.
It works for me via creates dbBooks.sqlite with the tblBooks table.
But when I compile the .apk, it creates only dbKnihy.sqlite with the android_metadata table in the ASD folder on my mobile, the tblKnihy table is not there.
ASD path in mobile is: file:///storage/emulated/0/Android/data/_data_appinventor.ai_ondrejruz.Knihy/files/dbKnihy.sqlite
It doesn't work even when there is a relative path in gPathASD....
Where am I doing wrong?

Use Do It in companion to see what is happening

Do not hard code ASD file paths, use the ASD path finder blocks

You may have more luck using the file component and setting filescopes correctly.

This path is incorrect
How do you copy the file to ASD?


Is it supposed to be like this?

Does it work?

It only works in Companion. So, in Companion, it just copies the file from the private directory on my mobile.../Documents/Zalohy/dbKnihy.sqlite to ASD and displays the contents of the file nicely. As soon as I make an .apk out of it, it doesn't copy correctly... and it's bad...

So this way I probably won't be able to copy the ...sqlite file from .../Documents to ASD...on mobile.
Are there any other options?

Here are the basics, tested compiled.

Filescope in Screen1 designer set to Legacy

I used an image, but your sqlite.db file should work in the same way.

Thanks for the example.
It works for me in Companion, but not on mobile.

Show us your blocks and explain how you found out, that it did not work to copy the file to ASD

I send blocks. How do I send the dbKnihy.sqlite file?

[mod edit: please do not post aia projects containing paid extensions]

Test just one procedure at a time, your call to four procedures at once may be causing a conflict / failure.

You may need to delete the sqlite.db file in /Documents/Zalohy/ before your compile and try the app again. (Reason - not possible to work with files created by another app - e.g. companion app)

I save the dbKnihy.sqlite archive in the folder /Documents/Zalohy. So if I change the version of the .app, this new version will no longer "recognize" the file created by the previous version of the app?
If so, how is the file backup done?

No, in this case it is still the same app, only a new version

@TIMAI2 was talking about first testing using the companion app and storing the file and later trying to read that file after building the app, because theny ou are trying to read a file created by another app...

You forgot to answer this question

Also previously you used a wrong path... what about using the correct path?


Hello. The app for copying the dbKnihy.sqlite file from /Documents/Backups/ to ASD does not work for me. That's why I created a test app with only a few blocks. In the input folder, dbKnihy has a size of 49,152. In the output folder after copies, it has only 12,000. Next, the app crashes with a Syntax error. quote in unquoted cell. In the output file, only the android_metadata table is copied... I am attaching blocks...
Can someone help?


You do not appear to have taken any of our advice above.....

Simplify your blocks, and just focus on the copying of the file from shared storage to the ASD.

Once you have that working, then you can start complicating things :wink:

Build in small steps, testing and checking at each step to ensure you have files in place and the correct file paths and permissions.

So the conclusion is probably that if I create e.g. in app1 the file dbKnihy.sqlite, so in another app, e.g. app2, I can no longer read that file and copy it to ASD in app2....
Is that so ?

Take us through the journey that your sqilte.db file goes through, step by step, from start to finish, then perhaps we can advise on the best course of action.

you still can read it using SAF


1 Like