Focal Point
[SOLVED] CSV file to XML

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/1381057331/m/4427002276

August 15, 2014, 05:18 PM
cokeyng
[SOLVED] CSV file to XML
Hi,

I am trying to convert a csv file downloaded from a ftp listener into a xml file.

There are two options that I am trying and hit dead end and hope to get some hints from the forum.

1. I saw some image on the manual under "Adding a Preparser" showing a CSVPreParser {com.ibi.preparsers.XDCSVpreParser}. how come it is not available when I try to select a preparser type in iIT?

2. I have created a CSV to XML transform in iWay and tried to use it with the Transform PreParser, what is the right way to specific the transform from the repository?

Thanks

Cokey

iSM 6.1.10

This message has been edited. Last edited by: Tamra,


iWay 5.5, 6.01
Windows
all output (Excel, HTML, PDF)
August 16, 2014, 06:11 AM
Srii
Hello,

For your question 1, Can you see the CSV preparser available in the drop-down list box of standard preparsers available in iSM Web Console?

If no, then the iSM instance you are working doesnt have one. It maybe because the image you might had seen was from an older version of iSM and this feature might had become obsolete in the recent.

If yes, respond back here and I'll do some research on it.

And for your question 2, Publish the involved transformation onto Systems area [not registry] of the managed server where the channel you are building will be deployed. In the Preparser object, simply mention the name of the transformation.

-
Srii
August 18, 2014, 01:16 PM
cokeyng
Thanks for the reply. No the CSVPreParser is not available as an option in the combo box.


iWay 5.5, 6.01
Windows
all output (Excel, HTML, PDF)
August 18, 2014, 05:26 PM
cokeyng
Option 2 works, thanks.


iWay 5.5, 6.01
Windows
all output (Excel, HTML, PDF)