Data Wrangling workflow for TV

Data Wrangling Workflow

When working as a Data Wrangler your workflow is key. Note I say Data Wrangler, and not DIT. This is a simple reliable method of data wrangling for storage, not a complete Digital Imaging Technician. As an Edinburgh based camera operator with experience as a data wrangler this is my personal work-flow, and as such each person will seek to make their convention their own. Whatever your work-flow, it is important that you stick to it. When backing up your rushes it is very important that the naming convention is correct. Be meticulous. I’ve seen first hand what happens when people are cack handed with their cards and at best it involves alot of stress and drama between the shoot and the edit with people questioning if footage has been lost – and at worse you really have lives oit your worst nightmare!

Into the Realms of the  DIT Digital Imaging Technician

I have worked as a professional camera operator and editor, but the types of  camera technologies you will come across may be far greater than my day-to day and include Arri Amira, Red Scarlet Dragon, Varicam LT and the Canon C300. ShotPut Pro is an automated copy utility application for video, audio and photo files. At $129 it is widely used and trusted by film and TV professionals. They have other useful products like PrimeTranscoder but I typically just use MPEG Streamclip. Many of the DITs I know will use Film Convert for camera profiles, Da Vinci Resolve for grading and Plural Eyes for syncing up cameras (if required), and Scratch for reviewing rushes.

Data Wrangling Equipment

13″ Mac Book Pro Retina Display

x2 2TB Rugged Lacie (Thunderbolt)

2x 8TB G-raid (in the office)

XQD card reader (for Sony FS7)

Workflow as a Data Wrangler on ShotPut Pro

You will create your naming convention within ShotPut Pro.

Everything must be copied via Shotput Pro, and you must copy THE WHOLE CARD, and not touch the folder structure within the card. We need an exact copy of the card in its entirety. Please adhere to the following naming convention exactly as follows, it is so important that this is correct.




Camera Codes:

FS7 – Sony FS7

AMIRA – Arri Amira

RED – Red Scarlet Dragon

VCLT – Varicam LT

C300 – Canon C300

FS700 – Sony FS700

ME20 – Canon ME20

SELEX – Selex

A7S – Sony A7S

GH4 – Panasonic GH4

D500 – Nikon D500

GP – GoPro


ShotPut Pro version 6

Backing up with ShotPut Pro version 6

Begin by connecting the 2 backup (destination) drives and the raw media (source) dri ve or card. Then launch ShotPut Pro and open the ‘Preferences’ menu.

Please ensure that the above settings are set. Backing up – Setting the offload destination Double click on ‘Presets’ in the bottom left hand corner.

In this Window you can change your Preset Title to ‘Default Offload’ It is in ‘Custom Text’ that you create your naming convention At the bottom of the window in ‘Filesystem Offload Destination’ add the 2 drives that you are backing up to. Please ensure that the below settings are set.

Once you have set the preset, drag and drop your card onto ‘drop files here’ You must drag and drop the whole card, do not open the card and pick out files. When the whole card appears in the main window, hit the play icon in the top right. The offload status will begin and appear in top right.

Camping at Rannoch Moor

Yesterday I was filming at the Glencoe Marathon for the official partner, the Cystic Fibrosis Trust so I took the opportunity to I camp solo on the Rannoch Moor. This boggy expanse is a piece of real wilderness, unlike any other in Scotland. In the darkness, out of my pocket fell my iphone, amazingly I retrieved it, half submerged from a bog. Thankfully I can confirm the iphone in a bag of rice really does work. I had hoped to be filming a morning timelapse but the weather’s promise quickly disappeared after sunrise, with only a distant glow somewhere over by the Ben Lawers range.

Billed as Scotland’s toughest – the Glencoe Marathon saw me chase runners through some stages of their epic trail run through the heart of Glencoe and into the foothills of Ben Nevis. It was a very exciting event with a spectacular (if very wet) location. The resolve of the competitors was fierce as they all braved the wet and winds to raise money for a worthwhile cause. I think next time I should aim for the That would be quiet an achievement judging by the route which takes in the Devils  staircase en route to Kinlochleven. I think I’d need to work up to that.

