Vito Cagnazzo SharePoint

Create Site SharePoint Rest C# CSOM

2015-04-03T17:07:00.000+02:00

private static string GetFormDigest(string token, string hdnHostWeb)
{
/* Retrieve a form digest, which is required for creating a new list item */

string endpoint = hdnHostWeb + "/_api/contextinfo";
HttpWebRequest digestRequest = (HttpWebRequest)HttpWebRequest.Create(endpoint);
digestRequest.Headers.Add("Authorization", "Bearer " + token);
digestRequest.Method = "POST";
digestRequest.ContentLength = 0;

HttpWebResponse digestResponse = (HttpWebResponse)digestRequest.GetResponse();
XDocument responseDoc = XDocument.Load(digestResponse.GetResponseStream());

XNamespace d = "http://schemas.microsoft.com/ado/2007/08/dataservices";
string formDigest = responseDoc.Descendants(d + "FormDigestValue").First().Value;

return formDigest;
}

public static Web CreateSite(string token, ClientContext cc, Web currentWeb, string template, int langue, bool heritage, string description, string titre, string url)
{
Web web = null;
try
{
#region test
string itemXML = "{'parameters': {'__metadata': {'type': 'SP.WebInfoCreationInformation' },'Url': '" + url + "','Title': '" + titre + "','Description': '" + description + "','Language':" + langue + ",'WebTemplate':'" + template + "','UseUniquePermissions':'" + !heritage + "'}}";

HttpWebRequest restRequest = (HttpWebRequest)HttpWebRequest.Create(currentWeb.Url + "/_api/web/webinfos/add");
restRequest.Headers.Add("Authorization", "Bearer " + token);
restRequest.Credentials = CredentialCache.DefaultCredentials;
restRequest.Method = "POST";
restRequest.Headers["X-RequestDigest"] = GetFormDigest(token, currentWeb.Url);
restRequest.Accept = "application/json;odata=verbose";
restRequest.ContentType = "application/json;odata=verbose";
restRequest.ContentLength = itemXML.Length;
StreamWriter sw = new StreamWriter(restRequest.GetRequestStream());
sw.Write(itemXML);
sw.Flush();

//Get response
HttpWebResponse restResponse = (HttpWebResponse)restRequest.GetResponse();
StreamReader restStream = new StreamReader(restResponse.GetResponseStream());

#endregion

cc.Load(cc.Web.Webs);
cc.ExecuteQuery();

foreach (Web wb in cc.Web.Webs)
{
if (wb.Title == titre || wb.Url == url)
{
web = wb;
}
}
.....

Javascript MemberOf Group AD, query LDAP ( activeX enabled /!\ and only in IE /!\)

2015-04-02T18:51:00.004+02:00

var ldapSearchJs = ldapSearchJs || {};

ldapSearchJs.getUserName = function () {
var wshNetwork = new ActiveXObject("WScript.Network");
var userName = wshNetwork.UserName;
return userName;
}

ldapSearchJs.isMemberOf = function (userName, group) {
objConnection = new ActiveXObject("ADODB.Connection");
objConnection.Provider = "ADsDSOObject";
objConnection.Open("ADs Provider");
objCommand = new ActiveXObject("ADODB.Command");
objCommand.ActiveConnection = objConnection;

objCommand.CommandText = "SELECT distinguishedName, memberOf, primaryGroupID, objectSID FROM 'LDAP://DC=vca-share,DC=local' "
+ " WHERE sAMAccountName='" + userName + "' and memberof='CN=" + group + ",CN=Users,DC=vca-share,DC=local'"; //(memberOf=cn=adminsp,ou=users,dc=vca-share,DC=local))";

objRecordSet = objCommand.Execute();

var userMail, lastName, firstName;
if (objRecordSet.RecordCount > 0) {
isMemberOf = 'Yes, ' + userName + ' is memeber of ' + group;
}
else {
isMemberOf = 'No';
}
objConnection.Close;

return isMemberOf;
}

$(document).ready(function () {

alert(
ldapSearchJs.isMemberOf(ldapSearchJs.getUserName(), 'adminsp')
);
});

SharePoint App Dev Note

2015-02-17T17:50:00.004+01:00

##Grab the cert and create the object##
$publicCertPath = "C:\vca-share.cer"
$certificate = New-Object System.Security.Cryptography.X509Certificates.X509Certificate2($publicCertPath)
##Certificate treated as root authority##
New-SPTrustedRootAuthority -Name "HighTrustAppCert" -Certificate $certificate
##Setup token issuer which is the certificate itself##
$realm = Get-SPAuthenticationRealm
$specificIssuerId = [System.Guid]::NewGuid().ToString()
$specificIssuerId
$fullIssuerIdentifier = $specificIssuerId + '@' + $realm
New-SPTrustedSecurityTokenIssuer -Name "HighTrustAppCert" -Certificate $certificate -RegisteredIssuerName $fullIssuerIdentifier -IsTrustBroker
iisreset
$serviceConfig = Get-SPSecurityTokenServiceConfig
$serviceConfig.AllowOAuthOverHttp = $true
$serviceConfig.Update()
$specificIssuerId

http://{sharepoint}/_layouts/15/AppRegNew.aspx

New-SPSubscriptionSettingsServiceApplication -ApplicationPool "SharePoint Web Services Default" -Name "Subscription Settings Service Application" -DatabaseName "SubscriptionSettingsDB" | New-SPSubscriptionSettingsServiceApplicationProxy

New-SPSubscriptionSettingsServiceApplication -ApplicationPool "SharePoint Web Services Default" -Name "Subscription Settings Service Application" -DatabaseName "SubscriptionSettingsDB" | New-SPSubscriptionSettingsServiceApplicationProxy

New-ItemProperty HKLM:\System\CurrentControlSet\Control\Lsa -Name "DisableLoopbackCheck" -Value "1" -PropertyType dword

$serviceConfig = Get-SPSecurityTokenServiceConfig$serviceConfig AllowOAuthOverHttp = $true $serviceConfig.Update()

http://sharepoint.stackexchange.com/questions/79284/getting-401-403-in-high-trust-app-for-sharepoint-2013

system.net tag:
<settings>
<servicePointManager
checkCertificateName=”false”
checkCertificateRevocationList=”false”/>
</settings>

SharePoint - JavaScript current page context info

2014-12-08T15:31:00.002+01:00

var _spPageContextInfo = {

   2:     webServerRelativeUrl: "\u002ftest",

   3:     webAbsoluteUrl: "http:\u002f\u002fexample\u002ftest",

   4:     siteAbsoluteUrl: "http:\u002f\u002fexample.com\u002ftest",

   5:     serverRequestPath: "\u002f_layouts\u002f15\u002fosssearchresults.aspx",

   6:     layoutsUrl: "_layouts\u002f15",

   7:     webTitle: "Home",

   8:     webTemplate: "53",

   9:     tenantAppVersion: "0",

  10:     webLogoUrl: "_layouts\u002f15\u002fimages\u002fsiteicon.png",

  11:     webLanguage: 1033,

  12:     currentLanguage: 1033,

  13:     currentUICultureName: "en-US",

  14:     currentCultureName: "en-US",

  15:     clientServerTimeDelta: new Date("2013-06-07T19:07:01.3494510Z") - new Date(),

  16:     siteClientTag: "40$$15.0.4420.1017",

  17:     crossDomainPhotosEnabled: false,

  18:     webUIVersion: 15,

  19:     webPermMasks: {

  20:         High: 2147483647,

  21:         Low: 4294967295

  22:     },

  23:     pagePersonalizationScope: 1,

  24:     userId: 1,

  25:     systemUserKey: "i:0\u0029.w|s-1-5-21-...",

  26:     alertsEnabled: false,

  27:     siteServerRelativeUrl: "\u002ftest",

  28:     allowSilverlightPrompt: 'True'

  29: };

example, open current page's version history:

open content editor web part and past this:

<script>function openModal(){var options = { tite: "Version History", url: _spPageContextInfo.webServerRelativeUrl + "/_layouts/Versions.aspx?list="+ _spPageContextInfo.pageListId +"&ID="+ _spPageContextInfo.pageItemId, width: 800, height: 500,};SP.UI.ModalDialog.showModalDialog(options);}</script><a href="javascript:openModal()">open</a>

Name	SP2010	SP2013	Example Value
currentLanguage	X	X	1033
pageItemId	X	X	1
pageListId	X	X	Guid
webLanguage	X	X	1033
webServerRelativeUrl	X	X	/
webUIVersion	X	X	4 or 15
alertsEnabled	X	X	False
allowSilverlightPrompt	X	X	False
userId	X	X	9
clientServerTimeDelta		X	Time
crossDomainPhotosEnabled		X	False
currentCultureName		X	en-US
currentUICultureName		X	en-US
layoutsUrl		X	_layouts/15
pagePersonalizationScope		X	1
serverRequestPath		X	/SitePages/Home.aspx
siteAbsoluteUrl		X	http://sp
siteClientTag		X	0$$15.0.4420.1017
siteServerRelativeUrl		X	/
systemUserKey		X	1:0).w\|<sid>
tenantAppVersion		X	0
webAbsoluteUrl		X	http://sp
webTemplate		X	1
webLogoUrl		X	_layouts/15/images/siteicon.png
webPermMasks		X	Object with properties High & Low
webTitle		X	Test

Apps Provisioning Master Page SharePoint Javascript

2014-12-08T11:58:00.002+01:00

'use strict';

window.VCA = window.VCA || {};

window.VCA.HostWebApp = function () {
var hostWebUrl,
appWebUrl,
hostWebContext,
destinationServerRelativeUrl,
destinationFileName,
createInfo,
newFile,
newFileID,

// locate a file in the app web and retrieve the contents. If successful, provision to host web..
readFromAppWebAndProvisionToHost = function (appPageUrl, hostWebServerRelativeUrl, hostWebFileName) {
destinationServerRelativeUrl = hostWebServerRelativeUrl;
destinationFileName = hostWebFileName;

var req = $.ajax({
url: appPageUrl,
type: "GET",
cache: false
}).done(function (fileContents) {
if (fileContents !== undefined && fileContents.length > 0) {
uploadFileToHostWebViaCSOM(destinationServerRelativeUrl, destinationFileName, fileContents);
}
else {
alert('Failed to read file from app web, so not uploading to host web..');
}
}).fail(function (jqXHR, textStatus) {
alert("Request for page in app web failed: " + textStatus);
});
},

// utility method for uploading files to host web..
uploadFileToHostWebViaCSOM = function (serverRelativeUrl, filename, contents) {
createInfo = new SP.FileCreationInformation();
createInfo.set_content(new SP.Base64EncodedByteArray());
for (var i = 0; i < contents.length; i++) {

createInfo.get_content().append(contents.charCodeAt(i));
}
createInfo.set_overwrite(true);
createInfo.set_url(filename);
var files = hostWebContext.get_web().getFolderByServerRelativeUrl(serverRelativeUrl).get_files();
hostWebContext.load(files);
newFile = files.add(createInfo);
hostWebContext.load(newFile, 'ListItemAllFields');

hostWebContext.executeQueryAsync(onProvisionFileSuccess, onProvisionFileFail);
},
onProvisionFileSuccess = function () {
$('#message').append('<br /><div>File provisioned in host web successfully: ' + destinationServerRelativeUrl + '/' + destinationFileName + '</div>');

newFileID = newFile.get_listItemAllFields().get_id();

setContentTypeEtPublishing('/' + destinationServerRelativeUrl + '/' + destinationFileName);
},
onProvisionFileFail = function (sender, args) {
alert('Failed to provision file into host web. Error:' + sender.statusCode);
},

// set content type et publishing
setContentTypeEtPublishing = function (masterUrl) {
var hostWeb = hostWebContext.get_web();

var oList = hostWeb.get_lists().getByTitle('Master Page Gallery');

var oMastreItem = oList.getItemById(newFileID); //test remplace avec query
//389
oMastreItem.set_item('ows_ContentType', 'Html Master Page');
oMastreItem.update();
var oMasterFile = oMastreItem.get_file();
oMasterFile.publish("Published by app");

hostWebContext.executeQueryAsync(onsetContentTypeEtPublishingSuccess, onProvisionFileFail);
},
onsetContentTypeEtPublishingSuccess = function () {
$('#message').append('<br /><div>Master page content type edited et page published successfully: ' + destinationServerRelativeUrl + '/' + destinationFileName + '</div>');
setMaster('/' + destinationServerRelativeUrl + '/' + destinationFileName);
},
onProvisionFileFail = function (sender, args) {
alert('Failed to provision file into host web. Error:' + sender.statusCode);
},

// set master page on host web..
setMaster = function (masterUrl) {
var hostWeb = hostWebContext.get_web();
var siteRerlativeMasterUrl = _spPageContextInfo.siteServerRelativeUrl + masterUrl;

hostWeb.set_customMasterUrl(siteRerlativeMasterUrl);
hostWeb.set_masterUrl(siteRerlativeMasterUrl);
hostWeb.update();

hostWebContext.load(hostWeb);
hostWebContext.executeQueryAsync(onSetMasterSuccess, onSetMasterFail);
},
onSetMasterSuccess = function () {
$('#message').append('<br /><div>Master page updated successfully..</div>');
},
onSetMasterFail = function (sender, args) {
alert('Failed to update master page on host web. Error:' + args.get_message());
},

init = function () {
var hostWebUrlFromQS = $.getUrlVar("SPHostUrl");
hostWebUrl = (hostWebUrlFromQS !== undefined) ? decodeURIComponent(hostWebUrlFromQS) : undefined;

var appWebUrlFromQS = $.getUrlVar("SPAppWebUrl");
appWebUrl = (appWebUrlFromQS !== undefined) ? decodeURIComponent(appWebUrlFromQS) : undefined;
}

return {
execute: function () {
init();

hostWebContext = new SP.ClientContext(window.VCA.appHelper.getRelativeUrlFromAbsolute(hostWebUrl));
readFromAppWebAndProvisionToHost(appWebUrl + '/MasterPages/MasterPageProvisionedByApp.txt', '_catalogs/masterpage', 'ProvisionedByApp.master');
}
}
}();

window.VCA.AppHelper = {
getRelativeUrlFromAbsolute: function (absoluteUrl) {
absoluteUrl = absoluteUrl.replace('https://', '');

if (absoluteUrl == absoluteUrl)
absoluteUrl = absoluteUrl.replace('http://', '');

var parts = absoluteUrl.split('/');
var relativeUrl = '/';
for (var i = 1; i < parts.length; i++) {
relativeUrl += parts[i] + '/';
}
return relativeUrl;
},
};

//$(document).ready(function () {
// window.VCA.HostWebApp.execute();
//});

Version corrigée de
http://www.sharepointnutsandbolts.com/2013/05/sp2013-host-web-apps-provisioning-files.html
CHRIS O'BRIEN

SocialDataFrame

2014-12-01T12:22:00.002+01:00

{web}/_layouts/SocialDataFrame.aspx?
Title={Title} --- ex. "This is my title"
&Src=bm
&DisplayUrl={liste url} --- ex. "http://projects.com/sites/moc/Lists/Rece
&Url={item url} --- ex. "http://projects.com/sites/moc/Lists/Rece/DispForm.aspx?ID=10

There is no Workflow App Part registered

2014-11-26T16:11:00.002+01:00

$WmsSap = Get-SPWorkflowServiceApplicationProxy
$WmsSap.RegisterWorkflowLifecycleManagementEnvironment()

Get page views, javascript sharepoint

2014-11-26T16:11:00.001+01:00

var context;
var web;
var list;
var currentItem;

$(document).ready(function () {
context = new SP.ClientContext.get_current();
web = parentContext.get_web();
list = web.get_lists().getById(_spPageContextInfo.pageListId);
currentItem = list.getItemById(_spPageContextInfo.pageItemId)
context.load(currentItem);
context.executeQueryAsync(onQuerySucceeded, onQueryFailed);
});

function onQuerySucceeded() {
var guid = currentItem.get_fieldValues("UniqueId").UniqueId.toString();
}

function onQueryFailed(sender, args) {
//Error Logging
}

function onQuerySucceeded() {
var keywordQuery = new Microsoft.SharePoint.Client.Search.Query.KeywordQuery(context);
keywordQuery.set_queryText('PageGuid:"{' + currentItem.get_fieldValues("UniqueId").UniqueId.toString() + '}"');
var searchExecutor = new Microsoft.SharePoint.Client.Search.Query.SearchExecutor(context);
results = searchExecutor.executeQuery(keywordQuery);
context.executeQueryAsync(SearchDone, SearchFailed)
}

function SearchDone() {
var viewCount = results.m_value.ResultTables[0].ResultRows[0].ViewsLifeTime;
//Use JQuery to show the viewCount on the page
}

function SearchFailed(sender, args) {
//Error Logging
}

Add Subscription Settings Service Application

2014-11-13T15:27:00.002+01:00

New-SPSubscriptionSettingsServiceApplication -ApplicationPool "SharePoint Web Services Default" -Name "Subscription Settings Service Application" -DatabaseName "SubscriptionSettingsDB" | New-SPSubscriptionSettingsServiceApplicationProxy

Manage User Properties Error

2014-11-07T17:44:00.001+01:00

6398
Critical
The Execute method of job definition Microsoft.Office.Server.UserProfiles.UserProfileImportJob

Démarrer le service SharePoint "Forefront Identity Manager Service"

Paramétrer un environnent pour le développement des apps SharePoint (PowerShell)

2014-06-27T11:41:00.001+02:00

Set-SPAppDomain "sharepoint.dev"

Get-SPServiceInstance | where{$_.GetType().Name -eq "AppManagementServiceInstance" -or $_.GetType().Name -eq "SPSubscriptionSettingsServiceInstance"} | Start-SPServiceInstance

Get-SPServiceInstance | where{$_.GetType().Name -eq "AppManagementServiceInstance" -or $_.GetType().Name -eq "SPSubscriptionSettingsServiceInstance"}

$account = Get-SPManagedAccount "sharepoint\vito"

$appPoolSubSvc = New-SPServiceApplicationPool -Name SettingsServiceAppPool -Account $account

$appPoolSubSvc = Get-SPServiceApplicationPool -Identity SettingsServiceAppPool

$appPoolAppSvc = New-SPServiceApplicationPool -Name AppServiceAppPool -Account $account

$appPoolAppSvc = Get-SPServiceApplicationPool -Identity AppServiceAppPool

//$account = dbcreator permission on sqlserver master db
$appSubSvc = New-SPSubscriptionSettingsServiceApplication –ApplicationPool $appPoolSubSvc –Name SettingsServiceApp –DatabaseName SettingsServiceDB
$proxySubSvc = New-SPSubscriptionSettingsServiceApplicationProxy –ServiceApplication $appSubSvc
$appAppSvc = New-SPAppManagementServiceApplication -ApplicationPool $appPoolAppSvc -Name AppServiceApp -DatabaseName AppServiceDB
$proxyAppSvc = New-SPAppManagementServiceApplicationProxy -ServiceApplication $appAppSvc
Set-SPAppSiteSubscriptionName -Name "app" -Confirm:$false

Fonctionnalités SharePoint 2013: SkyDrive Pro ... OneDrive

2014-04-25T10:48:00.001+02:00

Introduction

La nouvelle fonctionnalité SharePoint 2013 pour la synchronisation des donnés.

Dans l article suivante nous parlerons de Skydrive pro et nous ne parlerons ni de skydrive ni Dropbox ni de la bibliothèque des documentés sur les sites personnels SharePoint ...

Ces choses n ont rien en commun et il ne faut pas les mélanger

Skydrive Pro -OneDrive

SkyDrive Pro est un service Windows.

SkyDrive Pro n'est pas lié à SharePoint, mais plutôt à Office 2013 et récemment disponible pour le téléchargement indépendant.

Si SkyDrive Pro est installé sur votre ordinateur ( il n'est pas un composant serveur, mais client ) vous pourrez afficher un lien "SYNC" sur toutes les pages de toutes les bibliothèques SharePoint ( et non uniquement de la bibliothèque du site personnel ) pour démarrer le service Windows de synchronisation installé sur votre ordinateur appelé SkyDrive Pro - OneDrive

La synchronisation peut être aussi démarrée directement à partir du service installé localement sur propre ordinateur.

PowerShell: Redémarre tout le service SharePoint Timer sur tous les serveurs de farm

2014-04-25T10:24:00.000+02:00

$job = Get-SPTimerJob job-timer-recycle

$job.RunNow()

Récupère le correlationID du processus SharePoint en cours

2014-04-25T10:22:00.000+02:00

public class Correlation
{
[DllImport("advapi32.dll")]
private static extern uint EventActivityIdControl(uint controlCode, ref Guid activityId);
public const uint EVENT_ACTIVITY_CTRL_GET_ID = 1;
public static string GetID()
{
Guid g = Guid.Empty;
EventActivityIdControl(EVENT_ACTIVITY_CTRL_GET_ID, ref g);
return g.ToString();
}
}

Array.prototype.unique and count

2014-04-25T10:20:00.000+02:00

Array.prototype.unique = function() {

var o = {}, i, l = this.length, r = [];

for(i=0; i<l;i+=1)

if(!o[this[i]]) o[this[i]] = {"key": this[i], "value":1};

else o[this[i]] = {"key": this[i], "value":o[this[i]].value+1};

for(i in o)

r.push({"key": o[i].key, "value": o[i].value});

return r;

};

Désassembler .net ?

2014-04-07T17:35:00.001+02:00

http://ilspy.net/

Power Shell ISE Custom Color

2014-04-02T15:34:00.000+02:00

Exécuter la comande suivante pour connaittre le percour du fichier des paramétrages personal:

$profile

Resultat:

C:\Users\Vito\Documents\WindowsPowerShell\Microsoft.PowerShellISE_profile.ps1

Si vous aviez un paramétrage par default, vous ne trouverez le fichier indiqué et vous serez obligés de le creer.

Créer/Modifier le fichier personel dans le parcour indiqué avec le contenu suivante:

# fonts
$psISE.Options.FontName = 'Consolas'
$psISE.Options.FontSize = 16
# output pane
$psISE.Options.OutputPaneBackgroundColor = '#FF2E3436'
$psISE.Options.OutputPaneTextBackgroundColor = '#FF2E3436'
$psISE.Options.OutputPaneForegroundColor = '#FFFFFFFF'
# command pane
$psISE.Options.CommandPaneBackgroundColor = '#FF2E3436'
# script pane
$psISE.Options.ScriptPaneBackgroundColor = '#FF2E3436'
# tokens
$psISE.Options.TokenColors['Command'] = '#FFFFFF60'
$psISE.Options.TokenColors['Unknown'] = '#FFFFFFFF'
$psISE.Options.TokenColors['Member'] = '#FFFFFFFF'
$psISE.Options.TokenColors['Position'] = '#FFFFFFFF'
$psISE.Options.TokenColors['GroupEnd'] = '#FFFFFFFF'
$psISE.Options.TokenColors['GroupStart'] = '#FFFFFFFF'
$psISE.Options.TokenColors['LineContinuation'] = '#FFFFFFFF'
$psISE.Options.TokenColors['NewLine'] = '#FFFFFFFF'
$psISE.Options.TokenColors['StatementSeparator'] = '#FFFFFFFF'
$psISE.Options.TokenColors['Comment'] = '#FFAEAEAE'
$psISE.Options.TokenColors['String'] = '#FF00D42D'
$psISE.Options.TokenColors['Keyword'] = '#FFFFDE00'
$psISE.Options.TokenColors['Attribute'] = '#FF84A7C1'
$psISE.Options.TokenColors['Type'] = '#FF84A7C1'
$psISE.Options.TokenColors['Variable'] = '#FF00D42D'
$psISE.Options.TokenColors['CommandParameter'] = '#FFFFDE00'
$psISE.Options.TokenColors['CommandArgument'] = '#FFFFFFFF'
$psISE.Options.TokenColors['Number'] = '#FF98FE1E'

Import Powershell Service de métadonnées gérées

2014-03-19T13:05:00.003+01:00

add-pssnapin Microsoft.SharePoint.Powershell -ErrorAction SilentlyContinue
$filepath = "\\blablabla\MetaData.bak"
$taxSession = Get-SPTaxonomySession -Site "http://Sharepoint.fr/sites/testSite"
# Application ID$mmsAppId= $taxSession.TermStores[0].ID
#Proxy service ID$mmsproxy = Get-SPServiceApplicationProxy | ? { $_..name -eq "Service de métadonnées gérées" }
Import-SPMetadataWebServicePartitionData -Identity $mmsAppId -ServiceProxy $mmsproxy -Path $filepath -OverwriteExisting;

A Noter:
L'utilisateur doit avoir le droit de "BulkAdmin" sur le server SQL

Fonctionnalités SharePoint 2013: WMSA - Work Management Service Application

2014-02-21T14:14:00.004+01:00

Introduction

Service Application introduit avec la dernière version de SharePoint 2013. Un Service qui permet de regrouper des tâches à partir des différents sources dans une location centralisée:

Les utilisateurs ont la possibilité de visualiser et contrôler leurs listes des tâches
Les tâches sont disponibles dans la cache du site personnel de l'utilisateur
Les tâches sont synchronisées avec Outlook et pourront être visualisées et modifiées avec un accès direct via ce dernier
Les tâches sont regroupées à partir de Exchange, Project Manager, et SharePoint
Le service est basé sur un "Provider Model", donc un système ouvert qui peux être intégré dans le futur

Le service est normalement utilisé comme part intégrante de chaque My Site / Newsfeed.

Important

Le Search Service Application doit être paramétré et activé. En effet, le service WMA est basé sur les résultats du service de recherche.

Donner de user policy sur l application web au WMA
Donner des permissions de WSS_Content_Application_Pools sur le config database au WMA account
Donner des permissions de SPDataAccess sur le content database au WMA account

# Add the managed account to the SPDataAccess database role in SharePoint content database$w = Get-SPWebApplication -Identity $url $W.GrantAccessToProcessIdentity("domain\ServiceAccount")

Les tâches sont archivées dans une liste cachée "WmaAggregatorList_User" sur le site personnel de chaque utilisateur

Exchange Server

Pour avoir la synchronisation avec les tâches stockées sur Exchange Server est nécessaire établir une OAuth Trust and Service Permission et donc exécuter sur le serveur Exchange le script Powershell dans la directory : "C:\Program Files\Microsoft\Exchange Server\V15\Scripts"

.\Configure-EnterprisePartnerApplication.ps1 -ApplicationType Sharepoint -AuthMetadataUrl https://<SP_FQDN>/_layouts/15/metadata/json/1

<SP_FQDN> est l URL de la collection de site SharePoint

Erreur recurrente : “We are having trouble refreshing your tasks”

Le WMA doit avoir le même compte de l application web
Le WMA compte doit avoir le Full Control permission sur le User Profile Service
La tâche content type doit être le Default Content Type de la liste
Associé le WMA service au proxy groupe de la web application

Update taxonomy field Process Batch Data TaxonomyFieldValueCollection

2013-11-07T10:46:00.004+01:00

public static string XmlToUpdate(List<XmlDataDoc> lstKeyValues, string InternalColmnName, string listGuid, bool isDocLibrary)
        {
            StringBuilder methodBuilder = new StringBuilder();
            string batchFormat =
                "<?xml version=\"1.0\" encoding=\"UTF-8\"?>" +
                "<ows:Batch OnError=\"Continue\">{0}</ows:Batch>";
            string methodFormat = "<Method ID=\"{0}\">" +
                "<SetList>{1}</SetList>" +
                "<SetVar Name=\"Cmd\">Save</SetVar>" +
                "<SetVar Name=\"ID\">{2}</SetVar>" +
                "<SetVar Name=\"urn:schemas-microsoft-com:office:office#{3}\">{4}</SetVar>" +

//Requiredf only for Document Library
((isDocLibrary) ? "<SetVar Name=\"owsfileref\">{5}</SetVar>" : "") +

   "</Method>";

              foreach (XmlDataDoc KeyValue in lstKeyValues)
            {
                methodBuilder.AppendFormat(methodFormat, KeyValue.ID, listGuid, KeyValue.ID, InternalColmnName, KeyValue.Value, KeyValue.RelativeUrl);
            }
            return string.Format(batchFormat, methodBuilder.ToString());
        }

        public static string XmlToNew(List<Dictionary<string, string>> lstColNameEtValue, string listGuid)
        {
            string batchFormat =
                "<?xml version=\"1.0\" encoding=\"UTF-8\"?>" +
                "<ows:Batch OnError=\"Continue\">{0}</ows:Batch>";
            StringBuilder methodFormat = new StringBuilder();
            foreach (Dictionary<string, string> items in lstColNameEtValue)
            {
                methodFormat.Append("<Method ID=\"LaunchMeta\">" +
                    "<SetList>" + listGuid + "</SetList>" +
                    "<SetVar Name=\"Cmd\">Save</SetVar>" +
                    "<SetVar Name=\"ID\">New</SetVar>");
                foreach (KeyValuePair<string, string> ColNameEtValue in items)
                {
                    methodFormat.Append("<SetVar Name=\"urn:schemas-microsoft-com:office:office#" + ColNameEtValue.Key + "\">" + ColNameEtValue.Value + "</SetVar>");
                }
                methodFormat.Append("</Method>");
            }
            return string.Format(batchFormat, methodFormat.ToString());
        }

public static string TaxoCollToXmlInput(TaxonomyFieldValueCollection TaxoColl)
        {
            string metaList = string.Empty;
            foreach (TaxonomyFieldValue itm in TaxoColl)
            {
                metaList += itm.WssId + ";#" + itm.Label + "|" + itm.TermGuid + ";";
            }
            return metaList;
        }
    }

    public class XmlDataDoc
    {
        public int ID { get; set; }
//item.file.RelativeUrl not item.url
        public string RelativeUrl { get; set; }
        public string Value { get; set; }
    }
}

