Tag: Sharepoint

How to use Microsoft Document Connection for Mac with Genotec Hosted Sharepoint

Some days ago, I made a post about “How to use Microsoft Sharepoint Workspace 2010 with Genotec Hosted Sharepoint“. If you work on a Mac you can also use Microsoft Document Connection for Mac, which is included in Microsoft Office 2011 for Mac.

This shows you how you can use Document Connection for Mac with Hosted Sharepoint from Genotec.

  1. Start Microsoft Document Connection and connect to a SharePoint Site
    Microsoft Document Connect
  2. Add the  Addresse of your hosted Sharepoint Site
    Microsoft Document Connect
  3. Add your Credentials
    Microsoft Document Connect
  4. And now you are connected to your Site Collection
    Microsoft Document Connect


How to use Sharepoint Workspace 2010 with Genotec Hosted Sharepoint

This guide will show you how to add a Genotec Hosted Sharepoint 2010 to your Sharepoint Workspace 2010.

  1. First Startup Microsoft Sharepoint Workspace 2010
    Sharepoint Workspace 2010
  2. Add a new Sharepoint to your Sharepoint Workspace
    Microsoft Sharepoint Workspace 2010
  3. Add the Domain of your hosted Sharepoint (sharepointhosting.ch, Hostedsharepoint.ch or your own Domainname)
    Microsoft Sharepoint Workspace 2010
  4. Add your User Account and Password. Its Important that you add the Domain before your Username (CP\username)
    Microsoft Sharepoint Workspace 2010
  5. Now wait until your Site is synced with your computer
    Microsoft Sharepoint Workspace 2010
  6. Now you can see your Sharepoint Site Collection in the Launchbar and you can start working with Microsoft SharePoint Workspace.
    Microsoft Sharepoint Workspace 2010

Thats how you can connect a Genotec Hosted Sharepoint 2010 to your Sharepoint Workspace. I recommend that you use the “Remember my credentials” checkbox because your computer is not in the same Active Directory Domain.



Sharepoint 2010: Upload Multiple Documents button grayed out – This control is currently disabled

In the last days we had a customer ticket which was escalated because a user in our Hosted Sharepoint 2010 environment had the following problem. He could not upload multiple documents because the button was grayed out and he got the message “This control is currently disabled”.

Sharepoint 2010 multiple=

This is a feature which is a client integration component, which is available on machines with a installed Office 2010 client. So if you have a Windows 7 PC and Office 2010 installed you get the following:

  1. The first time you navigate on the Document Library you get asked about a ActiveX Control Object
    Sharepoint 2010 Document Library
  2. You can accept that
    Sharepoint 2010 Document Library
  3. Maybe you get asked again
    Sharepoint 2010 Document Library
  4. Now you can use the Upload Multiple Documents ButtonSharepoint 2010 Document Library
  5. And choose the Office Files
    Sharepoint 2010 Document Library

I found this solution in the technet forums



How to Backup a Sharepoint 2010 Site Collection with Powershell

Powershell HeaderOkay for a real backup solution you should use a backup software like Microsoft System Center Data Protection Manager or Symantec Backup Exec. But maybe you have customer which needs a backup of his Sharepoint Site Collection. You also could use the Backup Tool in the Sharepoint Central Administration, but if you need to automate that, you will need Powershell.

Backup a Site Collection:

[powershell]
Backup-SPSite -Identity “http://sharepoint.company.com” -Path “C:\Temp\backup1.bak” -Force
[/powershell]

Restore a Site Collection:

[powershell]
Restore-SPSite “http://sharepoint.company.com” -Path C:\backup1.bak -HostHeaderWebApplication “http://WebAppname” -Force -Confirm:$False
[/powershell]


Powershell: Create a new Sharepoint 2010 WebApplication and Site collection

Powershell Header

Microsoft Sharepoint 2010 is one of the new products which supports Windows Powershell commands. Its really easy to do the most tasks you do normally in the Sharepoint Central Administration with Powershell.

