Why user and record type lookups are not filled on insert?

Question:

I'm importing data from a CSV source into a custom object with a custom Lookup field to the User object, but the field isn't being filled when inserting new records. Why is this happening?

Answer:

The issue is often caused by missing lookup source CSV files for referenced system objects.

For CSV-driven migrations, ensure the required lookup data is present:

  • RecordType.csv for RecordType lookups.
  • User.csv and Group.csv, or a combined UserAndGroup.csv, for User/Group lookups.

You do not need every possible CSV file, only those required by lookup references used in your object set.

Related Articles

Last updated on 17th Feb 2026