Showing posts with label SharePoint. Show all posts
Showing posts with label SharePoint. Show all posts

Friday, October 21, 2016

SharePoint Framework Install



go to directory in command line
node –v
npm –v
update npm
npm install --global npm@latest
3.10.8 to 3.10.0
Install git
Install yeoman
use the node command prompt
npm install --global yo
yo –version
 
https://dev.office.com/sharepoint/docs/spfx/set-up-your-development-environment
 
npm i -g @microsoft/generator-sharepoint
 
 
https://dev.office.com/sharepoint/docs/spfx/web-parts/get-started/build-a-hello-world-web-part
 
cd helloworld-webpart
yo @microsoft/sharepoint

need to install gulp
npm I –g gulp

gulp serve
add webpart

open HelloWorldWebPart.ts with vs


Thursday, October 31, 2013

SharePoint Request Management



$w = Get-SPWebApplication -identity http://sp2013wfe1

$rmset = $w | Get-SPRequestManagementSettings

New-SPSite -Url http://sp2013wfe1 -owneralias sp2013\Administrator -ownerEmail administrator@sp2013.loc

New-SPSite -url http://www.contoso.loc -HostHeaderWebApplication $w -owneralias sp2013\Administrator -owneremail administrator@sp2013.loc -template sts#0

New-SPSite -url http://www.fabrikam.loc -HostHeaderWebApplication $w -owneralias sp2013\Administrator -owneremail administrator@sp2013.loc -template sts#0

$mp1 = Add-SPRoutingMachinePool -RequestManagementSettings $rmset -Name MachinePool1 -MachineTargets @("SP2013WFE1")

Get-SPRoutingMachinePool -RequestManagementSettings $rmset

$rmset | Get-SPRoutingMachineInfo -Name "sp2013wfe1"

$rmmi = $rmset | Get-SPRoutingMachineInfo -Name "sp2013wfe1"
Set-SPRoutingMachineInfo -Identity $rmmi -StaticWeight 9

$criteria = New-SPRequestManagementRuleCriteria -Property UserAgent -MatchType Regex -Value ".*Microsoft Office OneNote 2013*"
$rmset | Add-SPThrottlingRule -Name "Refuse OneNote Requests" -Criteria $criteria -Threshold 8

$criteria = New-SPRequestManagementRuleCriteria -Property Url -MatchType Regex -Value ".*\.pdf"
$rule = Add-SPRoutingRule -RequestManagementSettings $rmset -Name SendAllPdf2mp1 -ExecutionGroup 0 -MachinePool $mp1 -Criteria $criteria

$criteria = New-SPRequestManagementRuleCriteria -Property Host -MatchType Equals -Value "www.fabrikam.loc"
$rule = Add-SPRoutingRule -RequestManagementSettings $rmset -Name fabrikam2mp1 -ExecutionGroup 1 -MachinePool $mp1 -Criteria $criteria

%systemroot%\System32\runas.exe /user:user@dc07.loc "%ProgramFiles(x86)%\Internet Explorer\iexplore.exe

Monday, December 5, 2011

MOS 2010 Study Guide for Microsoft Office SharePoint

I was invited to take the Beta version of the user exam for SharePoint, officially called Microsoft Office Specialist, SharePoint 2010. This was the first time that I have taken a Microsoft Office Specialist exam, though I have taken around 50 Microsoft Certified Professional Exams. But they are quite different, basically it is a simulation of SharePoint and one is assigned many different tasks to perform. Great fun.

After getting the certification I am teaching the SharePoint user interface to two students who would also like to write the exam. Since I had received it as part of a review program, I decided to use Geoff Evelyn’s MOS 2010 Study Guide for Microsoft® Office SharePoint® from O’Reilly. The books is a good match to the exam objectives, I did not spot an exam objective that is not covered here. The intended audience would be someone who has been working with SharePoint for a while, and wants to write the exam. The book does not work as well outside the intended audience, for example, a SharePoint beginner. The exercises do not work just doing them in order, as an instructor I had to fill in the gaps and do some preliminary work to get the exercises to work. Another example, page 24 mentions content types but they are not explained until page 75, where they are explained very well. A step in the direction of giving more SharePoint background is the only companion download to the book, a 13 page Appendix: Overview of SharePoint 2010.

