[Dwight Bailey]

Thanks Steve! Very strange, because it was working fine a week ago!!
I’ll have to try and figure out what changed!! Maybe our IT people implemented some other plugin that is doing the ‘asyncScripts’ thing. It certainly gives me more places to look! Thanks!
Steve K (for Dwight:)

[Dwight Bailey]

Thank you so much for your super-speedy response, Steve.
I disabled W3TC, but the problem persists. I’m wondering if W3TC still is affecting the site even after disabled. But that’s not your problem…I’ll have to look into that, but if you have any other thoughts that would be great.
Thanks again!
Steve K. (for Dwight:)

[Dwight Bailey]

Ok, I was afraid of that.
If, for example, “Lisa Smith” gets divorced and changes to her maiden name, “Lisa Jones”, I don’t think she will be happy to have to keep using …/lisa-smith as the link to her profile. Oh well, maybe in future updates you’ll consider updating shortcodes when people change their names.
:)
I’ll figure something out. Thanks!
Steve K. for Dwight.

[Dwight Bailey]

Steven, that worked perfectly! Thank you so much.

Unfortunately, this revealed an issue from CSV Import.
When testing my spreadsheet to ‘perfect’ the formatting of my data for CSV Import, several errors occurred on my end, including incorrect insertion of first/middle/last names, etc.

So when I look at the individual pages, sometimes the name in the link looks correct, like this:
Alexander Angerhofer
https://newsite.chem.ufl.edu/people/name/alexander-angerhofer/

And other times the name in the link is using the wrong name (or using the the middle initial-firstname instead of firstname-lastname):
Rodney J. Bartlett
https://newsite.chem.ufl.edu/people/name/j-rodney/

So this means that the slug is now incorrect for these names (the data table is wp_38_connections). I even went into Connectons => Manage and changed the name manually that way, but the slug doesn’t change. If someone changes their name (e.g. if they get married), shouldn’t the slug change as well?

When I do the CSV Import, I don’t see a field to define the slug value, or a way to change it in Connections=> Manage. Is there some other way to change the slug? Or do I need to delete all my data and re-populate it? I hate to do that because I manually uploaded photos for them (and just changing the slug also “removes” the image). I probably can write some php to modify the database if I must, but I’d prefer not to do that and risk making more of a mess.

Sorry to bring you all these strange occurrences.
:)
Thanks again!
Steve K. for Dwight.

[Dwight Bailey]

Ok, it seems that duplicate categories occur if there already is a category of the same name but with the FIRST letter capitalized. So (for example) the already-existing category for one was “Faculty” but the data had “faculty”. So if the new category is created during the import, subsequent entries with the same category cause multiple copies of this category, which then must be deleted. I think it also can happen if the shortcode isn’t identical as well. An example was a “physical” category with a short code “physical-research-areas” instead of just “physical”.

Also, I noticed that, when importing already-existing records using the Entry ID, if we have blank fields and there is existing data (specifically we tested the website and bio fields), the preexisting data is not deleted. So if we have fields that need to be erased during Import CSV, how would we do this?

I hope this gets you closer to figuring out what is happening.
:)
Steve K. (for Dwight).

[Dwight Bailey]

Oh wow, that definitely was XML code my PHP was supposed to filter out.
I’ve fixed that, and you can download the new cleaner file at the same link as before.

That file still created duplicate categories, though (again, only on rows with multiple categories separated by commas; rows with only one category do not create duplicates).

I wonder if it only does it when you upload the file the 2nd time? The first time I ran it, I set the “Entry ID” field to “Do Not Import” (otherwise, it can’t find an entry with that ID and doesn’t import any data). Then after that, I let it map the “Entry ID” field so it would update the existing data rather than create duplicate entries.

It’s not a big problem; I’ll try again after the next update.

Thanks again!!
Steve K. (working for Dwight:)

[Dwight Bailey]

Hi, Steven.
Thank you so much for taking the time to test my large file! Yes, there is some HTML in some bios and custom fields (

<

p> and
tags mostly, and some links and ULs–and hidden in there there may be some tags I don’t know about). Are you saying that bios and custom fields can’t have html tags? If you can give me 1 or 2 examples of the types of tags you think might be causing a problem, I’ll be happy to ‘clean them up’. :)

Other than that, I’ll await the update, take your category renaming suggestion, and let you know how it goes. Are you saying to delete the category name, save, then edit the blank category and re-enter the name, or just delete/retype/save as one operation? (just checking; again, sorry for my confusion:)

[Dwight Bailey]

Oh, and the first field is the Connections ID#. I’m using that if editing, but you can choose not to map that field to test it as new entries:)

[Dwight Bailey]

This reply has been marked as private.

[Dwight Bailey]

OOPS, I was wrong: In #2 above, all the categories are showing up just fine! They weren’t showing before because they had no people assigned to them. Sorry about that.

[Author]

Posts