February 9, 2012  
   Login  
Forum  
 
ForumForumEnesys RS Data ...Enesys RS Data ...Support - RS Da...Support - RS Da...XSD for Data ViewXSD for Data View
Previous Previous
 
Next Next
New Post
 4/6/2007 12:02 AM
 
Has anyone toyed with creating an XSD for the XML required by the RS Data Extension?  We have found that some of the slightest bugs in your XML can give you the generic "object reference not set to instance of an object" and take a while to find.

For example, we use the U2U tool for our CAML and it creates "<Query></Query>" around the CAML.  Well, Enesys wants "<query></query>".  We had valid XML, but no indication of what was wrong.

You can use intellisense within VS2005 (and other tools) for CAML by pointing to the appropriate XSD file.  CAML XSD can be found within the SharePoint hive at ..\12\Template\XML\wss.xsd.

It seems that an extension of this XSD could be created for the RS Data Extension.  Has anyone done this already?

Thanks,
Kirk
www.threewill.com



New Post
 4/6/2007 10:56 AM
 
Hi,
You are right, something could be done in this area.
We are also thinking of developping a gui to build ERSDE query.
Something else we are thinking of is the ability to use SQL Query syntax.
What do you think?
Regards,


Frederic LATOUR
ENESYS
New Post
 4/9/2007 3:19 PM
 
A GUI would certainly be nice, if it can be done in a cost effective manner.  I'm sure it would bring your tool more into the mainstream.

However, it seems that a quick win would certainly be to provide an XSD that makes use of the current CAML XSD in the file I referenced.  It would include your schema for lists, joins, etc. and reference the CAML XSD for everything inside the <Where>.

Regarding a SQL Query syntax, that could be useful, but for those of us that know the that CAML is used under the covers CAML would probably be preferred.  A SQL Query syntax makes sense from an adoption standpoint, but it has to be a limited SQL syntax which could be frustrating/confusing for some.

So, my input would out of these to focus first on XSD (quick win), then on a GUI, then on SQL Query syntax.

Thanks for giving us a forum to provide input.

Kirk
www.threewill.com
New Post
 4/10/2007 3:17 PM
 
 Modified By kliemohn  on 4/10/2007 2:17:45 PM
Here is a little example around using intellisense in VS2005 to test your query (thanks to Bo for a little help with this).  This is far short of having intellisense on the entire Data view, but it is a start.

1. Open a new XML file in VS2005.
2. Put in code like that below.
3. Check the properties pane in VS2005 for your file and verify that the Schemas property is set to C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\TEMPLATE\XML\wss.xsd.
4. Modify the Schemas property if required.  Note that the xmlns value must be exactly as shown below (including the trailing "/").

<?xml version="1.0" encoding="utf-8"?>
<List xmlns="http://schemas.microsoft.com/sharepoint/">
 <MetaData>
  <Views>
   <View>
    <Query>
     <Where>
      
     </Where>
     <OrderBy>
      
     </OrderBy>
    </Query>
   </View>
  </Views>
 </MetaData>
</List>

Once you have done this you can start putting more in the Where clause, etc.

Now, what would be nice is an enesys.xsd that made use of these provided xsds and gave us intellisense for the enesys-specific portion of the XML in the data view.

Kirk
www.threewill.com
New Post
 4/12/2007 9:13 PM
 
Hi,
Thanks for sharing.
We are going to evaluate this option.
In a few days we'll give some informations about the features that will be included in the next version of ERSDE.
Regards,


Frederic LATOUR
ENESYS
Previous Previous
 
Next Next
ForumForumEnesys RS Data ...Enesys RS Data ...Support - RS Da...Support - RS Da...XSD for Data ViewXSD for Data View

 
You need to login for posting to the forums.
If you don't have a login, click here to register.
 
Copyright 2010 Enesys - All rights reserved Terms Of UsePrivacy Statement