on 10-16-2005 1:09 PM
Hi,
I had configured XI successfullly to send EMPLOYEE data from File(EMPLOYEE.XML) to JDBC. But I can send only the first row not all the rows from XML to JDBC. Is there any way to configure to send all teh rows from XML to JDBC.
regards
Anand.M
Hi,
Here is the JDBC XML
<?xml version="1.0" encoding="UTF-8"?>
<xsd:schema targetNamespace="http://xidemo.com/datareceiver" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="http://xidemo.com/datareceiver">
<xsd:element name="MT_DB_RECEIVER" type="DT_DB_VENDOR" />
<xsd:complexType name="DT_DB_VENDOR">
<xsd:annotation>
<xsd:appinfo source="http://sap.com/xi/TextID">d49556703e5511daa7dc00300530002e</xsd:appinfo>
</xsd:annotation>
<xsd:sequence>
<xsd:element name="STATEMENT">
<xsd:annotation>
<xsd:appinfo source="http://sap.com/xi/TextID">b57372e03e3211dabde4ebc60a15ca63</xsd:appinfo>
</xsd:annotation>
<xsd:complexType>
<xsd:sequence>
<xsd:element name="EMPLOYEE">
<xsd:annotation>
<xsd:appinfo source="http://sap.com/xi/TextID">b57372e13e3211da8e06ebc60a15ca63</xsd:appinfo>
</xsd:annotation>
<xsd:complexType>
<xsd:sequence>
<xsd:element name="access">
<xsd:annotation>
<xsd:appinfo source="http://sap.com/xi/TextID">d17518903e3211dac44febc60a15ca63</xsd:appinfo>
</xsd:annotation>
<xsd:complexType>
<xsd:sequence>
<xsd:element name="EMPID" type="xsd:string">
<xsd:annotation>
<xsd:appinfo source="http://sap.com/xi/TextID">d17518913e3211da804debc60a15ca63</xsd:appinfo>
</xsd:annotation>
</xsd:element>
<xsd:element name="NAME" type="xsd:string">
<xsd:annotation>
<xsd:appinfo source="http://sap.com/xi/TextID">d17518923e3211daca94ebc60a15ca63</xsd:appinfo>
<xsd:documentation xml:lang="EN">E</xsd:documentation>
</xsd:annotation>
</xsd:element>
<xsd:element name="AGE" type="xsd:integer">
<xsd:annotation>
<xsd:appinfo source="http://sap.com/xi/TextID">d17518933e3211dab732ebc60a15ca63</xsd:appinfo>
</xsd:annotation>
</xsd:element>
</xsd:sequence>
</xsd:complexType>
</xsd:element>
</xsd:sequence>
<xsd:attribute name="action" type="xsd:string">
<xsd:annotation>
<xsd:appinfo source="http://sap.com/xi/TextID">b57372e23e3211da94dcebc60a15ca63</xsd:appinfo>
</xsd:annotation>
</xsd:attribute>
</xsd:complexType>
</xsd:element>
</xsd:sequence>
</xsd:complexType>
</xsd:element>
</xsd:sequence>
</xsd:complexType>
</xsd:schema>
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
After checking this, it looks like you are not using 0:unbounded occurance for access element. After changing that go to your message map and map the source <b>row</b> field to <b>access</b> field.
YOU DID NOT POST THE TARGET XML, go to SXMB_MONI there you can find the target payload.
Check the above mentioned link.
http://help.sap.com/saphelp_erp2004/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm
regards
Shravan
Hi
here is my XML
<?xml version="1.0" encoding="UTF-8"?>
<ns:MT_FILE_SENDER xmlns:ns="http://xidemo.com/datasender">
<row>
<EMPID>20016</EMPID>
<NAME>PRASAD</NAME>
<AGE>39</AGE>
</row>
<row>
<EMPID>20017</EMPID>
<NAME>RAMESH</NAME>
<AGE>39</AGE>
</row>
</ns:MT_FILE_SENDER>
regards
Anand.M
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I think you did not use occurance 0:unbounded for access element.
Check the following link for correct document format.
http://help.sap.com/saphelp_erp2004/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm
regards
Shravan
Hi,
I used the access element. The first row it is copying not the second one
regards
Anand.M
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Ananda,
plz use one access element for every row.
Regards,
Udo
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
95 | |
11 | |
11 | |
10 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.