After the shoot I stopped off at the Boots Bar at The Clanchaig Inn for some food – I think it’s going on my personal top 10 pubs in Scotland….

Prince Charles / ITN News in Scotland

Prince Charles on grandson George’s first day at school

Shooting for ITN News in Scotland we caught a quick interview with Price Charles and recorded the Royal Editor, Chris Ship’s video report.

Speaking to ITN News about his grandson’s first day at school, Prince Charles joked to Royal Editor Chris Ship that he had not given the youngster any advice ahead of his big day as he “wouldn’t take it from me at that age”.

The Prince of Wales added that school is “good” for children, jesting that it is “character building”. He continued he “hoped” that George would be happy at his new school, and empathised with the “poor old thing” who appeared anxious as he walked into his new school to join the rest of his reception class.

The 68-year-old conceded that “at that age you don’t worry quite so much about going to school as you do when you get a bit older” and the “business of meeting new people.”

Lighting Up The Queensferry Crossing

Filming this Queensferry Crossing film as one filming unit of seven for Speakeasy Productions we collectively filmed the lighting up of the Queensferry Crossing. I was based a North Queensferry and filming on Canon C300 mk2 we pushed the ISO to 10,000 to get these images.

The First Minister of Scotland Nicola Sturgeon led a procession of vintage and modern vehicles on to the new Queensferry Crossing – the stunning new Scottish icon which opens to traffic on August 30 2017. She thanked the workforce for their amazing efforts before truly turning the spotlights on the third Forth Bridge

Heriot-Watt University

This university video production was shot in collaboration with UAV drone operator Peter Keith for Tanami video production. I used my Sony FS7 together with my steadicam to create the look the clients sought. We filmed across Edinburgh and Galasheilds in the Scottish borders, so travelling light was key – one bag and and a DG Glidecam were used to create the cinematography style required.

Created for the School of Textiles and Design, this video for Heriot-Watt University shows just how accessible the Galashiels campus is from Edinburgh city centre. Featuring Heriot-Watt students, Tanami captured footage using two camera crews, including a drone pilot.

Ryan Blackwood is a freelance camera operator based in Scotland experienced across TV, Documentary, Corporate and Commercial work.

HSBC Cycle Ride

This HSBC Cycle Ride promotional video was commissioned by British Cycling to promote the HSBC Cycle Rides taking place in Edinburgh and Glasgow.

“This is a huge moment for cycling in Great Britain,” said Ian Drake, CEO of British Cycling. “Working together with HSBC UK, we will provide the encouragement and opportunities to make cycling the most popular activity and sport of choice in Great Britain. We want to help transform an increasingly inactive and unhealthy nation through cycling.”

British Cycling and HSBC UK will deliver events and programmes across local communities, towns and free to enter mass participation events to get millions of people on their bikes.

Edinburgh Zoo’s Trainspotting

Edinburgh Zoo’s Trainspotting – a recreated a homage to the original 1996 cult film Trainspotting and the iconic ‘Choose Life’ scene that kickstarted Danny Boyle’s career. I shot and edited this campaign for Stripe Communications and it was definitely one of my more unusual days out….

‘Choose Scotland, choose Edinburgh, choose visiting the giant pandas, choose meeting a meerkat, choose brilliant birds, choose the penguin parade, choose Tiger Tracks, choose a great day out, choose Edinburgh Zoo!’

Shaun Bell of Stripe Communications was thrilled with the campaign which has  received over 160,000 views and 2,000 likes!


Spittle of Glenmuick wildlife shoot

