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 控制台操作自定义用户字段

开发

Kuro22 2022 年8 月 5 日 03:01 9

看起来 meta 有这个组件。 (只是猜测

话题		回复	浏览量
How can I force users to fill in a custom field when it’s empty Development	7	600	2022 年5 月 6 日
Update user information in bulk Product Support	5	985	2022 年4 月 30 日
How to write a ruby code that add a new user's data to a user_custom_fields Product Support	3	1132	2017 年7 月 23 日
.csv upload for bulk user custom field changes Feature	7	1338	2024 年1 月 18 日
User custom field with plugin Development	2	2081	2017 年5 月 5 日

从 Rails 控制台操作自定义用户字段

相关话题