Import using tab delimited file (Excel)

Any trouble you encounter with the Pedias, here's the place to ask for help.
Post Reply
daerp
Inductee
Inductee
Posts: 1
Joined: Thu Oct 13, 2005 9:35 am

Import using tab delimited file (Excel)

Post by daerp »

I have a large collection of CDs already catalogued in Excel and would like to import into CDPedia. I can export the file as a tab delimited txt file, but what order do the various fields have to be in? Is this really simple? I haven't tried it for fear I'll have messed up what I have already done in CDpedia (imported from iTunes).
part 2: Will cd listings be duplicated if they are imported from both sources?
Thank you.
:?
User avatar
Conor
Top Dog
Posts: 5343
Joined: Sat Jul 03, 2004 12:58 pm
Contact:

Post by Conor »

The order of the fields does not matter when importing the file. When you import the file, CDpedia will ask you to map each field to its corresponding counterpart in CDpedia via a series of pop-up menus (this becomes easier if you tell Excel to make the first line of the tab export the field header names).

After the import you will have a separate new collection created for you with the imported material for you to review. You can then select it all and drag it to the library to add it to your collection or keep it segregated if that is what you wish. (Keep in mind smart collections work with the library as a base) There will be duplicates, the one you add from filemaker and anything you have added previously. If there are not many you can weed them out by doing a title sort and looking for duplicates. There is no detect duplicates command like in iTunes yet.
Post Reply