Pretty slides with Sketchapp for PowerPoint and Google Slides via Drawing

Well the world has moved way beyond the clipart of Microsoft PowerPoint, so now what’s a person to do if they want really great artwork and beautiful slides.

TL;dr

First get pretty icons to with Gsuite, you need to export them to WMF and stick them in Google Drawing

  • The Noun Project. This is *the* place to get beautiful icons. They come in SVG format which is the format of the future. Its pretty clear you want a set of assets in SVG format into Google Drive.
  • Install Sketch and make sure you have Sketch Cloud, party away making incredibly cool diagrams. Then when you are ready export it
  • Now from the web interface https://google.com/drive, you want to open this with Cloudconvert and choose it when you right click and choose Open With on the SVG and select the WMF export format and hit convert and have it save it back to Google Drive. Note that there is a bug where there will be a big black box on top, just ungroup and delete it.
  • After a little bit, you will. have a WMF that you can Open With Google Drawing. Note that you cannot import this, you have to open with Google Drawing and then copy and paste it.
  • Once open in Google Drawing, it gets saved in GDraw format and you can now copy and paste to Google Docs, etc.
  • When you are done doing the edits in Google Drawing, which you need to do because you will get the right dimensions, then you export it back with a Save As SVG.
  • Then on your Mac, you can copy it to the GDrive and open it in Sketch. Sketch will then create it’s own file format and you’ve rounded tripped!

To make it work with Mac PowerPoint:

  1. you use the same Inkscape to do a command line conversion to EPS or PDF and this will import directly so it saves a step you don’t need to have it in separate drawing application.
  2. This does not work with EMF or WMF as you get a big black box on top way, so Microsoft is way better (but lacking on collaboration in real time on the web). Also unlike Google Drawings, this comes as a single object, you can’t edit the pieces.

The ugly details

Where these beautiful drawings should go is the biggest factor because the two biggies only import certain formats. The main thing is to make sure it doesn’t just convert it to a bitmap (e.g. JPG, or BMP) because that means you lose all the resolution and get rasterization errors plus the size is huge. The net is that EMF seems like the lingua franca across all these tools, so the strategy is to keep the documents in read/writeable SVG and then export into read-only EMF

  • Google Slides. They unfortunately don’t import SVG nor does it support EMF, SVG, EPS or PDF imports but it does support WMF via Google Drawings, instead, you have to have a running web app to copy from so bizarrely you have to have Windows Office to make this copy work or you have to use Google Drawings and copy and paste from there.
  • Mac Office. Annoyingly, only the Windows versions of PowerPoint support SVG natively. It does however grok EMF and EPS (although it does a bitmap conversion).
  • Windows Office  has SVG directly so it is a single step from Sketchapp (although this is Mac only)
  • Google Drive. It knows how to deal with SVG directly but only as a readonly object. That is it only has a viewer.

Give that, what are the choices for drawing applications and storage. You ideally want a format like SVG which is read and written and then you might have intermediate form. Looking at this list, the best choices seem to be Inkscape or Sketch.app:

  • Sketchapp also supports EPS and PDF and SVG export from it’s native Sketch format, EPS is not a bad one. We don’t use the more general PDF. because Google Slides doesn’t support that kind of import. It does cost $99 though but is way prettier. So to get to Mac Office is a one step create EPS.
  • Cloudconvert.com for instance which does this. But Install Cloudconvert as a Google application for Google Apps. Note that when doing WMF conversion, any colored object just comes out black on top, so you need to ungroup it and then underneath you will find the document. Also note that text boxes are turned into individual letters. The black box is a problem with Cloudconvert and also Inkscape.
  • Mac application like Gapplin to do this.
  • You can also do this from the command like with Inkscape
  • Inkscape. This is the open source version of Sketch.app. It does require XQuartz to run. You can install with Macports or Home brew. It has EMF export using Inkscape Save As or use EPS as the secondary format as this is something that Mac. However, it doesn’t seem to import SVG properly, I get an error from the Homebrew installed version. Plus it is an ultra ugly XQuartz applications. PowerPoint does understand. It’s native format is SVG so a pretty good choice.
  • Google Drawing. This is an editor like Sketch.app but is web based unfortunately it only support SVG and PDF as an output, so not super useful unless you add another translator https://openclipart.org to convert it into EMF for consumption by PowerPoint and Google Slides but this is an extra step. It is web-based though, so that’s attractive. It also does not import SVG so you can’t use it with other libraries
  • Google Autodraw. This takes any doodle and turns it with AI into a beautiful chart but it’s just a demo and only outputs PNG.

