Album Artist: | 4kuba |
Album: | Phunky Maiden |
Track List: | 1. Phunky Maiden |
2. Phunky Maiden (Feat Mars) | |
3. Phunky Maiden (Access Denied Remix) | |
4. Phunky Maiden (Kid Digital Remix) |
Fields | |
Album Artists | |
Data Type: | List (Semicolon Delimited) |
Calculated Data: | =[Album Artist (Auto)] |
Relational: | Non Relational |
Artists | |
Data Type: | List (Semicolon Delimited) |
Calculated Data: | =listcombine([Artist Supporting],[Remixer],\,;)&datatype=[list] |
Relational: | Non Relational |
Artists Calc | |
Data Type: | List (Semicolon Delimited) |
Calculated Data: | =if(isequal([Album Artists],[Artists],7),[Album Artists],[Artists]) |
Relational: | Non Relational |
Artist Supporting | (This field is for songs that feature an artist) |
Data Type: | List (Semicolon Delimited) |
Relational: | Non Relational |
Remixer | (This field is for songs that are remixed by an artist) |
Data Type: | List (Semicolon Delimited) |
Relational: | Non Relational |
View Schemes |
Album Artist | |
Expression: listcombine([Album Artists],[Artists Calc],\,;)&datatype=[list] | |
Disc Type | |
Year Album | |
Artist | |
Expression: listcombine([Artist],[Artists Calc],\,;)&datatype=[list] | |
Disc Type | |
Year Album | |
I made some errors but I've now rectified them. Note that where is says &datatype={list} the list should be in square brackets, for some reason them I put the word list in square brackets it would disappear when I posted. Also the Album Artist view scheme expression has been fixed, third time lucky
I hope anyone that can wrap there head around this can help me improve it and or find bugs with it.
Field Name | Expression | Description |
[Album Artists] | =listbuild(1,;,[Album Artist (Auto)])&datatype=[list] | I've done this because I have some multi artist albums and I have opted to just using ;'s to seperate the artists in the Album Artist (Auto) field. The list build is so that I can draw upon the Artists field and the list will allready have seperated the Artists This in my eyes makes it easier to work with. (I am not too sure if this is how you are supposed to do it) |
[Calculated Artist] | =listbuild(1,;,[Album Artists],[Artists])&datatype=[list] | This makes a list of the Album Artists and the Artists (Which includes Contributing Artists and Remixer) |
[Artists] | =listcombine([Artist Supporting],[Remixer],\,;)&datatype=[list] | This combines the Artist Supporting and Remixer fields |
[Artist Supporting] | N/A | This is a field that I manually complete for artists that feature on other artists songs |
[Remixer] | N/A | This is for the artists that remix songs |
Image | Description |
(http://thumbnails37.imagebam.com/14893/946858148921701.jpg) (http://www.imagebam.com/image/946858148921701) | This is the image of my test ep, The artist is 4kuba and the album is Phunky maiden. As you can see from the left it is focused on the artist 4kuba. The first track, I added the 3 Daft Monkeys the the remixer field and thus it had filtered thorugh to the Calculated Artist field. You will see on the next image that I have achived what I set out to do. |
(http://thumbnails28.imagebam.com/14893/0b1c7b148921715.jpg) (http://www.imagebam.com/image/0b1c7b148921715) | This is the view with the Artist 3 Daft Monkeys selected as you can see because they are the hypothetical remixer of the 4Kuba track that it will also show up in the 3 Daft Monkeys Pane. |
(http://thumbnails52.imagebam.com/14893/c1c0f6148921728.jpg) (http://www.imagebam.com/image/c1c0f6148921728) | This is where the bug is at,the remixer of this track is 7 Hurtz but the album artist is Black Strobe. This would be ok if I had a 7 Hurtz ep but I don't. Is there someway to check if I have any other albums by the remixer or contributing artist and if there is not filter it out? I hope so. |
Is there someway to check if I have any other albums by the remixer or contributing artist and if there is not filter it out?
Shame J River isn't built around Relational databases. I would be nice if it had both and the users could decide which one they want (Or both [I'm not sure if that is possible])
I understand what you meant but I'm not ready to disband the directory tree way. (I have a small monitor, so the panes would take up alot of vertical space)
How would I go about adding the Remixes and featured artists tracks to a virtual folder at the top of the directory structure in conjunction with all the calculated fields and view scheme expressions I have already used?
I don't think this is relational because its just a list to check a non relational field against.
The attached screenshot illustrates how I handle this in my primary (Panes) view.
I'm interested in your "Filters" column in this view. I'd like to do something like that. Are "filters" playlists which you created?
I anticipated your question and changed the name of the pane to "Search Lists," since that's that's what they are. ;)
Just make the Category/Pane a "Search List" type. Then each item added to the list is an independent search. Those would normally be just like a smartlist, but can also reference any existing playlist using the rule: Playlists is any (playlists selected from dropdown). The actual search uses internal playlistid's to associate files with playlists.
listbuild(1, \, [Genre], [Style])&datatype=[list]
I don't have a 'Styles' field. Do you mean the 'Display plural name' of the style field? Or is the Styles field another you created? How can I implement what you have done?
For example I have one compilation CD that contains many artists and styles...
From what I understand I am not supposed to use Genre as a delimited list type field?
Do you import the data from Allmusic into your custom field automatically?
Do you know of any online resource that just has a list of Genres that I can use as a guide?
I will need to take a time out with this one and ponder with this one...
I agree with making music only specific to one genre, it would be nice otherwise but you'd have to know your library inside out and tagging properly would be a nightmare, too many areas for error.
Replace(•Replace([Styles], ; , •), •, ;[Genre]\)&datatype=I am wondering if I can use your expression to change the ";" circled in red in the image to a " & " for purely aesthetic reasons?
Thanks Rick.ca
I think I'll keep trying, to get it to work as well as doing it with panes, I like having dual functionality.
Would it be possible in future development, that you could theoretically make the ability to make one field truly relational?
Say for instance this is plausible. I don't know how it would function but this is how i think of it.
The field I would use would just be used to flag other fields. I would call it "List Of Album Artists" it would be a semi colon delimited list
I would use list build as the expression to populate the field with album artists, here is where I think it could function different from other fields. Instead of data populating information for each individual file, the list build would build a semi colon delimited list and store it in a text file. It would contain of all the Album Artists (Or whichever other field) in one list. J River would have to periodically update this list (Probably dependant on specific events), so it would be probable that a limit would have to be set upon the number of these fields that could be used to keep performance up.
I could then use this [list of Albums Artists] in conjunction with my [Calculated Artist] field to filter out all of the calculated artists are not listed in [list of Album Artists] (Which is essentially a text file that bears no relation to any files)
I would then get a nice Album Artist view scheme that would contain all the remixes, appearances and featured tracks only if the artist in question actually had an album of their own.
I don't think this is relational because its just a list to check a non relational field against.
For me this functionality would open up lots of new possibilities without being too cumbersome to wrap my head around. (I'm not sure on performance though)
Thanks again
I'm not sure I understand 100%, but are you trying to group together all of a particular Artist's work that is not on their albums (Album Artist)?
Supporting Artist | |
If a track has a featured or supporting artist, it will be entered here. If there are multiple artists they are both entered and seperated using the ";" delimiter. | |
Remixer | |
If a track is remixed by a certain artist, it will be entered here. If there are multiple remixers they are all enteres and seperated using ";" delimiter | |
Those were my information fields I then had to make some expressional fields to get the results I wanted. The way I seen it I have four fields; Supporting Artist, Remixer, Album Artist & Artist. I had to somehow merge that information and then compare it to the Albums Artist. If it was a match it would be combined in the View Scheme.. | |
#List Album Artists & Artists | |
=listcombine([Album Artist],[Artist],\,;)&datatype=[list] | |
This expression comnines the Album Artist and Artist fields and puts that info in it's field.. | |
#List Supporting & Remixers | |
=listcombine([Supporting Artist],[Remixer],\,;)&datatype=[list] |
This expression comnines the Supporting Artist and Remixer fields and puts that info in it's field.. |
#Calculate: |
=listbuild(1,;,[#List Album Artists & Artists],[#List Supporting & Remixers])&datatype=[list] |
This Expressional Field just merges the previous two fields. I only did this because it made it easier for me to make an expression that would use the data in a view scheme. |
To use all these fields I made a view scheme and added an expressional category with the expression "listcombine([Album Artist],[#Calculate],\,;)&datatype=[list]". |
I don't think what I was trying is possible in J River but I've got close enough and learnt to live with it.. |