Cannot parse text argument to "list from csv table" as a CSV-formatted table

MIT App Inventor Help
1

Hi,
I know this topic has already been discussed, but I do not find the solution to my problem.
I can retrieve datas from a csv document internally uploaded in the app ; this works.
But when a save the same file in google drive or in dropbox, I can't get the content.

The app builder here tells me "Cannot parse text argument to "list from csv table" as a CSV-formatted table".
Here are my blocks :
image

Here is the design :

image
image304×550 29 KB

Here my csv doc (just for testing) :
image

And here, I have put the responsecontent in the third Label to eventually see what's wrong :

image
image698×445 114 KB

Thanks for your help :wave:

2

Your fuzzy Dropbox responseContent definitely does not look like Comma Separated Values (CSV).

Work on your Dropbox web request.

3

Blockquote @ABG Work on your Dropbox web request

I've tried but to be honnest I don't know how to do.
The same structure with google drive address of my csv-doc gives the same kind of responsecontent.

4

Here's my current collection of download examples ...

5

Well ...
I've noticed a error, that I have corrected (columns instead of rows)
I have put in the program retrieval of a doc in google drive
and I have tried to add some labels so it becomes clearer what is what
... but I still have the message "Cannot parse text argument to "list from csv table" as a CSV-formatted table" and it obviously doesn't retrieve anything (though I don't have the big amount of text previously displayed).

image
image

6

Here's my current collection of download examples ...

thank you, I go exploring :slight_smile:

7

In each of the web Got Text events, capture your responseContent for debugging BEFORE trying to convert it to a table. Don't give the event an excuse to die prematurely before you can capture the response.

8

Also check the sharing settings on your Dropbox file online ...

Capture
Capture584×569 45.8 KB

9

In each of the web Got Text events, capture your responseContent for debugging BEFORE trying to convert it to a table. Don't give the event an excuse to die prematurely before you can capture the response.

I needed a wile to understand :joy:
ok, done : now I have for each ResponseContent (dropbox and google drive) the same kind of <!DOCTYPE ... text as before though there's much more for dropbox then for google drive (do you need me to make a hundred pics to show you the exact content ?)

Also check the sharing settings on your Dropbox file online ...

I made right-click and share link
or I could open it in dropbox : image

google drive : share > everyone having the links can access (free translation from french)

I don't understand how to find the ID of the sheet as demonstrated here
image

11

In a Google Sheet, the file ID is the longest piece of text between slashes (/) in the URL.
It's long because Google has a LOT of them.

12

https://docs.google.com/spreadsheets/d/1z9Xg8vykhS5veSY8kIGImeQI-iJTjX-uQLPUThzP-2s/edit?usp=sharing
that part ?

I made it so : image

And I get : "Error 1101 : unable to get a response with the specified URL"

13
14

Google sheet problem solved !!
instead of simply copying the link https://docs.google.com/spreadsheets/d/1z9Xg8vykhS5veSY8kIGImeQI-iJTjX-uQLPUThzP-2s/edit?usp=sharing
I had to change the end of the link to convert it in a csv file, as shown here https://groups.google.com/g/mitappinventortest/c/Xtrwf7u2Qo4
so, it becomes : https://docs.google.com/spreadsheets/d/1z9Xg8vykhS5veSY8kIGImeQI-iJTjX-uQLPUThzP-2s/export?format=csv

I guess the dropbox problem is similar (some kind of anything in the late extentions of the sharelink name... but what ??) ... does anyone have an idea about it ?

Thank you for your patience and help @ABG :slight_smile: :smiley:

15

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.