Getting a DJI Phantom 3 Pro back to life

This drone has been sitting around for a year, so now it’s time to see how to get it back to life. It isn’t super easy as all the firmware is out of date, so here’s goes a long evening of fixing things:

  1. Getting the batteries charged, there is a charger with two outputs, pop the battery out of the drone by pressing the tab and connect to the charger, then plug the controller in as well.
  2. After all is charged, put the battery into the drone, connect your iOS or Android device to the USB port of the controller.
  3. Now turn the controller on, all DJI devices have the same safety, you have to quick press the power and then press and hold for two seconds and the controller should come on.
  4. If you plug it into an IOS 10 device, it will throw up a monstrous list of applications that work with DJI, look for your model. Note that there is a DJI Go and DJI Go 4 (for Phantom 4 and later). So make sure to pick the right one.
  5. If your firmware is super old, the application will tell you (and give you a terribly wrong URL referring to the Inspire 1 and not your Phantom 3 Pro) you have to start with your controller. Find a USB key and then download the latest firmware onto it. You have to make sure it is the only thing on the USB key. Confusingly, it does not want you to install the latest one (1.10), but the older (1.3) and if you put the wrong in, it will not work.
  6. The only debugging is to take the USB key out and look at the TXT files that are left. It will actually get confused and tell you the latest firmware is already in the controller. Ignore that and just load 1.3.20.
  7. Now power plug the USB key into the USB port of the controller and the red light will turn blue and it will beep really loudly. After a couple of minutes, the light goes green.
  8. Now make sure to power cycle the controller and get back to that ominous red. Plug your phone in and turn on the drone (use the same double press).
  9. Now when you connect, it will start to download firmware. The older firmware required you to use the USB key, but getting to 1.3.20
  10. The next time you plug it in, the remote controller will update through the application itself.
  11. If you want to see what version your controller is on, this is pretty confusing, you click on the top menu bar the application then click on status. If you get a blank screen then this means it is up to date. You can look at the About menu to see what version controller you have. Right now that is 1.8.
  12. As an aside, the software load is asymmetric, the new drones (Mavic) have a Mac application called DJI Assistant, but not the older drones
  13. To update the drone, camera and battery firmware. Yes, they all have separate firmware, you go to the download site.
  14. First make sure to have a fan pointed at your Phantom 3 Professional, the gimble will actually overheat during updates?!
  15. Now insert the microSD into the side of the camera, put the battery in and then do the quick click and hold for two seconds. You will see a tiny LED on the camera which flashes red, it is actually flashing red and green, but you can only see this looking head on. It also kind of chirps every half second or so and there are lots of lights.

At this point I’m in a weird state:

  1. The Phantom flies. if you click on the status bar, you can see it is all connected
  2. If you click on the right side three dots, you can scroll down to About and you can see the firmware is updated.
  3. However, there is no image transmissions. The gimbal works and you can even try to take photos and videos and when you pull the MicroSD, you do get images

There are lots of folklore about this but it seems as if it is the video transmission that is broken.

  1. If the memory card isn’t formatted correctly, then remove it and see if you can see the image.
  2. The cable connecting the drone to the gimbal could come loose. To remove the gimbal, you have to push the plastic parts. You can actually swap out the ribbon cable as well.

