Why is it so that if you have same info on Title and Original Title fields, Original title info disappears when you save the profile? It would be usefull to have that info, even if it is the same as in the Title field.

If you run SQL-queries to exported data, for example in Cinematic Collection viewer to find award statistics, it is a bit tricky 'cause award files have original titles and english titles and if you have non-UK or non-US release Title doesn't match with them in most cases. If you use Original Title field instead you miss all the movies where title is not localized and therefore you can't use original title eather. It's a bit tricky to explain but I hope that at least someone understood.

The only way that I have managed to get it work, is to use Sort Title field as "Original Title" with The, Der, etc., but that screws up the sorting. Any better ideas?

For example:

#1
Title: The Lord of the Rings: The Return of the King (non-localized release in Finland)
Original Title: cannot be used

#2
Title: Tulkki (localized release in Finland)
Original Title: The Interpreter

If I use a Title as a search field, I miss #2 compared to awards file Original and English title. If I use Original Title as a search field, I miss #1. All problems would be solved if we could have:

Title: The Lord of the Rings: The Return of the King
Original Title: The Lord of the Rings: The Return of the King

...and just use Original field in all queries.

Quoting northbloke:

Quote:
I know that when creating HTML windows, the ORIGINAL_TITLE tag has a UseTitleIfBlank attribute that you can switch to true.
Are you able to use that at all?
I'm not very good at SQL or exporting data, so I don't know if this is any good to you.

Nope, doesn't help. This info must be included in exported .xml file.

Have you ever tried 'COALESCE'?

select COALESCE(Original_title,title) from (...)

See here:
http://dev.mysql.com/doc/refman/5.1/en/comparison-operators.html#function_coalesce

Note: Not sure what engine you are using but oracle, db2, etc. have the same function as well...

Cheers, NEWT0N