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<http://www.sug.com/disclaimers/default.htm#Mail>. > 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"
