Somebody was nice enough to show me how to change %_length% to hours minutes and seconds when exporting to CSV. Unfortunately, when I downloaded the latest version, the CSV format was changed back to the original and I must start all over again. Can anyone pleased help in changing it back to the hour, minute, second format?
Do you mean this thread?
And: an update installation usually does not overwrite the existing user-defined exports and actions.
ohrenkino:
I wish I had a screen shot of my original CSV export file and the existing one after updating MP3 Tag, If I did, I wouldn't be asking this question. The CSV file can be made to include HH:mm:ss as shown here
and is included in the CSV file and will export perfectly into Excel with no problem at all. The expression used can be put anywhere in the CSV export file and will work. I just wish I had kept his reply to my question, my bad.
As far as I can remember, the problem arose from Excel and its display of the time.
I think you have to configure the Excel column to show always the hours.
If you want to define your own calculation you could try:
$ifgreater(%_length_seconds%,3600,$div(%_length_seconds%,3600):$div($sub(%_length_seconds%,3600),60):$mod(%_length_seconds%,60),00:$num($div(%_length_seconds%,60),2):$num($mod(%_length_seconds%,60),2))
I am too stupid - this is the much easier way:
$ifgreater(%_length_seconds%,3600,%_length%,00:%_length%)
That HH:mm:ss length formatting works great, exported in a CSV file, later imported in LibreOffice Calc (v7.0.5.3):
In Excel 2021 the import of the same CSV file needs more manual work.
For example, the TRACK column content needs to be manually adjusted. As you can see, Excel converts some TRACK numbers into a short date for some values. Example for the same CSV as above (unedited, original imported):
ohrenkino;
You stated in your last email
"As far as I can remember, the problem arose from Excel and its display of the time. I think you have to configure the Excel column to show always the hours".
This is an impossibility as when you open your CSV file it opens in a different window you cannot format the column. The expression must be in the CSV string. I know Excel has problems with time especially when importing and can be very frustrating, but I know it can be done within the CSV string. I know somebody said that when you install the latest version it does not delete any export functions, but it does. I'm going to try your expression you posted and see what happens only this time, if it works, and I have no doubt it will, I'll make a copy which I should have done in the first place.
You have to avoid the automatism in Windows to just double-click on a csv file but open it from within Excel and then use the import assistant. In that assistant you can set how Excel should treat the data.
I am still convinced that the installation of a new MP3tag version does not delete the user settings as long as you stay in the same kind of installation mode (standard vs. portable) and install the same kind of architecture (32-bit vs. 64-bit).
For all other installation variations, please see
and
So unless you have erased substantial parts of your data storage, the old settings should still be there.
Possible locations are described in the documentation.
ohrenkino:
Regarding installation of new versions, I always get the Install version for Windows and if it's 64bit, which I'm using, I grab it. I can always uninstall MP3tag and show you the CSV as it pertains to a new install. Trust me, if it didn't change any parameters in the CSV export, I wouldn't.be here trying to find out how to change anything as I keep the export string the same until I install an updated version. As far as you string that you created, it works perfectly and I'm grateful for you taking your time and figuring this out. Thank you very much. (This time I'll, make a copy)
Well, I spoke too soon. Here is the string I'm using:
$filename(csv,utf-16)Year;Title;Artist;Album;Track;Length;Genre;Comment;
$loop(%_filename_ext%)%year%;%title%;%artist%;%album%;%track%;$ifgreater(%_length_seconds%,3600,%_length%,00:%_length%);%genre%;%comment%;
$loopend()build on %_date% with %_app% - the universal Tag editor - http://www.mp3tag.de/en/.
For some reason it will not export the CSV file. I keep getting an error message say it cannot write the file. I've looked at the string and can't figure what the heck is going on. It originally wrote it but I was missing a parameter which was "Artist". As soon as I put that back into the string, it quit exporting. Maybe you can figure it out cause I surely don't know what the problem is.
Please check if this file is still open in Excel or an editor. You can not overwrite it, if it is still in use.
The string itself works fine in my environment with my files.
OK, I screwed up. I had a CSV file already open and that's why I was getting the error. What else can go wrong? Today has not been good for me. Think I'll just start over again. The string works perfectly.