Over the weekend myself and David climbed the White Mounth Munros circuit, a 29km hike taking in five munros: Lochnagarger, Carn a’ Choire, Bhoidheach, Carn an t-Sagairt Mor, Cairn Banish and Broad Cairn (which barely qualifies as a Munro). Filming with my Sony FS7 camera I captured Red Squirrels, Meadow Pipits, Pied Wagtail a lovely little Siskin feeding on Pine seeds, a Song Thrush and some very fast House Martin.

During the drive we drove up the highest public road in the United Kingdom the A93 at the Cairnwell Pass. On the drive we spotted a Grey Heron, but by they time we had a chin-wag with the landowner we was off. After leaving through Braemar we saw a strange lenticular cloud formation over Balmoral Estate – the kind of clouds that look like a UFO…

During the eight-hour hike we observed a Red Grouse and briefly caught a glimpse of a Mountain Hare bounding away. The route was long and we didn’t take camera kit the distance! You could drive as far as Glas Allt Shiel – a bothy on the Queens’s Balmoral estate, but we skipped the royal invite and camped in the popular Spittle of Glenmuick, this lovely upland moor at the back of the Balmoral estate is teaming with wildlife. It was an excellent place to camp with toilet facilities and the local mountain rescue team based there.

Jackie Kay poetry

Brian Cox reading Jackie Kay poetry for Visit Scotland. Emmy award winning actor of stage and screen Brian Cox has read Jackie Kay poems as a part of a new Visit Scotland campaign. Very proud to have meet and worked with two of Scotland’s finest cultural contributors!

Dawnings music video – ‘Activate It’

Director: Uisdean Murray
Production Company: Lily Island Films
Video Concept:Louise Quinn & Bal Cooke
Client: Tromolo Records.

This track is from the theatre show Music is Torture which is touring Glasgow, Edinburgh and Inverness from 18 May to 1 June. This new piece of gig theatre tells the story of a struggling music producer, Jake, who discovers that his music is being used to torture political prisoners and charts his ensuing moral dilemma. Essentially a show about selling out, while also reflecting on how people respond to global conflict and how people respond to fear of terrorism.

Jake – Andy Clark
King Of The Insiders – Ronni Menzies-Stirling
Queen Of The Insiders – Louise Quinn
Horse Head Man – Bal Cooke
Sports Casual Shaman – Steven Westwater
The Philosopher – Robert Henderson


Louise Quinn
Bal Cooke
Robert Henderson
Steve Westwater

Makeup – Emma Cunningham

Produced by Tromolo Productions with support from The Space

Thanks to Tron Theatre

Scottish music video

Wildlife lenses for the Sony FS7

 Telephoto lenses for wildlife

Most long telephoto wildlife lenses are out with the price bracket for many people. The Canon 70-200 is the ideal entry level wildlife lenses, but following on from there we investigated the options available. I’m not including macro lenses for really close up wildlife, but rather will run through a few long lens set ups fo aspiring wildlife filmmakers. In Britain some of the best wildlife to be found on our shores are the amazing array of birds, and to get them you need to go long or go home. Something like the 25-300mm Cabrio T3.5-3.85 is what would be top of many filmmakers list, but assuming you don’t have £35,000k to blow, here’s some other options to get started….

Assuming require a lens of at least 300mm and as fast as possible here are some wildlife lens options…

Canon EF 100-400mm f/4.5-5.6L mk2

£1,600 NEW or you could get a mk1 2nd hand for £650

The Canon EF 100-400mm f/4.5-5.6L mk2 is a compact, high-performance  zoom lens that’s ideal for action and wildlife. A 4-stop Image Stabilizer and high-quality optics deliver superb sharpness. We use this camera lens primarily for wildlife camera work for the Sony FS7. It’s super sharp, lightweight and used together with the Metabones Speedbooster Canon EF to Sony E Mount it’s an excellent solution for wildlife filmmakers and photographers.

With this FS7 wildlife setup this makes the lens equate to a 1.1x FOV crop so makes it like a 110mm to 440mm. You can also use it with our other Commlite  adapter (EF- NEX) and this increases the magnification further, but can sometime have the drawback of not being able to change to iris after a lens swap – so you may be restarting the camera during that crucial moment. The Commlite  adapter makes the angles of view equivalent to a 160-640mm on a full-frame camera.