So how do you get this fixed:

  1. You could just buy a new Gimbal for $300 and install it yourself, but what if it is in the drone itself?
  2. If you are lucky there is a DJI authorized repair place, then you don’t have to send it all the way back to DJI. There are even DJI Factory Stores now, so you might be lucky enough to find one of those.
  3. You can also drop a note to DJI and see if they can debug it. They have chat and email (quite a change from two years ago, where you waited on the phone for hours).

Screwing around with Unifi

I’ve been using Unify for home installations for a while now, so here are some notes on how to use them:

  1. Do not just hit the buttons willy nilly. Some like UAPSD can cause big problems as the Wifi access points power down.
  2. The admin console is pretty nontraditional, basically, you have a dedicated machine which manages all the access points. (Remember this stuff is designed for enterprises). This machine runs a little web server, so you access it via that (you can also tunnel through via the Ubiquiti cloud service to get to it). For most mortals, these are so robust, I just configure it at home and then plug it in at the remote site. If you remote home ever wants to manage it, they can adopt it if I send them the password (please do securely via iMessage or WhatsApp)
  3. The interface itself is even more confusing because the main configuration information is in the gear settings, you care about a few things like WLAN network, you can have a host of SSIDs that represent a single logical LAN. This is useful if you want your company devices to just work on your home network.

Stripping audio from a movie file

This seems like it would be so easy, you can do it if you load it into iMovie, but if you want to do it really quickly, you have to use 5 year old software. mpegstreamclip does this, you just load the file and choose Extract/Video and it works.

Useful if you want to just look at the video clip and don’t want to import it into a real video editor.

Interestingly, the old QuickTime Player 7 also used to do this, but that feature was lost with Quicktime Player 10. You can still download it though.

Then there are commercial products like Video Editor MovieMator that try to upset you.

Installing telnet on windows 10

Well windows has sure gotten more complicated. Getting telnet running take three steps 

  1. You need to run the Super Administrator mode for the command line. This is pretty hidden right now particularly if you are Running a windows tablet and it is not clear how to right click. The trick is to long press and item and then that is interpreted as a right click 

  2. Go to the Cortana menu which is the text box on the lower left and type ‘Cmd’. Then Long press and you will get a context menu so choose ‘run as administrator’ 

  3. Now you need to run their download manager dism. And you want to enable the feature with ‘dism /online /Enable-Feature /FeatureName:TelnetClient’

  4. Then if you want to capture a telnet stream it is as simple as ‘telnet ip adress socket‘ > output.txt

Capturing multiple videos on a mac

Well if you want to capture multiple videos from a Mac and potentially mix them here are some applications to try:

  1. Capturesync. Best Software has this, in experimenting, it is nice because it puts all of the video into a single file. Since it is recasting files it is CPU intensive. Works fine with three uhd feeds and five hd feeds at 5 fps on a MacBook Pro (2014). 
  2. ScopeBox. This monitors feeds and then turns it into video. This has a nicer interface, but doesn’t scale beyond a few inputs and seems to hang.
  3. VLC. Remove audio is one important thing and VLC does this pretty easily. 

Some standard dimensions:

  1. Logitech C920. 1080p30
  2. Logitech Brio. 4Kp30

Mavic Pro and all the goodies

