Print

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

[elprice7345]

I wrote an expression that looks for duplicate TV episodes in my database using the following expression: "~dup=[Episode],[Season],[Series]"

I expected it to only return files where the combination of the 3 fields was unique, for example: "30 Rock", "1", "21" would only be a duplicate of "30 Rock", "1", "21".

Instead, it returned duplicates that match the concatenated text string of the values, for example: "30 Rock", "1", "21" was a duplicate of "30 Rock", "12", "1" as in "30 Rock121"

Can this be corrected?

[MrC]

Yuck.

If the values are being concatenated, they should be joined using a unique separator to help ensure this doesn't happen.  I would have thought MC did a select on the matching values individually.

Matt?

[elprice7345]

Status?

Will this be fixed any time soon?

[MrC]

Use the Import/Export button to redine the ~dup modifier as follows:

   ~dup=[Episode]_[Season]_[Series]

The comma operator is just a concatenation.  So you can separate the field values with any separator string to help ensure uniqueness.

[elprice7345]

That didn't work for me. When I edit the Smartlist, click Import/Export, insert the new text you've supplied and click OK, it blanks out the new duplicate text string.

It doesn't seem to accept any concatenator other than commas. Any other ideas? Can the expression language be fixed?

[MrC]

It works. Just ignore what the GUI shows. I tested it.

[elprice7345]

Not for me in a smartlist. When I change the text, it blanks out the field list in the "duplicates of" field list. I click apply and the added text in the import/export box has been deleted.

Original expression:

[Media Type]=[TV],[Video] -[Season]=[] ~sort=[Series],[Season] ~dup=[Episode],[Season],[Series]

Edited expression:

[Media Type]=[TV],[Video] -[Season]=[] ~sort=[Series],[Season]~dup=[Episode]_[Season]_[Series]

Resulting expression (after clicking OK):

[Media Type]=[TV],[Video] -[Season]=[] ~sort=[Series] ~dup=

It doesn't accept anything, but commas as delimiters for me.

[MrC]

I think I must have made some mistake in my testing, because I'm seeing the same thing now.

Anyway, create a new customer user calculated field, called something like Episode_Season_Series, and define it to be the value:

   [Episode]_[Season]_[Series]

and use this value in your ~dup modifier:

  ~dup=[Episode_Season_Series]

You may have to restart MC for the field to show up under ~dup.

[elprice7345]

That works, but it's a work around for a bug in the expression language.

Any chance we can get the logic fixed so it works correctly?

[MrC]

Good to hear the workaround works.  JRiver reads all the threads, so they are aware of the issue.

[JimH]

I have to read some of them two or three times.