On our Sony FS7 and shooing in 2K crop mode (because we like 150fps rather than 4K!)  adds a further x2 magnification, so this lens extends to up to 1280mm – ideal for bird and wildlife photographer. Just remember and pick up a very heavy duty tripod. We shoot with a Sachtler 18P which is heavy duty but light enough to carry together with the camera.

For me this lens trumped our old one for travelling light and I was surprised to discover it was even sharper than our trusted Canon 70-200mm lens! Of course also the Image stabiliser is a MUST for shooting wildlife video.

Sigma EX Telephoto Zoom Lens for Nikon F – 300-800mm – F/5.6 – 6.3

£6,500 NEW or £2500 2nd hand

The Sigmonster was the last wildlife lens we used, but it was too long and too heavy for our requirements one the Scottish Hillside. We used this again with the 2K crop function and a 1.4EX Teleconverterto achieve a whooping 2240mm. This is a lens for hides, or if your on the move you will require assistance.

Adding a DG Teleconverter you can use this lens as a 420-1120 mm F8 MF ultra-telephoto zoom lens with a 1.4x EX Teleconverter, or as a 600-1600 mm F11 MF ultra-telephoto zoom lens with a 2x EX Teleconverter.

Canon EF 500mm F/4.0 L IS USM EF Lens

£6,600 NEW or £4000 2nd hand

Two stops faster than the Sigmonster and probably an extra £2K, this lenses is a prime and offers two-speed Power Focus mode allows focus to be adjusted at a smooth constant speed – perfect when shooting video. The Canon EF 500mm f/4 L IS II USM is a super-telephoto lens with integrated Image Stabilizer technology and a fast f/4 maximum aperture. It features a lightweight magnesium alloy and titanium construction, and its optical design includes fluorite and UD lens elements to tackle aberrations and distortions.

Camera Support Systems

The heavier the setup, the more reliant on a strong camera support system you’ll become. If your a photographer go away and look at some gimble heads – but for video you need to move from 15mm rods to bridge plates with 19mm rods. Everything just adds to the weight of your gear in the field, but it’s required unless you want amateurish, shaky footage.


Dolly: The world’s most famous sheep

In July 1996, scientists at the Roslin Institute created the world’s first animal cloned from an adult cell.
Dolly the sheep was created in a laboratory using an adult cell taken from one sheep to fertilise an egg from another. The fused cell was then implanted into a foster mother.

It was a breakthrough in the history of genetic engineering. Researchers hoped it would enable new ways of treating debilitating diseases, but critics were worried it opened the door to human cloning.
Sir Ian Wilmut led the team of scientists.

You can watch Witness a these times on BBC World News.

Witness the stories of our times told by the people who were there.

Visit Jambi this Halloween at Edinburgh Zoo

Here’s a short promotional video for the Tiger Tracks enclosure at Edinburgh Zoo. Jambi is a male Sumatrian tiger and in the wild they’re found on the Indonesian island of Sumatra. In 2008 as the population was estimated at 441 to 679 individuals. The population suffers because they require natural forest area, and tend to use areas closer to forest centres – which are in decline due to human agricultural – largely palm oil plantations – destroying their natural habitat.

Through the RZSS – a conservation charity on my doorstep – Edinburgh Zoo are taking practical action on the ground to study and protect wildlife.

conservation information



PBS Newshour – Jackie Kay

Filming for PBS Newshour, Ryan Blackwood is an Edinburgh based broadcast cameraman. Working for PBS Newshour anchor and senior correspondent Jeffrey Brown. I love getting to shoot as a news cameraman, it’s such an honour to shoot for real broadcasters historic events like Scotland’s referendum coverage.

We were filmed an interview with Scotland’s makar Jackie Kay at Stirling University as a part of PBS’ Newshour.



