Skip to main content

⚠️ Please note that this topic or post has been archived. The information contained here may no longer be accurate or up-to-date. ⚠️

How to find photos that don't belong to albums

Comments

6 comments

  • peter Frings
    Hi from another Aperture refugee.

    Deleting images from within an album
    Short answer: NO.

    But, in a catalogue with referenced images, you can create a smart album to collect the 'tag = Red' images. You can delete those images from within the smart album (I use the Cmd-Del shortcut). This moves the images to the system trash.

    I don't know whether this works for sessions or managed catalogues.


    Finding unassigned photos
    Short answer: NO.

    I think that this is one of the most asked-for features.


    Assign color tag on import
    Short answer: YES. But…

    You have to make a preset for this. Set the tag on a picture, then, in the metadata tool, select "Save User Preset" from the "manage" icon (2nd from right). Select the properties you want to save (the tag comes to mind 😊) and give the preset a name.

    You can then select that preset in the Import window. if you want to do other stuff on import via a preset, you have to make a combined preset. C1 only allows you to select 1 preset in the import window.

    HTH,
    Peter.
    0
  • XCL
    Hi Peter,
    Thanks for the tips.
    I now have a DeleteMe smart folder in my user collection and a brand new user preset to be used on import. 😄
    (I was looking for something along those lines but couldn't see the option to create a preset from within the Import window itself. It didn't occur to me to create the preset using an existing image - Duh).

    This is also giving me hints about how to look for solutions in CO. That's greatly appreciated.

    Xavier
    0
  • dev null
    Technically, though it is ridiculous to have to do it this way, it looks to be possible to find photos that are not in a collection (album etc.).

    The .cocatalog file is a SQLite 3 database. It looks like if ZIMAGE table row primary key is not in ZSTACK table ZPICKEDIMAGE column, and the ZIMAGE row ZISTRASHED is 0, then image has not been added to any collection and it is not in trashbin. So then one can find image location etc. but I'll have to see if I can make anything sensible with it. List of file names is not that helpful. Maybe I could add those to a pre-specified ZCOLLECTION via ZSTACK and ZSTACKIMAGELINK (ZSTACKs seem to be stacks of 1 in my db). And then, if all goes well, they'd show up in the collection when C1 is started (and it better not be running during this). For a quick clean-up done rarely, it might be tolerable. Or maybe feed the file list to AppleScript if C1 even offers enough functionality to add the files to a collection. Finding the image by name should be possible, as far as I recall.

    Seriously, would it be too difficult to add something to use in Smart Album rule to find stray images? Or even a way to list images in a collection in script?
    0
  • dev null
    If anyone really needs to find what images are not in any collection, quit Capture One 9, open Terminal and then open the cocatalog with sqlite3 command-line tool and run this SQL query and exit sqlite3:
    select ZIMAGEFILENAME from ZIMAGE where ZISTRASHED = 0 and Z_PK not in (select ZIMAGE from ZSTACKIMAGELINK);
    .quit

    One of the images I found with that was in smart album, so this query incorrectly finds images in those. Select All Images and search using the file name.
    0
  • peter Frings
    [quote="dev null" wrote:
    If anyone really finds to find what images are not in any collection, quit Capture One 9, open Terminal and then open the cocatalog with sqlite3 command-line tool and run this SQL query and exit sqlite3:


    Cool! You'd think it be a no-brainer to have a built-in function fot that!

    Thanks,
    Peter.
    0
  • XCL
    [quote="dev null" wrote:
    Technically, though it is ridiculous to have to do it this way, it looks to be possible to find photos that are not in a collection (album etc.).
    ...
    Seriously, would it be too difficult to add something to use in Smart Album rule to find stray images? Or even a way to list images in a collection in script?


    +1

    You've only made matters worse by showing how trivial it would be to get the information from the SQL database. 😉
    0

Post is closed for comments.