tag:blogger.com,1999:blog-4824665638268232032024-02-06T18:18:03.353-08:00SharePoint Expert solutionsIt's not the collection. It's my experience.....Anonymoushttp://www.blogger.com/profile/15414514889165889118noreply@blogger.comBlogger130125tag:blogger.com,1999:blog-482466563826823203.post-88506842071551367392016-12-26T04:08:00.000-08:002016-12-26T04:09:36.087-08:00Move documents along with versioning<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="MsoNormal">
<span style="font-size: large;">Keep in mind that below approach works only within the site
collection level. I mean to say here is it is not
possible to move the documents between libraries across site collection
levels.<span style="color: red;"><o:p></o:p></span></span><br />
<span style="font-size: large;"><br /></span></div>
<div class="MsoNormal">
<span style="font-size: large;">The best approach to move the documents between the libraries along with versioning is using “<b>site
content structure</b>” option. </span><br />
<span style="font-size: large;"><br /></span>
<span style="font-size: large;"><span style="color: red;">Note</span>: But one thing we should keep in mind that versioning
shoould be enabled in both the source and destination document libraries.</span></div>
<div class="MsoNormal">
<span style="font-size: large;"><br /></span></div>
<div class="MsoNormal">
<span style="font-size: large;"><u>Steps to move the documents between document libraries</u>:</span></div>
<div class="MsoNormal">
<span style="font-size: large;"><br /></span></div>
<div class="MsoNormal">
<span style="font-size: large;">Step1: Go to Site Actions -> Site Settings. Under “Site Administration” click “Content
and structure”</span></div>
<div class="MsoNormal">
<span style="font-size: large;"><br /></span></div>
<div class="MsoNormal">
<span style="font-size: large;">Step2: Find the source library and select the all or any
specific documents you want to move and then click “Actions”<span style="font-family: "wingdings"; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-char-type: symbol; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin; mso-symbol-font-family: Wingdings;">à</span> Move.</span></div>
<div class="MsoNormal">
<span style="font-size: large;"><br /></span></div>
<div class="MsoNormal">
<span style="font-size: large;">That’s it. Now, go and visit the destination document
library. You will get the moved documents along with its versioning’s.</span></div>
<div class="MsoNormal">
<span style="font-size: large;"><br /></span></div>
<div class="MsoNormal">
<span style="font-size: large;"><span style="background: yellow; mso-highlight: yellow;">One
thing I observed here is</span>, along with the documents versioning, metadata
also would came.</span></div>
<div class="MsoNormal">
<span style="font-size: large;">I have a created a source document library and created 3
custom columns with different types. Uploaded the new document along with the
metadata and then moved this document to destination library. </span></div>
<div class="MsoNormal">
<span style="font-size: large;"><br /></span></div>
<div class="MsoNormal">
<span style="font-size: large;">In addition to the versioning in destination
library what ever the columns available in source got created the same in destination( means 3 custom columns which are all created by me on source
library are also available in destination library).</span></div>
<br />
<div class="MsoNormal">
<h4 style="text-align: left;">
<span style="color: #741b47;">Source library:</span></h4>
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh54Q8lUa3NMsbY-m8IBSSKvuI9MYnX6v3uoNgpMpvlUF4Wc71ORndaZ43zVwE3k_nk5pFB-e9pGXGFVyh-2CKgTV5ux5kUKYUBrkGq7a6oxPZhtPZeuvWBWmbyhcPQm5NoIkuI8KPRHw/s1600/source.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh54Q8lUa3NMsbY-m8IBSSKvuI9MYnX6v3uoNgpMpvlUF4Wc71ORndaZ43zVwE3k_nk5pFB-e9pGXGFVyh-2CKgTV5ux5kUKYUBrkGq7a6oxPZhtPZeuvWBWmbyhcPQm5NoIkuI8KPRHw/s1600/source.jpg" /></a></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<h4 style="text-align: left;">
<span style="color: #741b47;">Destination library:</span></h4>
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgF-cpXlkwsAJwvBdRdoy8HaaoZW5CB6Z-9W6uDUGqtq113PGSf1c1zF5a8X1Y4KZ5RMp1rMgUBF5PTWT7mTEntLPJfW2l-hoAomZCpKZuJnuiIpw4dFqbxERGWW12rkreF0587E2156A/s1600/Destination.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgF-cpXlkwsAJwvBdRdoy8HaaoZW5CB6Z-9W6uDUGqtq113PGSf1c1zF5a8X1Y4KZ5RMp1rMgUBF5PTWT7mTEntLPJfW2l-hoAomZCpKZuJnuiIpw4dFqbxERGWW12rkreF0587E2156A/s1600/Destination.jpg" /></a></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
Happy Sharepoint.<br />
<br />
<span style="background-color: yellow;">Please take a momenet and do comments if this post really helps</span></div>
</div>
Anonymoushttp://www.blogger.com/profile/15414514889165889118noreply@blogger.com1tag:blogger.com,1999:blog-482466563826823203.post-84906103137672323092016-12-26T04:01:00.000-08:002016-12-26T04:01:16.955-08:00Get sharepoint Host Web Url using REST<div dir="ltr" style="text-align: left;" trbidi="on">
Just do copy paste the below code and execute it.<br />
<br />
<br />
<span style="background-color: yellow;">Note:</span> The below shared code is 100% verified/executed.<br />
<br />
<br />
<h3 style="text-align: left;">
<span style="color: #741b47;">Appmanifest.xml</span>:</h3>
Set read level permisisons to the web<br />
<br />
<h3 style="text-align: left;">
<span style="color: #741b47;">Default.aspx</span>:</h3>
The host web title is: <label id="HostwebTitle"></label><br />
<h3 style="text-align: left;">
<span style="color: #741b47;">app.js</span>:</h3>
var hostweburl;<br />
var appweburl;<br />
<br />
// Load the required SharePoint libraries<br />
$(document).ready(function () {<br />
appweburl = window.location.protocol + "//" + window.location.host + _spPageContextInfo.webServerRelativeUrl;<br />
hostweburl = _spPageContextInfo.siteAbsoluteUrl;<br />
<br />
// resources are in URLs in the form:<br />
// web_url/_layouts/15/resource<br />
var scriptbase = hostweburl + "/_layouts/15/";<br />
<br />
// Load the js file and continue to the <br />
// success event handler<br />
//$.getScript(scriptbase + "SP.RequestExecutor.js", execCrossDomainRequest);<br />
$.getScript(scriptbase + "SP.js", execCrossDomainRequest);<br />
});<br />
<br />
// Function to prepare and issue the request to get<br />
// SharePoint data<br />
function execCrossDomainRequest() {<br />
var executor;<br />
<br />
// Initialize the RequestExecutor with the app web URL.<br />
executor = new SP.RequestExecutor(appweburl);<br />
<br />
// Issue the call against the host web.<br />
// To get the title using REST we can hit the endpoint:<br />
// app_web_url/_api/SP.AppContextSite(@target)/web/title?@target='siteUrl'<br />
// The response formats the data in the JSON format.<br />
// The functions successHandler and errorHandler attend the<br />
// success and error events respectively.<br />
executor.executeAsync(<br />
{<br />
url:<br />
appweburl +<br />
"/_api/SP.AppContextSite(@target)/web/title?@target='" +<br />
hostweburl + "'",<br />
method: "GET",<br />
headers: { "Accept": "application/json; odata=verbose" },<br />
success: successHandler,<br />
error: errorHandler<br />
}<br />
);<br />
}<br />
<br />
// Function to handle the success event.<br />
// Prints the host web's title to the page.<br />
function successHandler(data) {<br />
var jsonObject = JSON.parse(data.body);<br />
<br />
<br />
document.getElementById("HostwebTitle").innerHTML =<br />
"<b>" + jsonObject.d.Title + "</b>";<br />
}<br />
<br />
// Function to handle the error event.<br />
// Prints the error message to the page.<br />
function errorHandler(data, errorCode, errorMessage) {<br />
document.getElementById("HostwebTitle").innerText =<br />
"Could not complete cross-domain call: " + errorMessage;<br />
}<br />
<br />
// Function to retrieve a query string value.<br />
// For production purposes you may want to use<br />
// a library to handle the query string.<br />
function getQueryStringParameter(paramToRetrieve) {<br />
var params =<br />
document.URL.split("?")[1].split("&");<br />
var strParams = "";<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 />
<br />
Thanks for visting.. Happy Sharepoint<br />
<br />
<span style="background-color: yellow;">Please take a moment and do comments on it if its really helped you.</span></div>
Anonymoushttp://www.blogger.com/profile/15414514889165889118noreply@blogger.com0tag:blogger.com,1999:blog-482466563826823203.post-20202968308528978062016-07-02T10:18:00.000-07:002016-07-02T10:20:00.952-07:00How managed metadata works in CQWP<div dir="ltr" style="text-align: left;" trbidi="on">
Please read the below good articles before go with querying the managed metadata column values through Content Query Web part:<br />
<br />
https://chrisjohnson.tech/2014/03/25/sharepoint-querying-on-multiple-select-managed-metadata-columns-in-content-query-web-parts/<br />
<br />
-Thanks to Chris.<br />
<br />
<span style="background-color: white; font-family: "verdana" , "arial" , "helvetica" , sans-serif; font-size: x-small;">https://blogs.msdn.microsoft.com/ecm/2010/05/14/whats-new-with-the-content-query-web-part/ </span></div>
Anonymoushttp://www.blogger.com/profile/15414514889165889118noreply@blogger.com2tag:blogger.com,1999:blog-482466563826823203.post-75912823191123223332016-06-18T00:28:00.000-07:002016-06-18T02:56:37.037-07:00Lists and Libraries: Class Day3<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="MsoNormal" style="background: white; line-height: normal; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; mso-outline-level: 1;">
<div>
In this article, We will cover below mentioned topics on SharePoint Lists and libraries. please feel free to reach me if have any clarifications or more information required on it.<br />
<u style="background-color: transparent;"><span style="font-size: 12pt;"><br /></span></u>
<u style="background-color: transparent;"><span style="font-size: 12pt;">Topics</span></u><span style="background-color: transparent; font-size: 12pt;">:</span></div>
</div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-size: 12pt;">1) List and Library<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-size: 12pt;">2) site columns and List
columns<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-size: 12pt;">3) site content type and
list content type<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-size: 12pt;">4) Views<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-size: 12pt;">4) Cascade Delete<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-size: 12pt;">5) Restrict Delete<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-size: 12pt;">6) Enforce uniqueness<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-size: 12pt;">7) Calculated columns<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-size: 12pt;">8) lookup columns<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-size: 12pt;">9) Permissions<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-size: 12pt;">10) List Threshold<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-size: 12pt;">11) Indexing<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-size: 12pt;">12) Versioning,
Checked-In/Out and Publish<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-size: 12pt;">13) Update Vs SystemUpdate
Vs UpdateOverWriteversion<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-size: 12pt;">14) SharePoint real-time scenarios<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-size: 12pt;">15) SharePoint interview
questions and answers<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-size: 12pt;">16) Read-Only columns(Eg:
Created/Created By, Modified/Modified By etc..).\<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-size: 12pt;">17) File URL length
restriction.<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="font-size: 12pt;">18) </span><span style="color: #333333; font-size: 12.0pt;">SPBuiltInFieldId</span><span style="font-size: 12pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<u><span style="font-size: 12pt;">Basics on the List and
Libraries</span></u><span style="font-size: 12pt;">:<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
</div>
<ol style="text-align: left;">
<li><span style="font-size: 12pt;">By default, Content type
option is disabled at the list/library: To enable it: Go to list/library
settings-->Advanced settings--> Make it as "Yes" to allow
management of content type.</span></li>
<li><span style="font-size: 12pt;">By default, Threshold
limit for the user:5000 items and for administrators: 20000. These values are
hard-coded at the central admin level but Microsoft recommended is should not
increase/change the default threshold values to avoid the performance issues.</span></li>
<li><span style="font-size: 12pt;">Best practice to handle
the threshold: 1) Indexing the columns 2) Avoid threshold exception by
maintaining the data/items in a folder structure( SharePoint considers Folder
is an item and we can maintain 2000 items in it).</span></li>
<li><span style="font-size: 12pt;">Always go with the
internal column names(Reason: Display name can be modified but internal can't
be modified) to fetch the data and update an items.</span></li>
<li><span style="font-size: 12pt;">Go with the creating
site columns option rather creating it in each list/library if the same column
is used in more than one lists/libraries.</span></li>
<li><span style="font-size: 12pt;">Go with the site content
types option if more than one site columns needs to preferred in the each
lists/libraries.</span></li>
<li><span style="font-size: 12pt;">In views, Filter by [Me]
if wants to show the results of current logged user only.</span></li>
<li><span style="font-size: 12pt;">Upload size limit of
files to the document library is: By default: 50MB and max 2GB(SP2013) and max
10GB(SP2016).</span></li>
<li><span style="font-size: 12pt;">The files into the
library should always be in published mode to get the updated changes by
others.</span></li>
<li><span style="font-size: 12pt;">By default, SharePoint
recommended support for indexing is 20.</span></li>
<li><span style="font-size: 12pt;">SharePoint handles the
permissions at the lists/libraries and even items level also.</span></li>
<li><span style="font-size: 12pt;">Only option to change
the list/library URL is through SharePoint designer.</span></li>
<li><span style="font-size: 12pt;">By default list/library
permissions are inherited from parent but we can have an option to maintain the
unique permissions at it.</span></li>
<li><span style="font-size: 12pt;">We don't have an option
to add users/groups directly at the lists/library level in inheritance mode. If
needs, break the inheritance and then add users/groups.</span></li>
<li><span style="font-size: 12pt;">Users should have
minimum "contribute" level permissions to make CRUD operation at the
list/library.</span></li>
<li><span style="font-size: 12pt;">Steps to support large
files upload: 1) Increase the default value(Default: 50MB and Max support: 2GB)
to the desired value 2) Increase the IIS request length 3) Increase the IIS
connection timeout
length. https://angler.wordpress.com/2012/03/21/increase-the-sharepoint-2010-upload-file-size-limit/ </span></li>
</ol>
<div>
Please go the below articles for complete details:</div>
<div>
<br /></div>
<div>
<div>
<b>RunWithElevatedprivileges</b></div>
<div>
http://sharepointquicksolutions.blogspot.in/2012/11/all-ways-of-runwithelevatedprivileges.html</div>
<div>
<br /></div>
<div>
<b>AllowUnsafeUpdates</b></div>
<div>
http://sharepointquicksolutions.blogspot.in/2012/03/whenwherewhy-use-allowunsafeupdates-in.html</div>
<div>
<br /></div>
<div>
<b>ForDigest Control</b></div>
<div>
http://sharepointquicksolutions.blogspot.in/2012/03/wherewhenwhy-formdigest-control.html</div>
<div>
<br /></div>
<div>
<b>Interviews questions with answers:</b></div>
<div>
http://sharepointquicksolutions.blogspot.in/2013/01/list-vs-library-sharepoint-interview.html</div>
<div>
http://sharepointquicksolutions.blogspot.in/2015/07/sharepoint-faqslistvslibrary.html</div>
<div>
http://sharepointquicksolutions.blogspot.in/2012/06/content-types-in-sharepoint.html</div>
<div>
<br /></div>
<div>
<b>PowerShell Scripts</b>:</div>
<div>
http://sharepointquicksolutions.blogspot.in//search/label/PowerShell</div>
<div>
<br /></div>
<div>
<br /></div>
</div>
<div>
<span style="background-color: yellow;">Your valuable suggestions/feedback helps me to give best outputs/results</span>.</div>
<br /></div>
Anonymoushttp://www.blogger.com/profile/15414514889165889118noreply@blogger.com1tag:blogger.com,1999:blog-482466563826823203.post-81850641461323176842016-06-18T00:03:00.000-07:002016-06-18T00:03:27.297-07:00SharePoint 2016 tutorials: Class Day2<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="MsoNormal" style="background: white;">
In Day 1 session, we
discussed why SharePoint technology is
now on demand and how much the importance of having an clear idea about on software
and hardware boundaries.</div>
<div class="MsoNormal" style="background: white;">
<br /></div>
<div class="MsoNormal" style="background: white;">
In Day 2 session, we
will cover the below topics:</div>
<div class="MsoNormal" style="background: white;">
</div>
<ol style="text-align: left;">
<li>SharePoint
configuration.</li>
<li>SharePoint farms and its
types. Use of it.(Small/Medium/Large farms).</li>
<li>12/14/15/16 hive
folder structure.</li>
<li>SharePoint site
hierarchy.</li>
<li>SharePoint features<span style="font-size: 10pt;">.</span></li>
<li>web application,
Inetmgr, content DB.</li>
<li>Real time examples.</li>
</ol>
<br />
<div class="MsoNormal" style="background: white;">
Refer the below
article for interview questions with answers and also covered with some real-time
scenarios.</div>
<div class="MsoNormal" style="background: white;">
<br /></div>
<div class="MsoNormal" style="background: white;">
</div>
<div class="MsoNormal" style="background: white;">
<a href="http://sharepointquicksolutions.blogspot.in/2012/10/sharepoint-interview-questions-and_19.html" target="_blank">http://sharepointquicksolutions.blogspot.in/2012/10/sharepoint-interview-questions-and_19.html </a></div>
</div>
Anonymoushttp://www.blogger.com/profile/15414514889165889118noreply@blogger.com0tag:blogger.com,1999:blog-482466563826823203.post-13531318158177463542016-05-27T22:54:00.000-07:002016-05-27T22:54:53.056-07:00SharePoint 2016 tutorials: Class Day 1<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="MsoNormal">
<b><span style="font-family: "arial" , "helvetica" , sans-serif;">What/Why is SharePoint and use of it?</span></b></div>
<div class="MsoNormal">
</div>
<ul style="text-align: left;">
<li><span style="font-family: "arial" , "helvetica" , sans-serif;">SharePoint is browser based
collaboration/web platform. You can
access it from anywhere.</span></li>
<li><span style="font-family: "arial" , "helvetica" , sans-serif;">Enterprise Content management</span></li>
<li><b style="font-family: Arial, Helvetica, sans-serif;">Example</b><span style="font-family: "arial" , "helvetica" , sans-serif;">: Document Management [Sharing/versionsing/Checkin&Checkout/Permisisions/Search/Workflow
process/Recycle Bin]</span></li>
<li><span style="font-family: "arial" , "helvetica" , sans-serif;">Calendar(create tasks/schedule
meeting/). We can easily integrate the outlook to SharePoint.</span></li>
<li><span style="font-family: "arial" , "helvetica" , sans-serif;">services( BCS/Excel service and Reporting
services etc..)</span></li>
<li><span style="font-family: "arial" , "helvetica" , sans-serif;">Rich browser based UI Interface(
like drap/drop of files to the document library etc.. )</span></li>
<li><span style="font-family: "arial" , "helvetica" , sans-serif;">Authentication and Authorization:
Single Sign on etc..</span></li>
<li><span style="font-family: "arial" , "helvetica" , sans-serif;">yammer integration( Its similar to
Face book, Twitter but only difference is these are public social networks and
Yammer is private social network).</span></li>
<li><span style="font-family: "arial" , "helvetica" , sans-serif;">Mutli-Language supports( 12 hive
means it supports English language)</span></li>
<li><b style="font-family: Arial, Helvetica, sans-serif;">REST API</b><span style="font-family: "arial" , "helvetica" , sans-serif;">: Through REST API, we can interact directly with
SharePoint objects by using any technology that support REST web request and
can be easily perform CRUD operations.</span></li>
<li><span style="font-family: "arial" , "helvetica" , sans-serif;">Office 365</span></li>
<li><span style="font-family: "arial" , "helvetica" , sans-serif;">Apps, Cloud model</span></li>
</ul>
<br />
<div class="MsoNormal">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span></div>
<div class="MsoNormal">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><b>Software and hardware
boundaries</b>:</span></div>
<div class="MsoNormal">
<span style="font-family: "arial" , "helvetica" , sans-serif;">We should have basic understanding about on SharePoint
software and hardware requirements before proceeding with the SharePoint. This
helps us to decide whether to go with SharePoint
or not.</span></div>
<div class="MsoNormal">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span></div>
<div class="MsoNormal">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><b>Example</b>: </span></div>
<div class="MsoNormal">
<span style="font-family: "arial" , "helvetica" , sans-serif;">Migrate.net application project to SharePoint 2010/2013? </span></div>
<div class="MsoNormal">
<span style="font-family: "arial" , "helvetica" , sans-serif;">Before proceed to go with the migration, we should think
about whether it really supports or not. For that it's better to have an idea about on the
software/hardware boundaries. Let's say
SharePoint 2010 supports .Net framework 3.5 but they have used .Net framework 4.0/4.5 framework to develop
the project. in this case SharePoint won't support it and migration is not
possible.</span></div>
<div class="MsoNormal">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span></div>
<div class="MsoNormal">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><b><u>Note</u></b>:
SharePoint always supports backward compatibility.</span></div>
<div class="MsoNormal">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span></div>
<div class="MsoNormal" style="background: white;">
<span style="font-family: "arial" , "helvetica" , sans-serif;">Please go through the
below article for the software and hardware boundaries:</span></div>
<div class="MsoNormal" style="background: white;">
<span style="font-family: "arial" , "helvetica" , sans-serif;">http://www.sharepointpitstop.com/2012/10/sharepoint2013-hardware-and-software.html
</span></div>
<div class="MsoNormal" style="background: white;">
<span style="font-family: "arial" , "helvetica" , sans-serif;">https://technet.microsoft.com/en-IN/library/cc262485.aspx
</span></div>
<div class="MsoNormal" style="background: white;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><b><br /></b></span></div>
<div class="MsoNormal" style="background: white;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><b>Technologies</b>: </span></div>
<br />
<div class="MsoNormal" style="background: white;">
<span style="font-family: "arial" , "helvetica" , sans-serif;">C#, Asp.net, HTML,
CSS, JavaScript, JQuery, Angular JS, Bootstrap, REST API, Apps, SharePoint 2010/2013/2016. Workflows.</span></div>
<div class="MsoNormal" style="background: white;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span></div>
<div class="MsoNormal" style="background: white;">
<br /></div>
</div>
Anonymoushttp://www.blogger.com/profile/15414514889165889118noreply@blogger.com1tag:blogger.com,1999:blog-482466563826823203.post-80137408400289494762016-01-20T22:36:00.001-08:002016-01-20T22:37:53.599-08:00SharePoint Interview Questions and Answers: EventRecievers1<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="MsoNormal">
</div>
<ol style="text-align: left;">
<li>How to handle the access denied event for
RunWithElevatedPrivileges<a href="https://www.blogger.com/null" name="_GoBack"></a>?</li>
<li>How to define/use SPSite and SPWeb objects in event
receivers?</li>
<li>How to handle the event receiver scope level in event receiver?</li>
<li>The Modified By/Modified columns should not be updated if
there no changes made in the SharePoint list/library?</li>
<li>Dispose objects in event receivers?</li>
</ol>
<div>
<br />
<a href="http://sharepointquicksolutions.blogspot.in/2012/07/event-receivers-interview-questions-and.html" target="_blank"><<Prev Post>></a> <a href="http://sharepointquicksolutions.blogspot.in/2012/07/event-receivers-interview-questions-and.html" target="_blank"><<Next Post>></a><br />
<br /></div>
<div>
Answers for the above questions are in progress and published soon.</div>
<br /></div>
Anonymoushttp://www.blogger.com/profile/15414514889165889118noreply@blogger.com0tag:blogger.com,1999:blog-482466563826823203.post-51900664504479218262015-09-05T06:21:00.000-07:002015-09-05T06:21:55.809-07:00SharePoint list view web address is not displaying the absolute URL<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="MsoNormal">
<b>Issue</b>: SharePoint
list web address is not displaying the absolute URL:<o:p></o:p></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<b>Description</b>:
Recently, we migrated SharePoint 2010 applications to 2013. While doing content
validation in SP2013 to check whether all the metadata is migrated properly, we
found an issue that most of the list web address is not showing the complete
view URL. It is just showing web application URL.<o:p></o:p></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<b>Solution</b>: You will
face such type of issues if no view set as by default to the list. Check the
list views and set any of the view by default and check, it will show the
complete view URL.<o:p></o:p></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
Regards,<br />
Sasi Kumar Reddy</div>
<div class="MsoNormal">
sharepointquicksolutions.blogspot.in</div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<br /></div>
<br />
<div class="MsoNormal">
<br /></div>
</div>
Anonymoushttp://www.blogger.com/profile/15414514889165889118noreply@blogger.com1tag:blogger.com,1999:blog-482466563826823203.post-1012294486645862612015-07-08T10:48:00.000-07:002015-07-08T10:49:11.398-07:00Sharepoint interview questions with answers: lists and library<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="MsoNormal">
I had faced below listed issues
while doing migration from SharePoint 2007/2010 to 2013:<o:p></o:p></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<span style="color: #c55a11; mso-style-textfill-fill-alpha: 100.0%; mso-style-textfill-fill-color: #C55A11; mso-style-textfill-fill-colortransforms: lumm=75000; mso-style-textfill-fill-themecolor: accent2; mso-themecolor: accent2; mso-themeshade: 191;">Quick Edit view issue:<o:p></o:p></span></div>
<div class="MsoNormal">
<a href="http://www.sharepointdiary.com/2014/12/fix-quick-edit-disabled-in-sharepoint-2013-issue.html">http://www.sharepointdiary.com/2014/12/fix-quick-edit-disabled-in-sharepoint-2013-issue.html</a>
<o:p></o:p></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<span style="color: #c55a11; mso-style-textfill-fill-alpha: 100.0%; mso-style-textfill-fill-color: #C55A11; mso-style-textfill-fill-colortransforms: lumm=75000; mso-style-textfill-fill-themecolor: accent2; mso-themecolor: accent2; mso-themeshade: 191;">Quick Edit view: Result: Get "Assertion Failed: Break into
debugger?"<o:p></o:p></span></div>
<div class="MsoNormal">
<a href="http://www.brandmysharepoint.de/quickedit-in-listen-wirft-javascript-meldung/">http://www.brandmysharepoint.de/quickedit-in-listen-wirft-javascript-meldung/</a>
<o:p></o:p></div>
<div class="MsoNormal">
We applied the JavaScript at
master page level, issue solved.<o:p></o:p></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<span style="color: #c55a11; mso-style-textfill-fill-alpha: 100.0%; mso-style-textfill-fill-color: #C55A11; mso-style-textfill-fill-colortransforms: lumm=75000; mso-style-textfill-fill-themecolor: accent2; mso-themecolor: accent2; mso-themeshade: 191;">“Files” and “library” option are not available by default in ribbon
for document library:</span><o:p></o:p></div>
<div class="MsoNormal">
Issue is it will be disabled if
you add any web part to the OOB pages (like CEWP)<o:p></o:p></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<span style="color: #c55a11; mso-style-textfill-fill-alpha: 100.0%; mso-style-textfill-fill-color: #C55A11; mso-style-textfill-fill-colortransforms: lumm=75000; mso-style-textfill-fill-themecolor: accent2; mso-themecolor: accent2; mso-themeshade: 191;">By default, SharePoint limitation for Size of URL is 260
characters. </span><b><span style="color: #1f497d;"><o:p></o:p></span></b></div>
<div class="MsoNormal">
<b><span style="color: #1f497d;">You might get the below
exception if exceed the limit</span></b><span style="color: #1f497d;">:<o:p></o:p></span></div>
<div class="MsoNormal">
<span style="color: red;">Exception: The specified file or
folder name is too long. The URL path for all files and folders must be 260
characters or less (and no more than 128 characters for any single file or
folder name in the URL). Please type a shorter file or folder name</span><span style="color: #1f497d;">.</span><o:p></o:p></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<span style="color: #1f497d;">Note: Microsoft recommended size
limit for single file name is 128 characters and URL limit is 260 characters. </span><o:p></o:p></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<span style="color: #1f497d;">I have uploaded one document to
the document library and when I open it through browser the size of the URL is
258 characters(max limit 260) and later on I have changed the web application “<a href="http://india.com/" target="_blank"><span style="color: #1f497d; text-decoration: none; text-underline: none;">http://India.com</span></a></span>”<span style="color: #1f497d;"> to <a href="http://allindia.test.ind.com/" target="_blank"><span style="color: #1f497d; text-decoration: none; text-underline: none;">http://allindia.test.IND.com</span></a>
and now my the document size of the URL is 263 characters(means exceeded the
limit). My Question how the SharePoint handles these types of scenarios?</span><o:p></o:p></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<u><span style="color: #1f497d;">As per my analysis</span></u><span style="color: #1f497d;">: you can’t edit/download the document but we can view
the document through browser.</span><o:p></o:p></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<span style="color: #c55a11; mso-style-textfill-fill-alpha: 100.0%; mso-style-textfill-fill-color: #C55A11; mso-style-textfill-fill-colortransforms: lumm=75000; mso-style-textfill-fill-themecolor: accent2; mso-themecolor: accent2; mso-themeshade: 191;">View the large number of records in SharePoint list/library:</span><o:p></o:p></div>
<div class="MsoNormal">
We can view the large number of records
(around 1lac) by removing the filters, group by/sort by and select the “Show
items without folders” option.<o:p></o:p></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<span style="color: #c55a11; mso-style-textfill-fill-alpha: 100.0%; mso-style-textfill-fill-color: #C55A11; mso-style-textfill-fill-colortransforms: lumm=75000; mso-style-textfill-fill-themecolor: accent2; mso-themecolor: accent2; mso-themeshade: 191;">Export to excel the list item with attachments:<o:p></o:p></span></div>
<div class="MsoNormal">
We can achieve it by using the
"<b>Open with access</b>" option. From there if wants we can directly
download from the access. <o:p></o:p></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<span style="color: #c55a11; mso-style-textfill-fill-alpha: 100.0%; mso-style-textfill-fill-color: #C55A11; mso-style-textfill-fill-colortransforms: lumm=75000; mso-style-textfill-fill-themecolor: accent2; mso-themecolor: accent2; mso-themeshade: 191;">Export to excel the list item with attachments URLs:<o:p></o:p></span></div>
<div class="MsoNormal">
We can achieve it by using <b>web
service</b> concept in Nintex<o:p></o:p></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<b>Export to Excel</b>”. Keep in mind that you can’t export a list that has more
than 52,000 items;
<o:p></o:p></div>
<div class="MsoNormal">
<a href="http://lyndzhang.wordpress.com/2012/09/27/working-with-large-lists-in-sharepoint/" target="_blank">http://lyndzhang.wordpress.com/2012/09/27/working-with-large-lists-in-sharepoint/</a><o:p></o:p></div>
<br />
<div class="MsoNormal">
<br /></div>
</div>
Anonymoushttp://www.blogger.com/profile/15414514889165889118noreply@blogger.com3tag:blogger.com,1999:blog-482466563826823203.post-31437339933461560152015-06-19T17:52:00.000-07:002015-06-19T17:52:04.263-07:00Solve edit page not working issue<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
Edit the sharepoint page:<br />
<br />
Append the below one to the url if you are unable to edit the sharepoint pages and then now try to click on edit page option. problem solved.<br />
<br />
<span style="background-color: yellow;">?toolpaneview=2</span><br />
<br />
Example:<br />
<br />
URL: http://abc.com/sitepages/Home.aspx?toolpaneview=2<br />
<br />
Please let me know for any issues.<br />
<br />
Regards,<br />
Sasi Kumar Reddy<br />
<br />
<br /></div>
Anonymoushttp://www.blogger.com/profile/15414514889165889118noreply@blogger.com2tag:blogger.com,1999:blog-482466563826823203.post-87533997065286852912015-05-16T19:50:00.000-07:002015-05-16T19:50:39.122-07:00ExportVsImport: SharePoint interview questions with answers<div dir="ltr" style="text-align: left;" trbidi="on">
<span class="Apple-style-span" style="color: #c00000;">Export and Import limitations:</span><br />
<div class="MsoNormal">
<u><span lang="EN-US" style="mso-ansi-language: EN-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-hansi-font-family: Calibri;">Major drawback</span></u><span lang="EN-US" style="mso-ansi-language: EN-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-hansi-font-family: Calibri;">: The export/import does not preserve workflows instances, associations,
history and tasks. Every workflow association must be recreated and there is no
way to restore the running instances from original site.<o:p></o:p></span></div>
<div class="MsoNormal">
<span lang="EN-US" style="mso-ansi-language: EN-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-hansi-font-family: Calibri;">If publishing feature is enabled in source site and same should be
applicable for targeted site also.<o:p></o:p></span></div>
<div class="MsoNormal">
<span lang="EN-US" style="mso-ansi-language: EN-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-hansi-font-family: Calibri;"><br /></span></div>
<div class="MsoNormal">
<span style="color: #c00000;">How can we do the export/import of
site, list and libraries along with versioning?<o:p></o:p></span></div>
<div class="MsoNormal">
<span style="mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;">Use the [-<b style="mso-bidi-font-weight: normal;">IncludeVersions</b>]
option to instruct PowerShell to include version information of items in the
export file.<o:p></o:p></span></div>
<div class="MsoNormal">
<span style="mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;">Example:<o:p></o:p></span></div>
<div class="MsoNormal">
<span style="mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;">Export-SPWeb -Identity </span><a href="http://sharepoint/site"><span style="mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;">http://sharepoint/site</span></a><span style="mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;"> -Path "E:\exports\MySite.cmp"
-IncludeVersions ALL<o:p></o:p></span></div>
<div class="MsoNormal">
<span style="mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;"><br /></span></div>
<div class="MsoNormal">
<span style="color: #c00000;">Export the sites, lists and
libraries?<o:p></o:p></span></div>
<div class="MsoNormal">
<span style="mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;">To export/import a specific list or library, provide the full URL
to the list or library, otherwise PowerShell will import/export the site if the
URL is to the main site location.<o:p></o:p></span></div>
<div class="MsoNormal">
<span style="mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;">Include the [-<b style="mso-bidi-font-weight: normal;">IncludeVersions</b>]
option to instruct PowerShell to include version information of items in the
export file.<o:p></o:p></span></div>
<div class="MsoNormal">
<span style="mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;">Include the [-NoFileCompression] option to turn off file
compression; this makes for a faster export but larger files on disk.<o:p></o:p></span></div>
<div class="MsoNormal">
<span style="mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;">Include the -haltonfatalerror or -haltonwarning options to stop
the import\export process in the event of an error or warning.<o:p></o:p></span></div>
<div class="MsoNormal">
<span style="mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;">In SharePoint 2007, administrators could export and import sites
only, using STSADM<o:p></o:p></span></div>
<div class="MsoNormal">
<span style="mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;"><br /></span></div>
<div class="MsoNormal">
<span style="color: #c00000;">Export and Import use in
sharepoint?<o:p></o:p></span></div>
<div class="MsoNormal">
<b>Backup-SPSite</b> is generally used when you want to
replicate the entire site collection (including all subsites) to an existing
web application.</div>
<div class="MsoNormal">
<b>Export-SPWeb</b> is generally used when you want to
replicate just a single subsite to an existing site collection.</div>
<div class="MsoNormal">
From SP2010 onwards, you can export a site, lists and
library through either central adminitrator or poweshell but we can only way to
do import is through powershell.</div>
<div class="MsoNormal">
<b style="mso-bidi-font-weight: normal;"><br /></b></div>
<div class="MsoNormal">
<span class="Apple-style-span" style="background-color: yellow;"><b style="mso-bidi-font-weight: normal;">Limitations</b>:</span></div>
<div class="MsoNormal">
Workflows are not included when we export/import contents of
sites, libraries, or lists means Export-SPWeb does not export the running
workflows.</div>
<div class="MsoNormal">
Export-SPWeb: </div>
<div class="MsoNormal">
Paramaters:<span style="mso-spacerun: yes;"> </span>NoFileCompression,
</div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<b style="mso-bidi-font-weight: normal;">Note</b>: The
NoFileCompression parameter lets you specify that no file compression is
performed during the export process. Using this parameter can lower resource
usage up to 30% during the export process. Using this parameter will result in
a backup folder being created instead of a compressed file. If you use the
NoFileCompression parameter in the Export-SPWeb command, you must also use it
when you import the content by using the Import-SPWeb command.</div>
<div class="MsoNormal">
<span lang="EN-US" style="mso-ansi-language: EN-US; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-hansi-font-family: Calibri;">includeusersecurity : Do not forget to use includeusersecurity parameter
in both export and import if you wish to preserve information relative to
permissions and other properties such as documents authors.</span></div>
</div>
Anonymoushttp://www.blogger.com/profile/15414514889165889118noreply@blogger.com1tag:blogger.com,1999:blog-482466563826823203.post-10686078995893279492015-04-03T10:58:00.006-07:002015-04-03T10:58:38.047-07:00Restore-SPSite problems in sharepoint<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="MsoNormal">
I have a requirement change the site collection URL (path
based). Best recommended way to change the site collection URL in sharepoint
2010 is backup and restore. I followed the same, first I took the backup and then
trying to restore the same but it giving exception.</div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<span style="background-color: yellow;">Observation</span>: Restoration fails if any of the URL characters
exceed the limit of 260 characters. So, please check the URL characters before proceeds
with backup and restore. </div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
Below script will
give the accurate results of the URL characters:<o:p></o:p></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
Step1: connect to the DB server and then select the
content DB<o:p></o:p></div>
<br />
<div class="MsoNormal">
Step2: Run the
script<o:p></o:p></div>
<div class="MsoNormal">
<br /></div>
<table border="1" cellpadding="0" cellspacing="0" class="MsoTableGrid" style="border-collapse: collapse; border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 0in 5.4pt 0in 5.4pt; mso-yfti-tbllook: 1184;">
<tbody>
<tr style="height: 118.85pt; mso-yfti-firstrow: yes; mso-yfti-irow: 0; mso-yfti-lastrow: yes;">
<td style="border: solid windowtext 1.0pt; height: 118.85pt; mso-border-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 312.85pt;" valign="top" width="417"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
SELECT<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
([DirName]+ N'/'+ [LeafName]) AS
[FullRelativePath],<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
LEN([DirName]+ N'/'+ [LeafName]) AS
[Length]<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
FROM <o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
[dbo].[AllDocs]<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
ORDER BY <o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
[Length] DESC<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<br /></div>
</td>
</tr>
</tbody></table>
<br /><div>
Note: If any of the URL characters exceeds the 260 characters, please make it below and then try to do the back up and restore.</div>
<div>
<br /></div>
<div>
-Thanks,</div>
<div>
Sasi kumar Reddy</div>
</div>
Anonymoushttp://www.blogger.com/profile/15414514889165889118noreply@blogger.com3tag:blogger.com,1999:blog-482466563826823203.post-18540211176675873352015-04-02T21:45:00.000-07:002015-04-02T21:45:56.042-07:00Solving access denied login for site collection administrators<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="MsoNormal">
<span style="font-size: 12pt; line-height: 115%;">Recently we
migrated the applications from sharepoint 2007 to 2010. Once it’s done, we
tried to browse the application but it is giving access denied error. Initially
I thought it was due to access issue but I am the primary site collection administrator
to that application.</span></div>
<div class="MsoNormal">
<span style="font-size: 12pt; line-height: 115%;"><br /></span></div>
<div class="MsoNormal">
<span style="font-size: 12.0pt; line-height: 115%;"><span style="background-color: yellow;">Workaround</span>: Check status of the content DB whether it is
in read-only or not locked stage. If it is in read-only, change it to “Not
locked” and then save it.<o:p></o:p></span></div>
<div class="MsoNormal">
<span style="font-size: 12.0pt; line-height: 115%;"><br /></span></div>
<div class="MsoNormal">
<span style="font-size: 12.0pt; line-height: 115%;">Now try to
browse the application and this time you can able to browse.<o:p></o:p></span></div>
<div class="MsoNormal">
<span style="font-size: 12.0pt; line-height: 115%;"><br /></span></div>
<div class="MsoNormal">
<span style="font-size: 12.0pt; line-height: 115%;">Regards,</span></div>
<div class="MsoNormal">
<span style="font-size: 12.0pt; line-height: 115%;">Sasi Kumar Reddy</span></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<br /></div>
<br />
<div class="MsoNormal">
<br /></div>
</div>
Anonymoushttp://www.blogger.com/profile/15414514889165889118noreply@blogger.com0tag:blogger.com,1999:blog-482466563826823203.post-28242602148798606632015-02-24T09:37:00.004-08:002015-02-27T20:49:37.281-08:00 Crawled Vs Managed properties: Search<div dir="ltr" style="text-align: left;" trbidi="on">
<span class="Apple-style-span" style="color: red;"></span><br />
<div class="MsoNormal">
</div>
<ol style="text-align: left;">
<li><span class="Apple-style-span" style="color: red;">How to create crawled and managed
properties?</span></li>
<li><span class="Apple-style-span" style="color: red;">Are managed properties works at web application, site collection and site
level?</span></li>
<li><span class="Apple-style-span" style="color: red;">How to map crawled properties with managed properties?</span></li>
<li><span class="Apple-style-span" style="color: red;">When full crawl is required?</span></li>
<li><span class="Apple-style-span" style="color: red;">Automatically creation of managed properties not supports what are all data
types?</span></li>
<li><span class="Apple-style-span" style="color: red;">New features introduced in SP2013?</span></li>
<li><span class="Apple-style-span" style="color: red;">Is full crawl required for each map between crawled and managed property?</span></li>
<li><span class="Apple-style-span" style="color: red;">Difference between creating crawled property at SSA level and site collection
level?</span></li>
<li><span class="Apple-style-span" style="color: red;">I have created one managed property of type “Text”. As per the current
requirement I want to change it “Choice”. Is it possible?</span></li>
<li><span class="Apple-style-span" style="color: red;">I have created one site column of type “Single line of text”. As per the new
feature introduced from the sharepoint 2013, automatically managed property
will create for each site column creation. So far everything is clear. Now my
question is will change the data type of managed property as changed at the
site column level?</span></li>
<li><span class="Apple-style-span" style="color: red;">I have two different lists in site and there is one common field in both the
list. Now, I want to map that field to the managed property?</span></li>
<li><span class="Apple-style-span" style="color: red;">Limitations on automatically creation of managed property for the site columns?</span></li>
</ol>
<br />
<div class="MsoNormal">
<span class="Apple-style-span" style="color: red;">New features introduced on managed
and crawled properties in SP2013?</span></div>
<br />
<div class="MsoNormal">
<div class="MsoNormal">
From SP2013 onwards, only site columns that contain values will
automatically become managed properties when they are crawled and full crawl is
required.</div>
<div class="MsoNormal">
In sp2010, whenever a new item was discovered during a
crawl, users would have to manually create a new managed property, and map
this to the corresponding crawled property.<br />
<br />
<div class="MsoNormal">
<span style="color: red;">What is the use of creating managed
properties and why mapping required to the crawled properties?<o:p></o:p></span></div>
<div class="MsoNormal">
Crawled properties are useless(means can’t be searchable/not
us in Refinable) <span style="mso-spacerun: yes;"> </span>without mapping it to
the Managed properties and next point why mapping required is we can assign behaving
similar ways of crawled properties to one managed properties. </div>
<div class="MsoNormal">
To include the content and metadata of crawled properties in
the search index, you map crawled properties to managed properties.<br />
<br /></div>
<b style="mso-bidi-font-weight: normal;"><span style="font-family: "Calibri","sans-serif"; font-size: 11.0pt; line-height: 115%; mso-ansi-language: EN-IN; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: AR-SA; mso-bidi-theme-font: minor-bidi; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: EN-IN; mso-fareast-theme-font: minor-fareast; mso-hansi-theme-font: minor-latin;">Example</span></b><span style="font-family: "Calibri","sans-serif"; font-size: 11.0pt; line-height: 115%; mso-ansi-language: EN-IN; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: AR-SA; mso-bidi-theme-font: minor-bidi; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: EN-IN; mso-fareast-theme-font: minor-fareast; mso-hansi-theme-font: minor-latin;">: Modified By, Created By and Author crawled
properties behaves in similar way. Rather performing individual assign all 3 to
one managed property called “<b style="mso-bidi-font-weight: normal;">Author</b>”
[see the below image]</span><br />
<span style="font-family: "Calibri","sans-serif"; font-size: 11.0pt; line-height: 115%; mso-ansi-language: EN-IN; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: AR-SA; mso-bidi-theme-font: minor-bidi; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: EN-IN; mso-fareast-theme-font: minor-fareast; mso-hansi-theme-font: minor-latin;"><br /></span>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhXs63aZIqAzCh8S4hLvUGgOt8uFq0xm7170FF3RromYXUcsEDLxK-4-1cunGSLcjQXBk3fP82V1Wq1hwLapfGl-M3radfQ83EClCQRv7tCX0nhr57_9blzhRm8l_D1p7q5uQZxc52l4A/s1600/MMP1.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhXs63aZIqAzCh8S4hLvUGgOt8uFq0xm7170FF3RromYXUcsEDLxK-4-1cunGSLcjQXBk3fP82V1Wq1hwLapfGl-M3radfQ83EClCQRv7tCX0nhr57_9blzhRm8l_D1p7q5uQZxc52l4A/s1600/MMP1.jpg" /></a></div>
<span style="font-family: "Calibri","sans-serif"; font-size: 11.0pt; line-height: 115%; mso-ansi-language: EN-IN; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: AR-SA; mso-bidi-theme-font: minor-bidi; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: EN-IN; mso-fareast-theme-font: minor-fareast; mso-hansi-theme-font: minor-latin;"><br /></span>
</div>
<div class="MsoNormal">
<span class="Apple-style-span" style="color: red;">Is full crawl required for each map
between crawled and managed property?</span><br />
<span style="color: black;">Yes, Full crawl should be
required. <o:p></o:p></span><br />
<span style="color: black;"><br /></span></div>
<div class="MsoNormal">
<span style="color: red;">When full crawl is required?<br />
</span>When you create a new managed property, or when you change certain
settings on existing managed properties, a full crawl must complete before the managed
property and its value is included in the search index.</div>
<div class="MsoNormal">
When you have changed a managed property, or when you have
changed the mapping of crawled and managed properties, the site must be re-crawled
before your changes will be reflected in the search index. Because your changes
are made in the search schema, and not to the actual site, the crawler will not
automatically re-index the site.<span style="color: black; mso-themecolor: text1;"><o:p></o:p></span><br />
<br /></div>
<div class="MsoNormal">
<span style="color: red;">Are managed properties works at web
application, site collection and site level?<br />
</span><span style="color: black; mso-themecolor: text1;">At site collection level.<span class="Apple-style-span" style="color: red;"><o:p></o:p></span></span><br />
<span style="color: black; mso-themecolor: text1;"><br /></span></div>
<div class="MsoNormal">
<span style="color: red;">Automatically creation of managed
properties not supports what are all data types?<br />
</span>Managed properties are created automatically for site columns that
contain values during crawl and it’s mapped to crawled properties (Note: All spaces are removed). But automatic creations
of managed properties are not supported for the following site column types: </div>
<div class="MsoNormal">
<br />
<ul style="text-align: left;">
<li>Lookup</li>
<li>Calculated</li>
<li>Task outcome</li>
<li>Summary Links data</li>
<li>Rich media data for publishing</li>
</ul>
</div>
<div class="MsoNormal" style="color: red;">
<span style="color: red;">Difference between creating managed
properties at site collection level and SSA level?<o:p></o:p></span></div>
<div class="MsoNormal">
Big differences between managed properties created in the
site collection versus the SSA are that when you create new managed properties
in the site collection they have the below limitations you should be aware of:</div>
<div class="MsoNormal">
<br />
<ul style="text-align: left;">
<li>They can only be text and Yes/No</li>
<li>They cannot be sortable</li>
<li>They cannot be refinable</li>
<li>They cannot allow multiple values</li>
<li><br /><div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhC4XwPYSRQlqGTOV9Re0-q9vxJBUucJoKBMEw3ktQa4bF1hgsaG4JTp8phMgKzed6sNrWjzF2K4G2UQGHzqt9z36R1v-WJEP3yQvyF3X7_KJ-BDzO02MlK1B9Em-mZCXSbqZX25bWMCQ/s1600/ManagedProperties.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhC4XwPYSRQlqGTOV9Re0-q9vxJBUucJoKBMEw3ktQa4bF1hgsaG4JTp8phMgKzed6sNrWjzF2K4G2UQGHzqt9z36R1v-WJEP3yQvyF3X7_KJ-BDzO02MlK1B9Em-mZCXSbqZX25bWMCQ/s1600/ManagedProperties.jpg" height="150" width="400" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEitkrNACXY25HkeGcdekLK7Ql1jh1POtH-6HDFBAJGDLeGz3P60ipSxji9yxjeE1EZmPe4LvrFXoKeazlsZX-c9_9IpGbt8XxrUi5nQVRDw2dCnOXjifhKWTDk9JprnGnO98uBPNn0qLA/s1600/MMP.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEitkrNACXY25HkeGcdekLK7Ql1jh1POtH-6HDFBAJGDLeGz3P60ipSxji9yxjeE1EZmPe4LvrFXoKeazlsZX-c9_9IpGbt8XxrUi5nQVRDw2dCnOXjifhKWTDk9JprnGnO98uBPNn0qLA/s1600/MMP.jpg" height="286" width="400" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
</li>
</ul>
</div>
<div class="MsoNormal" style="color: red;">
<span style="mso-no-proof: yes;"><v:shapetype coordsize="21600,21600" filled="f" id="_x0000_t75" o:preferrelative="t" o:spt="75" path="m@4@5l@4@11@9@11@9@5xe" stroked="f">
<v:stroke joinstyle="miter">
<v:formulas>
<v:f eqn="if lineDrawn pixelLineWidth 0">
<v:f eqn="sum @0 1 0">
<v:f eqn="sum 0 0 @1">
<v:f eqn="prod @2 1 2">
<v:f eqn="prod @3 21600 pixelWidth">
<v:f eqn="prod @3 21600 pixelHeight">
<v:f eqn="sum @0 0 1">
<v:f eqn="prod @6 1 2">
<v:f eqn="prod @7 21600 pixelWidth">
<v:f eqn="sum @8 21600 0">
<v:f eqn="prod @7 21600 pixelHeight">
<v:f eqn="sum @10 21600 0">
</v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:formulas>
<v:path gradientshapeok="t" o:connecttype="rect" o:extrusionok="f">
<o:lock aspectratio="t" v:ext="edit">
</o:lock></v:path></v:stroke></v:shapetype><v:shape id="Picture_x0020_2" o:gfxdata="UEsDBBQABgAIAAAAIQA0Ev94FAEAAFACAAATAAAAW0NvbnRlbnRfVHlwZXNdLnhtbKSSy07DMBBF
90j8g+UtSpyyQAg16YLHEliUDxjsSWLhl2y3tH/PJE0kqEo33Vj2zNy5x2MvVztr2BZj0t7VfFFW
nKGTXmnX1fxj/VLcc5YyOAXGO6z5HhNfNddXy/U+YGKkdqnmfc7hQYgke7SQSh/QUab10UKmY+xE
APkFHYrbqroT0ruMLhd56MGb5RO2sDGZPe8ofCAJruPs8VA3WNVc20E/xMVJRUSTjiQQgtESMt1N
bJ064iomppKUY03qdUg3BP6Pw5D5y/TbYNK90TCjVsjeIeZXsEQupNHh00NUQkX4ptGmebMozzc9
Qe3bVktUXm4szbCcOs7Y5+0zvQ+Kcb3ceWwz+4rxPzQ/AAAA//8DAFBLAwQUAAYACAAAACEArTA/
8cEAAAAyAQAACwAAAF9yZWxzLy5yZWxzhI/NCsIwEITvgu8Q9m7TehCRpr2I4FX0AdZk2wbbJGTj
39ubi6AgeJtl2G9m6vYxjeJGka13CqqiBEFOe2Ndr+B03C3WIDihMzh6RwqexNA281l9oBFTfuLB
BhaZ4ljBkFLYSMl6oAm58IFcdjofJ0z5jL0MqC/Yk1yW5UrGTwY0X0yxNwri3lQgjs+Qk/+zfddZ
TVuvrxO59CNCmoj3vCwjMfaUFOjRhrPHaN4Wv0VV5OYgm1p+LW1eAAAA//8DAFBLAwQUAAYACAAA
ACEAUMuBciQDAABXCAAAHwAAAGNsaXBib2FyZC9kcmF3aW5ncy9kcmF3aW5nMS54bWykVV1v2jAU
fZ+0/2D5fQ1lZaNR02pqRzWp21Dbac8Xx8TWHDuzTaD/fteOAwG16kSRAH+ee+65H7642tSKtNw6
aXRBT09GlHDNTCl1VdBfj7MPU0qcB12CMpoX9Ik7enX5/t0F5JWFRkhGEEG7HAoqvG/yLHNM8Brc
iWm4xr2lsTV4nNoqKy2sEblW2Xg0+pTVIDW93EHdgAeysvIIKGXYH15eg27BIaRi+XAlcVTs7ciQ
6/bWNg/N3Abm7Ec7t0SWBUXlNNQoEc3SRjqG0+zgVrUD2CxtHc6b5ZJsIspT+I0YfOMJw8XJ5/HZ
ZDyhhOEeKjcaT9IJJn4+c4+Jr6/cREKdYRwMyKSQziw6EkgFV2OQ48qhx2e9x3PJ/MpyMh64fnht
CH2HwXJEm2sBuuJfXMOZx+QLt5EPSnpoNen3AmZgmuDfkEFN5wQmD45y/KakwdERWbOPptu5ZEE+
XH4uZXB3J2B/prsBgcpLgu00tNasBYfS9Truo2RhusdioWQzk0oF8cI4eWv/x1fMVcn4jWGrmmvf
1bLlCjw2ESdk4yixOa8XHMvCfitjYCF3lt1joGNmO2+5ZyIYXyKJtI5h3m5ExjuSgb/DmiOL9XdT
YpXByhuMVZ/HxxUQGuzrr7HO33JTkzBA2sg0wkN75wJnPNofCVadUbLs9XO2WlwrS1pQBZ3FT7zr
BJS8W51OsGxTgqfjEXMPR2myLuh0eo5HCYOmoO5vB/SatY7gHlgtPbdEyRoR0fbWutKBP18u0UN0
LUzMCo8+iHJNFmpl7wHDNol8SSmDGKcBgOIEs2Ny1oERUBW+GF5hrI3/Lb14ENBgYEYd46Ek8Ua3
DqoR0EkSgZ6RZMsmCrRH1DGu+ccycGbYoiykaBnrhdl2GKN914iUrIS/lxWxEl8zvzZzn7zoYovE
CWZt7Lr4vMV/y9uCfg5NdqdYgukCtqPgmo7KgrdcPYbQjYM6lAiU7Hy07dHIx6wsJkhMnKEwKVdS
3xucC5UQ0WMZhMRH46EG8BtpDPrdcB4s9Bl9zIuyLQgcbPWMj0F28KQOrYauO5xf/gMAAP//AwBQ
SwMEFAAGAAgAAAAhAFNSiWHSAAAAqwEAACoAAABjbGlwYm9hcmQvZHJhd2luZ3MvX3JlbHMvZHJh
d2luZzEueG1sLnJlbHOskMFKBDEMhu+C71Byt5nZg4hsZy8i7FXWBwhtplOcpqWt4r691b04sODF
SyAJ+fLx7w+fcVUfXGpIYmDUAygWm1wQb+D19Hz3AKo2EkdrEjZw5gqH6fZm/8IrtX5Ul5Cr6hSp
BpbW8iNitQtHqjpllr6ZU4nUels8ZrJv5Bl3w3CP5TcDpg1THZ2BcnQ7UKdz7p//Zqd5Dpafkn2P
LO3KC2zdizuQiudmQOvL5FJH3V0Br2uM/6kRYo9goxHZBcKf+aiz+G8N3EQ8fQEAAP//AwBQSwME
FAAGAAgAAAAhAOFRNx/PBgAA5hsAABoAAABjbGlwYm9hcmQvdGhlbWUvdGhlbWUxLnhtbOxZzW/c
RBS/I/E/jHxvs9/NRt1U2c1uA23aKNkW9Thrz9rTjD3WzGzSvaH2iISEKIgDlbhxQEClVuJS/ppA
ERSp/wJvZmyvJ+uQtI2gguaQtZ9/877fm6/LV+7FDB0QISlPel79Ys1DJPF5QJOw590ajy6sekgq
nASY8YT0vDmR3pX199+7jNd8RtMJxyIYRyQmCBglcg33vEipdG1lRfpAxvIiT0kC36ZcxFjBqwhX
AoEPQUDMVhq1WmclxjTx1oGj0oyGDP4lSmqCz8SeZkNQgmOQfnM6pT4x2GC/rhFyLgdMoAPMeh7w
DPjhmNxTHmJYKvjQ82rmz1tZv7yC17JBTJ0wtjRuZP6ycdmAYL9hZIpwUgitj1rdS5sFfwNgahk3
HA4Hw3rBzwCw74OlVpcyz9Zotd7PeZZA9nGZ96DWrrVcfIl/c0nnbr/fb3czXSxTA7KPrSX8aq3T
2mg4eAOy+PYSvtXfGAw6Dt6ALL6zhB9d6nZaLt6AIkaT/SW0DuholHEvIFPOtirhqwBfrWXwBQqy
ocguLWLKE3VSrsX4LhcjAGggw4omSM1TMsU+5OQAxxNBsRaA1wgufbEkXy6RtCwkfUFT1fM+THHi
lSAvn33/8tkTdHT/6dH9n44ePDi6/6Nl5IzawklYHvXi28/+fPQx+uPJNy8eflGNl2X8rz988svP
n1cDoXwW5j3/8vFvTx8//+rT3797WAHfEHhSho9pTCS6QQ7RLo/BMOMVV3MyEa82YhxhWh6xkYQS
J1hLqeA/VJGDvjHHLIuOo0efuB68LaB9VAGvzu46Cu9FYqZoheRrUewAtzlnfS4qvXBNyyq5eTxL
wmrhYlbG7WJ8UCV7gBMnvsNZCn0zT0vH8EFEHDV3GE4UDklCFNLf+D4hFdbdodTx6zb1BZd8qtAd
ivqYVrpkTCdONi0GbdEY4jKvshni7fhm+zbqc1Zl9SY5cJFQFZhVKD8mzHHjVTxTOK5iOcYxKzv8
OlZRlZJ7c+GXcUOpINIhYRwNAyJl1ZibAuwtBf0aho5VGfZtNo9dpFB0v4rndcx5GbnJ9wcRjtMq
7B5NojL2A7kPKYrRDldV8G3uVoh+hzjg5MRw36bECffp3eAWDR2VFgmiv8yEjiW0aqcDxzT5u3bM
KPRjmwPn146hAT7/+lFFZr2tjXgD5qSqStg61n5Pwh1vugMuAvr299xNPEt2CKT58sTzruW+a7ne
f77lnlTPZ220i94KbVevG+yi2CyR4xNXyFPK2J6aM3JdmkWyhHkiGAFRjzM7QVLsmNIIHrO+7uBC
gc0YJLj6iKpoL8IpLLDrnmYSyox1KFHKJWzsDLmSt8bDIl3ZbWFbbxhsP5BYbfPAkpuanO8LCjZm
tgnN5jMX1NQMziqseSljCma/jrC6VurM0upGNdPqHGmFyRDDZdOAWHgTFiAIli3g5Q7sxbVo2Jhg
RgLtdzv35mExUTjPEMkIBySLkbZ7OUZ1E6Q8V8xJAORORYz0Ju8Ur5WkdTXbN5B2liCVxbVOEJdH
702ilGfwIkq6bo+VI0vKxckSdNjzuu1G20M+TnveFPa08BinEHWp13yYhXAa5Cth0/7UYjZVvohm
NzfMLYI6HFNYvy8Z7PSBVEi1iWVkU8N8ylKAJVqS1b/RBreelwE2019Di+YqJMO/pgX40Q0tmU6J
r8rBLlG07+xr1kr5TBGxFwWHaMJmYhdD+HWqgj0BlXA0YTqCfoFzNO1t88ltzlnRlU+vDM7SMUsj
nLVbXaJ5JVu4qeNCB/NWUg9sq9TdGPfqppiSPydTymn8PzNFzydwUtAMdAR8OJQVGOl67XlcqIhD
F0oj6o8ELBxM74BsgbNY+AxJBSfI5leQA/1ra87yMGUNGz61S0MkKMxHKhKE7EBbMtl3CrN6NndZ
lixjZDKqpK5MrdoTckDYWPfAjp7bPRRBqptukrUBgzuef+57VkGTUC9yyvXm9JBi7rU18E+vfGwx
g1FuHzYLmtz/hYoVs6odb4bnc2/ZEP1hscxq5VUBwkpTQTcr+9dU4RWnWtuxlixutHPlIIrLFgOx
WBClcN6D9D+Y/6jwmb1t0BPqmO9Cb0Vw0aCZQdpAVl+wCw+kG6QlTmDhZIk2mTQr69ps6aS9lk/W
57zSLeQec7bW7CzxfkVnF4szV5xTi+fp7MzDjq8t7URXQ2SPlyiQpvlGxgSm6tZpG6doEtZ7Htz8
QKDvwRPcHXlAa2haQ9PgCS6EYLFkb3F6XvaQU+C7pRSYZk5p5phWTmnllHZOgcVZdl+SUzrQqfQV
B1yx6R8P5bcZsILLbj/ypupcza3/BQAA//8DAFBLAwQKAAAAAAAAACEA49JqRpU6AACVOgAAGgAA
AGNsaXBib2FyZC9tZWRpYS9pbWFnZTEucG5niVBORw0KGgoAAAANSUhEUgAAAq8AAADwCAIAAACh
RBrBAAAAAXNSR0IArs4c6QAAAAlwSFlzAAAOxAAADsQBlSsOGwAAOjpJREFUeF7tnQtwVdX976MQ
wiOQ8H6YcEIithQIFKSCVgqxMn8g01q5WK1zkdvp6Hjr6+qMTm2Vqcz1f/VO56p1ro++KNYWQVux
KBQsSEAJVgIJUJBAyEkCJLzMg2cuj/s955csNvt1ztk5j733+a7JnNln7bV+6/f7rJ2zfvu31t7r
mkuXLmUwkQAJkAAJkAAJpDGBa9PYdppOAiRAAiRAAiQQIkBvgNcBCZAACZAACaQ7AXoD6X4F0H4S
IAESIAESoDfAa4AESIAESIAE0p0AvYF0vwJoPwmQAAmQAAnQG+A1QAIkQAIkQALpToDeQLpfAbSf
BEiABEiABOgN8BogARIgARIggXQnQG8g3a8A2k8CJEACJEAC1yTuXYRf//rXjXyXLFkydepUcicB
EiABEiABEnAPgQR6A8pIuAV0AtzT5dSEBEiABEiABHQEkj1T8PLLL//hD38QJXCArziAu1BeXr5h
wwYcPPjgg3v37lVaqswdO3aw80iABEiABEiABBJBINnewHe+850XXnhBLMEBvsrxmjVrvva1r8EP
KC0tveOOO06cOIFMuAjLly//9NNPH3jggbvvvlsymUiABEiABEiABOJLINneQFFREQw4HE44kK9I
U6ZMGTFiBA7mzp2Lz+rqanER4BwMHDhw4sSJKjO+9lMaCZAACZAACZBAsr2Bvn37PvXUU3V1dV9+
+eXixYvxVfoAQ76xM5YtW/bEE09g+sB0QSI7jwRIgARIgARIIC4Eku0NQOlp06bt2bOnqqpq/Pjx
yoazZ8/KcVtbGz579uyJz5kzZ7722muYPpDEhxHi0uUUQgIkQAIkQAI6AinwBnCjjxUDGN21d/wb
N26UZQGYHYATIDMImCbAugEuF+BVSwIkQAIkQAIJJZACbwD2YI4AI73WMCwn/OCDD+Af7N69+5ln
npEZBKwhKCkpueWWW5AvTx8wkQAJkAAJkAAJxJ1AMt43YFQazxbOmDFj1KhRcoovJIh7v1IgCZAA
CZAACURPIAWxAcwRBINB5QpErytLkgAJkAAJkAAJJIJAsr0BhAHwpMDDDz+cCGMokwRIgARIgARI
wAGB1MwUOFCUVUiABEiABEiABBJEINmxgQSZQbEkQAIkQAIkQAKOCdAbcIyOFUmABEiABEjAJwTo
DfikI2kGCZAACZAACTgmQG/AMTpWJAESIAESIAGfEKA34JOOpBkkQAIkQAIk4JgAvQHH6FiRBEiA
BEiABHxCgN6ATzqSZpAACZAACZCAYwL0BhyjY0USIAESIAES8AkBegM+6UiaQQIkQAIkQAKOCdAb
cIyOFUmABEiABEjAJwS6LVq0KBGm/OxnP/unIWGnogEDBiSiuSNHjvztb3/DDgjf/e53lfz3338/
JydHNkc2JtMqidANMu01ib5RUHXMMF46RK+tKmlU24EyprY7kONAf1YhARIgAd8TSPg+BfgR/8lP
flJUVJRQlEuXLsV+SN/61reib8VBleiFo+SmTZtGjBjRdcO1cqKEGZem4yJEiEWpthGvA9tj6qM4
Fo4jrjhqRVEkQAIkECUBn8wU7NmzZ+DAgVHaLMUcVIlJ/kcffRRTeavCDuQ4qGJsPS5CukjADTpE
aYKHVI3SIhYjARJIKwKJmilQEDFdMGnSJJkgWLt27YkTJ6677jocf/7557t378atM24ckbN3797X
X38dB4MHD5a6uNlCTlZWViAQ0HUJ6r766quHDx8eMmQIJgIgAQUqKirQlnamQMWWtU2IQGMVnUwI
RBkoA50nTJggoqCwKNmrVy/8+v/xj39U6qHYb3/7WyhgKl8b5TZtSBHQ2avTE/LHjRsnrKJsWqFT
OtTV1a1cubKyshJ2acFq82PlY+yvc+fObdmyBXqCG7pGXQPSok3XaBXWdqup7RGNMr26tD0rl6L2
chL1orkmlRxMUSlVL126ZLzI0+o3hcaSAAl4kUBSYwPjx4/H7L5gwgG+ynF9ff2tt9764IMPInrf
3NwsP9AY7f7zP/8TP6y4ideSxSn4ATg1Y8aMV1555dSpUzhGAcxHyIFp+vLLL9HE448/jlEcKwZ0
VYwyRUhTU9OCBQvk+MCBAyIBSn722Wd33HHHU089JdJwdtasWZD585//3FS+UsmqIZ16qrzRNCnp
oGkl87XXXpsyZYqyyzQ/Vj7G/qqqqkLfQU7v3r3t/zG6YntEo0yvLm3PWvVIlNekXCFaXFYXuT0E
niUBEiCB1BJIqjcwfPjwMWPGYPhEwgG+ivEyuT5y5Eh8YgjBJ3wFJNx7bd269fjx41pGyo2Q8vg5
joageB4SeDhz5oyuipVM7ay/HIsEOc7NzVXS4JQgmPHXv/7VVL5qzqohe/W02kpJB00rITNnzsRQ
J16XNlnlS3dIuzrmio+xv1QV1ctW3dQV2yMaZXp1qcyIpkW8Jo3rQqwu8miuUpYhARIggVQRSKo3
ACNxV4qhCAkHpjZnZmZKvtzrI+FWOFV0om/3448/RjDjrrvuir5KvErG2jTCGEOHDn3hhRd0DoFV
fpR6pra/olReXV1RGiXFYr0mI17kMbXOwnEngKtlx44dcRcbX4E1NTXPPvssVNWJRUAUp6zasqoV
X91iUimapu2NspJg2o/OREWjpO/LJNsbwCyy3EfiQMFF5B/HmLfGp6ww+MEPfrBz507MPRs7QE6p
8rIKoYup6zIRw8AKBp3C7e3tOsWcNWSUoxUbZdPaKrJiQMIwNvmq3YhqG/sLkQZtNznuIHvbozHK
eHVpa1mZFtM1KQKVqsaLHE9CHjt2zDEEVnRGAKOFMTn2A959913HdR3ov2TJkqlTp2JBkq7uI488
UlhYaCXQqpYDBeyraGnYqxRN09FLiNgL0YuKRrFElIloQiIajUZmsr2Bnj17zpkzBz/BOFD69evX
Dz+Xn3zyCToyOzsb+d/4xjfwjMAvf/lLTNLLxLxKeIwQpzCJgLVpKK+VE43BpmW6LhOTx1BVO77i
Xhk5SF1U3lSOVmaUTasqUAn00Au6KLcuX9tuRD7G/rr55pvRImQ6ux0XbSPaHtEoFDBeXdH0SEzX
pE5V04vc8cXJio4JYCiVBAkvvviiHE+cONGZwDfffNNZRWe1ysvL8YhyrHWd1Yq1FZRPMg2lYara
dYDIqop7TcAS6CSnjRs3njx5UjWKBXHV1dVJ1oHNpQkBZ1eXs1papLqLPE1ou9ZMPGqEmwelHr5i
IfDy5ctxgE+Vj0zk/OIXv8DTQzpbkK/S73//e1ULB/iKwtKEkrB///5oxEoZVESjkPDSSy8hRCrS
VDJqIrYYrTDWMkrWVdR9Xb9+PX6coYaRjGgohusa0uKN2KIWuLZHrIzSmm9s19iPShmQFEOgufHK
tOovLVWr3om1u7UyI15IuJyMl19y/rMyktOMauXQoUNr1qzRNtr1X94km8DmPETA2dXlrJbNRe4h
Yr5U1egNYJxoa2vDzy5OycgtwxjGQsnU3rEIEyVECqhM+e2WsbyxsRHHGFOVhIhiUQCFtRWhmLY5
G2/AaIVuYLaSLJYqEyAHx2IXRiMoACaKjMDBp2Qqe5WDpRq1scWoqm6YV95AlCUVc10/KmVg46pV
q6yuZ6v+Eu9BwbG3KMru1sm0v5DAX+tKJvP/MakzBfKMgMSQmUjAlwR4kXuiW4uLi/v06YMnm6Bt
a2srPsvKykpKSvC0jmTW1tZaGSJPmhwNJxzIVyTIxBtQcICHn5WEiGJR4LHHHpOKsrZaVlBFkzCF
p7NCW8tGsliqCstbXMXwgoICyJSlCUIGSaZXJPP8+fNWutm0aK+qVmD0JYW5DQHpIKtk2l8orIVj
Y1FM3a0DLiqZXkgLFy60WRcSzVXhuExSvQE8IIDH9GVlgErI7Prrex3bz4r+JuDs6nJWS0iaXuT+
huxF67RjoeiP+8jnn39eVh3aW4Th5/7778c6Uyzgx0COr1LeKDMasWhXrQ8QUTbDrU4x+1VTNpJ1
qmrlGK04ffo0FnVh7VtEMjYtRr/AK/qSVsyFEt4NA28GOmMthWmHmvaXTmb0DO2vItO2rC6kVP1D
JdUbSJWRbJcESIAE7AlgAf9zzz2nFh7aLzbEuzURzsVbQbE9ihKrHinC8IlMPHKMz4hiUUD3rK9U
7HqKl+Tf/e53iJRMnz7d+ICDTsl4tdh122VQxzJzvA4VD2rqXmEn8k37K3qLnHW3Tr7phRQX8x0I
oTfgABqrkAAJ+I0AYrl4kajxrVxaO+W5UyTEcrEyHLEBbVAX77WU6lhDinFR4sARxd55552ISUhM
G7fgqCgR+66neEnG/TEmMpB07zlQNJSq8WrR3nZjuzblbXbNNe0vnSgbi5x1t8i3uZDwjKjN+yS6
flXYSKA3kFC8FE4CJOANApjsx0iMF4ghtoxfZKPSeEYRC9xwoymnMEeAkV5bDBPeeBUYqiNs8NBD
D0nYP6JYBCEQk8BOGaiIW3DEt+PFK16ScXuNYLsyXNTT0ZDMeLVoQ8C0XdPyeA0RkKJDn376aVMH
y7S/dKJsLHLW3UZ0xgspXhdArHISvqNxrAqxPAmQAAm4nwDm0eE95OXliaoYeDBQOX6Zgfvt9ZmG
XeyvLlbXwtRdSCnkzNhACuGzaRIgAU8SQCwXwV7lCnjSBirtAgKuupDoDbjgiqAKJEAC3iGA+0JM
pRt3AfWOBdTUFQTcdiFxpsAVlwWVIAESIAESIIEUEmBsIIXw2TQJkAAJkAAJuIIAvQFXdAOVIAES
IAESIIEUEqA3kEL4bJoESIAESIAEXEGA3oAruoFKkAAJkAAJkEAKCdAbSCF8Nk0CJEACJEACriBA
b8AV3UAlSIAESIAESCCFBOgNpBA+myYBEiABEiABVxCgN+CKbqASJEACJEACJJBCAnz7UArhs2kS
IIHkEbh48eLOXbuwpdCRI0fQ6vDhw6+//vrx48Z169YteUqwJRJwKwF6A27tGepFAiQQPwKnTp1a
+cEH2Ja3cNSooUOHQnBTU1PNwYPYSvj73/tednZ2/JqiJBLwJAF6A57sNipNAiQQPQFEBf6ybNmo
goJvfGPstqo9/9q1D3VvKr7hm+PH/Hv37oO1tffcfTcjBNHzZElfEqA34MtupVEkQAJXCOyorDx2
7NjEid9c8t7q37+/flTesJMnTx79qvWRH5X+1zv/o6KiYvDgwRMnTFAVsJ2MEV/0GxZjj1rMQXB3
Y16C3iLAVYTe6i9qSwIkEDOB6n37igoLd+z68jfvrfvvP71/0f/6n5P/xyOnMrq/9Pbfa2qDOIUC
WqFrOxMy4QTIt+hH9zfffDNmFVmBBFJNgN5AqnuA7ZMACSSYQGNTE1YMbN6+Kzvr2stFgf9bX7uh
9mK3OT9tP9Xy2Y4vcQoFolShvLwckYNnn312z549qPLJJ5+88sorUhchASSJKzz55JOmAYYoW2Ex
Ekg+AXoDyWfOFkmABFJAILNb98bGxlfWBjdtP9V8JuNs+2Uo0TOrB1YVXHttVL+EO3bs+Oijj5Yv
X37PPfc8+uijzc3NM2bMOH78eE1NDVYjIiQwe/ZsRBFURCEFRrJJEnBKIKr/AafCWY8ESIAEUk8A
d/9YNzB9yvge2bkn3n/tq8Nn2o6eufSP17Kyc0umTcIagkGDBkWjZVlZWUlJSW5u7pgxY1C+trYW
n/AMsPIApzCn0KdPn2jksAwJuJAAvQEXdgpVIgESiCeBG0aPPlBTM+5r1//8J/+l3+X2Xh8s7vfB
4gHXtP+fnz0wfMggnEKBaNpbtWrV888/jykA7SwAPIOqqioEBqJfWBBNWyxDAkkmwGcKkgyczZEA
CSSbgHrCcPz44uChw7ur67p17zZ57A1DB/VH8N/mCUOM+tpHCbBcYM6cOVOnTtUagAUEW7duRc5N
N90kMQNdrWRby/ZIwBEBxgYcYWMlEiAB7xDAuwTu+P73Mep//q/Pe/fo/r3v3jJ3xtSMi+1bysuR
iVNRvmwA0wRYN4DlAlrT//KXv8BFQMLB6dOn5dThw4e9g4eakkCIQLdFixaRBAmQAAn4m0CPHj3G
jh3b1tr67z17NnzyybaKCrydMO+667572209e/a0sv2tt966/fbbhw0bJgUKCgrOnj37xBNPIB/x
BkwNwDkYMGDAlClTsGLgxIkTcAJGjx49fvz4xYsXV1dXz5w5099UaZ2fCHCmwE+9SVtIgARIgARI
wAkBzhQ4ocY6JEACJEACJOAnAvQG/NSbtIUESIAESIAEnBCgN+CEGuuQAAmQAAmQgJ8I0BvwU2/S
FhIgARIgARJwQoDegBNqrEMCJEACJEACfiJAb8BPvUlbSIAESIAESMAJAXoDTqixDgmQAAmQAAn4
iQC9AT/1Jm0hARIgARIgAScE6A04ocY6JEACJEACJOAnAvQG/NSbtIUESIAESIAEnBDgm4mdUGMd
EiABzxG4dOlSU1MTdhMQza+55hpsMTB06NBrr+VNkec6kwrHnwC9gfgzpUQSIAG3ETh37lxNTU33
7t179+6NY3gA2KwIGxdduHChsLDQZuMitxlCfUggQQToFCcILMWSAAm4hQCiAvv378/Ozh44cCCG
f0QFoBk2IRwyZAgycQoF3KIr9SCBFBFgbCBF4NksCZBAsggcOXLk5MmTgwYNQjCgW7duiBCo2QHs
RHz06FH4BMOHD1fqLF26VI6xnbE2XxXYvXs3ZhlMTyXLJrZDAnEmwNhAnIFSHAmQgNsIYK1ATk7O
2bNn4QdkZmbCIejRowemDDBBgFBB//791WIC0XzBggX4nDVr1ogRI0xt2bZtm9tspD4k0EUC3RYt
WtRFEaxOAiRAAm4mgLt/BAMwQZCVlQWHAK4AfALxDDBHcPnyZcQMMGugNaGysrKoqAgxA8QJEAZo
aGhYs2YNqqCYRA6wCgFlJkyYgOP6+vqVK1fCpUB5BBtEjsqEI7JixQpU7Nu3r2lhbRMikIkEkk+A
sYHkM2eLJEACySYAbwBjObwBJHgDOEaEAJniJdhrc+jQodGjR8+ePRshAcw4qMjBfffdh7qYhqiu
rp4/f35xcfHq1asRgYA0ZG7YsGHevHm33XZbS0sLcqQV08LIhwQsZoTkiMokGxzbSxsC9AbSpqtp
KAmkMQFMCsgcAT7hAYgrAB44QLIHk5eXBwdi8ODBKNbe3q4KI6iAFAwGR40a1atXL6xLwCkZ+5E5
bdo0hApQAGdVFdPCOAtXABJwgPJp3Es0PZUE6A2kkj7bJgESSAIBRO/b2trgEJw/fx7DrQz/mCPA
0A7nABF+PGtgowYCCTZn9+3bt2nTJkT71dpDFEamuAK6iqaFUYaPOCbhMmAT9gToDfAKIQES8DmB
QCCAgR8OAVYO4sFCrBxEgjeAO/7jx4/j9QN4B5FjBIgclJSUYNZAkjxogEx4HkaZpoUdN82KJBBH
AvQG4giTokiABNxIAJMCWBKIGH5jYyO8ASTcteMTawObm5txysHrCOFbiKmYCMAd/5kzZ2TiQOIB
yMQyw9OnT+MYywkVFNPCbkRGndKPAJ8pSL8+p8UkkH4EEO3HvD4iBHi+AG4BnAB8YrV/QUEBJgt0
PCTmf+DAATwIgEFdHi5AjnrQAPkbN27EFANGdzygiEjDP/7xD5xFvEFiA8iEf/DPf/4Tiwrz8/P3
7t0rQkwLK7Hp1y202EUE+PYhF3UGVSEBEnAJAbW2H/f6OFYrAKyOobZU0a0VQCamDJYtWzZnzhxZ
ZihJV1gr1iUEqEa6EeBMQbr1OO0lARKITEAb9tcO8FbH4gcYlw0iQoAXF2K5gDySoJKuMB8liNwl
LJFgAowNJBgwxZMACaQfge3bt+/cuRN2ww/ATAE+5QFCJhJwLQF6A67tGipGAiTgbQKmcwfeNona
+5cAvQH/9i0tIwESIAESIIHoCHDdQHScWIoESIAESIAE/EuA3oB/+5aWkQAJkAAJkEB0BOgNRMeJ
pUiABEiABEjAvwToDfi3b2kZCZAACZAACURHgN5AdJxYigRIgARIgAT8S4DegH/7lpaRAAmQAAmQ
QHQE+IRhdJxYigRIwOMEsIlAU1MTNhcQO/AygAEDBmD3QgdbFnmcBNUnARMC9AZ4WZAACfifALYt
xv5D2LsImxrjGB5Az549T506hQ2HCgsLcex/BLSQBGwJcKaAFwgJkIDPCSAqsH//fmwhOHDgQAz/
8opA7GiMrQiRiVMoEHcE5eXlJ0+edCwW+ygeOXLEcXVWJIFYCTA2ECsxlicBEvAYAQyrGJixhSCC
Ad26dUOEQM0O9OnTB3scwyeQnYhVkk2NJU2ePBl+g27boUQjgAKzZs0aNmxYohuifBIQAowN8Eog
ARLwOQGsFcjJyTl79iz8gMzMTDgEPXr0wJQBJggQKujfv79aTKAFgcH4vnAaMWIEtiA6ePCgzzHR
vPQmQG8gvfuf1pNAehBob2+HoXAC4A1kZWXJAbwB+yWEsu8w3IWJEydu2rQJ/oTQqq+vx737+vXr
jx07pvghAoHZAeRjA0NkqlA/DlAe+xrjAC4FhEgx5Ki6KABpusz06Bla6RYC9Abc0hPUgwRIIHEE
MOojMAA/QFwBHCNCgEwkWUZgn/D0AQq0tLTgE6N+dXX1/Pnzi4uLV69eLS4C3IJ169YVFRUtWLAA
WxiLNCX50KFDY8eOnT17NlyKvXv3Tpo0qbS0dNu2bWphAfQpKSmRTK2HEUkvnieBuBGgNxA3lBRE
AiTgWgIIA8gcAT7hAYgrAG1xgBST2sFgcNSoUb169cJCBOUiHDhwYNq0aVhegBzJ16a8vDx8lZUH
iDTAHRH3QiIWSLJqQTKxvDEmfViYBOJCgN5AXDBSCAmQgHsJYKlgW1sbHILz588j8i/DP54jwGAM
5wCLBvCsgb32MmzjDh6f+/btwy0+ovralYbIxFJECDeVIxUlGZ9mhHDMIMhUgnshUjO/E6A34Pce
pn0kkPYEAoEARlw4BFg5iDtvrBxEgjeAe/Tjx4/j9QN4B5E9JFlmiKWI+MSNPqL6ssAQSW7rkYkH
FpyRrqioaG5uLigowCyDMwmsRQJdJ0BvoOsMKYEESMDVBDApgBl9zPo3NjbCG0DCTTw+GxoaMAzj
lP1aQlkTgEl9eA+wE9MEiAScOXNG1hhKPGDMmDFbtmxpbW3FcawT/xJXQACjK+8ncHUHUDkvEKA3
4IVeoo4kQAJdI4D4PAZsjLiHDx+uq6urra3F9D++ItPqRYRr166VBwfgMcybNw+zCTLwwxvAOsEV
K1aoxweQiQjBzJkzv/jiC2SifEzKws+QZwpiqsXCJBBfAnz7UHx5UhoJkIBPCKgnAqxWA0gB41nk
S6bxQJupO1bUTGv5hCnNcDEBegMu7hyqRgIkQAIkQAJJIcCZgqRgZiMkQAIkQAIk4GIC9AZc3DlU
jQRIgARIgASSQoDeQFIwsxESIAESIAEScDEBegMu7hyqRgIkQAIkQAJJIeCiVYQz51QkxWQ24h8C
Gz6a5B9jaAkJkAAJpI4AYwOpY8+WSYAESIAESMAdBOgNuKMfqAUJkAAJkAAJpI6AG2cKGP5N3fXg
jZbVpBIvFW90GLUkARJwPQHGBlzfRVSQBEiABEiABBJMgN5AggFTPAmQAAmQAAm4ngC9Add3ERUk
ARKIBwFsYXzkyJFdnWn37t34isx4yKYMEvA8AXoDnu9CGkACJBCRwLlz5/bu3dvW1pabm4tNC3v3
7t2/f398RSZORazOAiTgewL0BnzfxTSQBNKdAAIA+/fvz87Oxq7EFy5ckL0HL168OGTIEGTilFci
BNguGfGMaLqzvLz85MmT0ZRkGRIQAnymgFeC9wjwmQLv9VlKNcYIiqFx0KBBp06d6tatW/fu3a+9
tuNGqE+fPkePHoVPMHz4cK2OGHfV18mTJ8NvGDx4sI0RmHcYMGCATkjcjYZWs2bNGjZsmJKs1VNl
3n777YnWJO6mUWDKCTA2kPIuoAIkQAKJJXDixImcnJyzZ8/CD8jMzIRD0KNHD0wWYMoAoQJMGaCA
UQOMu/eF04gRI3bu3Hnw4EEbLbdt25ZYGyykL1iwQJTEea3CKVGGjXqaAL0BT3efmfLln7798K4W
35lFg0igKwTa29tRHU4AvIGsrCw5gDegggSmwi+HE9yFiRMnbtq0Cf6EFKuvr1+/fj3uyxESwFe5
QV+3bp26U0cBHKPMsWPHTCXrJIgQZEKgEqvaElFWkX9RUgrLMZKaU9CKhUMDEzCJYNWElbZdIc+6
XiHgQW+gYdeHc//8tvzFY9hrWfHh27+q90qHeVFPEvZir/lMZ4z6CAzADxBXAMeIECATSZYR2CfM
AqBAS0uHm43qJSUlpaWlCAlgBMUNOs7KrTmkYWKiurp6/vz5xcXFq1evVj6EtgmdBDl16NCh0aNH
z549G2Jl7IeoDRs2zJs377bbbjt9+nQkNa86r+yC2LFjx0IsHBqsmpw0aZJorpqIqG1M7bKwRwl4
zRvAje8DwcAbP7r3w9Bf6fTg5hWtHkVPtUmABJJGAGEAmSPAJzwAcQXQOg6QYlVDZuXFRcBqRFVd
7suDweCoUaN69eqFlQpaH0LbiqmEvLw8eCqyQEGCGRA1bdo0LGuA2Pz8/Fj1lPIQi08RizgHmhDN
VRMRtXXWLmt5i4C3vIH6zYuDgWfmjgtd26GUM3/u3Pn9ELfbPPfDXSs+DQcMPg3f5rfuergzftCR
E66giStsLu8otmpJS8b6Taj7YYdjYVG3o02c/XBXA1oU+WhOlUd+Z+/rG+poa3O5qmhfOCMDfo8K
geCgI3oR0a4Pd5mEOXQ6q6aj5GZV3YqzVuyHHz78Zy3h+l8pWzqqd2L31j8OtfUSASwVxMOEcAjO
nz+PYVWGfzxHgOEQzgEWDeBZA3t7ZODEDb0Mogi5S0jftNa+fftwF46zVgWsJIh8bYIocQW6glsr
FhCMTdhr25WmWddDBDzlDTQgThcITDXF21K5JGN6KGBwC/zn+l+tqiy4tSN+sLC5rGNCoX7zCxnf
lqDCwpzg25hc7zfu16HjjJJQ4bBjYVVX22hL5QN1gZCc0gmFwbK5q5rvFZkZlS/IhL2xoY7qwcVV
ueHAxvSSlsp3ZNw2LQy/p3lCuGSHek+Ebgss7Grd9UJVxsLSsL3FzUuCZoCgc0fTIT0fEJ8JScsN
o/7V3K44UubVLfTRip0792rC+bcEMtbXdbTeUBesyQlMC2FnIoHEEQgEAhiA4RBg5SBu5bFyEAne
AO6Sjx8/jvcNDB061L51WWaIpYj4rKioaG5uLigokAkCY8K9OOYRZHEfknF5f0QJSiZEwYNJHBlI
jqhtQluncPcQ8Jg30GxNLvBMyA8IpYZdVetzJvyw41vO/OJATbA+dNee/+1fjwv9N+O/elogt6bF
ZI7Bsu5VDXe21S9/esiT+HbYQcnJz83okGnZkApshAbFWpmENCsc8ntyc8IhkJBYKWmlW2hMDRSH
XZmQtGcCppBU0yEgGc0tnWEMDbeQnOlhtyPUrr5YR0jmSr4tqytiddpMHRlA+DMUmMlo2RJsLilW
kR73/FdQE58RwKRAUVERZv0bGxvhDSDhbhufDQ0NGNdxyn4tIVYGYIUg5trhPYCM3K8j3qBb1gdv
Q7gh8I4yZ86cUWv6dDytJBixQ1RNTY2sGMAaw0T0S0RtE9EoZbqQgKe8gRj44V5WzRRsUjfLoeVs
En5/oKrZUpp53RgaxzgXVUMdIk0K5+EepGPArv80mFEQviUJD6AmdjW0WNtipXVLs5rUUEX0cnJy
C82KhdXorO6AVf54BGZCsYnW+rKWQKcLFxNeFiaBWAkgQj5mzBgM4YcPH66rq6utrcWUPL4i0xg8
F+Fr166VxfzwGLCOD7MJErGHWyBPBGh1wCP+W7ZskUyMr5jjX7FiBapv377dqKqpBFOLIApxi/fe
ew8PAkhkIu4porZxb5ECXUoA4TKXpO/8xxfyZ61PsGz2n8o+M56/Or+u6u+zNwWNpT7b9JbK15T5
6p2/v/W/O4tb1b0irbnqp1d0uKqukm/e0FUVL6HMT6u+gljTwiE1/vRWx1+nLVa66fKVZAudL10C
rr9X1eG0PTdV7GrNVXVLVvpuuooSmpWKkVFbXghRXCouuaiphocJqDt7extQTBXQHiNTJEREoMrY
ixI5NgKNrRurdF3biOawgEcJeCs2EL6tXHxl/R3uqk3WoOWNDBQGq2yfNah/5+rYQEfQHnNokevG
5NbpG7KtfKUwbtPDSxnCf523z1a6hQIJnfZi9eJi03UDGYpby4qqYGEgv3Ml5hWNwvLLOh+21BUz
qR4TK0UY7UlDCM+UjHS4SDqmPmBhEnBEwCrOrxOmXeKnW+4nEiI2rsrYixI5NgKNrRurdF3biOaw
gEcJeO/NxPAAQmvUJRUWl4aWAmAR+6aMZ34k8/fhFF4QV9P5raMYVuH9uSwc3stdWJyzpCUgAy1G
0PDEQe7C0vBCQvO6WslYNihthZSpK75X5trxFMBirGSUZYzGhkJiVcVQ4bdzwsqba6UkaMy0tEuZ
kJERmP5GThUWS3aukFA0mu+9NWOxTJoERMnwsxg6bqGcDm+iE5oAMatupY9BrJ5wmBv4X9VlMfwH
8c3EMcBiURIgARKIgoD3vIEojPJ8kdBgWRYQXyE0aP/qz1UjxVNxlq52RGKW0cXqZu1pPKeY1cnI
oDfgABqrkAAJkIANAW/NFKRLV7bWtWhWDra21PrN8NDSSE4T+K1XaQ8JkICHCdAbcGPn5T9ROqE2
9EKk8N+q4PSuBAZcaGB9cH0GnyZwYcdQJRIggbQlwJmCtO16DxvOmQIPdx5VJwEScCUBxgZc2S1U
igRIgARIgASSSIDeQBJhsykSIAESIAEScCUBegOu7BYqRQIkQAIkQAJJJEBvIImw2RQJkAAJkAAJ
uJIAvYH4d4t2096rN/CNf1vRS4y7JnEXGL0tLEkCDghgm6IdlZXvvvfer199FX84wFdkOhDFKiTg
PwJ+8AZCu/50vk/XvodCA1jH7sbhjYWiq5X8XtfpplU7+cqwRRLwAYFTp04te+cd7Eb4zYkT/9vC
hfjDAb4iE6d8YCBNIIEuEvCDNxA9gvwnfnTvVa/sjb5qKkt6VO1UImPbJKAhgADA+ytXFgQCN06+
8djJ1k3l2/B3orntxhtvRCZOMULA64UEvPa+gc433qPnwm+5v2pPgc6NBjq6VbOjQc6EN+aOywvv
CJBx671P5Gh3MTDbnkC9yV9zheibxilt61eqdLYS2gpAe2xVXrPLAIwqzX37yg4LolsUQnRbCXTY
q72+IwoxFuh861FkM5P8j8T3DSQZuNebw4wAwgATJ37z84qq3r17YyPja6655kL7eaTxY79WUVEx
ePDgiRMmKDPfffddbHz8yCOPSM5HH3109OjRhQsXxsTh9OnT2NQYtWbNmoWKy5cvz83NVRKQ+eKL
L06cODEmmSxMAokj4K3YQP1m7McT3tmvFJsZvr2rJaPfuF+HjjPCO/5d9Sb/hl2bl+RO79gGMOQK
aJJJrfpfraos6Ng2sHRhc1nnhEJnrfrND1RlLCwNbyp4a0ao6fAYqa0y99N6246yaEInuS7fyqKQ
cLtGg4urct8IwZle0lL5jp0upprk3xLIWF/XUa2hLliTE5gW2hkhEpnEXZyUTALxIVC9b19RYeH+
mmCfPtn9+vbrkZmZ3bvX0CGDBg8c0NTUhFMooG1p+vTpq1atggcgmS+99BJyYlWlrq7upptuklpT
p05dunRprBJYngSSScBb3kC+2povZ1ogt6alNQKqYLA8OpgNu6rW50z4Ycf+ujnziwM1wfoGTd3y
umBGoLhj36CwGqHxMjBddi/MyAhVyWhu0VbRtWzVhFGyjcq2jQae6XB6QuO6dgfhKDWZOjKQ0UGs
ZUuwWXY9jkgmOsAsRQIpJNDY1DRkyJCvWlpy+vXtmZXZt0/PnOxeffv0GjxowIULF3EKBbTqIef+
++8vKytDZk1NDcbywsJCKVBeXo7b+meffXbPnj2S09DQ8Morr0imVsi6devGjBkjOXfeeWe/fv1Q
1xTCjh07UBcSIAfSUgiKTaczAW95A+Glf/L2/vAexHYpb9zcN4pbFocKf7giktsQEtRS+YDsC4C/
zl19tQ0U5ly1h2BDy9UK5OQWtjRH+Ee2aEIn2cYqJ42aijPVJD9QkhEMBTha68taAvd27KAYmUw6
/wPRdu8QyMrM7N0rC05Av2xMFvTOCiccYNHAtdfqfwkRDHjzzTcR7d+7d++cOXPESgzbmDVAzP+e
e+559NFHm5tDvwEodv31169du/a5555TMHAKmVo28+fPlxkHHTDIfPLJJx966CFIKC4u/vGPf4xG
vQOVmvqHgKe8gfJPV6ng/xvFuRF7AQ5BOLCfs2TV5shBAkz8h8LsnX+6yQXcI1wdisjLuVqBluaa
nNyr5iOM+lk0ETnI0SnKSaOmmMw1yf9hcS4mC8IRiMBUVTESmYgdwQIkkFICuNfHuoFBA/tfuvD/
evXsgZQZTpcvX+qbnX3y5MlBgwbpFJTwwMaNGzFNMH78eDmLaEFJSQmm/+Wmv7a2VvJNx3gM7VqZ
WKwAH2LZsmW6hiDzscceQ3PInzJlCj4xxZBSWmw8TQl4yhvQ9FH9O1fHBmwC4xm4a7foXVUrb2Sg
MFhlE0IIR9E7C9RvxqqCcJWyzmcUW1ZUBSW0bpWsmjBKFgmmFsXaqKkyNsbKqReCzWq74Yhk0vQf
h2Z7icANo0cfqKnJv27EuXNnz50/jyWE0P4CJgkuXsSiQpxCAaM9CA/AFYBPgIFczmIxwfPPP4+Q
viwMlPT444+3trYiRzsRUFVVlZen/zmAD4GAgW6+ADJHjBghoqQhrG30Elzq6hcCnvIGpt4yvSRY
Fg7mV43EPH1HCq8hqFqlmxEo/1TtCIy1ft++cqdrWgvrCksDZas6q1x5LUFnI/nffqM4Y4kUqMp9
ClF0VLk1sL5j3+FVZYHSCM8uWjVhlJxhblFIlVgbNb1ObYztlz89p7mmRbPdcEQyfvlXoB3+JYDb
9MbGxj17/o0Fg3AFTp06ffrMmYsXL/Xs2bOyshKndPfxQkLu17UBfywgwHQAQvqS5IkAhArw9MHr
r7+uFhNgqYGpQBTGpAPmC7SLAyBTZhxUwvyFf7uClrmXgNeeMHQvSWqWPAJ8wjB5rP3SEl4xhPcK
DBs2bFRBwfDhw2EWnICagwfxecf3v5+dnW1qqO45wE8++WT9+vUIBmifFZSKGNHvuuuul19+GQEA
jPc333yzKqMTAlcASw0QIZAnDGXdwJ/+9Cc4HyJfu/7AL/hphwcIeCo24AGeVJEESMCNBDDe33P3
3QMHDNi+Y8ebv/kN/rZt24avyLRyBYxmzJgxA7fyGPUxwC9ZskQKyAMFyHz66adlPcH+/fuN7oKS
hhkEtSwRmXAIMPy/+uqrEIKFCHA13IiPOqUBAcYG0qCTfWciYwO+61L/GCRPHqpnC/1jGC3xOwHG
Bvzew7SPBEggiQS2bt06cuTIJDbIpkggPgToDcSHI6WQAAmQAAjgVcTqGQQCIQEPEaA34KHOoqok
QAIkQAIkkBAC9AYSgpVCSYAESIAESMBDBOgNeKizqCoJkAAJkAAJJIQAvYGEYKVQEiABEiABEvAQ
ATc+YeghfFQ1tQQ2fDQptQqwdRIgARLwBwHGBvzRj7SCBEiABEiABJwToDfgnB1rkgAJkAAJkIA/
CLhopsAfQGkFCZAACZAACXiOAL0Bz3UZFSYBEnBC4NKlS01NTSdOnJDK2MxwwIABQ4cOvfZahkid
8GQdnxGgN+CzDqU5JEACJgTOnTuHjYa7d+/eu3dvHMMDwHbG2NjwwoULhYWFOCY1EkhzAnSK0/wC
oPkk4H8CiApgX0HsVThw4EAM/4gKwOaLFy9iE2Fk4hQKJIjC0qVLjxw5YhRulZ8gNZRY7KR88uRJ
01ZsTkWpFSRjR2aYhvKpMjBKVVnMSIDeAK8KEiABnxPABAE8gKysrObmZpiKAwQDunXrdubMmZyc
HHxFAR0CDGYq7d69+9ixY44ZifNhTFb5jhuKpiJ2ZMb8iGlJm1PRSEaZHTt25OfnL1iwQExzYCBQ
mzpPUSrAYl0hQG+gK/RYlwRIwAMEsFYAo/7Zs2cxU5CZmQk/oEePHpgygE+AUEH//v3VYgKtMbNm
zbovnEaMGLFz586DBw96wNSUqtjQ0IBYC1S4fPmyM0W2bdvmrCJrdZ1At0WLFnVdCiWQAAmQgGsJ
HD16FAsFJDwAhwCuAHwC8QwwR4ChCwsIMGug1b+ysrKoqEjGtl69esGZ+Pjjj2+44QZUQQ7uX//1
r39t2rQJHka/fv0gFpmIJUBI3759tcci56uvvlq5cqU4JZCGAlr59fX1chbNGfc/FLGIaugkIB93
+RiA16xZM2HCBMg0lQNVccONAD4sHT58uFKytbV1+/btyEe7o0aN0ulvZaBqEfR0xGSCAIszYBr0
0RpoKk0UxvAPjCJNJ8G1l5NfFWNswK89S7tIgASuEIA3gCEHwzYSvAEcI0KATPESIpKS6HpLS4u4
AuvWrbvpppsQEh82bNj777/f3t4uErSi1HFtbS2qozCWK65atQoOhLY5SKuurp4/f35xcfHq1at1
Z6VkMBg0lYCKkCmReVM5mOCAqnBHUAYxfK2SX3zxBVZRIP+2225T+ojONgYeOnRo9OjRs2fPxiiu
W38AUagrARUtBxtp6IWSkpLS0lJIg6pWEiL2DgvEhQC9gbhgpBASIAFXE8CkgMwR4BMegLgC0BgH
SDGpjrF52rRpEjbAJAI+cZ9tIwEeg9zxFxQUKJdClYc03JojYDBo0CDjWSlmJQGugEQaEN4wlXPg
wAGoKjfxIl+bEBGRurp8GwPz8vLgSw0ePBhVlA+kqw6BWpk20hCrQF3xtLCoU8nRSYipd1jYMQF6
A47RsSIJkIA3CGAwbmtrg0Nw/vx5jDQy/CNyjvEMzgFC5bhLtrdERj7cy+Jz3759cAVkwMPQiE8s
PrCpbv/4IqQhVC4rFq2EWEnQ5pvK0aqqEw4vATTQKML1ulM2BgqBmJKVNCDFUgzMYtgYHlNDLNxF
AvQGugiQ1UmABNxOIBAIYOyBQ4CVg7gHxeCNBG8AY/nx48fx+gG8g8jeBllmiFl/fOL+GOOotrwa
I03dApWpdSlUdUhDtFyWKyLJ7bIu2UuQwqZykCkBAGNCUAEPESBKv2HDBt0TEzYGOuhpK2kVFRVY
DIF4iUwQMKWcAL2BlHcBFSABEkgsAUwKYO4cs/6NjY3wBpBwZ49PLMHDgIRT9q8jlNl3DJwSCRgz
ZkxZWdnp06dxjLtbjHYSOR8/fjwE4kA3uCJTVgMgZo7C4lKohGkC3D3jWUcJj5uuxreXIKJM5UDV
LVu2yESG6UOSMtGgWzlhZaCzTrKSJjEDhG106w/gtDlriLW6SIDeQBcBsjoJkIAHCCCojmEJY8/h
w4fr6uqwsg9jM74i0yoOv3btWgSxseoeHsO8efMwmyBDNW7fZ86cuXXrVpzFKYTcJR9PHGBQR3nd
QgR4AFhpj8IIMGDtoTyVoPUGsL5vxYoVKIBF/qYo7SUob8AoR1TFgkFRVSsc7xpCJtq99dZbxZtR
ycpAZ91sJQ3eFSYpgEsr9vbbb4f7ost01i5rxUqAbyaOlRjLkwAJpAUBdcds8/Q8ylidVaeMB4JP
V1eaM0rDmI2F+lhIaFrFWN5KjqkausJGc4xKqhZNbddmRpSmvYzsK6bFBZdqIxkbSHUPsH0SIAFX
ErAJ3St9bRwFdcp4INV1daNZSG+sYiRnJcdUDV1hozk2LZrars2MKE2rvH1FV14gflOK3oDfepT2
kAAJkAAJkECsBDhTECsxlicBEiCBpBKwmY9Iqh5szNcEGBvwdffSOBIgAe8TsJmP8L5xtMAtBOgN
uKUnqAcJkAAJkAAJpIoAvYFUkWe7JEACJEACJOAWAvQG3NIT1IMESIAESIAEUkWA3kCqyLNdEiAB
EiABEnALAXoDbukJ6kECJEACJEACqSJAbyBV5NkuCZAACZAACbiFAN834JaeoB4kQAIJJYBNC5ua
mmQ3QiQ8xD9gwADsXmi/ZVFCVaJwEnAPAXoD7ukLakICJJAoAti2GFsHYethbGqMY3gA2KwIu/1i
s+DCwkKrjYsSpQ3lkoD7CHCmwH19Qo1IgATiSgBRgf3792P/XOxDiOFfturBjsZDhgxBJk6hQDQN
Yt8/3fa70dRiGRLwBAHGBjzRTVSSBEjAOYEjR45gFB80aBCCAdhuGBECNTuATY2PHj0KnwAb72ob
wM6B8hW7CY8ePRqbBTtvnjVJwAsEGBvwQi9RRxIggS4QwFqBnJycs2fPwg/IzMyEQ9CjRw9MGWCC
AKGC/v37q8UE2kawj/B999134403btiw4dixY11on1VJwAME6A14oJOoIgmQQBcJtLe3QwKcAHgD
WVlZcgBvwH4JITYI6NevHypiWgGfCBggzCAH9fX1u3fvxgE+lW7IXL9+vTZTW3L79u2qMA7wtYtG
sToJxJEAvYE4wqQoEiABlxLAqI/AAPwAcQVwjAgBMpFkGYFVkqhA3759pYAqfOjQIcwgzJ49e9u2
bWoxAcSWlJSUlpYiU4UTqqursVBxwYIFmG5AvsjBAeYgXAqLaqUlAXoDadntNJoE0owAwgAyR4BP
eADiCoABDpBMYaxduxZ39qtXr548ebKxAMZyeBWDBw/GKQk8IMniAzy4iE8JJyDBFejVqxcOJMxw
OpxwkJubm2adQHNdTYDegKu7h8qRAAl0nQCWCra1tcEhOH/+PIL/MvzjOQKM4nAOsGgAzxoYW5F1
A0h4J8F7770nQ7hKCAPoqkDawYMHZfpAe0o9vgjvAY4FNEEsYdq0afjaddMogQTiRYDeQLxIUg4J
kIBLCQQCAQzVGIaxchC37Fg5iARvAOPx8ePH8foBjPemqsN1QMLDCDiL6vbmVVRUNDc3FxQUYFLA
qiSCB3A+0Cj8D0h2KS+qlZYE6A2kZbfTaBJIJwKYFCgqKmppaWlsbIQ3gISRGJ8NDQ0Yv3HKfi2h
rBxUSwesyO3btw9PKiIOYfNOAkwiYMXAV199JbMJTCTgHgL0BtzTF9SEBEggUQQQrh8zZgyG6sOH
D9fV1dXW1gaDQXxFptWLCGXdABJ8iDvuuAMjvb1yWDwozxTYF8McAVYSJMpOyiUBpwT49iGn5FiP
BEjA1wS0zxqoqD4y5Vgd6I4VEtOSOIuFBXi4QFYUMpGAewgwNuCevqAmJEACLiIgiwYkKbXUsWmm
VnvTkphEwPoDugIu6maq0kmA3gCvBRIgARJIBgFMOmBtwYQJE5LRGNsggRgJcKYgRmAsTgIkQAJO
CWjnF5zKYD0SSAgBxgYSgpVCSYAESMBIgE8V8qpwLQF6A67tGipGAiRAAiRAAkkiQG8gSaDZDAmQ
AAmQAAm4lgC9Add2DRUjARIgARIggSQRoDeQJNBshgRIgARIgARcS4DegGu7hoqRAAmQAAmQQJII
0BtIEmg2QwIkQAIkQAKuJUBvwLVdQ8VIgARIgARIIEkE6A0kCTSbIQESIAESIAHXEqA34NquoWIk
QAIkQAIkkCQC9AaSBJrNkAAJkAAJkIBrCdAbcG3XUDESIAESIAESSBIBegNJAs1mSIAESIAESMC1
BOgNuLZrqBgJkAAJkAAJJIkAvYEkgWYzJEACJEACJOBaAvQGXNs1VIwESIAESIAEkkSA3kCSQLMZ
EiABEiABEnAtAXoDru0aKkYCJEACJEACSSJAbyBJoNkMCZAACZAACbiWAL0B13YNFSMBEiABEiCB
JBGgN5Ak0GyGBEiABEiABFxLgN6Aa7uGipEACZAACZBAkgjQG0gSaDZDAiRAAiRAAq4lQG/AtV1D
xUiABEiABEggSQT+P8DgmENo1X4XAAAAAElFTkSuQmCCUEsBAi0AFAAGAAgAAAAhADQS/3gUAQAA
UAIAABMAAAAAAAAAAAAAAAAAAAAAAFtDb250ZW50X1R5cGVzXS54bWxQSwECLQAUAAYACAAAACEA
rTA/8cEAAAAyAQAACwAAAAAAAAAAAAAAAABFAQAAX3JlbHMvLnJlbHNQSwECLQAUAAYACAAAACEA
UMuBciQDAABXCAAAHwAAAAAAAAAAAAAAAAAvAgAAY2xpcGJvYXJkL2RyYXdpbmdzL2RyYXdpbmcx
LnhtbFBLAQItABQABgAIAAAAIQBTUolh0gAAAKsBAAAqAAAAAAAAAAAAAAAAAJAFAABjbGlwYm9h
cmQvZHJhd2luZ3MvX3JlbHMvZHJhd2luZzEueG1sLnJlbHNQSwECLQAUAAYACAAAACEA4VE3H88G
AADmGwAAGgAAAAAAAAAAAAAAAACqBgAAY2xpcGJvYXJkL3RoZW1lL3RoZW1lMS54bWxQSwECLQAK
AAAAAAAAACEA49JqRpU6AACVOgAAGgAAAAAAAAAAAAAAAACxDQAAY2xpcGJvYXJkL21lZGlhL2lt
YWdlMS5wbmdQSwUGAAAAAAYABgCvAQAAfkgAAAAA
" o:spid="_x0000_i1026" style="height: 170.25pt; visibility: visible; width: 464.25pt;" type="#_x0000_t75">
<v:imagedata o:title="" src="file:///C:\Users\DEll\AppData\Local\Temp\msohtmlclip1\01\clip_image001.png">
<o:lock aspectratio="f" v:ext="edit">
</o:lock></v:imagedata></v:shape></span></div>
<div class="MsoNormal" style="color: red;">
<span style="mso-no-proof: yes;"><v:shape id="Picture_x0020_3" o:gfxdata="UEsDBBQABgAIAAAAIQA0Ev94FAEAAFACAAATAAAAW0NvbnRlbnRfVHlwZXNdLnhtbKSSy07DMBBF
90j8g+UtSpyyQAg16YLHEliUDxjsSWLhl2y3tH/PJE0kqEo33Vj2zNy5x2MvVztr2BZj0t7VfFFW
nKGTXmnX1fxj/VLcc5YyOAXGO6z5HhNfNddXy/U+YGKkdqnmfc7hQYgke7SQSh/QUab10UKmY+xE
APkFHYrbqroT0ruMLhd56MGb5RO2sDGZPe8ofCAJruPs8VA3WNVc20E/xMVJRUSTjiQQgtESMt1N
bJ064iomppKUY03qdUg3BP6Pw5D5y/TbYNK90TCjVsjeIeZXsEQupNHh00NUQkX4ptGmebMozzc9
Qe3bVktUXm4szbCcOs7Y5+0zvQ+Kcb3ceWwz+4rxPzQ/AAAA//8DAFBLAwQUAAYACAAAACEArTA/
8cEAAAAyAQAACwAAAF9yZWxzLy5yZWxzhI/NCsIwEITvgu8Q9m7TehCRpr2I4FX0AdZk2wbbJGTj
39ubi6AgeJtl2G9m6vYxjeJGka13CqqiBEFOe2Ndr+B03C3WIDihMzh6RwqexNA281l9oBFTfuLB
BhaZ4ljBkFLYSMl6oAm58IFcdjofJ0z5jL0MqC/Yk1yW5UrGTwY0X0yxNwri3lQgjs+Qk/+zfddZ
TVuvrxO59CNCmoj3vCwjMfaUFOjRhrPHaN4Wv0VV5OYgm1p+LW1eAAAA//8DAFBLAwQUAAYACAAA
ACEARiVH/SgDAABXCAAAHwAAAGNsaXBib2FyZC9kcmF3aW5ncy9kcmF3aW5nMS54bWykVVtv0zAY
fUfiP1h+Z+k2Orpq2YQ2NiFxqbYhnl3HjS0cO9huOv49x3bSphUItFVq6+v5zne+iy+unhpNOuG8
sqakx0cTSoThtlKmLum3x9s3M0p8YKZi2hpR0l/C06vL168u2Lx2rJWKEyAYP2cllSG086LwXIqG
+SPbCoO9lXUNC5i6uqgc2wC50cXJZHJWNEwZermDumGBkbVTz4DSlv8Q1TUzHfOA1Hw+Xuk5av5y
ZDY33Z1rH9qFi8z5l27hiKpKCuUMayARLfqN/himxcGtegfwtHJNPG9XK/KUUH7F34QhngLhWJye
Td/NpjDAsXd6Pjt+i0m2Ir/+4R6XH/5xE4SyYQxGZPqQ3jo4EklFV1OQ08qhx9PB44XiYe0EOR25
fnhtDP0JwfLE2GvJTC3e+1bwgOSLt8EHkh5a7fX7C2Zk2sO/IIPa7ASSB6M5vn3SYPSMrNlHM91C
8Sgflv+UMtjdCTicyTdYpPI3wXYaOmc3UrDKDzruoxRxusdiqVV7q7SO4sVx7637H1+Rq4qLG8vX
jTAh17ITmgU0ES9V6ylxc9EsBcrCfaxSYNncO36PQKe89cGJwGU0vgKJfh1h3m4kxjuSkb9HzZHl
5rOtUGVsHSxiNeTx8woIBof6a50Pd8I2JA5AG0wTPOs++cgZR4cj0aq3WlWDft7Vy2vtSMd0SW/T
J931klUir6J8J6lmo4/5eMLcw9GGbEo6m53jKOGsLan/mYH+ZS0T3ANrVBCOaNUAEba31rWJ/MVq
BQ/hWpzYNY4+yGpDlnrt7hnCNk18SaWiGMcRgGKC7Ji+zWCE6RovRtCItQ3fVZAPkrUIzCQzHkuS
buR1plvJsiQJqK/5sSRbNkmgPaKeCyNOq8iZo0U51kfLuiDttsNYE3Ij0qqW4V7VxCm8ZmFjF6H3
IscWxAmyNnVdPG/p34mupO/wPOHTkxtgcsB2FHybqSxFJ/RjDN1JVIcSCcnOJ9seDT527ZAgKXHG
wvS50ve90bmYJQk9lUFMfBiPNYBvojHqd+N5tDBk9HNelG1BYLDVMz0GxcGTOrYau+54fvkbAAD/
/wMAUEsDBBQABgAIAAAAIQBTUolh0gAAAKsBAAAqAAAAY2xpcGJvYXJkL2RyYXdpbmdzL19yZWxz
L2RyYXdpbmcxLnhtbC5yZWxzrJDBSgQxDIbvgu9QcreZ2YOIbGcvIuxV1gcIbaZTnKalreK+vdW9
OLDgxUsgCfny8e8Pn3FVH1xqSGJg1AMoFptcEG/g9fR89wCqNhJHaxI2cOYKh+n2Zv/CK7V+VJeQ
q+oUqQaW1vIjYrULR6o6ZZa+mVOJ1HpbPGayb+QZd8Nwj+U3A6YNUx2dgXJ0O1Cnc+6f/2aneQ6W
n5J9jyztygts3Ys7kIrnZkDry+RSR91dAa9rjP+pEWKPYKMR2QXCn/mos/hvDdxEPH0BAAD//wMA
UEsDBBQABgAIAAAAIQDhUTcfzwYAAOYbAAAaAAAAY2xpcGJvYXJkL3RoZW1lL3RoZW1lMS54bWzs
Wc1v3EQUvyPxP4x8b7PfzUbdVNnNbgNt2ijZFvU4a8/a04w91sxs0r2h9oiEhCiIA5W4cUBApVbi
Uv6aQBEUqf8Cb2ZsryfrkLSNoILmkLWff/O+35uvy1fuxQwdECEpT3pe/WLNQyTxeUCTsOfdGo8u
rHpIKpwEmPGE9Lw5kd6V9fffu4zXfEbTCcciGEckJggYJXIN97xIqXRtZUX6QMbyIk9JAt+mXMRY
wasIVwKBD0FAzFYatVpnJcY08daBo9KMhgz+JUpqgs/EnmZDUIJjkH5zOqU+Mdhgv64Rci4HTKAD
zHoe8Az44ZjcUx5iWCr40PNq5s9bWb+8gteyQUydMLY0bmT+snHZgGC/YWSKcFIIrY9a3UubBX8D
YGoZNxwOB8N6wc8AsO+DpVaXMs/WaLXez3mWQPZxmfeg1q61XHyJf3NJ526/3293M10sUwOyj60l
/Gqt09poOHgDsvj2Er7V3xgMOg7egCy+s4QfXep2Wi7egCJGk/0ltA7oaJRxLyBTzrYq4asAX61l
8AUKsqHILi1iyhN1Uq7F+C4XIwBoIMOKJkjNUzLFPuTkAMcTQbEWgNcILn2xJF8ukbQsJH1BU9Xz
Pkxx4pUgL599//LZE3R0/+nR/Z+OHjw4uv+jZeSM2sJJWB714tvP/nz0MfrjyTcvHn5RjZdl/K8/
fPLLz59XA6F8FuY9//Lxb08fP//q09+/e1gB3xB4UoaPaUwkukEO0S6PwTDjFVdzMhGvNmIcYVoe
sZGEEidYS6ngP1SRg74xxyyLjqNHn7gevC2gfVQBr87uOgrvRWKmaIXka1HsALc5Z30uKr1wTcsq
uXk8S8Jq4WJWxu1ifFAle4ATJ77DWQp9M09Lx/BBRBw1dxhOFA5JQhTS3/g+IRXW3aHU8es29QWX
fKrQHYr6mFa6ZEwnTjYtBm3RGOIyr7IZ4u34Zvs26nNWZfUmOXCRUBWYVSg/Jsxx41U8UziuYjnG
MSs7/DpWUZWSe3Phl3FDqSDSIWEcDQMiZdWYmwLsLQX9GoaOVRn2bTaPXaRQdL+K53XMeRm5yfcH
EY7TKuweTaIy9gO5DymK0Q5XVfBt7laIfoc44OTEcN+mxAn36d3gFg0dlRYJor/MhI4ltGqnA8c0
+bt2zCj0Y5sD59eOoQE+//pRRWa9rY14A+akqkrYOtZ+T8Idb7oDLgL69vfcTTxLdgik+fLE867l
vmu53n++5Z5Uz2dttIveCm1XrxvsotgskeMTV8hTytiemjNyXZpFsoR5IhgBUY8zO0FS7JjSCB6z
vu7gQoHNGCS4+oiqaC/CKSyw655mEsqMdShRyiVs7Ay5krfGwyJd2W1hW28YbD+QWG3zwJKbmpzv
Cwo2ZrYJzeYzF9TUDM4qrHkpYwpmv46wulbqzNLqRjXT6hxphckQw2XTgFh4ExYgCJYt4OUO7MW1
aNiYYEYC7Xc79+ZhMVE4zxDJCAcki5G2ezlGdROkPFfMSQDkTkWM9CbvFK+VpHU12zeQdpYglcW1
ThCXR+9NopRn8CJKum6PlSNLysXJEnTY87rtRttDPk573hT2tPAYpxB1qdd8mIVwGuQrYdP+1GI2
Vb6IZjc3zC2COhxTWL8vGez0gVRItYllZFPDfMpSgCVaktW/0Qa3npcBNtNfQ4vmKiTDv6YF+NEN
LZlOia/KwS5RtO/sa9ZK+UwRsRcFh2jCZmIXQ/h1qoI9AZVwNGE6gn6BczTtbfPJbc5Z0ZVPrwzO
0jFLI5y1W12ieSVbuKnjQgfzVlIPbKvU3Rj36qaYkj8nU8pp/D8zRc8ncFLQDHQEfDiUFRjpeu15
XKiIQxdKI+qPBCwcTO+AbIGzWPgMSQUnyOZXkAP9a2vO8jBlDRs+tUtDJCjMRyoShOxAWzLZdwqz
ejZ3WZYsY2QyqqSuTK3aE3JA2Fj3wI6e2z0UQaqbbpK1AYM7nn/ue1ZBk1Avcsr15vSQYu61NfBP
r3xsMYNRbh82C5rc/4WKFbOqHW+G53Nv2RD9YbHMauVVAcJKU0E3K/vXVOEVp1rbsZYsbrRz5SCK
yxYDsVgQpXDeg/Q/mP+o8Jm9bdAT6pjvQm9FcNGgmUHaQFZfsAsPpBukJU5g4WSJNpk0K+vabOmk
vZZP1ue80i3kHnO21uws8X5FZxeLM1ecU4vn6ezMw46vLe1EV0Nkj5cokKb5RsYEpurWaRunaBLW
ex7c/ECg78ET3B15QGtoWkPT4AkuhGCxZG9xel72kFPgu6UUmGZOaeaYVk5p5ZR2ToHFWXZfklM6
0Kn0FQdcsekfD+W3GbCCy24/8qbqXM2t/wUAAP//AwBQSwMECgAAAAAAAAAhAGKLImQmZQAAJmUA
ABoAAABjbGlwYm9hcmQvbWVkaWEvaW1hZ2UxLnBuZ4lQTkcNChoKAAAADUlIRFIAAAJSAAABoggC
AAAAo8e/oAAAAAFzUkdCAK7OHOkAAAAJcEhZcwAADsQAAA7DAdpqmNwAAGTLSURBVHhe7Z0LsFXF
lf5vJiLK614hoqJwfWRUFNFhBl+IoqMmoDGaSgxOphxrylRyazJkiqkKlbESiqQqkVBTFRkqSkKq
1JnMkEcZrRB1fABiVHT8a0QtQYMK+AwYLz7Axwz+v3vXpW27e/fu3ftx9j7n20Xd2uzTvXr1b/U5
63Tvffr72J49e7p4kAAJkAAJkEBnEPizzugme0kCJEACJEACAwSY9jgOSIAESIAEOogA014HBZtd
JQESIAESYNrjGCABEiABEuggAkx7HRRsdpUESIAESKCAtHfv4KGj/OY3v7l582ZcUScVg3a2e/PN
N7/88stJnhTlalF2KibG5kiABEigQwjkTXvvvPPOrYMHTmqIDPlYEjCOiy+++JBDDqmhk3SJBEiA
BEigMgJ5096LL754yuCBk8qcDm8I+Ti8MEuSAAmQAAm0PYG8ae/xxx8/4YQTjjnmGJz4YT300ENY
ALzxxhtlpRFLjk899ZRUwfXt27fj5LHHHsN13Y6sGWLShhOUf+utt1AA52pZVV9UNBYY8V+YWrFi
hZzoS68wpWzabstLxsrtHXfcgS5IYZzgvzjBX5S0C+vNGeeG8a1bt4IJDrGM3gkKHiRAAiRAAmUQ
yJX28AH94IMPHnrooRMnTsSJ5/MaeeKll176/ve/P2vWrKVLlyJ7IVNu27YNXcLnPv7iVfx99dVX
cd3oJ9LezJkz58+fj9xw//33Y61ywYIFmMZ5btSJBTSHv1deeaWc6Aeahs2+vj7Y7O/v11+Cq8OH
D0eV1157TSVmFEB2//Wvfy0lcYL/4uT8889HyauuuirEH5S3jV977bXTp0+//PLLy4gubZIACZAA
CRgEcqU95Kqzzz57v/32GzVqFNY5JXU5D5UnJk2aJOkNmXLNmjU437hx4yWXXIJ5Hs5xBdcNC0cd
dRSuHHjggfgr5z09Pfi7a9eu6HCKHXEG6U23A1dxYAKHRL5jxw71Eu4LTp48GbkWB07kNiHyN2Zv
N910U6A/tnEARA5WqRdJXXrKgwRIgARIoAwCudLeypUrkahklQ9JAv8Nd1EyJWZysHDyySePGTMG
UytcwfVwI4WUHDZsmGFHJog4MCPUXzrxxBORonDMmDFDrt91112YGl566aXhnhjGMV886KCDFi9e
bEw6ww2yJAmQAAmQQDiB+LQni5OSHnAsXLgQ/5WL9oH5nNz8kwJYF8VfrGfixtvcuXPlHOuN9gpn
ak/ULDNpzfO9996zjcjEVJwZO3asXkBcdT6YCvdkuib+40CyHz16tLOw0zGncWRTmJJJJ+/tpUac
BUiABEggD4H4tCeLk6ptLHXOmTMHF53eYD43btw4TAofeeSRefPmoTCKyXrmhAkT1Lm9wpnaN2SX
5557Tj0SYpTH1Ep/YES9isklEszatWvhjDG/PO644+DqokWL1NM3Rh+Rp8V/HLgnh2LGMqm85HTM
No7qwAJ0su7KgwRIgARIoFQCH+tA4SGkGaRDpplSBxaNkwAJkEA9CcTP9urZH3pFAiRAAiRAAh4C
nO1xeJAACTSewG9+85uQPnzmM58JKcYy7U2gE9Nee0eUvSOBDiSAtHfWWWcZHf/YRw88d82014Fj
w+4yFzk5DEiABNqQgJHzwnuonmWzH2oLN5K/pLP19evX/+lPf/IYL9znwg3mJ5PfAtNefoa0QAIk
UC8CRs6T/zpdfHLwsKeJciWpVjW9ldbhnvp11qmnnmr84Mr2pHCfCzdYDT1PKwWkPQoP6XxLFR7C
6JcfPCRFtNTWWztY/bpRTt8i9Kda20e79TYOaHmo/+zP/gyf1PhrHHaL+FHv/xs8nL/uLc/DTJbh
XqbyLJxKIG/ao/BQKuICC9x5553HHnusscWoLq5UYFv5TRXrWKBuVGqjgXbyd7/pFlJJ1q2DMqWT
VPfxj39cz3lJsz384vbowcO/coie4hvn6tWr8aUTy4xvvPEGruDkmWeeEQi4/vbbb+MEvyHGdYMM
XsXWTpi04QQFdu/ejTI4V7NMfSHRWFSUXyTjjS8nxgIszOIKHHP6r161d0t+9NFHVes4wX/FZ1SR
btoz4CQn7VbARzoIU3UbJOJP3rRH4aEq44r92/BTeqPF2oortcSxljRa5RiorK3GkZRspxKenOir
nTa6LVu29Pb2YtOl559/3gMWOQ+JBxtQYHuKgw8+GAsPmB2iFrbkRS1JOa+//jr+YqNgtYWTbhCf
k8cff/zs2bPxZQJ7ekybNu3CCy/ENE6lK30hUT+XTeqxheHf/d3fyXX1KpzHgicKHHnkkatWrUI2
1VuEz8jKX/jCF6ZOnXrbbbcZrx522GFqEokT/Ffq7rPPPuecc474ZidL20lnKw8//DA+puDYX//1
X1c2XDM1lDftUXioWOEhPXiGVJOhoyQl7Yt4Q9rCSU4pJVQ3ZI9sHaVU4ScYcRrXHXNqNomSlC3/
lOSqUzfKEIcKoaHsGH1X5FO77KSk+qJcsothaUQuYitaffXS6DKKyRWlkKyPCic3XMRm7mqvImPk
yDgJoa3spIYv06dMNYX1DJea8OASJiVPP/00PqA/8YlP4ETmcM4DCea0006T7ZxkVykU7u7ulg0X
d+7cCT0W2bYe2QLXbSOSV2SX+QMOOGDfffeVW3Thi6sfDB66ZSTgkSNH4srhhx8ubuivwucjjjhi
//33R+/sV8VJzFBlkiqb++OQHfbFt//7v/9LDVxSK/KFwHA41VplBXKlPQoPlSc8ZEs1OXWU7Iub
Nm3CDtq6NlOSlBIGmSF75OyOX/gpybjumFOzCa3b8k8eV/W3hPQRWlSG3lMIDWXHI/nk77KTku2S
XWzDhg2YDcDJESNGKDfsLqMYFt+MYnr3nbJZUDWRmYE9cqRuIG2xExK+yj6kAhsyVjVTawEyRia2
kkdu8K9zIiki58mHODIW/v7v//4vNjiUzIF1S9x6QNQkhTjTHmZRyh+1tWGqh/4CfjvwGV+enFsz
Si/Q9zfffBPTTWR06RRyMPoii7GBvjlbgcF3331XlnYD7VRcLFfao/BQ4cJDKvy2VFPgyBAhQF2b
KUlKCcUM2SNnd/zCTx7jymGnZhNeteWfQqyhovRRvjv79adsGsoro+86Xn+XnZRsl+xiKqbynVoO
u8vOYrZ7hmyW2mwvaeQE0rY37UsKX+CArKyYvZ6pbuk57+0hK2C6dsMNN+ADGh/f69atS3IVczV8
juuvShr7y7/8S3wGYvaGxIkBgHNciesv8mjWiqqKTBn1zIr/wmcsV2JpVA59yElDKIAlSkxSMd+V
jI4Nk6EDg7ljkvyn7aSzFdDAE6dYKYW6Tj1Fs3OlPQoPNUV4KElKyZA9iugO3i1JxvW3MaR0RbMJ
J863t5J/CrGW9QPCWT5a8imQUmCxQIBJXbZls0LgZKWdGr6QRssuo9JeSEPycayywmWXXYb/6vqa
uhHoayIpqodW8FkvX7nGjx//wAMPyAIm/uIcy4MRK3tImS+88AKMJCUJTMvsTqGK3LHDSiNaN2aZ
WOFELseXQlkdtb2SRVrcklS/iJBJLRZOnQ/IOJ30tILkB9/q+eOH+LRH4SEEtXDhITW4nVJNSe9n
/x0Cj5QSDOqyR57uJDXtN64cw9tDpjU4UaZs+Se/tZCPM5QJv1+i9z3QuD/ouhEbJuaXuvyWFLa7
7CymW/bIZimDONFFvvDfCNqe8NVQIcuY0vk/cJEzsBYHLJIS8D0AEzXJPfaBqRKCgoBiXoj5ECpK
FpG7fbKyIlkHM7/wgaRKYokV+QnPPeIxHLv6eeedh4RqPxWJVPfss8+KAgwetzG+AOGNBkGbX/7y
lyigHtTUjWNhEx3B4zDqIuZn8iSnswtOJ52tyGOcaBp3Iuopmh2f9ig8hMFRnvCQU6rJORyTxJVU
YY+UkiF75OlO0pvZY1x3THSp8BGv35Cw5Z881gI/TVJpKDvRkk+BlOxip59+OlpHu/onlN1lZzG9
+x7ZLBRLGjlZaaeGLzAilRW7/fbb8ciiOnDf1zh0T/7iL/7iz//8z/U5EJ60POmkk+RNLUuC6gTn
SCFYM8QVPIQp8xgcOMEVuTGGvzhXL+lt6Xac55hgwTgOeTLTaB3/VU9F6tWxqgmfcQXZS55tMXxG
B/EqZrTw2RkFFJDHYeRA6x43nE6ilt0KVjilXeTUiLlvBQOmE/fkpPBQBQPLbgK3UrBOop4Z6+Qo
4FlNCDr29fXJ/blMRxy3uFq6Y0b4MvnMwoUTwJcnrNLjYc7CLXeCwfjZXifQYR+LIoCb57gPoXJe
UWYbagdP/eF2Ee4MNcV/hq8pkaKfIQSY9kIosUwuAphq4L6IrN118qF+yYf7QxdddFFRD7KXjZTh
K5twhH19tTOieodX6cRFzg4PObtPAiRAAp1MgLO9To4++04CJEACHUeAaa/jQs4OkwAJkEAnE8iV
9mQ7SjlqCzFpb0Onw0rdJk7iJ1UcJ7WA7lUmz1HR3uwxa1Cytij287eb1c+I8nFdi2ioJVXau3ct
QcpG25hArrQHLmpPjfZgpFRp4iR+UkVtUgvkUXvBT1bx2yz5Gx6OPC1KK3HthnvY9JL5CTedAP0n
gVoRyJv2atWZAp1plcRPHrUX7K2H30HL33AUeVqUVuLaDfew6SXzE246AfpPArUi8PGFCxdGO3T3
3Xfj9/+GyD02gF+2bBl2QsLPkkaPHg3jWIHBFjV4elv2glIHvgVfd9112AEdkldIM/fddx82Mser
uI5t4LER+IoVK9CEFBA72AsH11ELolbYEAEfKNhJVi+A69g+RgrIvji6k3qLzl5LE0uWLMGr2JgV
dc8991wpKQu56iJemjJlirRleAgg2BfqlltugRaM0WWxn1QgpAnhozeqOgJKeCZe/uIigDsBSryc
PXV2CoX9MTXaVf6kxsvpoYqgomoXw8+9sYUSeifBEqQ2GRTDrk5ghQIInDFW4Z49Woyx6uy4Xctu
WtnBvrVq2OzZswf7SIkeGyxjJNv7PicFzsbi750NLfptzook0GYE8s728NGj39tLEj1RqigKn6G3
gl/vQsIK2QKbsUL8AhssRYjgwLhTk0UaDRS1QcloiR/VO4+ojZRxFgjRzQnvRYgoUmCL+BKDkrNm
zVq6dKkoaeGwY2q/N6jgE6HgEyhs5NcnCol+m32WsTskEEggb9oz7u35RU90n2y9FUgPr127FnM+
nKBkhAgOatnqKqrRQFGbQHAoFidqI/Y9qje6A5lUhAzPs4oiSXVni3JRdtJCtpOSzpmK4QMVfHQg
gQo+gcJGfn2iuOiHD36WJIHmEsib9vL03JCYkTtSSuM4XLclyQf7Fld9RG2iVW/Q2cBe5AeYJ7gh
dQM9DCwWTsbpW6YbospCGQo+4f31QC7ESEgQWYYEGkeg4LQXLpdj661gqodlNBzYQx0cI0RwUMuj
yVI3UZsk1Zs8KkL6+LMB4pFL4YOfZ+glQ1pEeUPIJv9YDwxxeyv42BgDsfj1iQKN5A8iLZBA4wgU
nPbC5XIMvRXcshoxYgSW0XBgW3H8N1DexSDu0WQxWsQTAdjFPFPAChS1SVK9SW0iXJrHBoi0h/um
Rq9TWwyPaSaYKBwY4jZW8HEOwkAsfn2iQCNZQ8byJNAGBNpqT85M6iqYu7z//vshN6jaIMzt2oWm
K/hwELbryGS/6kyg4Nlenbtq+IbfHsij5DyaS6DpCj4chM0de/S8uQQ6N+3hoZKmKL80d3iV5Hnb
KPhwEJY0QmiWBDwE2mqRk5EmARIgARIgAT+Bzp3tcWSQAAmQAAl0IAGmvQ4MOrtMAiRAAp1LoLC0
V3/pk5Z46GzULz9Ukp8lmY176xTuTOEG4/oVV0uNB9ULuzv16WB9PImjzVokUFjaqxXKGkq96C6l
yg8VBbOGHIrqGuy0Te8qGA9tw6rA8UNTHUugPdNeDaVeWuJSSxqt7L3U3r0rFiNZFcuT1hpNIJfw
UJL0iS3XAkZQ4bnmmmsgbXP00Ud3d3crCR68pM5TpWrkO76h9WNoshjyPSo8TlUdW5/Frxnklz1S
CjiqRyJ7ZCgZ6f2NU0qqTFQoiYY+6I2IOCVvjOgnKRyJ2cp6p3qhixB5BI8ixqc0gWXMDz74QJSw
YAT70o0cORJM1q9fD7EtY7RARMmW9NKJKVEt++2geqQHzn5HpKqDGTHNKnIUMmwa/blJ5xtNINds
zyl94tQewjsc22JB2w86LLKRf9Lhl6pxyu5s2rRp5syZ8+fPx1da7DbplA2S5qTkggULpCSu2Pos
Hs0gv2+eTnlcilNKCpGVKURUKFVByY6I7Zsz+nYsFMDKeqeHzBhFzrGBixHjE7WOOeYYBBonsq+p
7IwKLQtcD//4sIeKR4VKD5wxElLVwWyzWUWOUodNeK9ZkgQKJ5Ar7TmlT5zaQ/jgg3hNyM/D/VI1
TvEgkcWRr9K7du3yMLJVdWx9Fo8kkN+3uNjEKSXFycpEiAqlCiTZEbF9c0bfI9tUWe/0kNmjKEL6
KkncauLEiWvWrEFz2JYFW6IDCM5xBdfDh409VDxaWp7ApaqD2WazihylDpvwXrMkCRROIFfaC/cG
4unhhf0lA2V3Apuz9VnySAIFNppULFwpqTJZmRAaRkRs37JGv7Le+eMV54ZzfI4aNQr7gGOmiFSH
rb2xYTqY4Aqux42ZVMGjkMB5ms70LqvVmyiOJ2t1FIFcac8pfeLUHrJFf5JEcPz0w8WD/GI6qhWn
PkuSJJDft9QeOV2KU0qqUlTIT8OOiO1beNSEcJW988Q0QrvH01OsZ65YsWLu3LloEefQwci0wola
9lDxgzUCp4ZfqjqYbTZC5CjuTdRRH77sbKsI5Ep7TukTp04NLk6YMGHRokW4uy431ZwiOKkUAmV3
UsV0VEO2PkuSJFCqb/4eJbkUrpSkO1CZqJBOw6mSY0fE9s2Ovh9mZb3L6kbqGPCMT1nPxLsAf+U8
0wonyttDxdOcMYz14ZeqJGWbzSpyFP0mSiXMAiSQnwD35MzPMN5CJqWk+GYKqkmVnIJA0gwJkEAr
CeSa7bXScbZdOQGq5FSOnA2SAAkUT4Bpr3im7WqRKjntGln2iwQ6igAXOTsq3OwsCZAACXQ6Ac72
On0EsP8kQAIk0FEEmPY6KtzsLAmQAAl0OgGmvaEREC2n4lcRco6vCDWiuo3TaFx16wj9IQES6DQC
zU57dZBTCVSNSXU10E6nDVC7v6kkiYgESIAEPASanfYaJKfSIFdr/oYhyZoHiO6RQM0J5BIeckrM
SIdt5RGPYJASUnEqzmCPaVzHXkfGq7acitGEeIJar732GprAObaWh3IQtvS1G1JSL05FJNR1Gsd1
p4qQEq8RHwxXnbI7yk608pGTnqHKJECwSxZ8UE5i+5XVq1fjIoSToJGk5JMyqc/o2j0qoLiowif8
ly1bhk22xo8fP3r0aCFjSy/ZtJWdlStX4tVHHnkE/u/Zs8eObM3fb3SPBEig5QRyzfY8AjGG8ohT
IcUWUnEahD4LdqsCKeNVW04Fn+O4iI9Cfe9j7KyP/eMFtNpIPkTaRo+NR+FFL2aL18irIRpAyk60
8pGzUyF6OpCVgXIFnBwxYoRyI6v6DCo6RZRU+JL0bgL1dMSOTtIZ2Za/o+gACZBAzQnkSnsegRhD
ecSpkGILqXikXsDRr0eTJMJyyCGHTJ48GRuB4sAJ/ptqyo6ZR+FFL5xHAknZiVY+cvIJ0dNJEpDC
dUyzsCPzjh079C8NwtA+nCJKclGvLoKLSGNyPVBPR9lR7TojW/P3G90jARJoOYFcac+jzGLrnvil
TERIxS/1kioEk9QEFkgxpcAxY8YMIZ5qyg5MJimWPHGNlowJ7FRgMXQhT5dtEaUQJql6OoaR6dOn
S2RxEmKfZUiABEggV9rzK7PoyiNOhRRbSMVv0PmqIaeC21R2UKHwItM1ucOHw9OQUz8oq3SOc2AF
aiGhbpxoS6BQjl3MIyCl8/Srz8Btj4gSXk3Su8mqpwNTiiRuQ0pkcSLM8XuS7du3841NAiRAAkkE
cqU9WyBGNWMojzgVUmwhFY9BWLZf1eVUPCIsUHWfM2cOpM6UvLunIad+UKDgkWechWshRYu2+Okp
3+xiTlmZrOozsO8RUcKrSXo3mfR0YEcnKZFFQlWR5VudBEiABPwEWrYnZ7M0dzpkGGFuB03Evr4+
uf2W6YgLaFwt3TE8bor7lz09PZm8ZWESIIGOJZBrttex1Nq143ikE0/94NcFTekgHlPavXs3c15T
4kU/SaAOBJj26hCFFvuAX/Jh1oWjv7//oosuasqCoTxlKiu0PEiABEggkEDLFjkD/WMxEiABEiAB
EiiQAGd7BcKkKRIgARIggboTYNqre4ToHwmQAAmQQIEEmPYKhElTJEACJEACdSfAtFf3CNE/EiAB
EiCBAgkw7RUIk6ZIgARIgATqToBpr+4Ron8kQAIkQAIFEmDaKxAmTZEACZAACdSdANNe3SNE/0iA
BEiABAokwLRXIEyaIgESIAESqDsBpr26R4j+kQAJkAAJFEiAaa9AmDRFAiRAAiRQdwJMe3WPEP0j
ARIgARIokADTXoEwaYoESIAESKDuBJj26h4h+kcCJEACJFAgAaa9AmHSFAmQAAmQQN0JMO3VPUL0
jwRIgARIoEACTHsFwqQpEiABEiCBuhNg2qt7hOgfCZAACZBAgQSY9gqESVMkQAIkQAJ1J8C0V/cI
0T8SIAESIIECCTDtFQiTpkiABEiABOpOgGmv7hGifyRAAiRAAgUSYNorECZNkQAJkAAJ1J0A017d
I0T/SIAESIAECiTAtFcgTJoiARIgARKoOwGmvbpHiP6RAAmQAAkUSIBpr0CYNEUCJEACJFB3Akx7
dY8Q/SMBEiABEiiQANNegTBpigRIgARIoO4EmPbqHiH6RwIkQAIkUCABpr0CYdIUCZAACZBA3Qkw
7dU9QvSPBEiABEigQAJMewXCpCkSIAESIIG6E2Daq3uE6B8JkAAJkECBBJj2CoRJUyRAAiRAAnUn
wLRX9wjRPxIgARIggQIJMO0VCJOmSIAESIAE6k6Aaa/uEaJ/JEACJEACBRJg2isQJk2RAAmQAAnU
nQDTXt0jRP9IgARIgAQKJMC0VyBMmiIBEiABEqg7Aaa9ukeI/pEACZAACRRIgGmvQJg0RQIkQAIk
UHcCTHt1jxD9IwESIAESKJAA016BMGmKBEiABEig7gSY9uoeIfpHAiRAAiRQIAGmvQJh0hQJkAAJ
kEDdCTDt1T1C9I8ESIAESKBAAkx7BcKkKRIgARIggboTYNqre4ToHwmQAAmQQIEEmPYKhElTJEAC
JEACdSfAtFf3CNE/EiABEiCBAgkw7RUIk6ZIgARIgATqToBpr+4Ron8kQAIkQAIFEmDaKxAmTZEA
CZAACdSdANNe3SNE/0iABEiABAokkCvtfXPvcfPNN7/11ltJbr388ss33ngjyqIASuK/4R1Arc2b
NxvlnRfDbbIkCZAACZBAxxLIlfZA7corr/z+978/YcKEu+66KwninXfeeeyxx6IYClx88cWHHHJI
x+Jmx0mABEiABFpLIG/aE+/HjRv34IMPJvXkqaeeQoHW9pOtkwAJkAAJkAAIFJP2XnrppTlz5iig
9957L9Yh8RdXZG1zxYoVcqLWJ3GCdKiXxKt33HGHrJtKXTnee+89KYbydswMC1hE3b59O0NLAiRA
AiRAAk4CedOe5LPdu3fPnDlTGnjooYeGDx+OJc3XXnsNiUrWNmUt1PBg06ZNqDV//vxbb71Vbvid
f/75KHbVVVepK7i4bds2FOvr68MNwv7+ft2I0RZjTAIkQAIkQAJ+AnnTHvLZvHnz1qxZ884770hL
vx48kAux7Lljxw5P8yeccAJePfDAA/F3165d+IvnYjB7u+mmm9QVnBx11FH4O2nSJPxFKtUN2m3h
3qEY5EECJEACJEACNoG8aQ8W8YgKVjgxdVPWZW6HQ00BA9HjuRjMFC+99NKk8sOGDTNeim4r0CUW
IwESIAESaCcCH1+4cGF0f+6+++5p06aNHTu2u7t7+fLlZ5xxxj777DNmzBj85ODwww/HuVhWxfRz
58Ubbrjh5JNP3n///e+77z6xjGIHH3xwb2/v1q1bH3744U996lP77ruvqmu3hXt7eHxm5MiR0Z1i
RRIgARJoLQHc2XmDh0YAKabAiHxsz5490eawkonJlixCykMomN5hofLRRx/FzbnJkyefd955mAvq
xdS58yLuBeIGHmzilqFYRrG5c+c+99xzICDW0Iqqa7eFtDdjxgyuc0bHlBVJgARaTgBp77DDDmu5
G2U4cPNvb89q9q9OnDJx4sSstTzlc6W9Av2gKRIgARIgASHQ3mnvs3M+FR7oW27978LTXgH39sI7
wJIkQAIkQAIkgEcgQ46SQDHtlQSWZkmABEiABOpIgGmvjlGhTyRAAiRAAiURYNorCSzNkgAJNI/A
s88+++1vfxv7ZsD1pUuX4r+Z+oCKv//97+0qSdczGWfhoggw7RVFknZIgATqSAApRx14wtzY6cnw
+Prrrz/11FOxSyKuYyOOI488sg5d+qfB480339SdwZWnn366Du41zof4tIdfLOg7Zz722GMyVqo/
sooZGR4q+STZNTT8qFIUKWcfVaeo2ZQa3zw6WU7jusHU1ssr0Mmh/8EPfoBPJ2zq9Ic//AE/kfJA
Xr9+PfRkyotCtOXjjz/+tttui67OijqB+LSHrcXw1UntSbZy5UrZbKyaAxlX6fDlFzNSW71U43xE
K3n6qLOKaLqaKvVxsnCdLN1gNTDZipMAdrE488wzV61apV5FksNEEKuass29rG1+4xvfkBO1MokT
lPzVr36FE/zVq8uKqH4RryqzzjVSo1GUxxTTuc++3ouzzjpr1KhRTzzxhLNrmPb95Cc/wfzvF7/4
xR//+McGDQC8O+yjbP/j015PT4/akwzfZ/Hj9CqF9JBxy0bTNvYbwao+Thauk1W4wbYZmRV35O23
3163bt2//Mu/SLu4CYdRhzxx2WWXff3rX8fip6xXydTQ8A273s+ePfuaa6758Y9/rJLZfvvt953v
fOe6667DRZW30ASWRmHhnHPO+epXv2qsqdqNSkPYlDGVxtlnn/3AAw+8/vrrRknkvB/96Eef//zn
f/jDH37yk5/83ve+B22AVGs1KYBNSAxP7CuFuxqf9uAKpneY5GHChx9XYm8U5ZwhBoR9xbCw4F9b
0DvmlB/CIqqsRsKaU8wItTA0xQ5O1MCNUCYqSRQpiYO++qTOjcJ+wSaEQKBhBmysZRmsAEcJOelr
1AYlFQ4dhXpj4yLCoQIK2riC/4qMBg5nLVw3WlF2dCeT4iiW7bGRRNU5ipR7uv/ROlmeHukAca6E
t2Rw2rh0f6Su3a9UlS4jLvpbRmw6Q1/4Z0oNDcoE7pJLLsFsb9asWeIh8hMyE76+4ys7/vv88897
PMemiZgsSknsGCUlTzrpJPyV+3/vvvuuXJw6der48eNxIg0ZZp2NXnHFFSE3EbFrI1IC5kaGn0il
X/ziFw844ABcFw9fffXVGkYhySU9z1WQ8+BGrrQnE74NGzZg0fzQQw+VXtliQNdee+306dMvv/zy
wEjY8kN4A2N/Mmwfiu2tIcXgFDNCDoYb0gROZMU1UJlIPpX0e3tliCJl4uApbPuGEEDCAlhGjBhh
QLZZSfUFCxYodSc/JafwE95XElDUhdoiWsGbHE++Ybs4ccCu5WxF7OhOOuOoOmWPjSRQThErZUf3
P1ony9Mj1ZDBPwmX8kdVNPplt+XsoLJjvGXErB36wLdk04vJBA5rgPpjlljtxMRInnZJ7SAmdkYZ
zB3Xrl0rK5/6S/hU9FjL1KhtB3sdY5suY6nz/vvvVzreSI2ohe83qT2qVQHJdtXkPDSUK+2hvnxI
4WuUGha2GBDm5vgQtB+gUs+SGAGw5YfwHkZD9sjTK2KJFd90MOHQV1wDlYnse3tliCIlcXCOP09h
2zeV5kPWmaW6vDlF78mvFeUUfpKLUlcMijKU+ppp13K2ouwoCM44qlftsZEEyilipezo/kfrZAX2
SI+vH5de0uiX3ZZHpQt2nG8ZO/S1+uwr2xncHsP6pMp8eGITS5RIh3LI1C38+OlPf4qZHKaPxoqo
etwBeRHWjNXLnI3C4GmnnYalTv0GHp52UV83xX/s1x/ekZqUrCznob950558eqrvGkLQEAPCt6GD
Djpo8eLFRuYTcSJbftaWH0q93yvtnnjiicivxoprUcpE+UWRkjg4h12mwvkHbiAlW/gppGlVK7AV
rA1IHHFi2LejkAQqNV7KcqBXzp7mqetHZ/fLaMvfwcC3TEj42qYMVik/97nPQc5TEhJWOFN/z+Dp
O+ZtWMzEYTy3gnm5fNDdc889SHLydVAdzkbxSEumHwh+9rOfveWWW5RNpHPcYpB7fo888giyICaF
bRO1MjqSN+3ZPmHm9/jjj6uvPCoh4cQQiU3qD/RpR48erVtw2rQn8sccc4x8KVYrrnZF/BJg+/bt
EShtr2AE63v4i9sw+AuZJN1sOIdTTjlF7Kh7Y1mhYWYA5soTu3f+RQ+nq8qIp48oI3VV04q8Xcvf
CiwoJ4844giJI06MvjijgK879uhylgwcroHDI7VHSc3ZuJwt6v2y2/J3MMK3wF43uhimdJ/4xCeQ
kNALLMsjLUHdE98wkHiy9gtPsuCZTDzJaVTEXUB8I4FN/Fjia1/7miGClrNRaQu5FnM+1e7RRx+N
r0RYbsUq7iuvvALJmqx96bTyxae94447DpO/RYsWqWcccIL1TNwFtFe0nLhxswdV9ByJkYQf08Am
7EhuQJjtx2SwCopWEHW1HGo742zRvrdnF7O9QhkI/iGPYokfv2zF48V6rXAOSHu4c2k88pMJ2umn
n46mUcU5G3Oy8ruqv+rpI4ohNAg34oKvmYCgyNu1/LHQnZQ46ivnyh87CkmgnPGywxo4QpzDJqJu
Ei7bvtEvuy1/B+23TKd9tKn+GguYGKUYXfIqTmSFEw+VyBW9sDp3XsRDKFgjxSHPbcoaKU6QSvFQ
JU7QkDzbYpi1G019pAWPaCK36RGcMmWKfhH//fKXv4wrMI45Q8fGOrDjFB4KBNWMYpgi48tBX1+f
sbQS7T3ymZJUDDcSV0u3j6cWcSPK/3RAuD8sSQLNItD2wkPGcmBSdPANmMJDzRq6LfAWj3TiuR71
HbMFHhTRJCb0+OERc14RLGmDBOpIAPks5CjJdc72SgJbqVmsqKxZswZN4iYfVrcKTBhx87a4WoIM
dbHqe+655xqLxpUCZWMk0FIC7T3by4q2cJlZpr2sIWB5EiABEiiXANJeuQ00zTp+rVigy0x7BcKk
KRIgARIggboTKP5Jzrr3mP6RAAmQAAl0MIEWpz1jA0l/ICLEdzLZR+s10YiRW1xKYkLHUh+9p/q8
a/QNS53QinK1cE2iVMeyDmC/wcL9j3hLpnaZBUigbAItTnuqeyG6M4HiOyGmkrDm14jJ03pIsFur
92R7WHZ/Q5hUVqZwTSKn5+UhLdz/wLdkZQFiQyQQQqAuaa9A3Zk8pvJrxORpPSRgrdV7sj0su78h
TCork394hLhaHtJq/A/pI8uQQAsJfByyBtHNYwXmwAMPxNPzsosSvqViwx5svdrb24v/YssubByH
LXHlVRTGXlOyg5c6v/vuu6dNm7ZkyRJcxDYf+C+eXDcqKvdULZxgE6yNGzfqzUkxUVFQpmAQ+xfY
JQ1XnXWN3mGrvWXLlmHPLfwqTvZBsN0wWtfBGi06u4CfcGKTWXQKoNAFkDE2PBOD3d3dy5cvP+OM
M5555hnsx6bKOD20mRs8n3zySbQInti7HR+4N9xwg4qgM2R6dJL6KxU9ljFmsDMOoqO3ZcfU6YBd
V0YROMjJww8/jC1+ZJs0MIEbxvZAGJMQTkNh7HwBmFIsa3CVb4ja6tWr0R10GSNZgDs9979f8g9g
GZNJb0kjWKnvJnvE6paVt6q/SW/J6I8XViSBkgjkne0lCbjA3XCdHUOcJaSiLb4jgPLo7Nh1U+V1
DDecikjyqaqr24irTv0gfF479YP08CfpPTkFgPzjBnfCIEI0f/58bIUF+RKsWemCRM66enSS+ouK
fstO0ZykmBpu+BWFUNgvXWQr8iSJAQUG16P6ZAP0vF/yD2CxUJmmktG7wPCV9EFGsyQQTiBv2vMI
uGTS2dE9Dqloi+8k9Tmrzo5uJ1VeJ9ANp0JNHv0gp96TUwDIPxSkg/gWj79yrgsSOeuGREdZS7Ls
FM0JhOlXFELTfukiW5EnSQwo0J9Mqk/RgkdZhaLAwa8npQfXORRtPSb/nrqBuMI/m1iSBEoikDft
6W4F6g2l9qQCzZ3y9GKSeldsi069p1SwhRQoJDrhqkC2zyF1PdJF9VHkyTMkAusGFnMOjDx1Cxlp
NEICJREoLO2l6uwkyeuojuniOE4pmXAEeXR2nK0kyes4C9utB6rAOPWDApWSnB6mMvcjDVREipBy
DlQFcjoQUtcjXWTHIlNwbWLOqKWS9w+JQgZw4KjzDPjA/YLD35gsSQJ1IFBY2kvV2XHK6ygEuu5M
Js0dG2JOnR1nVML1YpytByrU+PWD/MPF6aGfeer4C1FESqXtbCVQFcjpQEhdj3SRrcgTHlxnX5xR
SyXvGRKpSAOHU2AxZ6fy1E0dVyxAAq0lwM3JWsufrZdFoHrposJVn8pCQ7sk0NkECpvtdTZG9r5e
BFoiXdQeqk/1CiS9IYESCHC2VwJUmmwpgYqli8pTfWopRTZOAm1LgGmvbUPLjpEACZAACdgEuMjJ
UUECJEACJNBBBJj2OijY7CoJkAAJkEBhaa9YhRQjMKUa5yAgARIgARLoHAK50l55CillB6C5npdN
hvZJgARIoL0J5Ep75SmklA29uZ6XTYb2SYAESKC9CcQLD+WR+MGGWx988IHsUww72Ips5MiR2CN4
/fr1xx57LC4aoie6fhD0TaSiOnQRH/WqU9pGlFNWrlyJukqcqL0DzN6RAAmQAAnoBOJne3kkfqAS
t23bNvgB8Tb8hWIO/kIwBddx4pTpQXlI5PT19WHrsv7+fiOK9qtOeRrRZPHI5XBwkAAJkAAJtDeB
+LRncwmX+Jk4ceKaNWtgAQKw2DAX8zyc4wqu48QpmCKiJ5MmTcJfiNIZrduvOuVp/Mop7R1p9o4E
SIAESAAEikx7TqBO+ZJRo0Zhr14okSLVYSPgMWPGQA4GV3BdjPhFT4YNG+YJnrwaIk/DEUACJEAC
JNBpBPKmvWiFFKxnrlixYu7cuSCOcyxdygonDqdgiiyEyqLo2LFjjTjZr6bK0yjPA5V9Om1ksL8k
QAIk0JYEcqW9PAopsp45YcIE/JVz+YvDKXqCGSHy09q1a+fNm6cmhSok9qt+eZpUz9sy2OwUCZAA
CZBAO+zJiSc5kcZ4346jmQRIgARIIJVArtleqnUWIAESIAESIIFaEWDaq1U46AwJkAAJkEC5BNph
kbNcQrROAiRAAiTQRgQ422ujYLIrJEACJEACaQSY9tII8XUSIAESIIE2IhCf9rBtJg6FAjutYLvL
QshUKTOEttSRyXmnk6V6jt9vvPzyy6lOOn0IrJtq3C4Al/CbS9mgNWsr1TNM7WDWLojBUuPu9Nnp
Z/VupPJkARKoIYH4tIetyKBj8M4770ivsL+zbE5W6hEhGJRaRe0IU6rn+Y1ffPHFhxxyCOyk9shu
S9XN74Zh4c4778Tu4bLNaXmtGI1GEPB0XLdWeBeKdVX1Is9gSEJRkquFDzkaJIGcBOLTXk9Pz5w5
czZt2gQP8JV/8uTJ8qFc6hEhGBRRpdQu5Ddeqx5hV7lx48bl71QmC8USKNaa0ZFSjaOtAu0XaCpT
NFmYBComEC88BEe7u7uXL19+xhlnPPPMM9haTO0ZZsgGYUexW265BaugEBgK6R5khqZNmwZrhniQ
IXUk857rrrtu+PDhvb29+K+uQCQXjSpYGsJnNESOlBuqLXXFNoKXbBkjpxaSbi0Qgg7Hr8cEx444
4oglS5bAH101CWCvueYaNH300UcjIrpjOhnUBVJn7zBlX716NfaKE/tSUgcigk0SPr1fBl7xMKmV
/AzFJXsYQLJj2bJl2KBu/Pjxo0eP1seY3She1YldffXVOk/pwsMPP4ztziFihZdg/Mknn5TNEIyY
2qMoYsTqbHXPIwaDM/TSBYOPipTwdI6rkLcqy5BAEwnEz/bQW5nwbdiwAZoJ8hkh7zF82mLVCx8c
mArgyrXXXjt9+nTsFpYVkCEeZAgGOfWJMPuEPtH8+fPx1RVz0BCNIXzcy+095Z5hBNedMkYeLaRw
CDocvx6TuGf0CJ/gzz333MKFC3Fd5ClwiP8LFiwQCAZ2u3eI4K5du2BhxIgRzhiJYJMdXA/eMhg6
CQA1Eh48mTVr1tKlS6G8oXfBDpxBzNkFLNdjSIsdnMjqvXO8GbgiRqxia5iKGAzO0Pv5qEZD3ilZ
378sTwL1JJAr7aFL8gGBzaP3228/9TGBK8gi2Ax6x44duHj22WcjQ9gieanPkjjFgxRHpz6RfEKJ
Di0+yg3ouCNiSNSigH1vzzbikTFyaiHZviVB0K/79ZicAwgf4vBWwZcytgKUXtfunfpkT1qmVhu/
OZk7HSuDobMh5bwEAllEL2YHzknMsAwOWLTHNwZ99T6k7xEjNmlTvYjB4Ay9n089P5XoFQmUSiBv
2sOED/4Zd3cM2SB8BT7ooIMWL15sZD58wZQjqYep4kF+faICwaV6YmshBULQ4aTqMdk9kvl0lUc0
8/wMI7ppNxpIDCu6+K6GY8aMGard1L6n9jHVgmorYjBE8GEVEuhAAnnTno3MKRskt4VseVg/cad4
kBIMcjbkNJhfY8jpiUcLKRMEHY5Hj0nvWgQED2rMOB9//HEUEF0nzxHO3DZSCENl1iCgnFeL7VLS
btTZBVs/C4GQ6Z0yGNL3okasOJ91MDgDJ24bfKBtKaPXWAP364h14Ocju9yWBIpPe7ZskPyuC3cB
s4ok2OJBumCQU5/IDlKqxpB9b8824pQx8mghhUMw4Hj0mJRXeo8g0gvxpkWLFoFwyK/6nIP49NNP
x3V44tfvRZlA5s5W8jNMIoDFBnQfj/lAlMpY77UbtYk5RwjsYMRCD1IZDOl79IjFU0Xgb3DLOhic
2NFfmw/SHm4JGy2mvlPa8hOQnepAAtyTswODnthlfPgig/b19amnY0inGgKYZ7///vtZvxdW4xtb
IYE2I1D8bK/NAHVUd/BIJx7lwM8AOqrXdejsxo0bjeXZOnhFH0igLQlwtteWYc3WKfzabM2aNaiD
m3xYE5PHlHiQAAmQQFsSYNpry7CyUyRAAiRAAm4CXOTkyCABEiABEuggAkx7HRRsdpUESIAESCBX
2osWOomTd8kTrWhXVaO6wo7TE9VE/rby9FSvm8mTTIWL8jCnncCB1MSu5STD6iRAAkkEcqW9aKx5
5F1aJY+iK+xEd5wViyVQhv5OsR7SGgmQQN0ItCbt5aHQKnmUlijs5AHVUXVbNSo6CjI7SwLtQSCX
8JBT6MTQXsF/bQ0Xv0KNRwcnk+gM7DzwwANQJoKuCrbwEDEjhC2rTg2qJCnsyEuitqNUh5xiRkna
Pc5hZGgJoQlV3cDrl6cxPEktPGXKFPyATNdygnup6k6qC85YO4Hbwje61FE1Ykzt8QZmL0iABLIS
yDvbszVuDO0Vp4aL7mUmHRxbe8gjOoMfXyPjGno6WXVqxNX8sixJ2j12wJxaQqq6gTdEnkY1kVrY
jmaIupOyn6TX44mRc7xWL8aU9W3D8iRAAs0lkDft2Ro3hvaKU8NF5xWhg6Oq+0VVnHo6WXVqigqt
R7vHEGByKuOo6gbeTPI0qYXtaGZSd0rS6xGzTmEgJ97qxZiKijLtkAAJ1J9A3rRn99DWXnFquNQT
TapwTCFuG+ozhgCTXxnH8DCTPE2mwqqn4Vo5qAI9YdHrwUk0q8aJMUX3lBVJgASqJ1B82rO1V2wN
F38/U3VwAkVnnHacOizKH6dwjO1tkm5LSPxS9Wv8BZx4ISIBrQC0DtTYVh9/kzwJ1LJR1VO9NRrC
bU6ZIOJEXsokfKOsVSDGhDud27dvDwkZy5AACbQTgeLTnq29Ymu4+An6dXAM2R2P6IzTjlOHRfnj
FMdxpj1btyVwWKTq1/i1hGwPQ+RplG+ZCqNWqrdGryXWSHVKrydc+EaZqoMYU2A0WYwESKBxBGq9
Jyd1cBo3nuAwnvzEzTzuZ93E2NFnEugEAsXP9gqkRh2cAmFWYwp72ezevZs5rxrabIUESCCCQB1n
e9TBiQhkHargkVTc9Tz33HPx7Ewd/KEPJEACJGATqGPaY5xIgARIgARIoCQCtV7kLKnPNEsCJEAC
JNCxBJj2Ojb07DgJkAAJdCKBXGlPbS+CJ879P7LW0ZahAhMoQFNlhAt0qSaaR2UETiKS07LOJ5VV
lWOAbZEACdSQQK60h/7IFh6zZ89G5sMnTlIPy1AL0m3mUTIqKSoFulRbzaPwsIaXjAiHzicrq1Id
i+gLq5AACZRNIG/aE/+gD4C/u3btSnK3DF2YMmyWjTvOfm01j8JDEF4yApHOJyurUh2L6AurkAAJ
lE0g15OcWJvCbA+7JG/evBn7Yy1cuFD25sC2/dieavLkyeeddx62JxbVHjkwNcR/sdXIjh078ImD
HT1mzpxpdNKojlf1KqgLy7ZN8cRu3aiuWoS6zdq1a/EqDOoOwDI2+sJ+0HIdswHdT/yC/n/+539w
Bc2hy9Ko4iBtGRf9BlXT6mcbBhNPT51tKQ7KMvqycuVK/Levrw/7Qev+GI1iYRa7lwGvdGT+/Pn4
QiOKEJi86t2UAnpYneSlgFHS7qmyjLZQXnYmM8jrMdJf0o3rZUQ0wzai04DUg9EFYyg29L9nz3mk
oZ7T7VYRWHPrtFY1XX27eWd7+OjH5w7+Yj8qpAT57DOEZmzVHlvgRvU8SRgIuxsjQeKDG6up/f39
SUpASdVteSNd3cbg7hEJcooZpYYtRHXIUBQyPo5lMTm1IbtAeTJG4SJQRsmknuLLk8p5TsEj6Z3x
km7cdmn48OG4CP0pufds0MivJxUREVYhARJoLYG8aU9tz3/wwQcvXrwYCcmv7CO9tQVuFIWk6jKT
E/EafIolUUuqbssb6eo2hjWPSJBTzCg1hB6Dqq6hKJRqM7BAeTJGhgMhcZcqzp4i5+GQeR4Op+BR
6ku2S7CDr2XYvxurC5L2MBLUfqGBDFmMBEignQjsU1RnUhNSUQ3BzrBhw/Jbw5wDH4JI1QsWLPBs
pmWvGeZsOskgFIUmTJhw6aWXLlq0KGcTenXMcmbMmJFk0GhUVybCTAizdlTHxivF7rri7On++++P
pVTdTw/58KAYJf00CsReE1MdtXJVE+bNcqMz18PzzvZUjGWFCnoISco+Si3IPyySquMjGBVxQw5/
x44dK0Zsm35dIaNpXd3G6ZUtu+MUMwrXIfLo+JSkeVSqjJEeglTyKljOniLlIz3jtp8EwuN2uBaS
XdJZVzlGKaJmfWTTWxKII5A37cm9PfndFZ6AwLTJKTSjqwX5HU0SBhozZgw+lfAQyrx582Ty4bTp
1xXSmzbUbZxe2bI7ImaE/uozTqS9QB0ij45PSZpHpcoYhYtA6SWTeoqlYMz55KkWD6hwLSS7pE0j
fGTGvcFYiwRIoG4Ecj3JWVlnjGcIK2vX31A9vaoJHLrRQgJq5YqLnC2MQiOa7syhkne214jQ0kkS
IAESIAESEAJMexwJJEACJEACHUSgGYucHRQQdpUEchPozJWr3Ng60UBnDhXO9jpxrLPPJEACJNCx
BJj2Ojb07DgJkICXwPr7fvaPT+wkpLYjwLTXdiFlh0ggkMALT/z2gv/8mfwr4vN95y9/+7N/3RbY
OItFECDhCGh2Faa9QjDSCAk0jQCmMl/Z0rv8b77024F/F5655Xe/fKNpfaC/JBBDgI+0xFBjHRKo
M4GA5xS2/e6Ce7u+9TdnnGr0A9c39FzR89j1W7q6es/87YyJXW888Y+rHntWismVwQMzxa9s6Jer
A3b0Yl09V1x4wRfGdCXVHWoTVe7tWjC1/yv3orFB4yfsHGqr+8TlF0w5zNkQLg601f+lmV3flYr+
wl1dSPDfHSwoxzkzv/TP6ERqv7pPBId13Rf+25TuDysbPqumA7klVR/qlMVZN9vdc+TO/qFADBCe
unXVui7py1D1LWcK9gxHwFDJYK0xRffwIAESaC8CZ336YfmX2K2tG34z+94tjpe3rJv9H/+uvbRl
yX/8+5Khgq///Df//g8bXh+otWXd0Mke7eLg+d7CA4XcdVWr/Rv+QbUl5/+x7v6BV9MaksK/2bB1
0JUPW3F6hR4NldTdS/BtwPJvft4/6OIgir3d3Ov0R5oeMDjEyuA2WEznNlQsqXoSKzMcHyF8/70f
RmogoEPdzDSW04dKJnMNKcxFzsZ8QaGjJFAYgRd29ifb6v3Wh1O6Dau7T/zi0ASv+wtTe5/dsu0F
1Jx4xt45UPdpvT3P7nQsj77wRELdjzS8t60xE8/sxjxMZp/dE3u6hmwmNtT7raHp4MQZvV3P7xx8
8MRV+AW81NM9OHEcMCslk3x7YeuWZ3unDk2YJp7xrV4nJNX0AJCu/p0DQAYOjduAnTOH5mFdVrEh
zz+87mX1oVnDm1Mn9XZt2bJ+4OrOB7b0nzN1aH5c2ChpW0NMe20bWnaMBIogsPOxr+x97OUCWVQc
/JzF0yvyLMzepU5XW+66mbwKayjZq8O6u/dmpm33bek6HP8d6oGjX95vAwlu7+zfm/Y+LGDaGVyf
tIsNgtx7PYLVxBOu6N5yH54hemPbup29e7+rZMLbmYWZ9joz7ux1ZxPQJgppIHDLbeixl8GHXwZn
KuvvW3V9z9D15VN7Ek246qa195HXQxsarOQsPDDbG8oo61Z/OAMbvJVo9euw7uS+JPnd3SP3IPXD
tIN7cq5iA1XU9RhWA1Pt1Vu3DU5Se83btJlAd1Zhpr3Oijd7SwKDBAYnCt/97RN7pyCYVP3WfpLz
sEm9R27Z4H3Cc9vPhx5sGQI7tN7Y1RVQN1MszIa8lT8sjIkXnmEZynB7J0RJvg1MDff2F8/s6A/C
aM0pbjt/uWHLkb0THWlvgNu6vb/lMIo5qmdipQjDpcGK6zDhPmfS0Ep0JqadWphPcnZq5Nnv9iUQ
+HgeUt2q6/f+GvvIqYOPLNpPeH7kEc2uoWJd2/71P9etHiDYc8XU7ut39soTnnsf73Q9ydml6u4F
Lw9kDj1NOuDM1qlDzyUOPHvZJU+Nuhr6SMWBBzV/NvS8pdMrdXGg3b3+f/RJTu36h0+o9p65vHvD
4i51F3PQbeMhUvVoq81t4MrQmvBHG9WeQdWejP3Ik6XKH8usSXhgtRlBHHyYNmZABw6VGNM1rsO0
V+Pg0DUSiCLQmZ9lTlQDWWFdr/oRAlLghkmZn/LXLH8042aOTs7qrva0rwiZ3enq6syhwkXOiKHC
KiRAAs0g8MbWndpjLG/sfL4Zbod7OfCcDlc4w3kNlmTaywiMxUmABJpDYOI/X3ji8/cOPXR6waqI
H3TXu6/btqzu4jOcWWPERc6sxFieBOpOoDNXruoelVr615lDhbO9Wg5GOkUCJEACJFAOAaa9crjS
KgmQAAmQQC0JMO3VMix0igRIgARIoBwCTHvlcKVVEiABEiCBWhJg2qtlWOgUCZDA4G/VlW6tft5a
NoV7UrjB1vKpf+tMe/WPET0kgYoIhIt3D3xS7xVkD69VUTe0ZgzfdLerd4Yt1oQA015NAkE3SKBJ
BCb+89986SP6q81wvqFuNwNuc7zk7/aaEyt6SgJhBIJ+jBUkjz7UnrZ755Ce+MBGlwPS3t2a9nqg
qLqtzI5W3Frne1sZ2O9TPw/QRof63YU9P1O68EO+BRhJlm7fCz/ViF1g78/k07sZFuHCSgUNlcJa
q4shzvbqEgn6QQIVEtj2O2yyPKhLcCGkGH72xM6uMVP+beAcWq+4eMGQ1OqgRy888TslMyTCQx8e
jlrb/nXVY4cPiR5ceEX/ur1roSpr/O4rG7quuHBQFWFm10DTg8lAr3LBgIic50hoYttHLW+dmNSj
AdO+Rrd8d0PP8gE4Z56z87Gf+3xxejKgfAs9IOnAgCpQd+9pYwYzt59MhfHv7KaY9jo7/ux9hxII
kEf/CJkhFe90Wqmi6uu3bunSFMyxUjooF5ekRe5oMakJ27LHXW+jLul2l60kTwzdcxEnSiWTDpcl
iiHAtFcMR1ohgWYRyKBaftiUC5ZP3fndAS11hyafo9tpQuFHdg/MfdSRQYtc1UlowrDsS3s7+z/y
qkcA3R9YpycTe8/p+lD3/EtQdJIjjUyzxlBjvWXaa2zo6DgJRBPIpFqOVpD5Btcku69f9bv1qa2m
CYU/u/MN3UYGLXJVLaEJw7LH05hGnebcnkz84lSX7nkamVS0LFAEAaa9IijSBgk0lkCiPLqjR5gS
JfQzXFR9cAFwr2L7tt/hzp9IhCdokTvaS9Iity1LZV2OXJnL2qiz3x5VdHlp8ZYPdc8zSag3djg1
wnGmvUaEiU6SQKEETp1x5jlb1l0wsG65YdLU3r22u0/r7Xl2wypjMRNCpoMlf3bBwBMZtor3R2vh
IZcLe9et2lvlw5/37W1k4hnLp3ZdLwU29CzAAiCqzOxdPSQPpKvCJvQ5qQnbcpe7RwN2szbq9MXT
2TETz+zuf3anpgqUSqbQENNYMgH+gIGjgwTajUBnPpXeblGspD+dOVQ426tkcLEREiABEiCBehBg
2qtHHOgFCZAACZBAJQSY9irBzEZIgARIgATqQYBprx5xoBckQAIkQAKVEGDaqwQzGyEBEiABEqgH
Aaa9esSBXpAACZAACVRCgGmvEsxshARIgARIoB4EmPbqEQd6QQIkQAIkUAkB/ly9EsxshAQqJKB+
g1xhm2yq2QTW3Dqt2R3I4j1ne1losSwJkAAJkEDDCTDtNTyAdJ8ESIAESCALAS5yZqHFsiRAAiRA
Ag0nwNlewwNI90mABEiABLIQYNrLQotlSYAESIAEGk6Aaa/hAaT7JEACJEACWQgw7WWhxbIkQAIk
QAINJ8C01/AA0n0SIAESIIEsBJj2stBiWRIgARIggYYTYNpreADpPgmQAAmQQBYCTHtZaLEsCZAA
CZBAwwkw7TU8gHSfBEiABEggCwGmvSy0WJYESIAESKDhBJj2Gh5Auk8CJEACJJCFANNeFlosSwIk
QAIk0HACTHsNDyDdJwESIAESyEKAaS8LLZYlARIgARJoOAGmvYYHkO6TAAmQAAlkIcC0l4UWy5IA
CZAACTScANNewwNI90mABEiABLIQYNrLQotlSYAESIAEGk6Aaa/hAaT7JEACJEACWQgw7WWhxbIk
QAIkQAINJ8C01/AA0n0SIAESIIEsBJj2stBiWRIgARIggYYTYNpreADpPgmQAAmQQBYCTHtZaLEs
CZAACZBAwwkw7TU8gHSfBEiABEggCwGmvSy0WJYESIAESKDhBJj2Gh5Auk8CJEACJJCFANNeFlos
SwIkQAIk0HACTHsNDyDdJwESIAESyEIgV9p75513HnrooW8OHk899VSWdt1lYWfz5s3Ga86L+dui
BRIgARIggQ4kkCvt3X777e++++73B4+RI0eG4Lv33nvtxBZSkWVIgARIgARIID+BXGnvwQcfnDBh
gjgxadKkEG9uvfXWkGIsQwIkQAIkQAJlEPj4woULo+0eeuih69evHz9+/OjRo5URLHsuW7bspZde
UtexSnnggQfecccdK1euRLFHHnnk7rvvPvfcc3FlxYoVOB8+fHhvby9ewvmUKVM2btx43XXXwThq
ycVp06aNHTsW55gs4iVV/uabbx43blzgRDO6m6xIAiRAAiTQNgRyzfYmT548Y8aMO++8Ewnsrbfe
AhTkPCQ8rHnOmjVr6dKlchHHq6++evnll+M6zq+88ko5Of/883Fy1VVXYQr48ssvS8lt27bNnDmz
r6/vxhtv7O/v10HDOBIeqrz22muF3EpsmyiyIyRAAiRAAoEEcqU9tHHUUUchn/X09Nx00014wuXX
v/71CSecgOuy5olsJ36gmO0QkiJmb6iIl3bt2qWXlOpIb3otGMeBuSMWV3fs2IGXLr74YpkR8iAB
EiABEiCBEAJ50560cfLJJ2P69eKLL4Y0qcrcddddmL1deumlSbWGDRtmvCQzRRyYEWZqi4VJgARI
gARIAAQ+tmfPnmgQSHVHHHHEfvvthyVKLGnOnz//ueeewyInJmFbt2699tprceMQr2J+hnQlEz6c
Y3aI1VF1fsghhyxevFgK4NU5c+YgpUl1rH+OGjVKVZcV1E9/+tOwKT7j3h5WWTnhi44gK5IACdSB
AG7u1MGN+vgwceLE8pzJlfbwU4THH38cS46nnHIK1jYlsWHdEvfqcAUHUpqkN5X2UAWPsSDtIfkh
a+IGHl7CFZX25s6di9z5xhtvnHfeeUZ1LIo++uijMI7q8irTXnkjg5ZJgAQqI4C0d9hhh1XWXJUN
3fzb27M291cnTqlv2svaGZYnARIgARKwCbR32vvsnE+FB/2WW/+77LRXzL298C6xJAmQAAmQQKcR
wAOPIUc1WJj2quHMVkiABEiABGpBgGmvFmGgEyRAAiRAAtUQYNqrhjNbIQESaEMC2HPj97//vd2x
pOttiKCBXWLaa2DQ6DIJkEAwgbfffhuPfyMP4cBmisH1Bgr+6le/cma1TEYiCv/T4PHmm2/qdXHl
6aefjrDGKgaB+LSHHyrgUOYee+wxbFHWEr74GYPa2yzCARFOkiNT9TrIJOXsu+pv9epOZbTYCJtl
OJlp3HZa4Z/+9Kd//OMfscETPqC6u7szdf/HP/5xpvIFFj7++ONvu+22Ag3SlCIQn/bwQz18h8LD
OWIL20zLtmTVHLqAEX4dL7/wiz7U5i/RFqqsWFTfayICFedGXK0qw6S31QhvG+FkRARXrVp17LHH
yob1slGGHJjGffvb38YUEFttvPDCC3JRZoSY5MnsEFe+8Y1vyAkOvCRVUED3BNdxES89++yztofq
VbWT8PXXX5+6q/BZZ52FzTqeeOIJZ5cx7fvJT36C+d8vfvELJPUILK2qgj2c7aNiZ+LTHvbhxI4q
mzZtgseYbGE85cw9mXreyQJGRfW9KDuZAmcXjnMjrlZOV6OrN8LbRjgZEYLvfOc7SEhGmkHOQz77
2te+hing1KlT//7v/x5roWIcHEQfRpavfvCDH6h1LOwPBWsQgcEsUBlct27dkUceiTLnnHPOV7/6
VWMDfTQEg0hOl1122de//nX1KvZlTO3L2Wef/cADD7z++utGSeS8H/3oR5///Od/+MMffvKTn/ze
9763e/fuVGs1KYCdRgxP7Ctluxqf9uAZpneY5GHCh99aYpMw5Su+NmIlRy2BYqcx7MaCI7AzGECy
5GgsospFWJPVSOztIieyaoRa2L1MmsCJGqmGM1gV3L59u98TGMSYNio6vXrvvfekmPO7WyAHm49o
1oOYWrzFf7GMjCvOvgsE22eERtwGH2NtzbADC6ovOnajC4qb8keu+HuqN53qhhi0mehN2M4rx+yI
2IHzG4cpcJPmkiSRnQGy+YtX+VEry2qYGfz9/uiD04iUc1wlvZUC3791K3bqqacidf3Xf/0XZnVq
YoRchakSxNHg7fTp02XIiefIXvhO7+zFSSedhOtIcvgLhW0pg6wpdiA7g7/PP/+8XhcNiUGZaMqr
V1xxhRjxH/vvvz9SAuZGRjGk0i9+8YsHHHAArotZtel/mslavK7nuepzHhDkSnsy4duwYQPWzSGP
J0RteSDsromBhd3IApHbgkT4xMeOZdjhE5tQQ5zBEDASs8jBcEPOlRBEoFaRZFD5eJIDs1hsDYpd
RpUoUn6ZpCQOxvVM4k06UttnhAbSFsA1YsQIA77NUKovWLBAddlPT8SkckbcGUrYtJnomlNJtVDR
Fq6yA+c3DiPgBvUPJzfpr1Ndy+YvzPOjdqpx6fyd/ti1nAG1RcGcb6XAN289iyFdYZaGidHf/u3f
ynwLK59KIlvWP1UaS8p5mA6uXbtW1j/1biaVlzJoCLMxtWSalc/hhx+ObbqMpc77778fOqNiCqkR
f/FtL6vl1paXbNeSnId2c6U91Jd3yCWXXKK2h7blgTBVxzvQmPujrmQaPdlIJGxBIqQ9NKSacAYM
S6z44oPpkb7iGqhVZN/bk/uUssm1iCLll0lK4mBczyTepKOwfVamQtafpbq8h6XLNj29OSUmFR7x
8HeazcTQnEoyJV7pwlV24FKN+7klBcjmn+RkHGpDjUvn71H70ms5A2qLgjnfSuGxq21JfEeHbzLf
whTQ+ERKXXXEozGoe+aZZxrP7qnnG2SZ1LCDhpBxZckUh8wXMx2nnXYaljr1G3h42kVJmYqpfffd
N5PNOhRuVc5D3/OmPfmUVF89hKYhD4RvOgcddBBkFoxxJhJC8l1YP2xBotTbv1L9xBNPRH41VlyL
0irKL5OUxCHpeh2GZiC9wIiH98hmEuiJ3oQIV9mBK8R4eF8CSwZ20FbjCrGvagW2guUZeSvJAmCj
DzxRIglJnjcZM2YM/n7uc5/DJExyCeZwSE760y56fzGTlv9i3obFTBzGcyuYQ8sn2z333AM78j1D
HVjhxPKJ8dGHR1qcD78kcf7sZz97yy23qFfxtAvud8g9v0ceeQRZEJPCRseoYufzpj3bXcz8IMug
vgFJASQk/DVkY5O6CkmH0aNH6xacNu15/THHHCPfZ9WKq10x5N6e0zHbKxSTt4TcFRg7dqxeMRMH
nY9UVGZVX3TjgWsamNbopux++e04uxARcWhxCKik35k43bCZGIPKWcuOiDNwfuN+biEBKha1Z5ih
oSR/7FqpAVVIISgmbyWcVPyRVEZz+M6N7zrIW7jJJzfVZNlz2bJluI45HG5nONtFeTw2gidi8Cqe
ZJEnOY2SUBvFVyvY+cMf/oBnZGTJVB244YdcCFVRFEC2i+sdci3mfKru0Ucfja8vWG7F7clXXnkF
qjVxZju2VvFp77jjjsPkb9GiReqJDHkQAysMTo11Gz3uGKGKniMxsLAQD5uwIx+diLr9mAxWQdEK
BoFaDrWdcUbavrcX4hXK4Jsj8ii+Lc6bNw9PG+u1wjkYfNBZAERP8T0OZu2lXWffnf06/fTTcR32
nVOEVDuB9FJ7irSHW7NJzzQ53TCY2E0kOW9HxB5Oqcb93FIDZMciJ2rPMENbSf7YtfwB1Z2Ut5J+
86K5H5FqmRHvJn2NUV3HAybq/pyxDonyuIIEie4jX+IEhzy3KaZwAjt4qBInsC/Ptsh11RZIygon
GpJXUx9pQa5FbtOZT5kyRb+I/375y1/GFRjHJKG50WmJ57n09lriMRuNIIB5Er409PX1GSswEaZY
pWIC+AKk5CrDm46rpdvHM5+4Zeh/XiPcH5b0E2h74SFjqSaJBr5vUXiIb5ZiCODRRNy6UF9FizFK
K+1LAGsq+CkYc177RrjqniGfhRzVuMXZXjWcW9MK1lXWrFmDtnGzCkth/BRrTRjytRo3b4urJZ6i
Ltal8ZNtY90+Xz9Y20egvWd7WWNftsws017WiLA8CZAACRRMAGmvYIsNN4dfK5bXA6a98tjSMgmQ
AAmQQO0IFP8kZ+26SIdIgARIgARIYC+BXGnPs2mhThi3x9VmkkWRD2y6qObkhkfSDo3RrRQlGxTt
gL+ip8v21ppZ4ZQxKgrkEBLuuC6EWC6wI+GmautYeBdYkgRCCORKeyENoAy2UoXwh70bS2B1Vawm
wihxbjhr5ZRMivMkK/aSyhc1KkpyL8RsG3TB2c24cRVXK4Qzy5BAsQSqSHvYWszYvSyuDzURRolz
I66WH1QZNuNCE1GrqFER0XRRVdqgC04UceMqrlZRsaAdEggn8HHIGoSXNkrefffd2Cxg48aN2LYH
e2jJxs048L0PV7Ala29vr+w0jQ1HUBiPROMcW9hhTyDsnISfkcn+AiiDunjaXraM0qurFg07etPS
kN207q2/Cewuhi3vsOG1OIDC2JNJNhtT52hx2rRpS5YsMbojrRgWUiFILWXcrq4KJJExgDh91nuN
c8RIguUhhl+VYt9blAEBRA1dNjZdE8eEhnpJ/dfPISmaIaNC1dWHBxLPfffdh7UEAQ4xgSeffBJ7
7sAf1Uchg+sySrFjPT6gb7jhBr2AIqOGsd7BkAEZ3gVlGQPedlWFG4FYvXo1CsB5jDo1IJ3OpL6J
Kh7hSeNZf0vynARaRSDvbC9V3MRQXfGr6shnhy4xo7jkV2+pp1COdNCjzZTktkd8Rx9Mqjou2so4
Nm2/5k7qME3V9BELWUeFatdwGL/Bf+ONN/AhCw1F7H+G3yY69aFw31FkpHCPGaItWFvW9ZVg3Kns
I40GDsjUgW2jc7qq4uUUjWqKFFRWrbHUccUCJFAggbxpz9Z58avVpKrq+KvrPY9Tb4GFWgnlSI+S
NInwkkffJ2Qc6PugOpWJDEGfTFpFtgOpmj5On1NHhaplx2727NnYExVzPpygmEcfSlYjBIiur6Qu
Gso+0mjggAzvguqLx1VpV+Kli0Y1RQrKM55DBi3LkECpBPKmPd25rOImSR0L1EZxVg+sWzehnEDt
ocDeZRoxcTYxzTIEEETJtgJNH8NhGXWY80mvU/WhUuHY23bHIUptKM7VQGdaO8IDx3MqIhYggTII
5E17WcVNUkVb/Noo7SeUo4Kaqs3kV19KFfdxjh7bplNzx1ZrgrdYMhWbWGNEFlSTklTBINuT1FGh
qtgOY6oHbRcct912G4o5ZYZS3zlZBaTydEHV9bvqDESqcpAYTxW9Sh0t+aWgUsdzalBYgARKIpA3
7WUVN0kVbfFoo+RUb1EEayWUI16FaDP5xXf84j5Jo8e26dfc0ZM0HrLA0yI48JgMRDudHQmULkod
FUmxw70uzDKxOInj4IMPxn9tmaGQd04mASmnwfAuqOp+V52BCOTZ8hEeMp5D4sIyJFAGAW5OVgZV
2mwSgTy7NlfQT4pGVQCZTXQUgbyzvY6Cxc6SQPUEKBpVPXO22N4EmPbaO77sXVMJ4Fd9sobc399/
0UUXQausqT2h3yRQMwJc5KxZQOgOCZAACZBAmQQ42yuTLm2TAAmQAAnUjADTXs0CQndIgARIgATK
JFBY2muiakl9fC7Ek0KMYLAVKIdUiEuFGCnjTVQgqDLco00SIAEngVxpL0JqJKJKIZFrSbstaTQc
V5J7OeWQwh2Qkk43aotOd6xiUFnBsjwJkEDxaS9CaiSiSiGRa0m7LWk0HFdN3HO6URPfbJi1dSw8
7ixJAh1OIF54KEQJyJBWsUWIFH2I/lxzzTXQZDn66KO7u7udmiy2bk6SmI6hbZTUbohwkj4+bDkV
j4jSypUrUVdXXDIkY/wSP4EE/EY8cku2bpGSvNE1jHSf4dJrr72GKKBf6DikfGRb5zz9coYmZGjZ
7apIGWFykvRLESUZTxJ7StU28njb4R9A7D4JtIDAnhwH1FueeeYZMYDzm266CSd/+tOfcP7iiy8q
w9gmWF3Rq6gCjz76KOru2rXL8MWoKPahzKJbsy+uX79eLj7//PMoCSPinnJVtYKLt99+uyoJz3GO
6jhwAiP4ZNddQnn9SlJDYtNo1DarqoOV0z1YSCXgN6I66OyXET7bbcNn8VN1TUJcSL+cofEPrfAw
icMGSemsjCU518et37jumJwrIxEGjTHP/5IACZRNINe9PSNL20pATmkVO7djqoe6+g9ynRVt3RyY
corpyEXRkcEnkefbRCbhJFtVx9mQrvWjmrYlY/wSP4EEUnWCwnWLbLcNn7HZNLacfnnwUHtPF9Kv
1K97mUSmjDBFSBEFig3pbgu9JG2jCIOpTFiABEggjkCRac/2IFBaBRrZRt3AinF9TqqVKpyUU04l
UDJG3CuDQCYHxA2jCrbVhyIrjhkzZiiMmcwW2K+kdo0wxbWYqVMh47BwgyGNsgwJkIBNIG/a8ysB
OaVV7Cq2TkqcfIx0L0nFxulqVuEkW1UHLeJmEv7KTS/jUI0GSvyo6oEEnPI0zoHu1y0KrHLMMcfI
xEV1tpB+OUOTR2RKD1MgSZ1AHvWrQJK2lhM/nkiABKohkCvtpSoB2dIqzioQbZkwYcKiRYvwaAAW
0NDzOPkYQeaUgElyNZNwkiGnkqo1ozeaVeInkECgThCw+HWLnKPNroKF6Dlz5sydO1etSOfvlzM0
qUPLI8FjhCmQpE4gj/pVIMlq3t5shQRIwCbAPTk5KkiABEiABDqIQK7ZXgdxYldJgARIgATaggDT
XluEkZ0gARIgARIII8C0F8aJpUiABEiABNqCANNeW4SRnSABEiABEggjwLQXxomlSIAESIAE2oJA
fNrDTow4FATstILNDwthUqXQDNpSRybnnU6W6nmgzI3Th8C6mQjEFa6eW6qfcXBKjbXTZ6ef1buR
ypMFSKDmBOLTHvaLwm702ApZeoidl2UHqVKPCD2a1Cpq+4xSPc9vXMncpPbIbqtKiZwI90LgFGu2
VP2gYl1VcPIMgCTCJbkaElCWIYFWEYhPez09Pfjl8qZNm+C6vkljqT2JkH2JqFJqF/Ibr3mPSnKv
WLPFWjNiWqpxtFWg/QJN5R/YtEAC1RCIFx6Cf1AIWr58+RlnnIF96LFt1dixY8VpQ4nG1uvx9w16
QNOmTYO1VN0ioyFbh8hQisEy0bhx40aOHKkcUG2pK04xI1u8xilapFsLhKDDgXsffPCBbGcMN7DD
FlzF6jEEAY499lhRt1myZAle1fWMDM0m3bHhw4f39vaKNdQFUmfvMGVfvXr1ihUrxL6UVEDyyC3l
5yZu2PpEtuSTcthuFC/plK6++mqdocB5+OGHQ2SV7JETMUqVxpPxRogYAM5ww6xTEktFNmksVfOh
w1ZIoMUEcko83HPPPfhQhvCKkg2yRVsMvZ7UFg0VniTdImdDTnEipRSDVyHIYGgJoTk5lKSObcQj
XiPyRiJapDwPh6DDgaqRLoQEPSbYxBVRO1LGdT62ZpNTAUqv65Fqckog5ZFbys9NBUvvtVPyyRhX
+rBxUjL0gwJllZz+2MJGyrhzJCiNJ8PniAHgDHeq9pZzLKW+MVmABNqDQPwip6Rr3M/DxsTYuldt
0mhrrBhCMPq8Sh4nScr8ft0ip5iLU5xI2cfdEZlL6Yd9b8824hGvEXkjTBR0m+EQdDgTJ05cs2YN
7GzcuBFIMUHBOa7gehIiW7NJgoK/WIXGX3wdMep6pJogLWQ3lEduKT83Z8eV3JJTW8pu1EnJsBwo
q2T7EzFKndJUsBwxAJzh9vNp8RdtNk8CrSaQN+3JZytWDp2JZObMmbiepNfz/b1HEoRUyZjKxFxS
PVGiRaovhm9JEPTro0aNOuWUUzZv3oxUh32usU02JJlwBdeTENmaTYWPqDxyS/m5RXTHbjSQUpys
Umofw0dpxACI4MMqJNDhBPKmPRufU7RFF4IJJ+7XLfKrw+itKAmbaLUXpye2aJFqNBMEHQ5ukeIe
GyQOYArnEBPAX5uYR88oHK8qmapeFC23VAg35afRa1x3Sj7ZjQaKLoXIKtl4ixqlYjnrAHCG26m9
he9PMmJF5MSmGjFyWIUEmkig+LRni7YYQjDhmPy6RR51GL2JVAkbpBn/WiusOcVrbNEi1W44BAOO
rGdChgl/5dxe4dR7ZGs2heNVJf3qRXnklvJzU04avcYCA6KGR3vmzZunFtilsN2oTck5KkJklWy8
0aMUTxKBrWEw6wBwhtspiYW099xzzxktpr47IoYTq5BAzQlQeKjmAarUPXwQQ/Wwr69P7pnxKJUA
pqrvv/9+0n2+UpumcRLoZALFz/Y6mWbT+75hw4bJkyePHz++6R1phP94cEmJ1DfCYTpJAu1BgLO9
9ohjrl7gl2fyBClu8mF9TB5T4kECJEACbUmAaa8tw8pOkQAJkAAJuAlwkZMjgwRIgARIoIMIMO11
ULDZVRIgARIggVxpL1r0JE7qJU+0ol1VjeLXTvIof5Ibqon8beXpqV43kyeZChflYU47gQOpiV3L
SYbVSYAEkgjkSnvRWPPo4LRKKuXOO+/EftDYWCa616xYOIEytHgKd5IGSYAEakWgNWkvD4JWSaVg
gytjD7Y8vWDdYgm0alQU2wtaIwESqIBALuEhp+iJocOC/9p6LtE6OJkEaPDj6wceeOC6666D3gq2
8xAxIzDNqlmDKka7yn95SfRclOqQU8xI15oxNInsMBtaQmhCVTfw+qVqDE9SC0+ZMgU/JgMxpVgE
31LVnZT/zlg7gTsBKjvViDFV8O5iEyRAAjUkkHe2B5lZ7DcNHRN83Za9/rBzMVYCr7rqKrkiEg3S
c7UxvA5CLMyfP19ZwI+moRsAIyNGjDCQyRqj7O0rn6fYZhDns2bNWrp0KfbC18vDDjKuYcdfxXBe
WTPajQgkBI+wi5X4jKQCg/DNuUUych42kVq4cCHKqN1SVHXDQ2zhuG3bNpiV3Sll00UUdu7kmVrY
jqbTWztkAsQZaz9wJ8lrr712+vTpgivVZ5QxouMEaHctIoisQgIk0AYE8qY9W+PG0GFx6rno4LLq
4Oh1/QIr6lVdTyerZk1RMVZ7UNmaRLIjqHpYxqmSo6obeDNJ1aQWtqOZSd0pSbtHzDpFgpx4qxdj
KirKtEMCJFB/AnnTnt1DW4fFqedSTzSpIjKFuG0o0RgCTH6VHMPDTFI1mQqrnobr5qAKZmmYfeLA
STSr+osxRXeNFUmABFpOoPi0Z+uw2Hou/m6n6uAECtA47Tg1WZQ/ThEZ29skDZeQcKbqJfkLOPGG
aBWJb4G6Nqojqd4aXcZtTpkg4kReyiSCo6xVIMYUrUIVEmWWIQESqC2B4tOercNi67n4cfh1cMIF
aJx2nJosyh+nUI4z7dkaLoExTtVL8msJ2R6GSNUo3zIVRq1Ub41eS6yR6pQYULgIjjJVBzGmwGiy
GAmQQOMI1HpPTurgNG48wWE8+YmbedzPuomxo88k0AkEip/tFUiNOjgFwqzGFJ7d3b17N3NeNbTZ
CgmQQASBOs72qIMTEcg6VMHDqLjree655+LZmTr4Qx9IgARIwCZQx7THOJEACZAACZBASQRqvchZ
Up9plgRIgARIoGMJMO11bOjZcRIgARLoRAK50p7aXgRPnPt/ZK2jLUMFJlCApsoIF+hSTTSPygic
RCSnZZ1PKqsqxwDbIgESqCGBXGkP/ZEtPGbPno3MJ3tyOo8y1IJ0m3mUjEqKSoEu1VbzKDys4SUj
wqHzycqqVMci+sIqJEACZRPIm/bEP+gD4C/2j05ytwxdmDJslo07zn5tNY/CQxBeMgKRzicrq1Id
i+gLq5AACZRNIK/wkKj5bN68Gco+n/nMZ/bZZx94bCj7GKo9TrkivZ+2MBAsHHrooaKJgxNkWY8S
kL+6ktTR1W301nWVH1w3ZHd0MaMlS5aI5JBTRkcXVwpRHTIUhZRLOTWPYKckGaNwESijpN1TJZAE
VyEfcfDBB9vk9RjpQdGNww6KYSjiBL+jcBrRaVx99dVG+bLfb7RPAiTQcgJ5Z3vYDRKfO/iL/aiQ
EiTnGWJAtmqPRwUmSacGuxtDn6ivrw+rqf39/UlKQEnVba0cXd3GCINHJMgpZpQaxRDVoZI0j8qT
MQoXgTJKJvUUX55AUnbj9MgzGS/pxm2XDI0ng0Z+PanU0LMACZBA3QjkTXtqe358Q1+8eDESkl/Z
R/pvC9woLknVRXlHxGugVJfEMam6LW+kq9sY1jwiQU4xo9SgegyquoaiUKrNwALlyRgZDoTEXao4
e4qch0NyHg6n4FHqS7ZLsIOvZdi/e8eOHXjVSSOQJIuRAAm0B4G8aU9RSE1IBfIaNmxYfmu6uo3H
WibZnRCvkgyWpHlUnoxRSGedZZw93X///V955RW9vId8eFCMkuHPG0f3jhVJgARqTqCwtCcrVOPG
jUtS9lFqQX4iSdVFN1w0xHE7TYzYNv26QkbTurqN0ytbdscpZhSuQ+TR8SlJ86hUGSM9BKnkVbCc
PZ0wYcKMGTNw208C4XE7XAvJLumsqxyjFFHNP63oHgkUQiBv2pN7e/K7q/nz52MPYqfQjK4W5Pc7
SRhozJgx+FRau3btvHnzZMtHp02/rpDetKFu4/TKlt0RMSP0V59xIu0F6hB5dHxK0jwqVcYoXARK
L5nUUywFY86HdUgQ9oAK10KyS9o0wkdmIe83GiEBEmg5gWbsyYk0g48ndYes5dTEgXp6VRM4dIME
SIAE6kkg72yvnr2iVyRAAiRAAiTgJMC0x4FBAiRAAiTQQQSascjZQQFhV0mABEiABMokwNlemXRp
mwRIgARIoGYEmPZqFhC6QwIkQAIkUCYBpr0y6dI2CZAACZBAzQgw7dUsIHSHBEiABEigTAJMe2XS
pW0SIAESIIGaEWDaq1lA6A4JkAAJkECZBP4/3SN87r1mCNQAAAAASUVORK5CYIJQSwECLQAUAAYA
CAAAACEANBL/eBQBAABQAgAAEwAAAAAAAAAAAAAAAAAAAAAAW0NvbnRlbnRfVHlwZXNdLnhtbFBL
AQItABQABgAIAAAAIQCtMD/xwQAAADIBAAALAAAAAAAAAAAAAAAAAEUBAABfcmVscy8ucmVsc1BL
AQItABQABgAIAAAAIQBGJUf9KAMAAFcIAAAfAAAAAAAAAAAAAAAAAC8CAABjbGlwYm9hcmQvZHJh
d2luZ3MvZHJhd2luZzEueG1sUEsBAi0AFAAGAAgAAAAhAFNSiWHSAAAAqwEAACoAAAAAAAAAAAAA
AAAAlAUAAGNsaXBib2FyZC9kcmF3aW5ncy9fcmVscy9kcmF3aW5nMS54bWwucmVsc1BLAQItABQA
BgAIAAAAIQDhUTcfzwYAAOYbAAAaAAAAAAAAAAAAAAAAAK4GAABjbGlwYm9hcmQvdGhlbWUvdGhl
bWUxLnhtbFBLAQItAAoAAAAAAAAAIQBiiyJkJmUAACZlAAAaAAAAAAAAAAAAAAAAALUNAABjbGlw
Ym9hcmQvbWVkaWEvaW1hZ2UxLnBuZ1BLBQYAAAAABgAGAK8BAAATcwAAAAA=
" o:spid="_x0000_i1025" style="height: 327pt; visibility: visible; width: 460.5pt;" type="#_x0000_t75">
<v:imagedata o:title="" src="file:///C:\Users\DEll\AppData\Local\Temp\msohtmlclip1\01\clip_image002.png">
<o:lock aspectratio="f" v:ext="edit">
</o:lock></v:imagedata></v:shape></span></div>
<div class="MsoNormal">
<span style="color: red;">I have created one site column of
type “Single line of text”. As per the new feature introduced from the
sharepoint 2013, automatically managed property will create for each site
column creation. So far everything is clear. Now my question is will change the
data type of managed property as changed at the site column level?<br />
</span>I have created a site column name: </div>
<div class="MsoNormal">
Column name: MyDateTimeCol</div>
<div class="MsoNormal">
Managed property Name: MyDateTimeColOWSDATE</div>
<div class="MsoNormal">
And changed the date time column type to “Choice”</div>
<div class="MsoNormal">
Column name: MyDateTimeCol</div>
<div class="MsoNormal">
Managed property name: MyDateTimeColOWSCHCS</div>
<div class="MsoNormal">
<b style="mso-bidi-font-weight: normal;">Note</b>: What I
observed is managed property will create for each field type change.</div>
<div class="MsoNormal">
Auto-generated managed property is by default non-refinable<span class="Apple-style-span" style="color: red;">.</span><strong style="color: red;"><span style="font-family: "Calibri","sans-serif"; font-weight: normal; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-font-weight: bold; mso-bidi-theme-font: minor-bidi; mso-hansi-theme-font: minor-latin;"><o:p></o:p></span></strong><br />
<span class="Apple-style-span" style="color: red;"><br /></span></div>
<div class="MsoNormal" style="color: red;">
<span style="color: red;">Limitations on automatically creation
of managed property for the site columns?</span><br />
<span class="Apple-style-span" style="background-color: yellow; color: black;">Limitation#1</span><span class="Apple-style-span" style="color: red;">:</span></div>
<div class="MsoNormal">
<span style="mso-bidi-font-weight: bold;">Managed properties
are automatically created for the site columns but drawback here is they
generated is always of “<b>text</b>” data type only.<o:p></o:p></span><br />
<span style="mso-bidi-font-weight: bold;"><br /></span></div>
<div class="MsoNormal">
<span style="mso-bidi-font-weight: bold;">Means by which data
type if we create the site column, the managed property should create with of
same type. But by default sharepoint generate the “<b>text</b>” data type.<o:p></o:p></span></div>
<div class="MsoNormal">
<b>Example</b><span style="mso-bidi-font-weight: bold;">: I
have created a site column of data type “Choice”. Managed property generated
for this choice column is of “<b>Text</b>” type. <o:p></o:p></span><br />
<span style="mso-bidi-font-weight: bold;"><br /></span></div>
<div class="MsoNormal">
<span style="mso-bidi-font-weight: bold;">We cannot change the
types of managed properties once generated.<o:p></o:p></span></div>
<div class="MsoNormal">
<span style="mso-bidi-font-weight: bold;">Example: I have
created a site column of data type “Choice”. Managed property generated for
this choice column is of “<b>Text</b>” type and then tries to change the type. <b>Not
possible</b>.<o:p></o:p></span></div>
<div class="MsoNormal">
<span style="mso-bidi-font-weight: bold;">I have created a
managed property of type “Text” at SSA level and try to change the type. Not
possible<span class="Apple-style-span" style="color: red;">.<o:p></o:p></span></span><br />
<span style="mso-bidi-font-weight: bold;"><span class="Apple-style-span" style="color: red;"><br /></span></span></div>
<div class="MsoNormal">
<span style="mso-bidi-font-weight: bold;"><span class="Apple-style-span" style="background-color: yellow;">Limitation#2</span><span class="Apple-style-span" style="color: red;">:<o:p></o:p></span></span></div>
<div class="MsoNormal">
<span style="mso-bidi-font-weight: bold;">We cannot set the
refinable.</span><br />
<span style="mso-bidi-font-weight: bold;"><br /></span></div>
<div class="MsoNormal">
<span style="color: red;">I have created one managed property
of type “Text”. As per the current requirement I want to change it “Choice”. Is
it possible to make changes for the existing one?<br />
</span><span style="color: black; mso-themecolor: text1;">Am sure it is not
possible with CA. Will confirm on through PowerShell script.</span><span style="color: red;"><o:p></o:p></span><br />
<span style="color: black; mso-themecolor: text1;"><br /></span>
<span style="color: black; mso-themecolor: text1;"></span><br />
<div class="MsoNormal">
<span style="color: black; mso-themecolor: text1;"><span style="color: red; mso-bidi-font-weight: bold;">How to
change the type of managed property once generated/created?<o:p></o:p></span></span></div>
<span style="color: black; mso-themecolor: text1;">
</span><br />
<div class="MsoNormal">
<span style="color: black; mso-themecolor: text1;"><span style="mso-bidi-font-weight: bold;">Through browser it
is not possible to change the type of the managed properties. Only way is
through PowerShell script.<o:p></o:p></span></span></div>
<span style="color: black; mso-themecolor: text1;">
</span>
<br />
<div class="MsoNormal">
<span style="color: black; mso-themecolor: text1;"><span style="mso-bidi-font-weight: bold;"><br /></span></span></div>
<span style="color: black; mso-themecolor: text1;">
</span>
<div class="MsoNormal">
<span style="color: black; mso-themecolor: text1;"><span style="color: red;">What are all the ways to create
crawled properties?<o:p></o:p></span></span></div>
<span style="color: black; mso-themecolor: text1;">
<div class="MsoNormal">
Crawled properties are added automatically by the crawl
components</div>
<div class="MsoNormal">
Cannot be added via CA or search admin pages</div>
<div class="MsoNormal">
Can be added via PowerShell script</div>
</span></div>
</div>
<div class="MsoNormal">
<span style="color: red;"><br /></span></div>
<div class="MsoNormal">
<span style="color: red;"><br /></span></div>
</div>
Anonymoushttp://www.blogger.com/profile/15414514889165889118noreply@blogger.com0tag:blogger.com,1999:blog-482466563826823203.post-75592065807806584672015-01-23T16:37:00.000-08:002015-01-23T16:40:10.917-08:00sharepoint interview questions with answers: ListVsLibrary<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="MsoNormal">
<span style="color: red; font-size: 11.5pt; line-height: 115%; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-hansi-font-family: Calibri;"><a href="http://sharepointquicksolutions.blogspot.in/2013/01/list-vs-library-sharepoint-interview.html"><<Previous post>></a></span><br />
<span style="color: red; font-size: 11.5pt; line-height: 115%; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-hansi-font-family: Calibri;"><br /></span>
<span style="color: red; font-size: 11.5pt; line-height: 115%; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-hansi-font-family: Calibri;">Move
documents between document libraries along with versions?<o:p></o:p></span></div>
<div class="MsoNormal">
You can only copy the documents to others along with major version
only.<o:p></o:p></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<b><span style="color: #c00000; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;">Exception</span></b>: <span style="color: red; font-size: 11.5pt; line-height: 115%; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-hansi-font-family: Calibri;">“The data
source control failed to execute the update command</span>”<o:p></o:p></div>
<div class="MsoNormal">
<span style="font-size: 11.5pt; line-height: 115%;">Got
the above exception while trying to attach the file to the list item in MOSS2007</span><span style="color: red; font-size: 11.5pt; line-height: 115%; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-hansi-font-family: Calibri;"><o:p></o:p></span></div>
<div class="MsoNormal">
<span style="font-size: 11.5pt; line-height: 115%;">The
reason for the exception is attaching file name exceeded the limit (max size
limit for single file is 128 characters).</span><o:p></o:p></div>
<div class="MsoNormal">
<span style="font-size: 11.5pt; line-height: 115%;"><br /></span></div>
<div class="MsoNormal">
<b><span style="color: #c00000; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;">Exception:</span></b><span style="color: red; font-size: 11.5pt; line-height: 115%; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-hansi-font-family: Calibri;"> “The
specified file or folder name is too long. The URL path for all files and
folders must be 260 characters or less (and no more than 128 characters for any
single file or folder name in the URL). Please type a shorter file or folder
name”<o:p></o:p></span></div>
<div class="MsoNormal">
By default, SharePoint limitation for Size of URL is 260
characters.<o:p></o:p></div>
<div class="MsoNormal">
Microsoft recommended size limit for single file name is 128
characters and URL limit is 260 characters. <o:p></o:p></div>
<div class="MsoNormal">
I have uploaded one document to the document library and when I
open it through browser the size of the URL is 258 characters(max limit 260)
and later on I have changed the web application “<a href="https://webmail.bpglobal.com/OWA/redir.aspx?C=4Z5hUvWmCUC6e5Nk7OAZ_JskoAhJBNII53EEJBu8u-aemjpoV554E8roUWKU5-X9310S133Fmtc.&URL=http%3a%2f%2fIndia.com" target="_blank"><span style="color: windowtext; text-decoration: none; text-underline: none;">http://India.com</span></a>” to<a href="https://webmail.bpglobal.com/OWA/redir.aspx?C=4Z5hUvWmCUC6e5Nk7OAZ_JskoAhJBNII53EEJBu8u-aemjpoV554E8roUWKU5-X9310S133Fmtc.&URL=http%3a%2f%2fallindia.test.IND.com" target="_blank"><span style="color: windowtext; text-decoration: none; text-underline: none;">http://allindia.test.IND.com</span></a> and now my the document size
of the URL is 263 characters(means exceeded the limit).<o:p></o:p></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
</div>
<div class="MsoNormal">
<u><span style="background: yellow; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin; mso-highlight: yellow;">As per my understanding</span></u>: you
can’t edit/download the document but we can view the document through browser.<o:p></o:p></div>
<div class="MsoNormal">
<o:p></o:p></div>
</div>
Anonymoushttp://www.blogger.com/profile/15414514889165889118noreply@blogger.com0tag:blogger.com,1999:blog-482466563826823203.post-85386230000342906652015-01-15T00:57:00.002-08:002015-01-15T00:57:56.136-08:00Copy/Move items from one list to another list in sharepoint<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="MsoNormal">
<b><span style="color: #c00000;">Scenario</span></b>:</div>
<div class="MsoNormal">
<u>List AA fields</u>: Name, Title, User Name, Religion,
Qualification.</div>
<div class="MsoNormal">
<u>List BB fields</u>: Name, Title, User Name,
Qualification, Designation, Salary and Description</div>
<div class="MsoNormal">
<u>Common field names</u>: Name, Title, user name,
Qualification</div>
<div class="MsoNormal">
Now, I want to copy the common field values from List AA to
List BB.</div>
<div class="MsoNormal">
<b><span style="color: #c00000;"><br /></span></b>
<b><span style="color: #c00000;">Approach: </span></b></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="color: #00b050; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;">//Read the list item
values by ID and add the common field values as new item into the another list<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="background: white; color: #2b91af; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin; mso-highlight: white;">SPListItem</span><span style="background: white;"> spLstItemsAA = listNameAA.GetItemById(ItemID);</span>
<span style="color: #00b050; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;">//ItemID of List AA<o:p></o:p></span></div>
<div class="MsoNormal" style="background: white; margin-bottom: 0.0001pt; text-align: justify;">
<span style="border: none windowtext 1.0pt; color: #2b91af; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin; mso-border-alt: none windowtext 0cm; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: EN-IN; padding: 0cm;">SPListItem</span> <span style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial;">spLstItemBB </span><span style="border: 1pt none windowtext; padding: 0cm;">=
list.Items.Add();<o:p></o:p></span></div>
<div class="MsoNormal" style="background: white; margin-bottom: 0.0001pt; text-align: justify;">
<span style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; color: blue;">foreach</span><span style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial;"> (</span><span style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; color: #2b91af;">SPListItem</span><span style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial;"> spLstItemAA </span><span style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; color: blue;">in</span><span style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial;"> spLstItemsAA.ListItems)</span><span style="border: 1pt none windowtext; padding: 0cm;"><o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="background: white;">{<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="background: white;"> </span><span style="background: white; color: blue; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin; mso-highlight: white;">for</span><span style="background: white;"> (</span><span style="background: white; color: blue; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin; mso-highlight: white;">int</span><span style="background: white;"> i = 0; i < spLstItemAA.Fields.Count;
i++)<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="background: white;"> {<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="background: white;"> </span><span style="background: white; color: blue; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin; mso-highlight: white;">if</span><span style="background: white;"> ((!spLstItemBB.Fields[i].Hidden) && (!spLstItemBB.Fields[i].ReadOnlyField)
&& <o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="background: white;"> !(customfields.Contains(item.Fields[i].Title)))<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="background: white;"> {<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="background: white;"> spLstItemBB
[item.Fields[i].Title] = spLstItemAA [item.Fields[i].Title];<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="background: white;"> }<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="background: white;"> }<o:p></o:p></span></div>
<div class="MsoNormal">
<span style="background: white;"> }</span><br />
<span style="border: 1pt none windowtext; padding: 0cm;"> </span><span style="background: white;">spLstItemBB </span><span style="border: 1pt none windowtext; padding: 0cm;">[</span><span style="border: none windowtext 1.0pt; color: #a31515; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin; mso-border-alt: none windowtext 0cm; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: EN-IN; padding: 0cm;">"Salary"</span><span style="border: 1pt none windowtext; padding: 0cm;">] =</span> <span style="border: none windowtext 1.0pt; color: #a31515; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin; mso-border-alt: none windowtext 0cm; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: EN-IN; padding: 0cm;">"50k"</span><span style="border: 1pt none windowtext; padding: 0cm;">;<br />
</span><span style="background: white;">spLstItemBB </span><span style="border: 1pt none windowtext; padding: 0cm;">[</span><span style="border: none windowtext 1.0pt; color: #a31515; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin; mso-border-alt: none windowtext 0cm; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: EN-IN; padding: 0cm;">"Description"</span><span style="border: 1pt none windowtext; padding: 0cm;">] =</span> <span style="border: none windowtext 1.0pt; color: #a31515; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin; mso-border-alt: none windowtext 0cm; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: EN-IN; padding: 0cm;">"sharepointquicksolutions.blogspot.in
"</span><span style="border: 1pt none windowtext; padding: 0cm;">;<br />
</span><span style="background: white;">spLstItemBB</span><span style="border: 1pt none windowtext; padding: 0cm;">.Update();<o:p></o:p></span><br />
<span style="border: 1pt none windowtext; padding: 0cm;"><br /></span></div>
<div class="MsoNormal">
<span style="background-color: white;">Condition#1: !spLstItemBB.Fields[i].ReadOnlyField</span></div>
<div class="MsoNormal">
<span style="background: white;">Condition#2: !spLstItemBB.Fields[i].Hidden<o:p></o:p></span></div>
<span style="background: white; font-family: Calibri, sans-serif; font-size: 11pt; line-height: 115%;">The above 2 conditions are
used for to skip the read only and hidden fields.</span><br />
<span style="background: white; font-family: Calibri, sans-serif; font-size: 11pt; line-height: 115%;"></span><br />
<div class="MsoNormal">
<span style="background: white; color: red; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin; mso-highlight: white;">Note</span><span style="background: white;">: By default, every sharepoint list and
library will have the below fields.<o:p></o:p></span></div>
<div class="MsoNormal">
<span style="background: white;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj_2VUxtDQaLszsk4a9QwoiiRSusVOJQ5ROZs9dOlxVy1CeX3tIcYQlMuJpZV7IGD6IwwR6t-3VttMtF6ghg7nfIxN4-P_pLyg2L2cdJMpiwcnF-TtlE9gpbAR-5HLT2Qf99r8z6s3unA/s1600/Read_hidden+fields.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj_2VUxtDQaLszsk4a9QwoiiRSusVOJQ5ROZs9dOlxVy1CeX3tIcYQlMuJpZV7IGD6IwwR6t-3VttMtF6ghg7nfIxN4-P_pLyg2L2cdJMpiwcnF-TtlE9gpbAR-5HLT2Qf99r8z6s3unA/s1600/Read_hidden+fields.jpg" /></a></div>
<div class="MsoNormal">
<span style="background: white;"><br /></span></div>
</div>
Anonymoushttp://www.blogger.com/profile/15414514889165889118noreply@blogger.com4tag:blogger.com,1999:blog-482466563826823203.post-37374367710556430982015-01-10T21:21:00.000-08:002015-01-14T09:03:09.888-08:00SharePoint administrator interview questions and answers: Recycle Bin3<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="MsoNormal">
<div class="MsoNormal">
<div style="text-align: left;">
<span style="color: red; font-size: 11.5pt; line-height: 115%; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-bidi-font-weight: bold; mso-hansi-font-family: Calibri;"><span style="font-size: large;"><a href="http://sharepointquicksolutions.blogspot.in/2014/09/spadmin-faqs-on-recycle-bin2.html" target="_blank"><<Previous page>></a></span> </span></div>
<div style="text-align: right;">
<span style="color: red; font-size: 11.5pt; line-height: 115%; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-bidi-font-weight: bold; mso-hansi-font-family: Calibri;"><span style="font-size: large;"><a href="http://sharepointquicksolutions.blogspot.in/2014/09/spadmin-faqs-on-recycle-bin.html" target="_blank"><<Next Page>></a></span></span></div>
<span style="color: red; font-size: 11.5pt; line-height: 115%; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-bidi-font-weight: bold; mso-hansi-font-family: Calibri;"><br /></span>
<span style="color: red; font-size: 11.5pt; line-height: 115%; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-bidi-font-weight: bold; mso-hansi-font-family: Calibri;">Is it possible to re create the same site collection
after immediate deletion of this?<o:p></o:p></span></div>
<div class="MsoNormal">
<span style="font-size: 11.5pt; line-height: 115%;">We can recreate the site collection after immediate deletion
of site but before starts we have to perform either of the below two actions otherwise you will get the below exception:</span></div>
<div class="MsoNormal">
<span style="font-size: 11.5pt; line-height: 115%;"> "</span><span style="color: red; font-size: 11.5pt; line-height: 115%;">A site collection with the same URL is already in the </span><span style="color: red;"><span style="font-size: 15px; line-height: 17.6333332061768px;">Recycle Bin</span></span><span style="font-size: 11.5pt; line-height: 115%;">"</span></div>
<div class="MsoNormal">
<span style="font-size: 11.5pt; line-height: 115%;"><br /></span></div>
<div class="MsoNormal">
<span style="font-size: 11.5pt; line-height: 115%;"><span style="color: purple;"><b>Action#1</b></span>: Manually starts the “Gradual site delete:”
timer Job.<o:p></o:p></span></div>
<div class="MsoNormal">
<span style="font-size: 11.5pt; line-height: 115%;"><span style="color: purple;"><b>Action#2</b></span>: Return the “GradualDelete” parameter a $False
in the PowerShell</span></div>
<div class="MsoNormal">
<span style="font-size: 11.5pt; line-height: 115%;"><b><span style="color: red;">Note</span></b>: Microsoft recommending does not use the
action#2 for in case of deleting the site collection which has larger volume.
Reason it increases </span><span style="font-size: 11.5pt; line-height: 115%;">the load on the system during the deletion process.<o:p></o:p></span></div>
<div class="MsoNormal">
<span style="font-size: 11.5pt; line-height: 115%;"><br /></span></div>
<div class="MsoNormal">
<span style="color: red; font-size: 11.5pt; line-height: 115%; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-bidi-font-weight: bold; mso-hansi-font-family: Calibri;">I delete a site which has other sub sites. Now, is
it possible to restore the deleted sub sites? I mean is it possible to restore
the child sites without first restoring the parent sites.<o:p></o:p></span></div>
<div class="MsoNormal">
<span style="font-size: 11.5pt; line-height: 115%;">Remember, Restore a child of site that has also been
deleted, you need to restore the parent first. For example: If you try to
restore “/sites/site1/subsite1/subsite2/sub3” before restoring the parent /sites/site1/subsite1/subsite2”,
nothing happens.<o:p></o:p></span></div>
<div class="MsoNormal">
<span style="font-size: 11.5pt; line-height: 115%;"><br /></span></div>
<div class="MsoNormal">
<span style="color: red; font-size: 11.5pt; line-height: 115%; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-bidi-font-weight: bold; mso-hansi-font-family: Calibri;">Getting the exception “Specified method is not
supported” while trying to delete the site?<o:p></o:p></span></div>
<div class="MsoNormal">
<span style="font-size: 11.5pt; line-height: 115%;">Upgrade your databases to SP1.</span><span style="color: red; font-size: 11.5pt; line-height: 115%; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-bidi-font-weight: bold; mso-hansi-font-family: Calibri;"><o:p></o:p></span></div>
<div class="MsoNormal">
<span style="font-size: 11.5pt; line-height: 115%;"><br /></span></div>
<div class="MsoNormal">
<span style="color: red; font-size: 11.5pt; line-height: 115%; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-bidi-font-weight: bold; mso-hansi-font-family: Calibri;">What is the method to delete all the deleted site
collections in web application?<o:p></o:p></span></div>
<div class="MsoNormal">
<span style="font-size: 11.5pt; line-height: 115%;">Method to delete all the “deleted” site collections
under a specified web application.<o:p></o:p></span></div>
<div class="MsoNormal">
<span style="font-size: 11.5pt; line-height: 115%;"><br /></span></div>
<div class="MsoNormal">
<span style="font-size: 11.5pt; line-height: 115%;"><span style="background-color: yellow;">Get-SPDeletedSite -webapplication http://sharepoint
| Remove-SPDeletedSite</span><o:p></o:p></span></div>
<div class="MsoNormal">
<span style="font-size: 11.5pt; line-height: 115%;"><span style="background-color: yellow;"><br /></span></span></div>
<div class="MsoNormal">
<b><span style="font-size: 11.5pt; line-height: 115%;">Note</span></b><span style="font-size: 11.5pt; line-height: 115%;">: You will be prompted to delete
them one by one, if you want it to run through them all without further prompts
just enter the letter “A”<o:p></o:p></span></div>
<div class="MsoNormal">
<span style="font-size: 11.5pt; line-height: 115%;"><br /></span></div>
<div class="MsoNormal">
<span style="color: red; font-size: 11.5pt; line-height: 115%; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-bidi-font-weight: bold; mso-hansi-font-family: Calibri;">How to delete site that has other sub sites
sharepoint?<o:p></o:p></span></div>
<div class="MsoNormal">
<span style="font-size: 11.5pt; line-height: 115%;">SharePoint will give error “you can’t delete a
site that has sub sites when we try deleting a site having sub sites”.<br />
Good tip to overcome this and delete the site along with sub sites is using
Site content and structure<o:p></o:p></span></div>
<div class="MsoNormal">
<span style="font-size: 11.5pt; line-height: 115%;">In SP2007: using stsadm cmd, you cannot delete the
sub site if it contains other sub sites.<o:p></o:p></span></div>
<div class="MsoNormal">
<b><span style="font-size: 11.5pt; line-height: 115%;"><br /></span></b></div>
<div class="MsoNormal">
<b><span style="font-size: 11.5pt; line-height: 115%;">Scenario on Office 365: <o:p></o:p></span></b></div>
<br />
<div class="MsoNormal">
<span style="font-size: 11.5pt; line-height: 115%;">Deleted site collections go into the site collection
Recycle Bin and are retained for a 90 day period. If you accidentally delete a
site collection, it can be restored from the site collection Recycle Bin by a
site collection administrator within 90. If you need a site collection restored
after this 90-day period has elapsed, it can be restored by Microsoft within 14
days by contacting Office 365 via a Service Request.<o:p></o:p></span><br />
<span style="font-size: 11.5pt; line-height: 115%;"><br /></span>
<span style="color: red; font-size: 11.5pt; line-height: 115%; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-bidi-font-weight: bold; mso-hansi-font-family: Calibri;"><span style="font-size: large;"><a href="http://sharepointquicksolutions.blogspot.in/2014/09/spadmin-faqs-on-recycle-bin2.html" target="_blank"><<Previous page>></a></span> </span><br />
<div style="text-align: right;">
<span style="color: red; font-size: 11.5pt; line-height: 115%; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-bidi-font-weight: bold; mso-hansi-font-family: Calibri;"><span style="font-size: large;"><a href="http://sharepointquicksolutions.blogspot.in/2014/09/spadmin-faqs-on-recycle-bin.html" target="_blank"><<Next Page>></a></span></span></div>
</div>
<div class="MsoNormal">
<span style="font-size: 11.5pt; line-height: 115%;"><br /></span></div>
<div class="MsoNormal">
<b><span style="font-size: 11.5pt; line-height: 115%;">Please provide your </span><span style="font-size: 15px; line-height: 17.6333332061768px;">valuable</span><span style="font-size: 11.5pt; line-height: 115%;"> feedback if it's really helps you.</span></b></div>
<div class="MsoNormal">
<br /></div>
</div>
</div>
Anonymoushttp://www.blogger.com/profile/15414514889165889118noreply@blogger.com0tag:blogger.com,1999:blog-482466563826823203.post-78611450470411799132015-01-08T08:16:00.000-08:002015-01-08T08:16:18.214-08:00List doesn’t exist. The page you selected contains a list that doesn’t exist. It may have been deleted by another user<div dir="ltr" style="text-align: left;" trbidi="on">
Recently I encountered the below issue while trying to recreate the same document library from the template.<br />
“<span style="color: red;">List doesn't exist. The page you selected contains a list that doesn’t exist. It may have been deleted by another user</span>.”<br />
<br />
<b><span style="color: #351c75;">Scenario</span></b>: I got a requirement like recreate the same document library which is already present.<br />
Approach: Save that document library as template and recreate wherever/how times you want. I did the same thing. But I got the above exception when I tried to recreate the same document library by referring the template.<br />
<br />
<b><span style="color: #4c1130;">Solution</span></b>: Check the enterprise keyword column is used in the document library. Delete it and recreate it again.<br />
<br />
I did the same thing and it’s works fine.<br />
<br />
-Thanks,<br />
sasi Kumar Reddy<br />
<br /></div>
Anonymoushttp://www.blogger.com/profile/15414514889165889118noreply@blogger.com0tag:blogger.com,1999:blog-482466563826823203.post-78687740291979573902014-12-16T09:41:00.000-08:002014-12-16T09:44:36.688-08:00Sharepoint administrator interview questions with answers:MMS<div dir="ltr" style="text-align: left;" trbidi="on">
<ol>
<li><span style="color: red;">What is the “Managed metadata”
column and use of it?</span></li>
<li><span style="color: red;">What is the “Enterprise Keyword”
column and use of it?</span></li>
<li><span style="color: red;">What is the “TaxonomyHiddenList” list
and use of it?</span></li>
<li><span style="color: red;">Enterprise keyword Vs Managed
Metadata?</span></li>
<li><span style="color: red;">How to check enterprise keyword
option is enabled? Means I cannot go to the each list/library level and confirm
enabled/disabled?</span></li>
<li><span style="color: red;">How to disable the Enterprise
keywords from the list/library?</span></li>
<li><span style="color: red;">Is it possible to stop creating new
keywords when add new values to the enterprise keyword column in list/library?</span></li>
<li><span style="color: red;">Error: Failed to create a term set:
A default managed metadata service connection hasn’t been specified.</span></li>
<li><span style="color: red;">Error: The Managed Metadata Service
or Connection is currently not available. The Application Pool or Managed
Metadata Web Service may not have been started. Please Contact your
Administrator.</span></li>
<li><span style="color: red;">Error: Users were unable to view the
enterprise keywords in sharepoint list/library?</span></li>
<li><span style="color: red;">Error: Users can’t see
the values of the Managed Metadata Columns for list items?</span></li>
<li><span style="color: red;">Error: The site doesn’t contain a
default term keywords term store?</span></li>
<li><span style="color: red;">Error: "The default term store
for this site cannot be identified." </span></li>
</ol>
Am preparing answers for the above questions. Will post you soon.<br />
<br />
Thanks,<br />
Sasi kumar Reddy </div>
Anonymoushttp://www.blogger.com/profile/15414514889165889118noreply@blogger.com0tag:blogger.com,1999:blog-482466563826823203.post-38420184427650238552014-12-02T10:14:00.000-08:002014-12-02T10:14:56.839-08:00Send Meeting Request in SharePoint<div dir="ltr" style="text-align: left;" trbidi="on">
By using the below code, we can send the invite meeting request to any.
<br />
<pre class="csharp" name="code">//To send Calder Meeting Event request
private void sendMeetingRequest(DateTime startTime, DateTime endTime, string candidateEmail, string status, string location)
{
try
{
//create the credentials
NetworkCredential cred = new NetworkCredential(ConfigurationManager.AppSettings["userName"], ConfigurationManager.AppSettings["password"]);
//create the smtp client...these settings are for gmail
SmtpClient sc = new SmtpClient(ConfigurationManager.AppSettings["SMPTPServerName"], (Convert.ToInt32(ConfigurationManager.AppSettings["portNo"])));
sc.UseDefaultCredentials = false;
sc.EnableSsl = true;
//credentials (username, pass of sending account) assigned here
sc.Credentials = cred;
MailMessage msg = new MailMessage();
msg.From = new MailAddress(ConfigurationManager.AppSettings["userName"], "FromMe");
msg.To.Add(new MailAddress(candidateEmail, "From My Portal"));
msg.Subject = "Interview Schedueled";
msg.Body = "Interview Scheduled. Get ready to face it.";
//DateTime startTime = DateTime.UtcNow.AddDays(1);
//DateTime endTime = DateTime.UtcNow.AddHours(25);
StringBuilder str = new StringBuilder();
str.AppendLine("BEGIN:VCALENDAR");
str.AppendLine("PRODID:-//My Group");
str.AppendLine("VERSION:2.0");
str.AppendLine("METHOD:REQUEST");
str.AppendLine("BEGIN:VEVENT");
str.AppendLine(string.Format("DTSTART:{0:yyyyMMddTHHmmssZ}", startTime));
str.AppendLine(string.Format("DTSTAMP:{0:yyyyMMddTHHmmssZ}", DateTime.UtcNow));
str.AppendLine(string.Format("DTEND:{0:yyyyMMddTHHmmssZ}", endTime));
string meetingLocation = "LOCATION: " + location;
str.AppendLine(meetingLocation);
str.AppendLine(string.Format("UID:{0}", Guid.NewGuid()));
str.AppendLine(string.Format("DESCRIPTION:{0}", msg.Body));
str.AppendLine(string.Format("X-ALT-DESC;FMTTYPE=text/html:{0}", msg.Body));
str.AppendLine(string.Format("SUMMARY:{0}", msg.Subject));
str.AppendLine(string.Format("ORGANIZER:MAILTO:{0}", msg.From.Address));
str.AppendLine(string.Format("ATTENDEE;CN=\"{0}\";RSVP=TRUE:mailto:{1}", msg.To[0].DisplayName, msg.To[0].Address));
str.AppendLine("BEGIN:VALARM");
str.AppendLine("TRIGGER:-PT15M");
str.AppendLine("ACTION:DISPLAY");
str.AppendLine("DESCRIPTION:Reminder");
str.AppendLine("END:VALARM");
str.AppendLine("END:VEVENT");
str.AppendLine("END:VCALENDAR");
System.Net.Mime.ContentType ct = new System.Net.Mime.ContentType("text/calendar");
ct.Parameters.Add("method", "REQUEST");
AlternateView avCal = AlternateView.CreateAlternateViewFromString(str.ToString(), ct);
msg.AlternateViews.Add(avCal);
ServicePointManager.ServerCertificateValidationCallback = delegate(object s, X509Certificate certificate, X509Chain chain, SslPolicyErrors sslPolicyErrors) { return true; };
sc.Send(msg);
}
catch (Exception ex)
{
Console.WriteLine(ex);
if(ex.InnerException!=null)
Console.WriteLine("InnerException is: {0}", ex.InnerException);
}
}
</pre>
</div>
Anonymoushttp://www.blogger.com/profile/15414514889165889118noreply@blogger.com0tag:blogger.com,1999:blog-482466563826823203.post-40034318428977678282014-12-01T09:31:00.000-08:002014-12-01T09:32:23.069-08:00Re-Order the sharepoint site columns in content type using powershell script<div dir="ltr" style="text-align: left;" trbidi="on">
<div _fallwcm="1" class="bdyItmPrt" id="divBdy">
<div>
<div>
<span lang="en-US">
</span>
<br />
<div>
<div style="margin: 0;">
<span lang="en-US"><span style="font-family: Calibri,sans-serif; font-size: x-small;"><span style="font-size: 11pt;"><a href="https://www.blogger.com/null" name="_MailOriginal"><span style="color: #1f497d;">PowerShell script to reorder the Sharepoint site content type columns:</span></a></span></span></span></div>
<div style="margin: 0;">
</div>
<div style="margin: 0;">
<span lang="en-US"><span style="font-family: Calibri,sans-serif; font-size: x-small;"><span style="font-size: 11pt;"><span style="color: #1f497d;">$URL = "</span><a href="https://webmail.bpglobal.com/OWA/redir.aspx?C=TKfNIe5GnkWS2dcEIsnLIIpMAhO73tEIsQDjDkuKKUNEjzX0RNoXC_MS-FGv4G33JfPRnzfEl5g.&URL=http%3a%2f%2fLocalHost" target="_blank">http://LocalHost</a><span style="color: #1f497d;">/”</span></span></span></span></div>
<div style="margin: 0;">
<span lang="en-US"><span style="font-family: Calibri,sans-serif; font-size: x-small;"><span style="font-size: 11pt;"><span style="color: #1f497d;">$site = New-Object Microsoft.SharePoint.SPSite($URL) </span></span></span></span></div>
<div style="margin: 0;">
<span lang="en-US"><span style="font-family: Calibri,sans-serif; font-size: x-small;"><span style="font-size: 11pt;"><span style="color: #1f497d;">$web = $site.openweb()</span></span></span></span></div>
<div style="margin: 0;">
<span lang="en-US"><span style="font-family: Calibri,sans-serif; font-size: x-small;"><span style="font-size: 11pt;"><span style="color: #1f497d;">$myCustomContentype=$web.ContentTypes["MySiteContentType"]</span></span></span></span></div>
<div style="margin: 0;">
<span lang="en-US"><span style="font-family: Calibri,sans-serif; font-size: x-small;"><span style="font-size: 11pt;"><span style="color: #1f497d;">$newFieldOrder = @("Title","MyCOl1","MyCol3","FileLeafRef","MyCOl5","MyCol2")</span></span></span></span></div>
<div style="margin: 0;">
<span lang="en-US"><span style="font-family: Calibri,sans-serif; font-size: x-small;"><span style="font-size: 11pt;"><span style="color: #1f497d;">$myCustomContentype.FieldLinks.Reorder($newFieldOrder)</span></span></span></span></div>
<div style="margin: 0;">
<span lang="en-US"><span style="font-family: Calibri,sans-serif; font-size: x-small;"><span style="font-size: 11pt;"><span style="color: #1f497d;">$myCustomContentype.Update()</span></span></span></span></div>
<div style="margin: 0;">
</div>
<div style="margin: 0;">
<span lang="en-US"><span style="font-family: Calibri,sans-serif; font-size: x-small;"><span style="font-size: 11pt;"><span style="color: red;">Name</span><span style="color: #1f497d;">: </span><span style="color: #1f497d;"> </span><span style="color: #1f497d;">Only refer the Sharepoint internal names for reorder.
</span><span style="color: #1f497d;"><b> </b></span></span></span></span></div>
<div style="margin: 0;">
<span lang="en-US"><span style="font-family: Calibri,sans-serif; font-size: x-small;"><span style="font-size: 11pt;"><span style="color: #1f497d;"><b>Example</b></span><span style="color: #1f497d;">: Internal name for “Title” is “</span><span style="color: #1f497d;"><b>FileLeafRef</b></span><span style="color: #1f497d;">”</span></span></span></span></div>
</div>
<span lang="en-US">
</span></div>
</div>
</div>
</div>
Anonymoushttp://www.blogger.com/profile/15414514889165889118noreply@blogger.com0tag:blogger.com,1999:blog-482466563826823203.post-69389173380996529832014-11-25T07:57:00.003-08:002014-11-25T07:58:44.401-08:00Create sharepoint site in Office365 using powershell script<div dir="ltr" style="text-align: left;" trbidi="on">
Just do copy/paste the below script in you powershell and see the magic..You will be able to new site in your office 365 application.<br />
<br />
Am sharing the below script to all of my SharePoint colleges once did the experiments from my side.<br />
<br />
*********************************************************************************<br />
$wc = New-Object System.Net.WebClient<br />
$wc.Headers.Add("User-Agent","Mozilla/4.0+") <br />
$wc.Proxy = [System.Net.WebRequest]::DefaultWebProxy<br />
$wc.Proxy.Credentials = [System.Net.CredentialCache]::DefaultNetworkCredentials<br />
Add-Type –Path "C:\Program Files\Common Files\microsoft shared\Web Server Extensions\15\ISAPI\Microsoft.SharePoint.Client.dll"<br />
Add-Type –Path "C:\Program Files\Common Files\microsoft shared\Web Server Extensions\15\ISAPI\Microsoft.SharePoint.Client.Runtime.dll"<br />
Add-Type –Path "C:\Program Files\SharePoint Client Components\16.0\Assemblies\Microsoft.Online.SharePoint.Client.Tenant.dll"<br />
$siteUrl = “http://xxx.xxxx.com”<br />
$password = convertto-securestring "*****" -asplaintext -force<br />
$ctx = New-Object Microsoft.SharePoint.Client.ClientContext($siteUrl)<br />
$credentials = New-Object Microsoft.SharePoint.Client.SharePointOnlineCredentials("username", $password)<br />
$ctx.Credentials = $credentials<br />
$webCreationInformation = New-Object Microsoft.SharePoint.Client.WebCreationInformation<br />
$webCreationInformation.Url = "URLName"<br />
$webCreationInformation.Title = "Title"<br />
$webCreationInformation.WebTemplate = "STS#0"<br />
$newWeb = $ctx.Web.Webs.Add($webCreationInformation)<br />
$ctx.Load($newWeb)<br />
$ctx.ExecuteQuery()<br />
********************************************************************************** <br />
Please let me know for any concerns.<br />
<br />
-Thanks,<br />
Sasi Kumar Reddy<br />
https://sharepointquicksolutions.blogspot.com</div>
Anonymoushttp://www.blogger.com/profile/15414514889165889118noreply@blogger.com0tag:blogger.com,1999:blog-482466563826823203.post-8749593144856280072014-11-20T08:25:00.002-08:002014-11-20T08:26:11.376-08:00Setup [Today] as default to the sharepoint date time control through browser<div dir="ltr" style="text-align: left;" trbidi="on">
<!--[if gte mso 9]><xml>
<w:WordDocument>
<w:View>Normal</w:View>
<w:Zoom>0</w:Zoom>
<w:TrackMoves/>
<w:TrackFormatting/>
<w:PunctuationKerning/>
<w:ValidateAgainstSchemas/>
<w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid>
<w:IgnoreMixedContent>false</w:IgnoreMixedContent>
<w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText>
<w:DoNotPromoteQF/>
<w:LidThemeOther>EN-IN</w:LidThemeOther>
<w:LidThemeAsian>X-NONE</w:LidThemeAsian>
<w:LidThemeComplexScript>X-NONE</w:LidThemeComplexScript>
<w:Compatibility>
<w:BreakWrappedTables/>
<w:SnapToGridInCell/>
<w:WrapTextWithPunct/>
<w:UseAsianBreakRules/>
<w:DontGrowAutofit/>
<w:SplitPgBreakAndParaMark/>
<w:DontVertAlignCellWithSp/>
<w:DontBreakConstrainedForcedTables/>
<w:DontVertAlignInTxbx/>
<w:Word11KerningPairs/>
<w:CachedColBalance/>
</w:Compatibility>
<w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel>
<m:mathPr>
<m:mathFont m:val="Cambria Math"/>
<m:brkBin m:val="before"/>
<m:brkBinSub m:val="--"/>
<m:smallFrac m:val="off"/>
<m:dispDef/>
<m:lMargin m:val="0"/>
<m:rMargin m:val="0"/>
<m:defJc m:val="centerGroup"/>
<m:wrapIndent m:val="1440"/>
<m:intLim m:val="subSup"/>
<m:naryLim m:val="undOvr"/>
</m:mathPr></w:WordDocument>
</xml><![endif]--><br />
<div class="MsoNormal">
<span style="color: #990000;"><u>Step1</u></span>:</div>
<div class="MsoNormal">
Create a new date time field and set the calculated value as
“<b style="mso-bidi-font-weight: normal;">Today</b>”. That’s it. </div>
<div class="MsoNormal">
Create a new item into the list. There you can see set the Today’s
date as default to the date time field.</div>
<div class="MsoNormal">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjy2_MFmy-z7-ZkHItQyhZPGUeo15Hq5ljySFsG562MvrJs9_9gZz5KznG4ekryUnT0xE772lYlSst57eEMwqEniV9Er2jvxNm4sIATx0cc7rumZuPutKUawzc0TvpuGG5O2eCrO_4kfg/s1600/DateTime.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjy2_MFmy-z7-ZkHItQyhZPGUeo15Hq5ljySFsG562MvrJs9_9gZz5KznG4ekryUnT0xE772lYlSst57eEMwqEniV9Er2jvxNm4sIATx0cc7rumZuPutKUawzc0TvpuGG5O2eCrO_4kfg/s1600/DateTime.jpg" height="320" width="217" /></a></div>
<u><b><span style="color: #741b47;">Step2</span></b></u>: <br />
Creata new item into the list and there you will see the set the Today's date as default to the sharepoint date time field.[PFB the image]<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj3FcuJ6yM64qTQpUlQDgNpoWAPrYpHAp2d9nQJA6Iy6hqNHc77T-EbgekM6pQKPLWe4b_RrcwPes3savm_XasfJN3Zm7gzsiRa9WwzPz_CmfZPoDfDBmbLRweTCDB2R2nrCKJU4vYhWg/s1600/DateTime1.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj3FcuJ6yM64qTQpUlQDgNpoWAPrYpHAp2d9nQJA6Iy6hqNHc77T-EbgekM6pQKPLWe4b_RrcwPes3savm_XasfJN3Zm7gzsiRa9WwzPz_CmfZPoDfDBmbLRweTCDB2R2nrCKJU4vYhWg/s1600/DateTime1.jpg" height="85" width="320" /></a></div>
</div>
Anonymoushttp://www.blogger.com/profile/15414514889165889118noreply@blogger.com0tag:blogger.com,1999:blog-482466563826823203.post-13905538771026888092014-11-14T15:49:00.000-08:002014-11-14T15:49:47.964-08:00SharePoint choice field using powershell<div dir="ltr" style="text-align: left;" trbidi="on">
$docSite = new-object Microsoft.SharePoint.SPSite($siteURL)<br />
$docWeb = $docSite.OpenWeb()<br />
$lncustomListName listName<br />
$CustomfieldName = "MyChoiceColumn"<br />
<br />
<span style="color: #741b47;">/* To create choice field *</span>/<br />
Add-SPMultiChoiceField -listName $lncustomListName<br />
<br />
<span style="color: #741b47;">/* Method to create choice field */</span><br />
function Add-SPMultiChoiceField([string]$listName) <br />
{<br />
$OpenList = $docWeb.Lists[$listName]<br />
$multiChoiceCol = "<Field Name='"+ $CustomfieldName +"' Type='MultiChoice' FillInChoice='FALSE' DisplayName='"+ $CustomfieldName +"'><Default>MyChoice1</Default><CHOICES><CHOICE>MyChoice2</CHOICE><CHOICE>ERM</CHOICE><CHOICE>MyChoice3</CHOICE></CHOICES></Field>" <br />
$OpenList.Fields.AddFieldAsXml($multiChoiceCol,$true, <br />
[Microsoft.SharePoint.SPAddFieldOptions]::AddFieldToDefaultView) <br />
}<br />
<br /></div>
Anonymoushttp://www.blogger.com/profile/15414514889165889118noreply@blogger.com0tag:blogger.com,1999:blog-482466563826823203.post-25907780182526128342014-11-07T07:48:00.000-08:002014-11-07T07:48:41.427-08:00Creating a Site using Nintex workflow<div dir="ltr" style="text-align: left;" trbidi="on">
<ol style="text-align: left;">
<li>Create a new list and the fields: Project Name(single line of text) , site name(hyperlink) and Author( people picker)</li>
<li>Create a new nintex workflow</li>
<li>Insert Action<span style="font-family: Wingdings; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-char-type: symbol; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin; mso-symbol-font-family: Wingdings;"><span style="mso-char-type: symbol; mso-symbol-font-family: Wingdings;"> and </span></span>Sites
and Workspace and then <span style="font-family: Wingdings; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-char-type: symbol; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin; mso-symbol-font-family: Wingdings;"><span style="mso-char-type: symbol; mso-symbol-font-family: Wingdings;"></span></span>Create
a new Site.</li>
<li>Configure the above action as shown below</li>
<li>If the parent site permissions has to be inherited ,check
the <b style="mso-bidi-font-weight: normal;">Inherit Permissions</b> check box<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjH6pQOLOiWicx0zoIxGeSddTzCE-j08-U3a2Nmn7lg5YzyWzi0Ok7gJ486YjAstfgwVFj_3NYavcxl2Z7d1Xivhz5eT3lKacXwmNlQOUHhG6ZmGHELA2wX0qmp1seXNnqoLom-jtpglw/s1600/CreateSite_Nintex.jpg" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjH6pQOLOiWicx0zoIxGeSddTzCE-j08-U3a2Nmn7lg5YzyWzi0Ok7gJ486YjAstfgwVFj_3NYavcxl2Z7d1Xivhz5eT3lKacXwmNlQOUHhG6ZmGHELA2wX0qmp1seXNnqoLom-jtpglw/s1600/CreateSite_Nintex.jpg" height="400" width="393" /></a></div>
</li>
</ol>
<br />
<div class="MsoNormal">
<br /></div>
</div>
Anonymoushttp://www.blogger.com/profile/15414514889165889118noreply@blogger.com0