Requirements :
– Eliminate the risk of data loss as good as possible
– Provide access to all assets even on the road
– Improve the process of searching / finding assets
– Keep costs low
– Keep manual low
– Process should also work once multiple photographers are working together

The solution:
– On the working machine (macbook pro) there’s multiple lightroom catalogs (archive and one catalog for each unfinished shooting)
– The archive catalog contains all shootings considered done (files sent to customer)
– A catalog for each unfinished shooting is required as we merge the catalogs into archive, this is way easier with individual catalogs
– The photographer always has a USB disk in the field, once the shooting is done the files are copied to the macbook pro and from there to the USB disk, if internet is available the backblaze agent is sending the files to the cloud over night (so raw files are on the camera flash, on the macbook pro, on the usb disk and best case on the cloud backup solution the day after the shooting)
– Once the photographer is home again, the lightroom archive catalog and the catalogs of the finished shootings are merged, the files are then copied (ONLY VIA LIGHTROOOM) to the NAS.
– The NAS is backed up to the USB disks once a week, the disks are stored in a secure location

Using this approach its very unlikely to lose data, even on the road the data is relatively save. Via cloud solution it’s possible to access all files at any given time in case there’s a internet connection available.

Keywording :

In order to save time in re-sending files to customers (one of the main tasks as I learned), we applied a very strict keywording concept.

Customer Name

Customers Project Name

Location

Date

Event Type

Private or Business

Final (only for files sent to customer)

This allows lightroom search queries like : wedding peter weggis final
This reduced the effort to resend files from minutes or hours to seconds.

I was searching for a visualization of the pats involved in a web link. I did not come across a picture covering all the terms I see as relevant.
The picture below is a screenshot of a Google Document Table, I apologize to not have a more professional visualization but it was sufficient for my needs.
It explains what a web link consists of by listing everything which could be used together with a website, in this particular case URl, URI, URN, Host, Domain, TLD, Port, Resource Path, File, Querystring Parameter and Fragment Identifier.

I just recently bought a new computer. I was using OS X at home for the last 13 years without owning a single Windows computer. Anyhow, my requirements increased when I did start video editing using Adobe Premiere Pro.

This Spreadsheet will contain all my examples, the first one is a Pivot based on Region and Turnover with the Areas of Business which require attention (where we actually lose money) marked red using conditional formatting.

Current Example in Spreadsheet: “Region / Category”.
The advantage of manual pivots from my point of view is the fact the query could be adjusted and it stays dynamic as when we use UI pivots and change the filter new values are filtered out automatically.