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>