Karine Bosch’s Blog

On SharePoint

CAML Designer


Finally! The new CAML Designer is released! I did not do this alone this time, I co-developed the tool with Andy Van Steenbergen, one of my friends at the BIWUG board.

When I developed the first version of the U2U CAML Builder back in 2004, CAML was an exotic language that nobody knew and nobody wanted to learn. In the beginning the tool lived on the blog of my dear friend Patrick Tisseghem, who unfortunately died in september 2008, far too early. Thanks to the tool, which is used all around the world, each SharePoint developer knows how to use CAML.

The user interface is completely designed in WPF. If you install the tool on a server where you have installed SharePoint 2010, you can logon using the SharePoint server object model. But if you have to use the tool remotely, you can connect to SharePoint 2010 using the .NET client object or the SharePoint web services.

For the moment you can only build queries for SharePoint 2010, but once SharePoint vNext is out, we will upgrade the tool. Once you are logged in to SharePoint, you are able to build queries from very simple to very complex. You can also view code snippets in C# for the SharePoint server object model, for the .NET client object model and for the SharePoint web services.

You can download the tool from the download section of the biwug site. You can find detailed documentation on the tool and on CAML here.

Updated: The version downloadable from the site is a click-onnce application, meaning that each time you start the application, it checks online if no newer version exists. If this is inconvenient to you (because f.e. your server is not connected to the internet) and you want to download an off-line version, you can click this link.

The tool is still in beta and I know there are still a few glitches. We are working on it and will post new versions of the tool frequently. But with the click-once way of installing it, you will be asked to update your version of the tool as soon as we release a new version of it. If you find bugs yourself or if you have ideas please do not hesitate to post a message to camlfeedback@biwug.be.

I hope you enjoy this one!

About these ads

May 12, 2012 - Posted by | CAML Designer, SharePoint 2010

