XSLT: How do I read multiple lines in a CSV file?

I am trying to push data from a CSV file into Infor LN through ION. My XSLT mapping works fine with one line in the file but if I have 2 or more lines it kept reading 1 line only. I have been trying the command for-each with no success. My Data area looks like this:

<xsl:template match="DataArea">
<DataArea>
<xsl:apply-templates select="Process"/>
<xsl:apply-templates select="PCSProjectCSV"/>
</DataArea>
</xsl:template>

Any example would be greatly appreciated.

Thanks,

Find more posts tagged with

ION Mapper & Scripting

Accepted answers

All comments

Maxime Richard

Hi,

I am not sure to understand what you are trying to do. If your data flow is to retrieve a .csv file from a folder and send it to LN then a simple file connection point is required. ION will create 1 noun (PCSProjectCSV) per line in the .csv file (assuming there is only one record type in this file, i mean no "header" type record and "line" type record in the same file).

Legacy Contributor

Yes you are absolutely correct in all your assumptions, only one record type in this file. We had been testing with 1 line all the time and it's successful always. Someone asked how about if there are 2 or more lines in the file. I am new to this issue but how can I do it if there are multiple lines?

Legacy Contributor

Hi Maxime, do you have a scenario like this (ie reading multi line in one csv file)? It works fine with 1 line csv but i need it to read multiples.

Maxime Richard

Can you show us some printscreens of your custom BOD ?

I still don't get why you cannot read multiple lines. Here is a custom BOD example produced by your connection point if there are 3 fields per line in your csv file :

Copyright © 2025 Infor. All rights reserved.