[XML-DEV Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message]

Re: document to XML conversion

  • From: "Ding, Suli (GEIS)" <Suli.Ding@g...>
  • To: "'Philipp.Schaumann@c...'" <Philipp.Schaumann@c...>
  • Date: Fri, 4 Dec 1998 22:48:02 -0500

document to xml conversion
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@c...>	
To:	<suliding@y...>	
Cc:	"Soo TuckYan" <TuckYan.Soo@c...>,	
	"Jacob Morrison" <Jacob.Morrison@c...>	
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@Q
M+#%S*2P@5&5S=#UF,3$L($%#2SUF.2`-"E))1#U53D(L(%-E;F1E<CU;475A
M;&EF:65R/2@R+#%S*2Q396YD97))1#TH,BPP<RE=+"!296-E:79E<CU;475A
M;&EF:65R/2@S+#%S*2Q296-E:79E<DE$/2@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@L($US9U1Y240]*#(L
M,',I#0I2240]0D=-+"!$;V-#;V1E/2@Q+#!S*2P@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@Q+#%S*2P@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@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@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@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@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@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@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@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@R+#%S*3PO06-T3F%M93X-"@D\+U))1#X-"@D\4DE$(&UA=&-H/2)#55@B
M/@T*"0D\0W5R469R/B@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@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@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@i...
Archived as: http://www.lists.ic.ac.uk/hypermail/xml-dev/
To (un)subscribe, mailto:majordomo@i... the following message;
(un)subscribe xml-dev
To subscribe to the digests, mailto:majordomo@i... the following message;
subscribe xml-dev-digest
List coordinator, Henry Rzepa (mailto:rzepa@i...)


PURCHASE STYLUS STUDIO ONLINE TODAY!

Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!

Buy Stylus Studio Now

Download The World's Best XML IDE!

Accelerate XML development with our award-winning XML IDE - Download a free trial today!

Don't miss another message! Subscribe to this list today.
Email
First Name
Last Name
Company
Subscribe in XML format
RSS 2.0
Atom 0.3
 

Stylus Studio has published XML-DEV in RSS and ATOM formats, enabling users to easily subcribe to the list from their preferred news reader application.


Stylus Studio Sponsored Links are added links designed to provide related and additional information to the visitors of this website. they were not included by the author in the initial post. To view the content without the Sponsor Links please click here.

Site Map | Privacy Policy | Terms of Use | Trademarks
Free Stylus Studio XML Training:
W3C Member
Stylus Studio® and DataDirect XQuery ™are products from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2013 All Rights Reserved.