[vc_row][vc_column][vc_column_text]I recently had to dust off the part of my brain that has the FTP commands branded into it. I had to move large Automotive Aftermatet data from Opticat to an ETL server. Here’s how I handled it

ftp
open ftp.scalene.group
username/password
passive
bin
hash on
hash mark per 1024 bytes
prompt off
mget *.*

This is a really insecure promote. Remember kids, always use SFTP/SCP.[/vc_column_text][/vc_column][/vc_row]

Originally published at Scalene Group.


Filtered email inbox demonstrating that Amazon emails stopped specifying the item purchased or shipped and now only show the order number
Filtered email inbox demonstrating that Amazon emails stopped specifying the item purchased or shipped and now only show the order number
We used to buy things, now we buy numbers.

In the first half of 2019, and for years before, when I completed a checkout on Amazon, they would send me one email (from auto-confirm@amazon.com) confirming what I’d ordered, and a second email (from shipment-tracking@amazon.com) telling me my order had shipped, when I could hope to see it arrive, and what the tracking number for it was. The whole process was as straightforward as those email addresses. …


  • ACES = Aftermarket Catalog Exchange Standard. Industry XML standard for the exchange of automotive product applications data.
  • Brand Table = Brand Identification Database. Industry standard reference database of brands, brand owners and their parent company names.
  • Core = The rebuildable portion of automotive components, such as starters, alternators and carburetors.
  • Fitment = Compatibility of a part/product to a vehicle.
  • Notes = A note about a part. A note is firment (YMMSE) specific
  • PAdb = Product Attribute Database. Industry standard reference database to be used in conjunction with PIES.
  • PCdb = Product Classification Database. …

I recently purchased a video from Pond5. It was a great UX. I will be coming back again. Anyway, I grabbed the ProRes version of the video and converted on my 2017 MacBook Pro.

First I installed FFmpeg. There’s a Homebrew formula for it.

brew install ffmpeg

Then I found Google’s Recommended Settings for VOD. They have a good snippet to safe bet for a broad range of web and mobile devices.

ffmpeg -i 010575736-kids-children-play-cardboard-b_prores.mov -vf scale=640x480 -b:v 750k -quality good -speed 0 -crf 33 -c:v libvpx-vp9 -c:a libopus kids-children-play-cardboard-box-1960s-vintage-retro-film-home-movie-1990-640x480.webm

Originally published at Scalene Group.

About

David Gitman

Technologist. Partner at @coopersqv. Brooklynite. Aspiring stand up philosopher.

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store