Word documents are really ZIP files!? How to extract photos from a Word doc

Did you know that a Word document is really just a ZIP file presented as a .docx? Give it a try by renaming a .docx to .zip and you’ll see you can open it and see the contents.

I needed to extract several images from a Word doc and by doing this you will find a Media folder in the zip file that contains the original images (that Word may have compressed).

Credit to http://www.thewindowsclub.com/extract-images-word-document for the tip


.NET Framework 3.5 doesn’t install. Windows 10 – Error code: 0x800F081F

After mulitple tries at getting error code 0x800F081F when trying to install .NET Framework 3.5 (and downloading the associated files for 2.0 and 3.0) on Windows 10, I was finally able to get it working.

Go into RegEdit and locate the HKEY_LOCAL_MACHINE\SOFTWARE\Policies\Microsoft\Windows\WindowsUpdate\AU folder. Double click on UseWUServer(UseWindowsUpdateServer) and change the value to 0.  If the value is already 0 this fix may not work for you. I had to reboot and then try to install .Net again, then it worked.

Via https://social.msdn.microsoft.com/Forums/vstudio/en-US/4ea808e7-c503-4f99-9480-aa8e6938be3d/net-framework-35-doesnt-install-windows-10-error-code-0x800f081f?forum=netfxsetup 

Download multiple files in One Drive for Business

It’s amazing that Microsoft doesn’t yet have an easy way to download multiple files or folders from One Drive, but here is the best solution currently available.

Via https://onedrive.uservoice.com/forums/262982-onedrive/suggestions/9255150-multiple-file-download-onedrive-for-business

Guys, there is a solution to the problem to download multiples files and/or folders from OneDrive for Business. I stumbled on it in another forum after reading through this one. You have to use Internet Explorer (not Edge, FF, Chrome, etc) Once you have logged into your OneDrive for Biz web page, look on the bottom left corner. There should be a link to “Switch to Classic View” there. Once you are back in Classic View, click the gear at the top right corner. Turn the Ribbon “On”, it’s the first option. Once the Ribbon is on, click “Library” and then “Open with Explorer”. This will launch your OneDrive for Biz share in a native Windows Explorer window. Obviously, from there, the possibilities to manipulate files and folders are endless. Not a seamless solution, but being able to open OneDrive for Biz in Explorer is also an awesome option, no client necessary. Hope this helps!

  1. Launch Internet Explorer

  2. Go to Settings and Turn On the Ribbon: https://i.imgur.com/ACItUbI.jpg

  3. Click “Library” and then “Open with Explorer” https://i.imgur.com/WQdjhMV.jpg

A guide to Amazon Fire TV, Kodi, MythTV, and Mythbuntu

It looks like Kodi (formerly XBMC) is the best possible media center platform available today. The big question is what hardward to run the application on. After trying out a Matricom (insert link)  and not being happy with the overall user interface and apps from the Google Play store that were made for a touch screen device, I decided to try running Kodi on an Amazon Fire TV (2015).

Out of the box the UI is great. There are many popular apps available directly from the Amazon Fire TV app store and easy access to Amazon Prime videos. All the supported apps and UI work perfectly with the included and simple to use remote.

One of the easiest and best ways to install Kodi and control your Fire TV is by using the Fire Starter app (link). Once you have Fire Starter installed it is easy to install and keep Kodi updated with one click.

After installing Kodi, you will want to take advantage of the many available add-ons. One of the easiest ways is by installing many add-ons with a single click from a zip file, like the method from tvaddons.ag (link).

MythTV and Mythbuntu

If you really want the best experience of live tv, it is highly recommended setting up a PVR backend like MythTV. Doing this will give you access to over the air live live TV from your antenna with multi-room DVR capabilities. This setup guide will be extremely helpful in setting up a MythTV Backend with tv guide listing data via Schedules Direct (Link to setup guide).

I chose to install Mythbuntu which is a version of Ubuntu Linux that has MythTV already installed and ready to go. I had first installed Mythbuntu 14.04.2 32 bit but later decided I should have gone 64 bit. I decided to do a fresh install but repeatedly received mysql database errors while trying to configure a clean install of Mythbuntu 16.04 64 bit. I then tried Mythbuntu 14.04.2 64 bit and everything worked on the first try. Even doing the upgrade to v16 through the automated software updater after installing v14 caused major issues for me (mysql and permission errors).

