Importing spreadsheet to tag releases?

Support
#1

Hi, new here. As the title states, I was wondering how i would take the information from a spreadsheet and input it into the fields for the releases I have. You can look at the spreadsheet here.

Previously, I tried exporting a .CSV and inputting the data into it manually. However I ran into issues with semicolon's and even when copying and pasting it into a plaintext file, mp3tag would fail to parse some lines.

So my question is such: Is there a way, (possibly via a script?) that would let it directly fetch and input the metadata from the spreadsheet i made?

#2

You would have to do some post-processing to get rid of semicoli or commas that are part of the text. Otherwise it would also not work if your re-imported that file into the spreadsheet program.
So, if you can, export the data to a file in which the field separator is a unique character and never part of the data.
This could be a file with the tab character as separator.
Process this file with a word processor that is capable of replacing the tab character with a printable character e.g. the pipe |.
Then save this a plain text file and use the pipe as field separator for the import with MP3tag.

#3

You don't have to replace the tab character. You can import directly with it.
You just have to create your import string with a text editor and paste it in the Mp3tag format string field because pressing Tab in Mp3tag doesn't insert the tab char.

#4

Which still means that you have to use an intermediate program.
Alternatively, if the spreadsheet program allows to define a separator other than the standard comma or semicolon, it could be a single step if one defines a printable but unique separator character which then could be used for the MP3tag import.

#5

Tried that, but now it's failing to parse any of the lines in my .txt file.

Using this format string: %_PATH% / %_FILENAME% / %ALBUM% / %ALBUMARTIST% / %ARTIST% / %ARTISTCOUNTRY% / %CATALOGNUMBER% / %COMMENT% / %COMPOSER% / %DISCNUMBER% / %DISCTOTAL% / %EDITION% / %GENRE% / %LABEL% / %ORIGINALDATE% / %TITLE% / %TOTALDISCS% / %TRACK% / %YEAR%

I HATE TAGGING.txt (197.3 KB)

#6

as far as I can see, you do not fill every column/field that you intend to fill.
e.g. the file with "Everything_Now (continued)" is lacking at least 7 fields, e.g. no discnumber and no catalogue number.

You have to supply data for every field that you name in the format string.

#7

This worked perfectly, thank you! One last question: Is there a way to tag by album rather than per track?

#8

I don't really understand.
THe data gets aligned by the filename. The filename could be anything. That we humans consider tracks to belong to one album is just our sense of ordering.
In fact, the same data for the field ALBUM may be the final result of importing the data - so the album might be detectable only afterwards.
But, of course: if you only select the files that you say belong to an album, you may tag by album.
Or what did you have in mind?

#9

Thank you for the answer.