You are reading a single comment by @CYOA and its replies.
Click here to read the full conversation.
London Fixed Gear and Single-Speed is a community of predominantly fixed gear and single-speed cyclists in and around London, UK.
This site is supported almost exclusively by donations. Please consider donating a small amount regularly.
@CYOA
7 years later, similar question.
I have a new client and we're delivering as much content as we can to them per month - they'll pay for as much as we can give. At minimum this will be 40 still images and 10 x 5-10 second videos. Realistically this could be hundreds of images/videos per month. They already an archive in the hundreds/ Over time this will quickly become an archive of thousands/tens of.
Client needs a way to quickly find images for posting that doesn't rely on existing knowledge of archive.
Currently the client has a (to my eye) fairly sophisticated Google Sheets doc with various 'rules' that define naming conventions but essentially it's a fuck off great spreadsheet with long cumbersome file names such as:
McDonaldsSpicyChickenWinterMeltSmallFriesCokeWoodenTable.jpg
Apart from a Google Sheet with 10 quazillion rows is there an obvious way to make it easy to find stills or video based on what's in the picture?
I.e.:
Social Media Assistant wants to post image of something spicy that features chicken but doesn't know what exactly. They could filter/tick a few boxes that whittles down a selection of results to a few useable examples? Categories could be:
Merchant (McDonalds), Item (Spicy Chicken Winter Melt), Sides (Small Fries), Drink (Coke), Setting (Wooden Table) - perhaps also Media (Still/Video/GIF etc).
I'm open to the idea of pitching hire of a developer to create something bespoke but is there anything straight out of the box that's immediately user friendly? They use Google Apps for Business so if it's an app or something that can be incorporated that'd be marvellous - the media is realistically going to be stored on Google Drive so would be good to have it all under one roof (the search results could return a link to the actual file for example rather than just a file name you have to take back to Google Apps and manually search).