We have one field that we need to change with different settings for many users. Is there a fast way to do this? Can we export the entire list and then import and update it. I don't think that will work at all. but if it did that would be nice. We have 400 members that need to have a single field changed. Every user is going to be slightly different. What to do? Other than start going through one by one.
The simples way to do this is to create php script that will update all users. What should be changed and what is the pattern for new field? I will provide an example of script.
Yeah, not that easy unfortunately. Ever user has a category. There are 381 categories. They all have seperate id numbers. Looks like it will be a download the SQL, edit and upload and change. I think PHPmyadmin will allow you to upload and if it finds any duplicates, which it will, it will only add the changed fields or overwrite them. Is that a possibility. I haven't looked or tried it that way but is seems like that was an option when importing in phpmyadmin. Basically you have to go through each member look at their particular cat and then erase the old number and put the new number in. Which ever of the 381 categories it is.. Clients always think their is some magic way it all happens. If they would only specify before the first import their wouldn't be any headaches after....
You can write a PHP script with logic that knows the old cat and the new cat and do the switch with that. Loop through users, check their old cat, replace it with the appropriate new cat and save the user.