Vérification de la lecture du contenu

2013-02-08T13:46:00.002+01:00

Chargement du contenu dans le DIV à partir d'une page html

WebClient client = new WebClient();
String htmlCode = client.DownloadString("http://localhost:18995/Content/ContentPage.html");
textAcceptation.Controls.Add(new LiteralControl(htmlCode));

Vérification de la lecture du contenu

$(".AcknowledgeOuterDiv").scroll(function () {
var outerDiv = $(this);
var innerDiv = $(">.AcknowledgeInnerDiv", $(this));
var ScrollMod = 1;
if (outerDiv.offset().top < innerDiv.outerHeight()) {
ScrollMod = -1;
}
var innerOuterHeight = innerDiv.outerHeight();
var boxHeight = outerDiv.height();
var boxOffsetTop = outerDiv.offset().top;

if (Math.ceil(Math.abs(boxHeight) - innerDiv.offset().top + boxOffsetTop + 1) >= innerOuterHeight) {
$("#CheckId").attr("disabled", false);
$(this).unbind("scroll");
}
else {
$("#CheckId").attr("disabled", true);
}

});

*I have read and understand the above disclaimer.

Sharepoint 2013: from app to host

2013-01-25T00:12:00.000+01:00

E ora Sharepoint 2013, accediamo al nostro sharepoint host a partire da un app su office 365

