How to view the XML Output

bikan · Post by **bikan** » Thu Oct 30, 2008 4:26 am

Hi All,

I am working in DS 7.5.1. and Using the XML output stage.I have source file is sequencer file and I want to output is XML file.My job is running very well and There is not any error in log file.But i m not able to see the records in XML file.
Could any one guide me how to view the XML Output?

Thanks
Bikan

chulett · Post by **chulett** » Thu Oct 30, 2008 6:36 am

First off, there's no 'View Data' option in the stage. What do you mean when you say that you are "not able to see the records" in the XML file? Is it empty?

Unless you are outputting 'formated' XML then it will be one long record, essentially. You'll need to transfer it over to your PC and use an XML specific tool to view it properly, ideally one that can 'pretty print' it so it's easier for peoples to read.

John Smith · Post by **John Smith** » Thu Oct 30, 2008 4:15 pm

Your XML file is created in your unix filesystem,so that's probably where you should start. To view XML in the vi editor is not easy so best way to do that is ftp the file to your PC and use one of the XML tools to view it.
Btw an XML file is no different to other files as it's just text.

bikan · Post by **bikan** » Thu Oct 30, 2008 11:11 pm

chulett wrote:First off, there's no 'View Data' option in the stage. What do you mean when you say that you are "not able to see the records" in the XML file? Is it empty?

Unless you are outputting 'formated' XML then it will be one long record, essentially. You'll need to transfer it over to your PC and use an XML specific tool to view it properly, ideally one that can 'pretty print' it so it's easier for peoples to read.

----------------------------------------------------------------------------
Hi chulett,

I have done as per your Suggestion.But I am only able to see the size (1K) of file in unix.File is created but it's empty.

Thanks
Bikan

chulett · Post by **chulett** » Fri Oct 31, 2008 12:06 am

Ok... a 1K file isn't an empty file, what exactly is in it? If records aren't passing through the XML Output stage, then that usually means a problem with the XPath Expressions you are using there. Did you generate them from an xsd or were they manually created? Are there any messages in the log from that stage after the job completes?

bikan · Post by **bikan** » Fri Oct 31, 2008 12:51 am

chulett wrote:Ok... a 1K file isn't an empty file, what exactly is in it? If records aren't passing through the XML Output stage, then that usually means a problem with the XPath Expressions you are using there. Did you generate them from an xsd or were they manually created? Are there any messages in the log from that stage after the job completes?

Hi Chulett

Thank you for help again.Actually i am new to XML ouput.
I am using a sequential file as a source and transforming that data into xml file.In the XML output in option setting i am giving the unix path.Some time file gets generated and some time it won't.When XML file is cretaing in unix environment it has a length of 1k and using ftp i transferred that file into local system and not able to see any record.

Please let me know your answer on the same.

Thanks
Bikan

chulett · Post by **chulett** » Fri Oct 31, 2008 7:57 am

Answer the metadata / XPath Expression question, please.