Using .csv from Shared Folder(Documents)

[BIOwarFIRE]

I know its a well known error but i dont really understand how i can solve my problem. Sorry for all discomfort! I wanna make my App work on Android 11+ (i prefer solutions where i dont have to differ the different Android versions if thats possible )
Till now(Andoid 7.0):
I use the file-component to append an csv.
So I can access the csv on my laptop and can manipulate(adding; deleting, modifying) the data stored easily and can afterwards analyze them with Excel.

How can i make it work on all Android > 7.0?
I have heard, that taifun could help me but i doesnt know how
The only thing i have read, is, that i should use the ASD and export it to Shared Folder(with taifun?) but that wouldnt help me i guess, because i cannot overwrite and changes made on laptop wont change the "real" csv in the ASD...
Thank you for your help and sorry for my bad english, i am german^^

[Taifun]

Welcome
Please first read this Some basics on Android storage system

So you have a csv file and would like to modify it from within the app, but also from outside the app...

After it has been modified outside of the app, you will need SAF to be able to read it again...

SAF: App Inventor implementation of Storage Access Framework

1.Introduction Description: Basically AI2 wrapper of Storage Access Framework. Using this extension, you can get read and/or write access to a single document or tree document (and all of its children recursively). Latest Version: 1.3 Released: 2021-09-16T18:30:00Z (UTC) Last Updated: 2023-11-15T18:30:00Z (UTC) 2.Blocks [image] [image] [image] [image] [image] [image] [image] [image] [image] 3.Documentation Events ErrorOccurred Event indicating error/excep…

You can work directly from the shared storage /Documents, no need to hsd ASD I your case...

Alternatively you might want to think about a Google Spreadsheet solution... like this you can avoid sll the challenges with the file system

Taifun

[Anke]

In addition to @Taifun's answer:

Append and read csv file

/storage/emulated/0/Documents/ or /storage/emulated/0/Download/ For the File component you must use the relative path (as I already said): /Documents/liste.csv or /Download/liste.csv

Help with generating a sheet file from various labels

The File component uses/requires a relative path if the FileScope is "Shared" or "Legacy". If the FileScope = App, ONLY the filename is needed to store the file in the ASD (that means the file will be automatically redirected to the ASD). However, the ASD is no longer visible on devices running Android 11+. Also, as @Taifun said, other apps can't access your app's ASD. So if the file needs to be viewable from the device, you need to save the file on Android 11+ devices in one of the Shared fold…

[BIOwarFIRE]

Why does it not work?

What is wrong with my URI? what did I mixed up? IsDocumentUri results false Thank you for help <3

[Anke]

@BIOwarFIRE

What is wrong with my URI?

It's not an URI.
There are several posts ... so read ...

SAF: App Inventor implementation of Storage Access Framework

1.Introduction Description: Basically AI2 wrapper of Storage Access Framework. Using this extension, you can get read and/or write access to a single document or tree document (and all of its children recursively). Latest Version: 1.3 Released: 2021-09-16T18:30:00Z (UTC) Last Updated: 2023-11-15T18:30:00Z (UTC) 2.Blocks [image] [image] [image] [image] [image] [image] [image] [image] [image] 3.Documentation Events ErrorOccurred Event indicating error/excep…

[BIOwarFIRE]

i searched in

Read file from phone memory

and

SAF: App Inventor implementation of Storage Access Framework

I'm trying to copy a mp3 file from the ASD to the /Ringtones directory here are my blocks [Unbenannt] I get the following error message Permission Denial: writing com.android.externalstorage.ExternalStorageProvider uri content://com.android.externalstorage.documents/tree/primary%3A/document/primary%3ARingtones from pid=13158, uid=10721 requires android.permission.MANAGE_DOCUMENTS, or grantUriPermission() what needs to be changed? also how can we find out, if the TakePersistableUriPermis…

but couldnt find useful information even with keyword search "URI" and "write document"
I know that I need the URI of my document which is safed in Documents. But i wasnt able to find information how i can build the URI when i just know the path. Maybe i am totally wrong, because its my first time with URI so i didnt understand the informations given in the links above.

[patel]

Use asd , you can read and write without permission with your app and windows and android filemanegers

[BIOwarFIRE]

that doesnt help me, because i cannot access ASD, so i cannot watch the file on PC.

[patel]

Did you try ? I can with android 11

[Anke]

@BIOwarFIRE

i cannot watch the file on PC

Of course, this is possible even on Android 11+, but you have to use a special file manager like Total Commmander to see it on the device and on the computer you can see it via USB connection.

[Anke]

@BIOwarFIRE

cannot watch the file on PC

If that weren't possible, nobody would be able to clear the Companion assets / ASD on Android 11+ without uninstalling the companion app or deleting storage & cache in the app settings.

[patel]

@BIOwarFIRE

that doesnt help me, because i cannot access ASD, so i cannot watch the file on PC

Connect phone via usb, select Android, Data, your app folder, Files. You can drag your windows csv in Files and read it with your app.

[BIOwarFIRE]

Thx patel, what am I doing wrong? My .csv doesnt get appended.

[ABG]

The C in CSV stands for Comma (,)
not semicolon ";"

[BIOwarFIRE]

thats no problem for me. my excel uses Semicolon for seperation.

[patel]

You don't need SAF and Taifun ext for saving/reading ASD

[patel]

@BIOwarFIRE

thats no problem for me. my excel uses Semicolon for seperation.

Using semicolon you can not use AI2 blocks for csv tables

[BIOwarFIRE]

so should i use taifunfile-component to copy my file from ASD to privDir; using file-component to append the .csv; copying from privDir back to ASD with taifun-component? Because editing .csv with file-component in ASD doesnt seem to work

[Anke]

@BIOwarFIRE

what am I doing wrong?

Sorry, but unfortunately everything.

1. SAF is not required to write to or read from the ASD. So use the File component.
2. SAF is required if you want to write to or read non-media files from non-shared folders on Android 11+. In addition, SAF is required if non-media files that were NOT created by the app itself are to be read from shared folders.
3. Read all comments in the topic "SAF extension". There are numerous block examples on how to use the blocks correctly.

[patel]

@BIOwarFIRE

Because editing .csv with file-component in ASD doesnt seem to work