by Barry4679 » Sun Oct 03, 2021 6:16 am
EduMarins wrote: ↑Sat Oct 02, 2021 6:56 am
- is possible to create reports by Album name? I have interest to have a list that contains my entire collection by album names.
Example:
Artist - Album Name - Year - Bitrate - Number of tracks and so on. Not all tracks.
There are a couple workarounds that are usually mentioned when anyone asks how to make custom reports from their MM database.
- either load the MM add-on that allows you to query the database
- or export your track list to Excel, and make your report there
Your query prompted me to have little play with both today. Each could get a small way towards you want, but both have limitations which probably mean they are of no actual use to you.
- The SQL add-on gets close, but the limitations probably rule it out
- can't print or store it or copy and paste from it ... you have to rerun the query each time, and it is just a read-only report
- the utility is limited to returning no more than 1,000 rows, so if you have more than a 1,000 albums you have decide which 1,000 you want
- the query is easy to use once you have designed the query ... even if you have no SQL skills, it is just cut and paste once someone has made the query for you
- BTW is this no criticism of the Add-on ... it was never designed as a stand-in in for the missing Reporting facility, but if extended it could be a functional workaround ... if you agree you can add your voice here
- Excel can make an Album list, but the MM5 export facility is very weak:
- doesn't export the AlbumArtist tag, so every composite album (ie album containing tracks from multiple separate artists) that you have looks like multiple albums ... see tracks 3, and 8 though 18 in the first 20 "albums" on my illustration ... those are tracks, not albums
- takes some Excel skills to get the result that you want
- but at least the "report" can be saved to disk, and printed, and searched, etc
- if you think that it would be helpful if they could overcome AlbumArtist tag problem, you could make your opinion known here
Let me know If you think that either of these two flawed workarounds would be of assistance to you. I can help you.
[quote=EduMarins post_id=488083 time=1633175816 user_id=115817]
- is possible to create reports by Album name? I have interest to have a list that contains my entire collection by album names.
Example:
Artist - Album Name - Year - Bitrate - Number of tracks and so on. Not all tracks.
[/quote]
There are a couple workarounds that are usually mentioned when anyone asks how to make custom reports from their MM database.
[list=1]
[*] either load [url=https://www.mediamonkey.com/addons/browse/item/sql-editor/]the MM add-on[/url] that allows you to query the database
[*] or export your track list to Excel, and make your report there
[/list]
Your query prompted me to have little play with both today. Each could get a small way towards you want, but both have limitations which probably mean they are of no actual use to you.
[list=1]
[*] The [url=https://www.dropbox.com/s/n9je5wqe0eeayxr/SQL%20add-on%20report.png?dl=0]SQL add-on gets close[/url], but the limitations probably rule it out
[list]can't print or store it or copy and paste from it ... you have to rerun the query each time, and it is just a read-only report[/list]
[list]the utility is limited to returning no more than 1,000 rows, so if you have more than a 1,000 albums you have decide which 1,000 you want
[*] the query is easy to use once you have designed the query ... even if you have no SQL skills, it is just cut and paste once someone has made the query for you
[*] BTW is this no criticism of the Add-on ... it was never designed as a stand-in in for the missing Reporting facility, but if extended it could be a functional workaround ... if you agree you can add [url=https://www.mediamonkey.com/forum/viewtopic.php?p=488118#p488118]your voice here[/url]
[/list]
[*] [url=https://www.dropbox.com/s/h3r0udy8s8egbl1/Report%20via%20Excel.png?dl=0]Excel can make an Album list[/url], but the MM5 export facility is very weak:
[list]doesn't export the AlbumArtist tag, so every composite album (ie album containing tracks from multiple separate artists) that you have looks like multiple albums ... see tracks 3, and 8 though 18 in the first 20 "albums" on my illustration ... those are tracks, not albums[/list]
[list]takes some Excel skills to get the result that you want[/list]
[list]but at least the "report" can be saved to disk, and printed, and searched, etc[/list]
[list]if you think that it would be helpful if they could overcome AlbumArtist tag problem, you could make your opinion [url=https://www.mediamonkey.com/forum/viewtopic.php?f=30&t=100274]known here[/url][/list]
[/list]
Let me know If you think that either of these two flawed workarounds would be of assistance to you. I can help you.