Russ' Do It Yourself Home Workshop

Finding Fixes to Just About Anything and Everything

Importing an ICS Attachment to the non-Default Outlook Calendar

Posted by Russell Wright on February 13, 2019

Here’s a quick post on how to handle an ICS attachment (iCalendar or vCalendar file) when you have multiple O365 (or Exchange) accounts in the Outlook desktop application.

I have two Outlook accounts:  Business and Personal.  I am using Outlook (2016 I think, version 1808) to manage both calendars.  When an ICS file comes in on my personal (non-default) account as an attachment I’d like to add the contents to my personal calendar.  If I double-click and open it and then save, it will save to the default (business) calendar.  There’s a simple way to handle this problem.

Make sure you have your non-default calendar displayed in the calendar view.  Simply click and drag and drop the attachment to the non-default calendar and BOOM!  You’re all done.  Simple drag-and-drop works fine.

 

Posted in Computer Software, Office 365 | Leave a Comment »

Installing a Trailer Hitch on a 2018 Honda Clarity

Posted by Russell Wright on December 25, 2018

I’ve owned a 2002 Prius, a 2005 Prius, a 2010 Prius and my wife now has a 2017 Prius Prime.  They have all had trailer hitches installed for carrying bikes and towing my little 5’ x 8’ trailer for those Home Depot runs.  But now since we’ve joined the PHEV ranks, I recently expanded our PHEV fleet with the addition of a Honda Clarity.  Unlike the Prius Prime, there is only one manufacturer of a trailer hitch for this car (at least at this point in time).  Torklift has an Ecohitch (Part numbers: x7377 (2”), x7378 (1¼”)) that is on the pricey end of what I would normally pay for a hitch, but it seems to be well made and doesn’t stick out like a sore thumb, so I bought one.  It took a couple of weeks to get it since it was around the Christmas holidays and their site said they were experiencing a “high order volume.”  Good for them!

The hitch comes with a set of printed color instructions that are pretty good, but no one ever seems to get enough pictures for me.  I like pictures, so here’s my contribution to this project, should you choose to accept it.

As an overview, you need to remove the two tailights so you can remove the bumper facsia (bumper cover) to gain access to the bumper crash bar.  The hitch mounts underneath the bumper crash bar with new longer bolts that are supplied.

From tool standpoint, you’ll need:

  • Phillips screwdriver (misc screws)
  • Torx screwdriver (bumper cover screws)
  • 8mm socket (for taillights)
  • Flat screwdriver (for loosening pop rivets and trim panel fasteners)
  • Needlenosed pliers (for squeezing wire stay to remove it)

Begin by opening the trunk and removing six fasteners (three on each side) that hold the fabric trunk panels.  This should take about five minutes.

image

image

After these fasteners are removed you need to remove the wear molding that extends across the trunk.  Begin by removing the trunk latch cover.  It unsnaps pretty easily, so don’t overdo it.

image

Here’s a blurry closeup of the trunk latch cover.

image

Here’s a view of the fasteners that hold the wear molding in place so you can get an idea of where to pull up.  If you aren’t familiar with these, sometimes it can feel like you’re going to break something when you pull up.  That shouldn’t happen on new plastic parts.  When you reinstall, you just rap them with your hand to pop them back in place.

image

Just another pic of the wear molding.

image

After peeling back the fabric panels, you should be able to get to the back of the taillights.  Here you will need to remove four 8mm nuts, disconnect the connector and then simultaneously press both clips to remove the taillight.  The taillight should slide out directly towards the back.  You’ll notice in the pictures there is a fastener on the forward part of the taillight that fits over a clip.  It should slide off from this connector.

image

Here’s a back view of the forward part of the taillight showing the sliding connector.  I actually popped the connector out because I didn’t know it should slide on and off.

image

Here’s a removed taillight.

image

Here’s a pic of the empty taillight socket.

image

Here are a couple of pics of the back of the taillight locations.  You can see the connector and the holes where the taillight studs and clips go.  This is on the driver’s side.

image

This is on the passenger’s side.

image

The next couple of steps are pretty straightforward.  There are two big black torx screws that need to be removed from bumper fascia.  So, that means you’ll need a torx screwdriver to remove them!

image

Now its time to remove the phillips screws from each wheel well.  If you don’t have splash guards (mud flaps) you’ll probably have two on each side.  If you have splash guards there will be an extra three screws holding the splash guards in place and a panel fastener on the bottom of the splash guard.  Remove all these screws.  I don’t have a picture of this.

Next, under the bottom of the bumper cover are six (or eight) panel fasteners.  If you removed spash guards you already removed two.  You’ll have to lay down on your back and use your screwdriver to pry the heads up so the “pop rivet” panel fasteners will come out.  This picture shows them after they’ve been removed (along with the crash bar).