Tiger Tracks at Edinburgh Zoo

I spent a couple of hours testing the 150fps slow motion on the Sony FS7 camera at Edinburgh Zoo. Jen and Olly got to see  Jambi, the magnificent male tiger up close through the new Tiger Tracks enclosure.

The Sumatran tiger is a subspecies of tiger found only on the Indonesian island of Sumatra and it is estimated that fewer than 400 of these majestic tigers are left in the wild. In 1978, experts estimated the population of Sumatran tigers at 1,000. Whilst these tigers are protected by law in Indonesia, increased deforestation and poaching has led to their significant decline and, without help, the Sumatran tiger faces the very real threat of extinction.

Don’t think changing to a tasty eco palm-oil free peanut butter can really make a difference. Only lobbying your politician or support an organization campaigning on these issues can really help at this stage. Fewer than 400!

Support an organisation like the WWF to donate to help stop poachers from killing these beautiful animals.

Edinburgh Int’l Film Festival Trailer

The Edinburgh Int’l Film Festival will take place between the 15th-26th of June, now in its landmark 70th edition the festival trailer brief was to include as many of the films as possible. It was cut in 4 days and I love the creativity of this type of fast paced job, where you’re collecting up all these films and create new meaning and association out of the clips. Hopefully it has a nice balance of fun and creativity and will encourage people to check out the festivals selection for 2016.

The project was edited on Final Cut Pro X and I was able to include 112 films (I think probably the most ever included in the EIFF trailer) and I confirmed everything to fit a 2.35 aspect ratio. I worked as the Digital content producer for the festival in 2011 and I know from experience what a hard, but incredibly rewarding job creating the trailer can be. 5 years ago things were alot harder with most of the films being a nasty mix of frame rates, aspect ratios, formats and codecs so made it a big editing challenge.

For the 2016 version the quality of the films and editing software allowed to to push passed technical issues much quicker, to get to the funs stuff – choosing and position clips including Trainspotting and childhood favourite E.T. The Extra-Terrestrial. It’s a mountain of content to sift through and to cut films of these caliber down to a two or three shots is tricky. But my hope was to not choose really obviously shots and link them well where possible. Hopefully people like my toilet humour 😉

Get to know: Glasgow

Get to know Glasgow, one of Scotland most vibrant and exciting cities. Great food and drink, incredible culture and nightlife: it’s also famously friendly. Produced by Visit Britain this film was shot over the 5 and 6th of August with directed by Mark McKenna. It was a a fast paced most shoulder mounted shoot, filming at over dozen venues a day. From foodie places like the legendary Ubiquitous Chip and the super-cool Stravaigin, to Porter and Sons the Oran Mor and The Finnieston – where I had the freshest, tastiest  fish I’ve had all year! To display the city’s cultural wears we visited the Kelvingrove Art Gallery, the hyper-modern Riverside Museum and the People’s Palace and the Charles Rennie Mackintosh designed Willow Tearooms. I had never been to the Auchentoshan distillery before and we had a whistle-stop tour of the place. We also had a quick mixology lesson at the Corinthian Club before. I think Butterfly Films should shoot some weddings there, a landmark venue! The whole shoot was mesmerising, I felt like I got a full on Glagow experience during the crazy 2 day shoot. The film was shot using a Canon C100 with a Ninja Blade recorder and a Sony A7s with metabones adapter.


Mr Q and The Qatari Guy in Edinburgh

Khalifa and Hamad – aka Mr Q and the Qatari Guy are the founder of ‘I love Qatar’ and a stand-up comedian respectively. Digital Ape and Visit Britain wanted travel stories during their visit and highlight key moments of their trip in Arabic. 

Together with Digital Ape and Visit Britain we filmed a series of films as a part of a wider campaign promoting Britain to the GCC countries – Saudi Arabia, United Arab Emirates, Quatar, Bahrain, Oman a

Erasmus+ Conference videos

