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 "Nil"} u.save end However it had the unintended consequence of wiping the users’ other custom field values. Can anyone suggest a way to modify a user custom field value from the console that doesn’t cause chaos?

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 isn’t any data in that field yet) If you are filling that field for the first time UserCustomField.create(user_id: =UserID=, name: "=UserFieldName=",value: "=NewValue=")

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 NULL rather than say ‘Nil’ you could try this instead: users=User.where("users.created_at <= '2019-09-13'::timestamp") users.each do |u| u.custom_fields["user_field_16"] = NIL u.save end

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 you do create multiple ones, the UX will show them comma-separated, and if they are edited via the UX when they get saved, they get saved back to a single value. You can have a look at them with UserCustomField.all Or UserCustomField.where(name: x) That’s by memory on my phone so your mileage may vary.

[תמונה] 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)

[תמונה] JammyDodger: u.custom_fields["user_field_16"] = "Nil" Thank you - yes, that is what I should have used. [תמונה] 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 what happened. I felt pretty foolish afterwards!

How did you create that dynamic content in the post?

It seems that meta has this component on. (Just guessing [תמונה] 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 with the value from a text or selectable input field. eyeglasses Preview Preview on Discourse Theme Creator hammer_and_wrench Repository Link https://github.com/discourse/discourse-placeholder-theme-component open_book New to Discourse Themes? Beginner’s guide to using Discourse Themes Install this theme component …

מניפולציה של שדות משתמש מותאמים אישית מקונסולת Rails

מפתח

nathank (Nathan Kershaw) 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!

נושא		תגובות	צפיות
How can I force users to fill in a custom field when it’s empty Development	7	604	6 במאי,‏ 2022
Update user information in bulk Product Support	5	988	30 באפריל,‏ 2022
How to write a ruby code that add a new user's data to a user_custom_fields Product Support	3	1135	23 ביולי,‏ 2017
.csv upload for bulk user custom field changes Feature	7	1347	18 בינואר,‏ 2024
User custom field with plugin Development	2	2086	5 במאי,‏ 2017

מניפולציה של שדות משתמש מותאמים אישית מקונסולת Rails

נושאים קשורים