csv flat file export from ion

Legacy Contributor

Hello all,

I'm not sure whether this is appropriate, so I apologize in advance. My company has been using ION to produce XML files from EAM invoices. We are moving to a new platform and require the flat file to be csv and not XML. I have posted and recieved some help from the community but I have another problem that I have been unable to solve and this is now impacting project timelines.

I have constructed a mapping in graphical mode which outputs header and detail lines in one row. So the detail values are concatanated together like:

hdr1, hdr2, hdr3, dtl1 dtl2 dtl3.

I need:

hdr1, hdr2, hdr3, dtl1

hdr1, hdr2, hdr3, dtl2

hdr1, hdr2, hdr3, dtl3

I have been unable to do this with the graphical mapper, so I have changed the graphical mode to XSLT (this is where I had some help from the community and some help from Infor Support).

In testing mode, the output appears to be correct:

hdr1

hdr2

hdr3

dtl1

dtl2

dtl3

However, when I run the data flow, I get an error message that says the BOD does not contain any matching data.

So although the testing mode does not show any errors/problems, the data flow errors out.

We are trying to engage Infor consulting but we are not being very successful. So I would like to know whether anyone can recommend a company or consultant who we can engage to help us solve this problem. As I mentioned before this is time sensitive, so hoping we can engage someone in the next couple of days or so.

Thank you,

Peter

Maxime Richard

Hello Peter,

I suppose that you expect a csv file like this:

The output seems not ok for me. To get a csv file in the end, it requires an XML file embedded in your custom noun like this:

<Your Noun>

   <hdr1>value_hdr1</hdr1>

   <hdr2>value_hdr2</hdr2>

   <hdr3>...</hdr3>

    <detail>dtl1</detail>

</YourNoun>

<Your Noun>

   <hdr1>value_hdr1</hdr1>

   <hdr2>...</hdr2>

   <hdr3>...</hdr3>

    <detail>dtl2</detail>

</YourNoun>

<Your Noun>

   <hdr1>value_hdr1</hdr1>

   <hdr2>...</hdr2>

   <hdr3>...</hdr3>

    <detail>dtl3</detail>

</YourNoun>

One occurence of your noun per line of csv file. The tags hdr1, hdr2, hdr3 and detail are defined in the associated file template.

Maybe could you post a screenshot or two about the timeline of your BOD and the content of it ?