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 hou…

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 eas…

[image] xpac5896a: when exporting to CSV Do you mean this thread? [image] Adding Length (time) to CSV Support I'm wanting to add the length (time) of a track for export using csv. Length is nothing more than the time it would take a track to play. I'm not a programm…

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 [Example] and is included in the CSV file and will export perfectly into Excel…

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.

[image] ohrenkino: $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): [image] In Excel 2021 the import of the same CSV file needs more manual work. For example, the T…

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…

[image] xpac5896a: This is an impossibility as when you open your CSV file it opens in a different window you cannot format the column. 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 assis…

[image] xpac5896a: I know somebody said that when you install the latest version it does not delete any export functions, but it does. 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…

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…

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 %…

[image] xpac5896a: error message say it cannot write the file 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.

Change %_length% to HH:mm:sec

Support

ohrenkino March 18, 2023, 8:38pm 2

Do you mean this thread?

And: an update installation usually does not overwrite the existing user-defined exports and actions.