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. ⚠️

Catalog Query

MilesF
I am building a 'Master Archive' from C1 catalogs for each year since I started shooting digital e.g. 2000, 2001.....2015.

The annual catalogs have referenced images and not imported images. I can thin these out and import to the 'Master Archive' catalog only those images that I want to include in the archive. I then aim to have every imported image in this catalog also part of one or more user collections. Using Projects, Groups and Albums gives me a good and easily navigated database.

Is there any way to find any images in the Catalog that are NOT also in a user collection ? I have a reasonably robust workflow but occasionally I find myself doubting whether an image has been added to a user collection. Obviously, those that are show up in the relevant collection but I would like to be able to search for any 'orphans' in the catalog that don't belong to a user collection at all.

Many thanks in advance for any suggestions.
0

Comments

1 comment

Date Votes
  • Bill Booth
    I was intrigued by your question. Here is what I found.
    The DataBase used by C1 is SQLite, so you need to find a program that will allow you to peek inside the DB. An open source program is available here: http://sqlitebrowser.org
    In your Finder, right click on the MasterArchive.cocatalog and select Show Package Contents. There you will find the database file ending in .cocatalogdb.
    I suggest you make a duplicate of this file, changing the extension to .sql and move it to your Desktop. (MasterCatalog.sql)
    Open the SQLite app and open MasterCatalog.sql file.
    Go to TABLE ZIMAGE and side scroll to column 13 labeled ZISINSIDECATALOG. Images that are inside a collection have a value=1 while those not in a Collection value=0. The top line of the table allows you to put in a Filter value, so enter 0 to see the image files that are NOT in a collection. If you are familiar with sql, you can create a new table from the last result. (CREATE TABLE `test` as SELECT * from `ZIMAGE` WHERE `ZISINSIDECATALOG` LIKE '%1%' ESCAPE '\' ORDER BY `ZISINSIDECATALOG` DESC LIMIT 0, 50000;)
    I would suggest that you do not try to alter things via the db manager, rather do them in C1. As you can see, there are many tables and who knows how many links to keep tidy.
    Hope this was helpful for tracking your orphan images. Perhaps you can message C1 to have them make a proper routine for this purpose.
    0

Post is closed for comments.