Author Archives:

Let’s make a content provider weather database in Android

I am going to show you the code that I used to make my BigDogWeather app that uses the WeatherUnderground API to download current conditions in JSON format into a Android Content Provider that will allow us to share data with other applications like my wind graph app and barometric pressure graph applications.

We will make it a service so it runs in the background and downloads twice an hour.

First the MainActivity

It’s that time of the season again!

The annual Fall “I ran out of colors again” season.

Thank You Nepal (that’s a blue pin for you)

Thank You Italy (one more and you will have a yellow pin!)

Thank You Netherlands

Thank You Germany

Thank You Lebanon

Thank You Switzerland

Thank You U.K.

Thank You India

Thank You Brazil

Thank You Belgium

Thank You Russia

Thank You France

Thank You Australia

Thank You Malaysia

and of course …

Thank You China (Still going!)

Get ready people you are about to become the COOLEST people on the PLANET! and your neighbors are going to need your help.



OMG, OMG, OMG . . . breathe . . . breathe . . .

Ok, so yesterday I forgot my iPhone at home when I went to work. I never forget my phone, so I could have sworn I took it with me.

I did have my watch, so I thought I would ping my phone from my watch just to make sure I didn’t set it somewhere by mistake.

The watch showed that it was disconnected, but I thought maybe the phone was just out of range and pinging it might connect it.

IT DID! . . . but . . . it showed it was connected over the cloud!!!!

I didn’t hear the ping sound coming from the phone, so I walked around work to make sure I didn’t leave it in a different room. NO PHONE!

OK, time for the ULTIMATE TEST! IoT OtG BABY!!!!

Hey Siri, turn on living room lamp . . . . BOOOOOOOOOOOOOM!!!!!!! IT CAME ON!!!!!!!

Hey Siri, turn off living room lamp . . . . BOOOOOOOOOOOOOM!!!!!!! IT WENT OFF!!!!!!!

Hey Siri, turn on kitchen light . . . . BOOOOOOOOOOOOOM!!!!!!! IT CAME ON!!!!!!!

Hey Siri, turn off kitchen light . . . . BOOOOOOOOOOOOOM!!!!!!! IT WENT OFF!!!!!!!


The phone has to be somewhere, ok please, please, please be at home!

So at lunch I drive home and BOOOM there it is! I left it in the kitchen!!

Ok, let’s take it to the next level. Let’s try to connect the watch to my Android phone while it has tethering turned on. Nope, didn’t work. Ok, Apple wouldn’t let the series 2 watch just connect to any un-secure network, maybe I need to connect the phone to the hotspot first and then once it trusts the connection maybe the watch will too.


I left my phone at home and drove around with my Apple Watch connected to my Android phone and was able to send texts and use IoT OtG to turn on lights and fans at home!!!

So now I don’t even have to take my phone to work if I don’t want to, or if I forget my phone I can STILL USE IoT OtG!!!

OMG, OMG, OMG . . . breathe . . . breathe . . . .

P.S. I did try calling from the watch and it didn’t work, it could find my contacts but not make the call.

I’ll post some pics soon.

So why should you use my system?

Mobile users click on menu above for more information.

Home Automation, What is it?

Recently added a Wearables Page if you are wondering if you should get one.

Cost mainly, affordable and simple upgrade path, works with both iOS and Android, then openness, then the fact that I have no debt.

Oh yeah, Raspberry Pi’s work all over the world.(60 Countries, 6 Continents, 500+ downloads, Indonesia is getting a blue pin! South Africa, you’re keeping up, pretty cool!)

NONE of my Raspberry Pi’s have EVER gone bad, never had to return one.(You always see sales on refurbished Echo’s)

. . . and they make TONS of them.

The list just goes on and On and ON!

My setup is NOT proprietary and this is why I love using the garage door opener. You will never get locked out of your house.(The story also talks about how DEBT can raise it’s ugly head)

Business Insider – Smart lock maker Lockstate bricks some customers’ locks with software update

Alexa only works in the U.S. inside your house, 1 to 2 rooms tops. Phones and watches work all over the house, outside, in your car, in a cab. So why waste your money?

Speaking of saving money . . .

Aetna Customers! or maybe you know someone who is . . .

Apple working with insurer Aetna to discount Apple Watches for customers

9To5Mac – New WatchOS 4 features


Free Home Automation for iPhone

more info and demo video


