<script type="text/javascript">
document.getElementById('onetIdTopNavBarContainer').style.display = 'none';
document.getElementById('LeftNavigationAreaCell').style.display = 'none';
</script>
[System.Reflection.Assembly]::LoadWithPartialName(“Microsoft.Sharepoint”)
$siteURL = "https://sharepoint2007portal"
$spSite = new-object Microsoft.Sharepoint.SPSite($siteUrl)
$spWeb = $spSite.RootWeb
Foreach($node in ($spWeb.Navigation.TopNavigationBar))
{
if ($node.Title -eq "MyHeading")
{
write-host "Node: " $node.Title
//this will delete the node and its child
$node.Delete()
write-host "Deleted successfully."
}
}
$spWeb.Dispose()
write-host "Done."
<Query>
<SoapAction>http://schemas.microsoft.com/sharepoint/soap/GetListItems</SoapAction>
<Method Namespace="http://schemas.microsoft.com/sharepoint/soap/" Name="GetListItems">
<Parameters>
<Parameter Name="listName">
<DefaultValue>List9</DefaultValue>
</Parameter>
<Parameter Name="viewName">
<DefaultValue></DefaultValue>
<ViewFields>
<FieldRef Name="Title" />
<FieldRef Name="Choice" />
</ViewFields>
</Parameter>
</Parameters>
</Method>
<ElementPath IgnoreNamespaces="True">*</ElementPath>
</Query>
SELECT TOP 100
Webs.FullUrl As SiteUrl,
Webs.Title 'Document/List Library Title',
DirName + '/' + LeafName AS 'Document Name',
COUNT(Docversions.version)AS 'Total Version',
SUM(CAST((CAST(CAST(Docversions.Size as decimal(10,2))/1024 As
decimal(10,2))/1024) AS Decimal(10,2)) ) AS 'Total Document Size (MB)',
CAST((CAST(CAST(AVG(Docversions.Size) as decimal(10,2))/1024 As
decimal(10,2))/1024) AS Decimal(10,2)) AS 'Avg Document Size (MB)'
FROM Docs INNER JOIN DocVersions ON Docs.Id = DocVersions.Id
INNER JOIN Webs On Docs.WebId = Webs.Id
INNER JOIN Sites ON Webs.SiteId = SItes.Id
WHERE
Docs.Type <> 1
AND (LeafName NOT LIKE '%.stp')
AND (LeafName NOT LIKE '%.aspx')
AND (LeafName NOT LIKE '%.xfp')
AND (LeafName NOT LIKE '%.dwp')
AND (LeafName NOT LIKE '%template%')
AND (LeafName NOT LIKE '%.inf')
AND (LeafName NOT LIKE '%.css')
GROUP BY Webs.FullUrl, Webs.Title, DirName + '/' + LeafName
ORDER BY 'Total Version' desc, 'Total Document Size (MB)' desc
<script type="text/javascript" src="/Scripts/jquery-1.8.1.min.js"></script>
<script type="text/javascript">
var strProject = "";
var strProjectStatus = "";
function PreSaveItem()
{
strProject = document.getElementById('ctl00_m_g_f2d95e24_befb_49d2_b15f_823d71c9c758_ctl00_ctl04_ctl00_ctl00_ctl00_ctl04_ctl00_ctl00_TextField').value;
strProjectStatus = document.getElementById('ctl00_m_g_f2d95e24_befb_49d2_b15f_823d71c9c758_ctl00_ctl04_ctl01_ctl00_ctl00_ctl04_ctl00_DropDownChoice').value;
GetProjectID();
return true;
}
function GetProjectID(){
var soapEnv = "<soap:Envelope xmlns:soap='http://schemas.xmlsoap.org/soap/envelope/'> \
<soap:Body> \
<GetListItems xmlns='http://schemas.microsoft.com/sharepoint/soap/'> \
<listName>Teams</listName> \
<query><Query><Where><Eq><FieldRef Name='Project'/><Value Type='Text'>"+ strProject +"</Value> </Eq></Where></Query></query> \
<viewFields> \
<ViewFields> \
<FieldRef Name='ID' /> \
<FieldRef Name='Title' /> \
</ViewFields> \
</viewFields> \
<rowLimit>99999</rowLimit> \
<queryOptions xmlns:SOAPSDK9='http://schemas.microsoft.com/sharepoint/soap/' ><QueryOptions/> \
</queryOptions> \
</GetListItems> \
</soap:Body> \
</soap:Envelope>";
jQuery.ajax({
url: "/itsglobal/_vti_bin/lists.asmx",
type: "POST",
dataType: "xml",
data: soapEnv,
complete: ResultMethod,
contentType: "text/xml; charset=\"utf-8\""
});
}
function ResultMethod(xData, status)
{
if (status=="success")
{
var oldbatch = "";
$(xData.responseXML).find("z\\:row").each(function()
{
oldbatch = AddTobatch(oldbatch, $(this).attr("ows_ID"));
});
UpdateTeamItem(oldbatch);
}
}
function AddTobatch(oldbatch, itemId)
{
//Specify the batch query
var _batch = "<Method ID='1' Cmd='Update'><Field Name='ID'>" + itemId +"</Field><Field Name='ProjectStatus'>"+ strProjectStatus +"</Field></Method>";
oldbatch = oldbatch + _batch;
return oldbatch;
}
function UpdateTeamItem(batch)
{
var soapEnv = "<?xml version=\'1.0\' encoding=\'utf-8\'?> \
<soap:Envelope xmlns:xsi=\'http://www.w3.org/2001/XMLSchema-instance\' \
xmlns:xsd=\'http://www.w3.org/2001/XMLSchema\' \
xmlns:soap='http://schemas.xmlsoap.org/soap/envelope/\'> \
<soap:Body> \
<UpdateListItems xmlns='http://schemas.microsoft.com/sharepoint/soap/'> \
<listName>Teams</listName> \
<updates> \
<Batch OnError='Continue'>" + batch + "</Batch> \
</updates> \
</UpdateListItems> \
</soap:Body> \
</soap:Envelope>";
$.ajax({
url: "/itsglobal/_vti_bin/lists.asmx",
beforeSend: function(xhr) { xhr.setRequestHeader("SOAPAction", "http://schemas.microsoft.com/sharepoint/soap/UpdateListItems");
},
type: "POST",
dataType: "xml",
data: soapEnv,
complete: updateResult,
contentType: "text/xml; charset=\"utf-8\""
});
}
function updateResult(xData, status) {
if (status != 'success' )
alert("Update Project Status in Teams library failed");
}
</script>
<script type="text/javascript" src="/Scripts/jquery-1.8.1.min.js"></script>
<script type="text/javascript">
//This function will call when OK button will be pressed on a List's default form (e.g. EditItem.aspx).
function PreSaveItem()
{
var project = "Project A";
GetProjectID(project);
return true;
}
function GetProjectID(project){
var soapEnv = "<soap:Envelope xmlns:soap='http://schemas.xmlsoap.org/soap/envelope/'> \
<soap:Body> \
<GetListItems xmlns='http://schemas.microsoft.com/sharepoint/soap/'> \
<listName>Teams</listName> \
<query><Query><Where><Eq><FieldRef Name='Project'/><Value Type='Text'>"+ project +"</Value> </Eq></Where></Query></query> \
<viewFields> \
<ViewFields> \
<FieldRef Name='ID' /> \
<FieldRef Name='Title' /> \
</ViewFields> \
</viewFields> \
<rowLimit>99999</rowLimit> \
<queryOptions xmlns:SOAPSDK9='http://schemas.microsoft.com/sharepoint/soap/' ><QueryOptions/> \
</queryOptions> \
</GetListItems> \
</soap:Body> \
</soap:Envelope>";
jQuery.ajax({
url: "/itsglobal/_vti_bin/lists.asmx",
type: "POST",
dataType: "xml",
data: soapEnv,
complete: ResultMethod,
contentType: "text/xml; charset=\"utf-8\""
});
}
function ResultMethod(xData, status)
{
if (status=="success")
{
alert(status);
$(xData.responseXML).find("z\\:row").each(function()
{
alert($(this).attr("ows_ID"));
});
}
}
</script>
<script src="/Scripts/jquery-1.8.0.min.js" type="text/javascript"></script>
<script type="text/javascript">
function LoadFeed()
{
var varFeedURL = new Array();
varFeedURL[0] = "http://feeds.bbci.co.uk/news/business/rss.xml";
varFeedURL[1] = "http://www.ft.com/rss/home/uk";
varFeedURL[2] = "http://www.ft.com/rss/home/us";
for (i = 0; i < varFeedURL.length; i++)
{
$.get(varFeedURL[i], function(data) {
var $xml = $(data);
$xml.find("item").each(function() {
var $this = $(this),
item = {
title: $this.find("title").text(),
link: $this.find("link").text(),
description: $this.find("description").text(),
pubDate: $this.find("pubDate").text()
}
//Show only Today's Items
var a = new Date(item.pubDate);
var b = new Date(); //Today's Date
var msDateA = Date.UTC(a.getFullYear(), a.getMonth()+1, a.getDate());
var msDateB = Date.UTC(b.getFullYear(), b.getMonth()+1, b.getDate());
if (parseFloat(msDateA) == parseFloat(msDateB))
{
var content = document.getElementById('content');
content.appendChild(document.createTextNode(item.title));
content.appendChild(document.createElement('br'));
content.appendChild(document.createTextNode(item.description));
content.appendChild(document.createElement('br'));
content.appendChild(document.createTextNode(item.link));
content.appendChild(document.createElement('br'));
content.appendChild(document.createElement('hr'));
CreateNewItem(item.title, item.description, item.link);
}
});
});
}
alert('Done');
}
function CreateNewItem(varTitle, varDescription, varLink)
{
var batch =
"<Batch OnError=\"Continue\"> \
<Method ID=\"1\" Cmd=\"New\"> \
<Field Name=\"Title\">" + varTitle + "</Field> \
<Field Name=\"Description\">" + varDescription + "</Field> \
<Field Name=\"Link\">" + varLink + "</Field> \
</Method> \
</Batch>";
var soapEnv =
"<?xml version=\"1.0\" encoding=\"utf-8\"?> \
<soap:Envelope xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" \
xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\" \
xmlns:soap=\"http://schemas.xmlsoap.org/soap/envelope/\"> \
<soap:Body> \
<UpdateListItems xmlns=\"http://schemas.microsoft.com/sharepoint/soap/\"> \
<listName>RSSData</listName> \
<updates> \
" + batch + "</updates> \
</UpdateListItems> \
</soap:Body> \
</soap:Envelope>";
$.ajax({
url: "http://portalstg.amr.kworld.kpmg.com/_vti_bin/lists.asmx",
beforeSend: function(xhr) {
xhr.setRequestHeader("SOAPAction",
"http://schemas.microsoft.com/sharepoint/soap/UpdateListItems");
},
type: "POST",
dataType: "xml",
data: soapEnv,
complete: processResult,
contentType: "text/xml; charset=utf-8"
});
}
function processResult(xData, status) {
//alert(status);
}
</script>
<input id="btnGo" onclick="LoadFeed()" type="button" value="Get RSS Data" />
public class SharePointManagement
{
ViewsService.Views objViewsService = new SPViewsService.ViewsService.Views();
ListsService.Lists objListsService = new SPViewsService.ListsService.Lists();
string strSiteURL = "http://mySharepointServer:1100";
string strUserName = "username";
string strDomain = "us";
string strPassword = "password";
string strListName = "Announcements";
string strQuery = "";
string strViewFields = "";
string strQueryOptions = "";
ArrayList lstViewID = new ArrayList();
public void GetViewQuery(string strListName)
{
try
{
#region Source URL
//get the lists for the Source URL
this.objViewsService.Url = this.strSiteURL.Trim('/') + "/_vti_bin/views.asmx";
//get the domain
if (this.strUserName.IndexOf("\\") > 0)
{
this.strDomain = this.strUserName.Split("\\".ToCharArray())[0];
this.strUserName = this.strUserName.Split("\\".ToCharArray())[1];
}
this.objViewsService.Credentials = new System.Net.NetworkCredential(this.strUserName, this.strPassword, this.strDomain);
#endregion
System.Xml.XmlNode xnAllView = this.objViewsService.GetViewCollection(strListName);
foreach (System.Xml.XmlNode node in xnAllView)
{
if (node.Name == "View")
{
this.lstViewID.Add(node.Attributes["Name"].Value);
}
}
//Get the First View
System.Xml.XmlNode xnViewData = this.objViewsService.GetView(this.strListName, lstViewID[0].ToString());
foreach (System.Xml.XmlNode node in xnViewData)
{
if (node.Name == "Query")
{
this.strQuery = node.InnerXml;
}
if (node.Name == "ViewFields")
{
this.strViewFields = node.InnerXml;
}
}
}
catch (System.Exception exp)
{
MessageBox.Show(exp.ToString());
}
}
public void GetViewData()
{
DataSet ds = new DataSet();
DataTable dt = new DataTable();
try
{
#region Source URL
//get the lists for the Source URL
this.objListsService.Url = this.strSiteURL.Trim('/') + "/_vti_bin/lists.asmx";
//get the domain
if (this.strUserName.IndexOf("\\") > 0)
{
this.strDomain = this.strUserName.Split("\\".ToCharArray())[0];
this.strUserName = this.strUserName.Split("\\".ToCharArray())[1];
}
this.objListsService.Credentials = new System.Net.NetworkCredential(this.strUserName, this.strPassword, this.strDomain);
#endregion
//get the Data from the List
System.Xml.XmlDocument xdListData = new System.Xml.XmlDocument();
System.Xml.XmlNode xnQuery = xdListData.CreateElement("Query");
System.Xml.XmlNode xnViewFields = xdListData.CreateElement("ViewFields");
System.Xml.XmlNode xnQueryOptions = xdListData.CreateElement("QueryOptions");
//*Use CAML query*/
xnQuery.InnerXml = this.strQuery;
xnViewFields.InnerXml = this.strViewFields;
xnQueryOptions.InnerXml = this.strQueryOptions;
System.Xml.XmlNode xnListData = this.objListsService.GetListItems(this.strListName, null, xnQuery, xnViewFields, null, xnQueryOptions, null);
StringReader sr = new StringReader(xnListData.OuterXml.Replace("ows_", ""));
ds.ReadXml(sr);
return dt;
}
catch (System.Exception exp)
{
MessageBox.Show(exp.ToString());
return dt;
}
}
}
using System;
using System.Collections.Generic;
using System.Text;
using System.Configuration;
using System.Xml;
using System.IO;
namespace ELLP_Content
{
class Program
{
static void Main(string[] args)
{
SharePointManagement objSPManagement = new SharePointManagement();
objSPManagement.GetListContent();
}
}
public class SharePointManagement
{
MOSSListsService.Lists objListService = new ELLP_Content.MOSSListsService.Lists();
public void GetListContent()
{
try
{
string strSiteURL = ConfigurationSettings.AppSettings["SiteURL"];
string strUserName = ConfigurationSettings.AppSettings["Login"];
string strDomain = string.Empty;
string strPassword = ConfigurationSettings.AppSettings["Password"];
string strListName = ConfigurationSettings.AppSettings["List"];
#region Source URL
//get the lists for the Source URL
objListService.Url = strSiteURL.Trim('/') + "/_vti_bin/lists.asmx";
//get the domain
if (strUserName.IndexOf("\\") > 0)
{
strDomain = strUserName.Split("\\".ToCharArray())[0];
strUserName = strUserName.Split("\\".ToCharArray())[1];
}
objListService.Credentials = new System.Net.NetworkCredential(strUserName, strPassword, strDomain);
#endregion
//get the Data from the List
System.Xml.XmlDocument xdListData = new System.Xml.XmlDocument();
System.Xml.XmlNode xnQuery = xdListData.CreateElement("Query");
System.Xml.XmlNode xnViewFields = xdListData.CreateElement("ViewFields");
System.Xml.XmlNode xnQueryOptions = xdListData.CreateElement("QueryOptions");
//*Use CAML query*/
xnQuery.InnerXml = "<Where><Neq><FieldRef Name=\"Exclude_x0020_From_x0020_Country\" /><Value Type=\"Boolean\">0</Value></Neq></Where>";
xnQueryOptions.InnerXml = "<IncludeMandatoryColumns>FALSE</IncludeMandatoryColumns><DateInUtc>TRUE</DateInUtc>";
System.Xml.XmlNode xnListData = objListService.GetListItems(strListName, null, xnQuery, xnViewFields, null, xnQueryOptions, null);
foreach (System.Xml.XmlNode node in xnListData)
{
if (node.Name == "rs:data")
{
for (int i = 0; i < node.ChildNodes.Count; i++)
{
if (node.ChildNodes[i].Name == "z:row")
{
Console.WriteLine(node.ChildNodes[i].Attributes["ows_Title"].Value);
}
}
}
}
Console.ReadKey();
}
catch (System.Web.Services.Protocols.SoapException ex)
{
this.WriteLog("Message:\n" + ex.Message + "\nDetail:\n" + ex.Detail.InnerText + "\nStackTrace:\n" + ex.StackTrace);
}
}
private void WriteLog(string strLine)
{
string FilePath = Path.Combine(AppDomain.CurrentDomain.BaseDirectory, ConfigurationSettings.AppSettings["InputLog"]);
StreamWriter objFile;
if (!File.Exists(FilePath))
{
objFile = new StreamWriter(FilePath);
}
else
{
objFile = File.AppendText(FilePath);
}
objFile.WriteLine(DateTime.Now + "\\t" + strLine);
objFile.WriteLine();
objFile.Close();
}
}
}
namespace SilverlightApp
{
public partial class MainPage : UserControl
{
public MainPage()
{
InitializeComponent();
}
private void btnGo_Click(object sender, RoutedEventArgs e)
{
MessageBox.Show(this.txtMessage.Text);
}
}
}
<object type="application/x-silverlight-2" width="600" height="200">
<param name="source" value="SilverlightApp.xap"/>
<param name="minRuntimeVersion" value="3.0.40818.0" />
<param name="background" value="white" />
</object>
<iframe id="_sl_historyFrame" style="height:0px;width:0px;border:0px"></iframe>
private string _strPassword;
[Browsable(true),
Category("Parameters"),
DefaultValue(""),
WebBrowsable(true),
Personalizable(PersonalizationScope.Shared),
WebDisplayName("Password"),
Description("Network Password")]
public string strPassword
{
get
{
return _strPassword;
}
set
{
_strPassword = value;
}
}
private void GetItems(string strListName)
{
try
{
#region Connect to URL
this.m_objWSSListService.Url = this.cmbURL.Text.Trim('/') + "/_vti_bin/lists.asmx";
string sDomain = string.Empty;
string sUserName = this.txtLogin.Text.Trim();
if (sUserName.IndexOf("\\") > 0)
{
sDomain = sUserName.Split("\\".ToCharArray())[0];
sUserName = sUserName.Split("\\".ToCharArray())[1];
}
this.m_objWSSListService.Credentials = new System.Net.NetworkCredential(sUserName, this.txtPassword.Text.Trim(), sDomain);
#endregion
string sListName = strListName;
string SourceDocumentURL = "";
string strTempLocation = "C:\\Temp\\";
string strFileName = "";
System.Xml.XmlNode xnListSchema = m_objWSSListService.GetList(sListName);
//get the Data from the List
System.Xml.XmlDocument xdListData = new System.Xml.XmlDocument();
System.Xml.XmlNode xnQuery = xdListData.CreateElement("Query");
System.Xml.XmlNode xnViewFields = xdListData.CreateElement("ViewFields");
System.Xml.XmlNode xnQueryOptions = xdListData.CreateElement("QueryOptions");
System.Xml.XmlNode xnListData = m_objWSSListService.GetListItems(sListName, null, xnQuery, xnViewFields, null, xnQueryOptions);
if (!Directory.Exists(strTempLocation))
{
Directory.CreateDirectory(strTempLocation);
}
foreach (XmlNode outerNode in xnListData.ChildNodes)
{
if (outerNode.NodeType.Equals(System.Xml.XmlNodeType.Element))
{
foreach (XmlNode node in outerNode.ChildNodes)
{
if (node.NodeType.Equals(System.Xml.XmlNodeType.Element))
{
MessageBox.Show(node.Attributes.GetNamedItem("ows_Title").InnerText);
}
}
}
}
}
catch (System.Exception ex)
{
this.WriteLog(ex.ToString());
}
}
private void CreateFolder(string strPath, string strListName)
{
try
{
#region Connect to URL
this.m_objWSSListService.Url = this.cmbURL.Text.Trim('/') + "/_vti_bin/lists.asmx";
string sDomain = string.Empty;
string sUserName = this.txtLogin.Text.Trim();
if (sUserName.IndexOf("\\") > 0)
{
sDomain = sUserName.Split("\\".ToCharArray())[0];
sUserName = sUserName.Split("\\".ToCharArray())[1];
}
this.m_objWSSListService.Credentials = new System.Net.NetworkCredential(sUserName, this.txtPassword.Text.Trim(), sDomain);
#endregion
System.Xml.XmlDocument xmlDoc = new System.Xml.XmlDocument();
System.Xml.XmlElement Batch = xmlDoc.CreateElement("Batch");
Batch.SetAttribute("OnError", "Continue");
Batch.SetAttribute("ListVersion", "0");
string strBatch = "<method id="1" cmd="New">";
strBatch = strBatch + "<field name="ID">New</field>";
strBatch = strBatch + "<field name="FSObjType">1</field>";
strBatch = strBatch + "<field name="FileRef">" + strPath + "</field></method>";
Batch.InnerXml = strBatch;
XmlNode ndReturn = this.m_objWSSListService.UpdateListItems(strListName, Batch);
if (ndReturn.FirstChild.FirstChild.InnerText != "0x00000000")
{
this.WriteLog(ndReturn.InnerText);
}
this.WriteLog("Create Operation - List:" + strListName + " - Folder: " + strPath);
}
catch (System.Exception ex)
{
this.WriteLog(ex.ToString());
}
}
