Since I can't upload an excel spreadsheet here, I'll try to explain it.
It's a simple excel spreadsheet.
It converts the contents of a .edl file pasted in cell A2.
To the contents for a .VPrj file in cell D2 and below using excel formulas.
I'm just using it to test the new Smart Commercial Detection accuracy.
If you need to convert lots of edl files, you should probably write a script to do that (maybe sed taking input from edl and outputting to VPrj).
The edl (edit decision list) file created by Channels DVR is a tab delimited text file with time values in seconds.
Each line contains 3 tab separated values.
First value is start of the commercial break.
Second value is end of the commercial break.
Third value, always "3", signifies Commercial Break action and is not used here.
Excel formulas in cells D2 and below do the conversion to the VideoRedo .VPrj format.
The VPrj time stamps are in 1/10,000,000 seconds.
Formula in cell D2
=$E$2
Formula in cell D3
=IF(ISNUMBER($A2),CONCATENATE($E$3,($A2*10000000),$E$4,($B2*10000000),$E$5),IF($A1<>"",$E$6,""))
Formula in cells D4 and below are copied from D3 such that the values $A2, $B2 and $A1 are incremented by 1 per row
Formula in cell D4
=IF(ISNUMBER($A3),CONCATENATE($E$3,($A3*10000000),$E$4,($B3*10000000),$E$5),IF($A2<>"",$E$6,""))
I copied this formula down to cell D101 to accomodate up to 100 commercial breaks
Formula in cell D101
=IF(ISNUMBER($A100),CONCATENATE($E$3,($A100*10000000),$E$4,($B100*10000000),$E$5),IF($A99<>"",$E$6,""))
To use it, open the excel spreadsheet.
Open the Channels DVR generated edl file in notepad or some text editor that preserves tab characters.
Copy the contents of the edl file to the clipboard (I use <CTRL-A> select all, then <CTRL-C> copy).
Highlight cell A2 of the spreadsheet and paste the clipboard contents to it (I use <CTRL-V> paste).
You now have the contents for the VPrj file in cell D2 and below.
Create a new blank file named Apply.VPrj and open it with your text editor.
Copy the spreadsheet cells D2 and below to the clipboard, then paste that into the file Apply.VPrj and save it.
Now you open the recording in VideoRedo, choose menu item Edit>Apply Project File and select your Apply.VPrj file.
You could probably do all this in less time than it took to read.
EXAMPLE
Content of .edl file
0 8.41 3
385.12 505.27000000000004 3
987.59 1107.04 3
1387.3600000000001 1487.92 3
1717.42 1798.93 3
Content of .VPrj file
<VideoReDoProject Version="3"><CutList>
<Cut><CutTimeStart>0</CutTimeStart><CutTimeEnd>84100000</CutTimeEnd></Cut>
<Cut><CutTimeStart>3851200000</CutTimeStart><CutTimeEnd>5052700000</CutTimeEnd></Cut>
<Cut><CutTimeStart>9875900000</CutTimeStart><CutTimeEnd>11070400000</CutTimeEnd></Cut>
<Cut><CutTimeStart>13873600000</CutTimeStart><CutTimeEnd>14879200000</CutTimeEnd></Cut>
<Cut><CutTimeStart>17174200000</CutTimeStart><CutTimeEnd>17989300000</CutTimeEnd></Cut>
</CutList></VideoReDoProject>
Spreadsheet image
And to save you from having to type these in,
copy and paste this in cell A1
PASTE LINES OF START/END TIMECODES FROM .EDL FILE IN CELL A2
copy and paste this in cell D1
THEN COPY XML FROM CELL D2 AND DOWN AND PASTE INTO NEW .VPrj PROJECT FILE
copy and paste this into cell E1 to fill in E1-E6
Cells in E2-E6 are used for building VRD VPrj file contents in Column D
<VideoReDoProject Version="3"><CutList>
<Cut><CutTimeStart>
</CutTimeStart><CutTimeEnd>
</CutTimeEnd></Cut>
</CutList></VideoReDoProject>