Result is out

The result is out and here is what we have got.

How to get group by HTML in SharePoint Listview

From quite some time, we are using Jquery and JavaScript to tweak the SharePoint data rendering methods below are the few examples

Sharepoint Custom so called KPI

Highlight SharePoint List rows conditionally

SharePoint calculated column and jQuery Highlight row

and the recent one Delete button in list view

Now almost every time our main concept is let SharePoint work their way and we will work our way without changing its basics.

So for that many a times we change the rendered HTML by SharePoint to meet client expectation.

But sometime we have loose against SharePoint but not now, we find the way to get HTML of the Grouped by data.

Let us explain quickly…
In listview web part if we use group by then SharePoint make Ajax call and on click of + it get’s the data to render. In normal (without group by view) its working normally but in group by view we are not getting HTML in view source.

As a result our above post fails to change HTML as desired.

But now way is there… for How to get group by HTML in SharePoint Listview
We got noticed when one of our readers point us to a wonder full article by Alexander Bautz

so first of all thanks to Alexander Bautz for his efforts

Now lets’ go to the code without wasting time.

Take jquery reference

<script type="text/javascript">
$(document).ready(function(){
ChangeHTML();
});

function ChangeHTML()
{
//the code goes to change the HTML
//you get reference code by above links

}

function ExpGroupRenderData(htmlToRender, groupName, isLoaded) {

if(isLoaded == 'false')
{
setTimeout(ExpGroupRenderData,1000);
}
else
{
ChangeHTML();
}

}
</script>

Now lets us explain you how it works

The key thing to understand is the SharePoint function ExpGroupRenderData
While clicking on the + sign for group by SharePoint call web service from JavaScript to get the data and this function renders data after everything.

Now another problem is this function is called asynchronously. So when you check htmlToRender variable you will not get full data till the time isLoded is true
And when we tried in SharePoint 2010 it always show false so we had use set time out function which will called after each second.

Once isLoded is true then bingo we will get all the HTML and make our changes.
So sorry guys for not getting with full sample example because of time crunch but all the SP lover will get the idea what is happening and how much it’s useful. We will soon try to get working example for you.

Feel free to ask queries, we will happy to help (if possible).

Include image in SharePoint survey

How about coming up with some questions which have some images in it? And someone ask you is this possible in SharePoint survey. Well, you say I need some time to think. And yes, because out of the box, there is no option to include images in the survey which I sometime believes lack of functionality.

I also strongly believe that there are lots of third party solutions that can be deployed in SharePoint for customized survey which SharePoint survey does not provide, but I believe survey needs a lot of improvement. There has to be an expiration date, there should be a way to include images in the questions; just name a few. SharePoint 2010 has also not improved as far as survey is concern.

However we can do some little magic around survey page with the content editor web part and some magic in writing a question and then jumbling with JavaScript will get us the image in the question.

So let’s deep dive into this and explore how we can include image in the SharePoint survey.

Let’s ask one question. Question should be Do you think this picture is real?

And what we want is after this question we want to show one image down below this question. So that people come to know that we are talking about this image.

To do this, we need to make some modification to the question.

Add question something like this



Notice one jjjj at the end of the question. This is unneccesary word in the question. But this is very necessary word for us. Because we will change this jjjj word with image with the help of content editor web part.

Upload your images that you want to display in question in some image library because we need to take reference to that library.

Now add content editor web part below survey.

And write down following script

<script language="JavaScript">

var className;
className = 'ms-formlabel';

var elements = new Array();
var elements = document.getElementsByTagName('td');
for (var e = 0; e < elements.length; e++)
{
if (elements[e].className == className)
{
elements[e].innerHTML = elements[e].innerHTML.replace('jjjjj','<img src="{image path}"></img>');

}

}

</script>

If you observe, what we have done is we loop through all TD inside class ms-formlabel. And then we find ffff and then we replace it with image path. Check out the view source to get more idea. And of course you can reach us for any query.

And here is the output.



See, it’s fun. Isn’t it? We can now include images in the questions.

