camlDesignerLogo

 

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?

Json

 

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…

MainScreen

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? 

MainScreen_Gray

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.

Settings_Display

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

Connections

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. 

Connections_Black

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

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.

Orderby

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

QueryOptions

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…