09 December, 2011

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

08 December, 2011

How to create a document library in SharePoint Server 2010?

1.     Open your SharePoint site
2.     Select “Site Actions” from the left hand side top corner(refer below mentioned screenshot)

 
3.     Select View all site contentàCreate
4.     As soon as you will click create then it will redirect to page where all types of list’s and libraries options are available
5.     Select the appropriate document library as per your project requirement
6.     Enter the title and URL name
7.     Click createàthat’s it, document library will be successfully created.

If you wants to check the more options then it will Permissions, Navigation and Navigation inheritance (please refer the below mentioned screenshot)

Microsoft has published an awesome document on this:

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:
4.     Assembling Documents on SharePoint 2010 Sites by Merging Content from Excel, PowerPoint, and Word: http://msdn.microsoft.com/en-us/library/ff519529.aspx

An error has occurred. Please contact your system administrator if this problem persists.

While working with a user yesterday, i have noticed that users could not view Excel files in browser and getting the below mentioned error message:

Error Message:
An error has occurred.
Please contact your system administrator if this problem persists. 

ULS Logs shows the following entry:
There was an error in communicating with Excel Calculation Services http://sharepoint:28963/SPAdmin/ExcelCalculationServer/ExcelService.asmx exception: The request failed with HTTP status 401: Unauthorized.

Checked the event viewer and found the following:

Event Viewer entries:
Event Type:        Error
Event Source:    Office SharePoint Server
Event Category: Excel Services Web Front End
Event ID:  5234
Date: 12/7/2012
Time: 2:50:06 PM
User: N/A
Computer: XXX
Description:
No Excel Calculation Services is available in the farm.[User:
SHAREPOINT\system]

Event Type:        Error
Event Source:    Office SharePoint Server
Event Category:  Excel Services Web Front End
Event ID: 5239
Date: 12/7/2012
Time: 2:50:06 PM
User:                     N/A
Computer: XXX
Description:
There was an error in communicating with Excel Calculation Services
http://sharepoint:28963/SPAdmin/ExcelCalculationServer/ExcelService.asmx
exception: Unable to connect to the remote server
[Session: (null)
User: SHAREPOINT\system].

Troubleshooting Done:

1-checked this article: http://social.msdn.microsoft.com/Forums/en-US/sharepointexcel/thread/8bba2694-7276-4505-85a5-02f91b92bb1d  which states that find the ssp which is giving the problem and recycle the app pool to which the ssp is referrencing.

2-http://social.msdn.microsoft.com/Forums/en-US/sharepointexcel/thread/321cb536-39d6-4ee9-b9ef-65db9e133d97but cannot apply this resolution as in my case the excel services are running fine for other portals and not working for only one web application.

3-http://social.msdn.microsoft.com/Forums/en-US/sharepointexcel/thread/5968cb82-2e65-44c0-bfa8-ce05d70154ff this article has mentioned 3 fixes which will varies from the farm to farm i.e. enviornment to enviornment.

4-Checked alternate access mappings as per this article:http://social.msdn.microsoft.com/Forums/en-US/sharepointexcel/thread/c0c59a6a-1cf6-4280-a2ca-9667b2cadd33/ but AAM seetings are fine in our enviornment.

5-Ran this below mentioned commands but no results:
stsadm -o setsharedwebserviceauthn -negotiate
stsadm -o execadmsvcjobs

6-checked SSP pool account is running or not as per this article: http://social.msdn.microsoft.com/Forums/en-US/sharepointexcel/thread/85310dd3-a7e7-4673-b258-b0fec7823b8d  but it is fine and no problems

7-excel services are running or not is already checked: http://njbblog.blogspot.com/2008/04/sharepoint-v3-error-excel-services.html

Resolution that fix our issue:
If you get this problem the solution in my case was to by pass the proxy for local requests, this was done by editting the web.config for the relevant web app & adding:

<system.net>

<defaultProxy>

<proxy proxyaddress="http://<ProxyServer>:<port>" bypassonlocal = "true"/>

</defaultProxy>

</system.net>
------------------------------------------
what we have added in this: bypassonlocal = "true"

Issue has been resolved and excel services started working without any issues, Thank you

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, Thanks

Move files from one document library to another document library in SharePoint Server 2010

I have created two document libraries named as Source Library and Destination Library, now we have a requirement- How to transfer the documents from one library to another.
Please follow the below mentioned steps and let me know in case of any issues:
1-Open two document libraries in separate browsers/internet explorers
2-Click on LIBRARY on the top for both the document libraries
3-Select "Open with Explorer" for both the document libraries


