Explain the XML output please

[Former Member]

Hi Experts,

I have a message type, MT_UPDATE_STATUS, which is outputting based on the following XSD:

Is there a way to find out what the encoded parts translate back to ???

(ex. e32d9236a31b11daa9bed82c0a690329 )

Thanks

SL

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

<xsd:schema targetNamespace="http://tssi.ycdsb.ca" xmlns="http://tssi.ycdsb.ca" xmlns:xsd="http://www.w3.org/2001/XMLSchema">

<xsd:element name="MT_UPDATE_STATUS" type="DT_UPDATE_STATUS" />

<xsd:complexType name="DT_UPDATE_STATUS">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">dc2a4102138f11dc87c400145e7e174e</xsd:appinfo>

</xsd:annotation>

<xsd:sequence>

<xsd:element name="STATEMENTNAME">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">e32d9234a31b11da8ecad82c0a690329</xsd:appinfo>

</xsd:annotation>

<xsd:complexType>

<xsd:sequence>

<xsd:element name="dbTableName">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">e32d9235a31b11daa436d82c0a690329</xsd:appinfo>

</xsd:annotation>

<xsd:complexType>

<xsd:sequence>

<xsd:element name="TABLE" type="xsd:string">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">e32d9236a31b11daa9bed82c0a690329</xsd:appinfo>

</xsd:annotation>

</xsd:element>

<xsd:element name="access">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">2110ebc0cb2011da9af7dcd60a690329</xsd:appinfo>

</xsd:annotation>

<xsd:complexType>

<xsd:sequence>

<xsd:element name="status1" type="xsd:string">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">2110ebc1cb2011da9c03dcd60a690329</xsd:appinfo>

</xsd:annotation>

</xsd:element>

<xsd:element name="status2" type="xsd:string">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">f67c5b10f4af11dab865e2540a690329</xsd:appinfo>

</xsd:annotation>

</xsd:element>

</xsd:sequence>

</xsd:complexType>

</xsd:element>

<xsd:element name="key">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">2110ebc2cb2011daad17dcd60a690329</xsd:appinfo>

</xsd:annotation>

<xsd:complexType>

<xsd:sequence>

<xsd:element name="jobId" type="xsd:string">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">2110ebc3cb2011daae51dcd60a690329</xsd:appinfo>

</xsd:annotation>

</xsd:element>

<xsd:element name="status1" type="xsd:string">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">927a9270d3c711dac48bf9160a690329</xsd:appinfo>

</xsd:annotation>

</xsd:element>

<xsd:element name="messagenm" type="xsd:string">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">6c7b22b0fc8511daaeddf7c80a690329</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">e32d9240a31b11dac242d82c0a690329</xsd:appinfo>

</xsd:annotation>

</xsd:attribute>

</xsd:complexType>

</xsd:element>

</xsd:sequence>

</xsd:complexType>

</xsd:element>

</xsd:sequence>

</xsd:complexType>

</xsd:schema>

[ravi_raman2]

This is the xml generated from the xsd you pasted, i also populated it with sample data...

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

<n1:MT_UPDATE_STATUS xmlns:n1="http://tssi.ycdsb.ca" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://tssi.ycdsb.ca

C:\DOCUME~1\RR\Desktop\sample.xsd">

<STATEMENTNAME>

<dbTableName action="String">

<TABLE>String</TABLE>

<access>

<status1>String</status1>

<status2>String</status2>

</access>

<key>

<jobId>String</jobId>

<status1>String</status1>

<messagenm>String</messagenm>

</key>

</dbTableName>

</STATEMENTNAME>

</n1:MT_UPDATE_STATUS>

Hope that helps...

Dont forget the points if it does..........:-)

[Former Member]

Ravi,

When I test it, I get the following. So, the question is, where is this additional configuration coming from ???

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

<ns0:MT_UPDATE_STATUS xmlns:ns0="http://tssi.ycdsb.ca">

<STATEMENTNAME>

<dbTableName action="UPDATE">

<TABLE>sfx.job_copy</TABLE>

<access>

<status1>DONE</status1>

<status2>DONE</status2>

</access>

<key>

