![]() My only thought on this is to set the Collection ID as incremental, delete the database, and import the iTunes albums again and hope that CDPedia assigns the same UID as the Collection ID.ĪSINs/UPCs: These will have to be done manually, but no escaping this really. jpg with a numbered filename, presumably CDPedia's UID for the album, so if I had this number for each album I could recreate the URL easily enough, but I don t know how to export this UID either. The URL points to the Covers folder and then a. Help needed achieving this via CDpedia or iTunes directly.Ĭovers: I don't know how to export the Image URLs when exporting from CDPedia, but I know how to import it back in. I know how to import it (using semi-colons to split tracks out) but I can't get the track information (name, artist, duration) from the iTunes import sitting in CDpedia into Excel. Track information: I don't know how to export the Track information from CDPedia so that I can view it in Excel. Link to iTunes: I don't need to worry about the iTunes links as I have found out from the forum and by trail that these links are not encoded in the data anyway but looked up using Song Title and Artist (and hopefully Album as they don't necessarily match up). I have then managed to import this consolidated Excel list back into CDPedia. In Excel, I can manually add the Unique ID for each album that corresponds to the UID that my old windows database used, and then use that reference to look up the 10+ items of personal information from my Excel import from the old database. I have managed to import iTunes information to CDPedia, and then export that information to Excel, other than track info and cover images (see later). No comments as yet but I am nearing a solution. At the moment it has a collection of 5000+ CDs from iTunes and 5000+ CDs from excel import, and the program is running fine. ![]() I have played around with the program for new entries and it looks sweet, but want to resolve this first else I'll end up with 3 databases! Is there any shortcut given that I have the purchase information in excel now and could bulk enter the UPCs with the scanner? I would be happy to have an export of the CDPedia information to excel and then re-import once I have added the purchase information in excel, overwriting that information in CDPedia, as it is easier to bulk edit using excel.Īnd once the UPCs are entered for the collection, it would be useful to be able to turn on an audit function whereby I scan every CD on my shelf and a report is then generated showing which CDs are not in CDPedia and which are in CDpedia but not on shelf. ![]() CD singles) that do not feature in amazon/freedb). I don't want to start from scratch with the scanner as I think there would be too many rare CDs in my collection (e.g. I would then also need to compare the collection with the physical shelves to check for duplicates etc. ![]() I am almost resigned to going through the imported iTunes collection and adding manually my purchase date/purchase price/barcode information but this will take ages for 6000 CDs. I wonder what your recommended course of action is to get a database with all my CDs and purchase info in place. I have a bluetooth barcode reader on order, for new purchases and in case I need to add any items in bulk (i might purchase DVDpedia in due course, and I have no database for my DVDs so that would be starting from scratch). I have also imported my iTunes playlist which was a dream but obviously does not include the purchase information or UPCs. I have managed to import my CATraxx list of CDs into CDPedia (though the purchase date didn't import correctly due to UK/US date formats and I am missing track info but this could be resolved with little but some effort). I am now in a situation where I have an old database that is not up to date (CATraxx) and iTunes that is up to date but does not include purchase price, purchase date etc and does not quite list all of my CDs as I have some duplicates. I bought CDpedia about a year ago but didn't immediately take to it as I was still trialling what would be best to replace CATraxx. I have around 6000 CDs and 60000 songs iTunes and in the past have used CATraxx, a PC database, until I became a MacUser. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |