I am attempting to migrate a custom setting record from one sandbox org to another. I have successfully exported the custom setting record (~150 fields) from org1 to a .csv file. When importing into org 2, I am able to map all of the fields as expected. However, when running the import I have receiving the following error:
FIELD_INTEGRITY_EXCEPTION:field integrity exception: SetupOwnerId (id value of incorrect type):SetupOwnerId --
I have used both dataloader.io and the Data Import Wizard from the Salesforce Setup menu - in both situations I am received the same error. I have also tried both inserting and upserting (created the custom setting record but left all of its fields blank) - in both situations I am received the same error. I have also tried adding a SetupOwnerId column to the .csv file but there does not appear to be a field to map this to. The custom setting itself is public, a List type and is not a part of a managed package.
Has anyone encountered this issue or know of a way to avoid this?