Unable to import Database Picker Custom Field through CSV

Question

I have few Custom fields which is of type "Database Picker Custom Field" in source instance. Tried to import it to other instance using CSV file. Getting "ORA-01722: invalid number" error. So changed the value in CSV file with replacing it with custom field option Id ,now it's working fine.But is their any solution to import this type of fields without replacing it with option I'd?

Bhargavi Vasa · Answer

The option ID in the source instance and Target instance will be different . So it is not going to map the field value even if option ID is given in CSV.

Can we modify Validation SQL and Search SQL to only validate/check for the field value not the option ID?

Or

Do we have any way to map this Database Picker Custom Field value to other instance?

Nic Brough -Adaptavist- · Answer

There is no way to do this.  The database picker field does not contain the actual data, it contains a way to look up a value in a field.  When you export it to CSV, it gives you the value, not the lookup.

So if you import it into another database picker field, it won't work - the data you're importing is not what needs to go into the field.

You'll need to map the option ID.

Bhargavi Vasa · Answer

Yes, the mapping was done correctly with the exact field in source and have checked the field value as well.

If I replace the field value by field option I'd ,able to import the field( Ex: For type Database Picker Custom Field "Test", it is fetching options from other field with type of Select List (Multiple choice).

This field "Select List (Multiple choice)" has different options like Test1, Test2, Test3.

If I export the Database Picker Custom Field through CSV, the value in the CSV file showing the the above options (Test1, Test2, Test3) . In this case ,it's showing this error "ORA-01722: invalid number"

Tried with this scenario as that error defines we are converting a string to number. I have replaced the field value by option I'd from "Select List (Multiple choice)".It's working fine if the option I'd is same in Source instance and Target instance.

Any solution to import without changing the option I'd with field value?