21
Support / Re: Personal Video Database 1.0.2.7 MOD
« on: October 29, 2018, 07:49:50 pm »
And get only Movies not TV Episodes? Is it possible?
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.
22
Support / Re: Personal Video Database 1.0.2.7 MOD
« on: October 26, 2018, 08:59:04 pm »
Attached temporal Acumulative Scripts Patch date:2018.10.26 (to copy in PVD folder for overwriting the existing files).
ATTENTION: For recover Toolbar it overwrite the 'pvdconf.ini' file and Tabs folder.
Changelog:
Corrected "Date:=StringReplace(Date,'01.','1.',True,True,False);"
Now retrive directors, authors, composers, etc from the principal page
Recover the Toolbar with the indispensable buttons (Delete posters, clear data,etc)
Note: This is a release candidate.
ATTENTION: For recover Toolbar it overwrite the 'pvdconf.ini' file and Tabs folder.
Changelog:
Corrected "Date:=StringReplace(Date,'01.','1.',True,True,False);"
Now retrive directors, authors, composers, etc from the principal page
Recover the Toolbar with the indispensable buttons (Delete posters, clear data,etc)
Note: This is a release candidate.
23
Support / Re: Personal Video Database 1.0.2.7 MOD
« on: October 22, 2018, 08:39:30 am »Quote
working with Firebird databaseI think that in the MOD version there are only two modification that may to influence this functionality: it runs in portable mode and there is a dll update.
I can propose you some test (important, first make a backup of your actual instalation):
1) Replace the Scripts and Plugings folders of your current installation with the MOD folder but run it in normal mode (NOT with Portable.bat)
With this you have a MOD working copy over your standart installation.
2) If it works, copy the MOD dll's to the current installation. If it works, I suspect that the portable mode does not allow the connection with the Firefox server, if it does not work I suspect that the problem is the new dll.
Let us know your results.
(see "Dirty" own PVD installation/collection adaptation for advanced users" for more information)
24
Support / Re: Personal Video Database 1.0.2.7 MOD
« on: October 21, 2018, 10:08:29 am »
The same acumulative patch but with LogMessages improvements (only for the scripts developers: better tabulation, texts with the Custom Field name, etc)
25
Support / Re: Personal Video Database 1.0.2.7 MOD
« on: October 20, 2018, 07:52:00 pm »
Attached temporal Acumulative Scripts Patch date:2018.10.20 (to copy in PVD folder for overwriting the existing script files).
Changelog: (All posted alerts treated but the last GET_FULL_CREDIT=False)
IMDB_[EN][HTTPS].psf and IMDB_People_[EN][HTTPS].psf:
V 1.2.0.3 (20/10/2018) Improvement of search stored URL. Better script flow control. Only get FULL_AKA in MediaType='Movie'. More Ivek23 corrections.
FilmAffinity_[xx][HTTPS].psf
V 4.0.0.6 (20/10/2018) VVV: Improvement of search stored URL. Added the custom field FilmAffinity_Rating. Better script flow control.
)...
but now I have a very little amont of free time. Can anybody help with the script?
Changelog: (All posted alerts treated but the last GET_FULL_CREDIT=False)
IMDB_[EN][HTTPS].psf and IMDB_People_[EN][HTTPS].psf:
V 1.2.0.3 (20/10/2018) Improvement of search stored URL. Better script flow control. Only get FULL_AKA in MediaType='Movie'. More Ivek23 corrections.
FilmAffinity_[xx][HTTPS].psf
V 4.0.0.6 (20/10/2018) VVV: Improvement of search stored URL. Added the custom field FilmAffinity_Rating. Better script flow control.
Quote
It is necessary to check " // Get Cast." GET_FULL_CREDIT = False only the info of the main movie page. " code in Function ParsePage_IMDBMovieBASE sectionI agree but there is enougth info of the directors, authors, composers, etc in the principal page for the normal user (for instance for me
)...but now I have a very little amont of free time. Can anybody help with the script?
26
Support / Re: Personal Video Database 1.0.2.7 MOD
« on: October 08, 2018, 07:41:16 am »
Good news even if it must expend "some" manual editing time! It's true that the Grid View edition is a little bit forgotten.
Perhaps you have some especial chars in the URL's fields that the browser is capable to manage and PVD crash (for instance, the URL's must be separated by spaces not by Return, char#13).
And if all records are with those formats are easy to change with a SQL script because the URL field is a little bit especial, for instance, I haven't found the manner to protect it from script write or to delete all with the mass editor.
Perhaps you have some especial chars in the URL's fields that the browser is capable to manage and PVD crash (for instance, the URL's must be separated by spaces not by Return, char#13).
Quote
Regardless of Ivek's and mine issue regarding "www", it is obviously solvable, one way or another.I strongly recommend you use the standar url formats because there is other script (TheMovieDB) that use the IMDB link and is the normal way of PVD to detect the provider url (remember when PVD directly download the page when it detects the BASE_URL in the URL field, this is the reason that in the HTTPS scripts the function GetBaseURL returns BASE_URL_ROUNDABOUT in order to cheat GET PVdB funtion and rondabout the "https" fail).
And if all records are with those formats are easy to change with a SQL script because the URL field is a little bit especial, for instance, I haven't found the manner to protect it from script write or to delete all with the mass editor.
27
Support / Re: Personal Video Database 1.0.2.7 MOD
« on: October 07, 2018, 12:23:30 pm »
I'm agree with you that the script doesn't give you any problems.
I want to say that perhaps this is because the script don't use the stored URL and it search the title in IMDB and continues scrapping.
You may see the script behaviour with the log window tool.
I want to say that perhaps this is because the script don't use the stored URL and it search the title in IMDB and continues scrapping.
You may see the script behaviour with the log window tool.
28
Support / Re: Personal Video Database 1.0.2.7 MOD
« on: October 07, 2018, 10:47:29 am »
Attached non critical Acumulative Scripts Patch date:2018.10.07 (to copy in PVD folder for overwriting the existing script files).
Changelog:
IMDB_[EN][HTTPS].psf and IMDB_People_[EN][HTTPS].psf:
V 1.2.0.2 (07/10/2018) Managed IMDB url's not finish in BASE-URL-SUF='/' and principal page download errors.
Changelog:
IMDB_[EN][HTTPS].psf and IMDB_People_[EN][HTTPS].psf:
V 1.2.0.2 (07/10/2018) Managed IMDB url's not finish in BASE-URL-SUF='/' and principal page download errors.
29
Support / Re: Personal Video Database 1.0.2.7 MOD
« on: October 07, 2018, 10:44:54 am »Quote from: Ivek23
The interesting thing is that I did not have any problems in updating the information.Is sure that the script don't find the IMDB url. Maybe that the script are always searching the movie URL's in IMDB page but it find at first and don't ask nothing. You can see that with the Log tool. In this movies, after pass the script, don't you have two IMDB url's stored?
Quote from: afrocuban
To add to this, I hve experienced one more IMDb script issue:This is not easy to solve with a SQL script so I code a not critical MOD patch for you. In the next post.
- If URL doesn't have slash - "/" at the and, we get "404" error message, like URL doesn't exist on imdb.com, while actually url is valid. Please see first screenshot attached.
- After pressing OK (1-5 times, depending on how many pages are imported), script adds ghost link: - "http:/"? Please check second screenshot.
30
Support / Re: Personal Video Database 1.0.2.7 MOD
« on: October 06, 2018, 08:39:06 pm »Quote
Is it possible then, considering your statement:
... to standardize urls in form:
[*.]imdb.com/title/ttxxxxxxx/
[*.]imdb.com/name/nmxxxxxxx/
I think to do that this is dificult because the script use the parameter
BASE_URL_PRE = 'http://www.imdb.com/title/''
to make the url and for search if exist the url.
And this is risky because if the original PVD came to live again it use the same behavior with the Function GetBaseURL for locate the url.
But Ivek23 and you don't need add 'www' manual the SQL script (remeber, in debug mode Help/SQL, As script checked)
update MOVIES set "url"=replace("url",'http://imdb', 'http://www.imdb');
works fine: I test it.
31
Support / Re: Personal Video Database 1.0.2.7 MOD
« on: October 06, 2018, 01:38:02 pm »
This is easy: in both "13" and "After life" imdb url's lacks "www" remeber the standar url is:
http://www.imdb.com/title/ttxxxxxxx/
Perhaps you can use the SQL script:
update MOVIES set "url"=replace("url",'http://imdb', 'http://www.imdb');
.
BTW, one tools that can help you is pass the db to Excel with the export template "CSVDB" and search with the excel filters some bizarre things.
http://www.imdb.com/title/ttxxxxxxx/
Perhaps you can use the SQL script:
update MOVIES set "url"=replace("url",'http://imdb', 'http://www.imdb');
.
BTW, one tools that can help you is pass the db to Excel with the export template "CSVDB" and search with the excel filters some bizarre things.
Quote
Do you by any chance know what exactly optimizing will do to my database?It will do as you select: delete duplicates entries, delete orphan persons (persons not related with your movies). You can select if it will do with all movies/people or only qith the visible (so you can protect movies with a filter and hidde it's)
32
Support / Re: Personal Video Database 1.0.2.7 MOD
« on: October 04, 2018, 10:32:43 am »
Have you used the Tools/Optimize database ... ?
Perhaps it solved your "write protected" records but I warm you that it spend a lot, a lot of time.
With a 7.000 movies you must have more of 200.000 persons!
Perhaps you will spent one or two days with PVD working and the PC un-responding.
Perhaps it solved your "write protected" records but I warm you that it spend a lot, a lot of time.
With a 7.000 movies you must have more of 200.000 persons!
Perhaps you will spent one or two days with PVD working and the PC un-responding.
33
Support / Re: Personal Video Database 1.0.2.7 MOD
« on: October 03, 2018, 12:13:40 pm »
I have found different url formats versions in my PVD too?
Can we write a fast url standards?
My proposal is (remember that we cann't use httpS):
IMDB Movie (finish with '/'=Slash):
update PEOPLE set "url"=replace("url",'?ref_=tt_ov_dr', '/');
update PEOPLE set "url"=replace("url",'?ref_=tt_ov_wr', '/');
perhaps it may help to correct something.
AddCustomFieldValueByName('FilmAffinity_Rating',ItemValue);
because it doesn't nothing bad for the "normal" users but you need add by yourself this Custom field.
BTW, I have included several 'hidden' Custom Fields of Ivek23 in the scripts.
Ivek23, perhaps can be useful for other users open a new Thread with the information "Possibles improving Custom Fields" working in MOD version, how is the information and how add in the PVD database.
Can we write a fast url standards?
My proposal is (remember that we cann't use http
IMDB Movie (finish with '/'=Slash):
- Movie=http://www.imdb.com/title/ttxxxxxxx/
- Person=http://www.imdb.com/name/nmxxxxxxx/
- Movie=http://www.themoviedb.org/movie/xxxxxxx
- Person=http://www.themoviedb.org/person/xxxxxxx
- Movie Spanish= http://www.filmaffinity.com/es/filmxxxxxxx.html
- Movie English= http://www.filmaffinity.com/en/filmxxxxxxx.html
update PEOPLE set "url"=replace("url",'?ref_=tt_ov_dr', '/');
update PEOPLE set "url"=replace("url",'?ref_=tt_ov_wr', '/');
perhaps it may help to correct something.
I just wanted to ask if it's possible FA to have it's own rating custom field?In the next MOD version I will include the solution that Ivek was advancing
AddCustomFieldValueByName('FilmAffinity_Rating',ItemValue);
because it doesn't nothing bad for the "normal" users but you need add by yourself this Custom field.
BTW, I have included several 'hidden' Custom Fields of Ivek23 in the scripts.
Ivek23, perhaps can be useful for other users open a new Thread with the information "Possibles improving Custom Fields" working in MOD version, how is the information and how add in the PVD database.
34
Support / Re: Personal Video Database 1.0.2.7 MOD
« on: September 29, 2018, 09:44:42 am »Quote
Have you more Customs Fields that the MOD estandar? ... A lot more.The PVD is very stable but it have some inner problems: Be careful with spaces in the Custom Fields.
Quote
The error cames in the same movies? ... YES!If you tell us the movie title perhaps Ivek32 or myself can reproduce the problem.
Quote
The error cames with other scripts/provider? ... No. Checked with FA and TMDb.So the problem is with the IMDB scritp. This is a very complicated script. In the default version it dowloads 6 web pages, everyone with his own routine. So is very important to know what page 'fails'. BTW, if you are updating only some fields you are downloading a lot of not needed pages.
Quote
I must admit I don't know how to use ***Script M. Configuration***.I must rebuke you
.You are losting a lot of time. I rewrite the ***Script M. Configuration*** help in this post Controling the retreived information in PVD MOD
If you are trying only to update Title, Top_250 and IMDb_Votes You only need the principal page so you must uncheck the other 5 pages! (7000 movies x 5 pages = 35.000 downloads saved) Please, make a little efort
Quote
My custom fields were "Top 250:" and "IMDB Votes:", so now because you gave them different names, I have to update 7000 movies,You don't need create a new fields, you can rename its. See this post
Quote
I disabled updating fields in IMDb script and I discovered that if I disable updating some or all fields, everything works, for now!? Not all of these fields cause problems for movies. For some movie only one field causes problem, for other movie other two fields, and for some movies all these fields.Please, tell us those fields and movies! As I wrote in the forum, there is some uses of the database for the script not very safe (use Description and Comments, fields that are used for movie information and user file information, etc). The PVD database standar is not completely finished.
One more example of this, if you wants to update the Comments or the user Rating (not the IMDBrating) with a script you must clear it before (normaly with the Mass Editor)
Quote
If I delete it, when I press to exit edit mode, deleted Title comes back? Also the same for Description for some some movies - I delete it and it comes back when I exit edit mode?!Perhaps you have people information (awards, featured, etc) with the same movie that you have.
PVD have information of the movie by two way: By Movie list and by People info (for this I not download the People's awards, it brings to PVD a lot of unknowed movies).
35
Support / Re: Personal Video Database 1.0.2.7 MOD
« on: September 27, 2018, 06:04:00 pm »
Nice to know about you, afrocubam 
You have got a hard error, it seems that PVD tries to dulicate some record with a SQL instruction.
Some information in in this link: Why am i getting a primary/unique key violation/
Some test in order to detects/reproduce the problem:
Really is a strange error,
You have got a hard error, it seems that PVD tries to dulicate some record with a SQL instruction.
Some information in in this link: Why am i getting a primary/unique key violation/
Some test in order to detects/reproduce the problem:
- Have you more Customs Fields that the MOD estandar? (In the last version I have include 'Updated').
- The error cames in the same movies? If yes, can tell us.
- The error cames with other scripts/provider? If yes, can tell us.
- Can you try disabling IMDB pages donwloading with the ***Script M. Configuration***? First try only dowloading the base page, after adding the Certification page, after adding the "Also Know as' page,... I suspect of the retreive of people because it is the part less depurated in PVD and the one that handles more links.
Really is a strange error,
36
Support / Re: Personal Video Database 1.0.2.7 MOD
« on: September 23, 2018, 08:13:39 pm »and started to copy/paste my files and then the problems started with duplicates in the portable mod versionSo I think that you have choose the way 'Copy & Paste' movies in PVD, isn't it?
When you say 'my files' what do you want to say? Because in this way you must copy and paste de PVD records, the 'movie lines': Amadeus, Casablanca, etc from the database of the old version in the MOD PVD.
Have you tried first one by one movie in order to learn?
Can you attach one error window screenshot?
37
Support / Re: Personal Video Database 1.0.2.7 MOD
« on: September 22, 2018, 10:44:56 am »hello, have been a long time user of this wonderful program , but i am completely lost as to how to use this mod. is there a clear , step by step explanation of how to install this mod over the old one. i have tried to do it with the instructions in the early part of this discussion but it did not work. i am not a programmer so a lot of what you say is very easily misunderstood . i really hope some one can help.I have rewritten the post 'Passing from original PVD version' in order to help to this situation.
would love to get this program working the way it used to.
many thanks
I understand that you have installed the MOD version and you have problems to recover your movie database over the MOD version.
If you are a ancient PVD 1.0.2.7 user, the easiest way to change to the MOD version is Copy and Paste the movies.
If you are a ancient PVD 0.9.9.21 user, follow the Ivek23 post steps. Or, other way longer, pass first to the original 1.0.2.7 and then Copy and Paste the collection.
Note: If you are a normal user, I strongly recommends use the SyMenu free launcher to install and keep updated the portable Personal Video Database 1.0.2.7 MOD version (after pass your ancient collection). It's easy and completely free without charges, advertisements, etc. (same philosophy as PVD) and perhaps you discover other advantages (for instance the Win10 users don't need use the infamous Windows Tiles).
38
Support / Re: Personal Video Database 1.0.2.7 MOD
« on: September 20, 2018, 07:46:48 pm »
Attached the Acumulative Scripts Patch date:2018.09.20 (to copy in PVD folder for overwriting the existing script files).
All alerts just to this message applied.
Wonderfull, Ivek23, you have discover the bug in PVD= Field number 14 works in minutes and ~length~ field works in seconds but two are Duration. Easy to solve multiplying by 60.
Thank you for your alert, Miguelh1020, try to apply this acumulative Patch over "PVD MOD 2018.08.08" Scripts folder.
All alerts just to this message applied.
Quote
~ length ~ works but this part of the code AddFieldValueXML ('length', ItemValue); it prints Lenght number 00:01:37, which is wrong.
This part of the AddFieldValue code (14, ItemValue); // Filed number 14 = Duration. it prints Lenght number 01:37:00, which is absolutely correct.
Wonderfull, Ivek23, you have discover the bug in PVD= Field number 14 works in minutes and ~length~ field works in seconds but two are Duration. Easy to solve multiplying by 60.
Quote
I noticed a difference with my olf file made with the old PVD
Thank you for your alert, Miguelh1020, try to apply this acumulative Patch over "PVD MOD 2018.08.08" Scripts folder.
39
Support / Re: Personal Video Database 1.0.2.7 MOD
« on: September 19, 2018, 07:00:30 pm »I'd like to request that the AdultDVDEmpire script be adapted for this mod. I've been sort of maintaining the ADE script in the past, but I can lo longer get PVD and Proxomitron to play nice together. From what I can glean from looking at the mod's scripting, the mod uses an external program to download all https:// web pages, then parses them locally. This is beyond my capabilities to adapt.The script development has changed a little but is not far from the traditional aproach and all funtional code can be re-used ... and I can help you.
For test if your ancient script work you can follow those steps:
1) In Explorer/Firefox browse the page of one movie in your provider and "Save as" / "Web page, only HTML" it in a text file "Example_movie.htm" in your Scripts folder
2) In your script:
a) In the function GetDownloadURL, code the result as "Result:='http://httpbin.org/response-headers?key=Null';" (this avoid the HTTPS PVD problem)
b) In the funtion ParsePage, recover the dowloaded provider page with "HTML:=FileToString(GetAppPath+'Scripts\'+'Example_movie.htm');"
3) After this instruction you can process the page with the script in order to get all the information.
4) When you arrive a good result for this unique movie, publish the script in the forum that I pass the code to the new download script process and then you can try it with multiple and real pages and finish the script.
Note: For process the results of the search page you can use the same method.
Let's go, you can do it!
... and all people are invited too! 40
Support / Re: Personal Video Database 1.0.2.7 MOD
« on: September 19, 2018, 06:25:36 pm »
Attached the Acumulative Scripts Patch date:2018.09.19 (to copy in PVD folder for overwriting the existing script files).
All Ivek23 alerts just to this messages included but:
Please, Ivek test the ~length~ question.
With ~length~ it works for me in the two PVD versions but if you don't have movie file you must edit the movie panel in order to see it (add a field by number is [deprecated] in PVD manual).
Note: I have removed the PRESERVE_USER_MOVIE_CHARS parameter because this can be done with the 'Set Overwrite Options for the selected plugin' (the "Calendar" button, at right of the script 'Import name' in the 1.0.2.7 version and in 'Preferences/Plugin Preferences' in the 0.9.9.21).
All Ivek23 alerts just to this messages included but:
Please, Ivek test the ~length~ question.
With ~length~ it works for me in the two PVD versions but if you don't have movie file you must edit the movie panel in order to see it (add a field by number is [deprecated] in PVD manual).
Note: I have removed the PRESERVE_USER_MOVIE_CHARS parameter because this can be done with the 'Set Overwrite Options for the selected plugin' (the "Calendar" button, at right of the script 'Import name' in the 1.0.2.7 version and in 'Preferences/Plugin Preferences' in the 0.9.9.21).