1. Join Now

    AVForums.com uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

How to get a List of all my music

Discussion in 'Headphones, Earphones & Portable Music' started by hughesy, Aug 29, 2005.

  1. hughesy

    hughesy
    Active Member

    Joined:
    Jan 22, 2005
    Messages:
    846
    Products Owned:
    0
    Products Wanted:
    0
    Trophy Points:
    21
    Location:
    Irish in Oz
    Ratings:
    +13
    Hi guys,

    For ages now i've been trying to get a get a list of all my music so i send to friends and keep for my self etc. The problem is i've got about 30,000 songs on over 1500 albums on my pc. I have tryed getting a list off itunes but what that does is gives you a list by song. I would rather a list of artists and then albums. I have my music folder organised by naming the folders e.g. "Coldplay - x&y" therefore my music folder contains a list 1500 folders.

    Anybody know an easy way of extracting these folders as a list, or a textfile???

    I know this is not really an mp3, ipod or digital music Question, but i'm sure you see the relevance and that i'm sure other people would find this information helpful!!!

    Regards,

    Hughesy :thumbsup:
     
  2. RB05

    RB05
    Guest

    Products Owned:
    0
    Products Wanted:
    0
    Ratings:
    +0
    Can I ask why?
     
  3. hughesy

    hughesy
    Active Member

    Joined:
    Jan 22, 2005
    Messages:
    846
    Products Owned:
    0
    Products Wanted:
    0
    Trophy Points:
    21
    Location:
    Irish in Oz
    Ratings:
    +13
    So i know exactly what albums i have without serching the music folder every time.

    I also want to organise my id3 tags, but it always takes ages serching through folders finding which sonds don't have them.

    This way i could have a print out, with a list of folders...
     
  4. mick's cat

    mick's cat
    Guest

    Products Owned:
    0
    Products Wanted:
    0
    Ratings:
    +0
    I'm speaking about Mac iTunes here as I'm not at my pc while I'm writing, but I'm sure iTunes for Windows is similar. Doesn't the Export Song List from the File menu command allow you to export as delimited text? The file is them importable into a spreadsheet app like Excel - from there you can delete unrequired columns and organize. Long-winded, I know.

    To write and edit tags, you might be able to use a third-party utility, of which there are several. If you edit tags out of iTunes however, it won't work unless the utility is writing to the iTunes database library as well as writing the tags. (Put the other way round, editing tags within iTunes itself is the only way to do it unless the utility writes to iTunes.)

    There's always the possibility that you can work with the iTunes database library file direct as well. On a Mac, it's in the main iTunes folder with the name iTunes Music Library.xml, and I think that's what it's called and where it is on Windows too. This is an xml file of course, but can be opened in the likes of Excel too and manipulated. Work on a copy though, as changing it will affect iTunes' main Library

    Alternatively, for Mac users only I'm afraid, you can make use of iTunes' AppleScriptability to do the job directly and elegantly. Doug's Applescripts for iTunes site at:

    http://www.dougscripts.com/itunes/index.php

    is a source for hundreds of scripts to do exactly what you want, and many, many other jobs too.
     
  5. hughesy

    hughesy
    Active Member

    Joined:
    Jan 22, 2005
    Messages:
    846
    Products Owned:
    0
    Products Wanted:
    0
    Trophy Points:
    21
    Location:
    Irish in Oz
    Ratings:
    +13
    Thanks mike... unfortunetley some of your useful information is wasted on me not having a mac :(

    Thanks anyway :smashin:
     
  6. mick's cat

    mick's cat
    Guest

    Products Owned:
    0
    Products Wanted:
    0
    Ratings:
    +0
    Only the last about Applescripts is not applicable - the other suggestions should work.

    Best of luck. Keep us posted whether you find a solution.
     
  7. hughesy

    hughesy
    Active Member

    Joined:
    Jan 22, 2005
    Messages:
    846
    Products Owned:
    0
    Products Wanted:
    0
    Trophy Points:
    21
    Location:
    Irish in Oz
    Ratings:
    +13
    will do...

    I can remember someone suggesting a way through ms-dos. But they weren't sure...
     
  8. IanPM

    IanPM
    Active Member

    Joined:
    Jan 12, 2004
    Messages:
    389
    Products Owned:
    0
    Products Wanted:
    0
    Trophy Points:
    18
    Ratings:
    +6
    In a DOS box, type the following

    c: (will work on any drive, just put the letter here)
    dir *.mp3 > mp3list.txt /s

    then, go to the root of c: and open mp3list.txt and see what you have.

    There are a number of options and switches you can use to improve the output, but this will produce a very simple list of every folder.
     
  9. HMHB

    HMHB
    Distinguished Member

    Joined:
    Nov 11, 2001
    Messages:
    25,518
    Products Owned:
    0
    Products Wanted:
    0
    Trophy Points:
    166
    Location:
    Nottinghamshire
    Ratings:
    +3,852
    I exported my song list into library.txt and then used Access to import this file (delimited by tab) and then you immediately have a table in access with all your song information in. You can then use queries etc to produce any list you want. I assume this will also work for Excel.
    When you go into Access create a new blank database and then click File/Get External Data/Import and then tell it to look for the library.txt file and that it's a delimited file (tab) and away you go.
     
  10. hughesy

    hughesy
    Active Member

    Joined:
    Jan 22, 2005
    Messages:
    846
    Products Owned:
    0
    Products Wanted:
    0
    Trophy Points:
    21
    Location:
    Irish in Oz
    Ratings:
    +13
    Excellant stuff thanks guys!! :smashin:
     
  11. chrislad

    chrislad
    Well-known Member

    Joined:
    May 6, 2005
    Messages:
    5,642
    Products Owned:
    0
    Products Wanted:
    0
    Trophy Points:
    83
    Location:
    Rep. of Ireland
    Ratings:
    +141
    Failing that, there's a program called Directory Lister that I use. Very handy.
     
  12. hughesy

    hughesy
    Active Member

    Joined:
    Jan 22, 2005
    Messages:
    846
    Products Owned:
    0
    Products Wanted:
    0
    Trophy Points:
    21
    Location:
    Irish in Oz
    Ratings:
    +13
    is it FREEEE??? :eek:
     
  13. djpowell

    djpowell
    Guest

    Products Owned:
    0
    Products Wanted:
    0
    Ratings:
    +0
  14. HMHB

    HMHB
    Distinguished Member

    Joined:
    Nov 11, 2001
    Messages:
    25,518
    Products Owned:
    0
    Products Wanted:
    0
    Trophy Points:
    166
    Location:
    Nottinghamshire
    Ratings:
    +3,852
    The option to export the song list in iTunes is all you need to do and then once you have imported it into access or excel you can do whatever you like with it.
    Do you have Access as that is the best tool for this kind of job ?
     
  15. Uridium

    Uridium
    Well-known Member

    Joined:
    Jan 29, 2005
    Messages:
    14,415
    Products Owned:
    0
    Products Wanted:
    0
    Trophy Points:
    136
    Location:
    North West Leicestershire
    Ratings:
    +1,858
    Try a free MS-DOS command called "Tree"

    example below using a folder named "C:\Music"

    at the command prompt type

    Tree C:\Music /F /A > c:\music.txt

    this will give you a txt file (c:\music.txt) on the root of your C:\ drive listing all your folders\files.

    (Syntax explained)
    the /F makes the tree command list filenames as well as just folders and the /A makes it out put in ASCII characters not illegible rubbish. The > symbol is used to pipe the output to C:\music.txt (or whatever you want to call it) rather than just display it on screen.
     
  16. chrislad

    chrislad
    Well-known Member

    Joined:
    May 6, 2005
    Messages:
    5,642
    Products Owned:
    0
    Products Wanted:
    0
    Trophy Points:
    83
    Location:
    Rep. of Ireland
    Ratings:
    +141
  17. hughesy

    hughesy
    Active Member

    Joined:
    Jan 22, 2005
    Messages:
    846
    Products Owned:
    0
    Products Wanted:
    0
    Trophy Points:
    21
    Location:
    Irish in Oz
    Ratings:
    +13
  18. HMHB

    HMHB
    Distinguished Member

    Joined:
    Nov 11, 2001
    Messages:
    25,518
    Products Owned:
    0
    Products Wanted:
    0
    Trophy Points:
    166
    Location:
    Nottinghamshire
    Ratings:
    +3,852
    The text file output from iTunes is a tab delimited file and so access will import it with no problems, just remember to tell it that the first row contains column headings and away you go :)
     
  19. hughesy

    hughesy
    Active Member

    Joined:
    Jan 22, 2005
    Messages:
    846
    Products Owned:
    0
    Products Wanted:
    0
    Trophy Points:
    21
    Location:
    Irish in Oz
    Ratings:
    +13
    will give it ago ;)

    Thanks everyone for there helpful suggestions :thumbsup:
     

Share This Page

Loading...