Yesterday I was the Erasmus+ annual conference 2015 which was held at the John McIntyre Conference Centre. I  was working with 20/20 newbie, producer Andrew Botros and we shot 9x 2-3 minute individual interviews as standalone videos and lots of shots of people engaging at the conference.

Isle of Skye video shoot

This is a completely unofficial edit I did too see what I shot earlier this week I was filming on the Isle of Skye on behalf of CompassLight Productions. The video shoot involved filming at Sabhal Mòr Ostaig (Gaelic College), the Clan Donald Centre at Armadale and Gaelic Whiskies. The goal was to capture authenticity and interactions with the locals. CompassLight wanted to provide an authentic picture of the locales visited – energetic, bustling, lively and off-the-beaten-path. Using my travel days I explored more of the north of the island, at the Cuillin mountains and ranged as far north as Portree and the Old Man of Storr.

2015-09-06 16.45.37

2015-09-07 07.19.27

MoneyWeek Interviews

Last night I was filming a 30-minute interview and some vox pops for MoneyWeek. The interviewer was Merryn Somerset Webb the Editor in chief MoneyWeek, who also writes for the Financial Times and the Sunday Post. I filmed her as she interviewed Gillian Tett, British author and award-winning journalist at the Financial Times, where she is a markets and finance columnist and U.S. Managing Editor. They discussed Gillian’s new book The Silo Effect: Why putting everything in its place isn’t such a bright idea.

It was a multi-camera set up shooting with a Canon C100 and a Samyang 85mm 1.4 (on Merryn), a Canon 5D mk 3 and a Canon 70-200mm (on Gillian) ands another Canon 5D mk 3 with a Samyang 24mm 1.4 (covering the profile wide). Unusually I used all three F&V 4000 LED Panel Lights, one on each of the contributors and another erring towards Merryn with the director of the windows, I also had a Dedolight behind each of them as a highlight with a half CTB gel for Merryn and a full CTB gel for Gillian.

My Times Plus event – Rugby World Cup

Last night I was working for London Based RiseMedia filming an exclusive My Times Plus event about the upcoming Rugby World Cup. The videos will showcase the entire event as acts as a teaser to entice potential subscribers. Scott Hasting answers questions with a panel of three other at the BT Murrayfield stadium.

I was filming with Mike Lienard and Dan Goodall who are producing a series of the film across the country. Long standing friends and talented filmmakers I wish I was joining the team on the road… Despite knowing nothing about rugby it was a really interesting talk, so I’m armed with enough information to make a better informed better on the Rugby World Cup winner now!

I was filming on the SonyPXW- FS7 care of Procam, sadly not at 180fsp – might have been overkill for this event. Our sound recordist was the talented Pete Smith

Right now I’m packing my bags as I’m off to prepare for a shot for Moneyweek tonight…

Prostate Cancer UK Scottish Senior Scottish Open

Yesterday I was filming the Prostate Cancer UK Scottish Senior Scottish Open at Archerfield Link Golf Course. Archerfield Link Golf Course is the latest venue for the running of the 23rd Scottish Senior Scottish Open. This year Prostate Cancer UK became the new title sponsor and they asked me to produce a promotionl video for next years event. The disease affects over 40,000 men in the United Kingdom and the charity hopes to raise awareness and target men through sport. Two notable people I had the chance to interview were England Test cricketer Ian Bothham and Alex Salmond. The former first minister took the time to have a photo taken and later that evening brought me his autobiography and signed it. A true gent.

Denzil Skinner & Partners video

Here is a series of four corporate videos I shot on behalf of Tanami for Denzil Skinner & Partners.

Edinburgh jewellers, Denzil Skinner & Partners provide a personal and discreet service in the design and creation of bespoke jewellery and silver commissions. Denzil and Amanda use their design expertise and extensive industry knowledge to offer considered advice and to guide you through the process of designing from new, redesigning unworn jewellery to create fabulous new designs and  engagement rings.

Page 1 of 212