var hostweburl;

var appweburl;

function sharePointReady() {

// retrieve passed app web/host web URLs..

hostweburl = decodeURIComponent($.getUrlVar("SPHostUrl"));

appweburl = decodeURIComponent($.getUrlVar("SPAppWebUrl"));

loadDependentScripts();

}

function loadDependentScripts() {

var scriptbase = hostweburl + "/_layouts/15/";

// Load the js files and continue to the successHandler

$.getScript(scriptbase + "SP.Runtime.js",

function () {

$.getScript(scriptbase + "SP.js",

function () { $.getScript(scriptbase + "SP.RequestExecutor.js", getAllHostWebPropsUsingREST); }

);

}

);

}

function getAllHostWebPropsUsingREST() {

var executor;

// although we're fetching data from the host web, SP.RequestExecutor gets initialized with the app web URL..

executor = new SP.RequestExecutor(appweburl);

executor.executeAsync(

{

url:

appweburl +

"/_api/SP.AppContextSite(@target)/web/?@target='" + hostweburl + "'",

method: "GET",

headers: { "Accept": "application/json; odata=verbose" },

success: onGetAllHostWebPropsUsingRESTSuccess,

error: onGetAllHostWebPropsUsingRESTFail

}

);

}

function onGetAllHostWebPropsUsingRESTSuccess(data) {

var jsonObject = JSON.parse(data.body);

// note that here our jsonObject.d object (representing the web) has ALL properties because

// we did not select specific ones in our REST URL. However, we're just displaying the web title here..

$('#hostWebTitle').text(jsonObject.d.Title);

}