Microsoft created a Powershell Snapin for Sharepoint 2010, which is called “Microsoft.Sharepoint.Powershell”. This enables a lot of new Powershell cmdlets for Sharepoint.

With this small scripts you can simply create a new WebApplication and/or a new Sharepoint Site Collection.

Add the Sharepoint cmdlets:

[powershell]
Add-PsSnapin Microsoft.SharePoint.PowerShell
[/powershell]

Help for creating a new Sharepoint WebApplication:

The Powershell command for creating a new Web Application is New-SPWebApplication.

[powershell]
Get-Help New-SPWebApplication
NAME
New-SPWebApplication

SYNOPSIS
Creates a new Web application within the local farm.

SYNTAX
New-SPWebApplication -ApplicationPool -Name [-AdditionalClaimProvider
] [-AllowAnonymousAccess ] [-ApplicationPoolAccount ] [-AssignmentCollec
tion ] [-AuthenticationMethod ] [-AuthenticationProvider ] [-Confirm []] [-DatabaseCredentials ] [-DatabaseName ] [-Databas
eServer ] [-HostHeader ] [-Path ] [-Port ] [-SecureSocketsLayer ]
[-ServiceApplicationProxyGroup ] [-SignInRedirectProvider ] [-SignInRedirectURL ] [-Url ] [-WhatIf []] []

DESCRIPTION
Creates a new Web application specified by the Name parameter. The user specified by the DatabaseCredentials parame
ter must be a member of the dbcreator fixed server role on the database server.

