spooky650

Update Resolved.

I have received the following answer and used it to change all the nickname records to a different value.
s2Member’s “Advanced Import/Export Tools” could help you with this. They will export and allow you to re-import meta_key__nickname. The documentation for s2Member’s Adv. Import/Export functionality can be found here: http://www.s2member.com/kb/advanced-import-tools/

What I did was export my list of users in advanced export mode. The meta_key__nickname is then exported (I could then see the ID was the same as the meta_key__nickname). Then created a new csv file with just the ID and meta_key__nickname column headings. I matched the ID with the surname of each user and used the surname as the meta_key__nickname, so it is different to the ID but still relevant to the user. I then imported the csv (in advanced mode) with only those two values for each user, and it updated the whole list of users with their new ID field.

When using advanced mode you can update just one value of the users data, or many.

The csv file should look like this.
“ID” “meta_key__nickname”
“1” “JONES”
“2” “SMITH”
“3” “BLOGGS”

Thanks for the reply, but that hasn’t fixed it??