INTERACT FORUM
More => Old Versions => JRiver Media Center 30 for Windows => Topic started 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