function onGetAllHostWebPropsUsingRESTFail(data, errorCode, errorMessage) {

alert('Failed to get host site. Error:' + errorMessage);

}

// jQuery plugin for fetching querystring parameters..

jQuery.extend({

getUrlVars: function () {

var vars = [], hash;

var hashes = window.location.href.slice(window.location.href.indexOf('?') + 1).split('&');

for (var i = 0; i < hashes.length; i++) {

hash = hashes[i].split('=');

vars.push(hash[0]);

vars[hash[0]] = hash[1];

}

return vars;

},

getUrlVar: function (name) {

return jQuery.getUrlVars()[name];

}

});

The content type is in use

2012-11-07T16:19:00.002+01:00

using System;
using System.Collections.Generic;
using Microsoft.SharePoint;

namespace Test
{
   class ConsoleApp
   {
      staticvoid Main(string[] args)
      {
         using (SPSite siteCollection = new SPSite("http://localhost"))
         {
            using (SPWeb webSite = siteCollection.OpenWeb())
            {
               // Get the obsolete content type.
               SPContentType obsolete = webSite.ContentTypes["Test"];

               // We have a content type.if (obsolete != null)
               {
                  IList usages = SPContentTypeUsage.GetUsages(obsolete);

                  // It is in use.if (usages.Count > 0)
                  {
                     Console.WriteLine("The content type is in use in the following locations:");
                     foreach (SPContentTypeUsage usage in usages)
                        Console.WriteLine(usage.Url);
                  }

                  // The content type is not in use.else
                  {

                     // Delete it.
                     Console.WriteLine("Deleting content type {0}...", obsolete.Name);
                     webSite.ContentTypes.Delete(obsolete.Id);
                  }
               }

               // No content type found.else
               {
                  Console.WriteLine("The content type does not exist in this site collection.");
               }
            }
         }
         Console.Write("\nPress ENTER to continue...");
         Console.ReadLine();
      }
   }
}

