tag:blogger.com,1999:blog-85721202555175249952024-03-20T04:17:46.862-07:00Just another Sharepoint guySandeshhttp://www.blogger.com/profile/16230261794878311021noreply@blogger.comBlogger27125tag:blogger.com,1999:blog-8572120255517524995.post-16213958299273135702019-08-13T22:08:00.004-07:002019-08-13T22:09:29.046-07:00Upload zip file to azure blob storage<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="tr_bq">
<br /></div>
<br />
<blockquote class="tr_bq" style="text-align: left;">
<blockquote class="tr_bq">
CloudStorageAccount storageAccount = CloudStorageAccount.Parse("ConnectionString");<br /> // Create the blob client.<br /> CloudBlobClient blobClient = storageAccount.CreateCloudBlobClient();<br /><br /> // Retrieve reference to a previously created container.<br /> CloudBlobContainer container = blobClient.GetContainerReference("Container Name");<br /><br /> FileInfo zipFile = new FileInfo(@"C:\Documents\myfiles.zip");<br /> // Retrieve reference to a blob named "myblob".<br /><br /> CloudBlockBlob blockBlob = container.GetBlockBlobReference(zipFile.Name);<br /> // Upload the zip and store it in the blob<br /> using (FileStream fs = zipFile.OpenRead())<br /> blockBlob.UploadFromStream(fs);</blockquote>
</blockquote>
<div style="text-align: left;">
<br /></div>
</div>
Sandeshhttp://www.blogger.com/profile/16230261794878311021noreply@blogger.com0tag:blogger.com,1999:blog-8572120255517524995.post-67573749763438376332018-11-29T13:00:00.001-08:002018-11-29T13:00:20.474-08:00Check if the folder or file exists in Sharepoint C# CSOM<div dir="ltr" style="text-align: left;" trbidi="on">
var url = "/sites/sitecol/DocLib/FolderName;<br />
try<br />
{<br />
var file = ctx.Web.GetFileByServerRelativeUrl(url);<br />
ctx.Load(file);<br />
ctx.ExecuteQuery();<br />
}<br />
catch (ServerException ex) {<br />
<br />
if (ex.ServerErrorTypeName == "System.IO.FileNotFoundException") {<br />
}<br />
}</div>
Sandeshhttp://www.blogger.com/profile/16230261794878311021noreply@blogger.com0tag:blogger.com,1999:blog-8572120255517524995.post-24307550605890384312018-11-29T11:05:00.000-08:002018-11-29T11:06:06.512-08:00Error: Could not create SSL/TLS Secure channel<div dir="ltr" style="text-align: left;" trbidi="on">
Solution include<br />
<br />
<br />
<b> ServicePointManager.SecurityProtocol = SecurityProtocolType.Ssl3 | SecurityProtocolType.Tls | SecurityProtocolType.Tls11 | SecurityProtocolType.Tls12;
</b>
<br />
<br />
<br />
We have to make sure that the server and the client have common protocol support.<br />
<span style="background-color: white; color: #242729; font-family: "arial" , "helvetica neue" , "helvetica" , sans-serif; font-size: 15px;"><br /></span>
<span style="background-color: white; color: #242729; font-family: "arial" , "helvetica neue" , "helvetica" , sans-serif; font-size: 15px;"><br /></span>
<br />
<div>
<span style="background-color: white; color: #242729; font-family: "arial" , "helvetica neue" , "helvetica" , sans-serif; font-size: 15px;"><br /></span></div>
</div>
Sandeshhttp://www.blogger.com/profile/16230261794878311021noreply@blogger.com0tag:blogger.com,1999:blog-8572120255517524995.post-89602906508281811682017-09-23T15:05:00.000-07:002017-09-23T15:05:09.871-07:00Access SharePoint list across domain using CSOM SharePoint 2013<div dir="ltr" style="text-align: left;" trbidi="on">
var context;<br />
var hostweburl;<br />
var appweburl;<br />
var appContextSite;<br />
var list;<br />
var web;<br />
<br />
<br />
(function () {<br />
<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>$(document).ready(function () {<br />
SP.SOD.executeFunc('sp.js', 'SP.ClientContext', getUrl);<br />
});<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span> function getUrl () {<br />
hostweburl = getQueryStringParameter("SPHostUrl");<br />
appweburl = getQueryStringParameter("SPAppWebUrl");<br />
hostweburl = decodeURIComponent(hostweburl);<br />
appweburl = decodeURIComponent(appweburl);<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>alert("hostweburl: " + hostweburl);<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>alert("appweburl: " + appweburl);<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span><br />
var scriptbase = hostweburl + "/_layouts/15/"; <br />
$.getScript(scriptbase + "SP.Runtime.js",<br />
function () {<br />
$.getScript(scriptbase + "SP.js",<br />
function () { $.getScript(scriptbase + "SP.RequestExecutor.js", execOperation); }<br />
);<br />
}<br />
);<br />
event.preventDefault();<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>function execOperation() {<br />
context = new SP.ClientContext(appweburl);<br />
var factory =<br />
new SP.ProxyWebRequestExecutorFactory(<br />
appweburl<br />
);<br />
context.set_webRequestExecutorFactory(factory);<br />
appContextSite = new SP.AppContextSite(context, hostweburl);<br />
web = appContextSite.get_web();<br />
context.load(web);<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span><br />
list = web.get_lists().getByTitle("TestList");<br />
context.load(list);<br />
context.executeQueryAsync(onSuccess, onFail);<br />
}<br />
function onSuccess() {<br />
alert("List loaded Successfully"); <br />
}<br />
<br />
// This function is executed if the above call fails<br />
function onFail(sender, args) {<br />
alert( args.get_message());<br />
}<span class="Apple-tab-span" style="white-space: pre;"> </span><br />
}<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>function getQueryStringParameter(paramToRetrieve) {<br />
var params =<br />
document.URL.split("?")[1].split("&");<br />
for (var i = 0; i < params.length; i = i + 1) {<br />
var singleParam = params[i].split("=");<br />
if (singleParam[0] == paramToRetrieve)<br />
return singleParam[1];<br />
}<br />
}<br />
})();</div>
Sandeshhttp://www.blogger.com/profile/16230261794878311021noreply@blogger.com0tag:blogger.com,1999:blog-8572120255517524995.post-53840698584488830262015-11-18T12:04:00.001-08:002015-11-18T12:15:08.756-08:00App Structure<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgkVu8y1gDfk9IYHj3Cp9ZRu9NCBRH1RFV8cuPTon8eP0MVCd8OcmqH5l226qEhWg6aoih3KnhwKz2l8obiklmocc590Bx26Ft9XbxVet48rtKys3hEg_OMb7lGwF6Q3dDGppDVA0mgvkb6/s1600/Capture.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgkVu8y1gDfk9IYHj3Cp9ZRu9NCBRH1RFV8cuPTon8eP0MVCd8OcmqH5l226qEhWg6aoih3KnhwKz2l8obiklmocc590Bx26Ft9XbxVet48rtKys3hEg_OMb7lGwF6Q3dDGppDVA0mgvkb6/s1600/Capture.PNG" /></a></div>
<br /></div>
Sandeshhttp://www.blogger.com/profile/16230261794878311021noreply@blogger.com0tag:blogger.com,1999:blog-8572120255517524995.post-84627068627396980152015-06-02T20:20:00.004-07:002015-06-04T10:48:03.253-07:00SharePoint 2013 - Create an App to get lists using CSOM<div dir="ltr" style="text-align: left;" trbidi="on">
'use strict';<br />
<br />
var context = SP.ClientContext.get_current();<br />
var user = context.get_web().get_currentUser();<br />
var web = context.get_web();<br />
var list = web.get_lists();<br />
<br />
(function () {<br />
// This code runs when the DOM is ready and creates a context object which is<br />
// needed to use the SharePoint object model<br />
<br />
$(document).ready(function () {<br />
getListCount();<br />
});<br />
<br />
// This function prepares, loads, and then executes a SharePoint query to get<br />
// the current users information<br />
<br />
function getListCount() {<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>context.load(web);<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span>context.load(list);<br />
context.executeQueryAsync(onGetListCountSuccess, onGetListCountFail);<br />
}<br />
<br />
// This function is executed if the above call is successful<br />
// It replaces the contents of the 'message' element with the user name<br />
<br />
function onGetListCountSuccess() {<br />
<br />
var ernumerator = list.getEnumerator();<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span> while(ernumerator.moveNext())<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span> {<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span> var listname = ernumerator.get_current();<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span> alert(listname.get_title());<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span> }<br />
<br />
<span class="Apple-tab-span" style="white-space: pre;"> </span> $('#message').text('Hello ' +list.get_count());<br />
}<br />
<br />
// This function is executed if the above call fails<br />
<br />
function onGetListCountFail(sender, args) {<br />
alert('Failed to get list count. Error:' + args.get_message());<br />
}<br />
})();</div>
Sandeshhttp://www.blogger.com/profile/16230261794878311021noreply@blogger.com0tag:blogger.com,1999:blog-8572120255517524995.post-33402811183131880292015-04-05T16:30:00.002-07:002015-04-05T16:30:21.742-07:00Create your first app free in cloud Office 365 SharePoint 2013<div dir="ltr" style="text-align: left;" trbidi="on">
Microsoft has provided an online free developer environment for creating Apps in SharePoint 2013.<br />
<br />
In order to create an app below are the keys things we need to keep in mind<br />
<br />
1) The site should be created using Developer site template.<br />
<br />
2) When the developer site is created we would need to browse to SharePoint Store to add the NAPA tool as an app.<br />
<br />
Start here.<br />
<br />
https://msdn.microsoft.com/en-us/library/office/fp179924.aspx<br />
<br /></div>
Sandeshhttp://www.blogger.com/profile/16230261794878311021noreply@blogger.com0tag:blogger.com,1999:blog-8572120255517524995.post-24834686865052948602013-12-05T21:18:00.001-08:002013-12-05T21:20:18.493-08:00Move a source file and its properties from document library into a folder in same document library, delete the source and replace the destination file with another file<div dir="ltr" style="text-align: left;" trbidi="on">
using (SPSite oSite = new SPSite("http://Sharepoint2010:99/TestSite"))<br />
{<br />
using (SPWeb oWeb = oSite.OpenWeb())<br />
{<br />
//source file url<br />
string url = oWeb.Url + "/" + "SourceDocLib" + "/" + "SourceFileName";<br />
string fileName = "TestFile.docs"<br />
SPFile file =<span style="background-color: white; color: #333333; font-family: 'Segoe UI', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif; font-size: 14px; line-height: 20px;"> </span>oWeb.GetFile(url);<br />
byte[] fileBytes = item.File.OpenBinary();<br />
<br />
/destination document library<br />
SPList docLib = oWeb.Lists.TryGetList("TestDocLib");<br />
SPListItemCollection listItemCollection = docLib.Items;<br />
string folderName = "TestFolder";<br />
//get absolute destination Url<br />
string folderUrl = oWeb.Url + "/" + docLib.Title + "/" + folderName + "/" + fileName;<br />
<br />
foreach (SPListItem listItem in listItemCollection)<br />
{<br />
if (listItem["Name"] != null && listItem["Name"].ToString() == fileName)<br />
{<br />
// copy the source file and its properties to destination location<br />
listItem.CopyTo(folderUrl);<br />
//delete the source item<br />
listItem.Delete();<br />
break;<br />
}<br />
}<br />
replace the destination file with another file<br />
SPFile destFile = oWeb.Files.Add(folderUrl, fileBytes, true);<br />
destFile.Update();</div>
Sandeshhttp://www.blogger.com/profile/16230261794878311021noreply@blogger.com0tag:blogger.com,1999:blog-8572120255517524995.post-80657755413150423812013-12-05T17:37:00.003-08:002013-12-05T17:37:54.527-08:00People picker fields promoted from Infopath to sharepoint list as text fields<div dir="ltr" style="text-align: left;" trbidi="on">
When people picker fields are promoted from infopath to sharepoint list or form library, they are created in the sharepoint as "single text line" fields. In order to have them as people picker fields, create new people picker fields in sharepoint form library and write an event receiver and in the item adding event assign the values from the single text line fields to the people picker fields.</div>
Sandeshhttp://www.blogger.com/profile/16230261794878311021noreply@blogger.com0tag:blogger.com,1999:blog-8572120255517524995.post-35726640468240607622013-12-05T16:42:00.001-08:002013-12-05T17:58:44.365-08:00Retract and redeploy timer job<div dir="ltr" style="text-align: left;" trbidi="on">
1) Retract the timer job using powershell conmands<br />
2) run net stop SPTimerv4 in stsadm<br />
3) do IISRESET in cmd<br />
3) Deploy the timer job using powershell commands</div>
Sandeshhttp://www.blogger.com/profile/16230261794878311021noreply@blogger.com0tag:blogger.com,1999:blog-8572120255517524995.post-48526871045995184862013-12-05T15:09:00.000-08:002013-12-05T15:21:00.235-08:00Programmatically assigning multiple users to people picker field Sharepoint 2010 <div dir="ltr" style="text-align: left;" trbidi="on">
<span style="color: #2b91af; font-family: Consolas; font-size: x-small;"><span style="color: #2b91af; font-family: Consolas; font-size: x-small;"><span style="color: #2b91af; font-family: Consolas; font-size: x-small;">SPFieldUserValueCollection </span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;">usernameCol = </span></span><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;">new</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"> </span></span><span style="color: #2b91af; font-family: Consolas; font-size: x-small;"><span style="color: #2b91af; font-family: Consolas; font-size: x-small;"><span style="color: #2b91af; font-family: Consolas; font-size: x-small;">SPFieldUserValueCollection</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;">();</span></span><br />
<span style="font-family: Consolas; font-size: x-small;"> </span><br />
<span style="font-family: Consolas; font-size: x-small;">SPsite osite = new SPSite(<a href="http://sharepoint2010/testing">http://sharepoint2010/testing</a>);</span><br />
<span style="font-family: Consolas; font-size: x-small;">SPWeb oWeb = osite.OpenWeb();</span><br />
<span style="font-family: Consolas; font-size: x-small;">SPList oList = oWeb.Lists["TestList"];</span><br />
<span style="font-family: Consolas; font-size: x-small;">SPListItemCollection oListItemCol = oList.Items;</span><br />
<br />
<span style="font-family: Consolas; font-size: x-small;"></span><br />
<span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;">foreach</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"> (</span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;">SPListItem items </span></span><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;">in</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"> oListItemCol)</span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"></span></span><br />
<span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;">{</span></span><br />
<span style="font-family: Consolas; font-size: x-small;"></span><br />
<span style="font-family: Consolas; font-size: x-small;">SPUser user = items["PeoplePickerfield"];</span><br />
<span style="font-family: Consolas; font-size: x-small;"></span><br />
<span style="font-family: Consolas; font-size: x-small;"></span><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;">if</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"> (user != </span></span><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;">null</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;">)</span></span><br />
<span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"> {<br />
usernameCol.Add(</span></span><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;">new</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"> </span></span><span style="color: #2b91af; font-family: Consolas; font-size: x-small;"><span style="color: #2b91af; font-family: Consolas; font-size: x-small;"><span style="color: #2b91af; font-family: Consolas; font-size: x-small;">SPFieldUserValue</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;">(user.ParentWeb, user.ID, user.Name));</span></span><br />
<span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"> }</span></span><br />
<span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"><br />
}<br />
item["MultiplevalueallowedPeoplePickerField"] = usernameCol;<br />
item.Update();<br />
<br />
<br />
<br /></span><br /></span> </div>
Sandeshhttp://www.blogger.com/profile/16230261794878311021noreply@blogger.com0tag:blogger.com,1999:blog-8572120255517524995.post-25881789283691603082013-12-05T14:55:00.001-08:002013-12-05T14:56:54.875-08:00Check if the file exists in the document library SharePoint 2010 <div dir="ltr" style="text-align: left;" trbidi="on">
<span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;">using</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"> (</span></span><span style="color: #2b91af; font-family: Consolas; font-size: x-small;"><span style="color: #2b91af; font-family: Consolas; font-size: x-small;"><span style="color: #2b91af; font-family: Consolas; font-size: x-small;">SPSite</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"> oSite = </span></span><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;">new</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"> </span></span><span style="color: #2b91af; font-family: Consolas; font-size: x-small;"><span style="color: #2b91af; font-family: Consolas; font-size: x-small;"><span style="color: #2b91af; font-family: Consolas; font-size: x-small;">SPSite</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;">(</span></span><span style="color: #a31515; font-family: Consolas; font-size: x-small;"><span style="color: #a31515; font-family: Consolas; font-size: x-small;"><span style="color: #a31515; font-family: Consolas; font-size: x-small;"><a href="http://sharepoint2010:100/Testing">http://Sharepoint2010:100/Testing</a></span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;">))</span></span><br />
<span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;">
</span></span><br />
<span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"> {<br />
<br />
</span></span><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;">using</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"> (</span></span><span style="color: #2b91af; font-family: Consolas; font-size: x-small;"><span style="color: #2b91af; font-family: Consolas; font-size: x-small;"><span style="color: #2b91af; font-family: Consolas; font-size: x-small;">SPWeb</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"> oWeb = oSite.OpenWeb())</span></span><br />
<span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;">
</span></span><br />
<span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"> {<br />
<br />
</span></span><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;">string</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"> fileName = </span></span><span style="color: #a31515; font-family: Consolas; font-size: x-small;"><span style="color: #a31515; font-family: Consolas; font-size: x-small;"><span style="color: #a31515; font-family: Consolas; font-size: x-small;">"Test Reports.docx"</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;">;</span></span><br />
<span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;">
</span></span><br />
<span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"> </span></span><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;">string</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"> documentLibraryName = </span></span><span style="color: #a31515; font-family: Consolas; font-size: x-small;"><span style="color: #a31515; font-family: Consolas; font-size: x-small;"><span style="color: #a31515; font-family: Consolas; font-size: x-small;">"Test Reports"</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;">;</span></span><br />
<span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;">
</span></span><br />
<span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"> </span></span><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;">string</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"> fileUrl = </span></span><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;">string</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;">.Format(</span></span><span style="color: #a31515; font-family: Consolas; font-size: x-small;"><span style="color: #a31515; font-family: Consolas; font-size: x-small;"><span style="color: #a31515; font-family: Consolas; font-size: x-small;">"{0}/{1}/{2}"</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;">, oWeb.Url, documentLibraryName, fileName);</span></span><br />
<span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;">
</span></span><br />
<span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"> </span></span><span style="color: #2b91af; font-family: Consolas; font-size: x-small;"><span style="color: #2b91af; font-family: Consolas; font-size: x-small;"><span style="color: #2b91af; font-family: Consolas; font-size: x-small;">SPFile</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"> file = oWeb.GetFile(fileUrl);</span></span><br />
<span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;">
</span></span><br />
<span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"> </span></span><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;">string</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"> workfowStatus = </span></span><span style="color: #a31515; font-family: Consolas; font-size: x-small;"><span style="color: #a31515; font-family: Consolas; font-size: x-small;"><span style="color: #a31515; font-family: Consolas; font-size: x-small;">"Approved"</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;">;</span></span><br />
<span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;">
</span></span><br />
<span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"> </span></span><span style="color: green; font-family: Consolas; font-size: x-small;"><span style="color: green; font-family: Consolas; font-size: x-small;"><span style="color: green; font-family: Consolas; font-size: x-small;">//code when all the approvers approve delete this file and move it under folder called pdf</span></span></span><br />
<span style="color: green; font-family: Consolas; font-size: x-small;"><span style="color: green; font-family: Consolas; font-size: x-small;"><span style="color: green; font-family: Consolas; font-size: x-small;">
</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"></span></span><br />
<span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"> </span></span><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;">if</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"> (file.Exists)</span></span><br />
<span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;">
</span></span><br />
<span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"> {<br />
</span></span><span style="color: #2b91af; font-family: Consolas; font-size: x-small;"><span style="color: #2b91af; font-family: Consolas; font-size: x-small;"><span style="color: #2b91af; font-family: Consolas; font-size: x-small;">Console</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;">.WriteLine(</span></span><span style="color: #a31515; font-family: Consolas; font-size: x-small;"><span style="color: #a31515; font-family: Consolas; font-size: x-small;"><span style="color: #a31515; font-family: Consolas; font-size: x-small;">"File {0} exists in the site"</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;">, file.Name);</span></span><br />
<span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;">
</span></span><br />
<span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"> </span></span><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;">if</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"> (workfowStatus == </span></span><span style="color: #a31515; font-family: Consolas; font-size: x-small;"><span style="color: #a31515; font-family: Consolas; font-size: x-small;"><span style="color: #a31515; font-family: Consolas; font-size: x-small;">"Approved"</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;">)</span></span><br />
<span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;">
</span></span><br />
<span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"> {<br />
<br />
file.Delete();<br />
<br />
}<br />
<br />
}</span><br />
</span><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;">else</span></span></span><br />
<span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;">
</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"></span></span><br />
<span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"> {</span></span><span style="color: #2b91af; font-family: Consolas; font-size: x-small;"><span style="color: #2b91af; font-family: Consolas; font-size: x-small;"><span style="color: #2b91af; font-family: Consolas; font-size: x-small;">Console</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;">.WriteLine(</span></span><span style="color: #a31515; font-family: Consolas; font-size: x-small;"><span style="color: #a31515; font-family: Consolas; font-size: x-small;"><span style="color: #a31515; font-family: Consolas; font-size: x-small;">"File Not Found"</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;">);</span></span><br />
<span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;">
</span></span><br />
<span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;"> }<br />
<br />
}<br />
<br />
}</span></span></div>
Sandeshhttp://www.blogger.com/profile/16230261794878311021noreply@blogger.com0tag:blogger.com,1999:blog-8572120255517524995.post-44440732462255574312013-12-02T09:28:00.003-08:002013-12-02T09:29:37.288-08:00Using powershell add header and link in quick launch<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="color: blue; font-family: Courier New; font-size: xx-small;"><span style="color: blue; font-family: Courier New; font-size: xx-small;"><span style="color: blue; font-family: Courier New; font-size: xx-small;">param</span></span></span><span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;">([</span></span><span style="color: teal; font-family: Courier New; font-size: xx-small;"><span style="color: teal; font-family: Courier New; font-size: xx-small;"><span style="color: teal; font-family: Courier New; font-size: xx-small;">string</span></span></span><span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;">] </span></span><span style="color: purple; font-family: Courier New; font-size: xx-small;"><span style="color: purple; font-family: Courier New; font-size: xx-small;"><span style="color: purple; font-family: Courier New; font-size: xx-small;">$siteCollectionUrl</span></span></span><span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;">, [</span></span><span style="color: teal; font-family: Courier New; font-size: xx-small;"><span style="color: teal; font-family: Courier New; font-size: xx-small;"><span style="color: teal; font-family: Courier New; font-size: xx-small;">string</span></span></span><span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;">] </span></span><span style="color: purple; font-family: Courier New; font-size: xx-small;"><span style="color: purple; font-family: Courier New; font-size: xx-small;"><span style="color: purple; font-family: Courier New; font-size: xx-small;">$LeasingRelUrl</span></span></span><span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;">)</span></span><br />
<span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;">
</span></span><span style="color: purple; font-family: Courier New; font-size: xx-small;"><span style="color: purple; font-family: Courier New; font-size: xx-small;"><span style="color: purple; font-family: Courier New; font-size: xx-small;"></span></span></span><br />
<span style="color: purple; font-family: Courier New; font-size: xx-small;"><span style="color: purple; font-family: Courier New; font-size: xx-small;"><span style="color: purple; font-family: Courier New; font-size: xx-small;">$currentScriptName</span></span> </span><span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;"> </span></span><span style="color: red; font-family: Courier New; font-size: xx-small;"><span style="color: red; font-family: Courier New; font-size: xx-small;"><span style="color: red; font-family: Courier New; font-size: xx-small;">=</span></span></span><span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;"> </span></span><span style="color: purple; font-family: Courier New; font-size: xx-small;"><span style="color: purple; font-family: Courier New; font-size: xx-small;"><span style="color: purple; font-family: Courier New; font-size: xx-small;">$MyInvocation</span></span></span><span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;">.MyCommand.Name</span></span><br />
<span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;">
</span></span><span style="color: purple; font-family: Courier New; font-size: xx-small;"><span style="color: purple; font-family: Courier New; font-size: xx-small;"><span style="color: purple; font-family: Courier New; font-size: xx-small;"></span></span></span><br />
<span style="color: purple; font-family: Courier New; font-size: xx-small;"><span style="color: purple; font-family: Courier New; font-size: xx-small;"><span style="color: purple; font-family: Courier New; font-size: xx-small;">$usageText</span></span></span><span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;"> </span></span><span style="color: red; font-family: Courier New; font-size: xx-small;"><span style="color: red; font-family: Courier New; font-size: xx-small;"><span style="color: red; font-family: Courier New; font-size: xx-small;">=</span></span></span><span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;"> </span></span><span style="color: maroon; font-family: Courier New; font-size: xx-small;"><span style="color: maroon; font-family: Courier New; font-size: xx-small;"><span style="color: maroon; font-family: Courier New; font-size: xx-small;">"`nUsage:`n .\"</span></span></span><br />
<span style="color: maroon; font-family: Courier New; font-size: xx-small;"><span style="color: maroon; font-family: Courier New; font-size: xx-small;"><span style="color: maroon; font-family: Courier New; font-size: xx-small;">
</span></span></span><span style="color: purple; font-family: Courier New; font-size: xx-small;"><span style="color: purple; font-family: Courier New; font-size: xx-small;"><span style="color: purple; font-family: Courier New; font-size: xx-small;"></span></span></span><br />
<span style="color: purple; font-family: Courier New; font-size: xx-small;"><span style="color: purple; font-family: Courier New; font-size: xx-small;"><span style="color: purple; font-family: Courier New; font-size: xx-small;">$usageText</span></span></span><span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;"> </span></span><span style="color: red; font-family: Courier New; font-size: xx-small;"><span style="color: red; font-family: Courier New; font-size: xx-small;"><span style="color: red; font-family: Courier New; font-size: xx-small;">+=</span></span></span><span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;"> </span></span><span style="color: maroon; font-family: Courier New; font-size: xx-small;"><span style="color: maroon; font-family: Courier New; font-size: xx-small;"><span style="color: maroon; font-family: Courier New; font-size: xx-small;">"$currentScriptName `"`<siteCollectionUrl>`" `"`<siteUrl>`"`n`n"</span></span></span><br />
<span style="color: maroon; font-family: Courier New; font-size: xx-small;"><span style="color: maroon; font-family: Courier New; font-size: xx-small;"><span style="color: maroon; font-family: Courier New; font-size: xx-small;">
</span></span></span><span style="color: purple; font-family: Courier New; font-size: xx-small;"><span style="color: purple; font-family: Courier New; font-size: xx-small;"><span style="color: purple; font-family: Courier New; font-size: xx-small;"></span></span></span><br />
<span style="color: purple; font-family: Courier New; font-size: xx-small;"><span style="color: purple; font-family: Courier New; font-size: xx-small;"><span style="color: purple; font-family: Courier New; font-size: xx-small;">$usageText</span></span></span><span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;"> </span></span><span style="color: red; font-family: Courier New; font-size: xx-small;"><span style="color: red; font-family: Courier New; font-size: xx-small;"><span style="color: red; font-family: Courier New; font-size: xx-small;">+=</span></span></span><span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;"> </span></span><span style="color: maroon; font-family: Courier New; font-size: xx-small;"><span style="color: maroon; font-family: Courier New; font-size: xx-small;"><span style="color: maroon; font-family: Courier New; font-size: xx-small;">"Where:`n"</span></span></span><br />
<span style="color: maroon; font-family: Courier New; font-size: xx-small;"><span style="color: maroon; font-family: Courier New; font-size: xx-small;"><span style="color: maroon; font-family: Courier New; font-size: xx-small;">
</span></span></span><span style="color: purple; font-family: Courier New; font-size: xx-small;"><span style="color: purple; font-family: Courier New; font-size: xx-small;"><span style="color: purple; font-family: Courier New; font-size: xx-small;"></span></span></span><br />
<span style="color: purple; font-family: Courier New; font-size: xx-small;"><span style="color: purple; font-family: Courier New; font-size: xx-small;"><span style="color: purple; font-family: Courier New; font-size: xx-small;">$usageText</span></span></span><span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;"> </span></span><span style="color: red; font-family: Courier New; font-size: xx-small;"><span style="color: red; font-family: Courier New; font-size: xx-small;"><span style="color: red; font-family: Courier New; font-size: xx-small;">+=</span></span></span><span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;"> </span></span><span style="color: maroon; font-family: Courier New; font-size: xx-small;"><span style="color: maroon; font-family: Courier New; font-size: xx-small;"><span style="color: maroon; font-family: Courier New; font-size: xx-small;">"siteCollectionUrl is the URL of the root site collection, e.g. <a href="http://sharepoint2010.com%60n/">http://sharepoint2010.com`n</a>"</span></span></span><br />
<span style="color: maroon; font-family: Courier New; font-size: xx-small;"><span style="color: maroon; font-family: Courier New; font-size: xx-small;"><span style="color: maroon; font-family: Courier New; font-size: xx-small;">
</span></span></span><span style="color: purple; font-family: Courier New; font-size: xx-small;"><span style="color: purple; font-family: Courier New; font-size: xx-small;"><span style="color: purple; font-family: Courier New; font-size: xx-small;"></span></span></span><br />
<span style="color: purple; font-family: Courier New; font-size: xx-small;"><span style="color: purple; font-family: Courier New; font-size: xx-small;"><span style="color: purple; font-family: Courier New; font-size: xx-small;">$usageText</span></span></span><span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;"> </span></span><span style="color: red; font-family: Courier New; font-size: xx-small;"><span style="color: red; font-family: Courier New; font-size: xx-small;"><span style="color: red; font-family: Courier New; font-size: xx-small;">+=</span></span></span><span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;"> </span></span><span style="color: maroon; font-family: Courier New; font-size: xx-small;"><span style="color: maroon; font-family: Courier New; font-size: xx-small;"><span style="color: maroon; font-family: Courier New; font-size: xx-small;">"MORelUrl is the path of the site, e.g. testsite`n"</span></span></span><br />
<span style="color: maroon; font-family: Courier New; font-size: xx-small;"><span style="color: maroon; font-family: Courier New; font-size: xx-small;"><span style="color: maroon; font-family: Courier New; font-size: xx-small;">
</span></span></span><span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;">
</span></span><span style="color: blue; font-family: Courier New; font-size: xx-small;"><span style="color: blue; font-family: Courier New; font-size: xx-small;"><span style="color: blue; font-family: Courier New; font-size: xx-small;"></span></span></span><br />
<span style="color: blue; font-family: Courier New; font-size: xx-small;"><span style="color: blue; font-family: Courier New; font-size: xx-small;"><span style="color: blue; font-family: Courier New; font-size: xx-small;">if</span></span></span><span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;"> (</span></span><span style="color: purple; font-family: Courier New; font-size: xx-small;"><span style="color: purple; font-family: Courier New; font-size: xx-small;"><span style="color: purple; font-family: Courier New; font-size: xx-small;">$siteCollectionUrl</span></span></span><span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;"> </span></span><span style="color: red; font-family: Courier New; font-size: xx-small;"><span style="color: red; font-family: Courier New; font-size: xx-small;"><span style="color: red; font-family: Courier New; font-size: xx-small;">-eq</span></span></span><span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;"> </span></span><span style="color: maroon; font-family: Courier New; font-size: xx-small;"><span style="color: maroon; font-family: Courier New; font-size: xx-small;"><span style="color: maroon; font-family: Courier New; font-size: xx-small;">""</span></span></span><span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;">) {</span></span><br />
<span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;">
</span></span><br />
<span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;"> </span></span><b><span style="color: cadetblue; font-family: Courier New; font-size: xx-small;"><span style="color: cadetblue; font-family: Courier New; font-size: xx-small;"><span style="color: cadetblue; font-family: Courier New; font-size: xx-small;">write-Host</span></span></span></b><span style="color: cadetblue; font-family: Courier New; font-size: xx-small;"><span style="color: cadetblue; font-family: Courier New; font-size: xx-small;"><span style="color: cadetblue; font-family: Courier New; font-size: xx-small;"></span></span></span><span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;"> </span></span><i><span style="color: cadetblue; font-family: Courier New; font-size: xx-small;"><span style="color: cadetblue; font-family: Courier New; font-size: xx-small;"><span style="color: cadetblue; font-family: Courier New; font-size: xx-small;">-foregroundcolor</span></span></span></i><span style="color: cadetblue; font-family: Courier New; font-size: xx-small;"><span style="color: cadetblue; font-family: Courier New; font-size: xx-small;"><span style="color: cadetblue; font-family: Courier New; font-size: xx-small;"></span></span></span><span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;"> </span></span><span style="color: maroon; font-family: Courier New; font-size: xx-small;"><span style="color: maroon; font-family: Courier New; font-size: xx-small;"><span style="color: maroon; font-family: Courier New; font-size: xx-small;">Red</span></span></span><span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;"> </span></span><span style="color: maroon; font-family: Courier New; font-size: xx-small;"><span style="color: maroon; font-family: Courier New; font-size: xx-small;"><span style="color: maroon; font-family: Courier New; font-size: xx-small;">"Required parameter siteCollectionUrl missing."</span></span></span><br />
<span style="color: maroon; font-family: Courier New; font-size: xx-small;"><span style="color: maroon; font-family: Courier New; font-size: xx-small;"><span style="color: maroon; font-family: Courier New; font-size: xx-small;">
</span></span></span><span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;"></span></span><br />
<span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;"> </span></span><b><span style="color: cadetblue; font-family: Courier New; font-size: xx-small;"><span style="color: cadetblue; font-family: Courier New; font-size: xx-small;"><span style="color: cadetblue; font-family: Courier New; font-size: xx-small;">write-Host</span></span></span></b><span style="color: cadetblue; font-family: Courier New; font-size: xx-small;"><span style="color: cadetblue; font-family: Courier New; font-size: xx-small;"><span style="color: cadetblue; font-family: Courier New; font-size: xx-small;"></span></span></span><span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;"> </span></span><span style="color: purple; font-family: Courier New; font-size: xx-small;"><span style="color: purple; font-family: Courier New; font-size: xx-small;"><span style="color: purple; font-family: Courier New; font-size: xx-small;">$usageText</span></span></span><br />
<span style="color: purple; font-family: Courier New; font-size: xx-small;"><span style="color: purple; font-family: Courier New; font-size: xx-small;"><span style="color: purple; font-family: Courier New; font-size: xx-small;">
</span></span></span><span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;"></span></span><br />
<span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;"> exit<br />
<br />
}<br />
</span></span><span style="color: blue; font-family: Courier New; font-size: xx-small;"><span style="color: blue; font-family: Courier New; font-size: xx-small;"><span style="color: blue; font-family: Courier New; font-size: xx-small;"></span></span></span><br />
<span style="color: blue; font-family: Courier New; font-size: xx-small;"><span style="color: blue; font-family: Courier New; font-size: xx-small;"><span style="color: blue; font-family: Courier New; font-size: xx-small;">if</span></span></span><span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;"> (</span></span><span style="color: purple; font-family: Courier New; font-size: xx-small;"><span style="color: purple; font-family: Courier New; font-size: xx-small;"><span style="color: purple; font-family: Courier New; font-size: xx-small;">$LeasingRelUrl</span></span></span><span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;"> </span></span><span style="color: red; font-family: Courier New; font-size: xx-small;"><span style="color: red; font-family: Courier New; font-size: xx-small;"><span style="color: red; font-family: Courier New; font-size: xx-small;">-eq</span></span></span><span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;"> </span></span><span style="color: maroon; font-family: Courier New; font-size: xx-small;"><span style="color: maroon; font-family: Courier New; font-size: xx-small;"><span style="color: maroon; font-family: Courier New; font-size: xx-small;">""</span></span></span><span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;">) {</span></span><br />
<span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;">
</span></span><br />
<span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;"> </span></span><b><span style="color: cadetblue; font-family: Courier New; font-size: xx-small;"><span style="color: cadetblue; font-family: Courier New; font-size: xx-small;"><span style="color: cadetblue; font-family: Courier New; font-size: xx-small;">write-Host</span></span></span></b><span style="color: cadetblue; font-family: Courier New; font-size: xx-small;"><span style="color: cadetblue; font-family: Courier New; font-size: xx-small;"><span style="color: cadetblue; font-family: Courier New; font-size: xx-small;"></span></span></span><span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;"> </span></span><i><span style="color: cadetblue; font-family: Courier New; font-size: xx-small;"><span style="color: cadetblue; font-family: Courier New; font-size: xx-small;"><span style="color: cadetblue; font-family: Courier New; font-size: xx-small;">-foregroundcolor</span></span></span></i><span style="color: cadetblue; font-family: Courier New; font-size: xx-small;"><span style="color: cadetblue; font-family: Courier New; font-size: xx-small;"><span style="color: cadetblue; font-family: Courier New; font-size: xx-small;"></span></span></span><span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;"> </span></span><span style="color: maroon; font-family: Courier New; font-size: xx-small;"><span style="color: maroon; font-family: Courier New; font-size: xx-small;"><span style="color: maroon; font-family: Courier New; font-size: xx-small;">Red</span></span></span><span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;"> </span></span><span style="color: maroon; font-family: Courier New; font-size: xx-small;"><span style="color: maroon; font-family: Courier New; font-size: xx-small;"><span style="color: maroon; font-family: Courier New; font-size: xx-small;">"Required parameter MORelUrl missing."</span></span></span><br />
<span style="color: maroon; font-family: Courier New; font-size: xx-small;"><span style="color: maroon; font-family: Courier New; font-size: xx-small;"><span style="color: maroon; font-family: Courier New; font-size: xx-small;">
</span></span></span><span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;"></span></span><br />
<span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;"> </span></span><b><span style="color: cadetblue; font-family: Courier New; font-size: xx-small;"><span style="color: cadetblue; font-family: Courier New; font-size: xx-small;"><span style="color: cadetblue; font-family: Courier New; font-size: xx-small;">write-Host</span></span></span></b><span style="color: cadetblue; font-family: Courier New; font-size: xx-small;"><span style="color: cadetblue; font-family: Courier New; font-size: xx-small;"><span style="color: cadetblue; font-family: Courier New; font-size: xx-small;"></span></span></span><span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;"> </span></span><span style="color: purple; font-family: Courier New; font-size: xx-small;"><span style="color: purple; font-family: Courier New; font-size: xx-small;"><span style="color: purple; font-family: Courier New; font-size: xx-small;">$usageText</span></span></span><br />
<span style="color: purple; font-family: Courier New; font-size: xx-small;"><span style="color: purple; font-family: Courier New; font-size: xx-small;"><span style="color: purple; font-family: Courier New; font-size: xx-small;">
</span></span></span><span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;"></span></span><br />
<span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;"> exit<br />
<br />
}<br />
</span></span><span style="color: purple; font-family: Courier New; font-size: xx-small;"><span style="color: purple; font-family: Courier New; font-size: xx-small;"><span style="color: purple; font-family: Courier New; font-size: xx-small;"></span></span></span><br />
<span style="color: purple; font-family: Courier New; font-size: xx-small;"><span style="color: purple; font-family: Courier New; font-size: xx-small;"><span style="color: purple; font-family: Courier New; font-size: xx-small;">$web</span></span></span><span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;"> </span></span><span style="color: red; font-family: Courier New; font-size: xx-small;"><span style="color: red; font-family: Courier New; font-size: xx-small;"><span style="color: red; font-family: Courier New; font-size: xx-small;">=</span></span></span><span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;"> </span></span><b><span style="color: cadetblue; font-family: Courier New; font-size: xx-small;"><span style="color: cadetblue; font-family: Courier New; font-size: xx-small;"><span style="color: cadetblue; font-family: Courier New; font-size: xx-small;">get-spweb</span></span></span></b><span style="color: cadetblue; font-family: Courier New; font-size: xx-small;"><span style="color: cadetblue; font-family: Courier New; font-size: xx-small;"><span style="color: cadetblue; font-family: Courier New; font-size: xx-small;"></span></span></span><span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;"> </span></span><span style="color: maroon; font-family: Courier New; font-size: xx-small;"><span style="color: maroon; font-family: Courier New; font-size: xx-small;"><span style="color: maroon; font-family: Courier New; font-size: xx-small;">"$siteCollectionUrl/$Url"</span></span></span><br />
<span style="color: maroon; font-family: Courier New; font-size: xx-small;"><span style="color: maroon; font-family: Courier New; font-size: xx-small;"><span style="color: maroon; font-family: Courier New; font-size: xx-small;">
</span></span></span><span style="color: purple; font-family: Courier New; font-size: xx-small;"><span style="color: purple; font-family: Courier New; font-size: xx-small;"><span style="color: purple; font-family: Courier New; font-size: xx-small;"></span></span></span><br />
<span style="color: purple; font-family: Courier New; font-size: xx-small;"><span style="color: purple; font-family: Courier New; font-size: xx-small;"><span style="color: purple; font-family: Courier New; font-size: xx-small;">$pubWeb</span></span></span><span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;"> </span></span><span style="color: red; font-family: Courier New; font-size: xx-small;"><span style="color: red; font-family: Courier New; font-size: xx-small;"><span style="color: red; font-family: Courier New; font-size: xx-small;">=</span></span></span><span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;"> [Microsoft.SharePoint.Publishing.PublishingWeb]::GetPublishingWeb(</span></span><span style="color: purple; font-family: Courier New; font-size: xx-small;"><span style="color: purple; font-family: Courier New; font-size: xx-small;"><span style="color: purple; font-family: Courier New; font-size: xx-small;">$web</span></span></span><span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;">)</span></span><br />
<span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;">
</span></span><span style="color: blue; font-family: Courier New; font-size: xx-small;"><span style="color: blue; font-family: Courier New; font-size: xx-small;"><span style="color: blue; font-family: Courier New; font-size: xx-small;"></span></span></span><br />
<span style="color: blue; font-family: Courier New; font-size: xx-small;"><span style="color: blue; font-family: Courier New; font-size: xx-small;"><span style="color: blue; font-family: Courier New; font-size: xx-small;">function</span></span></span><span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;"> </span></span><span style="color: cadetblue; font-family: Courier New; font-size: xx-small;"><span style="color: cadetblue; font-family: Courier New; font-size: xx-small;"><span style="color: cadetblue; font-family: Courier New; font-size: xx-small;">AddHeading</span></span></span><span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;">(</span></span><span style="color: purple; font-family: Courier New; font-size: xx-small;"><span style="color: purple; font-family: Courier New; font-size: xx-small;"><span style="color: purple; font-family: Courier New; font-size: xx-small;">$HeadingName</span></span></span><span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;">,</span></span><span style="color: purple; font-family: Courier New; font-size: xx-small;"><span style="color: purple; font-family: Courier New; font-size: xx-small;"><span style="color: purple; font-family: Courier New; font-size: xx-small;">$Link</span></span></span><span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;">)</span></span><br />
<span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;">
</span></span><br />
<span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;">{<br />
<br />
</span></span><span style="color: purple; font-family: Courier New; font-size: xx-small;"><span style="color: purple; font-family: Courier New; font-size: xx-small;"><span style="color: purple; font-family: Courier New; font-size: xx-small;">$CreateSPNavigationNode</span></span></span><span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;"> </span></span><span style="color: red; font-family: Courier New; font-size: xx-small;"><span style="color: red; font-family: Courier New; font-size: xx-small;"><span style="color: red; font-family: Courier New; font-size: xx-small;">=</span></span></span><span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;"> [Microsoft.SharePoint.Publishing.Navigation.SPNavigationSiteMapNode]::CreateSPNavigationNode</span></span><br />
<span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;">
</span></span><br />
<span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;"> </span></span><span style="color: purple; font-family: Courier New; font-size: xx-small;"><span style="color: purple; font-family: Courier New; font-size: xx-small;"><span style="color: purple; font-family: Courier New; font-size: xx-small;">$qlNav</span></span></span><span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;"> </span></span><span style="color: red; font-family: Courier New; font-size: xx-small;"><span style="color: red; font-family: Courier New; font-size: xx-small;"><span style="color: red; font-family: Courier New; font-size: xx-small;">=</span></span></span><span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;"> </span></span><span style="color: purple; font-family: Courier New; font-size: xx-small;"><span style="color: purple; font-family: Courier New; font-size: xx-small;"><span style="color: purple; font-family: Courier New; font-size: xx-small;">$pubWeb</span></span></span><span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;">.Navigation.CurrentNavigationNodes</span></span><br />
<span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;">
</span></span><br />
<span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;"> </span></span><span style="color: purple; font-family: Courier New; font-size: xx-small;"><span style="color: purple; font-family: Courier New; font-size: xx-small;"><span style="color: purple; font-family: Courier New; font-size: xx-small;">$headingNode</span></span></span><span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;"> </span></span><span style="color: red; font-family: Courier New; font-size: xx-small;"><span style="color: red; font-family: Courier New; font-size: xx-small;"><span style="color: red; font-family: Courier New; font-size: xx-small;">=</span></span></span><span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;"> </span></span><span style="color: purple; font-family: Courier New; font-size: xx-small;"><span style="color: purple; font-family: Courier New; font-size: xx-small;"><span style="color: purple; font-family: Courier New; font-size: xx-small;">$CreateSPNavigationNode</span></span></span><span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;">.Invoke(</span></span><span style="color: purple; font-family: Courier New; font-size: xx-small;"><span style="color: purple; font-family: Courier New; font-size: xx-small;"><span style="color: purple; font-family: Courier New; font-size: xx-small;">$HeadingName</span></span></span><span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;">, </span></span><span style="color: purple; font-family: Courier New; font-size: xx-small;"><span style="color: purple; font-family: Courier New; font-size: xx-small;"><span style="color: purple; font-family: Courier New; font-size: xx-small;">$Link</span></span></span><span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;">, [Microsoft.SharePoint.Publishing.NodeTypes]::Heading, </span></span><span style="color: purple; font-family: Courier New; font-size: xx-small;"><span style="color: purple; font-family: Courier New; font-size: xx-small;"><span style="color: purple; font-family: Courier New; font-size: xx-small;">$qlNav</span></span></span><span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;">)</span></span><br />
<span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;">
</span></span><br />
<span style="font-family: Courier New; font-size: xx-small;"> </span><span style="color: purple; font-family: Courier New; font-size: xx-small;"><span style="color: purple; font-family: Courier New; font-size: xx-small;"><span style="color: purple; font-family: Courier New; font-size: xx-small;">$headingNode</span></span></span><span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;">.Properties[</span></span><span style="color: maroon; font-family: Courier New; font-size: xx-small;"><span style="color: maroon; font-family: Courier New; font-size: xx-small;"><span style="color: maroon; font-family: Courier New; font-size: xx-small;">"Audience"</span></span></span><span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;">] </span></span><span style="color: red; font-family: Courier New; font-size: xx-small;"><span style="color: red; font-family: Courier New; font-size: xx-small;"><span style="color: red; font-family: Courier New; font-size: xx-small;">=</span></span></span><span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;"> </span></span><span style="color: maroon; font-family: Courier New; font-size: xx-small;"><span style="color: maroon; font-family: Courier New; font-size: xx-small;"><span style="color: maroon; font-family: Courier New; font-size: xx-small;">";;;;Group_Name"</span></span></span><br />
<span style="color: maroon; font-family: Courier New; font-size: xx-small;"><span style="color: maroon; font-family: Courier New; font-size: xx-small;"><span style="color: maroon; font-family: Courier New; font-size: xx-small;">
</span></span></span><span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;">
</span></span><br />
<span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;"> </span></span><span style="color: purple; font-family: Courier New; font-size: xx-small;"><span style="color: purple; font-family: Courier New; font-size: xx-small;"><span style="color: purple; font-family: Courier New; font-size: xx-small;">$headingNode</span></span></span><span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;">.Update()</span></span><span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;"></span></span><br />
<span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;"></span><br /></span><span style="color: purple; font-family: Courier New; font-size: xx-small;"><span style="color: purple; font-family: Courier New; font-size: xx-small;"><span style="color: purple; font-family: Courier New; font-size: xx-small;">$web</span></span></span><span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;">.Update()</span></span><br />
<span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;">
</span></span><br />
<span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;">}<br />
</span></span><span style="color: blue; font-family: Courier New; font-size: xx-small;"><span style="color: blue; font-family: Courier New; font-size: xx-small;"><span style="color: blue; font-family: Courier New; font-size: xx-small;"></span></span></span><br />
<span style="color: blue; font-family: Courier New; font-size: xx-small;"><span style="color: blue; font-family: Courier New; font-size: xx-small;"><span style="color: blue; font-family: Courier New; font-size: xx-small;">function</span></span></span><span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;"> </span></span><span style="color: cadetblue; font-family: Courier New; font-size: xx-small;"><span style="color: cadetblue; font-family: Courier New; font-size: xx-small;"><span style="color: cadetblue; font-family: Courier New; font-size: xx-small;">AddLink</span></span></span><span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;">(</span></span><span style="color: purple; font-family: Courier New; font-size: xx-small;"><span style="color: purple; font-family: Courier New; font-size: xx-small;"><span style="color: purple; font-family: Courier New; font-size: xx-small;">$HeadingName</span></span></span><span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;">,</span></span><span style="color: purple; font-family: Courier New; font-size: xx-small;"><span style="color: purple; font-family: Courier New; font-size: xx-small;"><span style="color: purple; font-family: Courier New; font-size: xx-small;">$DisplayName</span></span></span><span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;">,</span></span><span style="color: purple; font-family: Courier New; font-size: xx-small;"><span style="color: purple; font-family: Courier New; font-size: xx-small;"><span style="color: purple; font-family: Courier New; font-size: xx-small;">$URL</span></span></span><span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;">,</span></span><span style="color: purple; font-family: Courier New; font-size: xx-small;"><span style="color: purple; font-family: Courier New; font-size: xx-small;"><span style="color: purple; font-family: Courier New; font-size: xx-small;">$External</span></span></span><span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;">)</span></span><br />
<span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;">
</span></span><br />
<span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;">{<br />
<br />
</span></span><b><span style="color: cadetblue; font-family: Courier New; font-size: xx-small;"><span style="color: cadetblue; font-family: Courier New; font-size: xx-small;"><span style="color: cadetblue; font-family: Courier New; font-size: xx-small;">Start-Sleep</span></span></span></b><span style="color: cadetblue; font-family: Courier New; font-size: xx-small;"><span style="color: cadetblue; font-family: Courier New; font-size: xx-small;"><span style="color: cadetblue; font-family: Courier New; font-size: xx-small;"></span></span></span><span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;"> </span></span><i><span style="color: cadetblue; font-family: Courier New; font-size: xx-small;"><span style="color: cadetblue; font-family: Courier New; font-size: xx-small;"><span style="color: cadetblue; font-family: Courier New; font-size: xx-small;">-Seconds</span></span></span></i><span style="color: cadetblue; font-family: Courier New; font-size: xx-small;"><span style="color: cadetblue; font-family: Courier New; font-size: xx-small;"><span style="color: cadetblue; font-family: Courier New; font-size: xx-small;"></span></span></span><span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;"> 5</span></span><br />
<span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;">
</span></span><br />
<span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;"> </span></span><span style="color: purple; font-family: Courier New; font-size: xx-small;"><span style="color: purple; font-family: Courier New; font-size: xx-small;"><span style="color: purple; font-family: Courier New; font-size: xx-small;">$qlNav1</span></span></span><span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;"> </span></span><span style="color: red; font-family: Courier New; font-size: xx-small;"><span style="color: red; font-family: Courier New; font-size: xx-small;"><span style="color: red; font-family: Courier New; font-size: xx-small;">=</span></span></span><span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;"> </span></span><span style="color: purple; font-family: Courier New; font-size: xx-small;"><span style="color: purple; font-family: Courier New; font-size: xx-small;"><span style="color: purple; font-family: Courier New; font-size: xx-small;">$web</span></span></span><span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;">.Navigation.QuickLaunch</span></span><br />
<span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;">
</span></span><br />
<span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;"> </span></span><span style="color: purple; font-family: Courier New; font-size: xx-small;"><span style="color: purple; font-family: Courier New; font-size: xx-small;"><span style="color: purple; font-family: Courier New; font-size: xx-small;">$qlNav1</span></span></span><span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;"> | </span></span><b><span style="color: cadetblue; font-family: Courier New; font-size: xx-small;"><span style="color: cadetblue; font-family: Courier New; font-size: xx-small;"><span style="color: cadetblue; font-family: Courier New; font-size: xx-small;">select</span></span></span></b><span style="color: cadetblue; font-family: Courier New; font-size: xx-small;"><span style="color: cadetblue; font-family: Courier New; font-size: xx-small;"><span style="color: cadetblue; font-family: Courier New; font-size: xx-small;"></span></span></span><span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;"> Title, </span></span><span style="color: maroon; font-family: Courier New; font-size: xx-small;"><span style="color: maroon; font-family: Courier New; font-size: xx-small;"><span style="color: maroon; font-family: Courier New; font-size: xx-small;">ID</span></span></span><br />
<span style="color: maroon; font-family: Courier New; font-size: xx-small;"><span style="color: maroon; font-family: Courier New; font-size: xx-small;"><span style="color: maroon; font-family: Courier New; font-size: xx-small;">
</span></span></span><span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;">
</span></span><br />
<span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;"> </span></span><span style="color: purple; font-family: Courier New; font-size: xx-small;"><span style="color: purple; font-family: Courier New; font-size: xx-small;"><span style="color: purple; font-family: Courier New; font-size: xx-small;">$qlink</span></span></span><span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;"> </span></span><span style="color: red; font-family: Courier New; font-size: xx-small;"><span style="color: red; font-family: Courier New; font-size: xx-small;"><span style="color: red; font-family: Courier New; font-size: xx-small;">=</span></span></span><span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;"> </span></span><span style="color: purple; font-family: Courier New; font-size: xx-small;"><span style="color: purple; font-family: Courier New; font-size: xx-small;"><span style="color: purple; font-family: Courier New; font-size: xx-small;">$qlNav1</span></span></span><span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;"> | </span></span><b><span style="color: cadetblue; font-family: Courier New; font-size: xx-small;"><span style="color: cadetblue; font-family: Courier New; font-size: xx-small;"><span style="color: cadetblue; font-family: Courier New; font-size: xx-small;">where</span></span></span></b><span style="color: cadetblue; font-family: Courier New; font-size: xx-small;"><span style="color: cadetblue; font-family: Courier New; font-size: xx-small;"><span style="color: cadetblue; font-family: Courier New; font-size: xx-small;"></span></span></span><span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;"> {</span></span><span style="color: purple; font-family: Courier New; font-size: xx-small;"><span style="color: purple; font-family: Courier New; font-size: xx-small;"><span style="color: purple; font-family: Courier New; font-size: xx-small;">$_</span></span></span><span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;">.Title </span></span><span style="color: red; font-family: Courier New; font-size: xx-small;"><span style="color: red; font-family: Courier New; font-size: xx-small;"><span style="color: red; font-family: Courier New; font-size: xx-small;">-eq</span></span></span><span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;"> </span></span><span style="color: purple; font-family: Courier New; font-size: xx-small;"><span style="color: purple; font-family: Courier New; font-size: xx-small;"><span style="color: purple; font-family: Courier New; font-size: xx-small;">$HeadingName</span></span></span><span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;">}</span></span><br />
<span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;">
</span></span><br />
<span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;"> </span></span><span style="color: purple; font-family: Courier New; font-size: xx-small;"><span style="color: purple; font-family: Courier New; font-size: xx-small;"><span style="color: purple; font-family: Courier New; font-size: xx-small;">$linkNode</span></span></span><span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;"> </span></span><span style="color: red; font-family: Courier New; font-size: xx-small;"><span style="color: red; font-family: Courier New; font-size: xx-small;"><span style="color: red; font-family: Courier New; font-size: xx-small;">=</span></span></span><span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;"> </span></span><b><span style="color: cadetblue; font-family: Courier New; font-size: xx-small;"><span style="color: cadetblue; font-family: Courier New; font-size: xx-small;"><span style="color: cadetblue; font-family: Courier New; font-size: xx-small;">New-Object</span></span></span></b><span style="color: cadetblue; font-family: Courier New; font-size: xx-small;"><span style="color: cadetblue; font-family: Courier New; font-size: xx-small;"><span style="color: cadetblue; font-family: Courier New; font-size: xx-small;"></span></span></span><span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;"> </span></span><span style="color: maroon; font-family: Courier New; font-size: xx-small;"><span style="color: maroon; font-family: Courier New; font-size: xx-small;"><span style="color: maroon; font-family: Courier New; font-size: xx-small;">Microsoft.SharePoint.Navigation.SPNavigationNode</span></span></span><span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;">(</span></span><span style="color: purple; font-family: Courier New; font-size: xx-small;"><span style="color: purple; font-family: Courier New; font-size: xx-small;"><span style="color: purple; font-family: Courier New; font-size: xx-small;">$DisplayName</span></span></span><span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;">,</span></span><span style="color: purple; font-family: Courier New; font-size: xx-small;"><span style="color: purple; font-family: Courier New; font-size: xx-small;"><span style="color: purple; font-family: Courier New; font-size: xx-small;">$URL</span></span></span><span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;">,</span></span><span style="color: purple; font-family: Courier New; font-size: xx-small;"><span style="color: purple; font-family: Courier New; font-size: xx-small;"><span style="color: purple; font-family: Courier New; font-size: xx-small;">$External</span></span></span><span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;">)</span></span><br />
<span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;">
</span></span><span style="font-family: Courier New; font-size: xx-small;"></span><br />
<span style="font-family: Courier New; font-size: xx-small;"></span><span style="color: purple; font-family: Courier New; font-size: xx-small;"><span style="color: purple; font-family: Courier New; font-size: xx-small;"><span style="color: purple; font-family: Courier New; font-size: xx-small;">$qlink</span></span></span><span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;">.Children.AddAsLast(</span></span><span style="color: purple; font-family: Courier New; font-size: xx-small;"><span style="color: purple; font-family: Courier New; font-size: xx-small;"><span style="color: purple; font-family: Courier New; font-size: xx-small;">$linkNode</span></span></span><span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;">)</span></span><span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;"></span></span><br />
<span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;"><br />
}</span></span><span style="color: cadetblue; font-family: Courier New; font-size: xx-small;"></span><br />
<span style="color: cadetblue; font-family: Courier New; font-size: xx-small;"></span><span style="color: maroon; font-family: Courier New; font-size: xx-small;"><span style="color: maroon; font-family: Courier New; font-size: xx-small;"><span style="color: maroon; font-family: Courier New; font-size: xx-small;">AddHeading "TestHeading"</span></span></span><span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;"> </span></span><span style="color: maroon; font-family: Courier New; font-size: xx-small;"><span style="color: maroon; font-family: Courier New; font-size: xx-small;"><span style="color: maroon; font-family: Courier New; font-size: xx-small;">""</span></span></span><br />
<span style="color: maroon; font-family: Courier New; font-size: xx-small;"><span style="color: maroon; font-family: Courier New; font-size: xx-small;"><span style="color: maroon; font-family: Courier New; font-size: xx-small;">
</span></span></span><br />
<span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;">AddLink </span></span><span style="color: maroon; font-family: Courier New; font-size: xx-small;"><span style="color: maroon; font-family: Courier New; font-size: xx-small;"><span style="color: maroon; font-family: Courier New; font-size: xx-small;">"TestHeading"</span></span></span><span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;"> </span></span><span style="color: maroon; font-family: Courier New; font-size: xx-small;"><span style="color: maroon; font-family: Courier New; font-size: xx-small;"><span style="color: maroon; font-family: Courier New; font-size: xx-small;">"TestLink"</span></span></span><span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;"> </span></span><span style="color: maroon; font-family: Courier New; font-size: xx-small;"><span style="color: maroon; font-family: Courier New; font-size: xx-small;"><span style="color: maroon; font-family: Courier New; font-size: xx-small;">"http://hotmail.com"</span></span></span><span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;"> </span></span><span style="color: maroon; font-family: Courier New; font-size: xx-small;"><span style="color: maroon; font-family: Courier New; font-size: xx-small;"><span style="color: maroon; font-family: Courier New; font-size: xx-small;">"True"</span></span></span><span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;"> </span></span><br />
<span style="font-family: Courier New; font-size: xx-small;"><span style="font-family: Courier New; font-size: xx-small;"></span></span><br /></div>
Sandeshhttp://www.blogger.com/profile/16230261794878311021noreply@blogger.com0tag:blogger.com,1999:blog-8572120255517524995.post-85734362692545314682012-12-04T13:32:00.001-08:002012-12-04T13:34:46.188-08:00<div dir="ltr" style="text-align: left;" trbidi="on">
Good Article for SharePoint debugging Locally<br />
<a href="http://hughajwood.wordpress.com/" target="_blank">http://hughajwood.wordpress.com/2012/09/24/local-debugging-in-sharepoint/</a><br />
<br /></div>
Sandeshhttp://www.blogger.com/profile/16230261794878311021noreply@blogger.com0tag:blogger.com,1999:blog-8572120255517524995.post-81039080853167368352012-07-02T21:46:00.000-07:002012-07-04T13:28:50.152-07:00Using SPServices to Query a list in SharePoint 2010<div dir="ltr" style="text-align: left;" trbidi="on">
<ol style="text-align: left;">
<li>Create 2 lists.</li>
</ol>
<div>
1a. Coolcities List<br />
1b. SelectCity List</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgtbmCUDzc2G4eX7lFos30vd83E2hLeBA6dYFbeFxCCeF-sgK7_NBPgZA1p5Iieta92l5Q0bcnBHhHCkLnNPqQSn3TVaJ1VMle8N1lnKST4nWUd_mIlfVHowqMhm6KMDImkLW1okDVopSer/s1600/Coolcities.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="106" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgtbmCUDzc2G4eX7lFos30vd83E2hLeBA6dYFbeFxCCeF-sgK7_NBPgZA1p5Iieta92l5Q0bcnBHhHCkLnNPqQSn3TVaJ1VMle8N1lnKST4nWUd_mIlfVHowqMhm6KMDImkLW1okDVopSer/s400/Coolcities.png" width="400" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjKaavxvjVvIdePgSymyISR18QqqD53Sd3RruILyk2eB7wFNVPkB20TwrWxgzUTXXTdCNc7Z-b3k9F5rHUAhcQ_t91AyKPFlRi7PbYYzcXUs814F4Ysxm0hDxQUG8JdYGuMSI7WrLwl_xLX/s1600/SelectCity.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="92" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjKaavxvjVvIdePgSymyISR18QqqD53Sd3RruILyk2eB7wFNVPkB20TwrWxgzUTXXTdCNc7Z-b3k9F5rHUAhcQ_t91AyKPFlRi7PbYYzcXUs814F4Ysxm0hDxQUG8JdYGuMSI7WrLwl_xLX/s400/SelectCity.png" width="400" /></a></div>
<br />
<span style="background-color: white;"><br /></span><br />
<span style="background-color: white;"><br /></span><br />
<span style="background-color: white;"><br /></span><br />
<span style="background-color: white;"><br /></span><br />
<span style="background-color: white;"><br /></span><br />
<span style="background-color: white;"> 2. Download, Refer and test SPServices.</span><br />
2a. Follow the <a href="http://spservices.codeplex.com/releases/view/77486" target="_blank">link</a> to download the SPServices js file.<br />
2b. Refer the file similar the way done for the jquery.js file<br />
<br />
<span style="background-color: white;"><script src="/Shared%20Documents/jquery-1.7.2.js" type="text/javascript"></span><span style="background-color: white;"></script></span><br />
<span style="background-color: white;"><script src="/Shared%20Documents/jquery.SPServices-0.7.1a.js" type="text/javascript"></script></span><br />
<span style="background-color: white;"><br /></span><br />
2c. Test the SPServices file has been properly refered or the file is properly loading during the page load. For this run the small script which alerts the user who is logged in during the page load.<br />
Edit the newform.aspx and add the content editor webpart<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg0XZZpJV2Xeq0oD5SZxOWT90fjRN4D0sB5G3Pg6XOzhS_X2ZueqW45rzwpG9ya1nyk13_WpV2mqfA6J1OjcKHoKtJuDTjiRZPiogF1CIORfCLBIya1fuZAVkkkU-mQFgTMRMlQNXUPx4yO/s1600/ContentEditorWebpart.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="121" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg0XZZpJV2Xeq0oD5SZxOWT90fjRN4D0sB5G3Pg6XOzhS_X2ZueqW45rzwpG9ya1nyk13_WpV2mqfA6J1OjcKHoKtJuDTjiRZPiogF1CIORfCLBIya1fuZAVkkkU-mQFgTMRMlQNXUPx4yO/s320/ContentEditorWebpart.png" width="320" /></a></div>
<br />
<br />
<br />
<br />
<br />
<br />
<br />
Then paste the following code inside it<br />
<br />
<span style="background-color: white;"><script src="/Shared%20Documents/jquery-1.7.2.js" type="text/javascript"></span><span style="background-color: white;"></script></span><br />
<span style="background-color: white;"><script src="/Shared%20Documents/jquery.SPServices-0.7.1a.js" type="text/javascript"></script></span><br />
<span style="background-color: white;"><br /></span><br />
<br />
$(document).ready(function() {<br />
<br />
<span style="color: blue;">var</span> thisUserName = $().SPServices.SPGetCurrentUser({<br />
fieldName: <span style="color: #a31515;">"Title"</span>,<br />
debug: <span style="color: blue;">false</span><br />
});<br />
<br />
alert(thisUserName);<br />
<br />
});<br />
<br />
So the above code will alert the user who is logged in, once you get the alert that means the spservices is being loading properly, and you can remove the test code. <br />
<br />
<ol style="text-align: left;">
</ol>
3. Building up the SPServices inside the onchange jQuery function.<br />
<br />
<br />
<script src="/Shared%20Documents/jquery-1.7.2.js" type="text/javascript"><span style="background-color: white;"></script></span><br />
<span style="background-color: white;"><script src="/Shared%20Documents/jquery.SPServices-0.7.1a.js" type="text/javascript"></script></span><br />
<span style="background-color: white;"><br /></span><br />
<span style="background-color: white;"><script type="text/javascript"></span><br />
<span style="background-color: white;"><br /></span><br />
$(document).ready(function() {<br />
$("select").change(function() {<br />
<br />
var selectedValue = this.value;<br />
<br />
$().SPServices({<br />
operation: "GetListItems",<br />
async: false,<br />
listName: "<span style="color: red;">CoolCities</span>",<br />
CAMLViewFields: "<ViewFields><FieldRef Name='<span style="color: red;">Description</span>' /></ViewFields>",<br />
CAMLQuery: "<Query><Where><Eq><FieldRef Name='<span style="color: red;">City</span>'/><Value Type='Text'>" + selectedValue + "</Value></Eq></Where></Query>",<br />
CAMLRowLimit: 1,<br />
completefunc: function (xData, Status) {<br />
$(xData.responseXML).SPFilterNode("z:row").each(function() {<br />
var liHtml = $(this).attr("ows_<span style="color: red;">Description</span>");<br />
alert(liHtml);<br />
$("input[title='<span style="color: red;">Description1</span>']").val(liHtml);<br />
});<br />
}<br />
});<br />
});<br />
<br />
});</script><br />
<br />
Output<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi0MixFDCOhSOSd57gmNfZTFR6AA8-oItANqaqEVWyWubCWIsnGpjMawqF3tamIgN8QvyplLOYSUzEUlr3lNDGM72tKvaGiLBOZqtQJ1Y4bz4GvHuAn5uR618bf43tUaw0279L-j643fFXM/s1600/output.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="161" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi0MixFDCOhSOSd57gmNfZTFR6AA8-oItANqaqEVWyWubCWIsnGpjMawqF3tamIgN8QvyplLOYSUzEUlr3lNDGM72tKvaGiLBOZqtQJ1Y4bz4GvHuAn5uR618bf43tUaw0279L-j643fFXM/s400/output.png" width="400" /></a></div>
<br />
<br />
-So when the drop down value is changed, on that event the CoolCities list is queried and the description of the selected city is displayed in the Description1 column of the SelectCity list.<br />
<br />
Note :<br />
The above code takes into consideration, that there is only one dropdown box in the SelectCity list,<br />
if there are more than one then it would need some check before running the code.<br />
<br />
<ol style="text-align: left;">
</ol>
</div>Sandeshhttp://www.blogger.com/profile/16230261794878311021noreply@blogger.com4tag:blogger.com,1999:blog-8572120255517524995.post-75655029028148859732012-02-13T10:01:00.000-08:002012-02-13T11:14:53.066-08:00The Sudden Death Error1:The server returned a non specific error when trying to get the data from the data source.check the format and the content of your query and try again.If the problem persists, contact the server administrator<div dir="ltr" style="text-align: left;" trbidi="on">From the production environment i created a template of a custom list l1(.stp file) and then used this template to create a list in the dev machine, now the names of the sitecollection and the server in the dev machine are different than those from the prod machine ..<br />
After i created a list based from the custom list template l1...i opened the list forms in the designer, as soon as i open the newform.aspx "BOOM" i was blinded with the vague,cryptic,horrifying Error--> <span style="color: blue;">"the server returned a non specific error when trying to get the data from the data source.check the format and the content of your query and try again.</span><br />
<span style="color: blue;">If the problem persists, contact the server administrator"</span><br />
I had no clue, probably even the designer did not know what exactly is wrong, but knew something is not well..After researching on it, i came to a solution in one of the forums which suggestion to change the weburl property ..so i checked the weburl property and there it was, the weburl sparkled as a twinkle in the dark..Default Value was still pointing to the production server site so i changed it to dev server site...and BINGO!..off in a flash it worked!<br />
<br />
Below is the tag in the newform.aspx<br />
<br />
<div style="color: #274e13;"><SharePoint:SPDataSource runat="server" DataSourceMode="ListItem" SelectCommand="&lt;View&gt;&lt;Query&gt;&lt;Where&gt;&lt;Eq&gt;&lt;FieldRef Name=&quot;ContentType&quot;/&gt;&lt;Value Type=&quot;Text&quot;&gt;Item&lt;/Value&gt;&lt;/Eq&gt;&lt;/Where&gt;&lt;/Query&gt;&lt;/View&gt;" UseInternalName="True" UseServerDataFormat="True"><SelectParameters><WebPartPages:DataFormParameter ParameterKey="ListItemId" PropertyName="ParameterValues" DefaultValue="0" Name="ListItemId"></WebPartPages:DataFormParameter><WebPartPages:DataFormParameter ParameterKey="weburl" PropertyName="ParameterValues" <span style="color: #660000;">DefaultValue</span>="<span style="color: #660000;">http://site.internal.com</span>" Name="weburl"></WebPartPages:DataFormParameter><WebPartPages:DataFormParameter ParameterKey="ListID" PropertyName="ParameterValues" DefaultValue="{40B40CDB-593E-4142-8AEA-B25032DE54D1}" Name="ListID"></WebPartPages:DataFormParameter></div><div style="color: #274e13;"><br />
</div><br />
<br />
<br />
</div>Sandeshhttp://www.blogger.com/profile/16230261794878311021noreply@blogger.com0tag:blogger.com,1999:blog-8572120255517524995.post-90104214582952312502012-02-11T12:57:00.000-08:002012-02-11T13:01:29.280-08:00Hidding the Quick Launch on a web part Page Sharepoint<div dir="ltr" style="text-align: left;" trbidi="on">First Edit the webpart page and add the content editor webpart to the page,then copy paste this CSS in it.<br />
<br />
<pre class="default prettyprint" style="color: blue;"><code><span class="tag"> <style type="text/css">
body #s4-leftpanel { display: none; }
.s4-ca { margin-left: 0px; } </span></code></pre><pre class="default prettyprint" style="color: blue;"><code><span class="tag"> </style></span></code></pre><pre class="default prettyprint"><code><span class="tag"> </span><span class="pln">
</span></code></pre></div>Sandeshhttp://www.blogger.com/profile/16230261794878311021noreply@blogger.com0tag:blogger.com,1999:blog-8572120255517524995.post-364421881861522912012-02-11T11:41:00.000-08:002012-02-11T11:56:30.444-08:00The Hidden Gem : SPHttpUtility.ConvertSimpleHtmlToText()<div dir="ltr" style="text-align: left;" trbidi="on">I had a requirement which needed to extract only first 200 characters from a Richtextbox in a custom webpart.Now this RichtextBox may contain tables,images,white spaces..html. .... The approach was first to strip all the HTML from the RichTextBox.Text and then remove the white spaces ... <br />
<br />
//add the following namespace<br />
<span style="color: blue;">using Microsoft.SharePoint.Utilities;</span><br />
<span style="color: blue;"> using System.Text.RegularExpressions; </span><br />
<br />
//converts all HTML into TEXT<br />
<span style="color: blue;">string convertHtmlToText = SPHttpUtility.ConvertSimpleHtmlToText(RichTextBox.Text, </span><span style="color: blue;">RichTextBox.Length</span><span style="color: blue;">);</span><br />
<br />
//replace extra white space with single white space<br />
<span style="color: blue;"> string removedExtraWhiteSpace = System.Text.RegularExpressions.Regex.Replace(</span><span style="color: blue;">convertHtmlToText </span><span style="color: blue;">, @"\s+", " ");</span></div>Sandeshhttp://www.blogger.com/profile/16230261794878311021noreply@blogger.com2tag:blogger.com,1999:blog-8572120255517524995.post-9653686279130115432012-02-11T11:12:00.000-08:002012-02-11T11:58:02.277-08:00The Awesome PreSaveAction() javascript function in list form sharepoint 2010<div dir="ltr" style="text-align: left;" trbidi="on">PreSaveAction() in list forms runs before the list form data gets saved<br />
<br />
How to define it?<br />
If you are on one of the list forms(newitem.aspx,edititem.aspx,dispitem.aspx) in sharepoint designer-click on the "Edit In Advance Mode option" find the "Main" content place holder in the page<br />
Inside the content place holder copy paste below<br />
<br />
<div style="color: blue;"><script type="text/javascript"></div><div style="color: blue;"> function PreSaveAction()</div><div style="color: blue;">{</div><div style="color: blue;">alert('I will run before the form gets saved');</div><div style="color: blue;">return true</div><div style="color: blue;">}</div><div style="color: blue;"></script></div><br />
<br />
Note : Don't forget to return true; otherwise the function won't fire ..<br />
<br />
</div>Sandeshhttp://www.blogger.com/profile/16230261794878311021noreply@blogger.com0tag:blogger.com,1999:blog-8572120255517524995.post-73271663739924278482012-02-11T11:02:00.000-08:002012-02-11T11:32:29.884-08:00Programmatically create a Attachment functionality in Custom Visual WebPart Sharepoint 2010<div dir="ltr" style="text-align: left;" trbidi="on">After searching, endlessly for creating a custom attachment functionality, i finally came across a great article which explained creating attachment functionality in a webpart.below is the <a href="http://www.pointsharepoint.com/2008/12/list-attachments-in-webpart-solution.html%20">link</a><br />
<br />
i modified it to suit my requirement<br />
<br />
<div style="color: #666666;">paste this code in the .aspx page </div><div style="color: blue;"><table> <tr><td></div><div style="color: blue;"><asp:HiddenField Value="hDeleteAttachs" ID="hHiddenFields" runat="server" /></div><div style="color: blue;"></td></tr></div><div style="color: blue;"><br />
</div><div style="color: blue;"><tr></div><div style="color: blue;"><td><span id="part1"></div><div style="color: blue;"><SharePoint:AttachmentButton runat="server" ID="btnAttach" ControlMode="new" Text="Add Attachment"></div><div style="color: blue;"></SharePoint:AttachmentButton> </span></td></tr></div><div style="color: blue;"><br />
</div><div style="color: blue;"><tr><td id='idAttachmentsRow'></div><div style="color: blue;"><SharePoint:AttachmentUpload runat="server" ID="uploadAttach" ControlMode="New"></div><div style="color: blue;"></SharePoint:AttachmentUpload></td></tr></div><div style="color: blue;"><br />
</div><div style="color: blue;"><tr><td><SharePoint:AttachmentsField runat="server" ID="fieldAttach" ControlMode="new" FieldName="Attachments"></div><div style="color: blue;"></SharePoint:AttachmentsField></td></tr></div><div style="color: blue;"></table></div><div style="color: blue;"><br />
</div><div style="color: blue;"> <asp:Button ID="submitButton" runat="server" Text="Submit" OnClick="submitButton_Click" /></div><br />
<div style="color: #444444;">Below in the c# page</div><div style="color: blue;"><br />
</div><div style="color: blue;">namespace ProjectName.VisualWebPartName</div><div style="color: blue;">{</div><div style="color: blue;"> public partial class VisualWebPartNameUserControl: UserControl</div><div style="color: blue;"> {</div><div style="color: blue;"><br />
</div><div style="color: blue;"> SPSite Osite = null;</div><div style="color: blue;"> SPWeb Oweb = null;</div><div style="color: blue;"> SPSite noprevsite = null;</div><div style="color: blue;"> SPWeb noprevweb = null;</div><div style="color: blue;"> SPList Olist = null;</div><div style="color: blue;"> SPListItem Osplistitem = null;</div><div style="color: blue;"><br />
</div><div style="color: blue;"> protected void Page_Load(object sender, EventArgs e)</div><div style="color: blue;"> {</div><div style="color: blue;"> noprevsite = SPContext.Current.Site;</div><div style="color: blue;"> noprevweb = noprevsite.OpenWeb(); </div><div style="color: blue;"><br />
</div><div style="color: blue;"> SPSecurity.RunWithElevatedPrivileges(delegate()</div><div style="color: blue;"> {</div><div style="color: blue;"> Osite = new SPSite(noprevsite.ID);</div><div style="color: blue;"> Oweb = Osite.OpenWeb(noprevweb.ID);</div><div style="color: blue;"> Oweb.AllowUnsafeUpdates = true;</div><div style="color: blue;"> Olist = Oweb.Lists["ListName"];</div><div style="color: blue;"> btnAttach.ListId = Olist.ID;</div><div style="color: blue;"> uploadAttach.ListId = Olist.ID;</div><div style="color: blue;"> fieldAttach.ListId = Olist.ID;</div><div style="color: blue;"> Osplistitem = Olist.Items.Add();</div><div style="color: blue;">});</div><div style="color: blue;">}</div><div style="color: blue;"><br />
</div><div style="color: blue;"> protected void submitButton_Click(object sender, EventArgs e)</div><div style="color: blue;"> {</div><div style="color: blue;"> AddAttachments(ref Osplistitem);</div><div style="color: blue;"> }</div><div style="color: blue;"> void AddAttachments(ref SPListItem Osplistitem)</div><div style="color: blue;"> {</div><div style="color: blue;"> try</div><div style="color: blue;"> {</div><div style="color: blue;"> for (int i = 0; i < (Page.Request.Files.Count - 1); i++)</div><div style="color: blue;"> {</div><div style="color: blue;"> try</div><div style="color: blue;"> {</div><div style="color: blue;"> //Get the list of files for attachments</div><div style="color: blue;"> HttpPostedFile newAttach = Page.Request.Files[i];</div><div style="color: blue;"> byte[] fileContents = new byte[newAttach.ContentLength - 1];</div><div style="color: blue;"> newAttach.InputStream.Seek(0, System.IO.SeekOrigin.Begin);</div><div style="color: blue;"> newAttach.InputStream.Read(fileContents, 0, newAttach.ContentLength - 1);</div><div style="color: blue;"> System.IO.FileInfo fInfo = new System.IO.FileInfo(newAttach.FileName);</div><div style="color: blue;"> Osplistitem.Attachments.Add(fInfo.Name, fileContents);</div><div style="color: blue;"> }</div><div style="color: blue;"> catch { continue; }</div><div style="color: blue;"> }</div><div style="color: blue;"> }</div><div style="color: blue;"> catch</div><div style="color: blue;"> {</div><div style="color: blue;"> }</div><div style="color: blue;"><br />
</div><div style="color: blue;"> }</div><div style="color: blue;">}</div><div style="color: blue;">}</div><br />
<br />
</div>Sandeshhttp://www.blogger.com/profile/16230261794878311021noreply@blogger.com7tag:blogger.com,1999:blog-8572120255517524995.post-27175584109479198282012-01-23T12:15:00.000-08:002012-02-11T11:31:49.880-08:00Getting the properties from user profile information using sharepoint object model sharepoint 2010<div dir="ltr" style="text-align: left;" trbidi="on">Below is the code for retrieving the user profile properties using sharepoint object model 2010<br />
<br />
<span style="color: blue;">SPSite Osite = SpContext.Current.Site;</span><br />
<div style="color: blue;"> SPWeb web = Osite.OpenWeb();</div><div style="color: blue;"> var strCurrentUser = web.CurrentUser.Name;</div><div style="color: blue;"><br />
</div><div style="color: blue;"> SPServiceContext serviceContext = SPServiceContext.GetContext(Osite);</div><div style="color: blue;"> UserProfileManager upm = new UserProfileManager(serviceContext);</div><div style="color: blue;"><br />
</div><div style="color: blue;"> if (!upm.UserExists(strCurrentUser))</div><div style="color: blue;"> {</div><div style="color: blue;"> UserProfile u = upm.GetUserProfile(strCurrentUser);</div><div style="color: blue;"> string uemail = u[PropertyConstants.WorkEmail].ToString();</div><div style="color: blue;"> string ufirstname = u[PropertyConstants.FirstName].ToString();</div><div style="color: blue;"> string ulastname = u[PropertyConstants.LastName].ToString();</div><div style="color: blue;"> }</div><div style="color: blue;"><br />
</div><div style="color: blue;"><span style="color: #444444;">Note : If you are remotely logging into the development machine, while debugging you might encounter a pop error -"cannot connect to remote computer" just press f11 again and it will get the value from the user profile and you will be able to debug further without exiting. </span></div></div>Sandeshhttp://www.blogger.com/profile/16230261794878311021noreply@blogger.com0tag:blogger.com,1999:blog-8572120255517524995.post-62566086824102752212012-01-22T15:38:00.003-08:002012-01-22T15:38:38.966-08:00back after a break<div dir="ltr" style="text-align: left;" trbidi="on">Sharepoint stuff</div>Sandeshhttp://www.blogger.com/profile/16230261794878311021noreply@blogger.com0tag:blogger.com,1999:blog-8572120255517524995.post-67818513901609397192011-05-14T16:27:00.001-07:002011-05-14T16:27:30.654-07:00A good article to upgrade a intranet site from sharepoint 2007 to 2010<div dir="ltr" style="text-align: left;" trbidi="on"><a href="http://www.sharepointmonitor.com/2010/02/migrate-moss-2007-to-sharepoint-server-2010/2/">http://www.sharepointmonitor.com/2010/02/migrate-moss-2007-to-sharepoint-server-2010/2/</a></div>Sandeshhttp://www.blogger.com/profile/16230261794878311021noreply@blogger.com1tag:blogger.com,1999:blog-8572120255517524995.post-70357576048329900132011-04-28T07:44:00.001-07:002011-04-28T07:44:22.382-07:00using list<div dir="ltr" style="text-align: left;" trbidi="on">http://www.c-sharpcorner.com/uploadfile/camurphy/csharplists03302006170209pm/csharplists.aspx</div>Sandeshhttp://www.blogger.com/profile/16230261794878311021noreply@blogger.com0tag:blogger.com,1999:blog-8572120255517524995.post-22876861859797176032011-04-27T21:37:00.001-07:002011-04-27T21:40:48.260-07:00How to deploy the .wsp package using stsadm.exe<div dir="ltr" style="text-align: left;" trbidi="on">cd "c:\Program Files\Common Files\Microsoft Shared\web server extensions\12\BIN"<br />
<br />
Add solution to your central administration, rename filename.wsp with your solution and path<br />
stsadm -o addsolution -filename "E:\WSPBuilderProject1\WSPBuilderProject1.wsp"<br />
<br />
add stsadm command to comit the changes<br />
stsadm -o execadmsvcjobs<br />
<br />
Deploy solution to your sharepoint site rename filename.wsp with your solution<br />
stsadm -o deploysolution -name WSPBuilderProject1.wsp -url [http://moss] -allowgacdeployment -immediate -force<br />
<br />
<br />
</div>Sandeshhttp://www.blogger.com/profile/16230261794878311021noreply@blogger.com0