Reply to thread

Message

<blockquote data-quote="RoChess" data-source="post: 653634" data-attributes="member: 18896">Re: AW: How do i create a &quot;import path&quot; view ?You open your TVSeriesDatabase4.db3 database file in an SQLite editor, and then go to the 'Views' table.In here you will find all the views that come default and those that you added via the MP-TVSeries configuration screen for Views. The name of the view is in the TransToken column and the pseudoSQL is in the viewConfig column.So add a new view, and then edit that view with an SQLite editor so it does what you want. But in order to do so you need to know SQL, so you can create the correct query and then you need to convert that into MP-TVSeries pseudeSQL. This is not easy, which is why there are only a select few templates included on what most people want a view on.The pseudoSQL only has access to a few select tables and corresponding columns, but I lost my reference guide as to which ones they are. Just check the pseudoSQL code on the existing templates otherwise, you should be able to figure it out if you know SQL. And if you don't then you will just have to be patient till more view filter functionality is added in the future.PS: And I believe I answered you before, you can just use the default Template for 'Removable Media'. Place your German series on the local HDD and the English one on Removable media, then you can filter them with the existing template. Otherwise look at the pseudoSQL code for the templates on 'High Definition', 'Removable Media' and 'Subtitles' and you might be able to figure something out that will work for your situation.</blockquote>

[QUOTE="RoChess, post: 653634, member: 18896"] [b]Re: AW: How do i create a "import path" view ?[/b] You open your TVSeriesDatabase4.db3 database file in an SQLite editor, and then go to the 'Views' table. In here you will find all the views that come default and those that you added via the MP-TVSeries configuration screen for Views. The name of the view is in the TransToken column and the pseudoSQL is in the viewConfig column. So add a new view, and then edit that view with an SQLite editor so it does what you want. But in order to do so you need to know SQL, so you can create the correct query and then you need to convert that into MP-TVSeries pseudeSQL. This is not easy, which is why there are only a select few templates included on what most people want a view on. The pseudoSQL only has access to a few select tables and corresponding columns, but I lost my reference guide as to which ones they are. Just check the pseudoSQL code on the existing templates otherwise, you should be able to figure it out if you know SQL. And if you don't then you will just have to be patient till more view filter functionality is added in the future. PS: And I believe I answered you before, you can just use the default Template for 'Removable Media'. Place your German series on the local HDD and the English one on Removable media, then you can filter them with the existing template. Otherwise look at the pseudoSQL code for the templates on 'High Definition', 'Removable Media' and 'Subtitles' and you might be able to figure something out that will work for your situation. [/QUOTE]

Verification