Channel lineup export

[McBainUK]

Is there a way of exporting (to txt file or similar) a list of all the channels that are assigned to a particular capture source? Perhaps querying the database somehow...?

[JavaWiz]

Here is SQL that will list all channels by capture source:

Code:

SELECT scm.oid, scm.channel_oid, cs.name, scm.source_channel_number, scm.enabled,
                c.display_name, scm.tuning_request
  FROM source_channel_mapping scm, channel c, capture_source cs
WHERE scm.channel_oid = c.oid
   AND cs.oid = scm.capture_source_oid
ORDER BY scm.capture_source_oid, scm.source_channel_number;

[McBainUK]

Thanks JavaWiz. What kind of app do I need to be able to open the database file and run that SQL snippet?

[martint123]

Thanks JavaWiz. What kind of app do I need to be able to open the database file and run that SQL snippet?

I've just tried it with sqltespy and it works, but a graphical interface.

There is a command line program http://www.sqlite.org/ and it works as well. (mini doc at http://www.sqlite.org/sqlite.html )

There is also http://code.google.com/p/sqlite-manager/ that runs as an addon within the Firefox browser!

[McBainUK]

Thanks, will take a look at SQLiteSpy.

[McBainUK]

Thanks guys. The firefox addon had a 'Copy to CSV' option which was exactly what I wanted

Although it's strange that the "lightweight" version had more features then the desktop one...?

[JavaWiz]

batch file version:

Code:

@Echo OFF
set GBPVRDir=c:\Program Files\Devnz\gbpvr
set SQLITE="%GBPVRDir%\SQLite3.exe"
set LOGFILE="%GBPVRDir%\logs\Channels.txt"

set sql=SELECT cs.name, scm.source_channel_number, scm.enabled, c.display_name FROM source_channel_mapping scm, channel c, capture_source cs  WHERE scm.channel_oid = c.oid AND cs.oid = scm.capture_source_oid ORDER BY scm.capture_source_oid, scm.source_channel_number;

%SQLITE% -separator " " "%GBPVRDir%\gbpvr.db3" "%sql%" >> %LOGFILE%