Domino View XSD Schema required

HCL Domino Domino Forum
1

I am trying to use Crystal Reports to connect to a Domino view and get the data as XML.

I am using the url …/db.nsf/viewname?ReadViewEntries to connect to the database and this seems to work Ok but Crystal is requesting a xsd schema. As I could not find any exampled of how to do this I have had a go at creating one for the view which has 5 columns (see below) but this does not work.

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

<xsd:schema xmlns:xsd=“http://www.w3.org/2001/XMLSchema”>

<xsd:element name=“viewentries”>

  <xsd:element name="viewentry">

     <xsd:complexType>

         <xsd:element name="QuNoPrefix" type="xsd:string"/>

         <xsd:element name="QuNo" type="xsd:string"/>

         <xsd:element name="QuInvestigationType" type="xsd:string"/>

         <xsd:element name="QuDate" type="xsd:date"/>

         <xsd:element name="QuStatus" type="xsd:string"/>

     </xsd:complexType>

  </xsd:element>

</xsd:element>

</xsd:schema>

Does anyone have any ideas how this schema should be written?

Regards

Mike

2

Subject: Domino View XSD Schema required

There should be a /lotus/notes/xmlschemas folder with all of the xsd and dtd files on your local machine.