Converting from Myth-TV

[dark_half]

I am pretty sure it uses the uid as dennet stated. It get this from the xml imported from schedules direct. Here is an example of mine.

Code:

<recording> <filename>\\Htpc\E\GBPVR\Recordings\True Blood_20090823_20002100.mpg</filename> <channel>815 HBOHD</channel> <status>READY</status> <startTime>2009-08-23 20:00:00</startTime> <endTime>2009-08-23 21:00:00</endTime> <title>True Blood *</title> <subtitle>New World in My View</subtitle> <description>Sookie, Bill and Jason return to Bon Temps; Hoyt and Jessica try to keep Maxine's madness a secret; Jason tries to rescue Sam. (Sun, Aug 23, 2009)</description> [color=Red]<uid>EP01075223.0022</uid>[/color] </recording>

[gazzat5]

Here's a few records from my mythtv database.
Hope it's useful.
According to MYSQL query browser, chanid and starttime are used as the primary key!

Code:

<ROOT> − <row> <field name="chanid">1002</field> <field name="starttime">2009-05-27 05:35:00</field> <field name="endtime">2009-05-27 06:00:00</field> <field name="title">Short Circuit</field> <field name="subtitle">Polymers</field> − <field name="description"> Bringing chemistry, physics and biology to life. Polymers are easily made and moulded to any purpose. Can the consequences be avoided as waste piles up in landfill sites? </field> <field name="category">Kids</field> <field name="hostname">enmyth</field> <field name="bookmark">0</field> <field name="editing">0</field> <field name="cutlist">0</field> <field name="autoexpire">1</field> <field name="commflagged">1</field> <field name="recgroup">Default</field> <field name="recordid">38</field> <field name="seriesid">fp.bbc.co.uk/KMAAYL</field> <field name="programid">fp.bbc.co.uk/1U4Y2D</field> <field name="lastmodified">2009-05-27 06:23:04</field> <field name="filesize">903840080</field> <field name="stars">0</field> <field name="previouslyshown">0</field> <field name="originalairdate">0000-00-00</field> <field name="preserve">0</field> <field name="findid">0</field> <field name="deletepending">0</field> <field name="transcoder">0</field> <field name="timestretch">1</field> <field name="recpriority">0</field> <field name="basename">1002_20090527053500.mpg</field> <field name="progstart">2009-05-27 05:35:00</field> <field name="progend">2009-05-27 06:00:00</field> <field name="playgroup">Default</field> <field name="profile">Default</field> <field name="duplicate">1</field> <field name="transcoded">0</field> <field name="watched">0</field> <field name="storagegroup">Default</field> </row> − <row> <field name="chanid">1002</field> <field name="starttime">2009-05-29 05:00:00</field> <field name="endtime">2009-05-29 06:00:00</field> <field name="title">Short Circuit</field> <field name="subtitle">Chemistry, Biology and Physics - Programmes 4-6</field> − <field name="description"> Bringing science to life using real-life examples and practical experiments. A look at energy, the eye, and electromagnetism. </field> <field name="category">Education/Science/Factual</field> <field name="hostname">enmyth</field> <field name="bookmark">0</field> <field name="editing">0</field> <field name="cutlist">0</field> <field name="autoexpire">1</field> <field name="commflagged">1</field> <field name="recgroup">Default</field> <field name="recordid">39</field> <field name="seriesid">fp.bbc.co.uk/KMAAYL</field> <field name="programid">fp.bbc.co.uk/1RRR2S</field> <field name="lastmodified">2009-05-29 06:49:05</field> <field name="filesize">2224143400</field> <field name="stars">0</field> <field name="previouslyshown">0</field> <field name="originalairdate">0000-00-00</field> <field name="preserve">0</field> <field name="findid">0</field> <field name="deletepending">0</field> <field name="transcoder">0</field> <field name="timestretch">1</field> <field name="recpriority">0</field> <field name="basename">1002_20090529050000.mpg</field> <field name="progstart">2009-05-29 05:00:00</field> <field name="progend">2009-05-29 06:00:00</field> <field name="playgroup">Default</field> <field name="profile">Default</field> <field name="duplicate">1</field> <field name="transcoded">0</field> <field name="watched">0</field> <field name="storagegroup">Default</field> </row> − <row> <field name="chanid">1002</field> <field name="starttime">2009-08-09 15:00:00</field> <field name="endtime">2009-08-09 15:30:00</field> <field name="title">Fred Dibnah's Made in Britain</field> <field name="subtitle">Engines at Work</field> − <field name="description"> Fred Dibnah travels Britain in a traction engine in search of engineering skills from a bygone age. Fred visits a pumping station with a triple expansion engine. </field> <field name="category">News</field> <field name="hostname">enmyth</field> <field name="bookmark">0</field> <field name="editing">0</field> <field name="cutlist">0</field> <field name="autoexpire">1</field> <field name="commflagged">0</field> <field name="recgroup">Default</field> <field name="recordid">73</field> <field name="seriesid">fp.bbc.co.uk/KN1TT2</field> <field name="programid">fp.bbc.co.uk/35W083</field> <field name="lastmodified">2009-08-09 15:30:00</field> <field name="filesize">0</field> <field name="stars">0</field> <field name="previouslyshown">0</field> <field name="originalairdate">0000-00-00</field> <field name="preserve">0</field> <field name="findid">0</field> <field name="deletepending">0</field> <field name="transcoder">0</field> <field name="timestretch">1</field> <field name="recpriority">1</field> <field name="basename">1002_20090809150000.mpg</field> <field name="progstart">2009-08-09 15:00:00</field> <field name="progend">2009-08-09 15:30:00</field> <field name="playgroup">Default</field> <field name="profile">Default</field> <field name="duplicate">1</field> <field name="transcoded">0</field> <field name="watched">0</field> <field name="storagegroup">Default</field> </row> </ROOT>