XSD from XML File

[former_member283645]

Hi Experts,

I have an XML file from mainframes which need to be imported in SAP MDM.

In mdm i have some extra fields which i will map with default values during the creation of import map.

Now, how can i create the XSD for the incoming XML file.

Does anyone one know the step-by-step process to create it?

Is there any automated tool which creates when we upload xml file to it? If so how to use it!!

Can any one help me in this issue!!!

Thanks

Eva

[Former Member · Accepted solution]

Hi Eva,

You can create an XSD from an XML using Altova XMLSpy.

Open the XML, choose menu DTD/Schema-> Generate DTD/Schema. Choose in the Dialog to generate Schema (named W2C Schema). There are some configurations you may define. Press OK, and save the XSD file.

Regards,

Hedda Cohen.

[former_member283645 · Accepted solution]

Thanks Cohen.

[former_member207367]

Hi Eva,

You can use Altova, xom lite for creating XSD from XML File if you have any new fields to be added.

if you dont need to add any new fields to be added, you can use the below link where we can upload the XML file and you can get XSD file in simple steps.

http://www.flame-ware.com/products/xml-2-xsd/

regards

Sowseel

[former_member283645]

Hi sowseel,

Thanks for the response.

So using altova xml spy and xomlite you can create XSD from xml file AND also add new fields to your XSD!!!

Am i right!!!

If so, do you have any steps for creating new fields to your xsd structure???

Kind Regards

Eva

[former_member207367]

Hi Eva,

Yes, you understood it right..

Please check in the link http://manual.altova.com/XMLSpy/spyenterprise/ for altova XML Spy help.

Hope it may help you.

regards

Sowseel.

[former_member283645]

Hi,

when i use http://www.flame-ware.com/products/xml-2-xsd/ .

i can see that <xs> tags are created instead of <xsd> !!!

Is this OK to have like this for an xsd file??

Kind Regards

Eva

[former_member283645]

Hi,

Also, i used xomlite45.

i placed the incoming xml input file in BIN folder, and executed. i am facing the below error.

C:\j2sdk1.4.2_12\bin>java -jar xomLite45.jar rep.xml

XOM 4.5

> Parsing time: 170 ms

Exception in thread "main" java.lang.NullPointerException

at com.sap.mdm.xom.app.Convert.build(Unknown Source)

at com.sap.mdm.xom.app.App.main(Unknown Source)

In cmd i executed the following codes...

***********************

C:\j2sdk1.4.2_12>cd bin

C:\j2sdk1.4.2_12\bin>java -jar xomLite45.jar

XOM 4.5

xomLite - version 4.5

Usage:

For XSD generation:

java -jar xomLite45 InputFile.xml

C:\j2sdk1.4.2_12\bin>java -jar xomLite45.jar rep.xml

XOM 4.5

> Parsing time: 170 ms

Exception in thread "main" java.lang.NullPointerException

at com.sap.mdm.xom.app.Convert.build(Unknown Source)

at com.sap.mdm.xom.app.App.main(Unknown Source)

*****************

Can anyone tell me what am i missing???

Kind Regards

Eva

[Former Member]

Hi Eva

I will follow the following steps-

1. Create an xsd from the xml file using the tools like xomlite, altova etc.

2. Create the new fields in the import map itself. No need to enhance the schema. The newly added fields can be mapped to the defualt MDM values.

Hope this helps-Ravi

[former_member283645]

Hi,

When i use Xomilte i am facing the error mentioned in the above post!!

Can anyone let me know how to fix it??

Moreover i read that xomilte has problems in converting 7.1 XML's to xsd ?? is this true!!!

And can anyon let me know to the steps we use to convert xml to xsd using ALTOVA.

I am unable to understand how to use this tool to convert??

Please help me.

Kind Regards

Eva