SharePoint resources for demos

Today’s post I thought I would include in order to find anything needed to create a working demo of SharePoint locally. Nowadays,  Azure or other cloud providers make this much easier, but if you want more control you can spin up your own locally.

Windows Server

2019 (still beta as of now)

https://techcommunity.microsoft.com/t5/Windows-Server-Insiders/bd-p/WindowsServerInsiders

2016

https://www.microsoft.com/en-us/evalcenter/evaluate-windows-server-2016

2012R2

https://www.microsoft.com/en-us/evalcenter/evaluate-windows-server-2012-r2

 

SQL Server

2017

https://www.microsoft.com/en-us/evalcenter/evaluate-sql-server-2017-RTM

2016

https://www.microsoft.com/en-us/evalcenter/evaluate-sql-server-2016

2014

https://www.microsoft.com/en-us/evalcenter/evaluate-sql-server-2014-sp2

 

SharePoint 2016

https://www.microsoft.com/en-us/download/details.aspx?id=51493

 

SharePoint 2013

Foundations

https://www.microsoft.com/en-us/download/details.aspx?id=35488

Server (Standard and Enterprise)

https://www.microsoft.com/en-us/evalcenter/evaluate-sharepoint-server-2013

 

SharePoint 2010

Foundations

https://www.microsoft.com/en-us/download/details.aspx?id=24983

Server (Standard and Enterprise)

https://www.microsoft.com/en-us/download/details.aspx?id=16631

 

Enjoy and happy lab building!

Advertisements

Office Files too big? Inspect them!

Today I had a problem with a group of users that were trying to work with a very large PowerPoint file in SharePoint and didn’t realize until I downloaded a local copy of the file that it was too big to work with through Office Web Apps.

So I did some digging around to see if there was a way to possibly shrink the files, so I ended up finding something here:

https://support.office.com/en-us/article/remove-hidden-data-and-personal-information-by-inspecting-documents-presentations-or-workbooks-356b7b5d-77af-44fe-a07f-9aa4d085966f

In PowerPoint 2016 you can find the option here:

After doing a bit more digging, this actually applies to all Word, Excel, and PowerPoint versions from 2016 on down to even the Office 2010 versions.

So now I’d be curious if this could be automated somehow to do some major cleanup in PowerShell or something? Hmmm… maybe for another blog post later… hehehe.

Hope this helps if you need to free up some space in the future.

Enjoy!

Creating sample data for SharePoint with SPDG

If you work like I do trying to setup test environments in SharePoint often, the experience is great when you finally get all the bells and whistles activated for the features you need to test, but then what?

Now you have a great looking environment with no data! A SharePoint farm with no data in it is like a chocolate chip cookie without the chocolate chips in it. You might as well throw it away and go get something else to eat.

Never fear though as I have recently discovered a great tool that can auto generate much of the content needed to flesh out a SharePoint farm and it happen to be an open source project on GitHub created by the same fine folks that created SPDocKit!

It’s called SPDG (short for SharePoint Data Generator) and it’s another awesome tool to add to your arsenal if you don’t already use it.

Just head over to Github at the following link and check it out here!

Below is an example screenshot to give you an idea of what it looks like:

What is even better about this tool is that you can use it to generate as much content or as little as you need to flesh out your test box. It works with SharePoint Online, and even older versions of SharePoint like 2010!

This tool is so great and I can see so many uses for it, I may just have to do a demo video of this sometime down the road, so stay tuned! I’d love to see more folks talking about this because it definitely saves a lot of time and effort to fill up an empty farm when you need to give a demo!

Many thanks again to the guys over at SysKit for developing something awesome like this!

I hope you enjoy it as well!

Displaying pdf reports in SharePoint

I had an interesting request by someone the other day. I was helping them set up a new site template for SharePoint 2013 and they wanted to display a couple of reports on their site that they had in pdf format in a way to showcase the numbers of the report to others in the company that would visit this site.

There are multiple ways actually to do this very method, but the one I ended up going with is referenced in the following article:

https://sharepoint.stackexchange.com/questions/151161/how-to-embed-word-and-pdf-documents-in-pages

After doing this one the page it gave a pretty good layout on the page. My only concern going forward is having to update this manually and having to possibly retrain someone to keep this showing the most up to date info on the page.

There are other things I would like to research as part of this like putting in zoom or other capabilities in the code to modify the view of the pdf for the users.

I hope this gives you more ideas for displaying info on sites and pages and should work regardless of what version of SharePoint you are working with.

If you have interesting ways to display reports or other objects on pages, feel free to add to this in the comments below.

Thanks!  -BJ

Update 9/18/17:

Beau Cameron just posted a fantastic article about how to do this in O365. Here’s the link:

http://www.aerieconsulting.com/blog/how-to-embed-a-pdf-in-a-modern-sharepoint-page?utm_source=collab365&utm_medium=collab365today&utm_campaign=daily_digest

Enjoy!

Add domain to people picker in Foundations 2010 and 2013

Hello everyone,

Recently I ran across a scenario where I needed to add in a new domain full of new users to my SharePoint Foundations farm.

Originally in my test setup we were dealing with a one way domain trust between my original dev forest and the newly created forest, so I went to searching and found the following article:

http://jantjesworld.blogspot.com/2013/06/configuring-peoplepicker-in-sharepoint.html

So I went in and followed the steps in his article and everything seemed to work just fine. That is until we went to production with this same scenario and discovered that we weren’t using a one way trust, but a two way trust.

After many hours of research and even a support ticket with Microsoft, we finally found our answer. And so far from the research I have done, there are many people who have figured out the one way trust issue, but no one has specifically noted what to do in a two way trust. That’s what I’m here for. 🙂

In a one way trust your PowerShell should include accounts that have permissions in the domain or forest so they can cross properly. In my case though with a two way trust the login information is not needed. Also with a two way trust, I did not need to set an encryption key.

For the new two way trust, all I had to enter was:

Stsadm -o setproperty -pn peoplepicker-searchadforests -pv “forest:Contoso.com; domain:Fabrikam.com” -url http://myintranet

I’m not sure if it was necessary, but after running this I did reset my web servers just for good measure and then, viola! I am now able to see my existing domain users as well as the new domain users in my people picker settings in SharePoint Foundations.

I have also tested this on both 2010 and 2013 versions of the product and it worked like a charm. My last bit of advice in this scenario is to make sure that you work closely with your Active Directory admin on this and ask many detailed questions…

It will go far and save you many headaches and possibly even a support call with Microsoft.

Thanks,

BJ