Uploading address data

I’m am trying to upload a csv of data that has 4,089 lines or rows, and 6 columns. One column has a unique address, formatted in the cell as, ‘4308 Victory Ave, Columbus, OH 45208’, other columns are just text and numbers related to the address.

I’m aware of there being a Google query limit for addresses, but I can’t seem to break down the upload into any reasonable chunk size, e.g. 900, 500, 250, and 100…I’d love to skew closer to 900 as chunks of 100 would entail 45 days of uploading just to finish the full ~4K row data set. I run into these 3 issues after I click ‘validate data’:

1. Initially tried to break ~4K entries into chunks of 900, this would result in hitting the query limit or one of the 2 issues below

2. When I tried to submit chunks of 100, 250, and 500, I would hit one of these 2 issues:

a. “There was an error analyzing your data: Error: u.run_once timed out after 30 seconds”

b. It tells me a particular entry is not an address, when it is an address and I can submit it individually as so…it won’t let the validation process continue after this → I’ve tried using the address format stated above and lat/long as well to make sure that wasn’t the answer

Any strategies on how to get my 4K entries up in reasonable chunks? As a side note, I’ve also tried uploading 900 rows with the address actually uploaded into a field type that was ‘text’ instead of ‘geographic address’, and that worked…then I put in the workflow to make the geographic address field used previously to equal the ‘text’ version, but that then breaks the code.

You should do this over a few days. Also, when an address gets rejected, try to put it in Google maps and see how it gets formatted. There’s not much we can do if Google doesn’t recognize the address.

if you hit the error reliably, please email us at support@bubble.is with a clear way to reproduce.

Hi, same topic but different approach.
Actually I want the user to click a button to upload a csv file with customer data (firstname, lastname, email) in the application. This data should be used automatically to update the customer data in the database.
I tried to use the file upload, but can´t find a way to store the csv file content in the database.
How can that be done?

Thx, Dennis

1 Like

This is not something we support yet. You can upload a file, but that file will be stored as such, not analyzed and converted in a database entries. That would be a new feature, get in touch at support@bubble.is if it’s important and we can chat about adding it on a custom basis.

1 Like

Hello Emmanuel,

I’ve run into this issue and have tripled checked Googles formatting. Here’s the error I get when importing CSV (one of many). Would appreciate any feedback :slight_smile:

Ex (There was an error analyzing your data: 6 Bridge St, Maidenhead SL6 8BJ, United
Kingdom doesn’t have the type geographic address. Please fix: this is row 1.)

Best regards

Hi there,

To further express, this exact same address “6 Bridge St, Maidenhead SL6 8BJ, UK” works when being imported as an individual address but this error still shows when imported to a list of addresses.

Here’s a few screenshots:

(same address in two cells within CSV, using | as delimiter)
Showing import settings, ignore all but address for now.

Tried to validate, error with uploading to address list. You can see the main address is imported fine when choosing to ignore the address list.

Validates perfect w no issues now… Same exact address with same formatting.

(image shows database within Bubble) Imported the main address with no issues…

Would love some thought here :slight_smile: @ecaterina.cheptini

Best regards,