Message Mapping: Items under Header node.

[Former Member]

Hi,

Below is the file sample:

0_LBS0000000008_2011090707:30:13~0000000009

4_GBP55.67_SB300005_VISTADocNO1100_DistChanPaymentDays

5₀₀₁Quan_UoMNetPrice_GrossPricePubDiv_{9781444724585}20110907₁₀₀1.1

5₀₀₂Quan_UoMNetPrice_GrossPricePubDiv_{9781444724585}20110907₁₀₀1.1

4_GBP55.67_SB300005_VISTADocNO1100_DistChanPaymentDays

5₀₀₁Quan_UoMNetPrice_GrossPricePubDiv_{9781444724585}20110907₁₀₀1.1

1~7

Record Type:Header Record(Always = 0),Min Occurrence:1,Max Occurrence:1

Record Type:Sales Invoice Header Record (Always = 4),Min Occurrence:0,Max Occurrence:unlimited

Record Type:Sales Invoice Item Record (Always = 5) ,Min Occurrence:1(per Sales Invoice Header Record)

,Max Occurrence:999999 (per Sales Invoice Header Record)

Record Type:Trailer Record(Always = 1),Min Occurrence:1,Max Occurrence:1

The Src Str is:

Header

SalesInvoiceHeader

SalesInvoiceItem

Trailer

The target Str is:

Header

SalesInvoiceHeader

SalesInvoiceItem (Child node of SalesInvoiceHeader)

Trailer

Provide some inputs.

Thanx

[Former Member]

You can read this with FCC.

you to create 4 structure

DT_input
...HeaderRecord 1..1
.....f1
.....f2
.......
.....fn
...SalesInvoiceHeader 1..unbounded
.....f1
.....f2
.......
.....fn
...SalesInvoiceItem  1..unbounded
.....f1
.....f2
.......
.....fn
...Trailer  1..1
.....f1

Content conversion paarameters

Recorset Structure = HeaderRecord,1,SalesInvoiceHeader,*,SalesInvoiceItem,*,Trailer,1
Key Field Names = KEY

HeaderRecord.fieldNames = KEY,.......
HeaderRecord.fieldSeparator = '~'
HeaderRecord.keyfieldValue = 0


SalesInvoiceHeader.fieldNames = KEY,.......
SalesInvoiceHeader.fieldSeparator = '~'
SalesInvoiceHeader.keyfieldValue = 4


SalesInvoiceItem .fieldNames = KEY,.......
SalesInvoiceItem .fieldSeparator = '~'
SalesInvoiceItem .keyfieldValue = 5


Trailer .fieldNames = KEY
Trailer .fieldSeparator = '~'
Trailer .keyfieldValue = 1

good luck

[Former Member]

Hi,

As per my understanding you cannot have hierarchical structure with FCC. You have to do either by using XSLT mapping or Java Mapping (XML Parsing). Or You can use conversion agents.

Check out similar discussion in this thread.

regards,

Ramesh

Edited by: Ramesh P on Sep 8, 2011 6:22 PM

[former_member191435]

HI,

Create source structure and target struticres as

Header 0...1 Header 0...1

SalesInvoiceHeader 0....unbounded SalesInvoiceHeader 0....unbounded

SalesInvoiceItem 0.....Unbounded SalesInvoiceItem 0.....Unbounded

Trailer 0....1 Trailer 0....1

Can u please provide the sample source xml file.

Thanks,

Enivass