How to import/create data on an Album Basis?

MY GOAL:
I need to automatically create or import information on an Album basis, which is to say, information that regards the Album, ant not any individual track, which means that it is repeated for all the tracks of that same album.
Examples are: Album Number (my own ID), Album Title, Album Artist, Genre, and other similar fields.
I usually create a discography list of my artists on an Excel spreadsheet, and it would be great to be able to import it using Mp3Tag. I know how to export, and I know how to import.

THE PROBLEM:
I can't find a way of associating one record from the import file, with many records from the mp3Tag database. Another possibility would be to do a GROUP BY sort (very common in SQL statements), but again, I can't find a way to do such a thing.

ANY HELP?
This is a typical 1-to-Many database relation, so I don't know if I am missing something here.
If I am, then please let me know, because I desperately need this.
I already searched the Web and the Mp3Tag Forum, but I never came across a solution.

PURPOSAL:
If there is no solution, I hereby propose Florian to please add one such function or method, because it could spare lots of time in the starting of a new artist collection, which is what I'm doing right now (creating a new library for all my artists, with all the tags correctly placed).

MP3tag does not know anything about albums
Mp3tag only looks at one track at a time. So I doubt that any kind of database like 1:n-scheme would be implemented.
For the time being you would have to supply (all) the (duplicate) information that qualifies each file.

So, if you have your excel sheet, it should be easy to copy the information.

Just a wild thought:
If you have the files separated so that all files of a single album are in one folder, AND the excel sheet would supply the complete data for at least the first file THEN you could try to rename the album folder in such a way, that it could be possible to retrieve the repeated information from the path. This would then save you the trouble to either copy it in the excel sheet or with the use of the tag panel.

Thank you for your answer.
Well, Mp3Tag does know something about Albums, as well as Artists, because they are the next two big things after a track. Mp3tag wouldn't be able to organise anything without an Album and an Artist, would it? So I think this is not so far fetched as it might appear at first glance and I think it would improve mp3Tag a lot!

As for coying the information in Excel, I already gave it a try, but it is not practical at all.
Unfortunately it doesn't allow to copy and insert full lines. So you must first create new lines, and only then copy the information. And You would have to know how many lines to create for each album, which would require a new information: number of tracks per album (which I don't use, so it would be an added extra effort, which is precisely the opposite of what I want eheheh). I it would have to be manual labour for sure. :frowning:

Your idea of getting info from a folder name is interesting, but it wouldn't work in this case for two reasons:

  1. I would have to put that info on the folders somehow, and I can't think of a way to easily do it systematically in mp3Tag. Maybe using a Renamer external application, but even so, it would be very awkward (if possible at all because of the characters involved) because I need a lot of info. Here is and example:

Fields: Artist~[Year-Month] Album~All Genres~Publisher~MediaType~Quality

Example Record: Vangelis~[1981-03] Chariots Of Fire~Ambient\\Modern Classical\\Soundtrack~Polydor~FLAC~High

Note: I'm using the tilde (~) as separator.

So, any other ideas? :slight_smile:

No, believe me: MP3tag does not know anything about this kind of data until you have entered it. It is impossible to find the album or artist with MP3tag if you only have the title. Or the track number.
Only after the tagging you can filter or sort data accordingly.

If you export the data to the FIRST track of an album and then use an action of the type "Format value" for _DIRECTORY with all the data you have mentioned in your example then all the files of that folder get moved to the new one (or better: the folder gets renamed).
You can then use either the Convert>Filename-Tag function or an action of the type "Import field" for _FILENAME to get the data out of the file system information.

If you're really working on an album basis and not the whole library, you can create .txt files for import (from Excel, I guess) with only album data repeated, let's say, 50 times (lines). Then, when you import it on an album basis, no matter how many tracks the album has they will all be populated (unless you have multi-disc ones, so maybe 100 is a safer bet).

If I got you right, your idea seems good, although I wouldn't be able to use it to import all sorts of fields because of character's restriction in the names of folders.
However, even worst than that is that it suffers from the same problem I have: how to isolate that only one track and use it as reference for the entire album? That's why I wanted a GroupBy function. :slight_smile:
So I'm afraid it won't work.
But thanks. Your idea of using the folder name to fetch data is interesting, and I think I will have some proper use for it though. :wink:
So thank you very much. In the end you did give me some precious info. :slight_smile:

Actually, I'm working on entire libraries from an artist at a time, but in the beginning, there might be nothing more than the track title and number, all in each album folder, of course. But besides that, nothing...
I collect a lot of info for each album on an Excel spreadsheet before starting, because it will be easier afterwards.

Your idea as a whole is very interesting. I adapted it to my needs, and now I do have a relatively easy and fast mehtod of importing AlbumData. Thank you! :slight_smile:
I must still work only on an album each time, but there is no other safe way of doing it in the beginning, especially if I don't have a year+month of release/recording. So it's acceptable.

In case someone needs this as I do, I built a framework on how to do this. Here it is.
EXPORTING ALBUM DATA

  1. Copy all the album data from excel to a blank text file
a) Select all these fields (columns in the Excel spreadsheet): Album#(%ALBUMSORT%), Year, Month, Album, All Genres, Publisher, MediaType, Quality - Add Optionally: AlbumRating, Comments (with a Web Link to Album Info)
2. Do two Find-Replaces:
- Replace all Tabs with tildes (~), using RegEx: FIND...: \t REPLACE: ~ - Remove extra space in the end of a field (just in some cases): FIND...: ~ REPLACE: ~
3. Select all the lines, and then copy them back exactly 54 times
This way it will allow for exactly 2 PageDown presses to select an entire album. ;-)
4. Then sort all the lines in Ascending order.
I use EmEditor which allows this sorting. If your text editor doesn't allow it, use Microsoft Word. ;-) This will put all the lines of the same album together, and order all the albums as well. ;-)
5. Select all the lines of the first album and cut (move) them into a new file. 6. Copy the data fro mthe first 4 fields and use it as the name of the file, in the format:
%ALBUMSORT%~%YEAR%~%MONTH%~%ALBUM%
7. Repeat steps 5-6 until all the albums are done.

IMPORTING ALBUM DATA

  1. With Mp3Tag, open each album directory at a time.
  2. Select all files.
  3. Operation: Text file - Tag
- Filename.....: E:\Music\To-Do\\%ARTIST%\0. Docs\Exports\Album Data\.txt - Format string: %ALBUMSORT%~%YEAR%~%MONTH%~%ALBUM%~%GENRE% ~%PUBLISHER%~%MEDIATYPE%~%QUALITY% c) If Added optional fields: Format string: %ALBUMSORT%~%YEAR%~%MONTH%~%ALBUM%~%GENRE% ~%PUBLISHER%~%MEDIATYPE%~%QUALITY%~%ALBUM RATING%~%COMMENT%
Thank you both for the help!