Export Metadata per recording using SQLite

[dinki]

I'm exploring using my GBPvr recordings in another program. What I would like to do is create a script (batch file?) that would generate an xml formatted file for each recording upon completion of the recording.

What is the best approach for this? I'm guessing that sqlite would be the easiest method? Are there any examples on using sqlite with the GBPvr database. I am very familiar with MySQL so I'm thinking things with sqlite will be very similar.

The items I would like to pull from the database would be the filename, seriesname, subtitle, season, and episode.

Any help getting started is greatly appreciated.

[Braklet]

SQLite is pretty easy to work with. The "server" is only one portable DLL so it is simple to install. Since GB-PVR already uses SQLite you can share the exact same data store.

First thing I would do if I were you is evaluate all the SQLite administration tools. There are a few free ones but I ended up paying for SQLite Maestro, because it supports a graphical query builder. Very similar to Navicat, if you are familiar with that from MySQL.

A good admin tool will let you manipulate the data and compose/test queries from the GUI, then you can build them into your own app. Or just use the admin tool to run the queries (that's how I do most of my DB manipulation these days).

Eventually I'd like to learn enough about PHP to instrument most of what I need (import, title and subtitle editing) from a web page.

[sub]

It might not help you, but if your file system is NTFS, then an alternate data stream is created containing info about the recoridng. You can view it by doing something like this:

notepad c:\myvideos\somevideoname.mpg:metadata.xml

[zehd]

here's some stuff...

http://forums.nextpvr.com/showthread.php?t=20995

i don't use the actual import export tool discussed, but I learned a lot about syntax...

[Jim_]

GetXML (in my sig) saves an xml file that can be inported after each recording. But subtitle, season, and episode arent in the gbpvr database unless you use a utility that adds them to the visible fields. IE rename recordings, add episode, epg extra, I-xmltv.

[dinki]

It might not help you, but if your file system is NTFS, then an alternate data stream is created containing info about the recoridng. You can view it by doing something like this:

notepad c:\myvideos\somevideoname.mpg:metadata.xml

Code:

<?xml version="1.0" encoding="UTF-8"?>
<recording>
  <filename>C:\Media\Recordings\Last Comic Standing\Last Comic Standing_20070801_20002100.mpg</filename>
  <channel>7 KPLC</channel>
  <status>READY</status>
  <startTime>2007-08-01 20:00:00</startTime>
  <endTime>2007-08-01 21:00:00</endTime>
  <title>Last Comic Standing</title>
  <subtitle>Challenge No. 1</subtitle>
  <description>The top 10 comics pair up for the heckle challenge; one comic wins a spot in the Just for Laughs Festival in Montreal.</description>
  <uid>EP5828060055</uid>
</recording>

That's really cool. Is there an easy way to export this data out into a standalone xml file? This is pretty much exactly what I'm looking for! Is the uid something from zap2it?

If I am running the I-xmltv, can you tell me if additional data would be stored in this xml data as well? The more information the better.

Thanks to all for the tips.