Bookpedia: Problems importing data from Booxter

Robby · Post by **Robby** » Tue Sep 25, 2007 4:06 pm

I had tried older versions of the Pedias and liked the concept but I didn't have much use for Gamepedia and DVDpedia as I don't many games and DVDs.
I was too lazy to enter all the CDs I have and Booxter seemed easier to use than Bookpedia.
But now these new versions 4.0 seem very attractive, both visually and in functionality so I downloaded CDpedia and Bookpedia to give them another shoot.

First thing I wanted to do was import my Booxter data.
So I fired up the HelpViewer and I looked up how to do that.
I exported my the data in XML format and the images in TIFF to the same location.
Next, I used the 'Import Collection...' command and hoped for the best.

I have been waiting for ages now, I think it must be nearly an hour now

, and it's still says "Einträge werden hinzugefügt" which is German for something like "entries are being added".

Edit: I'm going to send a bug report now.
Edit 2: Damn, "Unable to send bug report to Bruji servers".
Edit 3: Here's a log I copied from "Send bug report" (this time I didn't wait for so long, I hope this has no effect on the output):

Code: Select all

Console messages created by Bookpedia:

Bookpedia Help
2007-09-25 22:11:47.400 Bookpedia[417] [<MOBook 0x3cfcd0> setValue:forUndefinedKey:]: this class is not key value coding-compliant for the key release.
2007-09-25 23:07:46.603 Bookpedia[417] Error saving core data: {
    NSLocalizedDescription = "Zu wenige Objekte in collections."; 
    NSValidationErrorKey = collections; 
    NSValidationErrorObject = <MOBook: 0x3cfcd0> (entity: Book; id: 0x1693680 <x-coredata:///Book/tFC7BE737-CD83-4EA8-A714-F81FD7F8AA0B> ; data: {
    addressBookID = nil; 
    asin = 3828600484; 
    askingPrice = nil; 
    author = "Konrad Heidkamp"; 
    awards = nil; 
    borrowedBy = nil; 
    borrowedOn = nil; 
    buyerAddress = nil; 
    buyerEmail = nil; 
    buyerName = nil; 
    children = nil; 
    collectionID = nil; 
    collections = (); 
    comments = nil; 
    condition = nil; 
    copyright = nil; 
    custom1 = nil; 
    custom10 = nil; 
    custom2 = nil; 
    custom3 = nil; 
    custom4 = nil; 
    custom5 = nil; 
    custom6 = nil; 
    custom7 = nil; 
    custom8 = nil; 
    custom9 = nil; 
    dateAdded = nil; 
    dateEdited = 2007-09-25 22:11:47 +0200; 
    dewey = 48; 
    dimensions = nil; 
    discs = nil; 
    dueDate = nil; 
    edition = nil; 
    editor = nil; 
    extraData = nil; 
    format = "Gebundene Ausgabe"; 
    genre = nil; 
    gift = nil; 
    hasBeenSold = 0; 
    hasMovieLink = 0; 
    illustrator = nil; 
    isbn = 3828600484; 
    lastRead = nil; 
    lastUsedCount = 0; 
    lastUsedSet = (); 
    lccn = nil; 
    lentHistorySet = (); 
    linksSet = (); 
    locale = DE; 
    location = nil; 
    lowestNewPrice = nil; 
    lowestUsedPrice = nil; 
    myRating = 0; 
    notes = nil; 
    onSale = 0; 
    pageMark = nil; 
    pages = 311; 
    paid = nil; 
    placePublished = nil; 
    placedForSaleAt = nil; 
    price = nil; 
    producer = nil; 
    publisher = Fest; 
    purchasedAt = nil; 
    purchasedOn = nil; 
    rating = nil; 
    releaseDate = nil; 
    series = nil; 
    signed = 0; 
    similarProductsSet = (); 
    soldOn = nil; 
    soldPrice = nil; 
    sortTitle = nil; 
    status = 0; 
    subjects = nil; 
    summary = nil; 
    tags = nil; 
    title = "It's all over now. Musik einer Generation - 40 Jah"; 
    translator = nil; 
    uid = 1; 
    upc = nil; 
    url = "http://www.amazon.de/exec/obidos/ASIN/3828600484/l"; 
}); 
    NSValidationErrorValue = <_NSFaultingMutableSet: 0x3d1350> (); 
}
2007-09-25 23:17:13.839 Bookpedia[471] [<MOBook 0x4d08790> setValue:forUndefinedKey:]: this class is not key value coding-compliant for the key release.
Bookpedia Help
2007-09-25 23:24:40.397 Bookpedia[471] Error saving core data: {
    NSLocalizedDescription = "Zu wenige Objekte in collections."; 
    NSValidationErrorKey = collections; 
    NSValidationErrorObject = <MOBook: 0x4d08790> (entity: Book; id: 0x4d08830 <x-coredata:///Book/t9351E60C-BBE1-4D74-B7D2-5FF8AB4965EB> ; data: {
    addressBookID = nil; 
    asin = 3828600484; 
    askingPrice = nil; 
    author = "Konrad Heidkamp"; 
    awards = nil; 
    borrowedBy = nil; 
    borrowedOn = nil; 
    buyerAddress = nil; 
    buyerEmail = nil; 
    buyerName = nil; 
    children = nil; 
    collectionID = nil; 
    collections = (); 
    comments = nil; 
    condition = nil; 
    copyright = nil; 
    custom1 = nil; 
    custom10 = nil; 
    custom2 = nil; 
    custom3 = nil; 
    custom4 = nil; 
    custom5 = nil; 
    custom6 = nil; 
    custom7 = nil; 
    custom8 = nil; 
    custom9 = nil; 
    dateAdded = nil; 
    dateEdited = 2007-09-25 23:17:13 +0200; 
    dewey = 48; 
    dimensions = nil; 
    discs = nil; 
    dueDate = nil; 
    edition = nil; 
    editor = nil; 
    extraData = nil; 
    format = "Gebundene Ausgabe"; 
    genre = nil; 
    gift = nil; 
    hasBeenSold = 0; 
    hasMovieLink = 0; 
    illustrator = nil; 
    isbn = 3828600484; 
    lastRead = nil; 
    lastUsedCount = 0; 
    lastUsedSet = (); 
    lccn = nil; 
    lentHistorySet = (); 
    linksSet = (); 
    locale = DE; 
    location = nil; 
    lowestNewPrice = nil; 
    lowestUsedPrice = nil; 
    myRating = 0; 
    notes = nil; 
    onSale = 0; 
    pageMark = nil; 
    pages = 311; 
    paid = nil; 
    placePublished = nil; 
    placedForSaleAt = nil; 
    price = nil; 
    producer = nil; 
    publisher = Fest; 
    purchasedAt = nil; 
    purchasedOn = nil; 
    rating = nil; 
    releaseDate = nil; 
    series = nil; 
    signed = 0; 
    similarProductsSet = (); 
    soldOn = nil; 
    soldPrice = nil; 
    sortTitle = nil; 
    status = 0; 
    subjects = nil; 
    summary = nil; 
    tags = nil; 
    title = "It's all over now. Musik einer Generation - 40 Jah"; 
    translator = nil; 
    uid = 1; 
    upc = nil; 
    url = "http://www.amazon.de/exec/obidos/ASIN/3828600484/l"; 
}); 
    NSValidationErrorValue = <_NSFaultingMutableSet: 0x4d08c00> (); 
}
2007-09-26 00:56:36.338 Bookpedia[553] [<MOBook 0x1692250> setValue:forUndefinedKey:]: this class is not key value coding-compliant for the key release.
2007-09-26 00:56:37.338 Bookpedia[553] Error saving core data: {
    NSLocalizedDescription = "Zu wenige Objekte in collections."; 
    NSValidationErrorKey = collections; 
    NSValidationErrorObject = <MOBook: 0x1692250> (entity: Book; id: 0x16d6120 <x-coredata:///Book/t9F96BB69-FB72-40F0-843C-DCFF9D5AFDC5> ; data: {
    addressBookID = nil; 
    asin = 3828600484; 
    askingPrice = nil; 
    author = "Konrad Heidkamp"; 
    awards = nil; 
    borrowedBy = nil; 
    borrowedOn = nil; 
    buyerAddress = nil; 
    buyerEmail = nil; 
    buyerName = nil; 
    children = nil; 
    collectionID = nil; 
    collections = (); 
    comments = nil; 
    condition = nil; 
    copyright = nil; 
    custom1 = nil; 
    custom10 = nil; 
    custom2 = nil; 
    custom3 = nil; 
    custom4 = nil; 
    custom5 = nil; 
    custom6 = nil; 
    custom7 = nil; 
    custom8 = nil; 
    custom9 = nil; 
    dateAdded = nil; 
    dateEdited = 2007-09-26 00:56:36 +0200; 
    dewey = 48; 
    dimensions = nil; 
    discs = nil; 
    dueDate = nil; 
    edition = nil; 
    editor = nil; 
    extraData = nil; 
    format = "Gebundene Ausgabe"; 
    genre = nil; 
    gift = nil; 
    hasBeenSold = 0; 
    hasMovieLink = 0; 
    illustrator = nil; 
    isbn = 3828600484; 
    lastRead = nil; 
    lastUsedCount = 0; 
    lastUsedSet = (); 
    lccn = nil; 
    lentHistorySet = (); 
    linksSet = (); 
    locale = DE; 
    location = nil; 
    lowestNewPrice = nil; 
    lowestUsedPrice = nil; 
    myRating = 0; 
    notes = nil; 
    onSale = 0; 
    pageMark = nil; 
    pages = 311; 
    paid = nil; 
    placePublished = nil; 
    placedForSaleAt = nil; 
    price = nil; 
    producer = nil; 
    publisher = Fest; 
    purchasedAt = nil; 
    purchasedOn = nil; 
    rating = nil; 
    releaseDate = nil; 
    series = nil; 
    signed = 0; 
    similarProductsSet = (); 
    soldOn = nil; 
    soldPrice = nil; 
    sortTitle = nil; 
    status = 0; 
    subjects = nil; 
    summary = nil; 
    tags = nil; 
    title = "It's all over now. Musik einer Generation - 40 Jah"; 
    translator = nil; 
    uid = 1; 
    upc = nil; 
    url = "http://www.amazon.de/exec/obidos/ASIN/3828600484/l"; 
}); 
    NSValidationErrorValue = <_NSFaultingMutableSet: 0x4c05660> (); 
}
2007-09-26 00:57:03.640 Bookpedia[557] [<MOBook 0x16922d0> setValue:forUndefinedKey:]: this class is not key value coding-compliant for the key release.
2007-09-26 00:57:19.037 Bookpedia[557] Error saving core data: {
    NSLocalizedDescription = "Zu wenige Objekte in collections."; 
    NSValidationErrorKey = collections; 
    NSValidationErrorObject = <MOBook: 0x16922d0> (entity: Book; id: 0x16f7f90 <x-coredata:///Book/tE4A4529E-BCB5-4464-A069-5835A0C99EB9> ; data: {
    addressBookID = nil; 
    asin = 3828600484; 
    askingPrice = nil; 
    author = "Konrad Heidkamp"; 
    awards = nil; 
    borrowedBy = nil; 
    borrowedOn = nil; 
    buyerAddress = nil; 
    buyerEmail = nil; 
    buyerName = nil; 
    children = nil; 
    collectionID = nil; 
    collections = (); 
    comments = nil; 
    condition = nil; 
    copyright = nil; 
    custom1 = nil; 
    custom10 = nil; 
    custom2 = nil; 
    custom3 = nil; 
    custom4 = nil; 
    custom5 = nil; 
    custom6 = nil; 
    custom7 = nil; 
    custom8 = nil; 
    custom9 = nil; 
    dateAdded = nil; 
    dateEdited = 2007-09-26 00:57:03 +0200; 
    dewey = 48; 
    dimensions = nil; 
    discs = nil; 
    dueDate = nil; 
    edition = nil; 
    editor = nil; 
    extraData = nil; 
    format = "Gebundene Ausgabe"; 
    genre = nil; 
    gift = nil; 
    hasBeenSold = 0; 
    hasMovieLink = 0; 
    illustrator = nil; 
    isbn = 3828600484; 
    lastRead = nil; 
    lastUsedCount = 0; 
    lastUsedSet = (); 
    lccn = nil; 
    lentHistorySet = (); 
    linksSet = (); 
    locale = DE; 
    location = nil; 
    lowestNewPrice = nil; 
    lowestUsedPrice = nil; 
    myRating = 0; 
    notes = nil; 
    onSale = 0; 
    pageMark = nil; 
    pages = 311; 
    paid = nil; 
    placePublished = nil; 
    placedForSaleAt = nil; 
    price = nil; 
    producer = nil; 
    publisher = Fest; 
    purchasedAt = nil; 
    purchasedOn = nil; 
    rating = nil; 
    releaseDate = nil; 
    series = nil; 
    signed = 0; 
    similarProductsSet = (); 
    soldOn = nil; 
    soldPrice = nil; 
    sortTitle = nil; 
    status = 0; 
    subjects = nil; 
    summary = nil; 
    tags = nil; 
    title = "It's all over now. Musik einer Generation - 40 Jah"; 
    translator = nil; 
    uid = 1; 
    upc = nil; 
    url = "http://www.amazon.de/exec/obidos/ASIN/3828600484/l"; 
}); 
    NSValidationErrorValue = <_NSFaultingMutableSet: 0x16fc5f0> (); 
}

