topic Re: Mapping EDI message to CSV in Talend Studio

Mapping EDI message to CSV

SMAAYOUF1608544534 — Tue, 22 Dec 2020 08:24:47 GMT

Hello,

First of all, this is my first post on this forum

I'm new to Talend and have a project to set up.

I have to set up a solution for the issuance and reception of EDI flows (ORDERS and DESADV) with our partners in supermarkets.

How can I process an EDI file on talend? (Example translate an EDI message into CSV).

I have implemented a solution but I am not convinced in terms of performence.

Also, I don't get all the lines.

For example :

.........

BGM+220+COM00002+9'

DTM+137:20210110:102'

DTM+2:20210120:102'

RFF+CT:C0000025'

DTM+171:20121221:102'

NAD+BY+3026990099753::9'

NAD+DP+3026990099753::9'

NAD+SU+3014531200102::9'

NAD+UC+3026990099753::9'

NAD+SF+3026990099753::9'

NAD+IV+3027000009000::9'

CUX+2:EUR:9+3:GBP:4+1.24'

DTM+134:20130110:102'

TDT+20++30+31+9999999999999::9'

TOD+10E+X1E'

for the NAD+XX I get just the first line of NAD (BY😞

How do you make a loop on this kind of segment and how can the result be obtained in CSV format?

Thank you!

Re: Mapping EDI message to CSV

Anonymous — Mon, 28 Dec 2020 08:25:11 GMT

Hello,

There are different EDIs format. Each format can be managed by a specific gXML files, that is like an XSD definition for EDI files.

Talend Studio enables you to access structures, maps and namespace containers created in the Mapping perspective by expanding the Hierarchical Mapper node, which is located under the Metadata folder in the Repository tree view in the Integration perspective.

This feature is available in talend subscription solution.

For more information please have a look at this online user guide: https://help.talend.com/r/~_W_t84iB9ba_TN09qD6mA/3~tohjTK~75mJAZmM7v9ug

Best regard

Sabrina

Re: Mapping EDI message to CSV

SMAAYOUF1608544534 — Tue, 29 Dec 2020 08:22:54 GMT

Hey Xdshi,

Thank for your replay !

For EDI files, we have a EDIFACT file metadata.

For my example I created an ORDERS D96a metadata, I configured the job as indicated in the talend support but I still have the problem of the loop.

As I indicated in my previous message is that if I have a duplicate segment like the example below the job reads only the first line

....

BGM+220+128576+9'

DTM+137:20130109:102'

DTM+2:20130201:102'

NAD+BY+3026990099753::9'

NAD+DP+3026990099753::9'

.....

So, in this example i have just the result about the first date : DTM+137:20130109:102'.

Thanks !