For permissions and the most current information about Windows PowerShell for SharePoint Products, see the online d
ocumentation (http://go.microsoft.com/fwlink/?LinkId=163185).

RELATED LINKS
Get-SPWebApplication
Set-SPWebApplication
Get-SPWebApplication

REMARKS
To see the examples, type: “get-help New-SPWebApplication -examples”.
For more information, type: “get-help New-SPWebApplication -detailed”.
For technical information, type: “get-help New-SPWebApplication -full”.
[/powershell]

Creating a new Sharepoint WebApplication:

[powershell]
# SharePoint cmdlets
Add-PsSnapin Microsoft.SharePoint.PowerShell
# Set variables
$WebAppName = “Contoso Sharepoint1”
$WebAppHostHeader = “sharepoint1.contoso.com”
$WebAppPort = 80
$WebAppAppPool = “SharePoint1AppPool”
# This User has to be a Sharepoint Manager Account
$WebAppAppPoolAccount = “contoso\sp_serviceuser”
$WebAppDatabaseName = “Sharepoint1”
$WebAppDatabaseServer = “SQLServer\InstanceName”

# Create a new Sharepoint WebApplication
New-SPWebApplication -Name $WebAppName -Port $WebAppPort -HostHeader $WebAppHostHeader -URL (“http://” + $WWebAppHostHeader) -ApplicationPool $WebAppAppPool -ApplicationPoolAccount (Get-SPManagedAccount $WebAppAppPoolAccount) -DatabaseName $WebAppDatabaseName -DatabaseServer $WebAppDatabaseServer
[/powershell]

Creating a new Sharepoint Site Collection:

[powershell]
# SharePoint cmdlets
Add-PsSnapin Microsoft.SharePoint.PowerShell
# Templates
# Name Title LocaleId Custom
# —- —– ——– ——
# GLOBAL#0 Global template 1033 False
# STS#0 Team Site 1033 False
# STS#1 Blank Site 1033 False
# STS#2 Document Workspace 1033 False
# MPS#0 Basic Meeting Workspace 1033 False
# MPS#1 Blank Meeting Workspace 1033 False
# MPS#2 Decision Meeting Workspace 1033 False
# MPS#3 Social Meeting Workspace 1033 False
# MPS#4 Multipage Meeting Workspace 1033 False
# CENTRALADMIN#0 Central Admin Site 1033 False
# WIKI#0 Wiki Site 1033 False
# BLOG#0 Blog 1033 False
# SGS#0 Group Work Site 1033 False
# TENANTADMIN#0 Tenant Admin Site 1033 False

# Languages
# Name Title
# —- —–
# German 1031
# English 1033
# French 1036
# Spanish 1034

# Set variables
$SiteCollectionName = “Homepage”
$SiteCollectionURL = “http://sharepoint.contoso.com”
$SiteCollectionTemplate = “STS#0”
$SiteCollectionLanguage = 1033
$SiteCollectionOwner = “contoso\UserName”

# Create a new Sharepoint Site Collection
New-SPSite -URL $SiteCollectionURL -OwnerAlias $SiteCollectionOwner -Language $SiteCollectionLanguage -Template $SiteCollectionTemplate -Name $SiteCollectionName
[/powershell]

Creating a new Sharepoint WebApplication and a Sharepoint Site Collection:

[powershell]
# SharePoint cmdlets
Add-PsSnapin Microsoft.SharePoint.PowerShell
# Set variables
$WebAppName = “Contoso Sharepoint1”
$WebAppHostHeader = “sharepoint1.contoso.com”
$WebAppPort = 80
$WebAppAppPool = “SharePoint1AppPool”
# This User has to be a Sharepoint Manager Account
$WebAppAppPoolAccount = “contoso\sp_serviceuser”
$WebAppDatabaseName = “Sharepoint1”
$WebAppDatabaseServer = “SQLServer\InstanceName”
$SiteCollectionName = “Homepage”
$SiteCollectionURL = (“http://” + $WebAppHostHeader)
$SiteCollectionTemplate = “STS#0”
$SiteCollectionLanguage = 1033
$SiteCollectionOwner = “contoso\UserName”

# Create a new Sharepoint WebApplication
New-SPWebApplication -Name $WebAppName -Port $WebAppPort -HostHeader $WebAppHostHeader -URL (“http://” + $WebAppHostHeader) -ApplicationPool $WebAppAppPool -ApplicationPoolAccount (Get-SPManagedAccount $WebAppAppPoolAccount) -DatabaseName $WebAppDatabaseName -DatabaseServer $WebAppDatabaseServer

# Create a new Sharepoint Site Collection
New-SPSite -URL $SiteCollectionURL -OwnerAlias $SiteCollectionOwner -Language $SiteCollectionLanguage -Template $SiteCollectionTemplate -Name $SiteCollectionName
[/powershell]



Powershell: Count Sharepoint Sites on Sharepoint Server 2010

Powershell Header

This is a very small line of code to count Sharepoint 2010 Site Collections with Powershell.

[powershell]
(Get-SPSite -Limit all).Count
[/powershell]

By the way, we at Genotec AG are offering a Hosted Sharepoint 2010 solution based on Powershell automation.



Powershell: Get Sharepoint 2010 Site Collection Storage Usage

If you need to get the Storage Usage from a Sharepoint 2010 Site Collection, you can do this with Powershell.

Current Storage Used

1. Start SharePoint 2010 Management Shell or Powershell with the Sharepoint Snapin by:

Add-PSSnapin "Microsoft.SharePoint.PowerShell"

2. Create a new Object for a Site Collection:

$MySite = Get-SPSite http://my.sharepoint.com

3. You can now check the members of the $MySite Object:

$MySite | Get-Member (You could also use: Get-SPSite http://mysite.sharepoint.com | Get-Member)

get-spsite http://mysite.sharepoint.com | get-member

4. Now you get an output with a lot of member properties of this Site Collection Object. And you can see there is a member property called Usage, I think thats the right property. Now lets see what we get here:

$MySite.Usage

retruns:

Storage           : 1775819
Bandwidth         : 0
Visits            : 0
Hits              : 0
DiscussionStorage : 0

Ah there is a Storage property, lets use this to only get the used Storage:

$MySite.Usage.Storage

this returns the Storage Space in Bytes. Not really use full, so we get this in Megabytes:

$MySite.Usage.Storage / 1MB

returns:

1.6935....