And as an added bonus... If you also export 'Last modified by' and 'Modified Date' fields then the change to the record will not update those fields. So the data can be updated without stomping on those values if you want to via a MERGE action. ( This however is not possible if you take the workflow approach as that is a MODIFY action.)
HTH. -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap.... Pick two. On 10/13/06, Kemes, Lisa <[EMAIL PROTECTED]> wrote:
Cindy, It's really easy, I just create a file with the Request ID in one column and then the info that needs to be changed in the other columns. Save it to a .csv file and then use the Import Tool. You have to change your preferences (in the Import Tool) to "Update Old Record with New Record's Data." This is extremely helpful when we need to make a lot of changes to multiple fields. Lisa -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Cindy Sapochetti Sent: Friday, October 13, 2006 8:13 AM To: [email protected] Subject: Re: Merges Vs. Submit and Modify for Filters Hi Lisa - Can you tell me how you are able to update through an import? In reading this post, I'm interested in trying to figure out what you're doing b/c we have a number of instances where an update through a straight import would come in handy. Or - are you importing a file and handling your data matching via workflow? Just curious - thx.
_______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
