If you check out a file in SharePoint, you have the option to ‘Use my local drafts folder’. So, where is the folder located?
C:\Users\YOUR NAME\Documents\SharePoint Drafts
Where is Use my local drafts folder
Reply
SharePoint Designer Sucks
I’ll say it, SharePoint Designer SUCKS!
2007 and now 2010, both suck.
If we had to pay for this product I’d be one unhappy SharePoint person.
How can you release a product that is so important to SharePoint and allow it to be so buggy!
/rant
PowerShell Exception calling GetLimitedWebPartManager
Using PowerShell against SharePoint, I was trying to remove a web part from a lot of pages.
Time after time I was receiving this error:
Exception calling “GetLimitedWebPartManager” with “2” argument(s): “Unable to cast COM object of type ‘Microsoft.SharePoint.Li
brary.SPRequestInternalClass’ to interface type ‘Microsoft.SharePoint.Library.ISPRequest’. This operation failed because the Q
ueryInterface call on the COM component for the interface with IID
Turned out that I wasn’t trying to work with the correct page. I was trying to work with a web part on a page in a library, but by script was working with a site page.
PowerShell SharePoint Delete Web Part
Migrated a company from SharePoint 2007 to SharePoint 2010 and hit another small bump in the process.
The core issue was related to the AllItems.aspx page in a given library had a Content Editor web part on the page. Why? No idea, but when users tried to access the library, the Documents and Library tab were missing from the Ribbon.
This wouldn’t be an issue if I was dealing one library.
In my case, I had a Site Collection with a dozen sites, then under each of those sites were 100+ sites. So, I only needed to update ~1,000 sites.
Options:
A. Hire someone to edit ALL of those sites / pages.
B. Our great friend PowerShell!
What I’m doing in the script:
Starting at the Site Collection.
Loop on each site.
Looping on each List in the site.
When site = Random Documents dig in a little deeper.
Get the web parts on the AllItems.aspx page.
Loop on the web parts.
If web part title = “Content Editor Web Part”
Delete it.
$site = Get-SPSite "http://sharepointed.com/SiteCollection"
foreach ($web in $site.AllWebs)
{
foreach($List in $web.Lists)
{
If($list.Title -eq "Random Documents")
{
$webpartmanager = $web.GetLimitedWebPartManager(($web.Url + "/Random%20Documents/Forms/AllItems.aspx"), [System.Web.UI.WebControls.WebParts.PersonalizationScope]::Shared)
for($i=0; $i -lt $webpartmanager.WebParts.Count; $i++)
{
if($webpartmanager.WebParts[$i].Title -eq "Content Editor Web Part")
{
$webpartmanager.DeleteWebPart($webpartmanager.Webparts[$webpartmanager.WebParts[$i].ID])
}
}
}
}
$web.Update()
$web.Dispose()
}
$site.Dispose()
Cannot Open PDF in SharePoint 2010
Was having an issue opening PDF files in SharePoint 2010…
What worked for me was to install Adobe Reader X.
http://www.adobe.com/products/reader.html
Are SharePoint Workflows Case Sensitive
Yes, SharePoint workflows are case sensitive!
Recently ran into a BIG issue that caused thousands of emails to be sent, because of this question.
I needed to relink a few hundred InfoPath forms, the library had an associated workflow… So, I opened SharePoint Designer, added a new step to the workflow, and published my changes.
workflow step:
Condition: If Modified By equals domain\Ihayse
Action: Stop the workflow
Why do this?
When you relink the forms in a library, the worklow will be fired.
After receiving emails and IM’s from some happy campers, I knew my workflow was wrong.
My workflow step should have read:
Condition: If Modified By equals domain\ihayse
Action: Stop the workflow
My domain name is my first initial then my last name, all in lowercase.
Increase Storage Limit for One My Site User
Out of the box, the storage allocation for My Sites is real small. In SharePoint 2010 and SharePoint 2007 you can increase the storage limits for each My Site.
In SharePoint 2010:
Central Admin > Application Management > Configure quotas and locks
First select the My Site Web Application, then select the users My Site you want to edit.
In the Site Quota Information section, change Current quota template to Individual Quota, then change Limit site storage to a maximum of: ___ to your new value.
You can also set the Send warning e-mail when site storage reaches value to remind the user they are running low on space.
Click OK, and you are ready for more storage.
Microsoft info on this topic:
http://technet.microsoft.com/en-us/library/cc263480.aspx#BKMK_ChangeQuotaTemplates
Manage Content and Structure Link
Where is the Manage Content and Structure link?
Notice how the URL changes….
http://sharepoint/_layouts/sitemanager.aspx?Source=%2FPages%2FDefault%2Easpx
http://sharepoint/taco/_layouts/sitemanager.aspx?Source=%2Ftaco%2Fdefault%2Easpx
http://sharepoint/taco/meat/cheese/_layouts/sitemanager.aspx?Source=%2Ftaco%2Fmeat%2Fcheese%2F%5Flayouts%2Fmngsubwebs%2Easpx%3Fview%3Dsites%26
Update Default Value of a Date and Time field
Ohhh how handy can PowerShell be!
I needed to change the default value of a Date and Time field for several hundred sites. PowerShell allowed me to update the field on all of my SharePoint sites in a matter of seconds.
#add-pssnapin microsoft.sharepoint.powershell
$spsite=[Microsoft.SharePoint.SPSite]("http://sharepointed.com/customers/")
foreach ($web in $spsite.AllWebs)
{
Write-Host $web.name
$List = "List or Library"
$OpenList = $web.Lists[$List]
$Field = $OpenList.Fields["My Date Field"]
$Field.DefaultValue = "[today]"
$Field.Update($True)
$web.Dispose()
}
$spsite.Dispose()
Update Hyperlink Field in SharePoint with PowerShell
Recently was asked to update the hyperlink field in a SharePoint list. The list had thousands of links pointing to a server we were moving, so the URL in the list needed to updated to reflect the new location. The only options I could think of, were to open SQL Server and do find/update against the content database(s). Well, Microsoft doesn’t like up playing with the SharePoint databases. So I cracked open PowerShell and went to town trying to figure this out.
#Add-PSSnapin Microsoft.SharePoint.PowerShell
$siteUrl = "http://sharepoint/SiteCollection/SiteName"
$webName = “SiteName”
$listName = "Name of your list"
$spSite = new-object Microsoft.SharePoint.SPSite($siteurl)
$spWeb = $spSite.OpenWeb($webName)
$spList = $spWeb.Lists[$listName]
foreach($Item in $spList.Items )
{
$ofldurl= new-object Microsoft.SharePoint.SPFieldUrlValue($Item["URL"])
$ofldurl.URL = $ofldurl.URL.Replace("Nacho", "Taco")
$ofldurl.Description = $ofldurl.Description.Replace("Nacho", "Taco")
$item["URL"] = $ofldurl
$item.update()
}
$spWeb.Dispose()
What I’m doing here is replacing part of the URL string with a new word. The script is looking for the string Nacho and replacing it with Taco.
**** update ****
After migrating from SharePoint / WSS 2007 to SharePoint 2010, we started to notice some of our URLs were messed up. Web parts ( Page Viewer) and internal hyperlinks were pointing to an incorrect location.
example:
http://sharepoint/crmsp/customers/sitename/_layouts/1033/mngsubwebs.aspx?view=sites
Notice the 1033, no bueno!
Using the script above, i was able to update the links.
#Add-PSSnapin Microsoft.SharePoint.PowerShell
$siteUrl = "http://sharepoint/SiteCollection/SiteName"
$webName = “SiteName”
$listName = "Name of your list"
$spSite = new-object Microsoft.SharePoint.SPSite($siteurl)
$spWeb = $spSite.OpenWeb($webName)
$spList = $spWeb.Lists[$listName]
foreach($Item in $spList.Items )
{
$ofldurl= new-object Microsoft.SharePoint.SPFieldUrlValue($Item["URL"])
$ofldurl.URL = $ofldurl.URL.Replace("1033/", "")
$ofldurl.Description = $ofldurl.Description.Replace($ofldurl.Description, $ofldurl.Description)
$item["URL"] = $ofldurl
$item.update()
}
$spWeb.Dispose()
In SharePoint 2016, the Description property appears broken?
This is the only way I could manage to set the URL and display text:
$newItem[“LinkField”] = "http://taco.com, taco2"