Okay, so what next? We will go one step further. Let’s add image as an option. Now this is a real fun. And you will find almost no examples for this. I tried finding and end up with no option. So I tried venturing and solving this.

It’s all about looping through classes with the page from javascript using content editor web part. We need to locate the place where we can replace certain string with the image tag.

So let’s start this example by asking question that which is your favorite flower? And we want user to select one of the options. So our answer should be of type choice.



And this will be the page for the survey



What we are we going to do is that we will loop through the class. Now carefully observe the JavaScript been generated by the browser.



We are interested with this area of JavaScript. We first need to get a reference of class ms-formbodysurvey, then we will take every td tag inside it and then from that we will find every label inside that and then inside that we will replace those flower names with image path.

And here is a way to do it. Have a content editor web part on the survey page.



And write down the following script.

<script language="JavaScript">

var className;
className = 'ms-formbodysurvey';

var elements = new Array();
var elements = document.getElementsByTagName('td');


for (var e = 0; e < elements.length; e++)
{

if (elements[e].className == className)
{

var inputs = elements[e].getElementsByTagName('label');

for (var e1 = 0; e1 < inputs.length; e1++)
{


inputs[e1].innerHTML = inputs[e1].innerHTML.replace('Lotus','<b><font size="4">Lotus</font></b><br/><img src="{img path}"></img><br/><br/><br/>');


inputs[e1].innerHTML = inputs[e1].innerHTML.replace('Jasmine','<b><font size="4">Jasmine</font></b><br/><img src="{img path}"></img><br/><br/><br/>');

inputs[e1].innerHTML = inputs[e1].innerHTML.replace('Rose','<b><font size="4">Rose</font></b><br/><img src="{img path}"></img>');

}

}

}

</script>

And you should be good to go. Bingo we have done our job. Following is the output. Happy imagine.

Ribbon customization - Part 1

From this post, I am going to start on the series of customizing ribbon. And for this, we will start with understanding the ribbon architecture and the basics of ribbon.

We all know CustomActions feature element which helps us putting different functionalities at various places in SharePoint. We can use this to enable different options on different menu places.

Same CustomActions is used to enable customize the ribbon through the features. In ribbon architecture, first comes the Ribbon, then comes the Tab, then comes the Group and then comes the controls within the group.

Individual controls inside the group can be disabled or enabled. They cannot be hidden or shown.

But yes, individual Tab can be hidden and shown. If you like to see this, then go to document library, then go to documents tab without selecting any document. You would see all options disabled not hidden. Once you select any document, then they become enable.



These are called context sensitive controls and tabs. We will cover each one of these in details as we progress through the series.

There are built in controls that you can use inside group. You cannot use custom controls inside it. List of controls permitted inside group are button, Checkbox, Color Picker, Combo Box, Dropdown, Textbox, Toggle Button, split button, spinner, fly out anchor.

It is the java scripts which is performed on the client side when any of the controls is being clicked or actions performed on any of the controls inside it. So we will also investigate more in JavaScript as well in coming series.

Below is an example of ribbon. (Covered with green rectangle)



Below is an example of Tabs. (Covered with green rectangle)



Below is an example of Groups (Covered with green rectangle)



And inside Groups we have the respective controls.

Continue reading Part2

Word automation services – Part 2

Here we are with part 2 of word automation service. If you have not gone through the Part 1, then I would recommend you reading part 1 first and then return to this post for further reading.

We now know about the fantastic feature called word automation service. Now it’s not just that you can do it with the help of code.

If you are a server administrator, then again PowerShell is here to help you out with this. PowerShell is undoubtedly one of the best enhancements that have come with SharePoint 2010 which gives more power than traditional stsadm command for sure.


So open up the Start menu - >Administrative Toos -> Windows PowerShell Module.

We are using the same library that we have used in Part 1.

Now start writing following commands one after the other and see the magic. Again remember you need to wait for some time depends on the source file format and destination file format to get the output.

PowerShell also provides you way to check the status of the process the same way we checked with the code in part 1.

First we need to take the proxy reference of the word automation service. But yes, make sure that word automation service should be running.





