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>|[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"
