XSD for XML Export File - Some Advice/Help?

HCL Domino Domino Forum
1

Below is a fairly simple piece of XML which is to be used to export data from Notes application to SQL Server.

I have been asked to provide an XSD definition for the XML. I understand that an XSD file basically provides the data types, restrictions etc. but I am not sure how to apply it to such a Notes export?

Most of the fields are fairly simple Text fields, but some are multi-valued such as . How would be defined in the XSD?

Does anyone have any advice on how to create the XSD for this XML, how it is referenced and what it should look like?

Apparently the import code on the SQL Server cannot process the XML without a valid XSD and this is getting a bit beyond my rather basic XML skill-set?

Thanks.

<?xml version="1.0"?>

44AF2A831D2D587E8025731E00575AE8

JP2190

On Hold

24/06/2007

Fred Smith

Mark David

Frederick Jones

94DF2A831D1D587E8025731E00575BF6

JP2190

Closed

21/04/2007

Joe Bloggs

Fred Smith

26AF3A831F2D587E8025731E00575EH4

JP2190

Open

18/07/2007

Joe Bloggs

2

Subject: XSD for XML Export File - Some Advice/Help?

This tutorial should get you started:

http://www.w3schools.com/schema/default.asp

There are also online utilities like that will auto-generate an XSD from XML:

http://www.hitsw.com/xml_utilites/

Frunobulax

3

Subject: RE: XSD for XML Export File - Some Advice/Help?

Excellent! Thanks for that. Since posting this morning I have been through several tutorials and got to grips with it now, but this is very useful to validate my own XSD. Thanks again, much appreciated.