Good to know :) -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Misi Mladoniczky Sent: Friday, October 09, 2009 1:04 AM To: arslist@ARSLIST.ORG Subject: Re: Update Record and not change Modify Date
Hi, If not mapped, modify-/create-date will be set to $TIMESTAMP$ if you are replacing or creating new records. If you are "updating old record with new data", the timestamps will be left intact. All system/required core-fields will need a value when stored in the database. On updates, they allready have values. 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 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:arsl...@arslist.org] On Behalf Of Misi Mladoniczky > Sent: Thursday, October 08, 2009 1:35 AM > To: arslist@ARSLIST.ORG > 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: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 ARSlist: "Where the Answers Are" >> >> _____________________________________________________________________ >> _ _________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >> Platinum Sponsor:rmisoluti...@verizon.net 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:rmisoluti...@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" > > -- > This message was scanned by ESVA and is believed to be clean. > ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@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"