Hi
We had a requirement to update a custom field in the location table: cmn_location.
The import set was a basic match of sys_id and the custom field.
When I ran the import set, I selected coalesce on the sys_id.
The import ran without error. But when the cmn_location table is now viewed in a list, all (and I mean all) fields show "empty". However opening each location shows it is fine, with all fields including the custom field intact. If I dot walk to those fields from another table (eg Asset), the fields also appear okay int he list.
The records that were not referenced in the import are unaffected.
How can I reinstate the fields in the view? I really don't want to import these records and start over, as too many dependencies within our instance and also external systems, the existing sys_id of these records must be maintained.
Thanks in advance.
Hi
Unfortunately, the cmn_location table is not audited, so I can't tell.
I can open each record by clicking on the "Name" column and everything looks fine, including its related records (asset, cases etc).
I have tried updating the record but there is no change in list view.
This one of the records in the import set.
This is the field map for the import set.
Was I wrong to coalesce on sys_id?
S.
Hi
I turned on auditing in Dev instance and tested the import on a few records.
The only field that has changed for the affected records is what was expected: the custom text field. No other fields were updated.
The outcome is the same; the updated records do not show any field values in list view, but opening the record shows all fields present. The fields are also displayed correctly in, say, the asset list view.
From the record, if I select Export->XML, the downloaded file is blank with only:
Really weird - would appreciate your thoughts.
S.
