Forum Documentation Showcase Pricing Learn more

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 [email protected] 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 [email protected] if it’s important and we can chat about adding it on a custom basis.

1 Like