Monday, June 13, 2011

Book Review: Pro SharePoint 2010 Search

Just read the book Pro SharePoint 2010 Search yesterday, looking for gaps in my understand of search. It is a good coverage of SharePoint Search, it does not cover FAST Search. That the authors had real life experience was obvious from the coverage also of third party, I found this part especially interesting. Also enjoyed the brief discussion of the search algorithm. The discussion on changing the ranking model was good, and some of the issues with changing the user's language settings were clearly explained. I would recommend this book. I received it as part of a review program.

Using Today in a SharePoint calculated column

Sometimes one can be too tricky for ones own good. Was recently talking about the workaround to name a column Today, then create a calculated column using Today, and then to delete the placeholder column. Works like a treat, but of course the Calculated column does not automatically update the calculated column unless the item changes. Now we know why they hid this feature. Of course one could make a timer job....With thanks to Vaidotas.

Friday, June 10, 2011

Developer Dashboard

$cs=[Microsoft.SharePoint.Administration.SPWebService]::ContentService
$dds=$cs.DeveloperDashboardSettings
$dds.DisplayLevel=[Microsoft.SharePoint.Administration.SPDeveloperDashboardLevel]::On
$dds.Update()

Wednesday, May 25, 2011

Recipe: IIS 7.0 Compression for SharePoint 2010

%Windir%\system32\inetsrv\config\applicationHost.config around line 445


<httpCompression directory="%SystemDrive%\inetpub\temp\IIS Temporary Compressed Files">

<scheme name="gzip" dll="%Windir%\system32\inetsrv\gzip.dll" dynamicCompressionLevel="9"/>

<dynamicTypes>


cd \windows\system32\inetsrv

APPCMD.EXE set config –section:httpCompression /dynamicCompressionDisableCpuUsage:75

APPCMD.EXE set config –section:httpCompression /dynamicCompressionEnableCpuUsage:20

APPCMD.EXE set config –section:urlCompression /dynamicCompressionBeforeCache:true


XML rendered in blog with help of http://centricle.com/tools/html-entities/



Tuesday, May 24, 2011


http://www.mctsummit.eu/Sessions.aspx?ID=8

See you there! I will be presenting one SharePoint Deep Dive for ITPros and one for Developers.


Monday, April 25, 2011

Writing programmatically to the web.config file

SharePoint 2010 has a change that requires the following PowerShell:

$cs = [Microsoft.SharePoint.Administration.SPWebService]::ContentService

$cs.RemoteAdministratorAccessDenied = $false

$cs.Update()

OnTaskCreated not firing in loop

This bug with OnTaskCreated still exists

http://social.msdn.microsoft.com/Forums/en-US/sharepointworkflow/thread/2273b142-46d8-49a0-bd33-1f953d84b2c8

Monday, March 14, 2011

InfoPath FormService MemoryCacheSize default

Technet says 250 MB. MSDN says 300 MB.
I suspect the first figure is correct. The 300 MB is the threshold as explained here.


Friday, February 25, 2011

Kerberos for SharePoint 2010

Just reading this excellent white paper http://technet.microsoft.com/en-us/library/ff829837.aspx
and want to be sure that I have the main points clearly in mind. My previous blog on Kerberos is here. http://software-smith.blogspot.com/2010/02/using-kerberos-with-moss-2007-and.html

1. Service Apps only use C2WTS if incoming auth is classic or Windows claims.
2. Reporting Services is not claims aware, needs classic Kerberos as does RSS viewer with authenticated feed.
3. When C2WTS with Kerberos, must use constrained delegation. eg. Excel, PerfomancePoint, InfoPath, Visio services. All require C2WTS with Kerberos. Cannot cross domain boundaries.
4. Basic delegation: BDC, Access, Reporting, Project. Can cross domain boundaries, no protocol transition.
5. According to the documentation PowerPivot is claims aware and does not need delegation. It uses C2WTS to get Windows Identity to connect to AS Vertipaq. On refresh Vertipaq/PP service uses SSS and NTLM to connect to data source, there would only be a need for Kerberos if this SQL was linked to a second SQL server. PowerPivot refresh and data collection requires classic authentication. I think the statement that PowerPivot is claims aware is wrong.
6. In multihop scenarios, cannot change from Constrained to Basic delegation.
7. SharePoint does not support Kernel mode authentication.
8. Cross forest Kerberos delegation is not possible, even with trusts.



