Thanks Julie and Misi, your solution worked great! Now I just have to go in and turn on Modify-All so it will work (since it sounds like you cannot do a single modify operation within the macro, which kind of makes sense).
Thanks, Gary Opela, Jr Sr. Remedy Developer Leader Communications, Inc. 405 736 3211 -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Misi Mladoniczky Sent: Wednesday, January 23, 2008 2:53 AM To: [email protected] Subject: Re: Modifying a record via RunMacro on the command line Hi Julie, You are right about Modify-All being the only way to uptade a ticket. 1. Start Macro Recording 2. Open your form in search mode 3. Enter an advanced search of ('1' = "$Reguest$") 4. Choose Action -> Modify All 5. Enter valus or $xxx$ in the fields you want to update 6. Press Save 7. Save your Macro Before the days of Push-Fields, we did this all the time. We created a filter that executed the user-tool on the server, which in turn executed a macro that updated whatever we wanted to update... I like Push-Fields ;-) Best Regards - Misi, RRR AB, http://rrr.se > Hi Gary, > I believe you need a Modify-bulk command to actually perform the > modify. I am not sure how necessary those hex '01' characters > peppered throughout the macro are. > > TEST > Set-schema: <Schema><Server> > Query: 1=$Request$ > Modify-bulk: 536871039=$Title$ > end > > Good luck! > Julie Rockwood > > At 02:25 PM 1/22/2008, you wrote: >>** >>I'm trying to modify a ticket via command line. >> >>Here is my call on the command line: >> >>"C:\Program Files\AR System\RUNMACRO.EXE" >> -d "C:\Documents and Settings\All Users\Application Data\AR >> System\HOME\ARCmds" >> -e "TEST" -x "<Server>" -U "<User>" -P "<Password>" -p >> "Request"="CUST0000000 >>4854" = -p "Title"="Mr." >> >>I'm not even sure if the above is correct, but I'm trying to pass a >>parameter called 'Request' as part of the qualification on the >>macro, and then a parameter for 'Title' as the value that is being >>updated. So, it will look up 'Request' and modify 'Title.' >> >>So, I did some experimenting. A SUBMIT macro for this particular >>schema looks like the following: >> >>TEST >>Set-schema: <Schema><Server> >>Submit: >><Schema><Server>|536871039=Mr.536870985=asdf536870938=1536870936=15368 70935=1536870934=1536870929=336-3211536870925=Bob536870918=Smith53687091 [EMAIL PROTECTED] >>end >> >>And a QUERY macro looks like the following: >> >>TEST >>Set-schema: <Schema><Server> >>Query: 1=CUST00000004854[1] >>Form-open: >>Form-entry-list: 0 >>Form-final: modify@ >>end >> >> >>So, I merged the two and came up with the below: >> >>TEST >>Set-schema: <Schema><Server> >>Query: 1=$Request$<Server>|536871039=$Title$ >>Form-final: modify@ >>End >> >>The hopes are that the above macro will pull up ticket number >>$Request$ (as passed in via the command line call above), and update >>536871069 to 'Mr.' as passed via the command line call above). >> >>Unfortunately, this isn't working. Do you all have any tips on >>creating a macro that, when run via command line, does a query, then >>updates the resulting record(s)? I tried to just go into the user >>tool and record a query/modify action, but remedy won't commit to >>the DB, so it won't record the update in the macro either. It will, >>however, let you create a submit macro and create the proper >>commands in the macro file, just not submit to database. >> >>Any help is greatly appreciated! >> >>Thanks, >> >>Gary Opela, Jr >>Sr. Remedy Developer >>Leader Communications, Inc. >>__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers >>Are" html___ > > ________________________________________________________________________ _______ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor: www.rmsportal.com 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: www.rmsportal.com ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
