Convert CSV to XML in XSLT editor

I have CSV file needs to convert it to XML in XSLT editor to send it to MEC , the below is my code

But it gets the Application Area data null in MEC

when I add this tag to get the Application Area (xmlns="">schema.infor.com/.../2" and <xsl:namespace name="xs" select="'">www.w3.org/.../>)

it does not get the DataArea data as below

I used this tags in the code to read the CSV data

<xsl:stylesheet version="2.0" xmlns="">schema.infor.com/.../2"
xmlns:xsl="">www.w3.org/.../Transform"
xmlns:exsl="">http://exslt.org/common"
extension-element-prefixes="exsl">

what the missing ones to get the Application Area and Data Area right in MEC ?

Find more posts tagged with

ION Mapper & Scripting

Accepted answers

Maxime Richard

Hello,

For any incoming custom BOD message in m3ce (from csv transformation), I always add a mapping step to enrich the XML with the proper namespace. Something like this :

Maxime Richard

It won't work this way. This nasty namespace is indeed blank at DataArea level.

Can you give us more information about the file you have at the beginning of the process ? Simple .csv ? Single record type or multi-record type ?

Can you try what Mike has suggested ?

Anyway, simply create a new XSLT mapping, setup the code to add the namespace and copy paste your custom BOD ProcessSalaryJournals to try it out. In your dataflow, add 2 XSLT steps to win.

All comments

lamis-alaa

@m-richard could you help me in this ?

Maxime Richard

Hello,

For any incoming custom BOD message in m3ce (from csv transformation), I always add a mapping step to enrich the XML with the proper namespace. Something like this :

unknown

Hey there,

I'm not sure if you're dealing with the CSV directly within M3 or if you're able to process and handle the CSV with ION. However, you could consider using the file templates feature of ION to map a CSV or flat file to a BOD structure with an additional mapping step after that to further transform and enrich the BOD.

lamis-alaa

Hello Maxime,

I edit the code as you can see below<span class="hljs-tag"><span class="hljs-string">

it works well for the Application area and get its data in IEC but this was the result from Data Area and get null in the IEC

Maxime Richard

It won't work this way. This nasty namespace is indeed blank at DataArea level.

Can you give us more information about the file you have at the beginning of the process ? Simple .csv ? Single record type or multi-record type ?

Can you try what Mike has suggested ?

Anyway, simply create a new XSLT mapping, setup the code to add the namespace and copy paste your custom BOD ProcessSalaryJournals to try it out. In your dataflow, add 2 XSLT steps to win.

lamis-alaa

Thanks Maxime , it works when I spilt it to two mappings

Copyright © 2025 Infor. All rights reserved.