Free Home Automation for Android

more info and demo video

Pi voice command – Google Play Store

more info and demo video

Home Automation on your Apple Watch!

Pi Watch Command in the App Store

more info and demo video

Pi Wear Control

Control everything you can on all my apps from your Android watch.

Pi Wear Control – Google Play Store

more info and demo video

Control all your devices via text messaging, will even work with a flip phone! or Apple Watch or Android Watch FROM ANYWHERE, FULLY CUSTOMIZABLE WAKE WORD! (Jarvis, James, Q, Computer, Lord Vader(crap, my new one), Mommy, Frank RULES). Actually you can set them all up, choose what you want ON THE FLY!! Just added Lord Vader while I was at work SWEEEEEEEET! (CORRECTION: I mis-spoke all speakers will ALWAYS have a PROPRIETARY wake word, wearables WILL NOT and already DON’T Android and Apple Watch)

I think this is the first product you have no fear of corporate licensing! (and for you corporate types, there is no settings saved on the hub, it’s all on the users phone! which does not need an app! and the name is NEVER passed to the hub.)

Just set up in your phone contacts what name you want and give it the phone number of your hub. FREEEEEEEEEEEDOM!!!!!! NO ONE IS GOING TO TOUCH THAT!


IoT OtG – Google Play Store

more info and demo video

Home Automation Hub for cloud support

Home Automation Hub runs on Android ONLY. Gingerbread and higher!

Required for the Garage Door App and the paid version of iOS and Android Home Automation Remote with cloud support.

Pi Smart Hub – Google Play Store

more info and demo video

Yes, one person did all this.

Believe me I use all this every day and my mind is just blown when I think about it.

Most of this was made a YEAR AGO!

Cloud functionality has been tested from Costa Rica to Kansas!


Home Automation Remote for iPhone with cloud support

more info and demo video

* also requires Android device (Gingerbread or higher) and app above.


Home Automation Remote for Android with cloud support

more info and demo video

* also requires Android device (Gingerbread or higher) and Smart Hub App.


Pi Garage for iPhone

more info and demo video

* also requires Android device (Gingerbread or higher) and Smart Hub App.


Pi Garage for Android

more info and demo video

* also requires Android device (Gingerbread or higher) and Smart Hub App.

Main Screen

Pi One Button Remote for iOS


Quickly and Easily turn on up to two devices, fan button has timer functionality built in.

App Store

Yes, Apple made me make ANOTHER VIDEO for this app, I’m going to have to add up all the minutes of all my video’s and see if I have enough time for a feature movie. Since the Emoji Movie has set the bar so low, I might have a shot at something.

Cost: a lot of it is timing, even though we are still pretty early in the game, some people made their bet WAY too early, and they will be the ones with proprietary hubs. They had to go into debt to make their hardware setup, they were mainly hardware guys with electrical engineering degrees who loved to make hardware, but times have changed since when they started. Now Schenzhen, China can make things way to fast and way to cheap. So their are lots of choices and their will have to be consolidation to a few companies. A lot of times focus on one thing is a good thing, but as my product shows, not this time. You’ve got all these hubs that do just one thing, so you have to buy multiple hubs and then if you want to simplify you have to buy another hub to connect them all together. I need to go out and do a search, I would love to see a house that has a special hub for the garage door, a special hub for the lights, a special hub for wall outlets, a special hub for the sprinklers, another hub for the thermostat, another hub used to connect them all, it would be a mess!

The Raspberry Pi DOES IT ALL. . . TODAY!

So you can see there is consolidation coming!

It’s actually already happening, if you don’t have much of a life and you search the blogs all day you will see companies being acquired/bought that are involved in home automation. Right now none of the prices are being announced, because those are the companies that have the most debt. And if they do their own hardware, they probably aren’t going to make it. Especially if they are just connecting someone else’s hardware.

What has to happen is a company that actually makes a device, say Phillips Hue is going to have to buy companies that make other things like wall switches, or invest in hardware manufacturing and software developers, a lot of developers, to make their product do one more thing just to stay in business, and this will eventually put the makers of hardware that connect things out of business. And all of this will take time, and it may render their current hub obsolete and then you will have to buy another one.

The Raspberry Pi does ALL OF THIS NOW! . . . and more! It’s almost impossible for the Raspberry Pi to be obsolete.

