m_bojangles wrote:SELECT Albums.Album, Artists.Artist
FROM Albums INNER JOIN Artists ON Albums.IDArtist = Artists.ID
ORDER BY Albums.Album, Artists.Artist;

-m_bojangles

m_bojangles wrote:brave, not sure if you're comfortable using MS Access. If you have MS Office on your PC with Access installed, start it up. Open the MediaMonkey database (usually located in C:\Program Files\MediaMonkey\Data\MediaMonkey.mdb).

Now, you'll see a list that says, "Tables, Queries, Forms, Reports, Pages" and so on (it's a vertical list). Click on Queries.

Click on "Create query in Design view". A window will pop up asking you what tables you want in your query. Close this window.

Now you're looking at a mostly blank window called "Query1 : Select Query".

Go up to "View" on the main menu at the top. Choose "SQL View". The window should change to a white window that says "SELECT;" in it. Erase that and paste this in:

SELECT Albums.Album, Artists.Artist
FROM Albums INNER JOIN Artists ON Albums.IDArtist = Artists.ID
ORDER BY Albums.Album, Artists.Artist;

Now, look at the button bar and find the red exclamation point. When you hover over it, it will say "Run". Click on that to run your query.

You should see an album/artist list.

Now, go to "File" on the menu and choose "Save". Give the query a name, like "Album-Artist list". You will then see this query in the "Queries" window of Access. It can be run anytime by double-clicking on it there.

Double-click on it there to run it again. Now go to File and you'll see a choice called "Export...". When that window pops up, look at the drop down list called "Save as type:" This will allow you to export the list to a ton of formats, including Excel, or even just a plain text file.

Hope this helps.

btw, that query sorts it by album title. If you want to sort by artist, change this line in the query:

ORDER BY Albums.Album, Artists.Artist;

to

ORDER BY Artists.Artist, Albums.Album;

If you don't have Access or don't want to try messing with this, then we should look into why you're having trouble with the scripts that you said don't work.

-m_bojangles

brave wrote:All I want is to be able to print off a list of all the albums I have cataloged. I just want album name and artist, nothing else, not the track listings or any other data.

[ExportAlbumCSV]
FileName=Export.vbs
ProcName=ExportAlbumCSV
Order=5
DisplayName=Export &Album to CSV
Description=Exports only Albumnames to a .csv file
Language=VBScript
ScriptType=1

Sub ExportAlbumCSV
  ' initialize export
  Call InitExport (".csv", "CSV (*.csv)|*.csv|All files (*.*)|*.*", _
      "LastExportCSVDir")
  if fullfile="" then
    Exit Sub
  end if

  ' Create the output file
  Dim fout
  Set fout = fso.CreateTextFile( fullfile, True)

  ' Write header line
  fout.WriteLine Join(Array("Artist","Album"),",")
 
  ' Use progress to notify user about the current action
  Dim Progress
  Set Progress = SDB.Progress
  Progress.Text = "Exporting Albumnames to a CSV file..."

  ' Iterate through the list and export all albums
  
  Dim i
  Dim Album, Albums
  Set Albums = list.Albums
  Progress.MaxValue = Albums.count
  
  for i=0 to Albums.count-1
    Set Album = Albums.Item(i)
    fout.WriteLine Join( Array( QStr(Album.Artist.Name), QStr(Album.Name)), ",")
    Progress.Value = i+1
    if Progress.Terminate then
      Exit For
    end if
  next
  

  ' Close the output file and finish
  fout.Close

  ' Was it successfull?
  Dim ok
  if Progress.Terminate then
    ok = False
  else
    ok = True
  end if

  ' hide progress
  Set Progress = Nothing

  Call FinishExport( ok)
End Sub