Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[joh]

Hi

Some library fields are logically determined by the value of another field - e.g. Composer_Birth_Year is a function of Composer, Album_Release_Year is a function of Artist + Album.

I would like to have some help with checking where I have inconsistent data - e.g. multiple library items having an identical value for "composer" have different (incl <empty>) values in the "Composer_Birth_Year") field.

Is it possible to write an expression that returns a list of all set of library items where one value in a certain field is associated with different values in another field?

Thanks in advance!

Olle

[zxsix]

I'm gonna jump on board here for a reply also.   I'm not so good with expressions yet, but I'm looking for a way to identify artists that may be tagged with multiple genres.  I think a proper answer will lead to solving both needs.

[bunglemebaby]

The closest thing that I know of is using a combination of ~dup and ~nodup, like so:

Code: [Select]

~dup=[Artist] ~nodup=[Genre]Unfortunately what this will return is actually a list of the artists that have multiple genres associated with them, but it only lists one file for each artist. But, from here you can at least use the "Locate Artist" right-click command or arrow-button to go and find the offending files.

Other smarter folks might be able to help you refine that to make it better, but that might also be all you can get currently. Also, I believe the Auto-Tagger plugin that confishy is developing will be able to do this sort of thing (or can now?).

[marko]

The problem with these is that we can only use expressions to compare fields associated with a given file. We cannot compare a field from one file with a field from another.

This means that we must resort to using smartlists and exclusions to get as close as possible, then do the rest the hard way.

The closest thing that I know of is using a combination of ~dup and ~nodup, like so:

Code: [Select]

~dup=[Artist] ~nodup=[Genre]Unfortunately what this will return is actually a list of the artists that have multiple genres associated with them, but it only lists one file for each artist. But, from here you can at least use the "Locate Artist" right-click command or arrow-button to go and find the offending files.

You are correct that the solution to this problem cannot be realised using expressions. What you're search will actually return there, is one example of every genre that exists in the library.
What you want is: [media type]=[audio] ~nodup=[artist],[genre] ~sort=[artist] which will leave one example of each "[artist]/[genre]" combination, including empty genres, that exist in the library. From there, clicking on the 'linkable columns' arrow to get at the full list of artist tracks, as you described, is quick and easy.

joh, this same logic fits for you, simply adjust the library fields in the search rule to fit your needs.

regards,
-marko.

[bunglemebaby]

You are correct that the solution to this problem cannot be realised using expressions. What you're search will actually return there, is one example of every genre that exists in the library.

Oops, I guess I should have checked those results a little bit closer...thanks for clearing that up marko.

[joh]

Thanks Gents for the support. I realize that Marco has helped me solve another problem using the same method. Sorry for not recalling it... I have seen that there is a utility (SQLMyTunes for MC) that allows export / import of the MC Library to a sql database in order to make updates like the one I asked for more efficiently - have you tried it out, Marco?

Thanks,
Olle

[marko]

I haven't, no. I have absolutely zero experience of working with sql databases, so for me, it would be unlikely to be more efficient!!

-marko.