Hi Damon, Thanks for the help. The code is working fine.
Thanks & Regards, Sini On Mon, Dec 3, 2012 at 5:53 PM, Harry B. <[email protected]> wrote: > Sini- > > You need to build your complete xml structure before the call to > xdmp:save(). You are overwriting your previous file each time the script > loops through. I think this is more what you're looking for (haven't tested > it...check for errors): > > > let $input-document := "/config/list-Of-IDs.xml" > let $file-contents := > for $data in fn:doc($input-document)/ids/id/text() > let $fileName := fn:concat($data,".xml") > return fn:doc($fileName)/node() > let $compilation := > <combinedData> > {$file-contents} > </combinedData> > return > xdmp:save("/tmp/Demo/example.xml", $compilation) > > > This would give you the contents of each file from your config list inside > the <combinedData> parent node in the example.xml file. > > If 1.xml had: > > <someNode> > <foo>1</foo> > </someNode> > > And 2.xml had > <someNode> > <foo>2</foo> > </someNode> > > And only 1.xml and 2.xml were in your config list, example.xml would look > like: > > <combinedData> > <someNode> > <foo>1</foo> > </someNode> > <someNode> > <foo>2</foo> > </someNode> > </combinedData> > > > On Mon, Dec 3, 2012 at 8:08 AM, sini narayanan <[email protected]>wrote: > >> Hi Damon, >> >> This will work when I explicitly know which are the files that i wnat to >> combine. >> But in my case, >> >> Im my Marklogic DB, I have 10 xml files named as 1.xml, 2.xml, .....10.xml >> >> And I have an xml file with list of IDs like below: >> <ids> >> <id>1</id> >> <id>2</id> >> <id>3</id> >> <id>4</id> >> <id>5</id> >> </ids> >> >> >> Now, For each of the ids in the list-Of-IDs.xml(1, 2 ,3, 4 and 5) i want >> to save the contents in the corresponding xml files into a single xml file >> in the file system. >> ie: Contents of 1.xml, 2.xml, 3.xml, 4.xml and 5.xml should be saved into >> a file named "example.xml" in the file system. >> >> >> when I iterate through the IDs in the xml like below, Only the final xml >> file contents is getting saved in the "example.xml" output file. Instead I >> want the contents of other id's as well to be appended/combined in the >> output. How will i do that ? Please help. >> >> let $input-document := "/config/list-Of-IDs.xml" >> for $data in doc($input-document)/ids/id >> let $ID := $data/text() >> let $fileName := concat($ID,".xml") >> return >> xdmp:save("/tmp/Demo/example.xml", doc($fileName)) >> >> Thanks >> >> >> On Mon, Dec 3, 2012 at 2:58 PM, Damon Feldman < >> [email protected]> wrote: >> >>> Sini,**** >>> >>> ** ** >>> >>> I’m not sure exactly what you mean, but you can do this with simple >>> templating:**** >>> >>> ** ** >>> >>> let $doc1 := <doc><foo/></doc>**** >>> >>> let $doc2 := <doc2><foo2/></doc2>**** >>> >>> let $combined := <combined-doc>{$doc1/node(), >>> $doc2/node()}</combined-doc>**** >>> >>> return xdmp:save("c:/tmp/combined-doc.xml", $combined)**** >>> >>> ** ** >>> >>> Yours,**** >>> >>> Damon**** >>> >>> --**** >>> >>> Damon Feldman**** >>> >>> Sr. Principal Consultant, MarkLogic**** >>> >>> ** ** >>> >>> *From:* [email protected] [mailto: >>> [email protected]] *On Behalf Of *sini narayanan >>> *Sent:* Monday, December 03, 2012 8:39 AM >>> *To:* MarkLogic Developer Discussion >>> *Subject:* Re: [MarkLogic Dev General] Export from Marklogic**** >>> >>> ** ** >>> >>> Hi All,**** >>> >>> ** ** >>> >>> Does anyone have an idea on how to combine two xml files and then save >>> it in the file system using xdmp:save?**** >>> >>> ** ** >>> >>> Thanks**** >>> >>> ** ** >>> >>> On Mon, Dec 3, 2012 at 12:22 PM, sini narayanan <[email protected]> >>> wrote:**** >>> >>> Hi,**** >>> >>> ** ** >>> >>> I want to export the xml files inside Marklogic into a CSV in the file >>> system. Is it possible to save a file inside repository into a file system >>> using xquery ?**** >>> >>> ** ** >>> >>> Thanks**** >>> >>> ** ** >>> >>> _______________________________________________ >>> General mailing list >>> [email protected] >>> http://developer.marklogic.com/mailman/listinfo/general >>> >>> >> >> _______________________________________________ >> General mailing list >> [email protected] >> http://developer.marklogic.com/mailman/listinfo/general >> >> > > _______________________________________________ > General mailing list > [email protected] > http://developer.marklogic.com/mailman/listinfo/general > >
_______________________________________________ General mailing list [email protected] http://developer.marklogic.com/mailman/listinfo/general
