We did something similar by building a staging table, importing the updated records to that table, then using workflow to match the records with the BMC table and push certain fields.
--Pam ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Drake,Dave Sent: Tuesday, March 18, 2008 4:45 PM To: arslist@ARSLIST.ORG Subject: Mass data modifications without EIE Hi all... Does anyone know of a way to update a large number of records in the BMC.CORE:BMC_ComputerSystem form without using EIE/AIE? I have all the changes in a csv file, with the updated records RequestIDs included. The import tool doesn't work in ITSM evidently. Any advice is appreciated. Thanks!! ARS 7.0.1 p002, ITSM 7.0.1 p003, SQL2K, Win2K3 servers Dave Drake - Remedy Administrator - Cerner Corporation - CernerWorks ________________________________ CONFIDENTIALITY NOTICE This message and any included attachments are from Cerner Corporation and are intended only for the addressee. The information contained in this message is confidential and may constitute inside or non-public information under international, federal, or state securities laws. Unauthorized forwarding, printing, copying, distribution, or use of such information is strictly prohibited and may be unlawful. If you are not the addressee, please promptly delete this message and notify the sender of the delivery error by e-mail or you may call Cerner's corporate offices in Kansas City, Missouri, U.S.A at (+1) (816)221-1024. __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
