This would best be done easier by creating a new Dataset and importing the data into the new dataset. The only issue will be is there another field such as name that can be used as the primary key for the reconc
-----Original Message----- From: Pierson, Shawn <[email protected]> To: arslist <[email protected]> Sent: Wed, Oct 17, 2012 2:51 pmiliation job. Subject: Re: Updates via Import into Asset ** I’m not sure what the “best practice” is in this case, but since you’re talking about the Serial Number, which is on the Base Element form I’d potentially do it there since it’s the root form and not a join form. It probably doesn’t really matter though unless you are talking about millions of records that may cause database issues. Thanks, Shawn Pierson Remedy Developer | Energy Transfer From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Lisa Kemes Sent: Wednesday, October 17, 2012 1:33 PM To: [email protected] Subject: Re: Updates via Import into Asset ** That's probably a better idea since I don't know AIE yet. I would create the escalation on the AST:Monitor form (for monitors). Correct? Thanks! Lisa On Wed, Oct 17, 2012 at 2:22 PM, Pierson, Shawn <[email protected]> wrote: ** I know all the work was already done manually, but why not just write an Escalation to do a REPLACE on the field to remove the hyphens and avoid dealing with any import issues altogether? Otherwise, Atrium Integrator/AIE in conjunction with the Reconciliation Engine are the “right” ways to update the data, although they are really overkill for one time updates in my opinion. Thanks, Shawn Pierson Remedy Developer | Energy Transfer From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Lisa Kemes Sent: Wednesday, October 17, 2012 1:09 PM To: [email protected] Subject: Updates via Import into Asset ** Hello all!! :) We import assets into the AST:XXX forms (for example AST:Monitor). We do not use AIE. Customer imported records into the AST:Monitor form and put hyphens in the serial number and would like to take them out (the hyphens). We exported the data into a .csv file, cleared out the hyphens and now would like to import the updates. Is there an easy way to do this? I tried doing an import using the data import tool (using the Update Old Record with New Record's Data option under "Handle Duplicate Request IDs by") and it wants to add this to the database, not update it. Any ideas? ARS 7.5 ITSM 7.5 Windows 2003 SQL Thanks! Lisa _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ Private and confidential as detailed here. If you cannot access hyperlink, please e-mail sender. _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ Private and confidential as detailed here. If you cannot access hyperlink, please e-mail sender. _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
