[James Finlen]

This reply has been marked as private.

[Steven Zahm]

@ James

I was going to test an import, which is why I asked for the mapping you plan on using. I’ll be deleting the imported data after I do test imports. I just want to be able to match exactly ask possible to what you have been doing for consistency. You can attach a screenshot the same way you attached the CSV file in your previous reply.

[James Finlen]

This reply has been marked as private.

[Steven Zahm]

@ James

Well, got good news for you. I imported your file with zero issues. All 941 rows were imported. What I did, nothing, I chose the file and mapped the last name column in the CSV file to the last name field in Connections and mapped the combined named to the first name. It imported in roughly 10secs, pretty fast.

Since I had no trouble, I suspect it had to do with your mapping selections. Specifically require number 2 from the CSV File Setup Requirements.

I’ll do a second test import shortly after deleting these so I can test importing all columns from the CSV file.

[Steven Zahm]

@ James

Ok, so mapping all columns and only the first 100 are imported and the server responds with the “405 Not Allowed” error code.

Not sure what would trigger that from the server.

[Steven Zahm]

@ James

Ok, I narrowed do the issue… I can now import the entire file with all columns mapped to Connections fields. I have not deleted the imported data so you can review.

What I did to resolve.

I installed the Code Snippets plugin and added the following code:

add_action( 'admin_init', 'cn_remove_geocode', 11 );

function cn_remove_geocode() {
    remove_filter( 'cn_set_address', array( 'cnEntry_Action', 'geoCode' ) );
}

What this does is prevent Connections from using Google Maps to geocode an address. It seems some type of server error is being triggered when trying to geocode address. Perhaps Bluehost is rate limiting external connections to other sites???

[James Finlen]

OK, great! So I can follow that same procedure for my other sites and imports, correct? Thanks!

[James Finlen]

Will I still be able to use the Google maps feature in each profile? Thanks!

[Steven Zahm]

@ James

re: So I can follow that same procedure for my other sites and imports, correct?

If you have the same issue on another site, yes, this should work.

re: Will I still be able to use the Google maps feature in each profile?

Yes, it will still work because the geocoding will fallback to a browser based geocode using the Google Maps API.

Depending on your site traffic, you could run up against the daily Google API limit which mean the maps will stop working until it resets or you might have to pay Google for an increased limit. Geocoding when addresses are added is best because the values are cached in the database. Up until October Google Maps were basically free, now with recent changes they are looking to monetize their service. And, for most site, they will still be free as the limit are still quite generous. Just something to keep in mind in case you are running highly trafficked sites.

[Author]

Posts