Are you saying that you have a backup of the Asset data that was in Remedy? Does that backup include the Reconciliation ID? If it does, then you don't need to match on anything, you would simply need to do a Merge between the datasets, because everything should already be matched up (by definition, anything that has a recon id (something other than zero) is already matched to something, so it doesn't try to identify it again). You might need to define Precedence rules to only set the fields that have gone missing (to avoid overwriting any other data that may have changed since the backup), though.
Lyle From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Pierson, Shawn Sent: Thursday, December 10, 2009 10:29 AM To: [email protected] Subject: Using AIE to restore Asset Data ** Good morning, We had a recent problem where a bunch of our Asset data was wiped out. The records exist, but some of the fields were made null. I came up with the idea of using AIE to fix this problem by restoring the Asset data from a backup and treating it as external data to import. However, I've been told that I can't match on either the Request ID or the Instance ID, so I am curious if anyone here knows of a system generated unique id that I can use to match the old record with the new record. Thanks, Shawn Pierson Remedy Developer | Southern Union Private and confidential as detailed here<http://www.sug.com/disclaimers/default.htm#Mail>. If you cannot access hyperlink, please e-mail sender. _Platinum Sponsor: [email protected] ARSlist: "Where the Answers Are"_ NOTICE: This email message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
