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:

Some list columns are not visible in datasheet view

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.

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


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

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.