[mythtv-users] Any one knows script/app to do change for title and subtitle in batch?

[Nick Rout]

2009/7/17 "José Tomás @ Chico" <jose.tomas at chico.mine.nu>:
> José Tomás @ Chico wrote:
>
> Nick Morrott wrote:
>
> On 15/07/2009, José Tomás <jose.tomas at chico.mine.nu> wrote:
>
>
>  Hi!
>
>  TV Stations in Portugal are currentloy give titles and subtitles joined as
> a title.
>  So records for the same serie/season apears as separed programs.
>
>  Time to time I have to do some SQL work and also eliminating duplicates.
>  For example C.S.I is recorded as Title-"C.S.I. Sx Ey" I have to separate
> Title-"C.S.I." and SubTitle-"Sx Ey"
>
>  Does any one ear about any script that giving some kind of pattern does the
> reorganization of records?
>
>
> Are you getting listings via XMLTV or through MythTV using EIT?
>
> I noticed this problem in the UK with the listings data the uk_rt
> XMLTV grabber uses and added support for this (on a per title basis)
> so that the titles/subtitles are fixed before they hit the MythTV
> database. Configuration is via a text file retrieved by the grabber
> and a config flag to enable/disable title processing.
>
> The current fixups within the MythTV EIT processor are quite general
> and I doubt the relevant core developers would want to have to
> maintain a separate in-code list of titles to process for a specific
> country. However it may be possible to add support that uses a
> separate text file that is read at runtime and can be enabled on a per
> user/country basis.
>
>
>
> Portuguese TV distributors are providing a subset of MPEG4 for which there
> is EIT (I believe) but is closed to specific hw.
> For regular analogue cable (from where I get signal for my mythtv) and air
> I'm not aware of any EIT replacement diferent from XMLTV, or there is?
>
> XMLTV Grabber was on February and still just eating some HTML from URL
> http://www.zon.pt/Televisao/Programacao.aspx , that time provider made some
> kind of change for HTML and so I did on my own a urgent correction and
> posted as a contribution but probably in a very compliant way at the
> grabbers page.
> Was a fast and directed contribution, I also mailed the people in charge
> tell them that, the result was positive. Snif, for that HTML change my kid
> become very noisy... some episodes were not recorded.. ;-)
>
> So my question is: Is there any EIT for analogue cable working for portugal,
> mainly ZON/TVCABO provider?
> If so, where should I look?
>
> Thanks all!
>
> I heard that MS MediaCenter has access to some EPG URL on ZON/TVCABO. I did
> try to check, but didn't found any one able to help me.
> So, do anyone knows about this EPG?


There is a program called something like mce2xml which converts a MS
mce listing to xmltv format, getting xmltv into mythtv is trivial.

xmltv data s quite easy to do conversions on too, so that may be the
place to do your corrections, ie before import into the database.