82 – 87 Monte Carlo Blower Motor Speed Control Repair – Part 2 Blower Motor Relay.

Blower Relay

In my previous post I went though the procedure to change out my Monte Carlo SS blower motor resistor Unfortunately that did not fix the issue and I moved on to the next component in the circuit. The blower motor relay. Again this is an inexpensive part and is worth the investment to repair my classic car.

PARTS

I have to say that I now believe that Amazon carries everything or at least put you in contact with a vendor that has what you need.

Blower Relay
1985 Monte Carlo Blower Relay

Here is a link to the RY20 relay from Standard Motor Products that is an exact replacement to the existing relay. Under $14.00 at Amazon!

Continue reading “82 – 87 Monte Carlo Blower Motor Speed Control Repair – Part 2 Blower Motor Relay.”

Dell Latitude E5550 Battery Replacement

In the office we tend to buy Dell Desktops and Laptops. In my opinion they are no better or worse than any other brand and are priced competitively. Normally we have a 3-4 year cycle moving old equipment out and new equipment in. This one E5550 has been hanging around for whatever reason and was feeling slow. I originally popped the back cover to upgrade to a SSD and noticed the battery was in bad shape and needed to be replaced.

E5550 Battery Replacement

From the looks of it, two of the cells out gassed and have a belly. This is very bad since the battery capacity is obviously reduced. It is also dangerous to the hardware since the added pressure from the battery could damage the system board or cause the case to crack.

E5550 BatteryE5550 Battery

Where to purchase a suitable replacement?

Continue reading “Dell Latitude E5550 Battery Replacement”

Best Desktop PC Battery Backup

Depending on where you live in the world continuous power without disruption can be an issue. Here in the United States we are lucky to have a power grid that works great most of the time. However, on occasion equipment fails and your power can be disrupted. Do you need a Battery Backup to help keep things running in the event of a failure?

Battery backups have been around for many years and come in many different sizes and capacities. In this article I would like to focus on the backup you would use for your desktop PC.

TOP BATTERY BACKUP CHOICE:

Over the years I have found APC to be the superior choice in battery backup systems. They make very large units to cover the server room and small units to backup the desk top environment as well.

Think of a backup unit as an emergency spare tire that will allow you to safely pull over to the shoulder. When sizing a unit, it should give you sufficient time to save your work and shutdown gracefully.

APC Battery BackupI have found this particular unit – APC BE600M1 600VA to be perfect for desktop workstations. 5 outlets are battery backed, while 2 are surge protected only. This will give you plenty of room for your PC, multi monitors, router and wifi. In my testing 600VA can keep the average PC running for an additional 15min after the power has failed. Plus the unit is very affordable running for under $60 at Amazon. The best part is this unit features a USB port than can keep your phone or tablet topped off during the power failure!
Continue reading “Best Desktop PC Battery Backup”

Repair A Mouse With A Broken USB Cable

Recently a coworker of mine purchased a Logitech M500 corded mouse on Amazon. Its relatively inexpensive at $24.99 and perfect for office use.  As you can see from the image below, its a nice size mouse with a few extra buttons. I believe Logitech has been selling them for years.

Now I get why amazon has frustration free packing!

The mouse came in retail packing and upon cutting open the sealed packing he accidentally cut the USB connection off the mouse. He immediately tossed the mouse in the trash and proceeded to order a second. I saw this and said, hey don’t toss the mouse, let me attempt a repair.

Easy Mouse Repair

I considered soldering the wire back together, but that would prove to be messy and there would be a large bulge close to the base of the mouse. My second idea was simply to replace the entire USB cable from an older mouse that was sitting in my parts bin.

STEP 1 – Open the mouse

The Logitech M500 has the screws hiding under the 4 pads on the bottom of the mouse. Remove the 4 pads carefully and set aside. Then remove the 4 black screws to gain access to the mouse.

 

 

Carefully pry the top of the mouse away from the base to revile the internal components .

Continue reading “Repair A Mouse With A Broken USB Cable”

Protect Your Internal Network With A LOW COST Honey Pot

