Thanks Adam. I'd never even heard of SED until you mentioned it earlier. Combining that with your suggestions to another person I've now got a list of all the files in my old Pictures directory that are not in the shotwell database:-
As you said, generate the list of files in Shotwell DB % 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 % Use sed to strip the path from each line in the list, then sort:- % cat photolist | sed "s/.*\///" >shortlist % sort shortlist >shortlist1 Generate the list of files in my old Pictures folder: % find /media/old/Pictures >filelist Again strip the path and sort:- % cat filelist | sed "s/.*\///" >filelist1 % sort filelist1 > filelist2 Compare the two files:- % comm -23 filelist2 shortlist1 Thanks for your help. Chris -- View this message in context: http://shotwell.3510.www.nabble.com/Import-failed-But-which-files-weren-t-copied-tp29533p29588.html Sent from the Shotwell mailing list archive at Nabble.com. _______________________________________________ Shotwell mailing list [email protected] http://lists.yorba.org/cgi-bin/mailman/listinfo/shotwell
