One Star

edi mapping

Hi
I start to use talend, my problem is mapping edi file
The question is: theare are component that simplify the mapping edi file (eg. ifcsum, iftmin,...).
6 REPLIES
Community Manager

Re: edi mapping

Hello
Can you show us an example of your file and what are your expected result?
Best regards
shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: edi mapping

Hi
This is an example of EDI standard file IFCSUM 96D use in Logistic Enviroment for send information from a shipping agent to an other shipping agent. In my application this files is used in input and ouput.
In this case the file is generated from my db using a specific program, and I want change all my structure using talend.
UNA:+.? '
UNB+UNOC:3+CRTCAR+PARTNERMAILBOXNAME+090626:1211+1'
UNH+1+IFCSUMSmiley Very Happy:96A:UNSmiley Very HappyEFO01'
BGM+787::ZZZ+00000593'
DTM+137:200212191016:203'
CNT+10:24:NMB'
CNT+7:6048:KGM'
CNT+15:2.742:MTQ'
CNT+16:5:NMB'
CNT+11:55:NMP'
RFF+AFC:128017'
DTM+171:20021218:102'
TDT+20++30++:::HELLMANN+++::Smiley FrustratedT-W 2136'
TSR++++HAZ'
NAD+CS+FODE034227::ZZZ++L.W.CRETSCHMAR GMBH & CO KG+H?LKER FELD 15+WUPPERTAL++42279+DE'
NAD+DC+YOURSENDID(10 digits)::ZZZ++ELSEN+8, RUE DE LA STATION+LUXEMBURG++4711+L'
EQD+SW+CC 94::ZZZ'
CNI+1+1030002168205+9999'
TOD+5++167::ZZZ'
TOD+6++EXW::ZZZ'
TCC+::ZZZ'
MOA+211:0:::17'
QTY+100:450:KGM'
QTY+109:3.408:MTQ'
NAD+CZ+000043057::ZZZ++DELPHI PACKARD ESPA¥A S.L.+AVDA.TORRELLES, 11-13+SANT VICEN? DELS HORTS++08620+ES'
NAD+CN+++DELPHI-PACKARD HUNGARY KFT+ZANATI UT 29/A+SZOMBATHELY (HUNGARY)++09700+H'
GID+1+3:FP::ZZZ+0+0:::ZZZ'
FTX+AAA+++BANDEJAS 12033?+13002'
MEA+WT+AAD+KGM:450'
MEA+VOL+ABJ+MTQ:3.408'
PCI++KLT 6001 ?+ KLT 6002'
GIN+001+00340355449300574530:00340355449300574547+00340355449300574660'
CNI+2+1030002168209+9999'
TOD+5++901::ZZZ'
TOD+6++DDU::ZZZ'
TCC+::ZZZ'
MOA+211:0:::17'
QTY+100:650:KGM'
QTY+109:0.58:MTQ'
NAD+CZ+000032590::ZZZ++PORVASAL S.A.+AUTOVIA A-3 KM 323+CHIVA++46370+ES'
NAD+CN+++TOOLS & TECHNOLOGIES GMBH+HEIDESTRASSE, 8+SCHONWALD++95173+DE'
GID+1+1:FP::ZZZ+0+0:::ZZZ'
FTX+AAA+++MATERIAL'
MEA+WT+AAD+KGM:650'
MEA+VOL+ABJ+MTQ:0.58'
PCI++-'
GIN+001+00340355449300577524'
CNI+3+1030002168226+9999'
TOD+5++167::ZZZ'
TOD+6++EXW::ZZZ'
TCC+::ZZZ'
MOA+211:0:::17'
QTY+100:5:KGM'
NAD+CZ+000006743::ZZZ++NETZSCH ESPA¥A S.A.+PROVENZA, 194+TERRASSA++08226+ES'
NAD+CN+++NETZSCH-FEINMAHLTECHNIK GMBH+MITTERTEICHER STRASSE 5+TIRSCHENREUTH++95643+DE'
GID+1+1:KT::ZZZ+0+0:::ZZZ'
FTX+AAA+++MATERIAL'
MEA+WT+AAD+KGM:5'
PCI++-'
GIN+001+00340355449300574981'
CNI+4+1030002168235+9999'
FTX+DIN+++MERCANCIA ADR CLASE 6.1 II UN 1630, NO EXCEDE'
TOD+5++901::ZZZ'
TOD+6++DDU::ZZZ'
TCC+::ZZZ'
MOA+211:0:::17'
QTY+100:53:KGM'
NAD+CZ+000015243::ZZZ++DOYDA S.L.+CARLES BUHIGAS, 7-F+CANOVELLES++08420+ES'
NAD+CN+++M&M EURONATIONAL GMBH+FUHRMANNSTR. 10+HOF/SAALE++95030+DE'
GID+1+1:FA::ZZZ+0+0:::ZZZ'
FTX+AAA+++MATERIAL'
MEA+WT+AAD+KGM:53'
PCI++09052548'
GIN+001+00340355449300575070'
CNI+5+1030002168274+9999'
TOD+5++901::ZZZ'
TOD+6++DDU::ZZZ'
TCC+::ZZZ'
MOA+211:0:::17'
QTY+100:618:KGM'
NAD+CZ+000006657::ZZZ++YONASH ESPA¥A, S.A.+METAL.LéRGIA, NAU 17 PI ST. VI+CASTELLBISBAL++08755+ES'
NAD+CN+++M.ZELLNER GMBH+GUTENBERGSTRASSE 1+MICHELAU++96247+DE'
GID+1+29:TL::ZZZ+0+0:::ZZZ'
FTX+AAA+++TEJIDOS'
MEA+WT+AAD+KGM:618'
PCI++-'
GIN+001+00340355449300576480:00340355449300576497+00340355449300576503:00340355449300576510+00340355449300576527:00340355449300576534+00340355449300576541:00340355449300576558+00340355449300576565:00340355449300576572'
GIN+001+00340355449300576589:00340355449300576596+00340355449300576602:00340355449300576619+00340355449300576626:00340355449300576633+00340355449300576640:00340355449300576657+00340355449300576664:00340355449300576671'
GIN+001+00340355449300576688:00340355449300576695+00340355449300576701:00340355449300576718+00340355449300576725:00340355449300576732+00340355449300576749:00340355449300576756+00340355449300576763'
CNI+6+1030002168339+9999'
TOD+5++167::ZZZ'
TOD+6++EXW::ZZZ'
TCC+::ZZZ'
MOA+211:0:::17'
QTY+100:40:KGM'
QTY+109:0.2:MTQ'
NAD+CZ+000006743::ZZZ++NETZSCH ESPA¥A, S.A.+PROVENZA, 194+TERRASSA++08226+ES'
NAD+CN+++NETZSCH-FEINMAHLTECHNIK GMBH+MITTERTEICHER STRASSE 5+TIRSCHENREUTH++95643+DE'
GID+1+1:TL::ZZZ+0+0:::ZZZ'
FTX+AAA+++MATERIAL'
MEA+WT+AAD+KGM:40'
MEA+VOL+ABJ+MTQ:0.2'
PCI++-'
GIN+001+00340355449300579825'
CNI+7+1030002168383+9999'
TOD+5++901::ZZZ'
TOD+6++DDU::ZZZ'
TCC+::ZZZ'
MOA+211:0:::17'
QTY+100:150:KGM'
QTY+109:1:MTQ'
NAD+CZ+000043057::ZZZ++DELPHI PACKARD ESPA¥A S.L.+AVDA.TORRELLES, 11-13+SANT VICEN? DELS HORTS++08620+ES'
NAD+CN+++DELPHI-PACKARD HUNGARY KFT+ZANATI UT 29/A+SZOMBATHELY (HUNGARY)++09700+H'
GID+1+1:FP::ZZZ+0+0:::ZZZ'
FTX+AAA+++BANDEJAS 12033?+13002'
MEA+WT+AAD+KGM:150'
MEA+VOL+ABJ+MTQ:1'
PCI++KLT6001 ?+ KLT 6002'
GIN+001+00340355449300580999'
UNT+338+1'
UNZ+1+1'
Six Stars

Re: edi mapping

I think that the missing EDI parsing components are the biggest issue in Talend TIS when it comes to enterprise adoption.
Having EDI components will boost Talend sales in enterprises; I was blocked from purchasing Talend ETL ( 15 ETL developers ) just because of the missing EDI components ( I couldn't sustain a business case for it ).
Six Stars

Re: edi mapping

For example see this table, it would be useful to have such components in Talend:
http://www.xmlconverters.com/standards/edifact/
Community Manager

Re: edi mapping

Hello guys
Yes, you are right. It is an interesting issue, Can you report a feature on our bugtracker?
Thanks for your support!!!
Best regards

shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
Six Stars

Re: edi mapping