It would appear that more and more companies and home users are becoming victim to bad actors intruding on their network. Weather it be a targeted attack or drive by malware, network security is a hot topic in today’s IT landscape. In this article I will describe how you can build a low cost Honey Pot that can help alert you to an intrusion before its too late.

What is a Honey Pot?

In simple terms a Honey Pot is a device  on your network that looks appetizing to a hacker.  Like drawing a bear to a pot of honey. This device will advertise services that appear vulnerable and maybe draw an attacker in for further investigation. At a minimum it can simply be used as an internal “trip wire” to alert you someone poking around.

Why does a honey pot work?

Stop Hackers WIth A Honey PotI’m Joe hacker and I have just installed malware on one of your employees workstations. I have quickly gained access and I am now able to execute code and commands. What is the first thing I’m going to do? If you said start poking around you would be correct. After I look for anything of value on my host computer I will quickly begin scanning the subnet looking for hosts that are alive. I will also begin mapping the network for services that are possibly vulnerable to attack. This is where the Honey Pot fits in. It has been patiently siting on your network waiting for someone to direct a packet of data in its direction and alert you to possible trouble.

I’m in! How much does a honey pot cost?

Continue reading “Protect Your Internal Network With A LOW COST Honey Pot”

Extracting Etsy Product Reviews To CSV File

Etsy is a great platform to sell your handmade wares, however since Etsy has become a publicly traded company they have made some changed that angered some sellers and may have caused them into looking at other venues. Moving to a new online store is like moving into a new home office. You want to take your belongings with you and setup shop in your new place. In Etsy’s case this could include your product listings, order history and even your product reviews.

Easy to move except product reviews!

Etsy is kind enough to provide tools to capture your sales data into a neat CSV file ready to import at your new shop, however the product review section is much more difficult to work with. There is no simple interface to export your reviews to a CSV file.

To capture your product reviews. you could cut and paste each one individually, and if your shop is like mine with over 3,000 reviews it could take days or months to complete this task

I want to help get you your data!

In my opinion you earned the reviews and therefore they belong to you and your shop. Now is it ethical to re-post the reviews at other venues? Can you legally use a customers name? I’m not sure, so what you do with the CSV file I provide to you is, well up to you. My official stance is Etsy product review extraction is purely for archive purposes.

How much does it cost? What do I get?

Each page of product reviews contains about 15 reviews on it. To make payment options simple and affordable to all, see rate chart below. Even at the $25 range it comes out to about .03cents per extracted review

  • 1 – 50 pages $25    (up to 750 reviews)
  • 51 – 100 pages $45 (up to 1500 reviews)
  • 101-200 pages $75 (up to 3000 reviews)
  • 201-500 pages $150 (up to 7500 reviews)
  • 500-1000 pages $200 (up to 15000 reviews)
    Over 1000 pages of reviews (email me!)

    PURCHASE AT THE GEEK GEAR ONLINE STORE

What will the data look like?

The data will be in a CSV file and contain the following

  • Reviewers Name
    (Some older reviews have been set to Anonymous by Etsy)
  • Date of the review
  • Content of the review
  • Item name

Unfortunately the process that I use is unable to capture the star rating. Hopefully all your product reviews are 5 star so it will be simple to add it on!

DOWNLOAD THE SAMPLE DATA HERE

Click the link to download the sample data it will show you the exact format of the data and you can easily manipulate it in Microsoft Excel.

 

 

You’re interested and would like to proceed

