DSXchange

How can i convert data from Excel sheet (.csv file) to XML output? Has anybody done this before? If so can you share details on what stages you used and how you specified your XML tags etc. I appreciate your help.

Thanks

This is very well documented in the "XML Pack Designer Guide" - Chapter 4 - XML Output. Check your Datastage documents directory.

The problem that you're going to have is reading the Excel Spreadsheet in UNIX. DataStage does not ship with an ODBC driver to read Excel in Unix. There are some other ways to do that, but not within DataStage.

You might check out this thread:
viewtopic.php?t=85601&highlight=read+ex ... sheet+unix

for more information.

Good luck,
Tony

I assume a ".so" file would be needed to read an excel in UNIX.


Regards
Sreeni

You can gather the csv file and prepare the xml using xml writer.

Thanks Guys for the replies. I have .csv file only so i can put it out on Unix and can read it in my source file as an sequential file. However it is going to be a problem if that has comma or semi colen as a data. I am just going to seperate by tab. I will check the document chapter 4 for the details on XML. Let's see how far i can go.

Thanks again and share if you have other thoughts.