Post by **Nora** » Wed Sep 26, 2007 6:38 am

Thanks for letting us know about that bug with the import. It's fixed and you can download Bookpedia again. (still version 4.0 for now)

Robby · Post by **Robby** » Wed Sep 26, 2007 7:39 am

Wow, that was quick!

I'm afraid, the images weren't imported, though.

Edit: Also, diacritics (umlaut, accents etc.) aren't displayed correctly after import.

Post by **Conor** » Wed Sep 26, 2007 5:16 pm

To include the images you also have to export the images from Booxter as TIFF format and save them in a folder named "Images" at the same level as the xml file. I'll look at the diacritics problem for the 4.0.1 version.

Folder
----MyBooks.xml
----Images
--------123456.tiff
--------654321.tiff
--------....

Robby · Post by **Robby** » Wed Sep 26, 2007 6:03 pm

Conor wrote:To include the images you also have to export the images from Booxter as TIFF format and save them in a folder named "Images" at the same level as the xml file.

Folder
----MyBooks.xml
----Images
--------123456.tiff
--------654321.tiff
--------....

Thanks, that might be a good thing to add to the documentation.

Conor wrote:I'll look at the diacritics problem for the 4.0.1 version.

Cool!

Post by **Nora** » Thu Sep 27, 2007 2:57 am

That might be a good thing to add to the documentation.

Consider it done.

Post by **Conor** » Thu Sep 27, 2007 3:08 am

The encoding of the diacritics is actually a Booxter issue, they are using UTF8 but writing the file out as Mac Western Roman encoding. You can see this if you open the file in a program like TextWrangler that the diacritics already are wrong in the XML. However I have told Bookpedia to ignore the file format and force it to UTF8 when reading it, so when version 4.0.1 comes out, you will be able to import with the correct diacritics. Thank you for the information.

Robby · Post by **Robby** » Thu Sep 27, 2007 5:30 am

Excellent stuff!