Bugs when importing Aperture library
I just imported my Aperture library, but unfortunately some things did not go so well:
1. No ratings at all
2. Everything is color tagged with "purple" - at least visually in the browser view - but under the filters there is nothing tagged as purple, but all the pictures are tagged with "none". Strange thing is, these "none"-taggings do not appear combined under the first item called "none", but as hundreds of new "none"s below the last color tag "purple"
3. Image rotation is converted all wrong. The thumbnails appear at first normal (portrait and landscape, how they were shot and appear in Aperture), but as soon as C1 starts building previews, it rotates all images in portrait format 90 degrees to the right
4. Movies have been imported without some of the metadata, especially the date information. Therefore all the movies are sorted at the end, when I have my thumbnail viewer sorted by date
I may get rid of #2 and eventually #3 by manual adjustments, but #1 is really terrible and I don't know what to do actually.
Anybody out there with similar experiences?
1. No ratings at all
2. Everything is color tagged with "purple" - at least visually in the browser view - but under the filters there is nothing tagged as purple, but all the pictures are tagged with "none". Strange thing is, these "none"-taggings do not appear combined under the first item called "none", but as hundreds of new "none"s below the last color tag "purple"
3. Image rotation is converted all wrong. The thumbnails appear at first normal (portrait and landscape, how they were shot and appear in Aperture), but as soon as C1 starts building previews, it rotates all images in portrait format 90 degrees to the right
4. Movies have been imported without some of the metadata, especially the date information. Therefore all the movies are sorted at the end, when I have my thumbnail viewer sorted by date
I may get rid of #2 and eventually #3 by manual adjustments, but #1 is really terrible and I don't know what to do actually.
Anybody out there with similar experiences?
0
-
My import went smoothly and worked as advertised.
Did you notice a difference between how raw files were imported vs. JPG?0 -
[quote="6BQ5" wrote:
Did you notice a difference between how raw files were imported vs. JPG?
No difference there. All the bugs reported above are independent of file type, camera model etc. Could not find any pattern at all.
UPDATE: I just exported one of my bigger projects as a new library file out of Aperture and ran the importer on this one into a new blank catalog and everything went fine this time. Ratings are there, portrait orientation is ok, clean color tags. The only issue still present is the missing date stamp on all the movies, so this seems to be a general problem of C1.0 -
I had the same issues importing from Aperture, and after a number of trials have managed to get my Aperture library imported properly, albeit with a few glitches. Here is what I've found:
First, my setup
Capture 1 Pro 8.1.1.20 for Mac, running on a MacBook Pro Retina on Yosemite
Aperture version 3.6
My Aperture library has approx 21,000 photos and about 1000 videos, all of which are referenced files (no photos/videos stored inside Aperture library, only the Metadata). The photos and videos are kept on an external USB3 drive.
My first attempt to import my full Aperture library succeeded in importing all 21k items, but with no ratings, no keywords, no cropping/adjustments, and hundreds of blank 'color tags' which don't exist in Aperture, so I assume that represents some incorrect parsing of the actual metadata.
I subsequently tried with a small subset of photos, exporting a single Album from Aperture as a new Library, then importing this into a new C1 Catalog. This worked marvelously; all photos in the album came across with the correct metadata, adjustments etc, and only the items in the album came across, as expected. I then set about exporting the rest of the full library in small chucks, broken up by folders. My Aperture library is set up as a single project with a folder for each year and an album for each month of the year. So I exported each year-folder as a separate Aperture library, then went to import each into C1. When I imported the first library created from a single folder (which should have had about 1000 images), C1 imported the photos within that folder correctly, with ratings, keywords etc intact. However, very strangely, it also imported the remaining 20k images that should not have been in that library, since I only exported the single folder!! (I assume this is some issue with the Aperture export, as the references to these images should not have even existed in the exported library.) And worse, for all the other images not in the exported folder, NONE of the metadata or adjustments came across. I tested this process over and over with multiple subsets of Aperture folders and always got the same result; Metadata/adjustments for the items selected to be exported came across including their folder/album structure, but the remaining items in the library came across without metadata/adjustments (just lumped under a single folder called "[projectname] Images").
Ultimately, I exported the entire PROJECT to a new library, by clicking the main Project folder in Aperture and then selecting all 21k items (with a filter set to exclude Videos), and choosing File... Export ITEMS as new library. I then imported that to C1, and (yippee!!) it worked! All the images came across, including the year-date folder structure, all metadata and adjustments. There were still some minor issues here though: I actually have a second Project in my Aperture library with just a few hundred photos, and although this was not part of the export, all of those images (and the project name itself) were imported to C1, again despite the fact that they should not have existed in the exported library. This was a minor issue for me since the second library is trivial. I had also excluded all Videos in Export selection, but those nonetheless showed up in the C1 import. BTW, Videos have NEVER come across into C1 with ratings or keywords, and I've not experimented much with how to get those across. (I may not even use C1 for managing videos anyway... still working on best option for that.)
The issue with ALL of the referenced images being included in the Aperture export is clearly an Aperture issue/bug, since C1 should not even know about those files if they weren't exported. If you can export individual albums and import those into C1, it seems to work wonderfully. Otherwise it seems you will need to export the entire project (or multiple projects if you have them) in order to get the metadata. If you have multiple projects and want to import them to C1 separately, one thing you could try is to make copies of the Aperture library and, using Aperture, delete all Projects but one from each, so that those projects won't be available for Aperture to export.
Hope that helps save someone a bit of time!!0 -
This may or may not help, but it probably can't hurt to clean up your Aperture Library before you do the import (first make sure you have a backup before you do anything!)... Close Aperture, find your Library file in Finder, hold Option-Command while double-clicking the Library... choose "Rebuild". 0 -
I actually ended up importing my Aperture library in smaller chunks, meaning I separated it at the top folder level into smaller library files (using the Export as new library function of Aperture) and then ran the C1 importer for every one of them individually.
The C1 importer seems to have problems handling bigger library databases from Aperture (mine was about 425 gig and 27.000 images). This has been reported by other users in other forums and internet discussions as well. The solution was always to make smaller jobs out of the one big job.
I think I'll file an official bug report to Phase One these days.0 -
My experience importing aperture libraries into Capture One (C1)
I started with a 50K image library and the import went fine. Based on this I prepared our major library 170K photos (containing 10 years of scanned slides as well as the work of multiple photographers). I ensured that there were no problems in aperture, including making certain that all referenced photos were present. It took six import attempts to succeed. As may be obvious from the size of the library, I wanted the file structure and the organization to remain intact. I did not want to hunt through and find 20,000 missing photos. I was less concerned with annotations or rankings being maintained. My main system hard drive was partitioned, so my initial attempts were not made from the system drive of the OS. This seemed to make a difference as one import actually completed - but there were no photos in the resulting file structure. I moved the Aperture library to the Pictures folder of the OS and started a new C1 catalogue in the same folder.
The final import was successful and I don't know why. We have a fairly robust setup. a 5K iMac with 32 GB ram. We were working off a 1TB HD with 700 GB free. I turned off as many OS operations as possible. Screensaver etc. I did not remove video files or break the Aperture library into smaller chunks.
I see that C1 will need to generate previews. It seems this action only occurs in folders that have been opened. If this process could run in the background that would save considerable time. I am impressed with the C1 rendering engine and the configurability of the interface. It was a frustrating few weeks to get the import to work, but now that it is finished I'm looking forward to working with Capture One.0 -
No problems here importing 45'000+ images (1.4 TB, 75% of it in RAW, 20% in JPEG and 5% movie clips format ) from a managed Aperture library. Most of them with all kind of adjustments, some with ratings, all with metadata, but I do not use keywords.
I admit that I did a lot of cleaning up my Aperture library before I did the import into C1.
I batch changed all the images names in Aperture and I let Aperture write down the logical file names to the original file name so at the end both are equal.
I cleaned out any files that C1 doesn't support.
I repaired the permissions, repaired the database and even rebuild the database (using cmd + alt at Aperture startup)
Then I did the import into C1 under some version 8.1.x and it went smooth.
But I have to confess that after a while I threw away that new C1 library afterwards. Why? I figured out that the C1 RAW converter was so much better compared to my image adjustments within Aperture (even using auto adjust settings in C1) that I wanted to rework all my images completely. And yes, that's a still ongoing process and not finished yet, but for me the effort is worth it and I like what all new possibilities and fantastic image adjustments C1 offers me now. And the image quality is so much outstanding compared to Aperture before (I am not at all saying Aperture didn't have it's value).
I exported all my originals from within Aperture (ratings and colours were not lost) to a new folder, projects and album structure on my harddrive. After that I imported that structure into C1 and I now have the equal user collection with groups, projects and albums as before in Aperture. And I went for a referenced C1 library instead of the before managed Aperture library for the benefit of having more control over my images backup and restore after a possible disaster.0 -
[quote="AndyE" wrote:
I figured out that the C1 RAW converter was so much better compared to my image adjustments within Aperture (even using auto adjust settings in C1) that I wanted to rework all my images completely. And yes, that's a still ongoing process and not finished yet, but for me the effort is worth it and I like what all new possibilities and fantastic image adjustments C1 offers me now. And the image quality is so much outstanding compared to Aperture before (I am not at all saying Aperture didn't have it's value).
I fully agree, I had exactly the same experience. I did not throw away my imported catalog, because I wanted to keep my organisation into projects, but what I did was filter all my images based on ratings and worked myself from five stars ranked ones downwards and re-edited all of them with the C1 Pro 8 engine.
The Aperture Importer should have some sort of option like choose if adjustments should be converted or if it should only transfer the assets and metadata and forget the adjustments, this would speed things up a lot I guess.0 -
Re movies: If you want the meta data in, you need to run a script (php, perl) to add them to the catalog. Had the same problem. 0 -
[quote="mercator" wrote:
Re movies: If you want the meta data in, you need to run a script (php, perl) to add them to the catalog. Had the same problem.
What kind of script? Where can I get it?0 -
You need to find a buddy, who writes it for you 😄
On a more serious note:
- Install exiftool (http://www.sno.phy.queensu.ca/~phil/exiftool/)
- Run the following from the command line (it is a php script). Assuming
- your account name is USER
- your script is called movreader.php
- your CaptureOne database is called DATABASE and resides in the users Picture directory
- your movie files are somewhere in the Pictures directory tree
call it as follows:php movreader.php /Users/USER/Pictures/DATABSDE.cocatalog/DATABASE.cocatalogdb /Users/USER/Pictures/
Do not forget the slash at the end of the last parameter.
If you have your movies in more than one directory tree, repeat for each top level directory the movies reside under.
Paypal me a beer or two 😄 -- I already have written way too many CO scripts as a newbie so far.
<?php
/*
MOVREADER: Add video meta data to Capture One Pro database
CALL: php movreader.php <Capture On Pro database file> <directory with files to check>
EXAMPLE: php missingfiles.php CaptureOne/CaptureOne.cocatalogdb /Users/SomeUser/Pictures/
THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN
THE SOFTWARE.
Copyright (C) 2015 by Helmut Kaufmann
*/
function traverseTree($base,$func){
$subdirectories=opendir($base);
while (($subdirectory=readdir($subdirectories))!==false) {
$path=$base.$subdirectory;
if (is_file($path))
$func($path);
else if (($subdirectory!='.') && ($subdirectory!='..'))
traverseTree($path.'/', $func);
}
}
class MyDB extends SQLite3
{
function __construct()
{
global $argv;
$this->open($argv[1]);
}
}
function checkit($f) {
global $db;
if ((substr($f, -4) != ".MOV") && (substr($f, -4) != ".mov") && (substr($f, -4) != ".avi") && (substr($f, -4) != ".AVI") && (substr($f, -4) != ".mp4") && (substr($f, -4) != ".MP4"))
return;
$handle=@popen("exiftool -php '". $f. "'",'r');
eval('$data=' . fread($handle, 100000));
print($f . ": " . $data[0]['MediaCreateDate'] . " / ". strtotime($data[0]['MediaCreateDate']). "\n");
$time=strtotime($data[0]['MediaCreateDate']);
if (!time)
$time=strtotime($data[0]['CreateDate']);
// print_r($data);
$dir =substr(dirname($f), 1, 2000);
$fname=basename($f);
$sql="SELECT Z_PK FROM ZPATHLOCATION WHERE ZRELATIVEPATH='$dir'";
$row = $db->querySingle($sql, true);
$zPath=$row["Z_PK"];
echo $zPath. "\n";
$sql="UPDATE ZIMAGE SET ZEXP_DATE=$time WHERE ZIMAGELOCATION=$zPath AND ZIMAGEFILENAME='$fname'";
$ret=$db->exec($sql);
$modell=$data[0]['Model'];
if ($modell) {
$sql="UPDATE ZIMAGE SET ZCAMERA_MODEL='$modell' WHERE ZIMAGELOCATION=$zPath AND ZIMAGEFILENAME='$fname'";
$ret=$db->exec($sql);
echo $sql;
}
$make=$data[0]['Make'];
if ($make) {
$sql="UPDATE ZIMAGE SET ZCAMERA_MAKE='$make' WHERE ZIMAGELOCATION=$zPath AND ZIMAGEFILENAME='$fname'";
$ret=$db->exec($sql);
echo $sql;
}
pclose($handle);
}
$db = new MyDB();
error_reporting(E_ERROR | E_PARSE);
traverseTree($argv[2], 'checkit');
$db->close();
?>0 -
[quote="EnderWiggins" wrote:
[quote="mercator" wrote:
Re movies: If you want the meta data in, you need to run a script (php, perl) to add them to the catalog. Had the same problem.
What kind of script? Where can I get it?
Did it work?0 -
Hi Helmut
I run your script, but didn't succeed in updating the metadata of my movie files.
Your script found and processed my movie files but no metadata information at all was finally written/updated to my C1 catalog.
Sample output line of your script:
UPDATE ZIMAGE SET ZCAMERA_MODEL='P7000' WHERE ZIMAGELOCATION= AND ZIMAGEFILENAME='Lisboa_02_2012-1021.MOV'UPDATE ZIMAGE SET ZCAMERA_MAKE='NIKON' WHERE ZIMAGELOCATION= AND ZIMAGEFILENAME='Lisboa_02_2012-1021.MOV'/Volumes/Space/Pictures/_OriginalsRAW/Family/2012/0212 Lisboa/Lisboa_02_2012-1406.MOV: 2012:02:22 11:50:01 / 1329911401
It looks like the call within your script to update the time didn't run at all.
ExifTool 9.95 installed (and working fine in terminal).
Any ideas? Thanks !0
Post ist für Kommentare geschlossen.
Kommentare
13 Kommentare