I used this code snipped to attempt to bulk replace some data in a user custom field. I derived it from the Ning importer . users=User.where("users.created_at <= '2019-09-13'::timestamp") users.each do |u| u.custom_fields = {"user_field_16" => "Nil"} u.save end However it had the unintended con…

I find this a useful tool for getting the rails syntax right when you want to manipulate these UCFs in the Rails console: If you are replacing data in that field UserCustomField.find_by(user_id: =UserID=, name: "=UserFieldName=").update(value: "=NewValue=") (will give you an error if there i…

I think this format changes only the custom field in question. I’ve tested it briefly, and it seemed to do the trick. :+1: users=User.where("users.created_at <= '2019-09-13'::timestamp") users.each do |u| u.custom_fields["user_field_16"] = "Nil" u.save end Though if you wanted the field to be …

Also something like UserCustomField.create(user_id: 1, name: "user_field_4",value: "Oops") Oh, but if that already has a value, it’ll add a second one! So you might ucf=UserCustomField.find_by(user_id: name: 'user_field_4') and then you’d need to either update it or create a new one. But if y…

[image] nathank: u.custom_fields = {"user_field_16" => "Nil"} By doing this, you’re replacing everything in the u.custom_fields hash with {"user_field_16" => nil}(note the nil without quotes)

[image] JammyDodger: u.custom_fields["user_field_16"] = "Nil" Thank you - yes, that is what I should have used. [image] fzngagan: By doing this, you’re replacing everything in the u.custom_fields hash with {"user_field_16" => nil} (note the nil without quotes) Yup, that is exactly wha…

How did you create that dynamic content in the post?

It seems that meta has this component on. (Just guessing [image] Placeholder Forms Theme component discourse2 Summary Placeholder Forms will let you build dynamic documentation, by creating a form that replaces any occurrence of a =PATTERN= in your post …

Manipulating custom user fields from the Rails console

Development

nathank (Nathan Kershaw) February 18, 2022, 6:44pm 6

Thank you - yes, that is what I should have used.

Yup, that is exactly what happened. I felt pretty foolish afterwards!

Topic		Replies	Views
How can I force users to fill in a custom field when it’s empty Development	7	587	May 6, 2022
Update user information in bulk Support	5	955	April 30, 2022
How to write a ruby code that add a new user's data to a user_custom_fields Support	3	1112	July 23, 2017
.csv upload for bulk user custom field changes Feature	7	1255	January 18, 2024
User custom field with plugin Development	2	2064	May 5, 2017

Manipulating custom user fields from the Rails console

Related topics