OnDemand User Group
Support Forums => MP Server => Topic started by: teeraw on February 13, 2012, 05:34:59 AM
-
How can I use "arsxml export" to export only folder name and description? ???
I need this for batch export folder name that exclude permission and field information.
I used:
arsxml export -hlocalhost -uadmin -ppassword -v -i exportfldr.xml -o fldr.xml
My input XML file is:
<?xml version="1.0" encoding="UTF-8"?>
<onDemand xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:noNamespaceSchemaLocation="/usr/lpp/ars/bin/xml/ondemand.xsd">
<!-- This will export all of the groups defined on the system -->
<folder name="_ALL" />
</onDemand>
But my output is include anything within folders.
-
Hello Teeraw,
at my knowledge, it's a all or nothing flag with arsxml. Either you know what you want, or you get everything.
In either case, you'll get for a folder/appG/app/user/group/... everything to redo it again.
The only way to have only what you want would be to do it with the Java API from ODWek.
Sincerely yours,
Alessandro
-
Hey,
how about a simple db2 on the cli:
db2 "select name, description from arsfol"
Cheers :-)
-
Hello Mayach,
yes you could do it like that too :-D
I've seen more and more usage of arsxml instead of access directly the database, because most of the time customer wants to use standard tools and not look directly into the tables :-)
And at the same time I find the question about filtering the export via XML a very good idea, especially when it's not always easy to know which bit is what in some fields of some tables!!
For me that would be an improvement of the arsxml export functionality!!!
Sincerely yours,
Alessandro
-
Good Morning,
yes you're right, but for me there are two approaches for using arsxml or the cli.
arsxml = complete Export / Import / Update automation with the whole hierarchy and depedencies
cli = get data as they are on the database and at least with less work
Just thinking about an functionality that you mentioned with the output. How would you configure something like turning fields on / off in the output? First something with cat / sed / grep could work.
Cheers
-
Hello Mayach,
well today either I'm using perl, or if I'm lazy a lot bunch of awk/sed :-D It's always different, and depending on my mood!! :-D
But to have something integrated with arsxml would be top !!!
Sincerely yours,
Alessandro