4-this will open up a new window in which you can see you documents
5-now simply copy it and paste it in the destination document library
Note: It will take some time to transfer depending upon the size of the documents
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:
1.   How to: Access, Copy, and Move Files:

2.   Document library planning (SharePoint Server 2010)

3.   Move the contents of a document library using explorer view.
http://msmvps.com/blogs/shane/archive/2006/01/12/move-the-contents-of-a-document-library-using-explorer-view.aspx

01 December, 2011

Best practices, Capacity planning, Implementations, Hardware requirement’s for SharePoint Server 2010

Planning and architecture for SharePoint Server 2010
IT pros can use the content in the planning and architecture guides to develop
conceptual, logical, and physical designs for configuring Microsoft SharePoint
Server 2010 features, servers, and topologies. It also provides
recommendations for system designs based on customer scenarios and includes
information to help IT pros design a highly reliable, consistently available, and
scalable system.
http://technet.microsoft.com/en-us/library/cc261834.aspx
Downloadable book: Planning and architecture for Office SharePoint Server 2007
This book provides information and guidelines to lead a team through the steps of planning the deployment of a solution based on Microsoft Office SharePoint Server 2007. The audiences for this book are business application specialists,
line-of-business specialists, information architects, IT generalists, program
managers, and infrastructure specialists who are planning a solution based on
Office SharePoint Server 2007. It also includes links to planning worksheets for recording information related to your planning and deployment activities.
http://technet.microsoft.com/en-us/library/cc262757(office.12).aspx
Hardware and software (SharePoint Server 2010)
Hardware Requirements
The requirements in the following table apply to the facilities of a single server
with integrated database and the facilities of a server farm that includes a single
server or multiple servers.
http://technet.microsoft.com/es-ar/library/cc262485.aspx
Software Requirements
The requirements of the following tables apply to installations of a single server
with integrated database and facilities of a server farm that includes a single
server or multiple servers.
Preparation Tool Products Microsoft SharePoint (which can be accessed from the
homepage of SharePoint Server 2010) can facilitate the installation of the software
prerequisites for SharePoint Server 2010. Make sure you have an Internet
connection, as some of these prerequisites are installed from the Internet. For
more information, see Deploying a single server with SQL Server (SharePoint Server 2010) http://technet.microsoft.com/es-ar/library/cc262243.aspx 
Deploying a single server with an integrated database (SharePoint Server 2010) http://technet.microsoft.com/es-ar/library/cc263202.aspx  and
Multiple servers to a group or server farm of three levels (SharePoint Server 2010)
http://technet.microsoft.com/es-ar/library/ee805948.aspx
If you have any queries/need any further information information then please let me know.
I would be more than happy to help you as well as resolves your issuesJ

29 November, 2011

"Email Users" action not working


Yesterday I worked on one ticket in which the user had mentioned the problem description “email users” action is not working. This issue has been resolved with the following analysis:

The groups consist of approximately 100 users. If you select all the users and performed an action “actionàEmail users” then it has to open a mail window by including the email ID’s of all the selected users but no redirection and nothing happens.

If I select some users in the range 10-20 then it will perform the exact action as expected. This condition leads me to think that there should be some limitation on which it has to work/stopped working after the range exceeds.

Did research and found out that it is known issue as per this: http://support.microsoft.com/kb/208427

Here is the detail why it happens.
-There is a limit of 2048 characters for URI in IE. in case the length increases , the page wont popup us with error, it shall simply tries redirecting to same page
-In case, the length is within limit, it shall redirect to the page and  call JavaScript, which in turn shall invoke client email application.

Now the question is-How to resolve this issue?
1)      Open the siteàsite actionsàsite settings
2)      Users and groups
3)      Open that specific group in which we need to extract the users list
4)      Change the view from ‘detail view’ to ‘List view’
5)      Copy the list by normal windows ‘copy’ command and paste it in excel
6)      Now it’s easy to get the list and request has been completed

If you have any queries 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

27 November, 2011

Cannot retrieve the URL specified in the XML Link property. For more assistance, contact your site administrator

You can use the XML Web Part to display Extensible Markup Language (XML) and apply Extensible Stylesheet Language Transformations (XSLT) to the XML before the content is displayed.  The content displayed in the XML Web Part cannot contain an HTML <FORM> element. If you need to use the <FORM> element, consider using the Page Viewer Web Part or the Form Web Part.  This is little bit tricky issue and took lot of time to investigate and research to find out the root cause behind this issue.

Problem Description:
Microsoft out-of-box XML web part returns an error when connecting to any SharePoint Web Service - owssrv.dll, lists.asmx, feed.rss. Works fine with static XML data file.

Error message:
Cannot retrieve the URL specified in the XML Link property. For more assistance, contact your site administrator

