FCC a file with random sequence

[Former Member]

Hi Everybody,

HI,

I am facing one issue Can you tell me how i can resolve it. please see the incoming file structure i am getting

010johnnewjersy

02001price

03002989

030039898

020011898

02001101

0309090

010johnks

where 010-keyfield

020-keyfield

030-keyfiled

here rows with 020 030 can repeatand whole set 010,020..unbound,030..unbound . 010 record can repeat once again which will treated as new set

hope you understand. need directions to configure my sender adapter.

Thanks for your time

bye

raj

[Former Member]

Hi,

Go through the links below:-

Content Conversion (Pattern/Random content in input file)

FCC -

FCC - MDM

Thanks

[Former Member]

Hi Anand/ Hamja,

Thanks for your replies. Your solutions can be used in file adapter , I have to do same scenariou2019s using JMS adapter. As per Husain, I am using Plain2XML module to do content conversion in JMS adapter but they are working fine with simple file structures upto 2levels. But what ever flat flle structure I posted here is complex at multilevels , My aim is to read the all the records at one shot and do the multi levl mapping in the next mapping . Anand what ever blog you sent is useful , I want to apply same logic using Plain2XML module so that I can read all the records at first level. SO if somebody can tell me where I can find the all parameter which I can use with Plain2xML module and also if you can tell me whether I can use these

Recordset Structure : - Header, 1 , Body1, * , Body2 ,*

Recorsdet Sequence:- Variable

Using Plain2XML module. It would be very helpful to me, as I need to do this JMS configuration.

Thanks

raj

[Former Member]

Hi,

Pls do Content conversion in adapter as follows.

Module Key Parameter Name Parameter Value

Plain2XML xml.recordsetName MyRecordset

Plain2XML xml.recordsetStructure NameA,1,NameB,,NameC,

Plain2XML xml.keyFieldName MyKey

Plain2XML xml.keyFieldType CaseSensitiveString

Plain2XML xml.NameA.fieldNames MyKey,field-nameA

Plain2XML xml.NameA.fieldFixedLengths ex:2,10

Plain2XML xml.NameA.keyFieldValue 010

Plain2XML xml.NameB.fieldNames MyKey,field-nameB1,field-nameB2

Plain2XML xml.NameB.fieldFixedLengths ex:2,3,3

Plain2XML xml.NameB.keyFieldValue 020

Plain2XML xml.NameC.fieldNames MyKey,field-nameC

Plain2XML xml.NameC.fieldFixedLengths ex:2,5

Plain2XML xml.NameC.keyFieldValue 020

It will solve your query.Please let me know if you still face problems.

Please award marks if found useful.

Thanks

Hamja

[Former Member]

Raja,

You would have the following FCC parameters:

Recordset Structure : - Header, 1 , Body1, * , Body2 ,*

Recorsdet Sequence:- Variable

The keyField, fieldNames, fieldSeparator, endSeparator values for the above recordsets would have to be specified.

Thanks,

Anand

PS:Refer this blog for a detailed explanation of FCC for input files with random content:

[https://www.sdn.sap.com/irj/sdn/weblogs?blog=/pub/wlg/1825] [original link is broken] [original link is broken] [original link is broken];

Edited by: Anand Gopinath on Aug 8, 2008 8:20 AM

Edited by: Anand Gopinath on Aug 8, 2008 8:46 AM