If you don't map the modified date when importing, will it update to 'current', or will it stay the same?...I always thought that if you didn't map the modified date, it would be updated with timestamp
-----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Misi Mladoniczky Sent: Thursday, October 08, 2009 1:35 AM To: [email protected] Subject: Re: Update Record and not change Modify Date Hi! You do not really have to edit the ARX-file... I would do create two ARX-files with the Request ID field only. One named notebook.arx and one named desktop.arx. Then I would do an "update old record with new record data" import using BMC Remedy Import. Just map the Request ID field and then hardcode the Category-field to the appropriate value, before doing the import. Make sure that the Category-field is the only field that needs to be updated! You might want to do a full ARX-export of all fields for backup purposes, if something goes wrong. Best Regards - Misi, RRR AB, http://www.rrr.se Products from RRR Scandinavia: * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. * RRR|Translator - Manage and automate your language translations. Find these products, and many free tools and utilities, at http://rrr.se. > 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:[email protected]] On Behalf Of Sanford, Claire > Sent: Wednesday, October 07, 2009 11:44 AM > To: [email protected] > 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 > [email protected] > > ______________________________________________________________________ > ______ > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum > Sponsor:[email protected] ARSlist: "Where the Answers Are" > > ______________________________________________________________________ > _________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are" > > -- > This message was scanned by ESVA and is believed to be clean. > ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