Well it seems pretty clear the Mavic Pro is the most awesome drone right now, but as usual, you need a host of accessories. The drone was really hard to get a launch, but now there are bunch of places which will set you back about $1500 mainly for the batteries.

  • DJI Mavic Pro. This is $999 from Amazon and most other places. There is a $1300 prop bundle that is kind of a decent deal because it has 2 Extra batteries ($180), 2 Extra propellers ($20), 1 charging hub, 1 car charger, 1 battery to power bank adaptor and a shoulder bag. But most folks think the shoulder bag is too tight.
  • DJI Refresh. You definitely need this, For $99 at Amazon, it gives you repairs and even if you land your drone in the water as long albs you can recover it you can get a new one.
  • Replacement propellers. Because you will certainly destroy them and for $25 at Amazon, it’s cheap insurance.
  • Extra Batteries. These are $90 each from Amazon and you need at least three given the 20 minute time and the length of time it takes to charge. So you need a total of four batteries to keep it flying continuously (one in and three recharging).
  • 5 in 1 charging hub. This will charge three batteries at once in about 60 minutes. The main thing is that to charge three batteries at once, it is huge and has a big fan. It’s a true parallel charger
  • Hood. You need your own cell phone for this thing, but you need a hood in bright sunlight. for $14.
  • Leg Extenders. Most folks recommend these $10 accessories because the drone is too low to take off from gravel or grass.
  • Prop guards. These are $13 and keep your props from chewing up trees for people for that matter.
  • Hard case.

Getting 8% on Amazon purchases and 11% off Netflix too

Well since I’ve been buying so much now’s a great time to ask how to optimize for purchases. Two pointers:

  1. Amazon. You can get 3 JetBlue Points per Amazon purchase just by clicking through. That’s about a 5% discount. You can also get a straight 5% off by using an Amazon Store Card, so that’s pretty easy. An even more aggressive way is to buy Amazon Gift Cards from Office Supply stores like Staples and then apply it. This gives you 5x from Chase (so about 11% off in Chase points). It’s kind of wash when you think about it as to what’s better, personally, I like the JetBlue Points plus using your regular credit card if you have one that earns it.
  2. Netflix. Turns out that Netflix counts as an 5X merchant. So switch to that with your Chase card because it has a

Building out a simple home backend

OK, for the third time this year, I’m outfitting someone’s home with enough of a backend that they should be relatively stable, here’s a guide to how to do this:

The right NAS

Synology DS216J. There are a host of models that Synology has, but even the most basic $170 computer gives you a RAID-1 configuration. And with a pair of 4TB drives, it is a great deal. I’m not sure if this is the perfect DS216 (they have a confusing list, but I picked the second from the bottom which is I’ve found usually a pretty cheap one). But it should saturate a gigabit Ethernet and it has a one disk redundancy.

The right hard drives are 4TB or 8TB

Seagate Enterprise Capacity. I’m really over provisioning here, but I’ve found that you really want a drive with a five year warranty because it will last longer as they use higher quality drives. Right now the best price/performance is the 6TB Drive. I normally buy these on Newegg.com as they have the best reviews and good prices. Make sure to sign up for their loyalty program and use cashbackmonitor.com to get a rebate. You really want three drives, two go in and one is a hot backup. So if a drive fails, you can plug the new one in and with RAID-1 it rapidly rebuilds. But with 4TB at $160 at Amazon, pricing is extremely linear at $40/TB all the way up to 10TB! ($420 at Amazon).

I normally get a drive that’s much bigger than I need because things always fill available demand. Right now the cheapest is 8TB at $39 or so if you can afford it, having a 10TB effective server isn’t such a bad thing for your home, it’s going to store a lot of videos! It will set you back nearly $1200 for the disks though, so if you don’t need that much, the $480 for 4TB may be more reasonable.

Even the 10TB is pretty reasonable at $42/TB and the density is incredible although if you think about with the 8TB at $316, you do pay a big premium for 10TB ($102 extra or $50/TB), so perhaps better wait.

Making a USB Boot Drive for MacOS Sierra

Well it’s time once again to make USB boot disks, I’ve been using Diskmaker X forever, but with Sierra, there are some idiosyncratic things:

  1. Download from the Mac App Store the Sierra download. This will take a while as it it is over 4GB, but this is the image that Diskmaker X uses.
  2. Make sure that you reformat the disk completely before starting. It doesn’t seem to like already formatted disks and crashes with an error about not being to make things.
  3. You now get notifications as it moves along which is pretty cool.