Friday, February 18, 2011

SharePoint Myths

Myth 1. It takes 3 synchs for a profile deletion to work. See the mythbuster here.
Myth 2. You cannot use SharePoint for good looking internet sites. See some of the sites here.
Do you have a SharePoint myth you would like to see busted? Please send an email to the address here.

Monday, February 14, 2011

SharePoint 2010 Mirroring and Log Shipping

All databases can be mirrored for high availability except:
WebAnalyticsServiceApplication_StagingDB_
User Profile Service Application_SyncDB_
User Profile Service Application_SocialDB_
FASTSearchAdminDatabase
Reporting Services databases.

The only databases that can be logged shipped or use async mirroring:
WSS_Content
WSS_UsageApplication (not recommended)
Secure_Store_Service_DB_
All ProjectServer DBs if all db logs are synched
DefaultPowerPivotServiceApplicationDB (SQL server only)

This is according to this TechNet article updated July 29, 2010.

Another TechNet article also updated July 29, 2010 indicates that the following databases can also be log shipped:

Application_Registry_server_DB_
Managed Metadata Service_
PerformancePoint Service Application_
WebAnalyticsServiceApplication_StagingDB_
WebAnalyticsServiceApplication_ReportingDB_
User Profile Service Application_SocialDB_

Technically, I would concur with extending this list to include these.

With thanks to C. Liu

Saturday, February 5, 2011

CQWP (Content Query Web Part) and Dynamic Filtering

Basically you can use the token PageFieldValue to use a value on the current page layout. This works if it is a Managed MetaData field. Similarly you can use the PageQueryString to add a value to use in the query. A good example of using these values is here.

CQWP (Content Query Web Part) and Common View Fields

SharePoint 2010 exposes the Common View fields on the web part tool pane. Hence it is no longer necessary to export the web part, edit these fields and reimport. The documentation should be updated to reflect this.

Thursday, January 27, 2011

SharePoint 2010 Enterprise Search

Although you can have the query component and the query processor on two separate machines, the "Did you mean?" functionality will not work since it only uses the local query component.

Monday, August 30, 2010

The Microsoft Certified Master program

I just added the MCM logo to my blog. Why? Just another certification from Microsoft? Last time I looked on my transcript, I had the following, MCT, MCSD, MCDST, MCAD, MCDBA, MCSA, 2 MCITPs, 19 MCTSs, 5 MCPDs and 3 MCSEs. Each of those certifications took a lot of work and study and I consider each a good proof of competence in a technical area. Why am so excited about 3 more unpronounceable letters? ( so much so that when the email came late at night on Friday, our whole family was dancing around our home).

The key lies with the difficulty of the Master certification. The Master certification in effect certifies that one is an expert in a particular area, in my case SharePoint 2007. When I came to the three weeks of intensive course in Redmond in March 2009, I considered myself very competent in SharePoint, I had worked with SharePoint from the early beginnings of Digital Dashboard, all though the incarnations 2001, 2003 and 2007. I had gained a lot of experience, coaching a consultancy to become a SharePoint consultancy, retraining their consultants and developers to become SharePoint consultants and developers and fielding all the more difficult problems that came up. However, coming to Redmond I was a Commerce Server expert, not a SharePoint expert and to obtain the Masters certification I had to become an SharePoint expert. The 3 written exams are difficult enough, but it is the lab exam that is the real monster. 8 and a half hours of real world tasks that would usually take 8 and a half days in the real world. Because of the time difference between Europe and the US, by the end of my retake it was after midnight and I was so exhausted I would have had difficulty spelling SharePoint let alone doing any tasks. It took me more than a year after the Redmond training to reach the level of expertise required. Some of the recipes on this blog are the product of that preparation. Does that mean that I now think I know everything about SharePoint? No, it means that I have to continue learning constantly just to keep up. Being a master requires clearly identifying what you do not know and constantly filling in the gaps.

