INTERACT FORUM

More => Old Versions => JRiver Media Center 30 for Windows => Topic started by: mattlovell on March 30, 2023, 12:59:44 pm

Title: Duration format in exported CSV?
Post by: mattlovell on March 30, 2023, 12:59:44 pm
Hello,

When exporting a view as CSV data (via File -> Export Playlist ...), is any control possible over the format of duration?

At present, it seems like JRiver is willing to use either MM:SS or HH:MM:SS formats, depending upon the length of the track/work.  Here is an example:

Poupee de Nuremberg,Poupee de Nuremberg,Adam,Tenner,Vienna Radio Orchestra,48:39,223,ogg,? stars,,Classical,7/4/2012 12:31 pm,1951
Si j'etais roi,Si j'etais roi,Adam,Agler,National Symphony Orchestra of Ireland,2:11:36,236,ogg,? stars,,Classical,8/26/2013 7:34 pm,2000


Use of the shorter MM:SS format seems to cause a problem in both Excel and Google Sheets upon importing and parsing the CSV data, when treating the duration column as anything other than a string.  In either of those tools, the shorter work ends up getting a duration of 48h and 39m rather than 0h 48m 39s.

It's a Perl one-line to go and modify the CSV values, but I was wondering if any control over the export format is possible in JRiver?

Thanks!
  Matt