Hey guys

It’s been a loooong while since I’ve written about the tool that I’ve developed with Karine Bosch (@kboske) (and Peter was a great help with the Office 365 part) called Caml Designer.

Well since the vNext version that we have launched with the SharePoint Saturday 2012 the responses have been awesome 🙂 but also some bugs came up.

Thanks to all the people who sent a mail to camlfeedback@biwug.be we were able to track the bugs and fix them accordingly.

Continue reading


Hey all


Just a quick post before I’m off to set up all the rooms and bags before the main event tomorrow (SharePoint Saturday 2013 Belgium).

Karine and me were a little bit too busy with our main jobs to continue working on the Caml Designer during this iteration, so Peter Karpinski asked if he could help out.. And help out he did.

Some list with updates that we did on this iteration:

  • Improved support for Office 365
  • Bug fixes
  • CamlDesigner 2013 can now also be used to connect to SharePoint 2010.. so delete the CamlDesigner 2010
  • Changed the connection screen a little bit, you can now select to what version of SharePoint you are connecting to


Of course when selecting SP2010 you can only use Client OM and web services… Server OM connection wasn’t possible.. but functionality why you will not see a difference.

Hope you like it  and maybe see you tomorrow at #SPSBE



Hey everyone

So yesterday was a long and very exciting day for me and karine bosch. After working long days to get the Caml Designer ready for use, we made it for the BIWUG event.

There are still some minor bugs, but for normal use the tool is more than solid enough.

So what’s new?

  • Design is completely revamped
  • Speed of the tool, some stuff is happening async now
  • extra code snippets
  • settings fly out, you can delete your history, change colors of the screen
  • Multilingual.. at least the beginning of it.. Smile 

this will be improved (English and Dutch languages at the moment), but a mechanism will be put in place that you get the English resource file, translate it to your native language and send it to us, than we will implement the extra resource so that everyone enjoys the update.

By default the language is selected via the system region.

  • Connections window is completely changed now, history is being put in tiles, at the moment the tiles are being loaded when the tool starts and no resync will be done if you enter a different site

Custom credentials are NOT being encrypted, we will look into the possibility of this but at the moment this isn’t a priority

You can download the tool from here .

If you do find something, send us an e-mail and we’ll fix it and put it in an update.


That’s all, enjoy –> use –> blog and tweet about it Smile

Have a nice weekend



Caml Designer 2013 is now live and you can download it here.

hey everyone

As of yesterday we are in the final part of the development phase of the CamlDesigner v2013.

All of our beta testers have received the link to download the next version and are now putting it through rigorous testing.

Also a new page has been opened up to the public on the BIWUG site. If you go to the site and click on the “downloads” section in the navigation and than “Download here” in the Caml Designer part, you’ll see that we’ve also made the package available for “off-line” use as well.

This link was available upon request but we never made it public because of the one slight drawback, if we would release an update than the “offline” package would not update it self. In the click-once application this would be done automatically.

So now you can download in offline mode but keep in mind that you are responsible to update package once in a while.

We will provide with a version number in the program itself so that you can check against the number that will be provided on the webpage.

Yes there is a countdown as well on this page at the moment. Check it to see when we are planning to release the new tool Smile

That’s it for now. Have a nice week.


So it was quite these pas few weeks around the Caml Designer. But we are still alive and kicking and working hard on the new version.. Yes there will be a new version and it will contain a lot of new stuff, like a complete overhaul of the user interface, additional alerting system, telling the user what the program is doing. We even added multi lingual, although at the moment we only have Dutch and English. If you want your language in it as well, send us a translated list of the words (list of words will be provided in the program) and we’ll make sure it’s added in the next update.

In the back-end a lot has changed as well, we’ve now included JSON script. Isn’t that cool Smile???

You want an example of the new design + json code?



So when will be the release date?

Well soon, after our beta-testers have given their go and no severe errors have been found.

A link will be added in the Caml Designer 2010 to the page where you can download it, twitter will also be used, so make sure you are following us on @CamlDesigner .

Do you want to enter our beta-tester program than send us an e-mail with subject “beta tester” and we’ll add you to the list.

Any additional comments / questions than comment this blogpost or send me an e-mail.

Caml Designer 2010 and 2013 are now availble for download here

Once upon a time not too long ago Caml Designer v1 was released. It was at the SharePoint Saturday conference here in Belgium.

Since then the Caml Designer has been downloaded over 3000 times Glimlach not counting the numerous updates that we already did.

In the last update we’ve extended the Caml Designer with the possibility to create “Site Data Queries”.

Now for SharePoint 2013 we had a small problem: SharePoint 2010 uses framework .NET 3.5 and SharePoint 2013 uses framework .NET 4.0. So the assemblies of SharePoint are the issue. We couldn’t work out to support both versions of SharePoint in one application.

The reasons are that the assemblies are build in the different .NET frameworks and you cannot use .NET 4.0 in a .NET 3.5 assembly. A post that supports my findings (it’s in CRM but the error stays the same) you can find here.

I couldn’t even get assembly binding redirection to work.

So the decision was made to create a “new” Caml Designer for SharePoint 2013.

First of all the look and feel is somewhat different…

Keep in mind that we are still in the design phase.. so things are still going to change…

So the main screen will be something like…


As you can see the ribbon is GONE… This was one most crucial parts, the ribbon was making things more complex so one of the main requirements of the new design was having things much more easier. So tabs are now introduced instead.

Do you want the Designer in a new color? 


It’s all possible via the settings slide out…, design of this may still be changed but the color schema gives it a nice touch.


And last but not least, the login screen has changed somewhat as well..


This is still in design phase but at the right side you’ll have your recent sites in tiles and the selection via which method you want to create your connection. 


