Import custom fields of user with import_scripts Ruby

Support Migration

AI-generated summary

LN_test is trying to import custom user fields using the import_scripts Ruby feature in Discourse. They created a DrupalID field and attempted to import data into it using a JSON file. However, they are having trouble updating the custom fields.

pfaffman suggested searching other importer scripts for examples, but LN_test couldn’t find any examples with JSON files and field names. LN_test also tried importing with a CSV file using the csv_importer.rb script, but it didn’t work.

LN_test shared their CSV file format with the DrupalID field name, but it’s not populating the field. pfaffman advised to find a script that imports custom user fields and add it to the existing script. pfaffman later pointed to specific lines in the csv_importer.rb script that should work, but require defining the ENV variables seen in the script.

1

image
image432×160 3.61 KB

I’ve created the DrupalID field from user fields and now I want to import data into this

create_users(@users_json) do |u|
      {
#        id: u["uid"],
#        name: u["name"],
#        email: u["mail"],#
#       custom_fields: {
#          '1':u["uid"],
#          'DrupalID':u["uid"]
#        },


        id: 2037,
        name: "Test 7",
        email: "test7@gmail.com",
        custom_fields: {
          '1':'test',
          'DrupalID':"test"
        },

        created_at: Time.zone.at(u["created"].to_i),
      }
2

Is this a question is an answer? Are you saying that your code works?

3

Yes code works but not for custom fields
I want to update custom fields also

4

Search the other importer scripts for “custom_field”. I’m sure there are examples; I’m fairly certain I’ve done it before.

5

Yes I checked but we haven’t any example provided of JSON file and field name (what we needs to use)

6

Also i try to import with CSV, but I have same case (Example files missing)

7

Just find any script that imports custom user fields and add that to your script

8

I tried also custom_fields.csv from discourse/script/import_scripts/csv_importer.rb at main · discourse/discourse · GitHub
Field name DrupalID

id,user_field_1,DrupalID,Drupal ID,custom_field_DrupalID,drupalid
23456,John,John,Doe,example,johndoe
23457,Jane,Jane,Smith,example1,janesmith

image
image432×160 3.61 KB

It’s not working, showing field blank

9

Looks like discourse/script/import_scripts/csv_importer.rb at main · discourse/discourse · GitHub should work, but you have to define the ENV seen in discourse/script/import_scripts/csv_importer.rb at main · discourse/discourse · GitHub.