
Bump?
Code: Select all
Pais\<[b]Pais[/b]|Split by:[b];[/b]>\<Artist>\<Album>\<Title>
Code: Select all
Pais\<Pais|Split by:;>\<Artist>\<Album>\<Title>
Jinx wrote:I just saw your post. If you still haven't found a solution try this one:
Code: Select all
Pais\<[b]Pais[/b]|Split by:[b];[/b]>\<Artist>\<Album>\<Title>
Code: Select all
Mask226=Source\<Source|Split by:;>\<Artist>
Macarena wrote:it does not work for me. I used my own CustomField name, and I also deleted some fo the BBCode:
The idea is the 40 most recently added classical albums. Some have been played, some never. Some are mp3, some flac.40 recent Classical|Icon:Top level|Filter:Songs.IDAlbum IN (SELECT IDAlbum FROM Songs GROUP BY IDAlbum HAVING Count(TrackNumber) = Max(Cast(TrackNumber As integer)) AND Count(TrackNumber) > 3 AND Songs.Custom1 = 'c'ORDER BY Min(DateAdded) DESC LIMIT 40)\<Artist>\<Album>
I am not sure that understand what you mean by "extract information", neither I know why you need that. As it is told to you in the Help forum, the Album rating doesn't exist in the database as such, but my add-on calculates that value based on the tracks ratings. Those values are displayed for each album next to their captions in the tree panel when you expand the mentioned Magic node. The Magic Nodes add-on has not an option to export those values to some textual or similar file, but you have at least two another possibilities for that. The first one could be applied using the Tree Report add-on: you should select the mentioned Magic node and choose Tree Report option from the File menu - after you click on the Save As button you would get the .html file with the same data as they are displayed in the selected branch.rrfpacker wrote:ZvezdanD,
Is there a way to extract information from a node? I have a node you helped create (see below) and I would love to see the weighted calculation by album that it creates. Is that possible? Thanks.
<Group|Name:Album Ratings|Show tracks:No>\Albums with weighted avg. track rating >= 3 stars and at least 5 rated tracks|Icon:Top level|Filter:Songs.IDAlbum In (SELECT IDAlbum FROM Songs WHERE Rating >= 0 GROUP BY IDAlbum HAVING Sum(SongLength * Rating) / Sum(SongLength) >= 60 AND Count(Rating) >= 5)|Child of:Playlists|Position:Child\<Album|Sort by:Avg(Rating)|Statistic:Count(All)>
Thank you for such detailed bug report. Unfortunately, the mentioned problem is not caused by my add-on, but because of the program itself, and I cannot do anything about it. This bug appears since MM v3.0 and MM developers are informed about it already several times in the past.Anamon wrote:There seems to be a weird bug with the order of tree nodes using Magic Nodes 4.2 on MM 4.0.6. I haven't used MM in a while, so I don't know about earlier versions. It seems to happen when trying to position a Magic Node after the last regular collection node.
ZvezdanD wrote:I am not sure that understand what you mean by "extract information", neither I know why you need that. As it is told to you in the Help forum, the Album rating doesn't exist in the database as such, but my add-on calculates that value based on the tracks ratings. Those values are displayed for each album next to their captions in the tree panel when you expand the mentioned Magic node. The Magic Nodes add-on has not an option to export those values to some textual or similar file, but you have at least two another possibilities for that. The first one could be applied using the Tree Report add-on: you should select the mentioned Magic node and choose Tree Report option from the File menu - after you click on the Save As button you would get the .html file with the same data as they are displayed in the selected branch.rrfpacker wrote:ZvezdanD,
Is there a way to extract information from a node? I have a node you helped create (see below) and I would love to see the weighted calculation by album that it creates. Is that possible? Thanks.
<Group|Name:Album Ratings|Show tracks:No>\Albums with weighted avg. track rating >= 3 stars and at least 5 rated tracks|Icon:Top level|Filter:Songs.IDAlbum In (SELECT IDAlbum FROM Songs WHERE Rating >= 0 GROUP BY IDAlbum HAVING Sum(SongLength * Rating) / Sum(SongLength) >= 60 AND Count(Rating) >= 5)|Child of:Playlists|Position:Child\<Album|Sort by:Avg(Rating)|Statistic:Count(All)>
The another possibility to get album ratings into some file could be accomplished using the RegExp Find & Replace add-on: select all tracks from the wanted albums and choose the "Assign weighted average Rating of album to <Into Field>..." preset, then specify some unused custom field to store those values. After that you could use some report option from the File menu to get that custom field exported to the textual or .html file. If the built-in reports don't support export of that field, I suppose that there exists some add-on which is able to do that, e.g. Custom Report.
Well, I still don't understand what you mean with "extract information". If you just want "to see" those values, you already could do that. Just expand the mentioned Magic node and you would see the album ratings in the front of each album.rrfpacker wrote:ZvezdanD wrote:I am not sure that understand what you mean by "extract information", neither I know why you need that. As it is told to you in the Help forum, the Album rating doesn't exist in the database as such, but my add-on calculates that value based on the tracks ratings. Those values are displayed for each album next to their captions in the tree panel when you expand the mentioned Magic node. The Magic Nodes add-on has not an option to export those values to some textual or similar file, but you have at least two another possibilities for that. The first one could be applied using the Tree Report add-on: you should select the mentioned Magic node and choose Tree Report option from the File menu - after you click on the Save As button you would get the .html file with the same data as they are displayed in the selected branch.rrfpacker wrote:ZvezdanD,
Is there a way to extract information from a node? I have a node you helped create (see below) and I would love to see the weighted calculation by album that it creates. Is that possible? Thanks.
<Group|Name:Album Ratings|Show tracks:No>\Albums with weighted avg. track rating >= 3 stars and at least 5 rated tracks|Icon:Top level|Filter:Songs.IDAlbum In (SELECT IDAlbum FROM Songs WHERE Rating >= 0 GROUP BY IDAlbum HAVING Sum(SongLength * Rating) / Sum(SongLength) >= 60 AND Count(Rating) >= 5)|Child of:Playlists|Position:Child\<Album|Sort by:Avg(Rating)|Statistic:Count(All)>
The another possibility to get album ratings into some file could be accomplished using the RegExp Find & Replace add-on: select all tracks from the wanted albums and choose the "Assign weighted average Rating of album to <Into Field>..." preset, then specify some unused custom field to store those values. After that you could use some report option from the File menu to get that custom field exported to the textual or .html file. If the built-in reports don't support export of that field, I suppose that there exists some add-on which is able to do that, e.g. Custom Report.
Thank you so much for your response, however, I won't be able to research/try either of your suggestions for about a week. I'm not ignoring you, will just be away from MM.
As to why I want to see the calculation, I just think it would be fun/interesting to see my albums ranked using MN weighted calculations. I can get most of what I want using Trixmoto's Advance Report, but I think your node calculations would be closer to actual album ratings. Thanks again.