image

Now comes the scary part.  From the wheel well area grasp the bumper fascia at one corner and pull firmly up and away from the vehicle.  The fasteners should pop loose as shown in the following pictures.

image

You have to put your hand in the crevise and pull!  Pop, pop, pop it goes!

image

Keep going…you’ll get to the fasteners you can see that were beneath the taillights.

image

Once you get all this loose, the bumper cover should come off and reveal the crash bar, which is held in place with six bolts.

image

Disconnect the wire stay from its mount point by squeezing the backside of it with a pair of needlenose pliers.  This has to be moved aside as there is not enough clearance behind the trailer hitch for it to remain in its original location.  I wrapped a little extra tape around it just to prevent any future chafing.

image

Here’s another pic of the wire stay removed from its original mount point.

image

Now you can mount the hitch behind the crash bar and install the six bolts.  Torque to 85 ft-lbs.

image

To allow room for the bumper cover to be reinstalled, you need to trim a section out of it that is located around the receiver.  The section to be removed is approximately 4-1/2” wide and 4” deep.

image

Here are the recommended dimensions for material removal.

image

Another view of the bumper cover after the material has been removed.

image

Some pictures showing the fit after the trim job.

image

image

I also pulled a power wire through the grommet and tied it off under the car for any future power requirements for the trunk area (e.g. for a trailer wiring harness).

image

Now with the assistance of your helper, you can place the bumper cover back over everything a button it up.  As they say, put everything back in the reverse order of how you took it apart!

image

It should look something like this when you are done.

image

Posted in Auto Repair | 14 Comments »

Solved! – Outlook 2016 will not Display Images in Emails: Red X

Posted by Russell Wright on September 10, 2018

If you’re looking at this post you’ve probably been trying to solve the problem of Outlook 2016 suddenly not displaying images in email.  This problem was on my daily driver Windows 7 Dell E6530 (I have others).  Others have had it on every other Windows OS.  You’ve probably tried all kinds of things and are mad at Microsoft.  Same here.

1. Internet explorer advanced options:  Do not save encrypted files to disk.

image

2. Outlook options in the Trust Center:  Don’t download pictures automatically in standard HTML email messages or RSS items.

image

3. Send Pictures with Document in HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Outlook\Options\Mail missing from the registry.

image

4. Removing some Windows updates (should never have to do this, but we all know we’ve done it).

…and probably some others.

However, I found that resetting IE fixed the issue for me.

In IE Advanced Settings, click the reset button and reboot.  Yeah, sucky solution, but it’s the only one that worked for me.

image

References:

[SOLVED] Outlook 2010 not displaying images

Inline images may display as a Red X in Outlook – Microsoft Support

Pictures cannot be displayed and are shown as red X in Outlook

Fixing Outlook’s pictures show as red X problem – Spiceworks

Red X’s in Email Messages – Slipstick Systems

Microsoft Outlook 2016 Red X instead of Pictures – Windows 10 Forums

Posted in Computer Software | Leave a Comment »

pfSense SMTP Office 365 Email Settings on Netgate SG-3100

Posted by Russell Wright on August 17, 2018

It’s always a challenge to get the SMTP settings correct for sending through Office 365 SMTP email.  Here’s what I did for my new Netgate SG-3100.

You can start at System | Advanced | Notifications.

image

The important thing is to point to the email server than ends in mail.protection.outlook.com which is actually in your DNS MX record.

Port:  25

DO NOT CHECK:  Enable SMTP over SSL/TLS

Notification E-mail Auth Mechanism:  LOGIN

What I normally do in Office 365 is create a single “service account” email and assign multiple aliases to it.  Then I use the alias in the particular application, e.g. netgatedevice@mydomain.com.  This alias also serves as the Notification E-mail Auth Username, which you can leave blank since you have it in the FROM address.

SG-3100 pfSense SMTP Email Configuration

Posted in Computer Software, Networking | Leave a Comment »

Turn off Clutter in OWA Office 365

Posted by Russell Wright on June 26, 2017

Turn off clutter in Outlook Web Access in Office 365.  Thanks to Micael AC for the real solution!

https://answers.microsoft.com/en-us/msoffice/forum/msoffice_outlook-mso_win10/clutter-options-missing/46298cc6-b21f-45ac-9462-ffb20ae5bf05?rtAction=1498485082753

Your clutter settings are probably missing, so you must first change the Display settings.

image

image

image

Posted in Office 365 | Leave a Comment »

Replacing the Batteries in an APC UPS Battery Tray

Posted by Russell Wright on January 11, 2017

There comes a time when you need to replace the batteries in your UPS and, like most consumables, sometimes they can cost more than the acquisition cost of the UPS…if you don’t know what you are paying for.  Here’s what I did for an APC UPS 1400.