Now we will take the reference of the site



Now we need to set the input and output folder. It means source library path and destination library path. I am going to have it both at the same place.



Now we will take the reference of conversion job we created in first step, set up the user token under which the job will run, output format and should we override the file if already there or not.



Now then once we configure all these, it’s time to start the job to convert.

So your overall code would look something like this



At the same time, we can query the conversion status as well.




As you can see it shows the status, you can keep checking the status. After process started, it will be number of documents in progress and at the end if you query, it will be number of documents completed.

Default time is 15 minutes. You need to wait till 15 minutes, but if you do not want to wait till 15 minute then you can force job to run.



and Here is the output. If you have multiple files, it will automatically take all files and convert them to PDF.

Delete Drop off library Part – 3

Here we are with part 3. If you have not gone through part 1 and Part 2, I would recommend you reading part 1 and Part 2 then come back here for further reading.

Here is one more way to allow drop off library to be deleted. In this post, we are going to see how we can achieve this with the help of SharePoint Manager 2010 which is a free download available from CodePlex. The same functionality is also available for MOSS 2007. Check out here.

Open up SharePoint manager 2010.

When you first open up the SharePoint manager, you would see something like this.



Expand your site web application, site collection and then your web node. You would be able to see all lists and libraries inside the web along with all properties. This tool is simply awesome. It not only allows you to view all properties but also allows you to modify and save the changes as well.



When you select drop off library, you will see AllowDeletion property in propoertypane, select it to true. Save the changes and you should be good to go.

Read only view problem

I noticed when i wanted to bulk update value of one field and when i went ahead, changed the normal standard view to the data sheet view to modify values i could not modify values. it showed me that this view is read only.



now what does this mean that the view is read only? Well, after some search i came to know that if the list has a content approval turned on, you will not be able to modify the values in datasheet view. the view turns into read only mode.

So go to the list settings -> General settings->Versioning settings and turn off the content approval. come back to the list, make changes the way you want and then again turn on the list content approval.

Hope this helps.

Delete button in list view

Hi, we all know that list view is the best way to show the data to use without wasting of time.

It gives all the basic required functionality but as always client ask few simple things which SharePoint is not providing by default.

And for that silly thing we have to create custom webpart or custom listview

We already shown you few ways to show how you can change your listview HTML by JQuery and JavaScript like
http://www.sharepointkings.com/2010/04/sharepoint-custom-so-called-kpi.html
http://www.sharepointkings.com/2008/12/highlight-sharepoint-list-rows.html
http://www.sharepointkings.com/2009/04/sharepoint-calculated-column-and-jquery.html
All jquery stuff http://www.sharepointkings.com/search/label/JQuery

Recently we got requirement that client needs delete button link in SharePoint list view
Now edit button is available but delete button is not available in default view.

So finally we are went the same way as we always used: change the Listview HTML in JavaScript

We created a text field “Delete” and put some below text inside that field

<div><a href='#' onclick='javascript:DeleteItem(2);'><img alt='delete' src='/_layouts/images/delitem.gif' style='border:0px;' /></a></div>
where 2 will be listitem ID

Note: calculated column is not supporting ID. So we can use event handler or SPDesigner workflow to fill this field.

Now what we had done is on DeleteItem function we called web service from JavaScript using SPServices jQuery and delete the item and then just reload the thepage.

That’s it
Here is the function which called on page load to change text field to div field.

we have to put this JavaScript on the same page of list view.

$(document).ready(function(){
$(".ms-vb2:contains('<div')").each(function(){
var tempDIV = document.createElement ("div");
tempDIV.style.cursor = "pointer";
tempDIV.innerHTML = $(this).text();
$(this).text("");
$(this).append(tempDIV);

});
});

function DeleteItem(cID)
{try{
var cnf = confirm("Are you sure you want to send the item(s) to the site Recycle Bin?");
//this is default message that sharepoint gives.
if(cnf)
{
$().SPServices({
operation: 'UpdateListItems',
listName: ‘your list name’,
batchCmd: 'Delete',
ID: cID,
completefunc: function (xData, Status) {
location.reload(true)
}
});
}


}catch(ex){alert(ex);} }</script>