49 Comments »

  1. in one Word : Wow!

    Comment by nicodejong (@nicodejong) | May 12, 2012 | Reply

  2. nice looks very good

    Comment by Paul Keijzers | May 14, 2012 | Reply

  3. Nice new CAML Designer!

    Comment by Mark Beij (@markbeij) | May 17, 2012 | Reply

  4. Looking forward to trying this out! Glad you guys made a new version, the old one was getting a little rusty. :)

    Comment by Joe Capka | May 20, 2012 | Reply

  5. Working with it as we speak, very nice work!

    Comment by yuriburger | May 21, 2012 | Reply

  6. Just wow!! First CAML Builder, now CAML Designer!!

    Comment by naimishpandya | May 21, 2012 | Reply

  7. Hi Karine,

    I’ve just tested the tool and it looks nice. Good idea to pre-generate code snippets :) and the WPF UI is user friendly. However, correct me if I’m wrong but I didn’t find any way to perform joins although this is a big addition to CAML in 2010. Did I miss it or didn’t you implement it and if not, any plan to implement it?

    I think that this would be a great addition since this is even more complex for developers to deal with projected fields.

    Thanks
    Best Regards

    Comment by Stephane Eyskens | May 21, 2012 | Reply

  8. Works like a charm! (I was still using the old version :) ) Thanks for sharing!!

    Comment by CarolinePoint | May 22, 2012 | Reply

  9. Any chance you can wrap up an offline installer for this? Kinda difficult to get it installed on a server that has no Internet access.

    Comment by finarne | May 22, 2012 | Reply

  10. Stephane, thanks for your positive feedback, it means a lot to me!
    It is correct that you cannot perform joins, it is foreseen for the next version. We wanted to release the CAML Designer at the same date of the SharePoint Saturday; and because of its complexity, I was not able to add this functionality in time. I keep you posted on this.
    Kind regards,
    Karine

    Comment by Karine Bosch | May 22, 2012 | Reply

    • Hello Karine,

      Thanks for your answer. That’s indeed not an easy functionality to implement but that would clearly be an added value for the tool. Don’t hesitate to give me a shout since I have some ideas on how to implement that :).

      Cheers

      Comment by Stephane Eyskens | May 22, 2012 | Reply

  11. Stephane, thank you for the offer! If it’s ok for you I’ll contact you within a week or two to hear your ideas on this matter. First have to implement a few small changes :)
    Karine

    Comment by Karine Bosch | May 22, 2012 | Reply

  12. A time save for all SharePoint people. Thanks for sharing it to us!

    Comment by Jimbo Alba | May 23, 2012 | Reply

  13. Thanks a lot for this update!

    Comment by Christopher Clement | May 23, 2012 | Reply

  14. Great stuff, thanks! Any plans on building support for logging into SharePoint Online?

    Comment by Jarno Leikas | May 24, 2012 | Reply

  15. We didn’t plan anything like that but if there is a demand for it, we’ll put it on the list of enhancements for one of the next versions.

    Comment by Karine Bosch | May 24, 2012 | Reply

  16. Thank you very much for this great tool and your work behind.

    Comment by Ghisa Ovidiu | May 24, 2012 | Reply

  17. Karine this looks good. I am doing QueryOverride in a custom CQWP plus some client side stuff so this looks invaluable.

    Comment by westerdaled | May 24, 2012 | Reply

  18. [...] Leave a comment Liking or not, CAML is still out there and in several cases we must use it. This CAML designer makes the task of doing CAML less traumatic for people not very familiar with the syntax or to [...]

    Pingback by CAML Designer « myspworld | May 29, 2012 | Reply

  19. Useful info. Lucky me I found your web site unintentionally, and I’m surprised why this coincidence did not happened in advance! I bookmarked it.

    Comment by magic submitter tool | May 30, 2012 | Reply

  20. [...] CAML Designer [...]

    Pingback by SharePoint 2010: Recopilatorio de enlaces interesantes (XXXII)! - Blog del CIIN | June 1, 2012 | Reply

  21. [...] You can download the tool from this site. [...]

    Pingback by The new CAML Designer is released - Choroshin Alex | June 14, 2012 | Reply

  22. Looks great but i was unable to download the offline version.
    it’s onlt download an DLL?
    any Idea?

    Comment by ran | June 26, 2012 | Reply

    • Can you send a mail to camldesigner@biwug.be? We’ll check it out for you.

      Comment by Karine Bosch | June 27, 2012 | Reply

      • ran, Andy uploaded the corrected zip. It should work now.
        Kind regards

        Comment by Karine Bosch | June 27, 2012

  23. Not sure if this is user error or bug, but: if I use an “In” comparitor and pick multiple values, only the first one is added to the CAML query.

    How do I have a set of comparisons that includes “if expired date is null or greater than today”? Is there a way to indicate an “and” with multiple tests?

    Comment by Stan | June 28, 2012 | Reply

  24. [...] http://karinebosch.wordpress.com/2012/05/12/caml-designer/  , CAML Designer makes creating CAML queries a lot easier (successor of U2U CAML Query Builder). [...]

    Pingback by Top 10 SharePoint Tools | Virtualize SharePoint and SharePoint Virtualization | July 4, 2012 | Reply

  25. Thanks for the updates on an excellent tool all SharePoint developers should use. Not sure if I like the new look, but the results are just as good as the old version.

    Usability:
    * If Top Right panel (for entering fields) is reduced below minumim size scroll bars should appear.
    * Option to NOT execute query as you type

    Bug:
    * If you add fields, then remove them in the wrong order (top to bottom) you end up with a field or fields you can’t get rid of.
    * Need. hourglass during query execution.

    Suggestion:
    * Allow excution of CAML which has been modified by typing in the CAML window. (Such as to allow sorting operations)
    * Option to remember Custom Credentials

    Comment by Mike Williams | July 23, 2012 | Reply

    • Hi Mike,

      Thanks for the feedback, we’ll take it into account in next releases. But for your remark on executing the query, you have the option to not execute the query: there is a toggle button “Execute” on the ribbon that you can set to off.
      The design of the left fields panel will somewhat change to enable faster scrolling.
      About your suggestion of executing CAML you modified in the CAML window, this should already be integrated when in CAML mode (see the description of the tool). Are you sure you downloaded the latest version of the tool?
      Kind regards,

      Comment by Karine Bosch | July 24, 2012 | Reply

      • Yes I have downloaded the latest Offline tool.

        When does anyone ever read the manual :-) Didn’t ever need to for the old version.

        I will try it out in CAML mode

        Comment by Mike Williams | July 24, 2012

      • Toggling execute button speeds up things no end.
        CAML mode works allowing quick what if scenarios to be tested :-)

        Comment by Mike Williams | July 27, 2012

  26. Please let me know if it works out for you.

    Comment by Karine Bosch | July 24, 2012 | Reply

  27. Just found another gremlin.

    Copied files to VM and used the Server Object Model connection option to connect to a web app running on port 84. I “explodes” when selecting a list to build a query from. Runs ok if I select to use client object model. Am I missing a dependancy?

    Comment by Mike Williams | July 27, 2012 | Reply

  28. [...] http://karinebosch.wordpress.com/2012/05/12/caml-designer/ , CAML Designer makes creating CAML queries a lot easier (successor of U2U CAML Query Builder). [...]

    Pingback by Escape Business Solutions Blog | October 10, 2012 | Reply

  29. [...] Download it here [...]

    Pingback by CAML Builder / Designer « Victor Maceda’s Technical Blog | October 18, 2012 | Reply

  30. Hi Karine,
    really love that tool. Saved more than just one day. The wishlist for Join-Support has been posted before, I would agree with that.

    A “smaller” wish would be to allow Code posted in the source Window that contains Line Breaks (Enter). It is a bit annoying to first have to remove all new Lines before pasting it.

    Another small wish: When clicking the “Execute” button next to the Caml-Source-Area and no Result will be retrieved, please empty the right results list instead of just keeping the old data.

    Thanks for this great tool

    Ole Albers

    Comment by Ole Albers | October 29, 2012 | Reply

    • Hi Ole,
      Thanks for your feedback! At the moment we are fighting to get a new version ready for the SharePoint Conference @ Las Vegas. but I’ll add your suggestions to the list as they are all valuable points. After Vegas we’ll start working on the SP210 version again.
      Kind regards,
      Karine

      Comment by Karine Bosch | October 31, 2012 | Reply

  31. [...] to write good, old CAML. You can try writing the CAML-queries by hand, but I recommend checking out CAML Designer, SharePoint CAML Query Helper or some other tool to help you write those hairy [...]

    Pingback by Querying for current user’s items using the Content by Query Web Part’s QueryOverride property | Developer at War | December 1, 2012 | Reply

  32. Great tool!!

    Comment by Alex Choroshin | January 14, 2013 | Reply

  33. […] CAML Designer rend plus facile l’écriture de requêtes CAML. C’est le successeur de U2U CAML Query Builder. […]

    Pingback by Guide des meilleures pratiques SharePoint 2010 | Claude Couderc | August 25, 2013 | Reply

  34. Good good !
    Is there a scheduled date for the join add? It woul be so good!

    Comment by Vivien Pipo | November 26, 2013 | Reply

  35. […]    http://karinebosch.wordpress.com/2012/05/12/caml-designer/  , CAML Designer makes creating CAML queries a lot easier (successor of U2U CAML Query Builder). […]

    Pingback by SharePoint 2010 Best Practices | December 2, 2013 | Reply

  36. […] CAML Designer rend plus facile l’écriture de requêtes CAML. C’est le successeur de U2U CAML Query Builder. […]

    Pingback by Guide des meilleures pratiques SharePoint 2010 | | March 5, 2014 | Reply

  37. I am not able to login to my site it always gives me this error :
    Insufficient Data : PLease check the credentials . Although , I login with these all the time .

    Comment by Saud Khan | August 5, 2014 | Reply

    • Hi Saud, which version of SharePoint is your site?
      Karine

      Comment by Karine Bosch | August 6, 2014 | Reply

      • Karine , my site is using sharepoint2010 . I am trying to login using the spadmin credentials and it always gives me the user credentials error .. I understand i have to select sharepoint 2010 and de select all other options . Please let me know where i am goong wrong . Thanks .

        Comment by Saud khan | August 6, 2014

  38. This site was… how do I say it? Relevant!! Finally I have
    found something which helped me. Kudos!

    Comment by online casino | September 5, 2014 | Reply


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 171 other followers

%d bloggers like this: