Reply To: MySQL Bulk update on address line 1

01/17/2014 at 6:23 am #277309
Paul Chitson
Participant

Hi Steven

Thank you for your continued help on this.

I’ve restored the Functions.php file back to its original state. Installed Code Snippets and imported the XML file. All good so far. On testing I am still not getting the result I am looking for, which is shame.

If I update the Line_1 from the Connections Manager screen. The change is saved into the wp_connections table in “addresses”. However the wp_connections_address table remains unaltered. Thus when looking at the persons contact details it isn’t showing the update because its now looking at the wp_connections_address table and not wp_connections. I hope that makes sense.

While you are working on this I am also trying to create a SQL query to extract all the user information so I can do a re-import. That is providing it’s own challenges but it will give us a second option.

Thanks again.