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
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.
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.
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(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...
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.
When I cut more compilation CDs, your way is the way to go.
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?
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.
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?