Author Topic: Hiccup's Bible of Tags (all MusicBee, Picard and MP3tag tags + tag mapping)  (Read 10626 times)

hiccup

  • Sr. Member
  • ****
  • Posts: 7937
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.

hiccup

  • Sr. Member
  • ****
  • Posts: 7937
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?
Last Edit: February 13, 2023, 08:31:18 PM by hiccup

Nigol

  • Newbie
  • *
  • Posts: 4
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).
Last Edit: February 14, 2023, 01:35:01 AM by Nigol

hiccup

  • Sr. Member
  • ****
  • Posts: 7937
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)

hiccup

  • Sr. Member
  • ****
  • Posts: 7937
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':

Last Edit: February 14, 2023, 07:16:46 PM by hiccup

karbock

  • Sr. Member
  • ****
  • Posts: 358
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:
  • Select menu File/ Options... (Ctrl+O)
  • Select tab Tags/ Mapping
  • Create new entries (star button) with the values below.

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.
Last Edit: August 15, 2023, 10:41:36 AM by karbock

hiccup

  • Sr. Member
  • ****
  • Posts: 7937
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.
Last Edit: July 27, 2023, 07:22:47 PM by hiccup

karbock

  • Sr. Member
  • ****
  • Posts: 358
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:
  • Tag names used in different pieces of software, mainly:
  • Tag names used in different audio file formats:

We can discuss the details by PM.
Last Edit: July 28, 2023, 03:26:11 AM by karbock

hiccup

  • Sr. Member
  • ****
  • Posts: 7937

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:



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.
 
Last Edit: July 28, 2023, 04:27:58 PM by hiccup