Preface: Computers should be flexible enough to easily bend them to our needs, at least when it comes to reducing time spent on repetitive computing tasks. In my case, that means a work environment where I can find and manipulate information about book projects under review, whether files, emails, or database records. In an ideal world, I'd type in a name, and pull up all of the database records, emails, and file folders relevant to that name. But my files are stored on my hard drive, the emails are on Google, and the databases are in FileMaker Pro. One of my long-term projects is linking these together in some fashion so that I make my dream come true. (There's a lot of website that help programmers set up an integrated and efficient environment, but I haven't found much for helping editors.)
A previous attempt: Last year, I set up a private FMP database on my desktop that linked to all the other databases I use. Through various APIs, it also could search Gmail, various file storage platforms that I use, and even include a link to the folder on my hard drive where a project could be stored (clicking the link would open the appropriate window on the desktop). I also created a field to enter a single search term, connected to all of these resources.
Now, instead of typing a name into my computer's search function, waiting for it to pull up a list of possible results, then selecting the correct folder,
then typing the
same name into the database to pull up the book's record,
then typing it
again into Gmail to pull up relevant emails... it was all there with one search. The amount of time I saved typing must have been phenomenal. The only downside was that I had to enter the link to the local hard drive folder manually for each project.
Then I had to change the path all my projects were stored at. Suddenly, all the links to local files were useless! It was back to an extra search on the local hard drive again. And I felt no inclination to re-do all the hundreds of links already extant.
A new hope: This time, I wrote a bash script that opens the given folder on the desktop. Then I aliased it to the brief command "po" (short for 'project open'). It's much faster than the computer's built-in search function, since it's only searching a single directory:
#! /bin/bash
PROJECT_PATH='<insert your path here>'
open "$PROJECT_PATH""$(ls "$PROJECT_PATH" | grep -i "$1")"
Now, if I want to open a project's folder, I just go to the terminal and type "po <search term>". It's still an extra step compared to my ideal, but it's faster than... Oh, I mentioned that. But really, it's pretty snappy!
My next step will be to see if I can convince FMP to run the command when I type a search term into the given field. Then I'll be back to my original setup, with the additional advantage that I won't have to enter links manually anymore!