the way to import and export XML file

parvathi · Post by **parvathi** » Mon Aug 28, 2006 12:01 am

Hi...
I want to export a job in an XML format . And then i want to get each and every property of the job (including meta data information) used in the job in XML inputstage.. After that i want to send it to XML output stage with some modifications. in the transformer stage.
when i import the changed xml file ,the changes made to xml file should reflect in the job

loveojha2 · Post by **loveojha2** » Mon Aug 28, 2006 12:12 am

I think dsx is a better choice, if you want to dig information related with jobs or want general modifications,
but I guess it should also be possible through xml (but would be complicated, involved and slow (since the size)).

Through the manager at the time of export (the export dialog box) check the check box for xml export and you are done.

ray.wurlod · Post by **ray.wurlod** » Mon Aug 28, 2006 3:29 am

parvathi wrote:Hi...
I want to export a job in an XML format . And then i want to get each and every property of the job (including meta data information) used in the job in XML inputstage.. After that i want to send it to XML output stage with some modifications. in the transformer stage.
when i import the changed xml file ,the changes made to xml file should reflect in the job

Only if the changes you made were valid.
You might want to consider the "default valued properties" and "read only objects" options when exporting. You get a larger export file, but you do get everything.

But you are hugely confused.

The XML export file is not in a form that can be readily be processed with XML Input/XML Output/XML Transformer stages. For a start it's likely to be too large. Secondly, and more important, it contains metadata rather than data; what style sheet were you planning to use? Where were you intending to obtain the metadata (table definition) for driving this processing?

parvathi · Post by **parvathi** » Tue Aug 29, 2006 2:55 am

thanks.. i was able to process the xml file...
But one thing in that it is taking a lot of time to run the job containing

folder stage------>xmlinput------>transformer---->xmloutputstage

Are there methods to increase the performance...??

ray.wurlod · Post by **ray.wurlod** » Tue Aug 29, 2006 5:55 am

Yes, have fewer, smaller XML files. These stages were intended to process short messages when exposed as a web service - they are not intended to perform "grunt work". Investigate DataStage TX as an alternative.

parvathi · Post by **parvathi** » Tue Aug 29, 2006 10:43 pm

okay... i will do small xml files....

but i was getting the following error when i was generating the xml outfile

Cannot view XML input using XSL style sheet. Please correct the error and then click the Refresh button, or try again later.

--------------------------------------------------------------------------------

Only one top level element is allowed in an XML document. Error processing resource 'file://10.237.237.36/Angel_DS/Angel/Px...

<DSExport>
-^

what should be done to overcome the error.....??

DSXchange

the way to import and export XML file

the way to import and export XML file

Re: the way to import and export XML file

xml file

xml