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"