Hope fully you will get the idea how its working.

Delete Drop off library Part – 2

Here we are with part 2. If you have not gone through part 1, I would recommend you reading part 1 and then come back here for further reading.

As we know that by default there is no option to delete a drop off library and we saw in part 1 one way to enable the delete this library settings under permissions and management.

With the help of PowerShell script we can achieve this as well.

All you need to do is go to administrative tool -> PowerShell modules and type in following commands.

$objWeb = Get-SPWeb –Identit http://ServerName
$objDocLib = $objWeb.GetList("http://ServerName/sites/sitename/DropOffLibrary");
$objDocLib.AllowDeletion = "True";
$objDocLib.Update();

And you are good to go. You will be able to see delete this library option under permissions and management.

Read Part3 for further reading

Delete Drop off library Part – 1

Drop off library which is a part of content organizer in SharePoint 2010 is one of the cool new features been added to SharePoint 2010.

If you want to know more about drop off library, you can read it here.

Now the interesting this is, if you go to drop off library settings, you will not see the delete option by default.

This is the default settings, may be because drop off library is an important feature and there can be multiple rules might have been set on it.

However, if we want to remove this library then there are three ways. I am going to convert them in one by one part. In this part, we are going to see how we can enable deleting library from server object model.

First let’s have a look at the screen shot of drop off library settings.



Now write below code wherever appropriate.



And here is the result



Read more in Part 2.

Word automation services – Part 1

Common requirement is to convert doc to PDF and for that we often go for the third party software, do the conversion online, in development go for the third party DLL and then call method to do this job.

We now also have an option to convert word document in PDF in office 2010.

Well, now with SharePoint designer 2010 or word automation services, it is possible to convert word document to the PDF file and that too without any watermark.

Word automation service is only available in SharePoint server 2010 not in foundation server.

Word automation service can convert document to one format to another format. You can also do this programmatically as well.


It can read following file formats.
• Word 97-2003 Document (DOC) and Word 97-2003 Template (DOT)
• Rich Text Format (RTF)
• Single File Web Page (MHTML)
• HTML
• Word 2003 XML
• Word 2007/2010 XML

And it can write following file formats.

• PDF
• XPS
• Office Open XML (DOCX, DOCM)
• Word 97-2003 Document (DOC)
• Rich Text Format (RTF)
• Single File Web Page (MHTML)
• Word 2007/2010 XML

So definitely this is a great move from MS and it was highly needed.

Before starting on this, we need to make sure that word automation service is started on the server.

Go to your central administration – Application management – Services on server and see that it is started, if not, then start it.



In this post, I am going to show you how to convert a document to different formats from word and from other formats.

This time we will start with the code. Yes, directly we jump in to the code because it is really easy to convert a document from code for the developers. Just to show you how it works, I am using documents in the same library and outputting the resulting converted documents to the same library.

Output library can also be different from the site. I yet have to check if it works for the site collection or not. But for the site, it definitely works.

You need to include one DLL reference in your project and that is Microsoft.Office.Word.Server.Conversions.ConversionJob.



Once you execute this code, you might have to wait for couple of minutes or more. It depends on the type of file you are converting. Check out different options in conversions.SaveFormat. There are different formats available.

Output from the same above code tried with different formats is shown below.



First is .docx, converted to .doc, .pdf and .xps.

Now one more thing to add here. When you have job object in your hand then you can query its conversion status. As I said earlier, for some file format conversions it might take few minutes.

ConversionJobStatus status = new ConversionJobStatus("Word Automation Services", job.jobId, null);
if (status.Count == status.Succeeded)
{
// converted

}
else if (status.Count == status.Failed)
{
//Not converted. It has failed

}

Read Part 2 for further reading.

Understanding document set - Part 2

Let’s continue exploring document set. If you have not gone through part 1, I would recommend you go through it before proceeding. Part 1 will give you understanding on what the document set is all about and what are the advantages in that.

