View/Edit recordings in spreadsheet

[baj1]

This may not be that interesting to most, but I found it useful.

Using the Import/Export Recordings feature in NextPVR you can open the export files and view/manipulate the recordings in spreadsheet form (I used LibreOffice Calc).

In my version of Calc I had to go into Tools-Options-LibreOffice-Advanced and enable Experimental Features to make the "XML Sources" menu option available to open the exported recordings.

Attached is the .xsl Export Filter I setup with the recurring recordings formatting.  Note that in my version of Calc (at least) there seems to be a bug with the export filters where if two consecutive columns have the same value, it skips the second one in the output XML file.  In my file that was "Quality" and "Keep" both being zero for most entries.  To remedy this I moved the columns around in Calc, the new positions of which are reflected in the cell offsets in the .xsl file.  The cell offsets are the numerical column position (A=1).

Using this I was able to import my v4 recordings by changing all the v4 recordings to ChannelOID = 0 and ChannelName = All Channels.  I imagine you could get those values if you setup a recording on every station in your v5 install and exported, but that was more work than I wanted to do.  I was also able to eliminate the duplicates (in the v4 export and those we'd already setup in v5) prior to importing.

Cheers,
-Brad