Showing posts from 2014

SharePoint 2010 Menu Customisation

Here is an awesome menu customisation for SharePoint 2010. I used the Css to make it look like on the screenshot, i have uploaded the Css and the image file which you can download.

This post is basically an excerpt from the blog , i am reposting it. Link

Sometimes it’s the small details that matters most and makes the difference. This post is about how to customize the look and feel for the global navigation, one important element in the SharePoint interface. The navigation control renders a fairly deep HTML structure with a lot of classes to keep in mind when you need to set your branding on the top of it. Recently I built an Intranet branding where the agency had the desire to include a small arrow for selected links in the navigation. This CSS do also take care of drop downs, in the case you are using that. I hope this could be useful for you if you need to include graphics, like this arrow in the global navigation. Download

SharePoint Scrolling Announcement/ News Scroll for 2010/2013

I been asked to create a scrolling announcement for one of my SharePoint 2010 website and  thought it was straight forward however googling for a while i realised many solution have lots of script to be done and some not working, i finally found an easier way to do the same; i have spend many hours to make this happen, by posting this hope will save some of your time.

How does this work ? This uses Content Query webpart and fetch data from Announcement list (Yes any number of announcements can be scrolled) and will display on the site, Here is a screenshot -

If you like it and would want to implement it here are the  steps -

[I have done this and tested on SharePoint 2010 and IE 11/Chrome]

Step 1.
Create an Announcement list or use the one which is already in the SharePoint list (You can create any list as you wish)

Step 2.
Add a CQWP and fetch the item to display- in my case i set a new field called "Show Scroll" and in the CQWP filtered the items if set to Yes

Step 3.

I h…

How to Import Excel Spreadsheet to Lists in SharePoint 2010 / 2013

Users asking you they have large data in Excel and want to import it into SharePoint; You might have dealt with it at least once if you are in SharePoint.

The primary option will be to import data onto SharePoint by creating a custom list from the Spreadsheet as said on this link - MS Link; there could  be situation where the list is already present and you want to update the data or not follow this approach and then you might think about the SharePoint Datasheet view

However this approach also have several limitations as the excel sheet values should need to be of the same datatype again SharePoint Datasheet view have some restrictions on columns with "Multiline columns" as  and so on... Now what is the best way, i was trying different things and nothing much was helping me out until I found the MS Access way  :)

Yes if you have MS Access service enabled on your farm you have a better and easy way to bulk upload data onto SharePoint in easy 4 steps, Here are the steps
[I …

SharePoint 2010 Content Query Web Part (CQWP) to display items from a List and Format it

In this article i will show how to query a SharePoint List using Content Query Webpart and display the results in a Nice formatted way
Here is a screenshot of what i have done using CQWP , querying a Custom SharePoint List:

I will explain the steps below on how i have accomplished this :

Step 1.
I have created a custom list with appropriate list columns and it has got columns with the names : “Contract Name” [Single Line of Text]  “Alert Date”[Date and Time] and “Notes” [Multiple line of Text].

Step 2.
Add a Content Query Webpart [CQWP] on to the site, now for displaying this in the above format we need to do two things
- Need to Edit the “ItemStyle.xslt” in the Styles folder and need to add a bit “CSS” on to the Site. Both of these can be accomplished as long as you have access to these folders and if you can add a Content Editor Webpart on to the page.
Now let me walk you through these two steps:
First lets see how we can edit the “Item Sytle.xl” file
Navigate to Site A…

How to filter SharePoint List based on user permission

Have you ever had a scenario where you had to create a custom list and then you should only show items in the list which the user is supposed to see based on the user permission or the User Group he belongs to?

Read on if you want to find a solution for this scenario..... I did tried lot of researching and I got bits and pieces of information scattered in the net but couldn’t find a compete article, so thought to blog it, hope this will help you.

I will brief a bit more on the scenario:

I was asked to create a Master Custom list for users of different departments in my company however since there are confidential documents these items should not be shown to each other. My initial thought was to achieve this OOB using views and permission however while digging down I understood that this was not straight forward and I couldn’t find much help from the internet. To achieve this I have done the below : 

Step 1.

First I have created a Custom list called “Contract Manager” with the necessary col…