When installing the OS from the ISO files, I found that Rufus was a fantastic tool for easily creating bootable USB drives instead of burning installation DVDs.


Additional Links

Group a SharePoint list by year or month

I was recently working on a project where we wanted to display a SharePoint list or calendar by grouping items by month. This is not a SharePoint default but can easily be accomplished by creating a new field.

Simply create a new field that is is a “Calculated column (calculation based on other columns)” and use the formulas below. Note that the formulas are creating the field based on the “Start Time” value. This can be customized as needed.

Month Formula (Year/Month, example “2015/08”)
=IF( [Start Time]="", "No start time", YEAR([Start Time])&"/"&RIGHT("0"&MONTH([Start Time]),2))

Year Formula (Year, example “2015”)
=IF( [Start Time]="", "No start tiime", ""&YEAR([Start Time]) )

Source: http://techtrainingnotes.blogspot.com/2012/02/sharepoint-group-by-year-or-month-in.html

How to create a URL to a SharePoint alert

Sometimes it is nice to be able to create a button or direct hyperlink to direct users to create an alert on a list. Here is the easiest way that I have found to do it.

The formula = (site url) + “_layouts/SubNew.aspx?List=” + (list GUID)

And here is the breakdown.

  1. Site url is the path to your site (example: http://intranet/sites/training)
  2. Code for new alert is exactly “_layouts/SubNew.aspx?List=”
  3.  List GUID is the unique ID for your list. The easiest way to find it is to go to the library settings of the list you want to great the alert on then copy the URL for the “Advanced settings” and you will see that in the url there is a string after “List=”. This is the GUID you need (example: %7B76B645BF%2D1C33%2D43AC%2D827F%2D000394333F71%7D)
  4. Now you just put those three items together and you have your direct URL.

Finished example is http://intranet/sites/Training/_layouts/SubNew.aspx?List=%7BE7735F69%2D5542%2D4B8F%2D9426%2DD7757EAFABD9%7D

If you want to get fancy you can also specify the page the user is redirected to after clicking the OK or Cancel button on the alert page by adding “&Source=” followed by a url to the end for the hyperlink.

Credit via http://techtrainingnotes.blogspot.com/2011/10/sharepoint-create-alert-from-anywhere.html

Upload to SmugMug Easier with SnugUp

I recently worked on a project where I needed to upload many folders of images to SmugMug. Rather than manually create each folder and wait for the several hundred imaged to upload I tried out SnugUp. It is extremely easy to use and will sync any folder you target to the SmugMug folder you specify. I was able to easily upload the several thousand images in the proper folders in one shot. Great tool.

Images in Outlook are Blurry After Sending

I recently had an issue when I would embed an image in Outlook and it would look great. However, after sending the email the image became noticibly blurry and pixelated. I tried using the image as both .jpg and .png and neither worked.

I then came across this article http://www.howto-outlook.com/faq/unsharpimages.htm which solved the issue. The short answer is that the image needs to be created at 96 dpi because Outlook will reformat it to 96 dpi anyway. If it is not already at 96 dpi then it will become distorted. Check out the more detailed explanation below.

This issue usually happens when you are using a picture other than 96dpi.

When inserting a picture, Outlook will rescale the image as if it was a 96dpi image. This means that if you have a picture of 150dpi with a height of 88px, it will be displayed as an image of 56px high;
88px/150dpi * 96dpi = 56px

It even gets worse; upon sending, Outlook will convert and compress (re-render) the images to 96dpi with the new dimensions permanently! This means that all the “detailed” picture information is lost and you’ll be sending an image of 96dpi which is 56px high. This is of course a severe and very visible quality loss.

If your picture is less than 96dpi, then the opposite happens. A picture of 88px high with a dpi of 32 would then result in a 96dpi image of 264px high. So the result will be a very large image (but this time you can resize it back without the image becoming blurry).

This is a long outstanding issue/function/design choice which goes back all the way to Word 6.0 from 1993.

While this issue might not be a real issue when inserting pictures (which are usually too big anyway), it will become an issue when you have a carefully designed graphic to be used in a newsletter or signature; quality loss and unexpected changes in graphic sizes is not what you want then.