That’s all for now… hope you’ll like the design and let me know what you think of it…







Yesterday Karine blogged about the Caml Designer that we co-developed, you can find it here .

Some more bugs have been fixed, but I don’t think that we’ve found all of them, so to help us out you can always e-mail us  at camlfeedback@biwug.be , also if you have additional idea’s be sure to let us know.




Karine also did a wonderful job on explaining the Caml Designer step by step at this location. Be sure to read it, who knows maybe there is a hidden gem in the CD? Glimlach




While I was doing research about all the new features I came across some interesting articles.

For example: who knows about the new query parameters “In”, “includes” and “notincludes” in the SP2010 caml?

You can read more about the parameters here .

Most of you know that there are 2 nodes (“joins” and “projectedfields”) extra in the new CAML version. But it’s not easy to write caml against them. Therefore MS has created linq to SharePoint so that we don’t have to write all the difficult stuff. In fact, linq does a translation to CAML behind the scenes.

We will try to implement this also in the caml designer but one of the hard parts is to correctly visualize it.

Most likely “joins” and “projectedfields” will not be implemented in the first release, but it will definatly be added in future releases..

In the meanwhile here are 2 very good articles about explanation of each node.

MSDN – Joins and projectedFields

Blog – Maran

Also I’ve found a CAML intellisense “program”…


Hope it helps someone…

Hey everyone

As some of you know by now, I’m working together with Karine Bosch on a new CAML “Builder” tool, but the name doesn’t do it justice.

Because with CAML you can do a whole lot more than just writing queries. You can also build entire site definitions, site columns, content types… and so on.

Well the new name that we gave the program is “CAML Designer”, it pretty much sums it up all the things that you can do with it. And also because of trademarking infractions we had to search for a new and “better” name J .

Let me first start to give my thanks to Karine for all the hard work that she already put into the program, it’s been a long year but with regular meetings and matching our agenda’s we will get there in the end and it has been an honor to be working with the CAML girl.

Ok, “demo aka print screen time J “ but please note that this is still alpha phase and changes can and will be made to the design or labels will be filled in with more correct information.

Let us first start with the main screen

No more questions for logging in first, this was an easy decision because it is not always necessary to logon to the SharePoint site and work with CAML, since it is a designer you can do Offline work as well. So this means that you can start up the program without that you have to login.

full screen

As you can see there is a Ribbon, this was an essential part because we wanted a new design in accordance with the current Office applications. It also makes it easy for us to put all the controls that you need on top of the page.

At the moment only a “CAML Query” tab is available, the “Site column designer” and the “Content Type designer” isn’t available.

So if the “CAML query” is pressed than a check will be done to see if connection info is available, if it is not, than a login screen will pop up to ask you some questions. Of course you can press the login button on the ribbon. Going to the SharePoint site is needed because the query designer will be most used in “online” mode.

Login Screen

Current user

First question of course, the site URL, next up via which method that you want to connect to the SharePoint site (Server object model, Client object model (which is new in SP 2010, not in 2007) and last but not least, via the Web services.

Next is the choice of to what type of SharePoint that you want to connect, 2007 or 2010.

And a last step is the security part, you can give credentials if your current user doesn’t have access to the site or you can choose “current user” credentials (which is a default setting).

If you press “ok” a check will be done to see if the site URL that you have entered in the credentials is valid or not. Otherwise a warning will be given.

But note that the login screen will be redesigned.

fill in info animation

If you press the “CAML query” tab and no login information is given than an animation is given at the top to highlight the waiting part while the login screen is being displayed.

If the login information is valid, than the same animation will display “Retrieving SharePoint information” on top of the page, after all the data is retrieved than the animation will disappear.

retrieving info animation

Next step is the tree view that will be loaded during the above animation. Let’s select the task list for example and by default “CAML” and “C#” buttons are selected.

Select fields

If we select view fields a list of fields will be given, just click the name and the field will be put into the second container on the right hand side.

Also when selecting the fields, the CAML query is being built dynamically on the bottom of the window.

Query fields

Next up is when we select the “Where” button to go ahead and select some fields where we want to do a query selection on. As you can see, the fields that are selected each give a different filter window. For example “Modified” gives us 2 choices: “Today” or a “specific date”.

In Today you can also add an offset of +/- and how many days.

In specific date you’ll get a calendar view to select the date with the option to include time values.

As you can see on the print screen as well, if you have an “And” or an “Or” in between the filters, you can change them just by simple clicking area button.

These operators are automatically included when selecting more than 1 field.

For the operators: equal, larger than, smaller than … , simple right click the circle of the operator and a right click menu item will appear to give your choice.

Next up is the “Order by” and the “Query Options” selection.

As you can see the “Order by” is also a select field kind of action and by clicking the A-Z or Z-A image it’s being changed accordingly.


When you select the “Query options” than a short selection will be shown on the right hand side of the screen.


When selecting these options additional code will be generated in the Code Snippets part to add these selections to the query. And this leads us to the next part, “Code Snippets”.


If you check out the ribbon you can see “Server OM”, “Client OM for .NET” and “Web Services” in the code snippet section. If you select for example the “Server OM” than the CAML query will be translated to a snippet that you can copy/paste.
For the moment only C#.Net code is being used, but in the future we are looking to also set it to VB.NET. If you want to execute the code than you can do this via the button in the ribbon “Execute” and in the result will be shown in the section besides the Caml query.

result screen

This can also be done for “Client OM for .NET”…

Client OM

And for “Web services”…

web services

Well that’s it for the moment, a release date is set for April of sorts, but it could be that a beta version will be released before that. We will keep you posted though , through twitter #CamlDesigner 🙂 or Biwug site or this blog or karine her blog

Leave a line if you have suggestions or comments…