Previous 1 2 Next 17 Replies Latest reply: Apr 25, 2010 6:01 AM by jadamasa
likeisaid Level 1 Level 1 (0 points)
I want to import 100 compilation discs to iTunes so I can load them on my iPod.
Naturally the track names and artists don't come in on the import.
I have the track and artist information for each disc in EXCEL files and in "Surething" disc labeling files.
+*Is there a way to use either of theose file types to populate track and artist information in iTunes after the import completes?*+
Typing the information or cutting and pasting individual track information from Excel to iTunes is not appealing.

iPod 160G Classic, Windows 7
  • the fiend Level 5 Level 5 (7,885 points)
    likeisaid wrote:
    Naturally the track names and artists don't come in on the import.

    Why? Are these discs your own compilations that you've burned, or are they commercially available compilation CDs?

  • likeisaid Level 1 Level 1 (0 points)
    They are mine. I burned them from my own collection. Each track on each compilation disc is by a different artist.
  • likeisaid Level 1 Level 1 (0 points)
    For example, this is the content of the 1st disc. It's taken from the EXCEL file. Track #, Title, Artist. I'd like to assign those values to a playlist in iTunes.

    1 grass xtc
    2 calling all stations genesis
    3 no myth michael penn
    4 temptation waits garbage
    5 sex and candy marcy playground
    6 oxygen jj72
    7 flying badfinger
    8 swab the temples rollerskate skinny
    9 from a different view closer
    10 the writ black sabbath
    11 jackson cannery ben folds five
    12 stereotypes blur
    13 walking on air bee gees
    14 razor's edge ac/dc
    15 danger robin gibb
    16 flaming pie paul mc cartney
    17 glutton of sympathy jellyfish
    18 black or blue london suede
    19 ***** thin lizard dawm
  • turingtest2 Level 9 Level 9 (61,210 points)

    I've recently been working on a script to fill blank tags from the filename & path data. This could be easily adapted to read in a table of strings and apply these to a set of selected tracks in iTunes. When working with the path it extracts data from the string in the format:

    <Parent Path>\<Album Artist>\<Album>\<## Name\[ - <Artist>\].<ext>

    If you can use Excel to create a series of strings such as:

    Table(2)="Calling All Stations\Genesis"

    Then I could adapt the script to read the table and write the values into the tracks in turn. If your database has other fields that you'd like to include then it should be easy to add those in.

    I'm about to go out but I'll try to upload the script later on today/tonight. You'll still have to cut & paste some chunks of data around but it should be possible to save you quite a bit of finger work.

  • likeisaid Level 1 Level 1 (0 points)
    Sounds good.
    I'd like to try it when you have it.
    I typed in 4 discs worth of track info.
    I didn't enjoy it.
  • the fiend Level 5 Level 5 (7,885 points)
    Forgive me for stating the obvious, but wouldn't it make more sense to import the tracks from the original albums, (so that track names are added by Gracenote) and then (within iTunes) add those tracks to a playlist which you then Sync to the iPod?

    So if you only want one or two tracks from a particular CD, then simply import only those tracks, which would then be listed with track name, artist and album it came from. Once you have all the tracks from all the albums, create playlists with the names you want and drag tracks into the appropriate playlist. Sync the whole lot to your iPod and you then have the playlists you want and the original albums (with all or only some tracks). The "original albums" is only a label, if you don't want to search by albums, you don't have to.

  • turingtest2 Level 9 Level 9 (61,210 points)

    Download TagFromTable. I'm assuming you know enough about Excel to create a new column that creates the text you'll need to paste from the preceding cell data. The version as posted expects to get something like this:
    Table(0)="Album Name"
    Table(1)="Name 1\Artist 1"
    Table(2)="Name 2\Artist 2"
    Table(3)="Name 3\Artist 3"
    Table(4)="Name 4\Artist 4"
    Table(5)="Name 5\Artist 5"

    Take the data for one of the albums you've already imported into iTunes but not yet filled in the track data for (or just import a new album). Create the relevant text in Excel and paste it over the sample data in the script, then save. Select the tracks of the coresponding album in iTunes, then run the script. It should issue a message box showing each change that it would make. If you're happy it's going to do what you want change the line that reads Demo=True into Demo=False and run it again. Paste in a new set of track names & artists, save the script, select the relevant tracks and run it again. Repeat until all your imports are named. If you need help tweaking the script just ask...

  • likeisaid Level 1 Level 1 (0 points)
    I've already imported 10,131 songs from CDs I was able to import almost in their entirety.
    That leaves me with onswies twosies from many many CDs. Probably 1500 CDs or more are remaining.
    So you're talking about over 1250 separate CD loads to import those 1500 songs.
    That's lots of wear and tear.
    Alternatively. all the songs are already compiled on 100 discs so I'd rather do bulk song imports on fewer discs.
    HOWEVER ...
    When I cut more compilation CDs, your way is the way to go.
  • likeisaid Level 1 Level 1 (0 points)
    I'll give it a go and let you know.
  • likeisaid Level 1 Level 1 (0 points)
    Uh oh, Steve.
    One thing occurs to me.
    I do want to retain the track times.
    I anticipated the imported track times in iTunes would be retained but if the script is basically a replacement function I suspect it will be one variable short and immediately turn into an unholy mess.

    So does that mean I need columns with entries like:
    Table(1)="Name 1\Artist 1\Track Time"

    Is that correct?
  • Chris CA Level 9 Level 9 (78,005 points)
    The track times will be what the track time is. You can't import that value.
  • turingtest2 Level 9 Level 9 (61,210 points)
    Agreed. If there is other useful data in the spreadsheet then that could be included, but track times will be derived from the imported media.

  • turingtest2 Level 9 Level 9 (61,210 points)
    Of course the alternative approach is to use
    MusicBrainz Picard
    to try to identify the original meta-data for each track but that would break apart the compilation structure you currently have.

  • likeisaid Level 1 Level 1 (0 points)
    turingtest2 ... YOU ARE THE MAN

    TagFromTable works like a champ!

    I dummied up some entries to test the script and it flew.
    I did it for a 19 track disc.
    But I set the DIM for 22.
    No problem.
    So I guess I could set the internal table dimension for many more entries and as long as they're formatted correctly there will be no problem.
    Now I can work on the EXCEL modification.

    Thanks a whole lot. A WHOLE lot.

    BTW, was that script written in BASIC?
Previous 1 2 Next