getmusicbee.com

Support => Tips and Tricks => Topic started by: hiccup on August 14, 2018, 07:43:17 PM

Title: Hiccup's Bible of Tags (all MusicBee, Picard and MP3tag tags + tag mapping)
Post by: hiccup on August 14, 2018, 07:43:17 PM
This is an excel sheet containing all tags related to, or used by MusicBee, Mutagen, and Picard/MusicBrainz that I am aware of.

A couple of years ago I posted an earlier version, but I have been updating it for myself, and by now it also includes all tagging and scripting info on Picard/MusicBrainz that I could find.

So it seemed a good moment to share this updated version.

full sheet
(https://i.imgur.com/Igd2HDe.png)

tag mapping
(https://i.imgur.com/9ltXWXT.png)

download Hiccup's Bible of Tags (https://rebrand.ly/MB_Hiccups_bible_of_tags)

(the sheet is up-to-date for MB 3.5, Picard 2.8.5, Mutagen 1.46.0, Mp3tag 3.19)
Title: Re: Hiccup's Tagging Bible (all MusicBee & Picard tags)
Post by: sveakul on August 14, 2018, 08:03:00 PM
Wow, THANKS hiccup this is an invaluable reference!!  Appreciate all your work in creating this!
Title: Re: Hiccup's Tagging Bible (all MusicBee & Picard tags)
Post by: psychoadept on August 14, 2018, 08:12:00 PM
Nice work!
Title: Re: Hiccup's Tagging Bible (all MusicBee & Picard tags)
Post by: hiccup on August 14, 2018, 08:15:57 PM
Thanks guys, let me know if you find anything wrong, or have any suggestions for improvement?
Title: Re: Hiccup's Bible of Tags (all MusicBee & Picard tags)
Post by: hiccup on August 16, 2018, 10:26:03 AM
Updated
(some refinements and a couple of duplicates removed)
Title: Re: Hiccup's Bible of Tags (all MusicBee & Picard tags)
Post by: hiccup on August 19, 2018, 04:48:08 PM
Updated.

A couple of new entries and descriptions were added. (thanks psychoadept)
And it now has the option to create your own customized and filtered sheet.
(the 'how to' is in the 'HowTo' tab)
Title: Re: Hiccup's Bible of Tags (all MusicBee & Picard tags)
Post by: apokal on August 21, 2018, 08:58:48 AM
Great work.
Title: Re: Hiccup's Bible of Tags (all MusicBee & Picard tags)
Post by: hiccup on August 21, 2018, 12:43:55 PM
Great work.

Thanks apokal

Be sure to download the updated version that I just uploaded.
It has some improved formulas and macros, and now the 'Filtered' sheet's formulas will remain intact after using the 'remove blank rows' button.

(explanation is in the 'HowTo' tab)
Title: Re: Hiccup's Bible of Tags (all MusicBee & Picard tags)
Post by: LDGEB on September 02, 2018, 02:48:10 AM
Thank you for this. Good work.

I'm trying to use and take advantage of the information that you have conveniently provided. I'm having difficult in term of using it and putting it together though. Are you able to assist?

For example, I want to display the "Lyricist", composer is already there so that fine, but Lyricist

The Sheet say that it default in MusicBee and it is compatible with Picard, however under both the Tag Editor in Musicbee (Shift+Enter), in Tags and Tags (2) Menu this field is nowhere to be found.

If you use Tag Inspector it is there, but it is hidden away.

So does that mean I have to use one of the Virtual Tags (Tags (2), under one of those "custom:" tag for it to show?

How do you set up yours to take advantages of tags that Picard/MusicBrainz provide?
Title: Re: Hiccup's Bible of Tags (all MusicBee & Picard tags)
Post by: hiccup on September 02, 2018, 10:13:06 AM
Thanks LDGEB

In the Tag Editor you can find the lyricist under the 'Lyrics' tab.
If you have more questions about Picard and MusicBee working together, this is the thread created for that purpose:
MusicBrainz Picard Q & A thread (https://getmusicbee.com/forum/index.php?topic=16538.0)
Title: Re: Hiccup's Bible of Tags (all MusicBee & Picard tags)
Post by: Mr. Trev on September 06, 2018, 05:49:33 PM
Thanks Hiccup. Should make for a handy reference for doing offline work
Title: Re: Hiccup's Bible of Tags (all MusicBee & Picard tags)
Post by: Nigol on February 10, 2023, 12:20:52 PM
There is no need to have an macro enabled worksheet to do your filtered view. Because of the security concerns, some might be too reluctant too use it.

Here is a version with no need for it.
https://docs.google.com/spreadsheets/d/e/2PACX-1vRwkYbUohj2zC7LWOR2JkSqKGPUda33nXgTKap2xFxanJ_K4df0PlXJrcXm2Qx_FymIYnYEt57Swylj/pub?output=xlsx

See below
Title: Re: Hiccup's Bible of Tags (all MusicBee & Picard tags)
Post by: hiccup on February 10, 2023, 04:12:08 PM
There is no need to have an macro enabled worksheet to do your filtered view.
Filtering isn't working in your version.
Title: Re: Hiccup's Bible of Tags (all MusicBee & Picard tags)
Post by: Nigol on February 10, 2023, 08:54:08 PM
It does, it just seems that Google Docs messed up the conditional formatting you had for the little f. But the Filtering still works since it's all formula based, you enter the f, and it will appear in the filtered list.

Here is the direct excel file, instead of going through GDocs.
https://mega.nz/file/fY8FRYzC#aduIEaTY54-1SaeVZx4w6JLKAwa4o67ZgozvjfpdOM4

Edit:
Here is a Google Docs link for anyone that wants to just try it out. Just make a copy to you local GDrive.
https://docs.google.com/spreadsheets/d/1-6w8SBr_sPiC3f-r12UHChmAtgIKyHgFk2UZbbprL3o/edit?usp=sharing
Title: Re: Hiccup's Bible of Tags (all MusicBee & Picard tags)
Post by: hiccup on February 11, 2023, 07:13:42 AM
That one seems to work fine indeed.

Perhaps I need to review the contents of the sheet some time. It's been a while, and there are maybe some things that need corrections or updates?
But then again, nobody has ever reported any flaws or oversights, so maybe it's still o.k.
Title: Re: Hiccup's Bible of Tags (all MusicBee & Picard tags)
Post by: hiccup on February 12, 2023, 02:58:23 PM
I am going to update it.
Using a formula instead of a macro for the filtering part is probably a good idea.
Also I'll add genre mapping for MP3tag, since a lot of MusicBee users seem to use that.
If anyone has other suggestions let me know.
Title: Re: Hiccup's Bible of Tags (all MusicBee, Picard and MP3tag tags + tag mapping)
Post by: hiccup on February 13, 2023, 06:24:12 PM
The sheet was updated.

- macro's were replaced with formulas (thanks Nigol for the idea!)
- the filtered results sheet now updates instantly
- tagging information on MP3tag (tagging software) was added
- higlighting of Vorbis comments that differ between MusicBee/Picard/MP3tag was added (they display in red)
- added a tab (sheet) containing a more basic and straightforward MusicBee vs. Picard vs. MP3tag tag mapping
- other fixes and improvements

P.S.
I am not using MP3tag myself, so it might be useful if someone who does could check if the information on MP3tag is correct.
e.g., am I correct to assume that MP3tag does not have a distinction between its tag names, and its Vorbis comment tag representative?
In other words, MP3tag's names are always identical to how it names (reads and writes) the related Vorbis comment tag?
Title: Re: Hiccup's Bible of Tags (all MusicBee, Picard and MP3tag tags + tag mapping)
Post by: Nigol on February 13, 2023, 11:12:22 PM
Unfortunately your new file isn't compatible with older version of Excel or Google Docs. I am still using 2019 and these new formulas like FILTER you are using are just available in 2021 or 365. They seems very nice and might upgrade sometime, but for the people who aren't on the latest and greatest or don't have Excel and might want to use Google Docs, they won't be able to use it.

Opening in 2019 shows the filtered view, but the second you add a new field by writing an f, it breaks in #NAME everywhere. Google Docs just shows a #NAME on opening and the filtered view just doesn't work.

Maybe try with my formula, even if it's not straight forward (I had to open an old sheet and check how it was done, even then I had to split it in part to try to remember how it worked).
Title: Re: Hiccup's Bible of Tags (all MusicBee, Picard and MP3tag tags + tag mapping)
Post by: hiccup on February 14, 2023, 07:04:18 AM
Unfortunately your new file isn't compatible with older version of Excel or Google Docs.
Oh, that's a pity. It is indeed working very well with my Excel 2021 version.
At the moment I have no idea how to make that filtering work without the use of macro's (as with the previous version) or the FILTER function that I am now using for this new version.
I have a hunch it would need the ARRAY function or something. Maybe I'll see if I am able to figure that out.
(but I think to recall that I failed at that when first creating the sheet, hence turning to macros then)
Title: Re: Hiccup's Bible of Tags (all MusicBee, Picard and MP3tag tags + tag mapping)
Post by: hiccup on February 14, 2023, 06:24:06 PM
New version(s)
(download link in startpost)

The regular (new) version still needs Office 365 / Excel 2021 for the filtering tab to work properly.
But I added another version labeled 'compatible'. That one should work with older Excel versions and 3rd party spreadsheet software. (such as Google Sheets)
(neither version uses macro's)

And, concerning the filtering of tags marked with 'f': it's of course also possible to create a filter on column A yourself:
- select column A, select 'Filter' in the ribbon, check only 'f':

(https://i.imgur.com/OLrUdp1.png)
Title: Re: Hiccup's Bible of Tags (all MusicBee, Picard and MP3tag tags + tag mapping)
Post by: karbock on July 27, 2023, 06:20:39 PM
Hat tip!

P.S.
I am not using MP3tag myself, so it might be useful if someone who does could check if the information on MP3tag is correct.
e.g., am I correct to assume that MP3tag does not have a distinction between its tag names, and its Vorbis comment tag representative?
In other words, MP3tag's names are always identical to how it names (reads and writes) the related Vorbis comment tag?

Your assumption is correct:
by default, mp3tag's internal tag names do not map to the standard Vorbis comment tags.

How to match mp3tag tag names with Vorbis tag names

In mp3tag:

Column "Source" = Vorbis Comment tag name
Column "Target" = mp3tag's internal name

TagSourceTarget
VorbisCommentTRACKNUMBERTRACK
VorbisCommentDATEYEAR
VorbisCommentSOURCE MEDIUMMEDIATYPE
VorbisCommentORGANIZATIONPUBLISHER
VorbisCommentINITIAL KEYINITIALKEY

For a complete list, see this post: Tag Mapping: MusicBee, mp3tag, Picard (https://getmusicbee.com/forum/index.php?topic=39759.msg214909#post_Title_3d).
Title: Re: Hiccup's Bible of Tags (all MusicBee, Picard and MP3tag tags + tag mapping)
Post by: hiccup on July 27, 2023, 06:59:13 PM
How to match mp3tag tag names with Vorbis tag names
Thanks karbock
I have often wondered if it would be a good idea to have a comprehensive tag mapping topic post on the forum.
It including mappings for MusicBee, Picard and Mp3tag. (and maybe some others?)
But it's not something I am planning on to create myself in the near future though.

Perhaps it is something you would find interesting to do?
If so, the third tab of my Excel sheet contains some data that might be useful as a starting point.
Feel free to plunder it if you think it's a good idea and are willing to create such a post.
Title: Re: Hiccup's Bible of Tags (all MusicBee, Picard and MP3tag tags + tag mapping)
Post by: karbock on July 27, 2023, 09:33:40 PM
Thanks karbock
I have often wondered if it would be a good idea to have a comprehensive tag mapping topic post on the forum.
...

That's a nice and appealing challenge, which implies a large chunk of learning.

The first question is the significance of such a project, since your Excel table already excels... :)

Do you have in mind something more compact, that users can quickly grasp?
Or do you mean with "comprehensive" something that includes exceptions and variants/differences (such as between GROUPING and CONTENTGROUP)?

There are different ways of building such a comparison table. The first that came to my mind:

We can discuss the details by PM.
Title: Re: Hiccup's Bible of Tags (all MusicBee, Picard and MP3tag tags + tag mapping)
Post by: hiccup on July 28, 2023, 04:16:10 PM

The first question is the significance of such a project, since your Excel table already excels... :)
Thanks, but there will be some barrier in the sense that people need to download it and use Excel-capable tools to view it.
And it may be a bit unwieldy due to its vastness.
It began very small though (in an effort for me trying to understand all that weird, complicated and confusing metadata tagging stuff), but then it grew, and it grew…

I am also not sure how needed or welcomed a mapping table on the forum would be, since I don't think there have been that many questions regarding tag mapping on the forum over the years.
(or maybe the users that did have such questions found my Excel sheet?)

Quote from: karbock
Do you have in mind something more compact, that users can quickly grasp?
Or do you mean with "comprehensive" something that includes exceptions and variants/differences (such as between GROUPING and CONTENTGROUP)?

There are different ways of building such a comparison table. The first that came to my mind:

    Tag names used in different pieces of software, mainly:
    Tag names used in different audio file formats:


Yes to all.

In my mind it could be something like this:

(https://i.imgur.com/OE4xwkP.png)

There are probably more audio codecs and other software applications that could be included, but these are in my personal opinion the most essential ones for such a table.