[mweird0]

Hai m8's

Maybe a strange question but i was wondering how i can get my itunes music records in a MS Access database. I want to make a database of all my music (50GB) but don't wanna fill in the records by typing; duh!

I hope someone can give a solution of how i can get the records in a database. Does anyone know wat kind of type database is used by itunes?

GreetZ Mark

[cpac]

it's the Library file - though I'm not sure where that's stored on a Windows machine.

You could open it up in a text editor to take a look...

[TETENAL]

Originally posted by mweird0:
I want to make a database of all my music

Why? iTunes is a database already.

[mweird0]

There is an XML file which contains all the records but with i ugly link

for example: file://localhost/G:/-=MUSIC%20COLLECTION=-/N.E.R.D/Fly%20or%20Die/05-n.e.r.d-she_wants_to_move.mp3/

This is wath i want:
Artist Album Number
N.E.R.D Fly or Die she wants to move

I want to make a database of mine cd collection which i can share with friends.

I cant open the file calt; iTunes 4 Music Library, and don't know what it contains.

[TETENAL]

File->Export Song List (Format: Text)

That should be importable into Access somehow.

Why anyone would want to share a database of his CDs with his friends is beyond me, but I'm not asking.

[bbales]

I made a listing of all my songs on my desktop, using the Appleworks ... oops -- it occurs to me I used the spreadsheet program, not the database.
Then
Oh well -- I was just going to say that I made the list at all so I could compare the listings on my desktop and my PB. THen I was able to finally get the two libraries synced. Maybe he wants to do something similar!

[mweird0]

First: Thnx for all the posts!

It doesn't make a difference to export to *.txt, it gave the same results as a *.xml file.

Now i gonna try to import the records in excell and replace

[ file://localhost/G:/-=MUSIC%20COLLECTION=-/N.E.R.D/Fly%20or%20Die/05-n.e.r.d-she_wants_to_move.mp3/ ]

the text i don't need by the replace option in excell. After i will import the whole file in access. I hope it works ???

[Angus_D]

You could use AppleScript to export it into a tab-delimited text file or similar, but really...

[mweird0]

i saw a pearl script called phptunest which put your library music in a php script. This sounds also easy and good....only one problem; the original site is offline..

does anybody know where i can get the program?

[Maflynn]

Originally posted by mweird0:
i saw a pearl script called phptunest which put your library music in a php script. This sounds also easy and good....only one problem; the original site is offline..

does anybody know where i can get the program?

Why not just select File->Export Song list. Seems a lot easier then searching (and running) pearl or apple scripts. Exporting the songs will dump the songs into a file and use tabs as the delimitter. I successfully used this to import into Access.

Mike

[mweird0]

That is what i try ...but when i import the XML in Access i get strange links. See other posts for strange links

[Maflynn]

Originally posted by mweird0:
That is what i try ...but when i import the XML in Access i get strange links. See other posts for strange links

Make sure you select the format as plain text. When I do that I have no problems importing it into Access.

Mike

[mweird0]

Thnx for your post.

I made a text file of the XML file but i've still got the same problem.
Did i mist something?

gr mark

[Maflynn]

I'm not sure, because when I select text as the format, the output is a tabbed delimitted file. There's no xml. There is an option to select XML but I choose unicode or plain text. Because I'm running an older version of MS office on VPC it can't deal with unicode so I select plain text

Here's the first two lines of the file (the formatting is messed up since pasting it here) but as you can see there is no xml.

Name Artist Composer Album Grouping Genre Size Time Disc Number Disc Count Track Number Track Count Year Date Modified Date Added Bit Rate Sample Rate Volume Adjustment Kind Equalizer Comments Play Count Last Played My Rating Location
Lose Yourself Eminem 8 Mile Soundtrack 5392288 322 1 1 1 16 2002 4/29/03 9:27 PM 1/29/04 7:06 PM 128 44100 Protected AAC audio file

What version of iTunes you running.

Another option is to show all songs, click on one of them, hit cmd-a and then cmd-c to copy the list. You can paste that into excel and reformat it for importing into access.

Mike

[Angus_D]

Originally posted by mweird0:
Thnx for your post.

I made a text file of the XML file but i've still got the same problem.
Did i mist something?

gr mark

Yeah. You missed going File->EXPORT SONG LIST, then making sure that TEXT is selected.

If you can't find that option, you might need to upgrade to a newer version of iTunes.

[mweird0]

thnx for the reply.... i ctr-c the whole library and now i export it to access-> job done!

But i still think about an php solution which automatic generate the list of music. I thought there are some scripts on the internet written by other people with the same idea's

gr mark

[Angus_D]

Have you looked at iTunesCatalog?

[mweird0]

looks very good..... i've got no recent mac system at the moment
So i'm searching for a Windows solution

[Angus_D]

Perhaps you should, uh, try a Windows forum then.

[Millennium]

Unfortunately, there is no counterpart to Access on Macs at the moment; the closest things would be FileMaker Pro and AppleWorks (not iWork), but these aren't exact matches. FMP is too high-end and AW is too low-end.

If you can code, it shouldn't be too difficult to create a script to do the work for you. You could even use Windows' scheduler to run it automatically every day at some convenient time, so that the database is kept reasonably up to date. This article has some information about doing this with Python, though it only covers the iTunes side, not the Access side. Of course, the downside of this approach is that you have to write the code yourself, but if you've ever wanted to learn how then this would make an interesting project.

[mweird0]

You've been right Angus_D but most Windows users don't wanna know something about itunes.

I copied the library and put it in an acces database...that works

Today i saw some php scripts for an webbased library on versiontracker, only one problem the links were down. I still search for a script....btw iTunesCatalog looks really good, but its only for mac