Question Re: xml to xsd conversion issues in Technology Q&A

xml to xsd conversion issues

Bhargavakrishna — Fri, 24 Jan 2014 18:44:27 GMT

Hi Experts,

My req is to send the data in Cxml format to the vendor.

Vendor sent me the target structure in xml file, which contains the CXML tags in the file.

To import the structure into pi i converted it into XSD / DTD using Altova xmlspy.

when i open the xsd, it is showing the below issues.

after importing the xsd as a external definition i didn't see any fields under message tab.

Attached the xml and XSD files,please have a look Please help me to resolve the issue.

Regards

Bhargava krishna

Re: xml to xsd conversion issues

asdasd_asdasd — Fri, 24 Jan 2014 18:53:06 GMT

Check this:http://scn.sap.com/thread/1465072

Re: xml to xsd conversion issues

Former Member — Fri, 24 Jan 2014 19:13:32 GMT

Hi Bhargava,

Did you see similar exception when you opened the cXML file in the notepad editor?

Try opening the XSD in other editors like notepad++, notepad, word pad, ms word or even try loading the XSD as ED into PI and check.

Regards,

Pranav

Re: xml to xsd conversion issues

Bhargavakrishna — Fri, 24 Jan 2014 19:41:14 GMT

Hi Ram,

i opened xml file xmlspy, when i test it using validate xml, it is showing the below error.

i imported the converted xsd into PI, it is not showing any fields under message tab.

i checked with the client as well, they said it is the valid xml..

Regards

Bhargava krishna

Re: xml to xsd conversion issues

Former Member — Fri, 24 Jan 2014 20:59:15 GMT

Bharghava,

Use the attached XSD for the xml.

Change the file extension to xsd as its not allowed to attach xsd doc on thread.

Regards,

Pranav

Re: xml to xsd conversion issues

Bhargavakrishna — Sun, 26 Jan 2014 06:02:30 GMT

Hi Ram,

Thanks for the help.

i saved the attached file as xsd and imported as external definition.

It is only showing few fields. PFA screen shot.

Regards

Bhargava krishna

Re: xml to xsd conversion issues

Harish — Sun, 26 Jan 2014 14:38:18 GMT

Hi Bhargava,

Please try the attached XSD.

regards,

Harish

Re: xml to xsd conversion issues

Former Member — Mon, 27 Jan 2014 16:02:48 GMT

Hi Bharghav,

Use the xsd I shared and when you drag and drop the ED to MM, select CXML (instead of Accounting node) as per below screenshot. you can get the required xml.

Regards,

Pranav

Re: xml to xsd conversion issues

Bhargavakrishna — Mon, 27 Jan 2014 17:20:31 GMT

Hi,

Harish and Pranav thanks for the inputs.

I don't have access to the system due to SAP is working on some of the issues.

ill update you as soon as i get the system.

Regards

Bhargava krishna

Re: xml to xsd conversion issues

Bhargavakrishna — Tue, 28 Jan 2014 16:45:29 GMT

Hi Harish,

i imported the XSD which you have sent, it is giving below error

Thanks for your efforts..

Re: xml to xsd conversion issues

Bhargavakrishna — Tue, 28 Jan 2014 16:48:48 GMT

Hi Ram,

i imported the file as you suggested, now it is showing all the fields.

thank you very much for your efforts and time..

Regards

Bhargava krishna