Working EPG Tutorial for Sydney

**specks90** · 11th February 2005 12:33 PM

I have used the following guide found by BenP but found that there is a bit of information missing to get it all working for Sydney, and by default this should also help people in other areas. Follow the guide and I will put in comments below that will help you out:

http://www.bmpbargains.biz/mce_epg.htm

STEP 5 - I know it probably sounds silly but this was a sticking point for me CasPol.exe is wrong it should all be lower case caspol.exe in order to work.

STEP 6 - you need to make sure that the bold parts of the following file are the same as this:

TVHarvest.exe.config
<configuration>
<appSettings>

<add key="days" value="7" />

<add key="pastdays" value="3" />

<add key="SingleFile" value="true" />
<!-- Path to output the listings to (must have trailing "\&quot

Default is "c:\WINDOWS\eHome\"
but you may have to create those sub folders -->
<add key="path" value="C:\WINDOWS\eHome\" />


<!-- URL for NineMSN tvguide, you MUST update this for your state (ie. change the "94" which is Melbourne
to the number appropriate for your location. eg. "101" for Perth, "73" for Sydney,
"75" for Brisbane, "88" for Tasmania, "74" for Darwin and "126" For ACT)

Visit http://tvguide.ninemsn.com.au/ and view a TV Guide for your area will get
you this URL, but replace the date part (eg. "04042003&quot

with the string "(date)" -->
<add key="GuideURL" value="http://tvguide.ninemsn.com.au/guide/(date)_73.asp?channel=free" />


<add key="Timezone" value="+1100" />


<add key="PopupURL" value="http://tvguide.ninemsn.com.au/closeup/default.asp?pid=(pid)" />

</appSettings>
</configuration>

STEP 7 - The names for channels in Listing.xml and Listing2.xml do not match those of MCE and in order for it to work you need to replace the names use wordpad and replace as follows:

ABC NSW - ABC TV Sydney
Network TEN Sydney - TEN Digital
Channel NINE Sydney - NINE Digital
Channel Seven Sydney - 7 Digital
SBS Sydney - SBS DIGITAL 1

Yes it is case sensitive and if you miss just one instance you will not have any luck so I suggest making sure you are at the top of the document before you do the replace.

Two other xml files also need to be amended (TVxbChannel Info.XML) to read as follows

ChannelInfo.XML
<NewDataSet>
<Channel>
<name>ABC NSW</name>
<channelID>ABC Sydney</channelID>
<virtualchannel>2</virtualchannel>
</Channel>
<Channel>
<name>>Channel Seven Sydney</name>
<channelID>Channel Seven Sydney</channelID>
<virtualchannel>7</virtualchannel>
</Channel>
<Channel>
<name>Channel Nine Sydney</name>
<channelID>Channel Nine Sydney</channelID>
<virtualchannel>9</virtualchannel>
</Channel>
<Channel>
<name>Network TEN Sydney</name>
<channelID>Network TEN Sydney</channelID>
<virtualchannel>10</virtualchannel>
</Channel>
<Channel>
<name>SBS Sydney</name>
<channelID>SBS Sydney</channelID>
<virtualchannel>3</virtualchannel>
</Channel>
<Channel>
<name>SBS News</name>
<channelID>SBS News</channelID>
<virtualchannel>0</virtualchannel>
</Channel>
</NewDataSet>

TVxbChannelInfo.XML
<NewDataSet>
<Channel>
<name>ABC NSW</name>
<channelID>>ABC NSW</channelID>
<virtualchannel>2</virtualchannel>
</Channel>
<Channel>
<name>Channel Seven Sydney</name>
<channelID>Channel Seven Sydney</channelID>
<virtualchannel>7</virtualchannel>
</Channel>
<Channel>
<name>Channel Nine Sydney</name>
<channelID>Channel Nine Sydney</channelID>
<virtualchannel>9</virtualchannel>
</Channel>
<Channel>
<name>Network Ten Sydney</name>
<channelID>Network Ten Sydney</channelID>
<virtualchannel>10</virtualchannel>
</Channel>
<Channel>
<name>SBS Sydney</name>
<channelID>SBS Sydney</channelID>
<virtualchannel>3</virtualchannel>
</Channel>
</NewDataSet>

You should be up and running if anyone wants any of the above mentioned files let me know and I can Email them alternatively you should be able to copy and paste from above.

**monster** · 12th February 2005 12:23 PM

thanks for that but unfortantly i cant get it working

ive edited the files etc tvharvest creates the xmls no problems but when i run quickguide i get this error.

C:\WINDOWS\ehome>Quickguide
Error: Object reference not set to an instance of an object.
Stack Trace: at QuickGuide.EPGXMLWriter.GetProgramsAndSchedule(Str ing start,
String stop, DataView programs, DataView channels)
at QuickGuide.EPGXMLWriter.Create(DataSet XMLTV, DataSet Channels, String fil
ename)
at QuickGuide.QuickGuideWorker.CreateXMLFile(String&a mp; encryptedFile, String XM
LTVFile)
at QuickGuide.Starter.Main(String[] args)
****** XML Creation failed

*sigh* any ideas...

thanks

**Mike** · 12th February 2005 12:58 PM

Have I got a fix for you monster, just went throught the same thing an hour ago - (mine's set up for analogue TV btw).

Open your channelinfo.xml - if your problem has the same cause as mine, the first entry is wrong - it should read:

<name>ABC NSW</name>
<channelID>ABC NSW</channelID>

can't remember now but I think the channelID on mine was originally ABC Sydney - (wrong). So with Michael's help we tracked it down to that silly typo and now after that small change, my channelinfo.xml reads as follows:

<NewDataSet>
<Channel>
<name>ABC NSW</name>
<channelID>ABC NSW</channelID>
<virtualchannel>2</virtualchannel>
</Channel>
<Channel>
<name>Channel Seven Sydney</name>
<channelID>Channel Seven Sydney</channelID>
<virtualchannel>7</virtualchannel>
</Channel>
<Channel>
<name>Channel Nine Sydney</name>
<channelID>Channel Nine Sydney</channelID>
<virtualchannel>9</virtualchannel>
</Channel>
<Channel>
<name>Network TEN Sydney</name>
<channelID>Network TEN Sydney</channelID>
<virtualchannel>10</virtualchannel>
</Channel>
<Channel>
<name>SBS Sydney</name>
<channelID>SBS Sydney</channelID>
<virtualchannel>3</virtualchannel>
</Channel>
<Channel>
<name>SBS News</name>
<channelID>SBS News</channelID>
<virtualchannel>0</virtualchannel>
</Channel>
</NewDataSet>

making that change gotrid of the Quick guide error for me - let us know if it fixes the problem for you.

************************************************** *************************
The great work that Ben started is getting a bit fragnmented now and the post above by specks90 took me 99% pf the way there - but I fell at the last. Would anybody like to help with an update?

If Ben doesn't mind, we need to take his guide as the base using his site as the source, then we should include a zip file for each capital city which contains all the city specific xml data - so who wants to volunteer to add theirs? Sadly, both my servers have security which prohibits sending me xml files as e-mail attachments.

I think also, if the xml dtata is different for digital and analogue TV (someone please confirm) , we're gonna need one of each. So when you have a "guaranteed to work" xml data zip, start a new topic and mention if it's for digital or analogue , attach the zip, and I'll merge the topics into one and tidy it up.

Mke

**monster** · 12th February 2005 03:38 PM

Indeed you are right mike thanks for that but before i changed it i downloaded the latest from tgb 20050209 and it worked without the change

thanks again

**specks90** · 14th February 2005 08:58 AM

You are getting the same message that frustrated me for ages. Make sure you are at the top of the page before you do the replace as if you miss one it will invalidate the whole process. The above are files are correct so follow them exactly.

ABC NSW becomes ABC TV Sydney - get it right or you will be in trouble

**specks90** · 16th February 2005 09:16 AM

Peolpe go and have a look at this response to one of my earlier enquiries and all will make sense I hope:

http://www.xpmediacentre.com.au/comm...=1814#post1814

**freshlobster** · 2nd March 2005 02:26 AM

Hi Mike,

I've tried your suggestions and used the zip file posted by another user and I received this error when running quickguide:

Error: Failed to enable constraints. One or more rows contain values violating n
on-null, unique, or foreign-key constraints.
Stack Trace: at System.Data.DataSet.FailedEnableConstraints()
at System.Data.DataSet.EnableConstraints()
at System.Data.DataSet.set_EnforceConstraints(Boolean value)
at System.Data.XmlDataLoader.LoadData(XmlReader reader)
at System.Data.DataSet.ReadXml(XmlReader reader, XmlReadMode mode, Boolean de
nyResolving)
at System.Data.DataSet.ReadXml(String fileName, XmlReadMode mode)
at QuickGuide.QuickGuideWorker.CreateXMLFile(String& encryptedFile, String XM
LTVFile)
at QuickGuide.Starter.Main(String[] args)
****** XML Creation failed
Press 'Enter' key to exit.
(Use /batch parameter to suppress this prompt.)

Any ideas?

Thanks
FL

Originally Posted by Mike

Have I got a fix for you monster, just went throught the same thing an hour ago - (mine's set up for analogue TV btw).

Open your channelinfo.xml - if your problem has the same cause as mine, the first entry is wrong - it should read:

<name>ABC NSW</name>
<channelID>ABC NSW</channelID>

can't remember now but I think the channelID on mine was originally ABC Sydney - (wrong).* So with Michael's help we tracked it down to that silly typo and now after that small change, my channelinfo.xml reads as follows:

<NewDataSet>
* <Channel>
* * <name>ABC NSW</name>
* * <channelID>ABC NSW</channelID>
* * <virtualchannel>2</virtualchannel>
* </Channel>
* <Channel>
* * <name>Channel Seven Sydney</name>
* * <channelID>Channel Seven Sydney</channelID>
* * <virtualchannel>7</virtualchannel>
* </Channel>
* <Channel>
* * <name>Channel Nine Sydney</name>
* * <channelID>Channel Nine Sydney</channelID>
* * <virtualchannel>9</virtualchannel>
* </Channel>
* <Channel>
* * <name>Network TEN Sydney</name>
* * <channelID>Network TEN Sydney</channelID>
* * <virtualchannel>10</virtualchannel>
* </Channel>
* <Channel>
* * <name>SBS Sydney</name>
* * <channelID>SBS Sydney</channelID>
* * <virtualchannel>3</virtualchannel>
* </Channel>
* <Channel>
* * <name>SBS News</name>
* * <channelID>SBS News</channelID>
* * <virtualchannel>0</virtualchannel>
* </Channel>
</NewDataSet>

making that change gotrid of the Quick guide error for me - let us know if it fixes the problem for you.

************************************************** *************************
The great work that Ben started is getting a bit fragnmented now and the post above by specks90 took me 99% pf the way there - but I fell at the last.* Would anybody like to help with an update?

If Ben doesn't mind, we need to take his guide as the base using his site as the source, then we should include a zip file for each capital city which contains all the city specific xml data - so who wants to volunteer to add theirs?* *Sadly, both my servers have security which prohibits sending me xml files as e-mail attachments.

I think also, if the xml dtata is different for digital and analogue TV (someone please confirm) , we're gonna need one of each. So when you have a "guaranteed to work" xml data zip, start a new topic and mention if it's for digital or analogue , attach the zip, and I'll merge the topics into one and tidy it up.

Mke

**Mike** · 2nd March 2005 08:23 AM

Hi there freshlobster - welcome

Mmm - that looks tough! Did you start over after you got that error? - unless something in your setup broke on your first run through, I can't really transalate that error into something that's meaninful to me, but it probably will to someone else here.

I can only suggest that you (if you haven't already) go back to the start with clean correctly configured file and try a re-install from scratch.

Anybody else care to chip in?

Mike

**freshlobster** · 3rd March 2005 10:54 PM

Hi Mike

Thanks for your help so far. I've tried it again, and get this message...

Error: Object reference not set to an instance of an object.
Stack Trace: at QuickGuide.EPGXMLWriter.GetProgramsAndSchedule(Str ing start,
String stop, DataView programs, DataView channels)
at QuickGuide.EPGXMLWriter.Create(DataSet XMLTV, DataSet Channels, String fil
ename)
at QuickGuide.QuickGuideWorker.CreateXMLFile(String& encryptedFile, String XM
LTVFile)
at QuickGuide.Starter.Main(String[] args)
****** XML Creation failed
Press 'Enter' key to exit.

(Use /batch parameter to suppress this prompt.)

Originally Posted by Mike

Hi there freshlobster - welcome

Mmm - that looks tough! Did you start over after you got that error? - unless something in your setup broke on your first run through, I can't really transalate that error into something that's meaninful to me, but it probably will to someone else here.

I can only suggest that you (if you haven't already) go back to the start with clean correctly configured file and try a re-install from scratch.

Anybody else care to chip in?

Mike

**doylejul** · 23rd May 2005 12:48 AM

Correct me if I'm wrong, but the directions on http://www.bmpbargains.biz/mce_epg.htm to download the guide using the scheduler will not give you usable guide info as the channel information still needs to be modified to contain the correct channel names.....So I hacked this together, give it a try...

Download SED from http://sed.sourceforge.net/grabbag/ssed/sed-3.59.zip
Extract the exe file into your Windows directory and rename it to sed.exe

Edit your getepg.bat file that is in your C:\windows\ehome directory to read as follows:

(Don't hassle me about the hopelessly inefficient code, I am not a programmer...someone else please feel free to write it properly...)

@echo on
del listing.xml
del listing2.xml
tvharvest.exe
sed "s/ABC NSW/ABC TV Sydney/g" listing.xml>newlisting.xml
del listing.xml
ren newlisting.xml listing.xml
(sed "s/ABC NSW/ABC TV Sydney/g" listing2.xml)>newlisting2.xml
del listing2.xml
ren newlisting2.xml listing2.xml
sed "s/Network TEN Sydney/TEN Digital/g" listing.xml>newlisting.xml
del listing.xml
ren newlisting.xml listing.xml
(sed "s/Network TEN Sydney/TEN Digital/g" listing2.xml)>newlisting2.xml
del listing2.xml
ren newlisting2.xml listing2.xml
sed "s/Channel NINE Sydney/NINE Digital/g" listing.xml>newlisting.xml
del listing.xml
ren newlisting.xml listing.xml
(sed "s/Channel NINE Sydney/NINE Digital/g" listing2.xml)>newlisting2.xml
del listing2.xml
ren newlisting2.xml listing2.xml
sed "s/Channel Seven Sydney/7 Digital/g" listing.xml>newlisting.xml
del listing.xml
ren newlisting.xml listing.xml
(sed "s/Channel Seven Sydney/7 Digital/g" listing2.xml)>newlisting2.xml
del listing2.xml
ren newlisting2.xml listing2.xml
sed "s/SBS Sydney/SBS DIGITAL 1/g" listing.xml>newlisting.xml
del listing.xml
ren newlisting.xml listing.xml
(sed "s/SBS Sydney/SBS DIGITAL 1/g" listing2.xml)>newlisting2.xml
del listing2.xml
ren newlisting2.xml listing2.xml
quickguide.exe /batch
exit

**andrewnaar** · 24th May 2005 09:08 PM

To get this to work I copied all the files and folders from the C:\windows\ehom\quickguide to the c:\windows\ehome directory.

This worked for me like a charm.

Originally Posted by freshlobster

Hi Mike

Thanks for your help so far. I've tried it again, and get this message...

Error: Object reference not set to an instance of an object.
Stack Trace: at QuickGuide.EPGXMLWriter.GetProgramsAndSchedule(Str ing start,
String stop, DataView programs, DataView channels)
at QuickGuide.EPGXMLWriter.Create(DataSet XMLTV, DataSet Channels, String fil
ename)
at QuickGuide.QuickGuideWorker.CreateXMLFile(String& encryptedFile, String XM
LTVFile)
at QuickGuide.Starter.Main(String[] args)
****** XML Creation failed
Press 'Enter' key to exit.

(Use /batch parameter to suppress this prompt.)

**buzurk** · 21st July 2005 12:15 AM

when i run quickguide i get this error

**lerroy** · 24th July 2005 11:58 PM

Hi Guys

i have read all the post and stuff to do with EPG, it looked easy but i just couldnt get it working....i dunno whats going on i have tried so many times

first problem

is i dont have a eHome dir mine is ehome ???

Second problem

i did it first time and the EPG showed up but there were no shows in there, tvharvest worked and everything, i decided to start again and this time the tvharvest opens up dos prompt then jst disapears ???

i then did a system restore to yesterday and started all over again
i get the same problem !!!
as soon as tvharvest opens it just closes !!!
im going crazy

can anyone help me ??

**Mike** · 25th July 2005 09:40 AM

Originally Posted by lerroy

first problem is i dont have a eHome dir mine is ehome ???

This is what happens when people get creative with their typing - yours is OK - it IS ehome.

Originally Posted by lerroy

Second problem i did it first time and the EPG showed up but there were no shows in there,

Because you didn't add listings to channel - Settings >TV>Guide>Add Listings To Channel

Originally Posted by lerroy

as soon as tvharvest opens it just closes !!!

It closes because it has already grabbed the data (listing.xml) and when you run it again so quickly there's nothing to download

Now for anybody reading this post - PLEASE NOTE - it is an old one and was ported across from a previous forum and that's why all the "<" characters are in there and I can't be bothered going in there and spending half a day editing out all those characters in every post in that thread

So for simplicity - please read this post thoroughly, all the TVHarvest/Quickguide problems are listed and fixed in there and if you have something else, I would suggest you scratch it and start over again.

Now if you really want to do it the hard way, keep on going as you were, but to get the same result with the same software but using a simple installer - use Bladerunner - and then get support for it here

To avoid further confusion, I think it's best if I close this thread now and invite further requests for assistance to be posted to this thread from now on - - Updated EPG Walk Through - Quickguide/TVHarvest

Thread: Working EPG Tutorial for Sydney

LinkBack

Thread Tools

Working EPG Tutorial for Sydney

Re: Working EPG Tutorial for Sydney

Re: Working EPG Tutorial for Sydney

Re: Working EPG Tutorial for Sydney

Re: Working EPG Tutorial for Sydney

Re: Working EPG Tutorial for Sydney

Re: Working EPG Tutorial for Sydney

Re: Working EPG Tutorial for Sydney

Re: Working EPG Tutorial for Sydney

Re: Working EPG Tutorial for Sydney

Re: Working EPG Tutorial for Sydney

Re: Working EPG Tutorial for Sydney

Re: Working EPG Tutorial for Sydney

Re: Working EPG Tutorial for Sydney

Posting Permissions