What advice do I have to others considering the same path? Firstly, I would advise you to be sure you are an expert before you get to Redmond. You will get much more out of the class. The experience is unique, you are sitting with a class with vast experience and the program tries to get the instructors who have the best knowledge in the world. Not all of them are natural teachers, so you also have to be able to draw the information out of them. It is also much easier if you can concentrate just on one product, my life is made a lot more difficult in effect trying to be a master of both SharePoint and Commerce Server, (even though there is no master program for Commerce Server).

Now that I have joined an small group of MCMs, (I calculate that I am the 18th outside Microsoft to obtain this qualification for SharePoint), do I think that we know SharePoint better than anyone else? No, I am very conscious that there are doubtless many good SharePoint experts who will not get this opportunity. (Having my own company meant that it was easier to convince my boss.) What about MVP's? I realize that MVP is an award given in recognition of services to the community, it does not in itself certify that one is an expert in that area. That said, we had 2 MVPs in our class and they were among the best in the class. The Master certification however, certifies that one is an expert right across SharePoint not just one particular area. Thus it is especially the case that although there is a focus on the architecture of large farms, since this is where you especially need a Master, a Master also has to know the development side well also. While there can always be gaps in a Masters knowledge, the breadth and depth of the exams sure tries to make sure that those gaps are small.

What is the Return On Investment from the Masters program? The jury is still out on that one. It would help us if Microsoft would require (or strongly recommend) having an MCM on board for large installations. It would help if a Gold Partnership received an advantage in competencies for having a Master involved. Unfortunately, they have recently gone the other way, and the Partner program no longer counts an MCM as counting as two MCPs.

What is my next step? I need to first make sure that my understanding of Commerce Server and SharePoint 2010 is at the same level as my understanding of SharePoint 2007. And that is a challenge enough for today.

Here are some of my classmates blogging about their experience:
http://www.houberg.net/archive/2009/04/06/master-training_are-you-ready.aspx
http://www.sharepointchick.com/archive/2009/04/08/the-microsoft-certified-master-experience.aspx
http://harbar.net/archive/2009/04/28/certified-master-for-sharepoint-2007-ldquor2rdquo.aspx
http://www.bluedoglimited.com/SharePointThoughts/ViewPost.aspx?ID=301
http://www.sharepointbits.com/blog/2009/10/31/freshly-minted-microsoft-certified-sharepoint-master.html
http://blogs.msdn.com/b/ramg/archive/2009/05/16/my-mcm-experience.aspx

Friday, August 27, 2010

Creating a generic Data Form web part with SharePoint Designer 2010


If you create a List Form web part and save it to a file or gallery you get a prompt whether you want the web part saved with a relative path (list name is stored in the web part) or fixed to thesite (list id is saved in the web part)


If you create a Data Form web part and save it to a file or gallery you do not get this prompt.
Insert > Data View > Empty Data View
Select a Data Source, then insert fields as Single Item Form.
Save Web Part to a gallery.

To make the web part generic and referencing a file name you need to do the following changes.

In the property ParameterBindings replace:
ParameterBinding Name="ListID" Location="None" DefaultValue="{01CF5B35-CB1E-4A5A-82D1-144C6A0312E2}"
with
ParameterBinding Name="ListName" Location="None" DefaultValue="Shared Documents"

Also replace
property name="ListName" type="string">{01CF5B35-CB1E-4A5A-82D1-144C6A0312E2}
with
property name="ListName" type="string">Shared Documents

remove this line
01cf5b35-cb1e-4a5a-82d1-144c6a0312e2

And replace each occurence of
ParameterKey="ListID" PropertyName="ParameterValues" DefaultValue="{01CF5B35-CB1E-4A5A-82D1-144C6A0312E2}" Name="ListID"
with
ParameterKey="ListName" PropertyName="ParameterValues" DefaultValue="Shared Documents" Name="ListName"

Make sure that the ListId and the List Guid do not appear any where else in the webpart.

Now you have a generic Data Form web part!

With thanks to Sandeep and the folks at Trinedy.