This actually is a very similar task on Windows and Linux.
Note: This assumes you have ExifTool installed such that it is found through “$PATH”
Open a command shell, in the shell type
Windows: Type the drive letter for the device where you have your photos, e.g.
P:
and hit enter.
Now
cd dir-for-photos
… and this – all on a single line, any line wraps shown here should be replaced by single space chars:
exiftool -r "*" -printformat '$DateTimeOriginal,$aperture,$shutterspeed,$iso,$model,$lens,$filename' >PhotoList.csv
Windows: type ”
cd
” and hit enter
Linux: type ”
pwd
” and hit enter
Use the means necessary to copy what cd/pwd (above) displayed.
Close the shell by;
Windows: type ”
exit
” and hit enter
Linux: press CTRL-D or type ”
logout
” and hit enter
Open OpenOffice calc (or Excel for those that have Office available)
Select File > Open from the menu
Paste the path you copied above into the file portion of the dialog for selecting files, hit enter or use any other means to make that path be the one you’re viewing; so that you can select to open the ”PhotoList.csv” file, hit enter or click “OK”, “Open” or whatever the display may show, for opening the file.
Now, you should be prompted with the text file import dialog.
Make sure you’re NOT trying to use fixed length fields, the choice should be “Delimited” or similar – click “Next”
Now, make sure the “Comma” delimiter is selected (others shouldn’t matter), then press OK.
The contents of the Sheet should now be a set of nicely separated colums with the information from the file.
Now, from here on you can treat the contents as any other spreadsheet, summarize using the available functions.
Simple means:
Insert rows above the top to make room for summaries.
Enter “=SUBTOTAL( 3 ; A2:A99999 )” in a cell to make OpenOffice tell you the count of visible cells in the range (Excel needs that first “3″ to be “103″ instead). Here you need to adjust “A2″ to be the actual start-cell of the leftmost column of the table and “A99999″ to be the end row of that column, for a correct value to be calculated.
Now Select the entire table (columns and rows, including the header row – assuming you added one!) by dragging with the mouse, then find Autofilter in the menus and turn it on.
Now the small drop down buttons in the title row of the autofilter region will allow you to filter out items using “Custom filters” (and a set of others too, depending on software version).
Depending on what you select to filter on, the above ”subtotal() ” will show the number of items displayed.
Good luck!
