Multiple track listings

[wileewonka]

Has anyone experienced, when trying to create a simple catalogue of albums, multiple duplication of tracks (I have had duplicate, triplicate and septuple listings of the tracks on one album)?
Is there a fix/correction for this?
All I want to do is create a catalogue listing artist name and album title. Nothing truly extensive. I have unsuccessfully tried to do this for years. I have restored to attempting to manually create a catalogue, but with 1700 CD's and several hundred records it is too daunting.
I have contacts MM support, multiple times, and, even thought they were responsive, had no substantive functional answers.
Thank you

[Lowlander]

You left the Support Ticket for this unanswered.

Start with checking the Paths of the duplicate files. Are they different Paths for each duplicate or do they have the exact same Paths?

[wileewonka]

Has anyone experienced, when trying to create a simple catalogue of albums, multiple duplication of tracks (I have had duplicate, triplicate and septuple listings of the tracks on one album)?
Is there a fix/correction for this?
All I want to do is create a catalogue listing artist name and album title. Nothing truly extensive. I have unsuccessfully tried to do this for years. I have restored to attempting to manually create a catalogue, but with 1700 CD's and several hundred records it is too daunting.
I have contacts MM support, multiple times, and, even thought they were responsive, had no substantive functional answers.
Thank you

[IanRTaylorUK]

Part One
=======

I think you probably want to start with using two add-ons - SQL Editor and Custom Nodes:

https://www.mediamonkey.com/addons/brow ... tom-nodes/
https://www.mediamonkey.com/addons/brow ... ql-editor/

You then write your SQL in the editor and test the execution - note you are limited to displaying 1000 rows!

The SQL might look something like this:

Code: Select all

/* Creates a simple catalogue of the music collection by listing each
    unique Artist and Album combination only once.
    
    Purpose:
      - Produce a printable/exportable catalogue of albums.
      - Avoid duplicate entries caused by multiple tracks on the same album.
      - Sort the results alphabetically by Artist and then Album.
      
    Output:
      Artist | Album
 */
 SELECT DISTINCT Artist , Album
FROM Albums
WHERE Album <> ""
ORDER BY Artist, Album;

Once you have fine tuned your SQL statement, then you can transfer it to become a Custom Node - specifically an ALBUM type Custom Node. But the above WILL FAIL!!! Also it is not convenient to get printable "output" from the SQL Editor.

To get Custom Nodes to work you need to make available ALL fields from the Albums table, so the SQL becomes:

Code: Select all

SELECT DISTINCT *
FROM Albums
WHERE Album <> ""
ORDER BY Artist, Album

You will then see a problem - you have a Tile'd display of Albums and Artists - not particularly useful if you want to export!

So whilst we can get the information, we can't get it out of Media Monkey 2024 so easily!

[IanRTaylorUK]

Part Two
=======

To get the information out of Media Monkey, we first create a Backup of the database file MM.DB

In my case I do a full backup to a ZIP file, so I also have to "Extract All" to expose the MM.DB file.

I open the "backed up" MM.DB file using DB Browser for SQLite and check I have the database readable (click database structure tab and press F5)

In the Execute SQL tab, I type the simplest SQL possible i.e.

SELECT * FROM Albums WHERE ALBUM <> ""

and execute using the "Play" icon.

You can now highlight the whole table by clicking the LEFT / UPPERMOST part of the results display and then right click to "Copy with Headers. Open your spreadsheet and paste. You now have your list of Albums / Artists.

You might want to remove a few columns that are not useful and format others to your liking.

Suggest you save your SQL to a text / notepad file for future use, perhaps adding some notes in an SQL comment block (as shown in Part One).

P.S. You could bypass using the SQL and display the Albums table but then you would include no name ALBUM(s) = "".