= BLOCKCHAIN =: January 2012

January 30, 2012

Claims Based Authentication

http://blogs.technet.com/b/praveenh/archive/2011/09/08/configuring-claims-and-forms-based-authentication-for-use-with-an-asp-net-membership-provider-in-sharepoint-2010.aspx

http://msdn.microsoft.com/en-us/library/ie/ff953202.aspx

January 27, 2012

GAC Folder - MSIL

Run

%systemroot%\assembly\gac_msil

GAC dll uninstall Access Denied
http://msdn.microsoft.com/en-us/library/aa559881(v=bts.20).aspx

January 26, 2012

Term Stores between Environments

http://stoictech.wordpress.com/2011/10/07/solution-moving-terms-store-between-environments/

SharePoint Migration Manager

Tool to migrate data in between SharePoint Sites (2007 to 2010)

http://www.quest.com/migration-manager-for-sharepoint/

January 25, 2012

Metadata Property Mappings using PowerShell

Note: BDC Category, Check the Category Name in your Search Service App, i.e "Business Data"

Note: For PropSet --> edit the crawled property and get "Property Set ID"

$searchapp = Get-SPEnterpriseSearchServiceApplication "Search Service Application"

$category = Get-SPEnterpriseSearchMetadataCategory –Identity "SharePoint" -SearchApplication $searchapp

$crawledproperty = New-SPEnterpriseSearchMetadataCrawledProperty -SearchApplication $searchapp -Category $category -VariantType 31 -PropSet "00130329-0000-0130-c000-000000131346" -Name ows_TestProperty1 -IsNameEnum $false

$managedproperty = New-SPEnterpriseSearchMetadataManagedProperty -SearchApplication $searchapp -Name TestProperty1 -Type 1

New-SPEnterpriseSearchMetadataMapping -SearchApplication $searchapp -ManagedProperty $managedproperty -CrawledProperty $crawledproperty

DATA TYPE	CRAWLED PROPERTY VARIANTTYPE	MANAGED PROPERTY –TYPE PARAMETER
Text	31	1
Integer	20	2
Decimal	5	3
Date and Time	64	4
Yes/No	11	5
Binary Data	65	6

SharePoint 2010 PowerShell Cmdlets Reference

http://dmitrysotnikov.wordpress.com/2009/10/19/sharepoint-2010-cmdlet-reference/

January 16, 2012

Cannot be loaded because the execution of scripts is disabled on this system

http://www.itexperience.net/file-cannot-be-loaded-because-the-execution-of-scripts-is-disabled-on-this-system-error-in-powershell/

January 13, 2012

Referencing web part properties in SharePoint 2010 visual web part

https://www.nothingbutsharepoint.com/sites/devwiki/articles/Pages/How-To-Create-SharePoint-2010-custom-visual-webpart-properties.aspx

http://www.sharemuch.com/2010/05/25/referencing-web-part-properties-in-sharepoint-2010-visual-web-part/

Adding users from Different Domain - SharePoint

Just give the authenticated users Visitor access and give the url.
Once they hit the url, sharepoint creates the profile and authenticates them.

Powershell to Migrate Data From CSV

clear
Add-PSSnapin microsoft.sharepoint.PowerShell
$FilePath = "C:\Path\FAQ_List.csv"
$listurl="http://siteurl/Lists/FAQList";
[System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SharePoint") > $null;
$site=new-object Microsoft.SharePoint.SPSite($listurl);
$web=$site.openweb();
$list=$web.GetList($listurl);
$csv_file = Import-Csv $FilePath -Header("FAQ_ID","FAQ_Title","FAQ_PL","FAQ_Category","FAQ_Topic","FAQ_Answer");
$TaxSession = Get-SPTaxonomySession -Site "centraladminurl"
$TermStore = $TaxSession.TermStores["Managed Metadata Service"]
$TermStoreGroup = $TermStore.Groups["GroupName"]
$TermSet1 = $TermStoreGroup.TermSets["Product Lines1"]
$TermSet2 = $TermStoreGroup.TermSets["FAQ Categories1"]
#foreach ($line in $csv_file)
for($i=0;$i -le $csv_file.Count-2; $i++)
{
$line = $csv_file[$i];
$PL = ('#' + $line.FAQ_PL).Split(';');
$FC = ('#' + $line.FAQ_Category).Split(';');
$newItem = $list.Items.Add();
$targetPLField = [Microsoft.SharePoint.Taxonomy.TaxonomyField]$newItem.Fields["Product Lines"]
$targetFCField = [Microsoft.SharePoint.Taxonomy.TaxonomyField]$newItem.Fields["FAQ Category"]
$taxPLCollection = new-object Microsoft.SharePoint.Taxonomy.TaxonomyFieldValueCollection($targetPLField)
for($k=0;$k -le $PL.Count-1; $k++)
{
$taxonomyPLFieldValue = new-object Microsoft.SharePoint.Taxonomy.TaxonomyFieldValue($targetPLField)
if($TermSet1.GetTerms($PL[$k].Substring("1"),$true).Count -ne 0)
{
$taxonomyPLFieldValue.TermGuid = $TermSet1.GetTerms($PL[$k].Substring("1"),$true)[0].id
$taxonomyPLFieldValue.Label = $TermSet1.GetTerms($PL[$k].Substring("1"),$true)[0].Name
$taxPLCollection.Add($taxonomyPLFieldValue)
}
}
$targetPLField.SetFieldValue($newItem, $taxPLCollection)
$taxFCCollection = new-object Microsoft.SharePoint.Taxonomy.TaxonomyFieldValueCollection($targetFCField)
for($l=0;$l -le $FC.Count-1; $l++)
{
$taxonomyFCFieldValue = new-object Microsoft.SharePoint.Taxonomy.TaxonomyFieldValue($targetPLField)
if($TermSet2.GetTerms($FC[$l].Substring("1"),$true).Count -ne 0)
{
$taxonomyFCFieldValue.TermGuid = $TermSet2.GetTerms($FC[$l].Substring("1"),$true)[0].id
$taxonomyFCFieldValue.Label = $TermSet2.GetTerms($FC[$l].Substring("1"),$true)[0].Name
$taxFCCollection.Add($taxonomyFCFieldValue)
}
}
$targetFCField.SetFieldValue($newItem, $taxFCCollection)
$newItem["Title"] = $line.FAQ_Title;
$newItem["FAQ Topic"] = $line.FAQ_Topic;
$newItem["Answer"] = $line.FAQ_Answer;
$newItem.Update();
}
Remove-PSSnapin microsoft.sharepoint.PowerShell

http://ravendra.wordpress.com/uploading-csv-excel-data-into-sharepoint-list/
http://www.wapshere.com/missmiis/powershell-retrieving-data-from-excel