The problem with that approach would be that I would not be easily able to create a packing list of 680 odd filters chosen almost randomly with just one common trait.. they all have set field actions from direct SQL's
Another problem is that it will save the definition file as a .def file and not .xml which I would rather prefer as I have to do manual edits to the SQL commands in that def file. These edits will be a lot more difficult to do in a .def file. So it is an almost random list of filters that I will have to build a packing list out of.. and at the end of that there might be no way of exporting it as a xml definition file I was hoping to have the option of running aradmin by giving it a filter name to export and having the option to export that filter to a xml definition file and then run it again for the next filter and append that to the same def file and so on and so forth till I export the last filter.. If that was possible I could have auto written a batch script while spooling the filter list while running my sql query... Joe ________________________________ From: David Morgan <[EMAIL PROTECTED]> To: [email protected] Sent: Thursday, November 20, 2008 10:51:47 AM Subject: Re: Command line usage of aradmin.exe to export 'specific' filters... Hi all Running aradmin.exe /? Pops a usage string dialog - The options are listed in the Advanced Guide for 6.3 aradmin -u <user_name> [-p <password>] -x <server_name> [-w <external_authentication_string>] [-portnum <TCP_port_number>] [-e <file_name>] [-i <file_name>] [-convert [-<option> -f <form_name>]] [-c <file_name>] [-s][-o [<log_file_name>]] You'll need aradmin -u <user_name> [-p <password>] -x <server_name> [-portnum <portnum>] -e exported.def -l packinglist.xml From the document itself:- To parse an XML packing list, and export all objects defined in that packing list, use the following command format: aradmin -u <user_name> [-p <password>] -x <server_name> -e <target_filename> -l <packing_list.xml> Note: You cannot export server objects that include a percent sign (%) in their name. Regards Dave -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Matthew Perrault Sent: 20 November 2008 15:42 To: [email protected] Subject: Re: Command line usage of aradmin.exe to export 'specific' filters... --_000_2525780A3ED7DC4695C7EA8B9DEFE9A22F4C2C6C75MGOEXMBXP2gen_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Joe, I know it can be done. I've done it here and seen it done other places. I think you have to go to the directory that the AR Server is installed on = and there should be a .exe there that you have to run from a command prompt (but I'm not 100% on that statement above) Exact parameters...don't remember... It's been awhile since I've done this (2 years) You could always write an API program to do it though too. I do know that the API commands to export code can be found in the API refe= rence guide. Sorry Joe I can't be more help on how to do it, I can just tell you that I = know it can be done. HTH Matt P. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] T.ORG] On Behalf Of Joe DeSouza Sent: Thursday, November 20, 2008 9:34 AM To: [email protected] Subject: Command line usage of aradmin.exe to export 'specific' filters... ** Hello listers, I would like to know if anyone has used the aradmin.exe to export from the = command line a list of filters that I have queried for and save the definit= ion file in an XML format. The aim of my operation is to edit this def file for all filters that conta= in set fields actions from a SQL Command. Its not very easy to do it if I s= ave the filters in a .def definition file format as I will then need to con= sider the altered length of the SQL Command and they are over 600 filters s= o that would be a pain. An XML file is free of that format as we do not need to consider length of = the statement. I have already designed an sql query that pulls the right set of filters th= at I need to alter ignoring filters that contain queries to the meta tables= and filters that contain $fieldid$ in its statements, so all I need to kno= w is if it is possible to use aradmin.exe from the command line to export t= his set of filters to an XML definition file. Joe __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" --_000_2525780A3ED7DC4695C7EA8B9DEFE9A22F4C2C6C75MGOEXMBXP2gen_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable ** <html xmlns:v=3D"urn:schemas-microsoft-com:vml" xmlns:o=3D"urn:schemas-micr= osoft-com:office:office" xmlns:w=3D"urn:schemas-microsoft-com:office:word" = xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml"; xmlns=3D"http:= //www.w3.org/TR/REC-html40"> <head> <meta http-equiv=3DContent-Type content=3D"text/html; charset=3Dus-ascii"> <meta name=3DGenerator content=3D"Microsoft Word 12 (filtered medium)"> <style> <!-- /* Font Definitions */ @font-face {font-family:Calibri; panose-1:2 15 5 2 2 2 4 3 2 4;} @font-face {font-family:Tahoma; panose-1:2 11 6 4 3 5 4 4 2 4;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {margin:0in; margin-bottom:.0001pt; font-size:12.0pt; font-family:"Times New Roman","serif";} a:link, span.MsoHyperlink {mso-style-priority:99; color:blue; text-decoration:underline;} a:visited, span.MsoHyperlinkFollowed {mso-style-priority:99; color:purple; text-decoration:underline;} span.EmailStyle17 {mso-style-type:personal-reply; font-family:"Calibri","sans-serif"; color:#1F497D;} .MsoChpDefault {mso-style-type:export-only; font-size:10.0pt;} @page Section1 {size:8.5in 11.0in; margin:1.0in 1.0in 1.0in 1.0in;} div.Section1 {page:Section1;} --> </style> <!--[if gte mso 9]><xml> <o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" /> </xml><![endif]--><!--[if gte mso 9]><xml> <o:shapelayout v:ext=3D"edit"> <o:idmap v:ext=3D"edit" data=3D"1" /> </o:shapelayout></xml><![endif]--> </head> <body lang=3DEN-US link=3Dblue vlink=3Dpurple> <div class=3DSection1> <p class=3DMsoNormal><span style=3D'font-size:11.0pt;font-family:"Calibri",= "sans-serif"; color:#1F497D'>Joe,<o:p></o:p></span></p> <p class=3DMsoNormal><span style=3D'font-size:11.0pt;font-family:"Calibri",= "sans-serif"; color:#1F497D'>I know it can be done.<o:p></o:p></span></p> <p class=3DMsoNormal><span style=3D'font-size:11.0pt;font-family:"Calibri",= "sans-serif"; color:#1F497D'>I’ve done it here and seen it done other places.<o:p><= /o:p></span></p> <p class=3DMsoNormal><span style=3D'font-size:11.0pt;font-family:"Calibri",= "sans-serif"; color:#1F497D'>I think you have to go to the directory that the AR Server i= s installed on and there should be a .exe there that you have to run from a command prompt<o:p></o:p></span></p> <p class=3DMsoNormal><span style=3D'font-size:11.0pt;font-family:"Calibri",= "sans-serif"; color:#1F497D'>(but I’m not 100% on that statement above)<o:p></o:p><= /span></p> <p class=3DMsoNormal><span style=3D'font-size:11.0pt;font-family:"Calibri",= "sans-serif"; color:#1F497D'>Exact parameters…don’t remember…<o:p></o:p= ></span></p> <p class=3DMsoNormal><span style=3D'font-size:11.0pt;font-family:"Calibri",= "sans-serif"; color:#1F497D'><o:p> </o:p></span></p> <p class=3DMsoNormal><span style=3D'font-size:11.0pt;font-family:"Calibri",= "sans-serif"; color:#1F497D'>It’s been awhile since I’ve done this (2 years)<= o:p></o:p></span></p> <p class=3DMsoNormal><span style=3D'font-size:11.0pt;font-family:"Calibri",= "sans-serif"; color:#1F497D'>You could always write an API program to do it though too.<o= :p></o:p></span></p> <p class=3DMsoNormal><span style=3D'font-size:11.0pt;font-family:"Calibri",= "sans-serif"; color:#1F497D'>I do know that the API commands to export code can be found = in the API reference guide.<o:p></o:p></span></p> <p class=3DMsoNormal><span style=3D'font-size:11.0pt;font-family:"Calibri",= "sans-serif"; color:#1F497D'>Sorry Joe I can’t be more help on how to do it, I can = just tell you that I know it can be done.<o:p></o:p></span></p> <p class=3DMsoNormal><span style=3D'font-size:11.0pt;font-family:"Calibri",= "sans-serif"; color:#1F497D'><o:p> </o:p></span></p> <p class=3DMsoNormal><span style=3D'color:#1F497D;letter-spacing:-1.0pt'>HT= H<o:p></o:p></span></p> <p class=3DMsoNormal><span style=3D'color:#1F497D;letter-spacing:-1.0pt'>Ma= tt P.<o:p></o:p></span></p> <p class=3DMsoNormal><span style=3D'font-size:11.0pt;font-family:"Calibri",= "sans-serif"; color:#1F497D'><o:p> </o:p></span></p> <div style=3D'border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in = 0in 0in'> <p class=3DMsoNormal><b><span style=3D'font-size:10.0pt;font-family:"Tahoma= ","sans-serif"'>From:</span></b><span style=3D'font-size:10.0pt;font-family:"Tahoma","sans-serif"'> Action Reques= t System discussion list(ARSList) [mailto:[EMAIL PROTECTED] <b>On Behalf O= f </b>Joe DeSouza<br> <b>Sent:</b> Thursday, November 20, 2008 9:34 AM<br> <b>To:</b> [email protected]<br> <b>Subject:</b> Command line usage of aradmin.exe to export 'specific' filters...<o:p></o:p></span></p> </div> <p class=3DMsoNormal><o:p> </o:p></p> <p class=3DMsoNormal>** <o:p></o:p></p> <div> <div> <p class=3DMsoNormal><span style=3D'font-size:10.0pt;color:black'>Hello lis= ters,<o:p></o:p></span></p> </div> <div> <p class=3DMsoNormal><span style=3D'font-size:10.0pt;color:black'> <o:= p></o:p></span></p> </div> <div> <p class=3DMsoNormal><span style=3D'font-size:10.0pt;color:black'>I would l= ike to know if anyone has used the aradmin.exe to export from the command lin= e a list of filters that I have queried for and save the definition file i= n an XML format.<o:p></o:p></span></p> </div> <div> <p class=3DMsoNormal><span style=3D'font-size:10.0pt;color:black'> <o:= p></o:p></span></p> </div> <div> <p class=3DMsoNormal><span style=3D'font-size:10.0pt;color:black'>The aim o= f my operation is to edit this def file for all filters that contain set fields actions from a SQL Command. Its not very easy to do it if I save the filter= s in a .def definition file format as I will then need to consider the altered length of the SQL Command and they are over 600 filters so that would be a pain.<o:p></o:p></span></p> </div> <div> <p class=3DMsoNormal><span style=3D'font-size:10.0pt;color:black'> <o:= p></o:p></span></p> </div> <div> <p class=3DMsoNormal><span style=3D'font-size:10.0pt;color:black'>An XML fi= le is free of that format as we do not need to consider length of the statement.<= o:p></o:p></span></p> </div> <div> <p class=3DMsoNormal><span style=3D'font-size:10.0pt;color:black'> <o:= p></o:p></span></p> </div> <div> <p class=3DMsoNormal><span style=3D'font-size:10.0pt;color:black'>I have al= ready designed an sql query that pulls the right set of filters that I need to al= ter ignoring filters that contain queries to the meta tables and filters that contain $fieldid$ in its statements, so all I need to know is if it is poss= ible to use aradmin.exe from the command line to export this set of filters to a= n XML definition file.<o:p></o:p></span></p> </div> <div> <p class=3DMsoNormal><span style=3D'font-size:10.0pt;color:black'> <o:= p></o:p></span></p> </div> <div> <p class=3DMsoNormal><span style=3D'font-size:10.0pt;color:black'>Joe<o:p><= /o:p></span></p> </div> </div> <p class=3DMsoNormal><o:p> </o:p></p> <p class=3DMsoNormal>__Platinum Sponsor: www.rmsportal.com ARSlist: "W= here the Answers Are" html___<o:p></o:p></p> </div> </body> </html> __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ --_000_2525780A3ED7DC4695C7EA8B9DEFE9A22F4C2C6C75MGOEXMBXP2gen_-- _______________________________________________________________________________ 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"
