INTERACT FORUM

Please login or register.

Login with username, password and session length
Advanced search  
Pages: [1]   Go Down

Author Topic: ~dup doesn't work with calculated fields?  (Read 2156 times)

mark_h

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 1854
~dup doesn't work with calculated fields?
« on: November 17, 2007, 05:01:24 am »

I have a smartlist which show duplicate tracks in my library based around:

~dup=[artist],[name]

and a bunch of other rules.

But one thing this doesn't handle is artists with articles, eg "The Hollies" and "Hollies".  I'd like to catch duplicate tracks and handle missing articles.  So I created calculated fields to remove articles, eg

~dup=[artist (no articles)],[name (no articles)]

I am allowed to create the smartilist (although I am forced to restart MC in order for the wizard to see the calculated fields after I create them) but it doesn't function as expected and returns lots of nonsense data.

So it seems ~dup doesn't work with calculated fields?

Mark
Logged

Matt

  • Administrator
  • Citizen of the Universe
  • *****
  • Posts: 42373
  • Shoes gone again!
Re: ~dup doesn't work with calculated fields?
« Reply #1 on: November 17, 2007, 11:33:29 am »

We'll take a look.  I can't think of any reason why it wouldn't work.
Logged
Matt Ashland, JRiver Media Center

eba

  • Galactic Citizen
  • ****
  • Posts: 351
Re: ~dup doesn't work with calculated fields?
« Reply #2 on: November 17, 2007, 02:07:08 pm »

I've just done a quick test on this as I have quite a few custom audio fields, both calculated and non calculated.

From what I can see it appears it doesn't like fields with parentheses.

i.e. I have a field called Song Name (Auto), which contains exactly the same as the standard Name field.
Creating a smartlist to show the dupes of this doesn't work, whereas the standard name field does.
I tried creating a field called TestName, with the same formula as Song Name (Auto), and this did work.

It doesn't work with fields with parentheses regardless of whether it is a calculated or user data field.

It does however work with any fields from the search box...

Hope that helps :)
Ben.

Matt

  • Administrator
  • Citizen of the Universe
  • *****
  • Posts: 42373
  • Shoes gone again!
Re: ~dup doesn't work with calculated fields?
« Reply #3 on: November 17, 2007, 03:14:15 pm »

Try putting a slash (/) in front of the parenthesis.  You need to "escape" some search characters since they have special meaning otherwise.
Logged
Matt Ashland, JRiver Media Center

eba

  • Galactic Citizen
  • ****
  • Posts: 351
Re: ~dup doesn't work with calculated fields?
« Reply #4 on: November 17, 2007, 07:22:13 pm »

Am just using the Smartlist wizard to do it, so have no choice as to putting escape characters in (is there a way to do smartlists manually?), but it appears to be doing so as it sets the Notes complete with / before each parenthesis.

Actually the escape characters seem to be the problem as with the search box I do it manually and don't include them, and it works.  If I use the search wizard however it puts / before each parenthesis and doesn't work.

EDIT: I think the need to escape characters doesn't apply within a field name?  But the wizard seems to put them in anyway, thus causing the problem.

mark_h

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 1854
Re: ~dup doesn't work with calculated fields?
« Reply #5 on: November 18, 2007, 03:33:20 am »

Removing the parentheses works for me too!

Mark


Logged
Pages: [1]   Go Up