Viewing catalogue in SQLite viewer/editor
If you open a Capture One catalogue file in an SQLite editor/viewer, how/where do you find the file paths for referenced image files? I've tried opening it in DB Browser for SQLite but I couldn't find the actual file paths.
-
Tables -> ZIMAGE ->ZSIDECARPATH
Hope that helps,
Kassur
1 -
> Thomas Kyhn: how/where do you find the file paths for referenced image files?
What is your starting point, just the name of an image file and you want to find the path? A parallel to "Show in Library" or "Show in Finder" (or in Windows Explorer)? What do you want in a query result, just the (full) path?
I use C1 Pro v20 on Windows and the following quickie appears to return path elements for image files where the image name starts with "Manila". You should probably replace p.zwinroot with p.zmacroot
SELECT p.zwinroot,p.zrelativepath, i.zimagefilename FROM zpathlocation AS p
join zimage as i ON i.zimagelocation = p.z_pk AND i.zimagefilename like 'Manila%'
where p.z_ent=(select z_ent from zentities where zname='PathLocation')0 -
OddS. you are absolutely right -. I've made a mistake. ZSIDECARPATH is for the preview file. Sorry!
Kassur
0 -
ZIMAGELOCATON in ZIMAGE Table points to ZPATHLOCATION Z_PK. ZMACROOT pointing towards Mac Volume and ZRELATIVEPATH to the path.
0 -
Thanks for your replies! With your help, particularly the last post from Kassur, I've managed to find what I was looking for.
I my current catalogue, more than two thousand images appear at least twice, both offline and not offline. There are no missing/offline folders listed in the Folders section of the Library tab, so it's not just a question of relocating a number of missing folders. As far as I can see, all of the missing image files are listed in the catalogue as located in a top folder that only contains other folders which then contain the image files.
The only way to relocate the images files in Capture One is one at a time. So it would be useful if I could edit the wrong ZIMAGELOCATION numbers elsewhere.
0 -
Glad that it helps you!
Greetings,
Kassur
0 -
This was very useful to me to help transfer a selection from one catalogue to the other (the images being copied in both, but not the same physical files)
I share it, my use case being useful for everyone who 's having the need to get a text list of file names
This what I did, adapting the above command.
1. Open the C1 catalogue you want to transfer the selection from, with your SQLite editor/viewer
On a Mac , you need to select your catalog in the finder, open with right click: show package content, then drag the .cocatalogdb in the DB Browser for SQLite panel called "Database structure"
2. Get the file names of the collection you want to use, say, it is called "MyCollection", by issuing the right command
This worked:
Paste following line in the panel called "Execute SQL" the press play
SELECT i.zimagefilename FROM ZCOLLECTION AS p
join ZIMAGEINCOLLECTION as c ON c.ZCOLLECTION = p.z_pk AND p.ZNAME like 'MyCollection%'
join ZIMAGE as i ON c.ZIMAGE = i.Z_PKSelect the result and copy it : you have your text file
3. Go back to C1 in a catalog where these images are already present. In my case I have a global catalog with everything in it. In the "every image" collection use Selection /select by... Filename list
Paste your list of names
Then right clic Create an album from selection ...et voilà.
Of course, your filenames must be unique for this to work. If they are not, you can still manage it by suppressing the redundant files in the album created.
This can be adapted to filter any selection by any more complex query, not available in C1 native filters
Hope it helps.
Hugues
1 -
This one is a dirty dirty hack, for those trying to use the C1 collection structure to mimic aperture Projet structure. The problem : there is no way of knowing if an imported pic has been classified in a collection
Use
SELECT i.zimagefilename, p.Zname FROM ZCOLLECTION AS p
join ZIMAGEINCOLLECTION as c ON c.ZCOLLECTION = p.z_pk
join ZIMAGE as i ON c.ZIMAGE = i.Z_PKthen paste the result in an excel file.
it gives you the list of pics by file-name with the collections that are in.
With a dynamic chart you can spot the files that are in no customized selection. (list images in lines and look for nb of collections, or put collections as columns).
Really clumsy, but can help you easily find lost pics in your file structure on your disks.
0
Post ist für Kommentare geschlossen.
Kommentare
8 Kommentare