Here is the command that I got to work executing from a filter: "D:\Program Files\AR System\runmacro.exe" -o "D:\Program Files\AR System\User\testexport.csv" -x "$SERVER$" -U USERNAME -P PASSWORD -f "FORM_NAME" -t csv -q "'300984400'=""3000"""
As you can see the extra quotes are necessary. Two double-quotes together within a set of double-quote translates into a single double-quote within the double quotes. The best suggestion I can make is to turn filter logging on, copy the runmacro command and past it into a command prompt to test. The information in the log will give you how the system translates your filter. Then you can play with the single and double quotes until you get it to work the way you want. Best of luck. James Ward Cellular: 469-338-7185 EMail: [EMAIL PROTECTED] --- On Tue, 7/15/08, Suster, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > From: Suster, [EMAIL PROTECTED] <[EMAIL PROTECTED]> > Subject: Runmacro for export in an escalation > To: [email protected] > Date: Tuesday, July 15, 2008, 11:57 AM > I'm attempting to use the runmacro command from an > escalation to do an export. I've followed the > Integrating with Plug-ins and Third-Party Products guide as > best I can. The command simply doesn't work in the > escalation. When I run it from a command window in Windows > I get the following error: DTS:CMDB-SDS:Transactions is not > a regular form and is not processed. The listed form is a > regular form, however. The command as written: > > runmacro -o > "D:\Remedy\SDS_File_Exchange\SDS_nightly_batch_data\cmdb2sdsnew.csv" > -d > "D:\Remedy\SDS_File_Exchange\Macros" > -x ms-res-devrm -e "expxcmdb.arq" -U <USER> > -P <PASSWORD> -s "DTS:CMDB-SDS:Transactions" > -t csv > > > Any input is appreciated. Thank you. > > Ron Suster > State of California > > > _______________________________________________________________________________ > 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"
