I’m at wits end (and bottom of the tokens bucket) trying to bring tables of static data into an A.I. app.
The bot says I can:
"Export your Google Sheet or CSV as JSON (use a free converter like csvjson.com)
Save it as a file in your project assets (e.g., foods-data.json)
Import and seed on first app load:"
But there is no capacity to put tabular data into the project assets.
I went and set up an account at Supabase, only to find that this setup is only for all-cloud storage projects. A key feature of my application is that all data is to be stored locally.
I did manage to get the bot to read a CSV file from a shared Google Sheet, but then one thing or another goes haywire…
The bot (un)helpfully started this app with a small hard-coded table of generic data, 20 rows of six columns. I now want to replace that table directly with a table of 5280 rows of 52 columns. All this data is fixed and permanent, the user will be able to view an item in detail and copy it to a local user table, with edits as desired. None of those forms have been built yet.
The bot simply fails in a wild variety of ways, from scrambling the new columns to losing calls to the original table name to variable undefined errors. I tried asking it import a new table. I tried over-writing the old table. I asked it to completely delete to old table and start new.
I tried paring down the new data to 100 rows to speed things up, but that didn’t help much.
How can I get this done?? Again, I just want a pile of static data, permanently in the application. I’m not worried about updates outside of the user installing a new app version.
EDIT: I peeked at the code before and after an attempt at importing the 100 line table. I asked it to directly replace FOOD_CATALOG…
First of all it made a new variable name, FOOD_CSV_DATA, instead of reusing the existing name. Also, this looks like one very long invalid line of code, nothing like the old multi-line list. Does this have to do with the displayed pop-up error?
And I bet there are still calls for FOOD_CATALOG.