<jobId />

<status1 />

<messagenm />

</key>

</dbTableName>

</STATEMENTNAME>

</ns0:MT_UPDATE_STATUS>

[Former Member]

Hey Shane

i guess this new thread is in continuation of one of ur earlier thread

well,did u check the message mapping for any UDF's?

goto message mapping and it will show if any UDF's are created.

also are u using any adapter specific message attributes?

thanx

ahmad

Message was edited by:

Ahmad

[Former Member]

I'm new to XI Ahmad. Where would I find the UDFs listed? I don't see them anywhere in the message mapping.

Also, where would adapter specific message attributes be defined ??

Thanks

Shane

[Former Member]

Hey

for UDF u need to look in the message mapping editor,if u have any UDF it will show in the pull up menu in the bottom(same menu which has options like arithmetic,string etc.)

for adapter specific attributes,look in ur sender and receiver communication channel.

it has a small check box saying "Use adapter specific message attributes"

can u explain what interfaces ur trying to integrate.do u have IDOC on sender side?

my gut feeling says,ur getting this value either from header or from a UDF:)

thanx

ahmad

[Former Member]

Hi Ahmad,

The only options I have in the message mapping editor are: conversions, boolean, node functions, constants, date, text, statistic, arithmetic. I do not see UDF at all

Also, in the communication channels, I do not have a check box for "Use adapter specific message attributes". Maybe it's because I am on SP9 ??

Still very confused.

[ravi_raman2]

Yes there might be....do you know what algorithm is being used to encrypt the data ?

[justin_santhanam]

Shane,

I think its the same issue we are dealing with, the STATUS & TABLE value, am I right?

Ok, the value e32d9236a31b11daa9bed82c0a690329, you have given is nothing but the object ID for each node you create. There's nothing to do with object ID.

If you have any queries, reply back.

Best regards,

raj.

[Former Member]

Hi Ahmad and Raj,

Does this mean that e32d9236a31b11daa9bed82c0a690329 converts to 'sfx.job_copy' ??

Because the XSD I posted first produces the following XML:

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

<ns0:MT_UPDATE_STATUS xmlns:ns0="http://tssi.tssi.ca">

<STATEMENTNAME>

<dbTableName action="UPDATE">

<TABLE>sfx.job_copy</TABLE>

<access>

<status1>DONE</status1>

<status2>DONE</status2>

</access>

<key>

<jobId />

<status1 />

<messagenm />

</key>

</dbTableName>

</STATEMENTNAME>

</ns0:MT_UPDATE_STATUS>

There is no other place I can think of that the 'sfx.job_copy' comes from.

Also, if I download and edit the XSD in Visual Studio, it encodes it automatically. So, if I download and change the value between the <TABLE> tags, and then re-upload the XSD into my data type, should the value in the <TABLE> tags change ??

[justin_santhanam]

Shane,

I won't think so these objects will return any values. The final hope to your solution is , please send me the source and target XSD's in your message mapping and also in your mapping editor do the following steps and send me across the three files.

In Mapping editor press CTRL+SHIFT -Right Click -Export tools -Export save as .mte file and send me across to sapient.xi@gmail.com

Note: If its possible, send me across. Or we will try to figure it out in the forum.

Best regards,

raj.

[Former Member]

Hi Raj,

I have sent them. Thanks for any help you can offer

Shane

[justin_santhanam]

Shane,

I got your mail, I updated you with my observations, kindly reply back to the mail.

Best regards,

raj.

[Former Member]

I sent you a screenshot from my end. It is different. Hope you can help

[Former Member]

hey

>>Is there a way to find out what the encoded parts translate back to ???

i m not sure what you mean by this:)

u can look under the messges tabs to see all the messages u have in the XSD.

do u want to convert this xsd to XML?

thanx

ahmad

[ravi_raman2]

Ahmad,

I dont think you can convert the xsd to an xml, you can generate an xml from an xsd..since thats what it is..XML Schema Description...and the Xml has values for the items described.

[Former Member]

hey

y can't we convert xsd to XML?

stylus studio has this option under File wizard

thanx

Ahmad

Message was edited by:

Ahmad