What exactly I am doing:
Use of the 'XML Web Part' to display the RSS feed from a List.

When I entered the URL to the feed into the 'XML Link' field I receive the message "Cannot retrieve the URL specified in the XML Link property. For more assistance, contact your site administrator."

Troubleshooting Done:
1)   If I click the 'Test Link' a new window opens and correctly shows the feed. 

2)   When I checked the SharePoint logs and found out that no credentials are being supplied with the GET request to listfeed.aspx

3)   Web parts settings are ok as i checked the XSL as well as XML properties.

4)   As the credentials are not being supplied then i had checked the web application pool account is a part of ISS_WPG and WSS_WPG (Worker process groups) and found out that the app pool account is already added inside the mentioned groups

5)   Along with above mentioned groups, there is one more group exist in Active directory called as "WSS_ADMIN_WPG". Now the questions arises-Does the application pool account is a part of this group or not? I checked and found out it's not a part of that group (i.e. WSS_ADMIN_WPG), added the same web application pool account inside the group and check the results but still no success.

6)   Now the final step which is a vital one is "Anonymous", Allowing anonymous access to that web application (Central Administration > Application Management > Application Security > Authentication Providers section). now let’s go to the site collection and allowed anonymous access to a specific list where the problem resides ( Open the site collection-site actions-site settings-advanced permissions-settings-anonymous access-select list and libraries only)

That’s it-as soon as I applied the above mentioned steps and comes back to the home where the xml web part resides-it works without any issues.

Conclusion/Resolution steps:
1)   Web application pool account should be a part of WSS_WPG, ISS_WPG and WSS_WPG

2)   Anonymous access for the web application and list & libraries section at the site collection

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.

17 November, 2011

Error opening MS project .mpp file

MPP documents are Microsoft Project files. Microsoft Project is a software program that helps program managers to define project scopes and plans, assign tasks and keep track of project progress. One user has opened a ticket with our team and mentioned then following details:
Problem description: - MS project files are stored in a document library. After check out the file and tried to edit- I am getting the error.
Error message: The document could not be opened for editing. A Microsoft SharePoint foundation Compatible application could not be found to edit the document.
Machine configuration:
1.     OS-Windows XP
2.     Internet Explorer: IE 7.0
3.     Office Installed: Office 2007
4.     Project application Installed: Project professional 2007
Important points to consider while troubleshooting:
1.  All Office files which consist of Microsoft word excel and PowerPoint files are opening fine without any issues so the problem is with the .MPP files only i.e. Project files.
2.  If we try opening the project files by means of Desktop i.e. user’s machine then file opens fine without any problems
3.  This is vital point which can be consider  as workaround:
v Go to the document library in which project files resides
v Hover your mouse to any project file and select ‘edit in Microsoft Office Project’
v It will give you a pop up by selecting the ‘SharePoint drafts’ option
v Click ok / you can do a check out also by selecting the ‘SharePoint draft’ option
v Now the document is in check out condition so go to the SharePoint drafts location on your machine (Location: \My Documents\SharePoint drafts)
v Open the document by means of draft location, do the changes and save it.
v Go back to the SharePoint site and check in the document.
v Changes will be successfully saved without any problems.
Now, let’s come back to main problem-If you don’t check the “SharePoint drafts’ check box while editing the document then you will get the generic error message as mentioned above i.e. “this component is not compatible …..”
Resolution: Please refer the article which has been posted by Mr. Pratik Vyas-http://sharepointpratik.blogspot.com/2010/07/document-could-not-be-opened-for.html  
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 youJ

How to find out the site collection ID

A SharePoint Site is a collection of pages, lists, and libraries configured for the purpose of achieving an express goal. A site may contain sub-sites, and those sites may contain further sub-sites. Typically, sites need to be created from scratch, but sites can also be created according to pre-defined templates that provide packaged functionality. Examples of Site templates in SharePoint include: Blogs, MySites, collaboration (team) sites, document workspaces, groupwork sites, and meeting workspaces.

Sites have navigation, themes/branding, custom permissions, workflows, and have the ability to be configured or customized in a number of ways. In order to achieve a greater degree of maintainability, sites typically inherit site-level settings from their parent sites.

While working on one SharePoint issue in collaboration with the SQL, I need to run a SQL query against a specific site collection by using its ID. So you must be aware how to find out the ID of a site collection. Its takes some time to find out the answer but would like to share with all of you so that you can take the benefit of the same and your time will be saved, Thank you

Here is my analysis regarding the same:
1. Open the Central Administration

2. Application Management
3. SharePoint Site Management
4. Site collection quotas and locks
5. Select the appropriate site collection and you will get the ID of that specific site collection on top of the browser.

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