FBA sharepoint

2012-11-07T11:18:00.000+01:00

http://donalconlon.wordpress.com/2010/02/23/configuring-forms-base-authentication-for-sharepoint-2010-using-iis7/
Utenza Database: SPS.Farm.Admin
Nome database: SharePoint_FBA
Membership Provider: FBAMembershipProvider
Role Manager: FBARoleProvider
1. Accededuto al db loggandoci con SPS.Farm.Admin
2. Lanciato c:\windows\microsoft.net\framework\v2.0.50727\aspnet_reqsql.exe e viene aperta la GUI di creazione
3. Creato database con windows auth

1.1 Creazione web application

1. Acceduto alla central admin
2. New web application sulla porta 80
3. Scelta la Claim Based e settati I flag ntlm e fba
4. Settati fba
5. Settato utente app pool
6. Accettati i default tranne service application connections e excel service (scelte le ultime 4)
7. Nome database 0

1.2 Configurazione FBA

1. Seguiti i passi del doc in allegato ed in particolare:
2. Lanciare IIS Manager
3. Selezionare la webapp (e poi rifare l’operazione anche nel central admin site e sottosito securityTockenService (secure store web service)come indicato nel punto 2 del documento allegato)

4. Connection string
a. Add
b. Nome: FbaConnectionString
c. Configurati i parametri (use windows security)
5. .net users
6. Selezionati e configurati i .net roles e membership
a. In particolare settato a false require security answer

