Sharepointsintrabas

Ayuda a hacerlo fácil.

Update data source reference in Power View dashboard Sharepoint 2013

♦ septiembre 21, 2016 ♦ Deja un comentario

private void ModifyDashboardDataSourceReference(string CompanyId, string fileName, string myLibraryName, string dataConnection)
{

ReportingService2010 _reportServer = new ReportingService2010
{
Credentials =
new NetworkCredential(Utility.GetSuperUserByEnv(),
Utility.GetSuperUserPswByEnv(), Utility.GetUserDomainByEnv()),
Url = Utility.GetUrlAbsByEnv() + @»_vti_bin/ReportServer/ReportService2010.asmx»
};

var catalogitempath = string.Format(@»{0}sites/{1}/{2}/{3}»,
Utility.GetUrlAbsByEnv(), CompanyId, myLibraryName, fileName);

var dataSourceArray = _reportServer.GetItemDataSources(catalogitempath);

foreach (var dataSource in dataSourceArray)
{
if (!(dataSource.Item is DataSourceReference))
{
dataSource.Item = new DataSourceReference();
}

((DataSourceReference)dataSource.Item).Reference =dataConnection;
}
_reportServer.SetItemDataSources(catalogitempath, dataSourceArray);

}

Copy or Move element on the client context SP2013

♦ junio 27, 2016 ♦ Deja un comentario

public static void MoveElement(string sitrUrl, string sourceList, string destinationList, string listItemName)
{
var ctx = new ClientContext(sitrUrl);
ctx.Credentials = new NetworkCredential(@»xxxxx», «xxxxxx», «xxxxxx»);
var web = ctx.Web;
List list = ctx.Web.Lists.GetByTitle(sourceList);
CamlQuery camlQuery = new CamlQuery();
camlQuery.ViewXml = «<View><Query></Query><RowLimit>100</RowLimit></View>»;
ListItemCollection oListItem = list.GetItems(camlQuery);
ctx.Load(oListItem,
items => items.Include(
item => item.Id,
item => item.DisplayName,
item => item.HasUniqueRoleAssignments));
ctx.ExecuteQuery();
var listItem = oListItem.First(a => a.DisplayName == listItemName);
File myFile = listItem.File;
ctx.Load(myFile);
ctx.ExecuteQuery();
myFile.CopyTo(destinationUrl,true );
//myFile.MoveTo(destinationUrl, MoveOperations.Overwrite);
ctx.ExecuteQuery();
}