If aradmin.exe doesn't do it for you could try the following: In the admin tool: - create a packing list - add a filter to it
In the data dictionary: - find the packing list in the arcontainer form - find the packing list filter in the arreference form - sql the filterid's of the filters you need into the arreference form in the data dictionary using the filter added in the admin tool as a guide In the admin tool - use the admin tool export to export the filters in the packing list in xml format I've not tried this but looking at the data dictionary it wouldn't seem to hard to do. However, the safeGuard fields in the data dictionary might come and bite you! Cheers Peter > 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'>Ive 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 Im 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 dont > 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'>Its been awhile since Ive 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 cant 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" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