For a mere $230 you can order a new tray with batteries.

image

Or for about $60, you can purchase four new batteries and reuse your tray.

image

When you purchase these batteries, make sure you know whether you are getting F1 or F2 connectors on the batteries.  I ordered some with smaller (F1) tabs so I had to order some F1-to-F2 adapters.

image

Here are the batteries exposed, after removing the label.  Nothing special about these sealed lead/acid batteries.

image

First thing is to remove the batteries.  I had to think about this for a bit.  They are held in place with double-sided tape.  I ended up getting my heat gun out and heated up the metal side of the tray until I could pull them loose.

image

You can see where I first attempted to pry the batteries loose.  Much easier to heat up the double-sided tape and pull them out!

image

Just be sure to hook everything up as it was.  Basically, each battery pair is wired in series and then the pair are in parallel on the connector.  That would make the battery tray 24v output.  I found I could pull the fuses loose from their double-sided tape on the top of the batteries.

image

Now all you have to do is “stick” them back in the tray.

Posted in Computer Repair, Instructions, Misc Repair | Leave a Comment »

Repairing the Eddy Current Brake on a LifeFitness x5i Elliptical

Posted by Russell Wright on April 19, 2016

Well, I’ve now done this twice and I never published the pictures I took the first time, so here goes. 

What you may notice is the resistance is always higher than what you want…or what you remember the least resistance to be.  In fact, at one point, you might have heard the "pop" or "snap" while using your elliptical and notice the resistance no longer adjusts as low as it should.  You’ve come to the right place, and I’ll show you how to repair this for $10 or so.

So what is an "Eddy Current Brake?"  Well, it’s the magnetic part that creates the adjustable resistance on your machine.  In particular, we’re talking about the FB1 manufactured by Chi Hua in Taiwan.  To break (brake…LOL) it down in simple terms, eddy currents are created from the magnetic flux (of magnets) passing through a coil of wire (conductor).  Basically, you have a generator that creates small currents in a conductor that are essentially short circuited and turned into heat.  You can read about it at the source of all knowledge…Wikipedia.  This is what makes the drag force on your elliptical…you know, the thing that makes your legs hurt and sweat pour from your body.  Check it out on their web site and use your web browser’s translate feature.

image

Well, here’s what happens.  The blue actuator pulls and releases the cable based on the level setting.  This makes the white part in the green ECB (Eddy Current Brake) travel back and forth, which moves the magnets away from and closer to the flywheel, generating your resistance.

image

Unfortunately, after some period of time, the cable wears and snaps in two.  This is shown after removing the green part (essentially the stator). 

image

Getting the green part (stator) out (assuming yours is green, too) requires some mechanical work, but it’s not too hard…just takes some time.  You have to remove the flywheel.  Release the tension on the belt by loosening the nut on the tensioner.  Then you have to remove the flywheel nuts and the tensioner bracket.

image

image

You also have to remove the stator locking bracket to get it out of the way.  The actuator cable is easier to remove from the blue actuator side first by pulling and unwrapping it from the nylon spool.

image

What you are going to have to do is fashion a new cable to replace at least the one that broke.  Maybe two, if the other is worn and fraying.  I did this by purchasing a bicycle shifter cable ($5) and grinding down the barrel end with my Dremel tool to make it the correct diameter and length.  The ball end of the cable is not very critical.  It simply needs to NOT pass through the hole in the magnet.  You can pass the barrel end through the hole when threading it in place.  The replacement for the ball is a cable clamp that has been "swaged" in place using a crimping tool.  I used my ratcheting electrical crimpers, but you may want to opt for something more professional, like these hydraulic crimpers.

image

Here are my notes I took with my calipers.  Notice the leftover Christmas notepad paper. 

image

I didn’t get any pics of the stator taken apart, but it’s pretty easy to remove.  Two allen set screws hold it to the shaft.  Loosen these and pull it out…you’ll feel the magnets wanting to keep it in the flywheel.  Then there are some black phillip screws holding it together and the four silver screws that hold the thingamajiggy with the allen set screws.  Inside you’ll see the white plastic actuator that connects all the cables.

When you are done you’ll have something that looks like this.  Not really pretty, but very functional.

image

Posted in Misc Repair | 14 Comments »

OneNote needs a password to sync this notebook. Click here to enter your password. Get Rid of KB3055034 and KB3054886!

Posted by Russell Wright on November 5, 2015

This has been driving me nuts.  I’ve searched for hours.  For me, I’ve finally tracked it down to two updates in October.  KB3055034 and KB3054886.  After removing both my OneNote 2010 seems to be syncing again.  I first wrote about this for KB3055034 in this post.  But I was still having problems.  Then I found this post.  I’m not using SmartVault Drive, but since they appear to be related I removed them both.  Success!  This pic is showing the uninstallation of KB3054886.  I uninstalled it from everything.  Same for KB3055034…you’ll see it installed multiple times.  After the uninstallation, reboot.

