Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.


Messages - Chris64

Pages: [1] 2
1
Development / PVDB to Excel export (or tab seperated CSV)
« on: December 21, 2015, 01:31:47 am »
I thought I'd share a nice table export of PVDB to Excel with the FlameRobin SQL Tool (http://www.flamerobin.org/).
Windows download from http://sourceforge.net/projects/flamerobin/files/flamerobin-snapshots/0.9.x/.

It will output all your movies and series (with filenames and paths) in a somehow ordered manner :-)

Requirements: PVD database must be connectable via a firebird server (> v2.0).

Code: [Select]

-- ## NOTE: Comma seperator at the BEGINNING of a line
-- ##       allows for easy disabling certain lines!

SELECT
       IIF (c."title" IS NULL, a."title", c."title") AS "title"
       , IIF (c."origtitle" IS NULL, a."origtitle", c."origtitle") AS "otitle"
       , IIF (b."season" IS NULL, '', b."season") AS "S"
       , IIF (b."epnum" IS NULL, '', b."epnum") AS "E"
       , IIF (c."title" IS NULL, '', a."title") AS "etitle"
       , IIF (c."origtitle" IS NULL, '', a."origtitle") AS "eotitle"
       , a."year" AS "year"
    -- ## list directors in column "director(s)", if [null] set to '' (empty string)
       , LIST (DISTINCT IIF (e."name" IS NOT NULL, e."name", ''), ', ') AS "director(s)"
    -- ## list languages in column "lang(s)", if [null] set ''
       , LIST (DISTINCT IIF (g."value" IS NOT NULL, SUBSTRING(LOWER(g."value") FROM 1 FOR 3), ''), '|') AS "lang(s)"
       , a."rdate" AS "released", a."imdbrating" AS "IMDB", a."rating" AS "rate", a."orating" AS "orate"
       , a."url" AS "url", a."path" AS "path"
    -- ## put your replacement string for local drive name to a unc resolved one here
    -- ## adapt this line: i.e. 'M:\ALL_MY_MOVIES\' to '\\server\share\ALL_MY_MOVIES\'
       , (replace (a."path", 'M:\MYMOVIES', '\\movieserver\share\MYMOVIES\')) AS "unc"
       , a."mid" AS "a.mid", a."epid" AS "a.epid", a."series", b."mid" AS "b.mid", b."epid" AS "b.epid"
    -- ## for debugging or more infos
       -- , LIST (DISTINCT IIF (d."pid" IS NOT NULL, d."pid", ''), ', ') AS "d.pid(s)"
       -- , LIST (DISTINCT IIF (f."lid" IS NOT NULL, f."lid", ''), ', ') AS "f.lid(s)"

FROM MOVIES a
       LEFT JOIN EPISODES b ON a."epid" = b."epid"
       LEFT JOIN MOVIES c ON b."mid" = c."mid"
       LEFT JOIN CAREER d ON a."mid" = d."mid"
       LEFT JOIN PEOPLE e ON d."pid" = e."pid"
       LEFT JOIN AUDIO f ON a."mid" = f."mid"
       LEFT JOIN LANGUAGES g ON f."lid" = g."lid"

WHERE
       d."ctype" = 1                            -- ## only directors [=1]
       AND (d."pos" < 6 OR d."pos" IS NULL)     -- ## limit the number of directors, default=6 [starts at 0]
       AND (f."pos" < 5 OR f."pos" IS NULL)     -- ## limit the number of languages, default=5 [starts at 0]
       -- AND a."series" = 0                       -- ## if set [0], do not display series container
    -- ## user defined
       -- AND (a."title" LIKE '%James Bond%' OR c."title" LIKE '%James Bond%')
       -- AND (a."title" LIKE '%Doctor Who (2005)%' OR c."title" LIKE '%Doctor Who (2005)%')

GROUP BY
      "title", "otitle", b."season", b."epnum", "etitle", "eotitle", a."year"
      , a."rdate", a."imdbrating", a."rating", a."orating"
      , "url", "path"
      , "unc"
      , a."mid", a."epid", "series", b."mid", b."epid"


- Save the above code to something like "Movie and Series Export.sql" with a text editor.

- Load the file (some commentaries are included) into FlameRobin after having
  connected to your "Personal Video Database" (via firebird server).

- After execution of the statements make all records visible in FlameRobin (not only the first 300).

- Now select ALL records from the edit menu and copy them to clipboard (might take a while)

- Open an Excel sheet, mark 1st column / 1st row and press CTRL+V to insert your exported records.

- If you don't need UNC paths, comment these 2 lines:
   * from the SELECT statement:      -- , (replace (a."path", 'M:\MYMOVIES', '\\movieserver\share\MYMOVIES\')) AS "unc"
   * from the GROUP BY statement:  -- , "unc"

- I used this basically for learning, so the SQL statements might be improved ;-)

- This might also serve as a basic SQL export script - change it to fit your requirements.

Thanks for your attention and have fun...
CG


2
Support / Re: Missing awards from IMDB movie import plugin
« on: January 07, 2014, 02:55:55 pm »

It's fixed :-)
... and even posters are back ...

Thx a million, nostra !!!


3
Support / Re: Display aspect ratio
« on: November 27, 2013, 10:34:34 pm »

Thanks a lot! :-)

4
Support / Display aspect ratio
« on: November 27, 2013, 08:32:38 pm »
Hello nostra,

currently it looks like the "Display aspect ratio" from mediainfo.dll is used to determine the value
for the the respective database entry in PVD.
May I suggest to use the "Original display aspect ratio" (if available!) from mediainfo.dll in future
versions of PVD instead, since AFAIK this value reflects the DAR of the video container format
which is respected (and used) by almost all modern players like MPC-HC, VLC, SmPlayer etc. ?

TIA Chris


5
Support / Re: Missing awards from IMDB movie import plugin
« on: November 21, 2013, 05:53:09 pm »
Hi Ivek !

... looks like the problem is on my end ... with regards to the many answers filling this thread ;-)

Haven't got a clue though!



6
Support / Missing awards from IMDB movie import plugin
« on: November 12, 2013, 10:54:47 pm »

Latest IMBD plugin (v0.9.8.22) seems to fail when importing awards for a movie (PVD is v1.0.2.7).

It looks like the awards link is read on import, but even existing entries are NOT overwritten
when overwrite for awards is set.

Can somone please confirm this?

TIA Chris
 

7
Support / Re: Passing user credentials to Firebird server
« on: November 12, 2013, 12:33:17 am »
Actually, it seems like Firebird should pick those values by itself. I will check if it is smth easy I can do to make it do so,

I read about this too that fbclient should get it.
But it looks like it doesn't ... I already tried this to no avail. :-(

Code: [Select]
@echo off
SET PATH=C:\Program Files\PVD;%PATH%
SET ISC_USER=xxxxxxxx
SET ISC_PASSWORD=yyyyyyyy
start viddb.exe
# OR (alternatively)
viddb.exe

will not give me the expected behaviour from a batch.

Even setting the variables system wide would allow the cmd line tools
of Firebird (i.e. gbak) to work from a cmd line (without user/pass), while
PVD presents me a login prompt for the user/pass credentials on each
new start.

So thx for looking into it!

EDIT:
Forgot to mention that even "Process Hacker" shows the variables
in the process' environment of viddb.exe when started from the batch.


8
Support / Passing user credentials to Firebird server
« on: November 10, 2013, 08:43:28 pm »

Hi Nostra,

as far as I can see, PVD does not make any use of the "ISC_USER/ISC_PASSWORD" environment variables, which
would allow seamless connection from PVD to a FB server.

Is such feature planned?

TIA Chris

9
There is currently no possibility to disable this feature, but I will add it in the next update. If you name the files, so that they can't be matched with the name of the video file they will not be imported.

Thx for the prompt answer, Nostra. Since I batch generate my previews with "movie thumbnailer" (mtn) using the movie's file name,
i'd prefer some kind of "disable this feature" switch ;-)

BTW, v1.0.2.7 runs fine (... just installed). Big thx for this and your work!
 

10

Hi folks,

maybe I'm too stupid to find any information on this, but whenever I add a file path/file (movie file) to a db record,
all images (jpgs) with similar or same name as the movie itself are imported into (added to) the poster view.

Since I always save preview files with my movies, I do NOT want them to appear in the poster view automagically
(I always have to delete them manually after adding the movie's path). The very same happens on re-reading
the file information (from the list menu) of any particular movie.
From my observations, the "unwished import" does not happen when the movie is part of a series and sorted as such.

Any help or a switch to turn off this behaviour would be very welcome.

TIA Chris

11
Scripts and Templates / Re: A dark skin - best compromise ...
« on: November 06, 2013, 11:44:57 am »

@firefox: Thanks for the feedback and you're welcome!

So there's an update for all Windows 7/8/8.1 users to v1.0.2.6.103 now.

It looks like these OSs don't allow correct display of the 24bit (16,7 M) color depth bmps
attached to the skins anymore just as Windows XP did (let's call it an improvement/feature, Microsoft ...)
Changing the depth to 8bit (256) colors fixed the problem. And it still works on Windows XP :-)


Changelog from v1.0.2.6.102:
--------------------------------------
movie skin:
- Displays the rating bar now with a black background on Windows 7/8/8.1
  [thx to firefox for testing]

persons skin:
- Same changes as for the movie skin (see above)


@Ivek: TIA for updating! ;-)

---

12
Scripts and Templates / Re: A dark skin - best compromise ...
« on: November 05, 2013, 08:38:01 pm »
Hi, Chris
Many thanks for beautiful template for PDV. I like it a lot.
I have a bug with movie skin v1.0.2.6.102. In rating line, the stars area is white color not black color.
Please view the attached image.
My OS Windows 8.1, PDV v1.0.2.6.

My test setup is on XP, so it's hard to say what happens on W8.1.

One assumption though:
My screen color depth is set to 32 bit - what is your setting?


EDIT:
My assumption might be of no use, i guess ...

But I have another one which might fix your problem:

Go to your PVD Installation folder under Skins\Movies and Skins\People respectively and
make a backup of "buttons_cg_sdark.bmp" and "stars_cg_sdark.bmp".
Then replace the files in both subdirectories with the ones from the 7z you can download
from here, and reload the skin (or simply restart PVD).

If this works, please let me know(!) and I will update the skin package ;-)


