[REQ] Reports - Album List
Moderators: jiri, drakinite, Addon Administrators
[REQ] Reports - Album List
Hi - Is there a way to generate a report that just lists the Albums in the database?
When I try File>Reports>File List and just include "Album" ---- its doing what I suspect, listing the Album name as many times as there are tracks, i.e., "Album Name" 10 times, if there are 10 tracks.
All I really want is a list of the Album Names without any other details, but only list the Album name once per album.
Am I missing something?
Thanks
When I try File>Reports>File List and just include "Album" ---- its doing what I suspect, listing the Album name as many times as there are tracks, i.e., "Album Name" 10 times, if there are 10 tracks.
All I really want is a list of the Album Names without any other details, but only list the Album name once per album.
Am I missing something?
Thanks
Re: [REQ] Reports - Album List
What does [REQ] mean?
Was this changed to a new feature request or is there an existing way to generated just a list of the Albums and I missed it?
Was this changed to a new feature request or is there an existing way to generated just a list of the Albums and I missed it?
-
- Posts: 1190
- Joined: Tue Jun 13, 2017 8:47 am
- Location: Vienna
Re: [REQ] Reports - Album List
REQUIRED = was recognized by an administrator for a meaningful need.
MMW 4.1.31.1919 Gold-Standardinstallation
Re: [REQ] Reports - Album List
Request, but as it's an Addon request it may take an Addon developer to create this at some point instead.
Download MediaMonkey ♪ License ♪ Knowledge Base ♪ MediaMonkey for Windows 2024 Help ♪ MediaMonkey for Android Help
Lowlander (MediaMonkey user since 2003)
Lowlander (MediaMonkey user since 2003)
-
- Posts: 1190
- Joined: Tue Jun 13, 2017 8:47 am
- Location: Vienna
Re: [REQ] Reports - Album List
@Lowlander
Wouldn't it be easy to add an option to group by album???
Wouldn't it be easy to add an option to group by album???
MMW 4.1.31.1919 Gold-Standardinstallation
Re: [REQ] Reports - Album List
Just to make sure we are on the same page, what is happening now if only "Album" is selected in the Report File List (Example: albums "Star Dust" and "Moonstruck", the report looks like this when Star Dust has 6 tracks and Moonstruck has 5 tracks:
Star Dust
Star Dust
Star Dust
Star Dust
Star Dust
Star Dust
Moonstruck
Moonstruck
Moonstruck
Moonstruck
Moonstruck
All I really want is a list of the Albums:
Star Dust
Moonstruck.
If I had included "Album" and "Title" then the file list would be correct in showing the Album name six times with six titles (tracks) and Moonstruck five times with five titles (tracks).
Not a big deal, just a small enhancement to generated a list of all albums in the database - just a surprise that when only Album is entered it generated a really long list with all the Album names for as many titles each.
Thanks
Star Dust
Star Dust
Star Dust
Star Dust
Star Dust
Star Dust
Moonstruck
Moonstruck
Moonstruck
Moonstruck
Moonstruck
All I really want is a list of the Albums:
Star Dust
Moonstruck.
If I had included "Album" and "Title" then the file list would be correct in showing the Album name six times with six titles (tracks) and Moonstruck five times with five titles (tracks).
Not a big deal, just a small enhancement to generated a list of all albums in the database - just a surprise that when only Album is entered it generated a really long list with all the Album names for as many titles each.
Thanks
-
- Posts: 1190
- Joined: Tue Jun 13, 2017 8:47 am
- Location: Vienna
Re: [REQ] Reports - Album List
The result with the grouping function would look like the "Album" node, for example.
The programmers could read the album names straight away from the "Albums" -table in the MM5.DB.

The programmers could read the album names straight away from the "Albums" -table in the MM5.DB.

Last edited by Erwin Hanzl on Thu Apr 21, 2022 2:09 pm, edited 1 time in total.
MMW 4.1.31.1919 Gold-Standardinstallation
Re: [REQ] Reports - Album List
That's interesting.
I would have thought by just selecting "Album" in the File>Reports>File List it would have just giving one instance but I can understand that it is "Selecting Column" and since the column contains all the album names for as many titles, you can't get just one entry per album ----- its currently giving just what is in the "selected column."
Maybe the developers can group like you showed in order to generate an Album report.
I did export to excel and then clean it up by listing unique ( in column A1 set the formula =B1=B2, where column A is empty and column B contains the "Album report" from MM and copy that to the end of the list and get a True/False list, then delete all the True entries, leaving just the single, now unique Album names). But for a very long library list, sort of a sledge hammer approach.
I would have thought by just selecting "Album" in the File>Reports>File List it would have just giving one instance but I can understand that it is "Selecting Column" and since the column contains all the album names for as many titles, you can't get just one entry per album ----- its currently giving just what is in the "selected column."
Maybe the developers can group like you showed in order to generate an Album report.
I did export to excel and then clean it up by listing unique ( in column A1 set the formula =B1=B2, where column A is empty and column B contains the "Album report" from MM and copy that to the end of the list and get a True/False list, then delete all the True entries, leaving just the single, now unique Album names). But for a very long library list, sort of a sledge hammer approach.
-
- Posts: 1190
- Joined: Tue Jun 13, 2017 8:47 am
- Location: Vienna
Re: [REQ] Reports - Album List
Another possibility in EXCEL:
Use "Subtotals" under "DATA" menu
Weitere Möglichkeit in EXCEL:
Verwenden Sie "Teilergebnisse" unter Menü "DATEN

Use "Subtotals" under "DATA" menu
Weitere Möglichkeit in EXCEL:
Verwenden Sie "Teilergebnisse" unter Menü "DATEN

MMW 4.1.31.1919 Gold-Standardinstallation
Re: [REQ] Reports - Album List
Hi - thanks for the Excel suggestion about Subtotals. It worked but a little strange to clean up the list with "count" added to the Album name, etc..
While I was looking at the Data tab, wouldn't "Remove Duplicates" in the Data Tools work even better? Seems to give a clean, usable list........
While I was looking at the Data tab, wouldn't "Remove Duplicates" in the Data Tools work even better? Seems to give a clean, usable list........
-
- Posts: 1190
- Joined: Tue Jun 13, 2017 8:47 am
- Location: Vienna
Re: [REQ] Reports - Album List
That's how it is with Excel.
There are many ways to reach your goal.
Just test and use the best for yourself.
There are many ways to reach your goal.
Just test and use the best for yourself.
MMW 4.1.31.1919 Gold-Standardinstallation
Re: [REQ] Reports - Album List
I agree.Erwin Hanzl wrote: ↑Thu Apr 21, 2022 12:25 pm That's how it is with Excel.
There are many ways to reach your goal.
Just test and use the best for yourself.
The issue with Excel is where I have the same album name but have the Vinyl, CD and/or Reel-to-Reel versions --- removing duplicates would not give an accurate list of the library.
I still hope MM will add a grouping (or something similar). That would give a accurate list of all Albums right from the source with no external "manipulation."
Re: [REQ] Reports - Album List
Erwin,
You have been very helpful.
If you don't mind --- when I look at the File>Reports>File Lists> what is the purpose of adding "Grouping" as a selected column? And how would that be used to generate an Album list?
Thanks
You have been very helpful.
If you don't mind --- when I look at the File>Reports>File Lists> what is the purpose of adding "Grouping" as a selected column? And how would that be used to generate an Album list?
Thanks
-
- Posts: 1190
- Joined: Tue Jun 13, 2017 8:47 am
- Location: Vienna
Re: [REQ] Reports - Album List
Hello Roxie,
now generally speaking:
Groupings summarize the same entries in the same tag.
You can also find groupings in nodes in your collection: Genre, Classifications, Title, ....
Albums are grouped by the tags: "Album" and "Album artist(s)"
These groupings are entered in the MM5.DB in the corresponding tables and updated again and again in the event of changes.
The result would look something like this.

now generally speaking:
Groupings summarize the same entries in the same tag.
You can also find groupings in nodes in your collection: Genre, Classifications, Title, ....
Albums are grouped by the tags: "Album" and "Album artist(s)"
These groupings are entered in the MM5.DB in the corresponding tables and updated again and again in the event of changes.
A check box would be used for this in the same line.And how would that be used to generate an Album list?
The result would look something like this.

MMW 4.1.31.1919 Gold-Standardinstallation