SharePoint

SharePoint Document Library as a Network Drive

SharePoint can be fun if you just let it…

This post applies to SharePoint 2010 as I haven’t yet to play with the features of SharePoint 2013, although I am confident the same method would apply.

To map a SharePoint 2010 Document Library as a network drive you need to first copy the SharePoint document library URL. For example, I am using my document library from my ‘my sites’ location where I have “http://my.sites.jermsmit.domain/personal/jsmith/PersonalDocuments”.

I then open Windows Explorer, right click on Computer and select Map Network Drive

In the what network folder would you like to map?’ area I choose a drive letter that I would want “S” is a good choice as I have other mapped and its the next in the line for me. Choose what fits you best.

If you are in the same active directory domain you should not be prompt for a users and password. If you aren’t  just apply the domain/user and password you have been assigned for the SharePoint 2010 environment.

At this point you should be able to access your SharePoint 2010 document library contents right from Windows Explorer

– Jermal

SharePoint 2010 Social Collaboration Web Parts Missing

Today one of our SharePoint guys messaged me over Lync with a need to setup social web parts in SharePoint. What he noticed was that he was looking for the note board, organization browser, tag cloud , etc. It seems that somewhere in the past this feature was lost. Possibly during the SharePoint upgrade from 2007 to 2010.

To sum this up a bit. After a database attach upgrade of a site collection/content database from SharePoint 2007 to 2010, some of the web parts that you might expect to become available were not.

To fix this we used powershell and did the following:

Disable-SPFeature –Identity PortalLayouts –url http://corp.sharepoint.local

Enable-SPFeature PortalLayouts -Url http://corp.sharepoint.local

The issued was resolved

– jermal

 

SharePoint Server 2010 Windows PowerShell cmdlets

For those looking for essential resources when upgrading from MOSS 2007 to SharePoint Server 2010, I have found some of these very useful

Index of SharePoint Server 2010 Windows PowerShell cmdlets
http://technet.microsoft.com/en-us/library/ff678226(office.14).aspx

Avoid the Warning from Excel Services About Refreshing External Data

If you leave this value set to the default (i.e. Yes), then you’ll be greeted with the following message for each Excel Web Part on a TFS dashboard page:

This workbook contains one or more queries that refresh external data. A malicious user can design a query to access confidential information and distribute it to other users or perform other harmful actions.

If you trust the source of this workbook, click Yes to enable queries to external data in this workbook. If you are not sure, click No so that changes are not applied to your workbook.

Do you want to enable queries to external data in this workbook?

To avoid warnings before refreshing external data in Excel Services:

  1. On the SharePoint Central Administration home page, in the Application Management section, click Manage service applications.
  2. On the Service Applications page, click Excel Services Application.
  3. On the Manage Excel Services Application page, click Trusted File Locations.
  4. On the Excel Services Application Trusted File Locations page, point to the trusted file location that you want to edit (e.g. http://), click the arrow that appears, and then click Edit.
  5. On the Excel Services Application Edit Trusted File Location page, in the External Data section, clear the Refresh warning enabled checkbox, and then click OK.
Manage Excel Services trusted file locations