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

MIT App Inventor Help
1

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 Companion...it 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?
Ondrej

blocks(16)

blocks(13)
blocks(13)1090×562 61.1 KB

blocks(15)
blocks(15)1352×370 34.4 KB

blocks(14)
blocks(14)1426×696 69.7 KB

2

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.

3

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

Taifun

4

Is it supposed to be like this?
Ondrej

blocks(13)
blocks(13)1090×614 66.4 KB

5

Does it work?

6

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...
Ondrej

7

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?
Ondrej

8

Here are the basics, tested compiled.

Filescope in Screen1 designer set to Legacy

image
image415×614 45.3 KB

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

blocks
blocks1394×318 51 KB

9

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

10

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

11

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

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

12

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

13

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)

14

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?
Ondrej

15

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?

Taifun

16

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?
Ondrej

blocks(12)
blocks(1)

blocks(2)
blocks(2)1080×468 43.1 KB

blocks(3)
blocks(3)1350×594 51.8 KB

blocks(13)
blocks(13)1090×614 66.4 KB

blocks(5)
blocks(5)1590×622 75.1 KB

blocks(6)
blocks(6)808×180 12.9 KB

blocks(7)
blocks(7)810×180 12.9 KB

17

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.

18

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 ?
Ondrej

19

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.

20

you still can read it using SAF

Taifun

1 Like