document to XML conversion
Ding, Suli (GEIS)
Suli.Ding at geis.ge.com
Sat Dec 5 03:54:44 GMT 1998
Philipp,
I modified the template files (both the original and the XML one) to make
the LIN segment and the related segments a new HEADER. The output comes out
just the way you want it. The template files are attached with this e-mail.
Thanks,
Suli
(P.s. I will make the change to the template files in my page at
http://www.geocities.com/SiliconValley/Platform/4871/
to reflect the changes)
<<unb.tbl>> <<unb.tbl.xml>>
From: "Philipp Schaumann" <Philipp.Schaumann at cdc.com>
To: <suliding at yahoo.com>
Cc: "Soo TuckYan" <TuckYan.Soo at cdc.com>,
"Jacob Morrison" <Jacob.Morrison at cdc.com>
Subject: document to XML conversion
Date: Fri, 4 Dec 1998 11:47:32 +0800
HI,
I looked at your document-to-XML converter, quite interesting and very
smartly done. :-)
However, the problem that I had been thinking about seems not (yet ?)
implemented in this. The challenge that I see is how to get a
hierarchical
structure into the documents when converting from EDI (which contains an
implicit hierarchy, e.g. for line item loops, but is basically
syntactically
flat). XML can support hierarchies very nicely.
What I mean is the following: In EDIFACT (and X.12) you have various
repeating groups, e.g. in your sample ORDERS document the line items. In
EDIFACT, you recognize that you are in the second instance of the line
items
loop when you encounter the second LIN segment.
In XML, I would hope for a <LIN>, which is ended by </LIN> and which
includes all the information for this line item. Your converter does not
seem to allow this. Looking at your sample output, the <LIN> bracket
for the
first item does not contain the other segments that also belong to the
first
line item.
What I was hoping for was output that looks like this:
<LIN>
<LINSEG>
<LinNum>1</LinNum>
<LIN02></LIN02>
<ItemNum>136-804-086</ItemNum>
<ItemTy>BP</ItemTy>
<SLInd>CM316X7R474K16AT</SLInd>
<LinItemNum>MG</LinItemNum>
<LIN05>21:9000:PK</LIN05>
<LIN06>0.053:CT:1:PK</LIN06>
</LINSEG>
<PIA>
<ProdID>4</ProdID>
<ItemNoID>AVX</ItemNoID>
<ItemNoTy>MF</ItemNoTy>
</PIA>
<SCC>
<DlvCode>1</DlvCode>
<DlvInst></DlvInst>
</SCC>
<QTY>
<QtyQfr>21</QtyQfr>
<Qty>9000</Qty>
<Unit>PK</Unit>
</QTY>
<DTM>
<DTQfr>002</DTQfr>
<DTPrd></DTPrd>
</DTM>
<SCC>
<DlvCode>1</DlvCode>
<DlvInst></DlvInst>
</SCC>
<QTY>
<QtyQfr>21</QtyQfr>
<Qty>2000</Qty>
<Unit>PK</Unit>
</QTY>
<DTM>
<DTQfr>002</DTQfr>
<DTPrd></DTPrd>
</DTM>
</LIN>
<LIN>
<LINSEG>
<LinNum>2</LinNum>
.....
The idea is that everything that belongs to 1 line item is group
together.
Would that be possible using your syntax.
Thanks
Philipp
begin 600 unb.tbl
M2$146%0]/#]X;6P@=F5R<VEO;CTB,2XP(C\^/$1/0U5-14Y4/@T*5$Q46%0]
M/"]$3T-5345.5#X@("`@(`T*(PT*(R!F;W(@141)1D%#5"!D;V-U;65N=',-
M"B,-"FAE861E<CU53D(L(%1I;64]*#0L,7,I+"!S97`]2U5.0BLP+"!354(]
M2U5.3T$K,"P@=&5R;3U+54Y(+3`L($1A=&4]*#0L,',I+"!697)S:6]N/2 at Q
M+#%S*2P at 5&5S=#UF,3$L($%#2SUF.2`-"E))1#U53D(L(%-E;F1E<CU;475A
M;&EF:65R/2 at R+#%S*2Q396YD97))1#TH,BPP<RE=+"!296-E:79E<CU;475A
M;&EF:65R/2 at S+#%S*2Q296-E:79E<DE$/2 at S+#!S*5TL($EX0W1L4F5F/68U
M+"!0<W=D/68V+"!!<'!2968]9C<-"E1R86EL97(]54Y:#0HC#0IH96%D97(]
M54Y(+"!-<V=2968]9C$L($US9U1Y240]*#(L,',I+"!-<V=4>59E<G-I;VX]
M*#(L,7,I+"!-<V=4>5)E;#TH,BPR<RD-"E))1#U53D at L($US9U1Y240]*#(L
M,',I#0I2240]0D=-+"!$;V-#;V1E/2 at Q+#!S*2P at 1&]C5'D]*#$L,7,I+"!$
M;V-)1#TH,BPP<RD-"E))1#U2148L(%)E9E%F<CTH,2PP<RDL(%)E9DYU;3TH
M,2PQ<RD-"E))1#U.040L(%%F<CTH,2PP<RDL($%C=$YU;3TH,BPP<RDL($%C
M=$YA;64]*#(L,7,I+"!!8W1.86UE*#(L,G,I#0I2240]0U58+"!#=7)19G(]
M*#$L,',I+"!#=7)#;V1E/2 at Q+#%S*2P at 0W5R1'1L/68R+"!#=7)2871E/68S
M+"!#=7)%>$-O9&4]9C0-"G1R86EL97(]54Y4#0HC#0IH96%D97(]3$E.#0I2
M240]3$E.+"!,24Y314<]6TQI;DYU;3UF,2P at 3$E.,#(]9C(L($ET96U.=6T]
M*#,L,',I+"!)=&5M5'D]*#,L,7,I+"!33$EN9#TH-"PP<RDL3&EN271E;4YU
M;3TH-"PQ<RDL($Q)3C`U/68U+"!,24XP-CUF-ET-"E))1#U024$L(%!R;V1)
M1#UF,2P at 271E;4YO240]*#(L,',I+"!)=&5M3F]4>3TH,BPQ<RD-"E))1#U1
M5%DL(%%T>5%F<CTH,2PP<RDL(%%T>3TH,2PQ<RDL(%5N:70]*#$L,G,I#0I2
M240]4T-#+"!$;'9#;V1E/68Q+"!$;'9);G-T/68R#0I2240]1%1-+"!$5%%F
:<CTH,2PP<RDL($144')D/2 at Q+#%S*0T*#0H=
`
end
begin 600 unb.tbl.xml
M/#]X;6P@=F5R<VEO;CTB,2XP(C\^#0H\5$5-4$Q!5$4^#0H\2$146%0^#0H\
M(2TM/#]X;6P@=F5R<VEO;CTB,2XP(C\^#0H@"3Q$3T-5345.5#X-"BTM/@T*
M#0H\+TA$5%A4/@T*/%1,5%A4/@T*/"$M+3PO1$]#54U%3E0^#0HM+3X-"CPO
M5$Q46%0^#0H-"@DC#0H@("`)(R!F;W(@141)1D%#5"!D;V-U;65N=',-"B`@
M(`DC(`T*+2T^#0H\2$5!1$52(&UA=&-H/2)53D(B(%1,4CTB54Y:(B!4:6UE
M/2(H-"PQ<RDB('-E<#TB2U5.0BLP(B!354(](DM53D]!*S`B('1E<FT](DM5
M3D at M,"(@1&%T93TB*#0L,',I(B!697)S:6]N/2(H,2PQ<RDB(%1E<W0](F8Q
M,2(@04-+/2)F.2(^(`T*"3Q2240@;6%T8V@](E5.0B(^#0H)"3Q396YD97(@
M9W)O=7`](C$B/@T*"0D)/%-1=6%L:69I97(^*#(L,7,I/"]3475A;&EF:65R
M/@T*"0D)/%-E;F1E<DE$/B at R+#!S*3PO4V5N9&5R240^#0H)"3PO4V5N9&5R
M/@T*"0D\4F5C96EV97(@9W)O=7`](C$B/@T*"0D)/%)1=6%L:69I97(^*#,L
M,7,I/"]2475A;&EF:65R/@T*"0D)/%)E8V5I=F5R240^*#,L,',I/"]296-E
M:79E<DE$/@T*"0D\+U)E8V5I=F5R/@T*"0D\27A#=&Q2968^9C4\+TEX0W1L
M4F5F/@T*"0D\4'-W9#YF-CPO4'-W9#X-"@D)/$%P<%)E9CYF-SPO07!P4F5F
M/@T*"3PO4DE$/@T*/"](14%$15(^#0H\(2TM("`C("`M+3X-"CQ(14%$15(@
M;6%T8V@](E5.2"(@5$Q2/2)53E0B($US9U)E9CTB9C$B($US9U1Y5F5R<VEO
M;CTB*#(L,7,I(B!-<V=4>5)E;#TB*#(L,G,I(CX-"@D\4DE$(&UA=&-H/2)5
M3D at B/@T*"0D\37-G5'E)1#XH,BPP<RD\+TUS9U1Y240^#0H)/"]2240^#0H)
M/%))1"!M871C:#TB0D=-(CX-"@D)/$1O8T-O9&4^*#$L,',I/"]$;V-#;V1E
M/@T*"0D\1&]C5'D^*#$L,7,I/"]$;V-4>3X-"@D)/$1O8TE$/B at R+#!S*3PO
M1&]C240^#0H)/"]2240^#0H)/%))1"!M871C:#TB4D5&(CX-"@D)/%)E9E%F
M<CXH,2PP<RD\+U)E9E%F<CX@#0H)"3Q2969.=6T^*#$L,7,I/"]2969.=6T^
M#0H)/"]2240^#0H)/%))1"!M871C:#TB3D%$(CX@#0H)"3Q19G(^*#$L,',I
M/"]19G(^#0H)"3Q!8W1.=6T^*#(L,',I/"]!8W1.=6T^#0H)"3Q!8W1.86UE
M/B at R+#%S*3PO06-T3F%M93X-"@D\+U))1#X-"@D\4DE$(&UA=&-H/2)#55 at B
M/@T*"0D\0W5R469R/B at Q+#!S*3PO0W5R469R/@T*"0D\0W5R0V]D93XH,2PQ
M<RD\+T-U<D-O9&4^#0H)"3Q#=7)$=&P^9C(\+T-U<D1T;#X-"@D)/$-U<E)A
M=&4^9C,\+T-U<E)A=&4^#0H)"3Q#=7)%>$-O9&4^9C0\+T-U<D5X0V]D93X-
M"@D\+U))1#X-"CPO2$5!1$52/@T*/"$M+2!!(&YE=R!G<F]U<"!F;W(@3&EN
M92!I=&5M<R`M+3X-"CQ(14%$15(^#0H)/%))1"!M871C:#TB3$E.(CX-"B`@
M("`@("`@/$Q)3E-%1R!G<F]U<#TB,2(^#0H)"2`@("`\3&EN3G5M/F8Q/"],
M:6Y.=6T^#0H)"2`@("`\3$E.,#(^9C(\+TQ)3C`R/@T*"0D@("`@/$ET96U.
M=6T^*#,L,',I/"])=&5M3G5M/@T*"0D@("`@/$ET96U4>3XH,RPQ<RD\+TET
M96U4>3X-"@D)("`@(#Q33$EN9#XH-"PP<RD\+U-,26YD/@T*"0D@("`@/$QI
M;DET96U.=6T^*#0L,7,I/"],:6Y)=&5M3G5M/@T*"0D@("`@/$Q)3C`U/F8U
M/"],24XP-3X-"@D)("`@(#Q,24XP-CYF-CPO3$E.,#8^#0H@("`@("`@(#PO
M3$E.4T5'/@T*"3PO4DE$/@T*"3Q2240@;6%T8V@](E!)02(^#0H)"3Q0<F]D
M240^9C$\+U!R;V1)1#X-"@D)/$ET96U.;TE$/B at R+#!S*3PO271E;4YO240^
M#0H)"3Q)=&5M3F]4>3XH,BPQ<RD\+TET96U.;U1Y/@T*"3PO4DE$/@T*"3Q2
M240@;6%T8V@](E%462(^#0H)"3Q1='E19G(^*#$L,',I/"]1='E19G(^#0H)
M"3Q1='D^*#$L,7,I/"]1='D^#0H)"3Q5;FET/B at Q+#)S*3PO56YI=#X-"@D\
M+U))1#X-"@D\4DE$(&UA=&-H/2)30T,B/@T*"0D\1&QV0V]D93YF,3PO1&QV
M0V]D93X-"@D)/$1L=DEN<W0^9C(\+T1L=DEN<W0^"0T*"3PO4DE$/@T*"3Q2
M240@;6%T8V@](D1432(^#0H)"3Q$5%%F<CXH,2PP<RD\+T14469R/@T*"0D\
M1%10<F0^*#$L,7,I/"]$5%!R9#X-"@D\+U))1#X-"CPO2$5!1$52/@T*#0H\
,+U1%35!,051%/@T*
`
end
xml-dev: A list for W3C XML Developers. To post, mailto:xml-dev at ic.ac.uk
Archived as: http://www.lists.ic.ac.uk/hypermail/xml-dev/
To (un)subscribe, mailto:majordomo at ic.ac.uk the following message;
(un)subscribe xml-dev
To subscribe to the digests, mailto:majordomo at ic.ac.uk the following message;
subscribe xml-dev-digest
List coordinator, Henry Rzepa (mailto:rzepa at ic.ac.uk)
More information about the Xml-dev
mailing list