SharePoint Online Document Migration Tool: FREE

The SharePoint Migration Tool lets you migrate your files from SharePoint on-premises document libraries or your on-premises file shares and easily move them to either SharePoint or OneDrive in Office 365. It is available to all Office 365 users. It only works for documents and NOT lists or any other objects.



Download tool:






Unable to install Application Server Role, Web Server (IIS) Role SharePoint 2016

When installing on new win 2016 VM i got this error: Unable to install Application Server Role, Web Server (IIS) Role. Most solutions install features using Win Server ISO installation and Powershell. But you can enable to download features/components from windows update.

When we run the SharePoint 2016 pre-requisites installer in order to prepare our machine to install SharePoint 2016 product installation on Windows Server 2016, the installer fails due to the error shown in the screen below:

“The tool was unable to install Application Server Role, Web Server (IIS) Role”


The error occurred due to the reason that your operating system Windows Server 2016 do not allow applications to connect to the internet straight away to download files necessary for installation.

In order to fix this error, some steps need to be taken as described below:

  1. Open an MMC console.
  2. Add the Group Policy Object snap-in.
  3. The following screen will open.
  4. In Local Computer Policy go to Computer Configuration –> Administrative Templates and select “System”.
  5. Scroll down the list in the System settings and find “Specify settings for optional component installation and component repair”. Double-click the settings, a screen as displayed below will appear.
  6. Select Enabled in the top left corner and select “Contact Windows Update directly to download repair content instead of Windows Server Update Services (WSUS)”.
  7. Click OK and close the MMC console.
  8. Run the pre-requisite installer again and this time it will not give errors on a server role installation.

note: also turn off internet explorer enhanced security configuration for admins…


Microsoft Flow SharePoint Send Email By Due Date

Scope: Get Calendar Due Date and Send Email if due dates within 5, 30 or 90 days from current date.

Initially I used SPD and created 3 workflows. Here’s a screenshot of the 5 Day SPD workflow using pause actions. Didn’t work like I wanted it. Problem is that if the “due date” changed at any time, the workflow will keep the original Due Date.


Solution: Microsoft Flow

So Here’s the Microsoft Flow Version that I can schedule a recurrence and check the list every day and get the correct due date. This is only a rough draft of the Flow.

Set Recurrence. I set it to daily.


I check to see if DueDate is Null to reduce any Flow errors. You could make it required too. First I check 5 Day condition then 30 and 90.

All conditions are similar, I just use adddays function to change the logic. Final version of Flow will have a different email messages about the notice.

Only limitation is that Flow will only loop thru 500 items. Dynamic OData filters for SharePoint Connectors are not enabled yet. I could add filters after the Get Items too. but initial Get items is limited to 500. Flow is still new and getting new features added. Will continue testing and trying out advanced conditions.

PC Build: Custom Open Case


Intel I7-6700K
Ballistix Sport LT 32GB
850 watt Thermaltake PSU

Thermaltake PACIFIC DIY LCS R360 water cooling kit (which I only used radiator and res/pump) regid tubes and fittings were extra.

Samsung 850 EVO – 500GB x 2
Samsung 950 PRO Series – 512GB PCIe NVMe

See at the end for complete list for case parts.

Was inspired by a few designs to create an open case design. After seeing a few on youtube and looking at the thermaltake p5 case, I set out to create a custom case base on my own layout. Maybe this design is not the best, but it’s a start. Time to learn and get started.


First step is to choose material. I wanted something that was hard enough to support all my components, but easy to cut. I went with a PVC foam board. Its easy to cut and make a template. If it turned out too soft, I could just use it as a stencil for either plexiglass or aluminum sheets. Turns out the PCV was just strong enough to support my components.


I knew I needed extra support so I orders the back/front panels plexiglass. I also ordered steel standoffs that would make it sturdier.


Component Layout:

At first I just placed components on the board and sent pics to my friends. I chose a layout that just looked nice. I didn’t take into consideration a few key points.


  1. Keep pump reservoir at the lowest point for draining the system
  2. Build draining system. Most kits do not have a drain valve.
  3. Keep PSU and water apart or at least shield PSU from any potential leaks
  4. Measure PSU cables with your layout. I had to add 6 inches to main 24 pin cable to reach MB
  5. Measure holes with cables too. Original design for SSD cables was smaller. Had to double size.
    20160805_191142 20160806_174838

After you’re sure about the layout, either spray paint or cover the main panel with a design. I choose carbon fiber vinyl. Looks great and its cheap. A bit hard to install without getting bubbles. Just poke any bubbles with a razor and press it flat.


Tube Bending using a heat and silicon insert to keep the same form. 3D printed bending tool.

LED needed a 12 v power adapter plu, so I ordered a remote and connected to a 12v molex PSU connector.


Mounted all components and filled water cooling system. Only connected power to the pump and ran a leak test for 24 Hours.

Added the back panel Acrylic White semi translucent 24×24 inch. 3D printed red bold caps. Also printed bolt spacers.

Added the front clear plexiglass to standoffs. Looks great!!

3D printed List:

PSU bracket:

I designed a case stand, but didn’t use it in the end:

I designed a few other items. I haven’t uploaded to share yet. Will update later.(PSU cover, Pump/res base, Cable covers, Tube bending tool, bolt cap and spacers)

best wifey pic ever:


Here’s the complete build list:

Plexiglass: Clear 24 x 24
ProjectPVC 48×24
On switch and artic paste
Acrylic Sheet white 24 x 24
SSD 500 GB qty 2
PETG Regid tube 4 pack
Silicon Insert
Regid fittings 12 pcs
Thermaltake Water Cooling Kit R360
LED T shape connector
Thermaltake PSU 850 watt
White HDMI Cable 15 ft
LED corner connectors 5pcs
Carbon Fiber sheet 24×60
Steel Standoff 4pcs 200 mm height
Standoff bolts
Silicone insert 3ft
LEDs 16ft 5050
LED controller
T-Fitting and Drain Valve
Ballistix Sport LT 32GB
Samsung 950 PRO M.2 512 GB
EVGA GeForce GTX 1070
step drill bit
Intel I7-6700K




Enable Chart Web Part in SharePoint 2013

The SharePoint Chart Webpart was deprecated. But its still available in 2013.


  1. Login to any farm server hosting SharePoint as a Site Collection Administrator.
  2. Go to: Settings > Site Settings > Go to top level site settings > Web Designer Galleries > Web parts.
  3. Click the FILES tab.
  4. Click New Document.
  5. Scoll down the list and look for: Microsoft.Office.Server.WebControls.ChartWebPart.
  6. Check this item.
  7. Scroll back up to the top, and then click the Populate Gallery button.
  8. Wait for it to refresh.
  9. Scoll down the list and look for: ChartWebPart.webpart.
  10. Click its Edit button.
  11. Enter the value, Content Rollup, or enter any other web part group value appropriate to your needs.
  12. Click Save.
  13. That’s it.  The next time you open a web page in edit mode and search for a web part to add to it, you’ll see the Chart web part there.
1 2 3 5