Click this link to my online store -> www.geekgearstore.com
Purchase the number of reviews you would like extracted
During check out, include your review page URL from Etsy and shop name.
(https://www.etsy.com/shop/<SHOP NAME>/reviews)

The system takes some time to crawl the pages and extract the reviews, usually I can have the work done in about 24 hours.

PURCHASE AT THE GEEK GEAR ONLINE STORE

Ready to go, just click the link above and you’re on the way. If for some reason I am unable to complete the task, you will be issued a 100% refund!

Questions? email me joe@joeoliveri.com

Thanks again for reading my blog,
Joe

visit the GeekGearStore

RELATED
Is Etsy just another Ebay?
Forced Etsy Payments; Is this a good thing or bad?

 

Weekend Project – 2011-2014 Dodge Charger Backup Camera Replacement

Over the last few months the backup camera on my wife’s 2014 Dodge Charger has been intermittently failing to send picture to the console display. The radio / head unit is functioning normally for climate control functions and AM/FM/ and Satellite is working OK too, so I began to troubleshoot the wiring.

During the troubleshooting process, with the backup camera active I disconnected the unit from the cars wiring harness and then reconnected it. At that point the camera begins transmitting again. (think reboot) The next time the camera is activated it fails once again.

This leads me to believe the unit is bad and needs to be replaced. A call to the Dodge dealership quoted me a price of over $350 for parts and labor. I quickly sourced the part on Amazon for around $197

OEM – Mopar  2011-2014 Dodge Charger / Chrysler 300 Backup Camera – $197 at Amazon

 

Tools you can use:

Continue reading “Weekend Project – 2011-2014 Dodge Charger Backup Camera Replacement”

Fun Desk Clock From Recycled iPhone 5

Technology changes so fast, and we all want the latest gadget, but what is the cost of consuming so much? Big business wants us to keep buying devices, even if the old ones are still good. We wind up with millions of abandoned iPhones, Androids and tablets. Some are recycled responsibly while tens of thousands are just tossed in the trash or the back of your desk draw never to be seen again.   Here is a super simple way to recycle your old iPhone into a great retro looking desk clock.

Recycle Your iPhone into a clock – WHAT YOU NEED

 

I needed a stand for my clock and since my objective was to keep this project as simple and low cost as possible. I started with two 3×5 acrylic photo frames.

 

3×5 acrylic frame. Very low cost, about $5.00 at Amazon

 

You will also need 8 flat rare earth magnets (Neodymium) The stronger the magnets the better. Keep them small and flat, the actual shape round or square does not matter. $14.00 at Amazon

 

A little glue to hold it all together. I tend to like GOOP, but any strong adhesive should do. Goop at Amazon $ 11.00

 

 

The last two items you probably have around the house.

  • A colored spay paint for tinting the acrylic frames, I used black.
  • Some type of counter weight for the back of the stand to give it stability, I used a pair of hard drive spindle motors.
Putting it together

Continue reading “Fun Desk Clock From Recycled iPhone 5”

Battery Replacement – Samsung Galaxy Tab S 10.5

It seems like everyone on this planet likes the latest shinny new gadget, and I’m no exception. However, there are times when one of those gadgets has everything you want in it and does a good job. My Samsung Galaxy Tab S is one of them.

Its OEM battery is running on fumes and basically it needs to be tethered to the wall almost all the time. Rather than toss it in the trash or take it to the kiosk in the mall I figured I would make a run at changing the battery myself. This replacement was MUCH easier than expected. I have changed a number of iPhone batteries over the years and they are a pain to do (because of all the glue). The Galaxy was easy and only took about 15 minutes to complete.

TOOLS AND PARTS

First stop was to Amazon to check out the replacement battery choices. There was a number of different  units on sale from $17 to about $55. While scrolling through they all seem to be the same Chinese replacement so I simply picked the lowest cost kit

Continue reading “Battery Replacement – Samsung Galaxy Tab S 10.5”

Making a great home network!

Moving into a new home or simply switching Internet providers can be a daunting task. Cable companies offer so many TV, Internet and Phone packages and combination of packages it could be hard to decide. How much bandwidth do I really need? How do I protect my network from hackers? What is the best WiFi access point and how do I maximize my range?

These are a few questions I will try to answer in this blog posting and maybe save you some money in the process.

How much bandwidth do I really need?

There was a period of time during 2017 the cable companies were having their marketing departments spin how fast their internet connections could be and they would compete for your business. 50/50 MB not enough were offering 100mb.. no were offering 900mb etc and so forth. If you’re not sure how much speed you need READ THIS. Personally I have 75/75 at home and my family is your typical Netflix / Amazon / Fortnite ECT and we are doing just fine.


How do I protect my network from hackers?

Continue reading “Making a great home network!”