Custom field filling with import from csv file [in Linux Mint/Puddletag]

Hello. I'm a new member.

I would like to know how to automatically fill a custom field from a list, prepared in a text file.

I have a CSV file containing the artist, the title and the peak level (in dB) of each song, presented as follows:

Name of artist;Title of song;-0.14 dB

I first created the custom peak_level field.

I've tried the various functions that seem appropriate, but I don't know the exact syntax.

Thanks.

You could start with these instructions:

Let us know if you need specific help.

Your Format string should look like this:
%artist%;%title%;%peak_level%

Please note that a semicolon inside your artist name or title cause difficulties for the import.
The separator should be as unique as possbile and should not exist in the data itself.

Thanks for the quick answer, but it doesn't work. I tried with this syntax and went through the Convert/Clipboard -> Tag menu. But if I try to insert the values in a custom field, it doesn't work. On the other hand, it's ok if I use a stock field, for example:

%artist%,%title%,%comment%

I don't know why it doesn't work with a custom field.

Is this menu point available on Mac?
I don't find it on my Windows Mp3tag v3.28c.

If I import the CSV line
Name of artist;Title of song;-0.14 dB
with the menu Convert -> Text file - Tag
and the Format string
%artist%;%title%;%peak_level%

I get this 3 fields as result in my 01 - test.mp3 track

Please show us some content of your real CSV file.

In the initial question you write about fields separated by a semicolon.
In your second answer you seem to use a comma a separator in the Format string.

The separator in the Format string has to be exactly the same as the one your CSV file.

Sorry. I run under Linux Mint and I use the Puddletag fork. I thought it was exactly the same as MP3Tag.

Anyway, it's the same with the Text to Tag function.

I wonder if it would be possible to fill in the how field and then copy the values to the peak_level field?

Sorry, I have no idea about "Linux Mint" or a "Puddletag fork".

If you speak about this "Puddletag" I suggest to ask over there in the support forum of Linux Mint/Puddletag.

Mp3tag and Puddletag are two different applications, even if Puddletag claims:

puddletag is an audio tag editor (primarily created) for GNU/Linux similar to the Windows program Mp3tag

Okay, I think I've got it. It looks like it's the underscores that are the problem in Puddletag. Why? I don't know. I renamed the field to peaklevel and it works (with import function or clipboard).

%artist%,%title%,%peaklevel%

Thanks for the feedback and your finding.

I hope that you can find some function in Puddletag that can copy your content from PEAKLEVEL to PEAK_LEVEL and then deletes the no more needed field name without underscore.

As it's not a standard field, it doesn't matter that it's named without underscores.

Now I need to see how to proceed for files in recursive folders (albums).

It's not as easy as I thought. I'm French. I have many pieces of music that contain “special” characters.

Example: Étienne Daho

In my spreadsheet (LO Calc), when I sort the file name alphabetically, É comes after E. But in the Puddletag sorting, it comes after Z. And it's the same for accented lower-case letters within words (Cé comes after Cu instead of Ce).

So I have to be very careful and classify my text file in the same way as Puddletag. I had naively thought that the function system would automatically look for the line corresponding to the file (or to the artist/title) to enter the values.

Please understand that this is the Mp3tag Community. If you're looking for support regarding puddletag, please refer to their respective support channels.

I installed MP3Tag under Wine. The functions are the same and the problem I mentioned earlier regarding alphabetical sorting is identical.

I think you have to change your sorting scheme in Linux.

The alphabetical arrangement of files under Linux is correct. It's the same as under Windows; it's in the Puddletag (and MP3Tags) interface that something goes wrong (and there are no setting options in either of these programs).

In any case, we can consider the issue resolved. But rather than inserting values into fields with an exact correspondence of lines, wouldn't it be possible, by specifying the file name, to have the values inserted according to that name, thus, without having to worry about the order?

You can define the property "Sort by" for each column in which you e.g. replace accented characters with the plain ASCII one.
Also it may be worthwhile to check the options Ctrl-O > General and the settings for sorting.

In the sorting preferences, I have artist, title. If there's a way to replace special characters in the sort, I don't know how to do that.

Here is a list of special characters:

See the documentation how to customize the file list:

See the documentation on how to use scripting functions:

In your case it would be $replace(%title%,É,E,é,e,etc...) as setting in Sort by.

Do you refer to puddletag again? If so, please leave this forum and ask the puddletag support. puddletag and mp3tag are not the same.

No, MP3Tags (under Wine). :slightly_smiling_face: