25 December, 2011

SharePoint Column/View Permission

As we all aware that there is no out of box way in sharepoint by which we can achieve column level permissions. but would like to highlight one third party utility which will be very effective and fullfill all the requirements.

You can get this utility here : SharePointBoost

What are the benefits:
----------------------------
1. SharePoint administrators can now assign to Users and User Groups all relative permissions at Columns-and Views-level.
2. Permissions can even be defined using conditions, so that the values of certain fields determine permissions dynamically.
3. Permissions settings can be imported or exported as XML file for easy management and batch permissions assignment. 



SharePoint Column/View Permission provides further protection on list columns and views than the SharePoint permission system does. Using it, you can safeguard the confidential column contents from access and edition by unauthorized users.

Main highlights:
-------------------
1. Hide or read-only columns in a list
2. Hide or read-only views in a list
3. Set Permissions According to Conditions
4. Hide columns in Alert Me email
5. Add Extral Protection against Access from Web Services


I hope the above mentioned information is pretty much clear regarding the SharePoint column permisisons utility.http://www.sharepointboost.com/columnpermission.html

The List Cannot be Displayed in Datasheet view.....


Display a list in Datasheet view. Datasheet view requires that you have a Windows SharePoint Services-compatible datasheet program installed, such as Microsoft Office 2010 Professional. Datasheet view lets you add, delete, and update list entries just as you would in a spreadsheet program, such as Microsoft Office Excel 2010. Come across such issue that belongs to datasheet view and details are as follows:

As we all know that SharePoint list consist of two views by default: Standard view and datasheet view. The standerd view is working fine without any issues but when i changed the view from standerd view to datasheet view then i faced the below mentioned problem | error message:

The list cannot be displayed in Datasheet view for one or more of the following reasons:
•A datasheet component compatible with Microsoft SharePoint Foundation is not installed.
•Your Web browser does not support ActiveX controls.
•A component is not properly configured for 32-bit or 64-bit support.


Configuration:-
-Machine OS: Windows 7 (64 bit)
-Office installed: Office 2010 (64 bit)
-IE version: IE8.0


Resolution:
Issue has been resolved because of this post

You can solve the issue by installing the “2007 Office System Driver: Data Connectivity Components” downloadable under:http://www.microsoft.com/download/en/confirmation.aspx?displaylang=en&id=23734

Why this issue occurs:
The ActiveX control for the Datasheet view is not compatible with Office 64-bit versions.

what is imporant to note:
Microsoft strongly recommends the use of 32-bit (x86) versions of Office 2010, Project 2010, and Visio 2010 applications as the default option for all platforms.
Office 2010 64 bits will not be required in most of the scenarios.


Note: DataSheet is an ActiveX control so it would work with only Internet Explorer.

I hope the above mentioned information is pretty much clear to resolve the issue but still in case of any doubts/queries/questions then please let me know.
I would be more than happy to help you as well as resolves your issues, Thank you

24 December, 2011

Sharepoint list columns not visible in datasheet view


Display a list in Datasheet view. Datasheet view requires that you have a Windows SharePoint Services-compatible datasheet program installed, such as Microsoft Office 2003 Professional. Datasheet view lets you add, delete, and update list entries just as you would in a spreadsheet program, such as Microsoft Office Excel 2003. Come across such issue that belongs to datasheet view and details are as follows:

ISSUE:
Some list columns are not visible in datasheet view

CAUSE:
This issue can be observed only if following is true:
1. Office 2003 is the primary office package installed at user workstation
2. List contains columns in which multiple values are allowed.

Multi-valued columns are not visible in datasheet view if you have office 2003 installed.

This is a by-design behavior.

RESOLUTION:
Any of the following is applicable to resolve this issue:
1. A feature needs to be installed called "Microsoft Office Access Web Datasheet Component". This feature can be found in the installation UI as a sub-feature of "Windows SharePoint Services Support".
2. Install “Access Runtime” which can be found http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=4438
3. Upgrade office package to version 2007

If you have any queries/questions regarding the above mentioned information then please let me know. I would be more than happy to help you as well as resolves your issues, thank you

References:


Cannot edit lists in Datasheet view

 SharePoint 2007: Use the Datasheet View to Add, Edit, or Delete Items and Files: http://programming4.us/enterprise/2402.aspx

23 December, 2011

How to Create Folders in a SharePoint Wiki Library?

As I mentioned in my last post that Wiki libraries are completely different and special ways are mentioned to achieve some functionality. So requirements will be many, library configurations will be different, library parameters will change but we need to move in that direction to achieve that functionality. It might be possible that it is resolve by using out of box functionality or by using SharePoint object model i.e. complete customization's. Don’t worry guys-we will concentrate only on out of box functionality to achieve these requirements.


Let’s go ahead and resolve this request:
Wiki libraries are configured in such a way in which you will not find an option to create a new folder.


Solution is very simple-
1.By default the view that you can see in the wiki page library is “All Pages”
2.Change the view from ‘All pages’ to ‘Explorer view’
3.When you will change the view then you will see an alone folder named as ‘Forms’. This is part of explorer view so please don’t delete it and keep it as it is.
4.Now this is windows network view and you can use all windows operations here so please go ahead-Right Click and you will get the option of ‘NEW FOLDER’
5.Assign appropriate name to a folder as per your project requirements
6.Now change the view from ‘Explorer view’ to ‘All pages’
7.That’s it-folder will be successfully created inside a wiki page library.


Easy! Simple! Neat & Clean-Mission accomplished and request completed.
If you have any queries/doubts regarding the above mentioned information then please let me know. I would be more than happy to help you as well as resolves your issues, thank you

Moving Wiki Pages Between Wiki Libraries in Sharepoint 2007

SharePoint has three primary page content-types: Wiki pages, Web-part pages, and Publishing Pages. Unlike prior versions of SharePoint, the default page type is a 'Wiki Page', which enables free-form editing based on the ribbon toolbar. It is possible to insert Web-parts into any page type. In this article, we will explore some insights related to Wiki.

Wikis are a useful living repository of information, allowing a build-up of shared knowledge in an easily managed and accessed format. But suppose if you want to transfer this wiki pages to another document library within the same site collection/different subsite within the same site.

Requirement: Transfer wiki pages from one place to another within same site collection.

Wiki library has its own existence and not like normal document libraries. For normal document libraries, we can easily transfer the documents by saving the library as template/using the explorer views of both libraries. But this not applicable for the Wiki libraries as they are little bit different configurations.

Let’s go ahead and achieve these requirements:
To explain this-I am keeping two document libraries named as Library A and Library B.
Both are wiki libraries. I wants to transfer the wiki pages from library A to library B.

Both the libraries are located on the same site collection i.e. root site but scenario will be: One library is at root site and another library is at subsite.

1.Go to the site where library A resides. 
2.Site actions
3.Site settings
4.Under site administration
5.Site content and structure
6.You will see two partitions now left navigation and right navigation
7.Select the library i.e. library A. As soon as you click on it then it will show the underneath pages in the right navigation pane
8.Now pages are in front of you, by default maximum 100 pages will be present on a single page, so if your library contains more than 100 pages then change the number from the right hand side.
9.Now select all the pages by clicking ‘select all’ check box
10.Actions
11.COPY

Note: You will see three options under actions-Copy, Move and Delete. Why I have selected COPY because it will keep the pages in both the libraries and we can cross check when the transfer operation will complete by comparing the numbers under view all site content.

If you select ‘MOVE’ then pages will be completely moved from library A and transfer to library B. it means that library A will be empty now and you don’t have any chance to rectify if the transfer operation fails.

When you will select COPY then you just have to wait for few seconds and it will give you a choice to select the destination library under any site that exists under the same site collection.As soon as you will select the destination library and click OK then operation will starts and will take some time depending upon the number of pages to be moved.

Note: Please don’t refresh or click anywhere when the operation is in progress, if you do such activity then pages won’t be moved and transfer operation fails.

I hope the above mentioned steps are pretty much clear to achieve the requirements as mentioned above. In case of any queries/questions then please let me know.
I would be more than happy to help you as well as resolves your issues, thank you.