Will give it a go :) Thanks Fred, --- En date de : Lun 1.12.08, Grooms, Frederick W <[EMAIL PROTECTED]> a écrit :
De: Grooms, Frederick W <[EMAIL PROTECTED]> Objet: Re: RUNMACRO À: [email protected] Date: Lundi 1 Décembre 2008, 15h37 The armaced program is available on the BMC Developer Network http://developer.bmc.com/communities/docs/DOC-2141 Grab the program and put it in its own folder. Save your macro to the same folder. Open a command prompt to that folder and run the program. Fred From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Frex Popo Sent: Thursday, November 27, 2008 8:10 AM To: [email protected] Subject: RUNMACRO ** Hello all, ARS: 7.1 patch04 I am using the runmacro to dump some data from a form. All done in a batch script which I run from the command line. The following command does more or less what I want. %ARDIR%\runmacro.exe" -x %ARSVR% -U %ARUSER% -P %ARPASS% -a %ARPORT% -o %TARGDIR%\%TARGFILE% -f %ARFORM% -t csv -q "'1000000161' != $NULL$ AND '7' = "0" Now I am trying to change this to extract only certain columns from the form. I have tried to do this by going to the user tool switch the macro button, run a search, then generate a report skeleton and write the data to some file. However, I want to be able to write to the file specified by -o rather than the file specified within the macro. There are other issues also when copying the script to a different machine etc etc.. My question is, is there a way I can edit a file (.arq) manually and tell it to dump columnA and colunB from a particular form etc and then include the -e option in the command above? Rather than having to go to the user tool and create everything from there!!! anywayone has done this and wants to share his macro? Thanks in advance frex _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
