Best approach for Flat file to xml conversion

[Former Member]

Hi ,

i have a scenario where i need to convert a flatfile delimited by hat(^) into xml for furhter mapping and processing. whats the best approach to convert it into xml format. with content conversion how would my data structure look like ?

an exmaple of the flat file is as follows

ENV001^ANAA1^{5012222222222}RIPLEY PUBLISHERS^{5013546113221}BATCH.CO.UK⁰⁰¹¹²⁸143700^REF00002 ^INVFIL

INVF01¹INVFIL⁹0700^INVOICES5012222222222^^{RIPLEY PUBLISHERS}FINIAL BUILDINGS^{DISTRIBUTION WAY}FOLKLEY^HAMPSHIRE

^{LO98 1UY}156582940^^^0049980Hillside Bookshop

INVF02¹^⁰⁷³GBP

INVF03³⁵⁰³1^001127001127001127^^^7

INVO01²INVOIC⁹^^0049980Hillside Bookshop^^^^^^6799909I001127⁰⁰¹¹²⁷1^⁰⁰¹²²⁹0

INVO03¹11111^^^^6799909I001127

INVO04¹1^{9780340043608}0340043601^^^^¹^⁶⁷23517^KG45434^^3044100Z⁰⁰⁰⁰^^^⁶⁹⁹⁰⁰0^^⁶⁹⁹⁰⁰1639200^35000

INVO04²1^{9780340043608}0340043601^^^^¹^¹0351^KG45400^⁴⁵⁴⁰⁰Z⁰⁰⁰⁰^^^⁶⁹⁹⁰⁰0^^⁶⁹⁹⁰⁰24500^35000

INVO04³1^{9780340680339}0340680334^^^^¹^¹⁰⁰31300^KG45435^^4543500Z⁰⁰⁰⁰^^^⁶⁹⁹⁰⁰0^^⁶⁹⁹⁰⁰2446500^35000

INVO04⁴1^{9780340680339}0340680334^^^^¹^¹0313^KG45400^⁴⁵⁴⁰⁰Z⁰⁰⁰⁰^^^⁶⁹⁹⁰⁰0^^⁶⁹⁹⁰⁰24500^35000

INVO04⁵1^{9781859987049}1859987044^^^^¹^²⁰6040^KG61035^^1220700A⁰⁰⁰⁰0^^^⁰0^^⁹³⁹⁰⁰657300^35000

INVO04⁵2^{9781859987049}1859987044^^^^¹^²⁰6040^KG38940^⁷⁷⁸⁸⁰⁰Z⁰⁰⁰⁰1^^^⁰0^^⁵⁹⁹⁰⁰419400^35000

INVO04⁵3^{9781859987049}1859987044^^^^¹^²⁰6040^KG22095^⁴⁴¹⁹⁰⁰S¹⁷⁵⁰⁰2^^^⁰0^^³⁴⁰⁰⁰237900^35000

INVO04⁶1^{9781859987049}1859987044^^^^¹^¹0302^KG61000^⁶¹⁰⁰⁰A⁰⁰⁰⁰0^^^⁰0^^⁹³⁹⁰⁰32900^35000

INVO04⁶2^{9781859987049}1859987044^^^^¹^¹0302^KG38900^³⁸⁹⁰⁰Z⁰⁰⁰⁰1^^^⁰0^^⁵⁹⁹⁰⁰21000^35000

INVO04⁶3^{9781859987049}1859987044^^^^¹^¹0302^KG22100^²²¹⁰⁰S¹⁷⁵⁰⁰2^^^⁰0^^³⁴⁰⁰⁰11900^35000

INVO07¹Z⁰6⁸⁴⁹⁶¹0^^084961849610⁸⁴⁹⁶¹84961

INVO07²S¹⁷⁵⁰⁰2⁴⁶⁴⁰0^^046404640812⁵⁴⁵²5452

INVO08²89601^^^{0008960189601}812⁹⁰⁴¹³90413^24

INVT01⁴INVTLR⁹89601⁸⁹⁶⁰¹812⁹⁰⁴¹³90413¹3

INVF01⁵INVFIL⁹0700^INVOICES5012222222222^^{RIPLEY PUBLISHERS}FINIAL BUILDING^{DISTIBUTION WAY}FOLKLEY^HAMPSHIRELO98

1UY^432582940^^0106968Action Books (HO)^{14-16 East Street}Drumoyne^Possilpark

INVF02¹^⁰⁷³GBP

INVF03³⁵⁰³1^001127001127001127^^^7

INVO01⁶INVOIC⁹^^0081111Action Books - Cadder Branch^^^^^^7897908I001127⁰⁰¹¹²⁷1^⁰⁰¹²²⁹0

INVO03¹11112^^^^7897908I001127

INVO04¹1^{9780340043608}0340043601^^^^¹^²⁰7020^KG41940^⁸³⁸⁸⁰⁰Z⁰⁰⁰⁰^^^⁶⁹⁹⁰⁰0^^⁶⁹⁹⁰⁰559200^40000

