Print

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

[lowjoel]

Quite a significant portion of my library comprises Japanese pop, with the normal Japanese titles, artists, albums etc. I used to keep the English names together with the Japanese native names in the Name field... which was nice and fine until I started using Last.fm and picked up some Japanese. So I'm now intending to get all my tags back to follow the Japanese names, and storing the English names as a separate user defined field.

Since I'm still not too... fluent in the language, I figured I'd display the English names (I call it the Transliterated Name field) on the display if one is present in the tags. This works on my local library when the Transliterated Name field is defined. Connecting a Media Server however would cause the entire If statement to trip and display the expression string verbatim.

This is my Display Text:

[Name]If(IsEmpty([Transliterated Name]),,/ /([Transliterated Name]/)) ([Artist] - [Album])

So I'll have 花守の丘 (Hanamori no Oka) (FictionJunction - FictionJunction: Yuki Kajiura Live Vol.#4 Part II: Everlasting Songs Tour 2009) on my machine, but 花守の丘 ([Transliterated Name]) (FictionJunction - FictionJunction: Yuki Kajiura Live Vol.#4 Part II: Everlasting Songs Tour 2009) when connected to the library server.

[MrC]

I'm not seeing this here, but the symptoms seem to indicate the client don't see [Transliterated Name] as a field.  Perhaps you need to restart the client?

Btw. you should escape the last set of parens:

[Name]If(IsEmpty([Transliterated Name]),,/ /([Transliterated Name]/)) /([Artist] - [Album]/)

[lowjoel]

Escaping the last two parentheses didn't help... and those were actually from the stock messages.

I think I should clarify. My local library has the Transliterated Name field. The server which my client is connecting to does not. So it's a field defined on my client but not on the server.

[MrC]

[ I removed my previous reply, since I misread and the response didn't make sense.]

When there is no field defined, MC treats any [missing field] as plain text, so that's what you'll see.

[lowjoel]

I pretty much guessed that. Any way to short-circuit the logic? Is there a defined() function or something like that? Empty here obviously doesn't work...

[MrC]

Sure.  Test for IsEmpty() AND not IsEqual([Transliterated Name], /[Transliterated Name/])

See also: http://wiki.jriver.com/index.php/Database_Expressions_AND_OR_And_XOR

[lowjoel]

Alright, thanks.

[lowjoel]

Oh, it does seem that the | operator doesn't work in the Display Text field. The expression gets cut off after the pipe.

[MrC]

Oh, it does seem that the | operator doesn't work in the Display Text field. The expression gets cut off after the pipe.

Confirmed. I'll report it.

[lowjoel]

Thanks again.

[MrC]

Oh, it does seem that the | operator doesn't work in the Display Text field. The expression gets cut off after the pipe.

Update: This is a limitation due to some old code that uses | as a separator.  Until this is fixed someday to use the current expression evaluator code, use one of the alternate techniques to perform OR operations for customizing the Display Text.

[lowjoel]

Heh, I'm guessing only those familiar with assembly would associate + with boolean OR; and * with boolean AND

Thanks anyway.

[MrC]

Yeah, probably.  Use the nested If() version.