[FREE] CSV Tools Extension to work with CSV Files

[edited]

If a text/csv file is owned/created by your app, then use the File component to write, but use SAF to read.

If a text/csv file is NOT owned/created by your app, then you need the SAF extension to read/write.

Or just use SAF for read/write operations.

1 Like

1 Like

Yes, it worked. I used MFile to save a .csv file (using this file path: file:///storage/emulated/0/Download/177.csv), then i used File component to read it using this filepath (/Download/177.csv). After that I deleted the MFile block. Now, the app is reading the file.

I am using Tasker app to update the same file always. Tasker is also doing it well. So, mit ai2 app has to read it and perform some task based on this data.

As I said, this does not work on Android 13+ (at least not with the APK, on Android 14 it also doesn't work with Companion). So you must use my MFile extension (at least on Android 13+).

1 Like

Your words...

On Android 11+, non-media files (like txt, pdf, csv, ...) can be accessed
if and only if

  1. the text files are in the → ASD or in the → Private dir (i.e. were saved there), or
  2. the text files are in one of the Shared folders /Documents or /Download and
    these files were created by the app itself
1 Like

and...?

So which is it ?

1 Like

Currently, it is working on my phone Android version 11. But, we can assume that Android will bring more restrictions for the safety of users in future updates. But, currently MFile has no option to read file directly if I am correct. So, in the upcoming update of MFile if there will be blocks (that included SAF technology in it) to read file, that will help users like me to read files without any kind of interruptions even in Future Android Updates. Thankyou @TIMAI2 , @Anke .

Of course, it has, but the non-media file (.txt, csv) must be created by the app itself.


And again, the File component cannot read it on Android 13+ (even if it is created by the app).

1 Like

I tested both File component and MFile extension. Both are giving same result. Thankyou :slight_smile:

No, not on Android 13+.

1 Like

If both never work on Android 13+, then will you upgrade MFile extension with SAF as its one of the background technologies. ie, All SAF concepts must work on the background, we want only simple.MFile blocks.

Hi, @The_K_Studio , guide me so I can learn using this CSV Reader extension. Right now, I am not able to read csv files in my Android 11 version phone, using this extension. Can you help me to solve this?

First tell us, where is your csv file located? Is it in ASD or in Download folder?

Also is that file created by your app or is it already existing on the device creted by other app or are you downloading that file from your app?

The file is created by the app itself in Download folder using MFile (save file block). Both Mfile and File component are reading the file and displaying it in label successfully. But, CSV Reader extension is not doing that.

===================================================================
Capture1

I didn't say that. So once again and for the last time: My MFile extension works on all Android versions, but the File component unfortunately doesn't (at least not as far as the reading method is concerned on Android 13+).

1 Like

The extension uses/needs an absolute path, not a full path. So remove "file://".

1 Like

Yes, it worked now.

If your csv file dont need to be visible to users you can save it in ASD and read from it with any extension.

With ASD you dont have to worry about permissions on higher Android versions.

1 Like

Okay.
I have another doubt. When I searched in chatgpt I found that there are lot of types of CSV. Is it so? Why the csv file that we make in mit ai2 has unnecessary double quotes'' '' in between the data. How can we convert these Quoted CSV into Standard CSV?

My csv file has values only 1,2,3. But, the CSV Reader is reading it as ''1'',''2'',''3''. And, if we save any csv data using mit ai2, it is saving as quoted csv. What I do want is only Standard CSV. How can I do that?

CHATGPT => CSV TYPES: Standard CSV, Quoted CSV, CSV with escaped quotes, CSV with different Delemeters.

I Want only Standard CSV.

Help me.