Update, the below issue was figured out to simply be a wrong SYSID was used in the xml, which was for a nonexistent record. I would welcome advisement though around if you are using a different method for fixing Asset to CI associations than this manual edit and re-import of XML? if there are many to fix, that'll be a time consuming activity for sure!
The Objective: So when Asset & CI tables have duplicates and are a mess in general, we're struggling to figure out a method to correct the association between Asset and CI records. If one wants to associate a CI and Asset record manually how can this be done since those fields are read only? (set by the dictionary)
i'd rather not wipe and start over as there is data there and associations to other things like users etc. seems rather frustrating to not be able to update that association manually. Hopefully one of you has direction to help me make progress
Option 1 (which at first i thought was broken but i just didnt have the right sysid):
- export the xml for your asset record and CI record you want to associate.
- get the sysid and display name for each of those records.
- in the CI xml (see screenshot below of the CI xml example that i had messed up due to wrong sysid): where it says 'asset_display_value' you provide the asset record display name and then the sysid between the asset tags.
- Likewise you find similar in the asset record for associating the CI
Other options?
what follows here was the original post where i thought something was broken, but it was just my 'oops' on using the wrong sysid when attempting to associate the asset record in the ci xml.
example below: this CI isnt showing the Asset display name even though i have tried importing xml which has the display value and sysid, for some reason the display value is being dropped though the sysid is intact. Also on the Asset record i want associated to this CI, i was able to do an import set with the CI referenced, and ON THE ASSET the ci field shows the below CI which is really odd since that reference isnt displaying on the CI itself. (see attached asset-ci image)
my XML:
