Problems of downloading images from google drive

[dolly99]

Hi, I know this kind of question has been asked for many times, but I still can't fix this problem, sorry.
I want to download images from google drive, and I try to use the way I have found on the Internet.
But it keeps saying"Cannot parse text argument to "list from csv table" as a CSV-formatted table."
Is there something wrong with my sheet file or blocks?
Here is my sheet file: https://docs.google.com/spreadsheets/d/1g3KUUZHxAPNAQMHN-dIuZrSCODcDs55kTMOFxHzYuKQ/edit?usp=sharing
Blocks:
DownloadImages.aia (5.7 KB)

Can someone please help me with it? Thanks a lot!

[dolly99]

And here is my image folder: https://drive.google.com/drive/folders/1W-qmZEGqHjpUQZEhMI6lt6kqlL8ys2hx?usp=sharing
My google script to run the sheet:

Thanks again.

[dolly99]

Hi,
More images would be upload into my drive because our lab wants to use those pictures to do some analysis. And we hope we can do the analysis on a mobile app.
That's why I try this way to get images because there will be lots of images to download from google drive.
But if there's another solution to achieve, I'm glad to try it!
Thanks in advance!

[TIMAI2]

@Meulencv

This is about google drive, not free web hosts.

Also please do not spam unrelated material in your posts, you already have your app in the App Showcase for people to see.

[TIMAI2]

I will have a look and see if I can find the issue for you

[dolly99]

Thanks. Truly appreciate your help!

[TIMAI2]

@Meulencv This again is not helping!!

[TIMAI2]

Your sheet with filenames and file IDs is good.

I have edited your download url to:

Your blocks work and download all the files without error.

Depending on your Android version, if Android 10 or 11, when testing in companion the download file path will be inside

/storage/emulated/0/Android/data/edu.mit.appinventor.aicompanion3/files/Download/GDFiles

Remember to clear the tinydb tag and refresh your companion when testing

[dolly99]

Hello, sorry for bothering you
I edited my download url, but the same error showed up.

I'm using the emulator for connection. Do I have to change the download file path?
And I'm sorry that I don't understand what does "clear the tinydb tag" mean...

Thank you so much again.

[TIMAI2]

Try your blocks like this:

Do you get the same output ?

[dolly99]

Uh oh, no. It turns out like this.

[TIMAI2]

Hmmm an issue with the emulator and connection method. See here:

How can I read values from a Google spreadsheet?

I am getting below warning since after updating the aistarter. "Cannot parse text argument to "list from csv table" as a CSV-formatted table" the problem is started for even old programmes which were working properly. Please help on this

Can you try connecting your real device via USB, or install an alternative emulator like genymotion ?

Note: there are emulator/real device connection issues at the moment with the companion, but with a legacy connection it is working fine for me with genymotion.

[dolly99]

Okay! I'll try these ways!

[dolly99]

Hello,
I borrowed Android phone from my dad and used AI companion for connection.
And it works!!!
Oh my, I have tried to fix this problem for two days.
You really help me a lot. Thank you so much. And I wish you all the best!

[TIMAI2]