13
Scripts and Templates / Re: A dark skin - best compromise ...
« on: November 03, 2013, 04:23:23 pm »
First of all, Ivek, you mustn't apologize for anything said or proposed here!!!

Why not here and where is it?

I apologize because I'm asking for opinions without stating the reason why I made some changes in color.
...


I agree. Your skin for further distribution.
I have a program to upload skins in the download page.

Original movie skin v1.0.2.6.102 is available via auto-update program.

OK ;-)
...  and a big thanx for your work!!!

14
Scripts and Templates / Re: A dark skin - best compromise ...
« on: November 03, 2013, 02:21:43 pm »
I changed some colors in the skin, what do you say to these changes.

I apologize because I'm asking for opinions without stating the reason why I made some changes in color.
The biggest reason is that I have major problems with your eyesight (I'm short-sighted with higher diopter), so it bothers me a dark background and very dark or very bright (faded) font on it, so I do not see and I can not read the information where it is very dark or very bright (faded) font. These changes, which I have done, allows me to be easier to read written information. It may be helpful to anyone who uses PVD and has similar problems, how to change and adapt to the skin.

By the way:
I use the skin with a light background for easier reading information. I like to help other users who create skins, so to solve problems that may arise in creating skins and the best possible appearance of the skin.
And more to:
Skins are well made and have a nice appearance.

Thus I made a new version (v1.0.2.6.101) available to let you
see my efforts. Be warned though - the layout of the skin has
changed to a more technical view.

Ivek, I have not merged your changes because they are not to my taste.
Let me explain why: my philosophy behind this work is to have some
"eye catchers" for the most relevant information I like to "see" at a glance
(and I know this depends from person to person). So light colors attract my
eye - that's why i.e. the title and (talking about the new skin v1.0.2.6.102)
duration of a movie, or the aggregated stream information got light colors.
"Green" i.e. stands for "done, achieved..." and "red" shows something missing
or a warning.
Simply put - your suggestions were "to light" (concerning the color changes)
for me and otherwise would blast my intention of "less is more".

Your "quantum of solace" might be, that it's all a matter of taste
when it comes to the question "better or not ..."

Anyway, feel free to create your own descendants of the skin, because it's free
software (even if only a XML file) and sharing is fun. Perhaps change the
name to not get in conflict with me ;-)

