add non tvdb one-off shows and also lock genre (1 Viewer)

[Dutchie388]

Hi, i was hoping to get help with the following 2 things i'm trying to achieve in the TV SERIES plugin.

1. is to add one-off single shows into the database, shows which may not be listed in tvdb, i'd like to simply get them added into the database to show up in media portal, and sort the images and show details myself - however, i just cant seem to find a way to add anything if the import does not find a season or episode to match it to.

2. By changing the GENRE of series, eg. ASTRONOMY, POKER, TV SHOWS, SCIENCE etc (and having media portal list only by genre) i can nicely group the types of series, however, at the next import it always re-updates the genre details and i have to re-group them alll over again everytime. so i'm trying to find a way for the genres' details to be left alone (or the whole files' details for that matter) yet allow the importing of newly added material.

Cheers for any help.

 

[ltfearme]

1. is to add one-off single shows into the database, shows which may not be listed in tvdb, i'd like to simply get them added into the database to show up in media portal, and sort the images and show details myself - however, i just cant seem to find a way to add anything if the import does not find a season or episode to match it to.

Sorry there is no support for this.

2. By changing the GENRE of series, eg. ASTRONOMY, POKER, TV SHOWS, SCIENCE etc (and having media portal list only by genre) i can nicely group the types of series, however, at the next import it always re-updates the genre details and i have to re-group them alll over again everytime. so i'm trying to find a way for the genres' details to be left alone (or the whole files' details for that matter) yet allow the importing of newly added material.

Yes, the data will get updated but there is another way you can go about achieving this but you will need to edit the database manually.

First you need to add a new field to the Online_Series table e.g. CustomGenre. Then in the Views table, edit the existing Genre Group View to use the new <Series.CustomGenre> instead of <Series.Genre> field.

 

[Dutchie388]

thanks for the tip!

what would be the proper tool to edit the .db3 file? at first i assumed notepad, i've looked it up further but am unable to find an answer.


cheers

 

[marvenius]

You can use SQLitebrowser or SQlite Studio to edit directly in the db3 file. However, doing so might corrupt your database. Make sure you have a (plenty of) backup stored in a save place.

 

[Dutchie388]

Thank you both for your feedback, it helped a lot and i'm very close to having that working but after a couple of days experimenting i still have one hic-up.

As a test, if i tell the <Series.Genre> to use the 'actors' field for eg. (<Series.Actors>) , the Genre will list by whats in the Actors field. However, if i create a new field in the Online _Series like 'mygenre' it will show up in TV SERIES, but if i try and use that it will always come up an "NO ITEMS!" in media portal.

I've tried renaming existing fields like the actors or genre field to mygenre and point to that, but again "NO ITEMS!" message, and it re-creates the renamed fields at the end of the table, and produces some weird structure behaviour.

The reason i tried renaming is that when i add a new field to the Online_series with SQLitestudio the data type options were 'NONE' 'INT' and several others but not 'STRING' or blank like the originals were, so i thought the problem was related to that - that the new data field i create in Online_Series is not proper for Views Table to use.

I went back to fresh media portal 1.01 install using the standard skin adding a couple of fresh programs imports things simple to try it all out.

I'd like to make this work, to catagorize my types of shows rather than one large list of them all, but if i'm being a bit anal about that I'll drop it as being a no go.

cheers

 

[ltfearme]

Hi Dutchie388, can you zip and attach your DB. I will take a quick look if I have the time.

 

[Dutchie388]

ah ok cool. this is the database from a fresh mp1.01 and tvseries2.2.3389 and nothings else, with just 2 episodes imported. i'm still fiddling around....yeah if you have some spare time great! thx for your help

 

[ltfearme]

Hey Dutchie388, I have now added support to do this from with-in MediaPortal or from with-in the configuration. If you can hold off until v2.3 (don't ask when) you can have proper support for this feature.

The only thing left to do with the View system is create advanced conditional views e.g. All Series with Genre = "Action" and ContentRating > PG etc

 

[Dutchie388]

Fantastic! big fan of your work many thx for your responses

 

[Dutchie388]

hi, just tried your new release, the feature works a treat! well done and thank you