Re: Weekly report using Runmacro
Hi Howard, The -o option for runmacro is a special mode of operation that is used to dump the data from one or more forms quickly. It ignores the query in the macro in favour of one passed via the -q or -Q options, depending on the format of the query. There is another paramtere for passing the formname also so the macro is completely redundent with -o. I guess this has probably arrived a little too late for you. Rod On 24 September 2010 08:57, Howard how...@homesteadbound.com wrote: I am trying to generate a weekly report in a CSV format and want to use the server runmacro utility to accomplish this. When I try to run the following in the command line: /u01/app/bmc/v55/bin/runmacro -d /u01/app/bmc/ -o /u01/app/bmc/macro -x testserver -e testmacro -U user -P password -f formName -t csv I do get a CSV file as the output, however, the file contains all the records from the formName and it doesn't take the qualification in my testmacro into consideration. Does anybody know why? Also, how would I apply the .arr style to the command or does it just know because the file is located in the same directory as the macro? ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Re: Weekly report using Runmacro
1. May be you forget -a protNo, or you need to set environment variables such as ARHOME=? REMEDY_DIR=? AR_CONF=? AR_SERVER_ID=? ARMON_DIR=? ARTCPPORT=? PATH=? 2. For .arr once define in the macro then the file should be in the same directory, -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Rod Harris Sent: Tuesday, March 08, 2011 2:46 PM To: arslist@ARSLIST.ORG Subject: Re: Weekly report using Runmacro Hi Howard, The -o option for runmacro is a special mode of operation that is used to dump the data from one or more forms quickly. It ignores the query in the macro in favour of one passed via the -q or -Q options, depending on the format of the query. There is another paramtere for passing the formname also so the macro is completely redundent with -o. I guess this has probably arrived a little too late for you. Rod On 24 September 2010 08:57, Howard how...@homesteadbound.com wrote: I am trying to generate a weekly report in a CSV format and want to use the server runmacro utility to accomplish this. When I try to run the following in the command line: /u01/app/bmc/v55/bin/runmacro -d /u01/app/bmc/ -o /u01/app/bmc/macro -x testserver -e testmacro -U user -P password -f formName -t csv I do get a CSV file as the output, however, the file contains all the records from the formName and it doesn't take the qualification in my testmacro into consideration. Does anybody know why? Also, how would I apply the .arr style to the command or does it just know because the file is located in the same directory as the macro? ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Re: Weekly report using Runmacro
Howard, Out of curiosity, what was your qualification? Maybe the way the qualification was written might have made the ARS return the whole set of records? Joe -- From: Howard how...@homesteadbound.com Sent: Thursday, September 23, 2010 11:30 PM To: arsl...@listserv.rbugs.com; Joe DeSouza jdso...@shyle.net Cc: Howard Cheung how...@homesteadbound.com Subject: Re: Weekly report using Runmacro Hi Joe, Yes, that would be a workaround but I plan on creating several different reports using this method and it would be better if I could get this to work. I also tried using the -q flag to set the qualification but wasn't able to get it working this way either. Did anybody else experienced this before? Any suggestions would be greatly appreciated. Thank you. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Weekly report using Runmacro
We are doing the same thing like running report every for night etc as per the
requirement
We create a macro and made it run through windows scheduler
Its written something like this
D:
cd D:\Program Files\AR System
runmacro -x serveranme -h C:\Documents and Settings\Administrator\Application
Data\AR System\Home\ARCmds -e macroname -U username -P password
D:
cd the path where you need to store the result
for /f Tokens=1-4 Delims=/ %%i in ('date /t') do set dt=%%k%%j%%l
for /f Tokens=1 %%i in ('time /t') do set tm=-%%i
set tm=%tm::=.%
set dtt=%dt%%tm%
exit
hope this can help you
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Howard
Sent: Friday, September 24, 2010 5:27 AM
To: arslist@ARSLIST.ORG
Subject: Weekly report using Runmacro
I am trying to generate a weekly report in a CSV format and want to use
the server runmacro utility to accomplish this. When I try to run the
following in the command line:
/u01/app/bmc/v55/bin/runmacro -d /u01/app/bmc/ -o /u01/app/bmc/macro -x
testserver -e testmacro -U user -P password -f formName -t csv
I do get a CSV file as the output, however, the file contains all the
records from the formName and it doesn't take the qualification in
my testmacro into consideration. Does anybody know why?
Also, how would I apply the .arr style to the command or does it just
know because the file is located in the same directory as the macro?
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Important notice: This e-mail and any attachment there to contains corporate
proprietary information. If you have received it by mistake, please notify us
immediately by reply e-mail and delete this e-mail and its attachments from
your system.
Thank You.
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Weekly report using Runmacro
I am trying to generate a weekly report in a CSV format and want to use the server runmacro utility to accomplish this. When I try to run the following in the command line: /u01/app/bmc/v55/bin/runmacro -d /u01/app/bmc/ -o /u01/app/bmc/macro -x testserver -e testmacro -U user -P password -f formName -t csv I do get a CSV file as the output, however, the file contains all the records from the formName and it doesn't take the qualification in my testmacro into consideration. Does anybody know why? Also, how would I apply the .arr style to the command or does it just know because the file is located in the same directory as the macro? ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Weekly report using Runmacro
Howard, I can't imagine why its doing that, but as a workaround you could do the same thing to a form view, that pulls a view of the same form with the qualification defined in the creation of that view.. CREATE VIEW ReportView AS SELECT Col1, Col2, etc FROM Form WHERE the qualification; Then create a view form against that view... Create a macro to report from that view form. So since the macro runs a report across the form ignoring the qualification, you wouldn't care here as the view restricts the records to that qualification anyways... Joe -- From: Howard how...@homesteadbound.com Sent: Thursday, September 23, 2010 7:57 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Weekly report using Runmacro I am trying to generate a weekly report in a CSV format and want to use the server runmacro utility to accomplish this. When I try to run the following in the command line: /u01/app/bmc/v55/bin/runmacro -d /u01/app/bmc/ -o /u01/app/bmc/macro -x testserver -e testmacro -U user -P password -f formName -t csv I do get a CSV file as the output, however, the file contains all the records from the formName and it doesn't take the qualification in my testmacro into consideration. Does anybody know why? Also, how would I apply the .arr style to the command or does it just know because the file is located in the same directory as the macro? ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Weekly report using Runmacro
Hi Joe, Yes, that would be a workaround but I plan on creating several different reports using this method and it would be better if I could get this to work. I also tried using the -q flag to set the qualification but wasn't able to get it working this way either. Did anybody else experienced this before? Any suggestions would be greatly appreciated. Thank you. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