And Raspberry Pi is essentially the first of it’s kind, Audrino may have been first but to use those you need a lot of patience and be smarter than the average bear. When I bought my first Raspberry Pi I was actually on my way to get Audrino, but everything you need doesn’t usually come in one piece, I *think* you need 3 pieces i.e. how I ended up with a Raspberry Pi and the rest is history.

So what I meant to say is:

1. guess where they are made? China (developed in U.K.)
2. They got their process down to a science!

*Maybe* someone will beat them some day, Intel couldn’t, a couple others I will have to update later.

They actually beat themselves, Pi Zero, but they had to remove stuff that you need to do that, which you would have to add back yourself, so it doesn’t make sense for home automation.

So there you go, absolutely no cheaper solution and it’s available today. The only thing close is SainSmart they make a “wireless” (not so) board for their relay’s that cost $30 BUT they only work with a single relay board, so best case scenario you would have a bank of 4 light switches right next to each other so you could control 4 lights for $30 plus the cost of the relay. Raspberry Pi would cost you about $40 with a power supply plus the relay. But you probably aren’t going to stop there, so another relay another $30 for the SainSmart setup. You are already done with the Raspberry Pi setup, just add another relay.

Now out of the box you can only power 2 relay boards with the Raspberry Pi, but I found a way to power/control 8 relay boards with 1 Raspberry Pi.

And the Raspberry Pi is built to work in ANY COUNTRY.

It’s really not fair to all the other companies, it’s just the way things happened and you are the beneficiary.


There is nothing stopping you from doing what I have done. None of what I do is proprietary. I highly recommend if you have kids or grandkids you use this as a way to get them interested in programming and how electricity works (lesson one know how to turn off the power and use a volt meter to test the the power is off) This is a great way to get hooked on programming. I still recommend getting my app of course 😉 it’s the absolute fastest, cheapest way to get started off the bat, and then you can customize your own setup later if you want, but you don’t have to.

In fact we are so early in the game, if they got good at hardware installation they could start their own company. The way I see it they will be creating one of the next alarm installation companies of the future, of course those won’t last forever.

Openness is how I got my setup to do EVERYTHING TODAY! It has a free/standalone version for Android or iPhone that does everything(most secure), It has watch functionality for Android or iPhone, it has voice capability for Android, it has texting functionality for cloud like functionality(more secure than cloud), it has cloud functionality, Android hub, Android or iOS client, it has garage door functionality for Android or iOS. Timers, linking(scenes), geofence.

In the words of Tony Stark:

“What more do you want? For now!”

Debt: I have no debt, no overhead, no programmers (I’m the only one) I’m not going anywhere.

So you can take the long way around with the other guys, or be there today with me.

If you are ready here is a overview of how to connect the Raspberry Pi to a relay:

In depth hardware explanation

YouTube – Raspberry Pi – Home Automation – Garage Door Opener

Here is the software setup for the Raspberry Pi in pictures:

Raspberry Pi OS

Links to what you need to buy and where you can get them.

I would like to take a post to thank you all for your TRUST.

Technology has entered a phase where trust is in very limited supply and I hope that from the beginning I have shown you that I am someone you can trust to give you the best, forward thinking technology at the best value.

Consumer technology used to be a way to first and foremost, have fun, and it seems we have gotten away from that. I hope that my free apps will give you the fun you expect without any of the worries of being tracked or hacked.

Remember! The free apps do not have to be connected to the internet WHAT SO EVER! You can set up an entirely different network off the internet and use the app the same as if it was on the internet, but only when you are at home.

If later you want to do things remotely, and you have used it enough to trust my product, you can step up to IoT OtG. It is not foolproof, but it is the most trackable, smallest opening to the real world that I can think of.

It really humbles me that so many people all around the world have given me a chance to earn their trust. Especially the times we are in.

All for now, you know I like to add stuff, stay tuned . . .

Let’s learn something “new”

Welcome Swaziland! (looking for some pics now) Moving up the coast!

Love the 360’s


Thank You Italy, and France, and of course China!

Ok, I actually wrote this like 3 or 4 years ago, but you probably haven’t seen anything like it.

A music remote for the iPhone using an android device.

Some advice, if you are just starting out learning how to program, pick something you love, no matter how saturated the app market, you want to learn not sell. I avoided making a mp3 player because, how was I going to make any money in the app store with that? It’s not about making money it’s about ideas and if you are working on something you love the ideas will flow faster than you can type.

