cancel
Showing results for 
Search instead for 
Did you mean: 

how to send multiple records in file2file and file2db or all scenarios//

Former Member
0 Kudos

I'm able to send single record for file2file and file2db,

how to send multiple records in file2file and file2db or all scenarios//

what should add or make changes for dis.

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

hi shiva,

to do your scenario for multiple records

1. change your data type as given below

<Root>

<Record > 0 to unbounded

<custid>

<item>

<quantity>

<price>

2. create a message type for this

3. use this message type in your message mapping

now to create the xml for this with multiple records

- go to the <b>Test tab</b> in message mapping

- right click on the field Record and select duplicate subtree option

- now click the button SRC(source document view) which will give you xml with multiple records.

Kind Regards

Francis

former_member182418
Participant
0 Kudos

hi Shiva,

For sending Multiple records in file2file scenerio you have to change the structure of data type in IR.

put Occurance 1 to Unbounded ,which will have a multiple records.

with regards,

Ravi Raika

Former Member
0 Kudos

My question is how to put multiple records at sender side to receive multiple records at receiver end.

I mean how to create xml docment... tags for multiple records.

Former Member
0 Kudos

Hi,

If you wnat to capture multiple records for a perticular structure make it 0 to unbounded.

this pertcular structure can capture multiple records.

you prepare source structure by comparing the source file, and find what structure is repeating under which root.

if you provide sample structure of file we can explain you more detailly than this.

Thanks,

venu

Former Member
0 Kudos

record consists of

custid

item

quantity

price

if I send one record of xml doc, it will be like

<custid> 123</custid>

<item>ipod </item>

<quantity>2</quantity>

<price> 2993</price>

My issue is how to create xml struture for multiple record. I just want structure to test da scenario...

Former Member
0 Kudos

Hi Shiva,

I under stood..

<Record > 0 to unbounded

<custid>

<item>

<quantity>

<price>

If this is the case no issue right..

Thanks,

venu

Former Member
0 Kudos

venu, I did not get u.

gimme xml structure for two records..

Former Member
0 Kudos

1 put Occurance 1 to Unbounded in data type of IR

2 In the test tag of message mappings in IR,select one node and use "duplicate subtree" in its context menu

After that,you can download the test data in XML format with the button "save document source"

for example:

<?xml version="1.0" encoding="UTF-8" ?>

- <ns0:ZFileDemo xmlns:ns0="http://hand-china.com/mm/po_01">

- <Item>

<ItemNo>1</ItemNo>

<Matnr>2</Matnr>

<Text>3</Text>

</Item>

- <Item>

<ItemNo>4</ItemNo>

<Matnr>5</Matnr>

<Text>6</Text>

</Item>

</ns0:ZFileDemo>

Former Member
0 Kudos

ming,

get I have graphical steps or screen shorts for this...

I dont know 'node' and not able to find 'save source document'

I can access subtree only for fields( custid, item, quantity, price).

Former Member
0 Kudos

HI,

You can send the file

in text format

custid item quantity price

1001 , x,10,100

1002 , y, 20,200

.... any number of .. youhave to use the sender structure

Orders

Data 0..unbound as occurrences

custid 0.1

item 0.1

quantity 0.1

price 0.1

And use sender side file adapter with content conversion.

If is XML then you dont need content conversion.

i hope it is clear..

see the below link to get more screen shots..

/people/sravya.talanki2/blog/2006/12/27/aspirant-to-learn-sap-xiyou-won-the-jackpot-if-you-read-this-part-iii

regards

Chilla

<i>reward points if it is helpful..</i>

Former Member
0 Kudos

Change the occurance in target data type to 1..unbounded.

Regards,

Jai Shankar