[mythtv-users] Cutlist to ProjectX format?

James Armstrong james at thearmstrongs.org
Fri May 20 16:26:00 UTC 2005


> There was a lot of talk about using ProjectX a while back, and I am
> pleased with the way it is working.  THe only thing missing, is to get
> it to use the Myth cutlists.  I guess the basis is that I don't
> understand what units the cutlists are stored in...
> 
> In any case, I did this, with lots of bash man checking (I'm a newb to
> bash scripting, please point me in the right direction if there's a
> better what to do this):
> 
> mysql -u$mysqluser -p$mysqlpass mythconverg -s -B --exec "select
> IFNULL(recorded.cutlist,'') from recorded where recorded.chanid=$channel
> and recorded.starttime=$starttime and recorded.endtime=$endtime;" >>
> cutlist.txt

I think the problem might be you are taking everything from the cutlist. 
  I don't know how ProjectX is expecting the cutlist format, but the 
mythdatabase has a field that indicates whether the frame offset is a 
start or end of commercial or just a index frame.

> Now if I load that cutlist into ProjectX, it really doesn't look right
> (everything is red/cut out).  I'm running through a project right now to
> make sure...
> 
> Is anyone doing this already?

- James


More information about the mythtv-users mailing list