Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[mattlovell]

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