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.

[imagen] 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)

[imagen] JammyDodger: u.custom_fields["user_field_16"] = "Nil" Thank you - yes, that is what I should have used. [imagen] 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 [imagen] 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 …

Manipulando campos de usuario personalizados desde la consola de Rails

Desarrollador

Kuro22 5 Agosto, 2022 03:01 9

Parece que meta tiene este componente activado. (Solo estoy adivinando)

Tema		Respuestas	Vistas
How can I force users to fill in a custom field when it’s empty Development	7	598	6 Mayo 2022
Update user information in bulk Product Support	5	977	30 Abril 2022
How to write a ruby code that add a new user's data to a user_custom_fields Product Support	3	1125	23 Julio 2017
.csv upload for bulk user custom field changes Feature	7	1296	18 Enero 2024
User custom field with plugin Development	2	2076	5 Mayo 2017

Manipulando campos de usuario personalizados desde la consola de Rails

Temas relacionados