Problem with File Content Conversion

[Chandra_Hota]

Hi All

I am facing a problem with file content conversion.

This is my sample file structure:

Header_Record (Occurance - 1)

Field1 in Header

Field2 in Header

Item(Occ-1 to n)

Field3 in Item

Field4 in Item

<<ItemType>> (Structure in Item) (Occ - 0 to n)

<<Field5>> in ItemType

<<Field6>> in ItemType

<<ItemTypeCategory>> (Structure in ItemType)(Occ - 0 to n)

<<<<Field7>>>> in ItemTypeCategory

<<<<Field8>>>> in ItemTypeCategory

Footer_Record (Occurance-1)

Field9

Field10

There is a key field 'Type' in all the above records with unique value in each record.

Now, I defined Field content conversion as follows:

Recordset Structure: Header_Record,1,Item, * , ItemType, * ,ItemTypeCategory, * ,Footer_Record,1

Recordset Sequence: Ascending

KeyField Name: Type

Following are parameters defiled:

Header_Record.Keyfieldvalue: 00

Header_Record.fieldseperator: ,

Header_Record.fieldnames: Field1,Field2

Header_Record.endseperator: 'nl'

Item.keyfieldvalue: 05

item.fieldseperator: ,

item.fieldfieldnames: field3,field4

item.endseperator: 'nl'

ItemType.keyfieldvalue: 10

itemType.fieldseperator: ,

itemType.fieldfieldnames: field5,field6

itemType.endseperator: 'nl'

ItemTypecategory.keyfieldvalue: 15

itemTypecategory.fieldseperator: ,

itemTypecategory.fieldfieldnames: field7,field8

itemTypecategory.endseperator: 'nl'

Footer.keyfieldvalue: 20

Footer.fieldseperator: ,

Footer.fieldfieldnames: field5,field6

Footer.endseperator: 'nl'

Now, i pass the following file:

00,111

05,222

10,333

15,444

20,555

What i expect out of my FCC is this (Sample output to show the hierarchy of field values):

00,111

05,222

<<10,333>>

<<<<15,444>>>>

20,555

But, I am getting this output (Hierarchy is missing. All the structures are in the same order without hierarchy):

00,111

05,222

10,333

15,444

20,555

Field values are being identified according to field content conversion, but, the hierarchy of the fields is missing.

Can you please tell me how should i change my FCC config?

Sorry for this long question.

Many Thanks

Chandra

Edited by: Chandra Sekhar H on Jan 30, 2009 7:10 PM

Edited by: Chandra Sekhar H on Jan 30, 2009 7:16 PM

Edited by: Chandra Sekhar H on Jan 30, 2009 7:17 PM

[Former Member]

U cannot parse the structure below three levels. Please modify the structure

<Recordset>

<Record>

<Fields>

You can simplify the structure in the Items. This can ease out. If you mention your structure. I can help suggest some.

Thanks

Nikhil

[VijayKonam]

You will always get a flat structure from FCC. If you want hierarchichal strucuture, you have to create a target and map. You will get only like -

Root

--Recordset

-

---

Group1

-

---

Fields

-

---

Grop2

-

---

Fields

-

---

Group3

-

---

Fields

VJ

[Chandra_Hota]

Hi All

Is there any problem with FCC configuration (please see above) because of which, data hirarchy is incorrect?

Please let me know.

Thanks

Chandra

[VijayKonam]

No. Its that way FCC has been designed to. You will get only ad flat strucuture under recordset.

VJ