Yes, you are the creator of the skin, skins are and will remain yours. I will help
with ideas on how continue to improve the skin.

First of all, Ivek, you mustn't apologize for anything said or proposed here!!!

After reading your answer I have to admit that I hadn't people in mind, that are
i.e. visually impaired in some way (I myself had an eye cataract op years ago
without using progressive-addition lens glasses since - instead two with differently
fixed dioptric).

May I propose, that you maintain a "compromise of a compromise" of the skin for
the future and even publish that one for further distribution (since i cannot foresee
where all the difficulties might lie for others - and perhaps you can apply a good
measure).
Please take my admission to make any necessary changes to reach for a broader
viewing audience!

All those who are interested in "my" original skin can download it from the forum
anyway.

Awaiting your answer ...


15
Scripts and Templates / Re: A dark skin - best compromise ...
« on: November 03, 2013, 01:00:02 am »

Okay, ... and i swore, I know ...

Learning slowly what's possible and what not.

Thus I made a new version (v1.0.2.6.101) available to let you
see my efforts. Be warned though - the layout of the skin has
changed to a more technical view.

Ivek, I have not merged your changes because they are not to my taste.
Let me explain why: my philosophy behind this work is to have some
"eye catchers" for the most relevant information I like to "see" at a glance
(and I know this depends from person to person). So light colors attract my
eye - that's why i.e. the title and (talking about the new skin v1.0.2.6.102)
duration of a movie, or the aggregated stream information got light colors.
"Green" i.e. stands for "done, achieved..." and "red" shows something missing
or a warning.
Simply put - your suggestions were "to light" (concerning the color changes)
for me and otherwise would blast my intention of "less is more".