There are two reasons why I can code in Android and iOS. The app I am about to show you and a lesson I learned when networks were just starting to be the hot item.

I was in support and Novell was starting to take off, everyone who knew networks knew Novell.

Then Microsoft came out with Windows NT and I chose that side because of course it was the coolest.

So some people chose Novell and got rich, some people chose Windows NT and got rich (I got screwed), but the people who got INSAAAAAAAAANELY RICH? They knew BOTH! and could make both talk to each other, so I said to myself if that opportunity ever happened again I wasn’t going to miss it.

So the other reason I know both is Steve Jobs was stubbornly (his company) not going to make the iPhone 6 Plus, he made the iPhone 5. It was then I knew he wasn’t going to make the phone I wanted, but I LOVED the sound chip in the iPhone for listening to music.

So I was going to have to make my own, I don’t do hardware so I was going to have to use software. I was going to pick the song with the beautiful screen on my Samsung phone along with huge cover art on the screen and have the iPhone actually play the music.

Thought I was going to use BlueTooth, but Apple has their own kind of BlueTooth so that was out. But I found Bonjour or Network Service Discovery on Android.


And now since we have the iPhone 6 Plus, 7 Plus, 8 Plus I guess I can show you how I did it.

This will be 3 apps, two iOS apps and one Android app.

First we will make an app to create a text file of all the songs on your iPhone.

Then a Android app that will take the list and make a selectable list that you can pick a song from.

Then the iOS app that actually plays the music.


First click on the app name in the tree view on the left and then click on build phases and add the following frameworks in the Link Binary with Libraries section.


Then add this code to the ViewController.m file:

#import "ViewController.h"
#import <AVFoundation/AVFoundation.h>
#import <MediaPlayer/MediaPlayer.h>
#define NSLog(FORMAT, ...) printf("%s", [[NSString stringWithFormat:FORMAT, ##__VA_ARGS__] UTF8String]);

@interface ViewController ()


@implementation ViewController