INVO04²1^{9780340043608}0340043601^^^^¹^¹0351^KG41900^⁴¹⁹⁰⁰Z⁰⁰⁰⁰^^^⁶⁹⁹⁰⁰0^^⁶⁹⁹⁰⁰28000^40000

INVO04³1^{9780340680339}0340680334^^^^¹^²⁰6260^KG41940^⁸³⁸⁸⁰⁰Z⁰⁰⁰⁰^^^⁶⁹⁹⁰⁰0^^⁶⁹⁹⁰⁰559200^40000

INVO04⁴1^{9780340680339}0340680334^^^^¹^¹0313^KG41900^⁴¹⁹⁰⁰Z⁰⁰⁰⁰^^^⁶⁹⁹⁰⁰0^^⁶⁹⁹⁰⁰28000^40000

INVO04⁵1^{9781859987049}1859987044^^^^¹^²⁰6040^KG56340^^1126800A⁰⁰⁰⁰0^^^⁰0^^⁹³⁹⁰⁰751200^40000

INVO04⁵2^{9781859987049}1859987044^^^^¹^²⁰6040^KG35945^⁷¹⁸⁹⁰⁰Z⁰⁰⁰⁰1^^^⁰0^^⁵⁹⁹⁰⁰479300^40000

INVO04⁵3^{9781859987049}1859987044^^^^¹^²⁰6040^KG20395^⁴⁰⁷⁹⁰⁰S¹⁷⁵⁰⁰2^^^⁰0^^³⁴⁰⁰⁰271900^40000

INVO04⁶1^{9781859987049}1859987044^^^^¹^¹0302^KG56300^⁵⁶³⁰⁰A⁰⁰⁰⁰0^^^⁰0^^⁹³⁹⁰⁰37600^40000

INVO04⁶2^{9781859987049}1859987044^^^^¹^¹0302^KG35900^³⁵⁹⁰⁰Z⁰⁰⁰⁰1^^^⁰0^^⁵⁹⁹⁰⁰24000^40000

INVO04⁶3^{9781859987049}1859987044^^^^¹^¹0302^KG20400^²⁰⁴⁰⁰S¹⁷⁵⁰⁰2^^^⁰0^^³⁴⁰⁰⁰13600^40000

INVO07¹Z⁰6²⁵¹⁶²0^^025162251620²⁵¹⁶²25162

INVO07²S¹⁷⁵⁰⁰2⁴²⁸³0^^042834283750⁵⁰³³5033

INVO08²29445^^^{0002944529445}750³⁰¹⁹⁵30195^24

INVT01⁴INVTLR⁹29445²⁹⁴⁴⁵750³⁰¹⁹⁵30195¹3

END001^7

and the structure of the data type is as below

ENV001 (Envelope Header: one per file)

INVF01 (File Header : one per Bookshop Head office and one per Supplier)

INVF02 (File Header : repeated after every INVF01 Line)

INVF03 (File Header : repeated after every INVF02 Line)

INVO01 (Invoice Header : one per invoice)

INVO04 (Invoice detail line : one for each line unless Mixed VAT)

INVO04 (Invoice detail line : one for each line unless Mixed VAT)

INVO03 (Order reference details – refers to previous Invoice detail line, or to whole invoice if placed after invoice header)

INVO04 (Invoice detail line : one for each line unless Mixed VAT)

INVO04 (Invoice detail line : one for each line unless Mixed VAT)

INVO03 (Order reference details – refers to previous Invoice detail line, or to whole invoice if placed after invoice header)

INVO04 (Invoice detail line : one for each line unless Mixed VAT)

INVO07 (VAT Summary : one per VAT rate)

INVO08 (Invoice Total record : one per Invoice)

INVF01 (File Header : one per Bookshop Head office and one per Supplier)

INVF02 (File Header : repeated after every INVF01 Line)

INVF03 (File Header : repeated after every INVF02 Line)

INVO01 (Invoice Header : one per invoice)

INVO04 (Invoice detail line : one for each line unless Mixed VAT)

INVO04 (Invoice detail line : one for each line unless Mixed VAT)

INVO03 (Order reference details – refers to previous Invoice detail line, or to whole invoice if placed after invoice header)

INVO04 (Invoice detail line : one for each line unless Mixed VAT)

INVO04 (Invoice detail line : one for each line unless Mixed VAT)

INVO03 (Order reference details – refers to previous Invoice detail line, or to whole invoice if placed after invoice header)

INVO04 (Invoice detail line : one for each line unless Mixed VAT)

INVO07 (VAT Summary : one per VAT rate)

INVO08 (Invoice Total record : one per Invoice)

INVT01 (File Total record : one per file)

END001 (End of file record : one per file)

i guess i should use content conversion but not sure if XI can handle complex substructures. please advice me on the best approach.

thank you

[Former Member]

thanks

[Former Member]

Hi Sudheer,

You should be able to achieve this using content conversion.

Please check the following help link on how to do it using content conversion,

http://help.sap.com/saphelp_nw70/helpdata/en/0b/9a50465ccf84479e39a6d50c90fb3f/frameset.htm

The other option could be writing a small adapter module which will convert your flat file into xml using SAX parsers. You can find API for using SAX or DOM parsers on net.

Regards,

Yomesh