Go to site collection features and activate the document set feature.



Once you activate the document set feature, you would be able to apply it on the content type of document library.

Go to the document library where you want this document set. Go to library settings -> Advanced settings->



Go to list settings page and click on add from existing site content types.

Select document set content type and select document set.



Once you have added document set, and then go to document library and then click on New to create document set. Give name and the description of the document set.



This will create a document set in the library.



Click on the Project Document will take you to the detailed page of the document set.



You can also see that document set specific actions comes alive as a context sensitive ribbon controls.



Document set it has its own properties. You can add columns to it same way we add columns to the normal list or libraries. These will serve as a Meta data for the document set.



Let’s add couple of documents in it, couple of excels files and a presentation in it.



This is it for this part. Keep reading Document Set Part-3 for further reading..

Common list operations in SharePoint 2010

In this post, we are going to see how to implement some of the cool new features in SharePoint 2010 for the list through programming.

1) How to add validation for the field in the list



2) How to add list validation



3) How to add referential integrity (cascading delete or cascading restrict) to the relationhip list

Result is out

Result of last polling is out and it looks like people has given thumbs up to Google Android followed by Microsoft Windows Phone 7 and surprisingly followed by iOs.

Enforce unique constraint from code

We have seen in previous posts that it is very easy to set field with the unique constrain from list settings. We are going to see the same using code that how to do that

Below is a sample code to achieve that. We must remember that before a field can be set to unique constraint, we have to index that field and hence we have also set that as well.

Opening any SharePoint page as model dialog SP2010

Hi Guys,

As we all know that sharepoint 2010 is opening a lot of forms in its newly featured model dialog.

Few of this pages are list forms like NewForm.aspx, EditForm.aspx, DispForm.aspx, pages while creating new object like list,site…etc.

While customize your sharepoint site, if by any chance you required any of your page to show in model dialog then below is the code for the same.

function OpenDialog(strPageURL,strDialogTitle) {

//Creating New Object for SharePointDialog
var newDialogOptions = SP.UI.$create_DialogOptions();

//set URL for Dialog to open
newDialogOptions.url = strPageURL;

//you can set your custom size by setting height and width
autoSize: true,

//set title to show on head of dialog
newDialogOptions.title = strDialogTitle;

// This line required only if you want to call a function when we close dialog -- here we refresh the page
newDialogOptions.dialogReturnValueCallback = Function.createDelegate(null,CallbackFunc);

//open the dialog
SP.UI.ModalDialog.showModalDialog(newDialogOptions);

return false;
}

function CallbackFunc(result, target) {
//Refresh the current page
location.reload(true);
//some suggest to use below line but sometime this was not working
//so we are working on that
//SP.UI.ModalDialog.RefreshPage(SP.UI.DialogResult.OK);

}

The good thing for us is you can open any page with this dialog.

That page might have you custom webpart as well or anything will work.

Even JavaScript, query string, postback etc… available on that page because that page work similar as normal page it will also remove limitation of traditional model dialog.

If we want to refresh parent page after closing popup then also we can do that (as shown in code)

One more thing if you want to open another model dialog from already open model dialog then also this one is working

Thanks Antonio Lanaro for his wonderful post on this one.

Enjoy the popup.

Send email to attendees from designer workflow

You may come across to a common scenario where in you may want to send an email to attendees in the calendar list. Or let’s say you have a manager name as a field and then you want a leave approval from them, so you select manager name in the field and submit the button, then you want mail to go to that manager or the attendee.

Many of us have doubt that if this is possible out of the box or not, but yes this is possible through SharePoint Designer. We are talking about the sending an email to one of the field data from the list item not to static email address.

Let’s say I have a calendar list and I have a manager name field in it. So open SharePoint designer 2007 or 2010, navigate to your site. Create a new workflow, based on your requirement, select list and then on new item created.

In condition to make it always true, compare ID field with the ID field and then in actions, select send an email.





Select Workflow lookup and then from current item, select field. In my case, its manager name.



So now onwards, if any item is created in the list, then mail will be triggered to the name mentioned in the manager name field.