CSV to CSV

Hi, To better understand the features of ION, I'm attempting create a CSV to CSV workflow.

In MEC this is pretty simple but we're using an Infor ERP Product which does not use MEC and only ION.

File 1 is defined as a csv Document within the Connection Point (As opposed to using File Format Template) with acceptance of the following BODS

CSV File definition is also configured in File Template

How do you configure the workflow to accept a csv file which then converts to an XML file for the XSLT to convert. Current workflow only recognises an XML file.

I cannot find a good end-to-end example anywhere.

Find more posts tagged with

ION Mapper & Scripting

Accepted answers

All comments

Legacy Contributor

Hi, you are talking about data flow, as workflow is something else (at least from ION's point of view).

You have to define File Template for your file that is CSV formatted. From there you can also generate BOD metadata so the schema gets generated automatically (based on provided sample CSV) - this is then Custom BOD. When you use this File Template in a File Connection point it will convert internally you CSV into Custom BOD XML and you can do the mapping based on the schema.. You have to provide the similar File template and File Connection point on the receiving side of the data flow. So the mapping goes from incoming Custom BOD to outgoing Custom BOD, and both File Connection Points use File Templates that are either able to generate BOD out of CSV or CSV out of BOD.

Maxime Richard

Hi,

I suppose you speak about data flow and not workflow, which is complete different object in ION.

If you need to use XSLT step in a data flow, you don't have the choice but to use BOD as input document and BOD as output document (XML).

Everything seems fine in your data flow:

1) retrieve .csv file from File CP 1

ION converts it to a custom BOD (Process.ItemDesc in your case)

2) Your XSLT mapping will use Process.ItemDest as input BOD and transform it to Update.ItemFile (output BOD)

3) BOD Update.ItemFile is sent to File CP 2 (that must exist in ION Desk accordingly) and ION will convert it to a basic .csv file

Georges would say, what else ?

Edit : OK, Tilen was faster.

Legacy Contributor

Thanks All and yes I did mean Document Flow.

When I place a csv file into the receiving location I get the error

-----

Reason Code: GENERAL

Reason Description: com.infor.ion.container.common.exception.ServiceContainerException: Transformer could not transform message. Reason: org.xml.sax.SAXParseException; lineNumber: 1; columnNumber: 1; Content is not allowed in prolog.

------

File is simply

WC|A6|Apple iphone 6

So Document Flow seems to think that the inbound file should be one of XML and not CSV.

I did not use the internal automated XSLT but created my own.Not sure if this is related or not.

Maxime Richard

Your input of XSLT must be Process.ItemDesc BOD

Did you test your XSLT sheet ?

Legacy Contributor

Yes, the output was fine within 'Testing' tab

Legacy Contributor

Hey there, just wanted to provide a heads up that I've moved this thread to the ION Mapper forum

Denis MARETTE

Hi @tilen-markez

I don't understand where my settings don't work.
I tried to follow your instructions step by step.
Everything works correctly except the final phase of writing in the CSV file
Here are the results and the settings for the last step
A little help would do me a lot of good
Thank for your help

Maxime Richard

Hello Denis,

Your custom BOD should looks like this:

1) Your file template seems to be OK despite the fact we don't see the fields description

2) In your connection point, choose "Modèle de format de fichier" instead of BOD (unless it copies the entire message in the file, not the data itself)

3) You should get 1 csv line per noun occurence. In my example:

A;B;C;D

1;2;3;4

Denis MARETTE

Hi @m-richard
Thank you for your help.

1. Please see my fields that were missing

2.Effectively, you are right : I use BOD instead File Format Template. I will change that in my next trial.

But, before doing this trial, I am waiting your advice about the first point.

Thanks

Copyright © 2025 Infor. All rights reserved.