I’m trying to upload a list of business brokers, with one of the fields defined as List of Geographical Addresses. I tried to transform the data to be a list of addresses, separated by ; so it doesn’t conflict with the , in the address, but I keep getting this error while validating the data:
This is the exact entry from my CSV:
Providence County, RI, USA; Bristol County, RI, USA; Kent County, RI, USA
I checked the address on Google Maps and Providence County, RI, USA is the correct way to show it. What am I doing wrong here? Did anyone find a way to upload addresses successfully via a CSV?
So I found a workaround to this. These are the steps I followed to load my list of geographical addresses in Bubble through the CSV upload tool:
I searched for the [STATE INITIAL], in a tool like Google Sheets, and replaced the , with a ;
Then I created an list of texts field in Bubble, in my dataset, called text_geo_address
I mapped the address list to the list of text_geo_address field, with ; as the separator and uploaded successfully
I created a backend workflow with the right data type to be able to run it on the table I had uploaded my text_geo_address content. The workflow looks at the text_geo_address list and sets the actual list of geographical addresses field as the text_geo_address contents.
After running the workflow on-demand, I was able to bulk upload Brokers data and populate the addresses field automatically.
For anyone else, you need to make sure your google maps api key in your settings area has google address validation api enabled. This is what bubble uses to validate the addresses you upload in your csv. Took me a while to figure this out
