Or a little bit of a variation that works nicely depending on what you are doing (some times you want a lookup form another table, etc). Export the records you are going to update as an .arx file. All you really need is field 1, the last modified by user and modified time. Update the records (escalations, modify all, etc) then import the last modified by and modified time back. Make sure that you have the import tool set to update and not replace existing records.
In 7.5 the Suppress Filters setting in the import tool makes this work even better since it does not trigger your Merge filters. In previous versions I have just disabled the Merge filters right before the import if possible. HTH, Jason On Wed, Oct 7, 2009 at 11:07 AM, LJ Longwing <lj.longw...@gmail.com> wrote: > If you export the records to ARX, modify the arx file, and then re-import > the file back in after the changes, you should be able to get it done > without the dates changing as long as you re-import it with those fields > mapped > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:arsl...@arslist.org] On Behalf Of Sanford, Claire > Sent: Wednesday, October 07, 2009 11:44 AM > To: arslist@ARSLIST.ORG > Subject: Update Record and not change Modify Date > > Other than going in the wrong way and doing it at the DB level, is there a > way for me to update/change 30K records without changing the last modified > name and date fields? > > We are starting to do things the right way and are making the distinction > between a Laptop and a Desktop Computer in an asset record. > So, I will have to go in and change the records to reflect a different > Category name. > > > Was: Computer > Will be: Desktop > > Was: Computer > Will be: Notebook > > ARS 6.3 Patch 18 > HD 6.0 > Oracle 10.2.0.4.0 w/9 libraries > Oracle lives on a remote server > Windows 2003 4 gig on app server and 8 gig on DB server > > > Claire Sanford > Information Systems Division > Memorial Hermann Healthcare System > Phone: 713 448 6035 > claire.sanf...@memorialhermann.org > > > ____________________________________________________________________________ > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum > Sponsor:rmisoluti...@verizon.net <sponsor%3armisoluti...@verizon.net>ARSlist: > "Where the Answers Are" > > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum > Sponsor:rmisoluti...@verizon.net<sponsor%3armisoluti...@verizon.net>ARSlist: > "Where the Answers Are" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