KB3054886 Uninstall

Now I can sync from OneDrive again!

Some other background.  I have a personal OneDrive (Live) account.  I also have two OneDrive for business accounts.  I expect them all to work, but I’m finding OneDrive for business has lots of sync issues.

Some other posts I’ve looked at.  There were others.

http://meyermed.com/2014/02/fixing-the-error-onenote-needs-a-password-to-sync-this-notebook-click-here-to-enter-your-password/

https://community.spiceworks.com/topic/1236093-kb3055034-breaks-opening-office-files-directly-from-sharepoint

https://support.smartvault.com/04Support/01Knowledge_Base/KB3055034_%2F%2F_KB3054886_-_Uninstall_update_for_Office_2010_causing_Word_or_Excel_to_crash_when_opening_Word_or_Excel_files_from_the_SmartVault_Drive

http://faq.mydocsonline.com/1009/ms-office-2010-update-kb3055034-causes-authentication-error-when-opening-office-files-from-web-folders/

https://support.microsoft.com/en-us/kb/3099951

http://superuser.com/questions/986693/excel-2010-crashes-when-opening-files-from-sharepoint-office-365

Posted in Computer Software, Office 365 | Leave a Comment »

October 2015 Office Updates: KB3055034 Causes OneNote 2010 to Crash on Sync

Posted by Russell Wright on October 27, 2015

I can fully attest to this being a problem.  I noticed it when on site with a client and attempting to connect to our shared OneNote notebook on SharePoint 2010.  I was "catching up" with stuff that occurred over the last couple of weeks and OneNote would crash each time I tried to sync.  I even tried re-connecting to the OneNote notebook, but that also failed.

I opened Programs and Features and selected the View Installed Updates on the left and waited for Windows 7 to chunk through the multitude of updates.  When it finally settles down you can enter KB3055034 in the search box and, if you’re lucky, it will show you the multiple times it’s installed.  In my case it was four times:  Visio, Project, Office and something else I don’t’ remember.  I removed it four times and after it is gone syncing works again.

image

See how syncing works again?

image

Posted in Computer Software | 1 Comment »

Upgrading the Aerator on a Septic Systems

Posted by Russell Wright on August 8, 2015

I know!  Let’s design a septic aerator with an electric motor that sits down in a very caustic environment where the motor and bearings will only last 2-3 years so the homeowner has to constantly replace it.  And when it floods, it’s always good to have electrical power sitting under water!  NOT!

WP_20140610_08_10_02_Pro

This is the stupidest design in the world.  Poor idiots at Norweco.  They haven’t figured out that electricity and water don’t mix.

WP_20140610_08_09_53_Pro

No problem…let’s upgrade!  First you need to get an aeration stone like is used on a pond.  I found one on eBay.  It’s a 7" dome diffuser airstone.  It was about $50 or so.

WP_20140614_08_39_57_Pro

Next, put it on a long length of (properly measured) PVC.  I chose to use electrical conduit.

WP_20140614_08_39_47_Pro

Next, attach a PVC union for easy installation and removal.

WP_20140614_08_40_05_Pro

Now you’re getting the idea.  The assembly will be lowered into the chamber where aeration occurs.  Notice the notch taken out of the side of the concrete collar for the air supply line.

WP_20140614_08_40_50_Pro

You can lower it all the way.

WP_20140614_08_40_57_Pro

And make the final attachment with the PVC union.  This is where prior measuring and cutting is important!

WP_20140614_08_41_08_Pro

Now it’s all attached.  See the old electrical outlet?  It’s dead now.

WP_20140614_08_41_30_Pro

How did the air line get there?  A little digging!

WP_20140607_11_02_04_Pro

Just a shallow trench.  I think it took me about 45 minutes.  I’m pretty good with a spade.

WP_20140607_11_07_51_Pro

Covering it back up.

WP_20140607_12_05_17_Pro

Watering the sod back down.

WP_20140607_13_19_05_Pro

The final attachment to an aeration pump.  This is a very standard pump I got off eBay.  It’s a Hiblow HP-80 and was $248.00.  A little tubing and fittings and a bit of wiring (it runs all the time) and you’re done.  At this point in time it’s been running for over a year with no issues.  There’s a filter you have to clean and/or replace once or twice a year, but no big deal.  My effluent has never been cleaner!  That’s a nice way of saying, "My @#$% don’t stink!"

WP_20140607_16_11_16_Pro

Posted in Home Repair, Misc Repair | Leave a Comment »