Has anyone else had issues moving a Google Sheet app to a Google Cloud SQL database? I’m curious if someone could let me know where I went wrong with mine. The automatic copy to SQL from Appsheet didn’t work for me. Not certain why. So I went and manually created all my tables and columns in my database and then attempted to important a CSV downloaded from Google Sheets with no luck. Tried a variety of different methods with MySQL Workbench crashing every time I tried. Eventually, I tried downloading the Google Sheet in .ods format and then saving to CSV from there on my PC instead of going straight from Excel. After that I was able to import all of my CSVs with no issue. I’m just curious for future what the cause of this may have been. Files always showed encoded as UTF-8 if that matters.
LinkedIn
Twitter
