Help - Search - Members - Calendar
Full Version: Tagging from a text file
Hydrogenaudio Forums > Hydrogenaudio Forum > General Audio
GetCool
So I have a bunch of FLAC files, and I have an Excel spreadsheet with all the tags listed in it, like so:

CODE

FILE                ARTIST     ALBUM     TITLE
<path/file1.flac>   <artist>   <album>   <title>
<path/file2.flac>   <artist>   <album>   <title> ...etc...


I want to automatically tag the flac files based on the information in the above Excel spreadsheet (which I would convert to a text file). What would be the best approach to this?

Thanks.
atici
Export the excel file in a tab delimited format. Learn some shell programming and write a script. I guess that's the only way. I guess it should be easy to do this in Python.

GetCool
QUOTE(atici @ Feb 12 2005, 04:03 PM)
Export the excel file in a tab delimited format. Learn some shell programming and write a script. I guess that's the only way. I guess it should be easy to do this in Python.
*


That was the first thought that crossed my mind. I was just hoping that there would be some tagging app that would allow me to do this easily.

I'll look into it.
Hanky
Try mp3tag, TagScanner or The Godfather . It could be that one of them contains that feature.
Another option could be to edit your file to a batch file containing one TAG command for each line. Example:
CODE
TAG trackname.flac --artist "Artist" --album "Album" --title "Title"
GetCool
QUOTE(Hanky @ Feb 12 2005, 04:57 PM)
Another option could be to edit your file to a batch file containing one TAG command for each line.

Wow, that's a great idea. It would be easy enough to add columns in Excel, export the file to text, and then convert it to batch.

Going to give it a try; thanks for the idea.
Sebastian Mares
QUOTE(GetCool @ Feb 13 2005, 04:51 AM)
QUOTE(Hanky @ Feb 12 2005, 04:57 PM)
Another option could be to edit your file to a batch file containing one TAG command for each line.

Wow, that's a great idea. It would be easy enough to add columns in Excel, export the file to text, and then convert it to batch.

Going to give it a try; thanks for the idea.
*



It's even easier with MP3Tag by using the Taglist File - Tag wizard. If you have problems, you can always ask for support on the forums. smile.gif
jcoalson
also possibly of use:

metaflac --import-tags-from=FILE

Josh
GetCool
Thanks, all. I ended up doing it the way Hanky suggested; I inserted columns into my Excel file for all the command-line options, like so:

CODE

A   B       C       D        E        F       G       H      I      J
tag --title <title> --artist <artist> --album <album> --year <year> FILE1
tag --title <title> --artist <artist> --album <album> --year <year> FILE2


...then exported the Excel file to a tab-delimited text file. I tried making it a batch file, but because some of my tags/filenames had special characters (ö, é, etc.), batch choked on the script. To get around this, I made it a bash script instead and ran it with cygwin, which worked.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2008 Invision Power Services, Inc.