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"