- (void)viewDidLoad
    [super viewDidLoad];
    MPMediaQuery *everything = [[MPMediaQuery alloc] init];
    [everything setGroupingType: MPMediaGroupingArtist];
    NSArray *itemsFromGenericQuery = [everything items];
    for (MPMediaItem  *myArrayElement in itemsFromGenericQuery) {
        NSString *songTitle = [myArrayElement valueForProperty: MPMediaItemPropertyTitle];
        NSString *albmTitle = [myArrayElement valueForProperty:MPMediaItemPropertyAlbumTitle];
        NSString *songURL = [myArrayElement valueForProperty:MPMediaItemPropertyAssetURL];
        // We have to get same value twice to save as NSURL instead of String probably should
        // just convert a URL to String??
        NSURL *second = [myArrayElement valueForProperty:MPMediaItemPropertyAssetURL];
        AVURLAsset* audioAsset = [AVURLAsset URLAssetWithURL:second options:nil];
                CMTime audioDuration = audioAsset.duration;
        float audioDurationSeconds = CMTimeGetSeconds(audioDuration);
        NSDate* d = [NSDate dateWithTimeIntervalSince1970:audioDurationSeconds];
        NSDateFormatter *dateFormatter = [[NSDateFormatter alloc] init];
        [dateFormatter setTimeZone:[NSTimeZone timeZoneWithName:@"UTC"]];
        [dateFormatter setDateFormat:@"HH^mm^ss"];
        NSString* result = [dateFormatter stringFromDate:d];
        NSLog(@"%@%@%@%@%@%@%@%@%@%@%@",albmTitle, @"*", songTitle, @"*",songURL, @"*",albmTitle,@".jpg*", result,@"*", @"\n");


- (void)didReceiveMemoryWarning
    [super didReceiveMemoryWarning];
    // Dispose of any resources that can be recreated.


YOU NEED TO ADD THE FOLLOWING TO YOUR Info.plist FILE: (right click and open as source code)

    <string>Make a song list for my app</string>

make sure you insert this in where there is a string line above and a key line below, you don’t want to separate the key from the string they are a pair.

This will give you a list with items separated by *
Nothing will show on the screen of the phone.

Back In Black*Hells Bells*ipod-library://item/item.m4a?id=4716459563742250917*Back In Black.jpg*00^05^12*
Back In Black*Shoot To Thrill*ipod-library://item/item.m4a?id=4716459563742250918*Back In Black.jpg*00^05^17*
Back In Black*What Do You Do For Money Honey*ipod-library://item/item.m4a?id=4716459563742250919*Back In Black.jpg*00^03^35*
Back In Black*Givin’ The Dog A Bone*ipod-library://item/item.m4a?id=4716459563742250920*Back In Black.jpg*00^03^32*
Back In Black*Let Me Put My Love Into You*ipod-library://item/item.m4a?id=4716459563742250921*Back In Black.jpg*00^04^15*
Back In Black*Back In Black*ipod-library://item/item.m4a?id=4716459563742250922*Back In Black.jpg*00^04^16*
Back In Black*You Shook Me All Night Long*ipod-library://item/item.m4a?id=4716459563742250923*Back In Black.jpg*00^03^30*
Back In Black*Have A Drink On Me*ipod-library://item/item.m4a?id=4716459563742250924*Back In Black.jpg*00^03^59*
Back In Black*Shake A Leg*ipod-library://item/item.m4a?id=4716459563742250925*Back In Black.jpg*00^04^06*
Back In Black*Rock And Roll Ain’t Noise Pollution*ipod-library://item/item.m4a?id=4716459563742250926*Back In Black.jpg*00^04^26*
The Razor’s Edge*Thunderstruck*ipod-library://item/item.m4a?id=4716459563742250957*The Razor’s Edge.jpg*00^04^52*
The Razor’s Edge*Fire Your Guns*ipod-library://item/item.m4a?id=4716459563742250958*The Razor’s Edge.jpg*00^02^53*
The Razor’s Edge*Money Talks*ipod-library://item/item.m4a?id=4716459563742250959*The Razor’s Edge.jpg*00^03^46*
The Razor’s Edge*The Razor’s Edge*ipod-library://item/item.m4a?id=4716459563742250960*The Razor’s Edge.jpg*00^04^22*
The Razor’s Edge*Mistress For Christmas*ipod-library://item/item.m4a?id=4716459563742250961*The Razor’s Edge.jpg*00^03^59*
The Razor’s Edge*Rock Your Heart Out*ipod-library://item/item.m4a?id=4716459563742250962*The Razor’s Edge.jpg*00^04^06*
The Razor’s Edge*Are You Ready*ipod-library://item/item.m4a?id=4716459563742250963*The Razor’s Edge.jpg*00^04^10*
The Razor’s Edge*Got You By The Balls*ipod-library://item/item.m4a?id=4716459563742250964*The Razor’s Edge.jpg*00^04^30*
The Razor’s Edge*Shot Of Love*ipod-library://item/item.m4a?id=4716459563742250965*The Razor’s Edge.jpg*00^03^56*
The Razor’s Edge*Lets Make It*ipod-library://item/item.m4a?id=4716459563742250966*The Razor’s Edge.jpg*00^03^32*
The Razor’s Edge*Goodbye & Good Riddance To Bad Luck*ipod-library://item/item.m4a?id=4716459563742250967*The Razor’s Edge.jpg*00^03^13*
The Razor’s Edge*If You Dare*ipod-library://item/item.m4a?id=4716459563742250968*The Razor’s Edge.jpg*00^03^09*

The * needs to be replaced with commas, but a lot of songs have commas in the title, so you need to remove those first before converting *’s to ,’s.

Also song titles have :’s in them so remove those before converting the ^’s to :’s.

ipod-library://item/item.m4a?id=4716459563742250957 – is the song on the iPhone.

If your actually going to try this, it’s best to grab just a few songs first so you can make sure the song’s don’t have any weird characters in them like @ for instance.

Copy and save it as a .txt file.

less successful, wow, did someone say that.

Thank you China!


Also, Thank you Sweden! Once you’re done, YOU’RE DONE! You will have everything you need to start and finish your smart home and then it’s all just software upgrades after that. Haven’t touched the hardware in months.

Ooops, OK, you bought the Garage Door App, just let me know if you have any questions.

Linking of voice commands, that’s soooooo 6 months ago, very well documented:

Pi voice command – Google Play Store

more info and demo video

A small-screen iPod, an Internet Communicator and a Phone | Asymco

The Coming Software Apocalypse – The Atlantic

Here is how “Spaghetti Code” comes about:

A developer creates a system that meets a business’s needs. It consists of 3 servers costing a total of $50,000. But to save money the business only buys the main server costing $20,000, then they look for other systems that do the same thing and get the 2 other servers from 2 other developers for a total of $40,000. All say that they can make their system work with the others, but they can’t, they are written by totally different people with totally different thinking patterns and code is full of flags (variables that manipulate data to do what you need it to do to make it through the system). So one of the most intelligent support people get’s pulled in and has to create two other servers that talk in between the 3 purchased servers. So now we are at the original $50,000 that the original system would have cost. The support person busts their butt to make everything work as good as they can and then expects a raise. The person doesn’t get it there, but doubles their salary somewhere else. Then the company hires someone who is TOTALY out of the loop with no documentation. Spaghetti Code.

Where can I get a Raspberry Pi TODAY?

I’m glad you asked!

I will look for other countries too, but that will be a little more tricky.

. . . and done!



United States:

Fry’s Electronics

800 Garden Ave. North
Renton, WA 98057
Phone (425) 525-0200

Store Hours:
9am – 9pm Monday – Friday
9am – 8pm Sunday

Raspberry Pi

Other Fry’s locations:

Fry’s Locations

Microcenter (Sorry, you will have to change the store location manually at the top, that’s the way the web site works.)

$29.99 (In Store only – 8/28/2017)

Boston/Cambridge – Massachusetts (252 In Stock)

Raspberry Pi

Orange County / Tustin – California (241 In Stock)

Raspberry Pi

Denver – Colorado (236 In Stock)

Raspberry Pi

Atlanta/Deluth – Georgia (248 In Stock)

Raspberry Pi

Atlanta/Marietta – Georgia (248 In Stock)

Raspberry Pi

Chicagoland/Central – Illinois (248 In Stock)

Raspberry Pi

Chicagoland/Westmont – Illinois (248 In Stock)

Raspberry Pi

Beltway/Rockville – Maryland (248 In Stock)

Raspberry Pi

Baltimore/Towson – Maryland (248 In Stock)

Raspberry Pi

Detroit/Madison Heights – Michigan (248 In Stock)

Raspberry Pi

Twin Cities/St. Louis Park – Minnesota

Raspberry Pi

St. Louis/Brentwood – Missouri

Raspberry Pi

North Jersey / Paterson – New Jersey

Raspberry Pi

Long Island / Westbury – New York

Raspberry Pi

Brooklyn / Gowanus Expy – New York

Raspberry Pi

Queens / Flushing – New York

Raspberry Pi

(Wow! Having Law and Order Flashbacks!)
Westchester County / Yonkers

Raspberry Pi

Central Ohio / Columbus – Ohio

Raspberry Pi

North East Ohio/ Mayfield Heights – Ohio

Raspberry Pi

Cincinnati / Sharonville – Ohio

Raspberry Pi

Philadelphia / St. Davids

Raspberry Pi


Raspberry Pi

Dallas Metroplex / Richardson (249 In Stock)

Raspberry Pi

Northern Virginia / Fairfax (253 In Stock)

Raspberry Pi

Nothing near by? Order it on line:

Raspberry Pi

Power Supply (can use Android charging cable)

Micro SD – 16 GB

Here is a two relay board, good for first try

All Kinds of Relays

Wires to connect relay to Raspberry Pi

The 5v Power Block is now a thing . . .

Thank you Switzerland, Thank you Spain, and China (2000+ downloads in less than a month!! what a way to end a year!)

Normally you can only power 2 relays with a single Raspberry Pi, but I documented a way you can use a powered usb hub and modified usb cables to power up to 8 relays with one Raspberry Pi. It was very ugly and not user friendly, well that’s all about to change . . .

Hello, Innovation!

Here is the 5v Power Block:

Show you how to make one, this is what you will need:

Solder Sucker – removes solder while you heat it up with a soldering iron.

These are connection pins you can buy and they break off so you can use individual ones. You will solder these to the power and ground connections.

Heat up these spots with the soldering iron and remove the solder. Solder here is only to hold the aluminum frame to the board. Once you have removed the solder you can take a pair of needle nose pliers and pull off the aluminum usb frame from the other side and the white plastic piece will come out also.

Then I took a pair of locking pliers and clamped them on each individual data connection. Using the weight of the pliers I heated up the solder with a soldering iron and then lifted the board and the weight of the pliers pulls out the metal connection from the board.

Leaving this.