I use webegp to grap radiotimes xmltv schedules. This doesn't include an episode name (mptvdb.programs.episodeName) in regular soaps so I get a lot of duplicate recordings. I assume that detecting duplicates "by episode title" used this field. Is that correct?
The only thing I can think of is to write a script to artificially populate the episodeName field by writing a script to copy the first x characters of the description to the episode name.
E.g.
mysql -e "UPDATE mptvdb.programs SET episodeName=SUBSTR(description, 0, 255) WHERE episodeName NOT LIKE '' AND title LIKE 'xxx%';"
Will that mess other things up? Is there a better way?
The only thing I can think of is to write a script to artificially populate the episodeName field by writing a script to copy the first x characters of the description to the episode name.
E.g.
mysql -e "UPDATE mptvdb.programs SET episodeName=SUBSTR(description, 0, 255) WHERE episodeName NOT LIKE '' AND title LIKE 'xxx%';"
Will that mess other things up? Is there a better way?
Last edited: