Jacob,
thanks for your message. I'm cc-ing the Shotwell mailing list on this
response since that's the best place for Shotwell-related discussion.
On 11/22/2010 07:35 PM, Jacob Van Luyn wrote:
Hi there.
I'm a big fan of the Shotwell project. I have been looking for a way
to organise my image collection via tags for almost a year now and
Shotwell seems to provide the best solution for me in that regard.
I have a small question: How do I go about tracking down files that
aren't imported into Shotwell?
The folder I am working with contains 3334 image files (according to
Nautilus and the results of "ls | wc -l"). There are no hidden files
in the directory. Of these images, Shotwell imported 3196. Impressive
to be sure, but those remaining 138 files are going to be a pain to
find if they don't appear in my collection in Shotwell. If those files
aren't supported, I'd at least like to move them to another folder to
keep them separated from the rest of the collection.
Is there a way I can find them using Shotwell's database or any other
method?
There's currently no way to do that inside Shotwell itself, but this
isn't hard if you're willing to look inside the Shotwell database. You
can generate a list of the filenames of all photos in your Shotwell
database like this:
% sqlite3 ~/.shotwell/data/photo.db
SQLite version 3.7.2
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> .output photolist
sqlite> select filename from PhotoTable;
sqlite> ^D
%
You can generate a list of all the filenames in your folder using a
command like this:
% find /home/me/Pictures > filelist
Now you want to see all the files which are in 'filelist' but not in
'photolist'. The classic UNIX command 'comm' can report the difference
of two sorted lists:
% sort filelist > filelist1
% sort photolist > photolist1
% comm -23 filelist1 photolist1
adam
_______________________________________________
Shotwell mailing list
[email protected]
http://lists.yorba.org/cgi-bin/mailman/listinfo/shotwell
