More > JRiver Media Center 25 for Windows
Advanced Tag Editing: Remove Actors With Only One Title
zybex:
Andrew... you make it hard by not following the suggestions above. All of them have some reasoning behind them.
Fix made at some point: I meant (obviously) a fix added AFTER your version, since that command works fine on the current versions. Since you're unwilling to try new versions, we can't even tell if the problem is MC or Excel.
Changing UI to english is because we are aware of some other weird problems in the past where MC internals was expecting some english string and would not work with other languages. There were a number of fixes for this over time (as the issues were discovered), so maybe this was the case here. Hence Marko's suggestion.
Clipboard object format: no, it's not the same. Data/text/objects in clipboard have a number of different formats; over time, new formats are added to support new features (by Microsoft and others). Also, MSOffice changed its file format since version 2007, and you have an older version which still uses the old formats - so YES, it's extremely likely that Excel 2003 is putting data on the Clipboard using a data format which is no longer common. Since MC was developed after 2007, it's likely that it is expecting the new format. Clipboard is not magic, apps need to speak the same object language to actually transfer between each other (unless it's simple text without formatting, which is not the case here - a table is not text).
Not sure if MC accepts CSV format from the clipboard. Try it. But you'll have to open the CSV in notepad and CTRL+C from there... if you CTRL+C from Excel it's still the same object format.
andrewberg:
Thank you Zybex, all making good sense...! However, when I copied no headings like 'Title', 'Actors' etc, where could be a language specific issue for MC? I have also tried copy & pasting from .csv (created in Excel), and from Notepad (using the exact same lines from CSV) -- the Paste Tags command remains unavailable.
I would agree with you that MC can detect incompatible clipboard contents, and block it from pasting, but what's incompatible in semicolon delimited text (not comma, as the name 'CSV' suggests for 'Comma Separated Values'... ;-)? Anyway, it gets frustrating to see no success after any option we thought of has been tried...
Let's focus on the second approach instead -- if we get that working right, there is no more need for editing my actors database! ;-) So, in order to use the original string "ListLimit([Actors],2)", avoiding any language conflicts, I have transferred all actors from my custom field to MC's default 'Actors' field.
Now my custom field ('Darsteller (red.)', meaning 'reduced') can use the calculated data from original 'Actors'... However, this returned very odd results, as it simply replaced the string [Actors] with all actors it found in the first matching title, so for example:
"ListLimit[Charles Chaplin; Jackie Coogan; Albert Austin,2)"
Was there a mistake in the syntax? I also noticed the "ListLimit" function is not available under 'Manage Library Fields > Calculated Data > Expressions' in my MC version... Has it been added in a later version only?
zybex:
Added around 25.0.69:
https://yabb.jriver.com/interact/index.php?topic=121209.0
https://wiki.jriver.com/index.php/Release_Notes_MC25
Have you upgraded MC yet?
Have yo upgraded Excel yet?
andrewberg:
--- Quote from: zybex on March 07, 2021, 12:29:23 pm ---Added around 25.0.69:
https://yabb.jriver.com/interact/index.php?topic=121209.0
https://wiki.jriver.com/index.php/Release_Notes_MC25
Have you upgraded MC yet?
Have yo upgraded Excel yet?
--- End quote ---
Wow, that's interesting -- especially as the function was customized for [Actors] -- and might give me a first reason to upgrade, to answer both questions (Excel upgrade, rather not... ;-)
But before, I would like to reduce my actors-based network views, to only create lists that my TV can handle (1,008 items on 63 pages)... I tried to limit the view to 4+ ratings, but that still returns too many, because it includes all actors for any 4+ rated film, and creates a result for each ;-) There are so many expressions & functions, maybe another will do the trick?
>> If you don't mind have another look at my previous post, edited heavily afterwards... ;-) Thank you!
zybex:
LibreOffice is free and fully compatible with Office 2019. You don't even have to uninstall 2003.
I have no idea what functions work on v25. You can play around with Zelda to test and find something that works for you.
Navigation
[0] Message Index
[#] Next page
[*] Previous page
Go to full version