Skip to Content
0
Former Member
Mar 13, 2009 at 12:30 PM

How to add Namespace

39 Views

Hi all,

I would like to use mutiple occurence for my mapping. My scenario is CSV File to JDBC.

So when I activate that option (set occurence to 0..unbounded) My messages has changed :

<messages>
    <message1>
        <MT_xxxxxxx>
            <col1/>
        </MT_xxxxxx>
    </message1>
</messages>

My payload looks like :

<?xml version="1.0" encoding="utf-8"?>
<ns:Messages xmlns:ns="http://sap.com/xi/XI/SplitAndMerge">
<Message1>
	<MT_xxxxxxxxx>
		<DIVISION_CODE>70</DIVISION_CODE>
		<DESCRIPTION>xxxxxx</DESCRIPTION>
		<COURSE_CODE>xxxxxx</COURSE_CODE>
		<COUR_DESC>xxxxxxx</COUR_DESC>
		<COURSE_REV>0001</COURSE_REV>
		<FREQUENCY>0</FREQUENCY>
		<ISSUE_DAT>01-Dec-2006</ISSUE_DAT>
		<DUE_DAT>01-Dec-2006</DUE_DAT>
		<COURSE_STATUS>A</COURSE_STATUS>
		<SERVER_TIME>11:43:10 AM</SERVER_TIME>
	</MT_xxxxxxxxxx>
</Message1>
</ns:Messages>

When I test it into the Mapping test :

caonnot produce target element /ns0:Messages/ns0:Message1

So my assumption is to reach a message like this :

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

<ns0:Messages xmlns:ns0="http://sap.com/xi/XI/SplitAndMerge">
   <ns0:Message1>
      <ns1:MT_xxxxxxxxxxxxx xmlns:ns1="http://mycompany.com/PI/ABC/xxxxxxx">
         <DIVISION_CODE/>
         <DESCRIPTION/>
         <COURSE_CODE/>
         <COUR_DESC/>
         <COURSE_REV/>
         <FREQUENCY/>
         <ISSUE_DAT/>
         <DUE_DAT/>
         <COURSE_STATUS/>
         <SERVER_TIME/>
      </ns1:MT_xxxxxxxxxxxxx>
   </ns0:Message1>
</ns0:Messages>

So how can I add namesapce into my message ?

Regards

Edited by: Joseph BERTHE on Mar 13, 2009 1:30 PM