Duplicate fields in metadata with different values

Hello everyone,

I write from Chile, South America. I am a fan of metadata, and I want to make improvements to my clubs, to enjoy them obsessively.

I need, please, help me to work better on the following:

BASIC INFORMATION

  1. I am using the following "Format String":

%dummy%,%artist%,%album%,%track%,%title%

  1. I handle the CSV files in the following way, as in the example given on this same page:

87,Sigur Rós,Ágætis byrjun,1,Intro

ISSUES:

A. I want the track to be ordered as follows:

But if in the format string i add a duplicate field, for example:
Composer: composer 1
Composer: composer 2

Automatically it will then be seen only in one composer column, and not in 2, as in the image i showed previously (I made that one manually).

How should i correctly configure the software or the CSV so that this does not happen?

How can i make a configuration so that the format string and data are in the same CSV? Because currently i have to put the format string manually in the software, which makes the process very slow. I want to do this with more than 2,000 albums.

Thank you very much everyone, i look forward to any comments.

Nicole.

Use $meta_sep(composer,, ) to see all the data from all the composer fields.

If you want to import data from an external file into several fields of the same type (e.g. composer) you would have to prepare the external data so that it looks like
Beethoven\\Mozart\\Haydn where each composer name is separated from the others with two backslashes.
The format string would still only contain a single reference to %COMPOSER%. MP3tag would then take the \\ as separator and split the data into several composer fields.

AFAIK this is currently not possible.

I'm just curious:
Why would you use a different CSV content structure for every of your 2000 albums?

I thank you very much. It's good to have such a clear guide when you're learning.

This example worked perfectly for me:

Beethoven\Mozart\Haydn
*I am indeed using an external source.

Now i only have the doubt if it is possible for the same CSV to use the format string and also contain its data, since currently I must put the format string in Mp3tag, manually, and attach the Excel only with the data.

Just out of interest: which spreadsheet function is so useful and not part of the MP3tag functions that you have to take the bother of export and import of data via text files?

Hello, maybe i'm getting too complicated with that problem, and i don't know how to explain it well.

I need to sort by track, since each of these tracks has different data. In some, for example, there is data that in others there is not. Exemplified as follows:

Track 1:
Composer
Track
producer

Track 2:
Composer
Track

Track 3:
Composer
Track
Engineer

And I think that if i use a format string for the entire disk, it will fail because it has a different order, that's why i wonder if there is any possibility of keeping the "Data Field" and the "data" in the same Excel, by line, and that in this way everything is imported, reading them automatically by tracks.

It is also possible that my logic is not correct, and that is not the way to do it.

Sorry for my ignorance. I am very grateful for the good reception and help.

Maybe there is a more effective way to do it, but basically I'm pulling the information out of Roon, using software to read characters, and then using Visual Basic to manage an organization of data to import directly into Mp3tag. The latter is what i need help with, making it more efficient.

Basically, the organization of my data is in two Excel columns, one:

COMPOSER: X1
COMPOSER: X2
Album: x
etc

You would have to set the empty positions too and always use the same amount of fields.
For your example it would be:

Composer;Track;producer;
Composer;Track;;
Composer;Track;;Engineer

with the Format string:
%composer%;%title%;%producer%;%engineer%

And it would be filled as

"01 - Test.mp3" ->
composer: Composer
title: Track
producer: producer
engineer: 

"02 - Test.mp3" ->
composer: Composer
title: Track
producer: 
engineer: 

"03 - Test.mp3" ->
composer: Composer
title: Track
producer: 
engineer: Engineer

For that problem you can follow the instructions in the documentation:

Matching files from the text file to Mp3tag’s File List

Usually, Mp3tag uses the sequential order of the entries in the text file and applies it to the file at the same sequential position the the range of selected files. This means the files need to be in the same order as the entries in the text file.

You can use %_filename_ext% or %_path% to perform matching based on the file name or the abolute file path respectively.