Re: RunMacro versus macro in client

[Bruce Scott]

Thomas,
 
I recently did something very similar and encounter some of the issues you are 
seeing.  What I have is an escalation (because the report is needed on a 
reoccurring basis to meet audit requirements) which has a Run Process action.  
The command line of the Run Process looks like:
 
c:\\progra~1\\remedy\\reports\\report.bat $zTmpDate$
 
where $zTmpDate$ is a variable I pass to the file being generated to make it 
unique.
 
The batch file (report.bat) looks like:
 
@Echo Off
copycmd=/Y
Set filedate=%1
C:\Progra~1\ARSyst~1\runmacro.exe -x remedydev01 -U Username -P password -d 
C:\Progra~1\Remedy\Reports -e ChangeCo
copy c:\\progra~1\\remedy\\reports\\weekly\\changecontrolmeeting_.csv 
c:\\progra~1\\remedy\\reports\\weekly\\ChangeControlMeeting_%filedate%.csv
 
Finally, my macro looks like this:
 
ChangeCo
Set-schema: PETM:ISChangeControlRequest
remedyapp01
Query: 
1707200=true
1707100=true
1707000=false
1706900=true
(( '7' = 
"Approved" AND '536871106' = "Open") OR ( '7' = "Pending" AND '536871106' != 
"Closed")) AND '536870921' >= $-4$ AND '536870921' < ($-4$+7*24*60*60)
Report: 
21=1
1=1
3=Change Control 
Meeting
4=
5=
6=
13=
23=0
7=72
10=96
8=1
9=1
11=0
12=0
20=7
16=-
17=
18=1
19=7
2=1Change
 Req ID050536870921Implementation Start045536870923Change 
Type025200000004Type040536870914Change 
Owner0407Approval0308Short Description0100536870919Risk 
Lvl015536870920Outage015

report-sort: 0|2|536870921\1|1\1|

Statistics: 
 
to-file: C:\Progra~1\Remedy\Reports\Weekly\ChangeControlMeeting_.csv
O
end
 
Part of the no file issue you are seeing seems to be related to the way the 
command line interface treats the DOS-like commands, which is why there are 
doubled slashes in the batch and command line of the run process.  Make sure 
that the name of the macro (seen above, first line of the macro) matches the 
macro name in the runmacro command (end of the third line of the batch file 
above).
 
Thanks,
Bruce
 

  _____  

From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of Števove Tomáš
Sent: Wednesday, January 17, 2007 9:02 AM
To: arslist@ARSLIST.ORG
Subject: Re: RunMacro versus macro in client


** 
Bruce,
 
runmacro command looks like this:
 
C:\Program Files\AR System\Admin>runmacro.exe -h c:\u00\ar\macro -d c:\u00\ar\ma
cro -x ars01 -e repGE

I try macro with login infromation, but the result is the same - no file was 
created. 
 
When I try this command:
C:\Program Files\AR System\Admin>runmacro.exe -o c:\tmp\report.csv -x ars01 -U 
<user> -P <password> -f HPD:HelpDesk -z c:\u00\ar\macro\repGE.qbe -t CSV
File is created, but with all fields from HPD:HelpDesk and I need only some 
fields (as you can see in macro - command Report:)
 
Maybe is I have error in macro? But, why macro is OK under client?
 
Tomas Stevove
Software Specialist
Email: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> 

#####################################################################################
The information contained in this electronic mail message, including 
attachments, if any, is PetSmart confidential information.  It is intended only 
for the use of the person(s) named above.  If the reader of this message is not 
the intended recipient, or has received this message in error, you are hereby 
notified that any review, dissemination, distribution or copying of this 
communication is strictly prohibited.  If you are not the intended recipient or 
have received this message in error, please notify the sender via e-mail and 
promptly delete the original message.
#####################################################################################

_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
Answers Are"