XML error when importing data to MP (1 Viewer)

[echobravo88]

Hi all!

I'm getting the following error when importing xml file to EPG database:

Since I'm no XML expert can anyone tell me, what is the reason for getting this error?

Any help would be much appreciated.[DOUBLEPOST=1402656214][/DOUBLEPOST]Oh, I forgot to attach a non working xml file...

 

[RonD]

There is a problem with the stop date/time in your "error" tvguide.xml file. If you open a cmd.exe window, cd to the folder with your tvguide.xml file and type the following command

findstr "20000000000000" tvguide.xml

There are lots of bad stop times = 20000000000000. If I use notepad++ to open/edit tvguide.xml, search for 20000000000000, it looks like this happens on the last programme for each channel before switching to the next channel. Hard to tell for sure it is only the last show. Not sure why your tvguide.xml file has the problem or how to fix the problem, but a typical example is shown below.

EDIT/COMMENT
The "good" tvguide.xml file does not show this strange stop time. Don't know why xmltv plugin gets into trouble trying to import this file. But a strange stop time 14+ years before the start time is a very strange combination of dates/times.

#### last good start/stop time
<programme start="20140619050000 +0200" stop="20140619053000 +0200" channel="BBC World">
<title lang="sl">BBC World News</title>
<desc lang="sl">The latest international news from the BBC.</desc>
<category lang="sl">Informativni program</category>
</programme>
#### good start, bad stop
<programme start="20140619053000 +0200" stop="20000000000000 +0200" channel="BBC World">
<title lang="sl">HARDtalk</title>
<desc lang="sl">Stephen Sackur talks to newsmakers and personalities from across the globe.</desc>
<category lang="sl">Informativni program</category>
</programme>
#### next channel, good start/stop times.
<programme start="20140612060000 +0200" stop="20140612071000 +0200" channel="MTV Adria">
<title lang="sl">Morning Mix</title>
<category lang="sl">Razvedrilni program</category>
</programme>

 

[RonD]

additional comment, the tvguide.xml date/time format is YYYYMMDDhhmmss so

20000000000000 maps to Y=2000 MM=00 DD=00 hh=00 mm=00 ss=00 with month = 0 day = 0

As a test did a global replace 20000000000000 with 20140619070000 and the "error" tvguide.xml imports without problems. Actual SetupTv-Error.log is following. Not sure why/how your tvguide.xml file gets stop date/time problems.

[2014-06-14 10:32:17,203] [Log    ] [XmlTvImporter] [ERROR] - XML tv import error loading C:\ProgramData\ServerCare\WebGrab_tvguide1\tvguide.xml err:Year, Month, and Day parameters describe an un-representable DateTime.
    at System.DateTime.DateToTicks(Int32 year, Int32 month, Int32 day)
   at TvEngine.XMLTVImport.CorrectIllegalDateTime(Int64 datetime)
   at TvEngine.XMLTVImport.Import(String fileName, Boolean deleteBeforeImport, Boolean showProgress)

 

[echobravo88]

RonD, kudos to you.

Your suggestions was spot on! The import is working like a charm now.

Thank you very much.