Hi all, One more question regarding custom user profile fields and csv imports. It appears the fields we can populate using the cv imports is limited, but we’d like to populate some custom user fields we’ve created. In taking a look through this support forum, I “think” it’s possible, but I’m not sure how, or how complicated it will be. Again, thanks in advance for helping this newbie out. I have lots of smarter people involved who can help implement once I give them the initial info! :slight_smile:

And by “using that as an example” I presume you mean we could use that as a template for scripting a custom import of our own? It looks like ning imports json, and we’re looking to import from a csv file. I should probably be more clear - we’re hoping to import several thousand users and send them an invite to our new discourse environment. When we import those users, we’d like to add some custom field data to their user profiles. Is the ning importer still the best option to accomplish this? Or, alternately, is there a better means to do it? Thanks again

My idea was that you’d see how the Ning script created and populated custom user fields and modify your script to do the same. You’d not change the part of your script that reads the csv file. It sounds like you also need to look for a script that reads a CSV to see how to read a CSV in ruby. I think that I had assumed you had that part figured out. If you have a budget, my contact information is in my profile.

Here is a class we used to import custom fields and to assign members to a group(s). require File.expand_path( "/var/www/discourse/script/import_scripts/base.rb") class ImportScripts::BD2L < ImportScripts::Base def initialize super @htmlentities = HTMLEntities.new @import_config_file = ARGV[0] raise ArgumentError.new('Bringing Data to Life import script config file argument is missing. Provide the full path to the config json file.') if @import_config_file.blank? end def import_users(import_array) puts "import_users.started" if import_array == nil then puts "import_users: skipped." else puts "import_users.import_array: #{import_array}" candidate_users = Array.new import_array.each do |import| puts "import_users.import_array.import: #{import}" mobile = UserField.find_by_name("Mobile") landline = UserField.find_by_name("Landline") postcode = UserField.find_by_name("Postcode") groups = Array.new import['groups'].each do |group_name| group = Group.find_by(name:group_name) if group == nil then # ignore else groups.push(group) end end @members = parse_import_json_file(import['path']) @members.each do |member| # puts "import_users.import_array.import.members.member: #{member}" email = member['email'] if email.length == 0 then email = member['name'].gsub(' ','.').downcase + '@domain.com' puts email member['email'] = email end if email.length > 0 and member['name'].length > 0 and email != '@domain.com' then #puts email user = User.find_by_email(email) if user == nil then username = member['name'].gsub(' ','.').downcase member['username'] = username #puts "create" candidate = {} candidate['id'] = member['external-id'] candidate['username'] = member['username'] candidate['name'] = member['name'] candidate['email'] = member['email'] candidate['mobile'] = member['mobile'] # user custom field candidate['landline'] = member['landline'] # user custom field candidate['postcode'] = member['postcode'] # user custom field candidate['groups'] = groups candidate['mobile-user-field'] = mobile # userField candidate['landline-user-field'] = landline # userField candidate['postcode-user-field'] = postcode # userField candidate_users.push(candidate) else groups.each do |group| if group.user_ids.include?(user.id) then # already a memeber else group.add user end end end end end end # import_array.each do |import| if candidate_users.length > 0 then puts "calling create_users with candidate_users.length #{candidate_users.length}" create_users(candidate_users) do |candidate| { id: candidate['id'], username: candidate['username'], email: candidate['email'], name: candidate['name'], active: true, approved: true, post_create_action: proc do |user| user.save puts "user.id: #{user.id} user.email #{user.email}" candidate['groups'].each do |group| if group.user_ids.include?(user.id) then # already a member else group.add user if user.primary_group == nil then user.primary_group = group user.save end end end mobile = candidate['mobile-user-field'] landline = candidate['landline-user-field'] postcode = candidate['postcode-user-field'] if candidate['mobile'].length > 0 then user_field_name = sprintf("user_field_%d", mobile.id) user_custom_field = UserCustomField.where(user_id:user.id,name:mobile.name).first if user_custom_field == nil then user_custom_field = UserCustomField.create!(user_id: user.id, name: user_field_name, value: candidate['mobile']) else if user_custom_field.value != candidate['mobile'] then user_custom_field.value = candidate['mobile'] user_custom_field.save! end end end if candidate['landline'].length > 0 then user_field_name = sprintf("user_field_%d", landline.id) user_custom_field = UserCustomField.where(user_id:user.id,name:landline.name).first if user_custom_field == nil then user_custom_field = UserCustomField.create!(user_id: user.id, name: user_field_name, value: candidate['landline']) else if user_custom_field.value != candidate['landline'] then user_custom_field.value = candidate['landline'] user_custom_field.save! end end end if candidate['postcode'].length > 0 then user_field_name = sprintf("user_field_%d", postcode.id) user_custom_field = UserCustomField.where(user_id:user.id,name:postcode.name).first if user_custom_field == nil then user_custom_field = UserCustomField.create!(user_id: user.id, name: user_field_name, value: candidate['postcode']) else if user_custom_field.value != candidate['postcode'] then user_custom_field.value = candidate['postcode'] user_custom_field.save! end end end end } end else puts "No processing done for candidates candidate_users.length #{candidate_users.length}" end # if candidate_users.length > 0 end # if import_array == nil then puts "import_users.finished" end def parse_import_json_file(path) puts "parse_import_json_file('#{path}')" text = File.read(path) result = JSON.parse(text) return result end def execute @config = parse_import_json_file(@import_config_file) import_users(@config['users']) end end if ARGV[0] == nil then ARGV[0] = "/shared/bd2l/members-configuration.json" end ImportScripts::BD2L.new.perform

Custom user fields and csv import

Product Support Migration

pfaffman (Jay Pfaffman) January 3, 2019, 3:45pm 2

The Ning importer imports custom user fields. You can use that as an example.

Topic		Replies	Views
Importing a custom user profile field from legacy forum software Development	3	607	May 1, 2020
Ning import script Feature feedback	63	11833	December 5, 2017
.csv upload for bulk user custom field changes Feature	7	1346	January 18, 2024
Import custom fields of user with import_scripts Ruby Migration drupal	8	668	August 18, 2023
Import Users via CSV Product Support	10	331	December 19, 2025

Custom user fields and csv import

Related topics