7. Cliccare su .net roles
Settare FBARoleProvider come default

8. Creati i ruoli StandardFBAUsers e AdminFBAUsers (no in central admin e in tocken security)

9. Creato l’utente SPS.FBA.Admin

10. Set Authentication
SharePoint should have done this when you created the web application, but let’s confirm. From the web application home page in IIS Manager, select Authentication under the IIS section. Confirm that the web application has both Integrated and Forms enabled.
11. ATTENZIONE ALLA NOTA SEGUENTE!!!
Ricordarsi di risettare come default c
12. In order for you to use IIS Manager to manage your SQL users, you need to set the default provider to our Forms provider, i.e. FBAMembershipProvider. In order for it to work we need to set it to the SharePoint claims provider. Go back to .NET Users and reset the default provider to “i” which is for the Microsoft.SharePoint.Administration.Claims.SPClaimsAuthMembershipProvider
You should also check the default Role Provider for the web application and ensure that is set to “c”. If this is set to the SQL provider that you created, you will get an unexpected error after you logon.

DisableLoopbackCheck and SharePoint

2012-09-13T13:25:00.001+02:00

Sharepoint access denied with hostname configuration

Add this registry entry by PowerShell

New-ItemProperty HKLM:\System\CurrentControlSet\Control\Lsa -Name "DisableLoopbackCheck" -value "1" -PropertyType dword

REFERENCE

http://support.microsoft.com/kb/896861/en-us