error from BRP: cannot find column ChannelID

[dsolomontc]

I've been banging my head against the wall trying to get Bladerunner 3.0 to process the XML TV file provided by the local cable TV company (see http://tvguide.express.tc/listings/p...sicplus.xml.gz). They have a single file with the channel definitions and the program. I put this 18mb file as both Listings2.xml and ChannelInfo.xml. Trying to process the files results in:

Transforming guide data...
Cannot find column ChannelID.
at System.Data.DataTable.ParseSortString(String sortString)
at System.Data.DataView.CheckSort(String sort)
at System.Data.DataView.set_Sort(String value)
at QuickGuide.EPGXMLWriter.Create(DataSet XMLTV, DataSet Channels, String filename)
at QuickGuide.QuickGuideWorker.CreateXMLFile(String XMLTVFile)

I then reduced the listings and channel XML files to a single entry and still get the same error. Here are the minimal files I created:

ChannelInfo.xml:
<!DOCTYPE tv SYSTEM "xmltv.dtd">
<tv><channel id="16"></channel></tv>

Listings2.xml:
<!DOCTYPE tv SYSTEM "xmltv.dtd"><tv>
<programme channel="16" start="20080617000000" stop="20080617003000">
<title lang="en">BBC News</title>
</programme></tv>

I must be missing something basic here - anyone have a suggestion?

And a related question: since the provider here has the single big XML file with the channel lineup and the program, should I use this file for both my ChannelInfo.xml and Listings2.xml or should I manually split off the channel lineup (which presumably won't change often)?

Thanks much,
David Solomon

[epgStream]

Hi,

If you don't get BRP running then give wmcGuideServiceProxy (external link) a go. I just loaded your XMLTV file and it imported into Media Center with no problems ...

?<?xml version="1.0" encoding="utf-8"?>
<wmcGuideServiceProxy>
  <log type="Debug" timestamp="2008-06-18T05:07:29">
    <items count="19">
      <item timestamp="2008-06-18T05:01:37" source="Proxy" category="" message="Proxy service starting." />
      <item timestamp="2008-06-18T05:01:37" source="Proxy" category="" message="Proxy service started." />
      <item timestamp="2008-06-18T05:03:11" source="Proxy" category="TV Services" message="Media Center is requesting a list of available guide services." />
      <item timestamp="2008-06-18T05:03:11" source="Proxy" category="TV Services" message="Media Center is requesting a list of available guide services." />
      <item timestamp="2008-06-18T05:03:11" source="Proxy" category="Guide Services" message="Media Center has requested guide information for 'wmcGuideServiceProxy'." />
      <item timestamp="2008-06-18T05:03:11" source="Compiler" category="General" message="Loading 'provo-basicplus.xml' XMLTV file." />
      <item timestamp="2008-06-18T05:03:14" source="Compiler" category="Channel" message="Parsing channel items." />
      <item timestamp="2008-06-18T05:03:21" source="Compiler" category="Channel" message="Sorting channel items." />
      <item timestamp="2008-06-18T05:03:28" source="Compiler" category="Category" message="193 categories processed." />
      <item timestamp="2008-06-18T05:03:34" source="Compiler" category="Channel" message="62 channel items processed." />
      <item timestamp="2008-06-18T05:03:34" source="Compiler" category="Programme" message="24,322 programme items processed." />
      <item timestamp="2008-06-18T05:03:35" source="Compiler" category="Schedule" message="24,380 schedule items processed." />
      <item timestamp="2008-06-18T05:03:35" source="Compiler" category="General" message="Performing garbage collection." />
      <item timestamp="2008-06-18T05:03:36" source="Compiler" category="Compilation" message="Saving channel settings." />
      <item timestamp="2008-06-18T05:03:36" source="Compiler" category="Compilation" message="Saving category settings." />
      <item timestamp="2008-06-18T05:03:36" source="Compiler" category="Compilation" message="Compressing programme information." />
      <item timestamp="2008-06-18T05:03:40" source="Compiler" category="Compilation" message="Applying security settings." />
      <item timestamp="2008-06-18T05:03:41" source="Proxy" category="Guide Services" message="Media Center has been notified that guide information is now available to download." />
      <item timestamp="2008-06-18T05:03:46" source="Proxy" category="Guide Services" message="Please wait while Media Center finishes loading the latest guide information." />
    </items>
  </log>
</wmcGuideServiceProxy>

Thanks,

[dsolomontc]

I tried wmcGuideServiceProxy and it worked! A few minor glitches that I reported on their forums (may be the fault of the XML TV file I'm importing).

Thanks!!