Check for broken MP4 file in PHP on Linux


I’m working on a project where MP4 files are FTPd over to a different server. This server’s job is to add a front and end bumper to the video clips automatically and host for user pickup. I needed to find a way to ensure that the source video had finished transferring and was complete before starting the process.
Continue Reading

Barclays Bike API data feed

I’ve been working on aggregating data regarding the number of Barclays bikes there are available at certain docks. I had tried using some third-party Barclays Bike API sources because I didn’t realise that TFL already had easily accessible data for this.
Continue Reading

Working out aspect ratios in Excel

Aspect Ratios in ExcelI’ve spent most of my time at work recently building a big ol’ database with specifications of screens. Once the structure had been completed, I needed to import all existing data (stored in an Excel spreadsheet) in to the database. I’ve build the database with a form where everything can be put in. Functionality of this form includes automatically calculating aspect ratios from width and height pixel dimensions – something that didn’t exist in the spreadsheet.
Continue Reading