More > JRiver Media Center 25 for Windows
Advanced Tag Editing: Remove Actors With Only One Title
andrewberg:
--- Quote from: zybex on March 06, 2021, 03:10:35 pm ---Try copying with and without column headers; try copying just 1 column, with and without header; make sure you're just copying the exact same number of movies that are selected in MC; try copying all columns (as many as are on MC's view); Try copying just 1 cell or 1 row, and select just 1 movie in MC; (...)
--- End quote ---
All options tested one by one, but no pasting tags function available...
Will start all over again, make a new view, then come back with screenshots... maybe that helps to visualize what I'm doing... ;-) Thank you guys!
andrewberg:
OK, here we are...
-- The first screenshot shows my Excel cells selected and copied for testing: 10 rows / 3 columns; the dotted outline ('marching ants') indicates the cells are in the clipboard.
-- The second screenshot, taken a few seconds later, shows the MC main window (UI language in English) with the open context menu on the same selection of files -- 10 rows / 3 columns:
#1 for 'Title', #2 for 'Darsteller/in' (= Actors), and #3 for 'Darsteller (red.)'; col. #3 is meant for the 'reduced' list, once it's been edited by VBA in Excel... As you can see, the 'Paste Tags' command is there, but still inactive...
- The 'action' pane on top has some movie specific columns, including my German custom 'Actor' fields that are also visible in the file pane.
- The navigation tree shows the current view called 'Actor' sitting directly (by level) under the 'Video' branch.
- The view scheme is "[Media Sub Type]=[Movie] -[Darsteller/in]=[] ~sort=[Date (year)]"
What do you make of it? Please advise what could be wrong, or else to try...
(Note @ zybex -- a peek at your profile told me you're located in Frankfurt, Germany -- nice surprise, which language do you speak natively? ;-)
zybex:
Try it on a Playlist instead of a View. If it still doesn't work, try Office 2019 or LibreOffice. It's likely the issue is the clipboard format. The command in MC27 is almost always available, regardless of what's on clipboard (unless it's an image)... so there was probably a fix at some point.
I'm Portuguese, and my German still sucks. I can understand it, but speaking/writing is a whole different matter. I can order an Hefeweizen though ;)
marko:
You're going to make wer cross again...
--- Quote from: wer on March 04, 2021, 05:51:12 pm ---Pasting from Excel into MC works fine, but you can only paste one tag at a time.
So you'd have to select the cells (in a column) that comprise your Actors field (don't select the header row), and when you do a paste tags, check only the Actors field.
The number of cells in the clipboard must exactly match the number of files selected in MC.
--- End quote ---
So, if I understand that correctly, you should only be copying one column of data (without the header) from excel?
Other than that, maybe it's a language thing... If the "one tag at a time" instruction still says "No", try switching your language in MC to English and see if it works then...
-marko
andrewberg:
What else to say -- I have tried every way possible to paste tags from Excel:
On smartlists, on the top level 'Video' view, selecting, copy & pasting multiple and/or single cells and/or columns at a time (note @ wer...!), both with and without heading cells -- all options tested in views containing both MC default fields ('Year', 'Title') and/or custom fields ('Darsteller/in'), just in case tag pasting should work on default fields only... still no success! :-(
@ Zybex -- I would rule out the cause of a 'fix made at some point'... What fix would it be when the feature stopped working afterwards? OK, not completely impossible, just unlikely...
@ Marko (who hasn't looked at my beautiful screenshots... ;-) -- I even changed my UI to English... However, would MC be able to detect the language of contents in the clipboard, and block the pasting command (before execution!) if German was detected? Seriously, I don't think so, rule that out.
Nor do I believe Excel 2003 cells are different from other spreadsheet charts; at least their clipboard format should be widely compatible... And yet, since MC's own tags can be copy & pasted in any view (tested), the cells' format seems the most likely cause. (By the way, if it was related to the new Windows 10 clipboard feature for copying / restoring multiple items by 'Win key + V', then MC's own tags wouldn't work either...)
To improve compatibility, I will try saving my Excel sheet in *.CSV format and repeat... Or would any of you know other tag editing software to use?
Navigation
[0] Message Index
[#] Next page
[*] Previous page
Go to full version