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:

SharePoint Datasheet View and Office 2010 64-bit

http://www.knowsharepoint.com/2010/06/sharepoint-datasheet-view-and-office.html

SharePoint: ActiveX Error When Trying to View List in Datasheet View: http://weblogs.asp.net/felipeferreira/archive/2009/07/30/sharepoint-activex-error-when-trying-to-view-list-in-datasheet-view.aspx

Cannot edit lists in Datasheet view

http://objectmix.com/sharepoint/329100-cannot-edit-lists-datasheet-view.html

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

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.

Document Library Basics-SharePoint 2010

In this session, we will try to concentrate on ‘How To’ things associated with the documents as well as with the document library in SharePoint 2010 that includes the following things:

1.   How to change the document name

2.   How to check out the document

3.   How to download a document

4.   How to send the document library link

5.   How to manage permissions on a single document

6.   How to create a folder in document library

7.   How to delete the document

8.   How to create a view in document library

9.   How to set an alert on document library

10. How to set permissions on document library

Let’s start one by one:

How to change the document name

1.   Open the document library in which that document resides

2.   Select the check box of that document

3.   From the top ribbon, select Edit document (please refer the below mentioned screenshot)

4.   Or Hover your mouse to that document and you will get the dropdown like this:



Note: All document related activities are associated with ‘Documents’ section which is present under Library Tools

How to check out the document

1.   Open the document library in which that document resides

2.   Select the check box of that document

3.   From the top ribbon, select check out

4.   Or Hover your mouse to that document and your will get a dropdown like this:



How to download a document

1.   Open the document library in which that document resides

2.   Select the check box of that document

3.   From the top ribbonàDownload a copy (please refer the below mentioned screenshot)

4.   Or Hover your mouse to that document and you will get the dropdown like this:



How to send the document library link

1.   Open the document library in which that document resides

2.   Select the check box of that document

3.   From the top ribbon, select Email a Link(please refer the below mentioned screenshot)

1.   Or Hover your mouse to that document and you will get the dropdown like this:

How to manage permissions on a single document

1.   Open the document library in which that document resides

2.   Select the check box of that document

3.   From the top ribbon, Select Document permissions

4.   Or Hover your mouse to that document and you will get the dropdown like this:

How to create a folder in document library

1.   Click on the document library in which you wants to create a folder

2.   From the top ribbon, select NEW FOLDER (Under documents section) [Pease refer the below mentioned screenshot)

How to delete the document

1.   Open the document library in which that document resides

2.   Select the check box of that documents that you wants to delete

3.   From the top ribbon, select DELETE DOCUMENT(please refer the below mentioned screenshot)

4.   Or Hover your mouse to that document and you will get the dropdown like this:

How to create a view in document library

1.   Open the document library in which you wants to create a view

2.   As view is a part of LIBRARY and not a document so that’s why we will select the section of library from the top ribbon(please refer the below mentioned screenshot)

3.   Select the option that’s says-CREATE VIEW

How to set an alert on document library

1.   Open the document library on which you wants to set an alert

2.   Under Library ToolsàLibrary section

3.   Select Alert Me (Please refer the below mentioned screenshot)

How to set permissions on document library

1.   Open the document library on which you wants to set up permissions

2.   Under Library toolsàLibrary section

3.   Library Permissions(please refer the below mentioned screenshot)

4.   Or Library settings

5.   Under permissions and management

6.   Permissions for this document library

If you have any questions/queries regarding the above mentioned information then

please let me Know. I would be more than happy J to help you as well as resolves

your issues, Thank you

References:

1.   Create, Delete or Modify View: http://office.microsoft.com/en-us/sharepoint-server-help/create-modify-or-delete-a-view-HA010377693.aspx

2.   How to manage permissions for a list, library, folder: http://support.sherweb.com/Faqs/Show/how-to-manage-permissions-for-a-list-library-folder-or-document-item-sharepoint-2010

3.   User permissions and permission levels: http://technet.microsoft.com/en-us/library/cc288074.aspx

4.   Delete a document: http://office.microsoft.com/en-us/windows-sharepoint-services-help/delete-a-library-HA010223998.aspx

5.   Managing alerts: http://office.microsoft.com/en-us/windows-sharepoint-services-help/about-managing-alerts-HA001161282.aspx

How to transfer the document library from one site collection to another site in SharePoint 2010

We always transfer the documents from one document library to another but it would be great if I can transfer the complete library from one place to another.

Conditions will be:

1.   Movement of document library from parent site to subsite

2.   Movement of document library from one site collection to another

3.   To make the replica of one document library and create another one by means of archiving purposes

This information will be basic but very vital for the beginners who have started learning sharepoint from the ground level and document library will be undoubtedly important from business perspectives as we use it on daily basis.

So let’s start how we will achieve this requirement:

1.   Open the document library that you wants to transfer from one place to another

2.   Under library toolsàselect Library

3.   Library settings (please refer the mentioned screenshot)

4.   Under permissions and management

5.   Save Document Library as Template

When you will do this then it will ask to provide File name and Template name, make sure to select the check box that specifies “Include Content” and click OK

6.   The above action will save the library under list template gallery (/_catalogs/lt/Forms/AllItems.aspx)

7.   Now go to the list template gallery

8.   Click on the file name that you have provided and it will ask you save the template to your desktop

Now depending upon the project requirement, you can use this template anywhere.

Suppose if you want to create a same library under subsite then you can create now you can get this file under View all site contentàCreate

Suppose if you wants move this library to another site collection then simply upload the template file (that we have saved to desktop) to the list template gallery of another site collection (this is the site collection where you wants the library to move/Designate)

Here are the detailed steps in case of any confusion:

1. Lets go source SharePoint site collection
2. Site Actions
3. Site Settings
4. Galleries
5. List Templates
6. Click on the file name that you have provided and it will ask you save the template to your desktop
7. Now switch to Destination SharePoint site collection
8. Site actions
9. Site settings
10.  Galleries
11.  List Templates
12.  simply upload the template file (that we have saved to desktop) to this list template gallery

 That’s it-Now you will find this uploaded template under library creation path i.e. site actionsà View all site contentàCreate

I hope the above mentioned information is pretty much neat and clear but still please don’t hesitate if you have any queries/questions

I would be more than happyJ to help you as well as resolves your issuesJ

References:

1. http://pravahaminfo.blogspot.com/2011/05/how-to-move-document-library-from-one.html
2. http://weblogs.asp.net/bsimser/archive/2010/08/26/sharepoint-document-libraries-and-horrors-oh-my.aspx
3. http://technet.microsoft.com/en-us/library/cc262215.aspx

   4.http://social.msdn.microsoft.com/Forums/en/sharepoint2010general/thread/67282348-25c7-4bd0-9d95-61024c6892f9