Your "quantum of solace" might be, that it's all a matter of taste
when it comes to the question "better or not ..."

Anyway, feel free to create your own descendants of the skin, because it's free
software (even if only a XML file) and sharing is fun. Perhaps change the
name to not get in conflict with me ;-)

That said, we now have a

Changelog from v1.0.2.6.101:
--------------------------------------
movie skin:
- Smaller Rating Box (width) [190->135]
- Smaller Seen Box (width) [190-116]
  => Both changes will allow for 1152x864+ screen resolution without
       any loss (full list width on Win XP) ... you might even get it
       working at 1024x768 with a smaller list view ... ;-) [untested]
- Seen/Wish changed [bold->normal]
- Color changes for video/audio display
- Duration/File Size/Resolution placed directly under Poster window now

WARNING:
- Overall the skin is emphasizing more on the technical aspects of
  your rip(s) from now on. So be warned before updating and make ...
  yeah, backups!

I will attach a preview to let you make your decision easier ...


16
Scripts and Templates / Re: A dark skin - best compromise ...
« on: November 02, 2013, 08:47:09 pm »

BTW, Ivek, a question to fields in the XML file:

To me it looks like that each field variable can only be used once in a skin.
Only the last instance becomes visible in a skin.  Is this correct (or really true)?



17
Scripts and Templates / Re: A dark skin - best compromise ...
« on: November 02, 2013, 06:42:35 pm »
I changed some colors in the skin, what do you say to these changes.

Changelog v1.0.2.6.102:
-------------------------------
movie skin:
- "<linkcolor_memo>" changed [DDDDFF->FFCC00]

persons skin:

- "Comments" color changed [FFFFFF->00FF55]
- "<linkcolor_memo>" changed [DDDDFF->FFCC00]

The download file contains zero bytes, so all i get is nothing at best ;-)

One request i have though is, if you make changes to an existing skin, give it a suffix of "b", "c" or "d" etc. - because
it will not collide with my numbering of versions - since v1.0.2.6.102 is already in development here :-(

But I'm eager to see your improvements! So just name it i.e. v1.0.2.6.101b and reup it here - then i might merge it
with my latest changes ...

Chris

18
Scripts and Templates / Re: A dark skin - best compromise ...
« on: November 01, 2013, 08:19:41 pm »
EDIT:
Ivek, FYI, I added my minor version (-v101) number to the XML files to make testing easier for me with different
versions in the PVD\Skins subdirectories. They should work without this extension, because the "skinname" has not,
and the "version" has changed in the XML files.

If you prefer some other (consistent) naming for the distribution, let me know ...

Such naming skins for testing should remain.

OK.

19
Scripts and Templates / Re: A dark skin - best compromise ...
« on: November 01, 2013, 07:30:44 pm »
Hi Ivek,

Though I swore not to touch the skins again, I made some minor changes and fixes :-)

... and I guess you'll have to update them now from the attachment, so TIA ... ;-)

Lots of fun
Chris


Changelog v1.0.2.6.101:
-------------------------------
movie skin:
- Buggy entry in "<linkcolor_memo>" [DDDDFFF->DDDDFF] fixed
- some cleanups

persons skin:
- column containing the photo is changed in width [160->190]
  (now the buttons menu is allowed to be seen WITH the DELETE button in edit mode ... hopefully)
- Buggy entry in "<linkcolor_memo>" [DDDDFFF->DDDDFF] fixed
- "Translated name" color changed [FFFFFF->DDDD00]
- "Alternative names" color changed [FFFFFF->DDDDDD]
- "Birthday" color changed [FFFFFF->00FF55]
- "Date of death" color changed [FFFFFF->FFD00BB]
- "<linkcolor_combo>" changed [FFFFFF->DDDDDD]


EDIT:
Ivek, FYI, I added my minor version (-v101) number to the XML files to make testing easier for me with different
versions in the PVD\Skins subdirectories. They should work without this extension, because the "skinname" has not,
and the "version" has changed in the XML files.

If you prefer some other (consistent) naming for the distribution, let me know ...


20
Scripts and Templates / Re: A dark skin - best compromise ...
« on: November 01, 2013, 04:04:21 pm »

Of course! :-)

I attached preview files for all those who need some impression before downloading ...


Pages: [1] 2