cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Recordset structure

Former Member

on ‎08-11-2007 6:09 PM

0 Kudos

Hi All,

My scenario is file to IDoc.

The structure is

Header

--- Body

--- Body

Header

--- Body

--- Body

Meaning Body occurs unbounded times within Header. Moreover in the file the Header also occurs more than once.

I have given <b>Header,,Body</b> in Recordset of FCC. But when i receive the outbound payload the data comes as

Header

Body

Body

Header

Body

Body

Now how i shall i give the define the Recrodset in Content Conversion in order to get

Header

--- Body

--- Body

Header

--- Body

--- Body

Regards,

Ramesh P

Message was edited by:

Ramesh Parashivamurthy

Show replies
Show replies
Answer

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
‎08-11-2007 6:42 PM
0 Kudos

Hi,

Recordset structure should look like that:

Header,1,Body,*

/wg

Show replies
Show replies
Former Member
‎08-11-2007 6:53 PM
0 Kudos

hi Wojciech,

if i give Header,1,Body,*

data will be coming as Header,,Body,. So how can i your specified solution ??

regards

Ramesh P

Message was edited by:

Ramesh Parashivamurthy

Former Member
‎08-11-2007 7:00 PM
0 Kudos

I think that I could be wrong with that. Do you have a file format, is there any key field? Without it adapter will be not able to distinguish where is the beginning of new sequence.

/wg

Message was edited by:

Wojciech Gasiorowski

Former Member
‎08-11-2007 7:09 PM
0 Kudos

Hi,

The actual problem in generating the IDoc.

File contains :

Header1

Data1

Data2

Data3

Header2

Data1

Data2

Header3

Data1

Data2

But when the IDoc generated it was

Segment1 - for header1

datasegment - for Data1 >>>>>> Data2, Data3 are missing

Segment1 - for header2

datasegment - for Data2 >>>>>> Data2

Segment1 - for header3

datasegment - for Data3 >>>>>> Data2

I have mapped Segment to 1...Unbounded of header segment

I have mapped Segment to 1as constant

if i map body 1...unbounded to datasegment i receive an error ....

Regards

Ramesh P

Former Member
‎08-11-2007 7:18 PM
0 Kudos

hi

i am providing the sample input in the file. This contain one header and one data record, but this set can occur many times in the file.

H0010100120070802200708021001001 9001 001146

D001010012050000000706 0181820099000 0000099000

H and D are key field item for Header and Data

thanks

Ramesh P

Former Member
‎08-12-2007 1:42 AM
0 Kudos

Hi Ramesh,

I can't think of a way to create the structure you want because if you want Body to be at a lower level than Header you should have Header at Recordset level, but I don't think you would be able to pull the other Header information in since the Recordset Structure would only have many body fields.

An example for your sample file is:

You would get

<Header>

<Body>

<F1>001010012050000000706</F1>

<F2>0181820099000</F2>

<F3>0000099000</F3>

</Body>

</Header>

But would not get information from the Header row. ie.:

0010100120070802200708021001001 9001 001146

What I would advise (if all rows in the file have the same structure) is that you pull all the rows of your file into XI using the same structure (eg. Recordset Structure = row, *) and then use a User Defined Function to get the format/information you require.

justin_santhanam
Active Contributor
‎08-11-2007 6:35 PM
0 Kudos

Ramesh,

Try Recordset name = Header

Recordset structure = Body,*

Best regards,

raj.

Show replies
Show replies
Former Member
‎08-11-2007 6:51 PM
0 Kudos

Hi Raj,

I tried the same, but i received an error for last 'lastFieldsOptional' parameter.

What for i need to use this?

regards

Ramesh P

Ask a Question