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 - Peter

Pages: [1]
1
Support / Re: Can I avoid the links?
« on: January 21, 2017, 07:58:33 pm »
Perfect! It works fine with the code you mention, namely this one:

Code: [Select]
<row>
       <column halign="right" valign="top">
<spacer width="12" />
        <label width="128">
          <caption>Darsteller/innen:</caption>
        </label>
        <spacer width="7" />
    <custom field="Darsteller/innen:" collapsedlines="15"></custom>
        <spacer width="11" />
   </column>
   </row>

As you say, I only had to change a little bit some figures, namely the figure for the first spacer width (from 12 to 4) and the figure for label width (from 128 to 116) so that the lines of the field and the field name are in the same position as the other ones.

I enclose a picture to show how the entry for a movie looks now with the configuration I made, based on the friendly support given by Ivek23. I am completely happy now with this look and the arrangements of the fields.  :D

Thank you so much, Ivek23.  :)


2
Support / Re: Can I avoid the links?
« on: January 21, 2017, 04:37:41 am »
Wow, so easy.  ;) Formerly I had tried to make similar entries in the xml-file, but without success. That's why I had asked. Now - with your support - all the lines in the field are automatically visible. Perfect! Once more: thank you, Ivek23.

Only a small detail still does not work as it should: The field name ("Darsteller/innen") is still in the middle instead in the first line (when the contents fills 2 or more lines). This happens although I added the valign="top" on the place you showed me.

If it is easy for you, it would be nice if you could tell me what should additionally be changed (so that it is in the first line). But it is really of no big importance. So please do not spend a lot of time or research work on this. I ask only in case that it is obvious and easy for you to find out what should be modified additionally in the xml-file.

3
Talk / Re: Donations to Ivek
« on: January 21, 2017, 04:20:25 am »
Hello Ivek23,

just know I saw this thread (due to the new postings). So I would like to tell you here (in this thread) too that your phantastic support is highly appreciated and that I am very thankful for it.  :)

But most of all I wish you all the best concerning your health condition!

4
Support / Dynamic SQL Error in Advanced Search
« on: January 09, 2017, 07:10:14 am »
I would like to mention a minor problem:

When performing an advanced search, sometimes (not always) the following error message appears:

Quote
Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, column 107
-
Invalid token
Error Code: 249.
(see also the attached picture)

Fortunately, whenever I repeat the (same) search immediately a second time, the message does not appear again and the search takes place as it should.
When starting the next advanced search (with another word or in another field) the same may happen: The first try leads to the error message, the second try works.

In case that it is of importance: About exactly the same error message a thread can be found here:
http://www.videodb.info/forum_en/index.php/topic,1471

The problem there (in the other thread) appeared with Chinese titles - I do not use such titles. Specific in my case is that I perform the Advanced Search in custom fields (as specified in this thread: http://www.videodb.info/forum_en/index.php/topic,4061.0.html). I do not know if the problem could have to do with this fact.

Thanks in advance if anyone can help.

5
Support / Re: Can I avoid the links?
« on: January 08, 2017, 09:52:14 pm »
All works fine with your solution, Ivek23. I have transferred in the meantime my old entries to the new skin and from now on I am working directly with it.  :)

I would like to ask you about a small (and surely not very important) detail:

It would be fine if my custom field "Darsteller" * could look like exactly in the same way as the corresponding field "Actors" (respectively in German "Darsteller") in my old skin (= the one with the links).
*[in the meantime I changed the name to "Darsteller/innen" but this is of no importance for my issue]

That means:

a) The name of the field ("Darsteller") should always be in the first line beside the field (on top) [see picture 01] and not in the middle [see picture 02]. (achieved in the old skin by valign="top")

b) It would be nice if more lines of this field (for example the first 5 lines) could always be visible (expanded) [see picture 01] and not only the first line [see picture 03]. (achieved in the old skin obviously by collapsedlines="5") It would also be o.k. if all lines of this field are always expanded.

Here the parts of the xml files which seem to be relevant in this matter:

From my old skin (= the one with links) (= pvd_classic_movie.xml with small modifications):

Code: [Select]
<row>
   <column width="120" halign="right" valign="top">
    <fieldlabel field="human" category="0"/>
   </column>
   <column>
<human category="0" collapsedlines="5"/>
   </column>
  </row>

From my new skin (= the one without links) (= pvd_classic-movie (ex).xml with small modifications):

Code: [Select]
  <row>
       <column>
        <label width="128" halign="right">
          <caption>Darsteller/innen:</caption>
        </label>
        <spacer width="7" />
    <custom field="Darsteller/innen:"></custom>
        <spacer width="11" />
   </column>
<column>
   </column>
  </row>

If it is easy for you to find out how I would have to change the xml file, I would be grateful for your advice.

6
Support / Re: Can I avoid the links?
« on: January 05, 2017, 04:38:48 pm »
Hello Ivek23!

I am very happy. :D After a long delay I tried again to create entries without links - following the instructions you gave in this thread. And this time it worked fine and so easily.

Maybe that it is of interest for other users too, so I will describe how I do it now:

A) For adding new entries (movies) without links for names (Actors, Director, Producer etc.) the method is very simple:

- I downloaded the skin pvd_classic_movie (ex) skin, as offered by you in your above posting #23 (25 August 2016) (= http://www.videodb.info/forum_en/index.php/topic,4061.msg19774.html#msg19774) and copied it in the folder mentioned there. (In my case the folder is part of the portable version of PVD).

- I created the memo custom fields as explained and shown by you in your postings #25 and #20 (especially picture sshot-40).

- In essence, that's all. When chosing now your skin, I can create data/names without links.  :)

It is only of importance to take care that the names of the memo custom items are the same as in the xml file of the skin. (In my case, I decided to use the following [german] names: Darsteller: / Drehbuch: / Musik: / Produzent: / Regie: )

Moreover I modified - also in the xml-file of your pvd_classic_movie (ex) skin - some minor details as font, font size, background colours etc. (adjusting it more or less in the way I had done it in the old skin).

[A few quite unimportant details I was not able to modify until now. Perhaps about them I will ask you at another time in case that you will still be ready to offer your friendly support.]

B) Concerning already existing entries in the database (= entries where the names have links):
I think in order to remove these links you created the script "txtinfo_en (0a).psf" (as offered and described in your above postings). As I have no experience in using scripts I did not know how exactly to handle it. But I made the removing of the links manually which may be more work but it is funny work as you see immediately its success. ;)

- It is important to open an entry (movie) with the old skin (the one which creates the undesired links). When starting the editing you will see there the new custom fields. This was something that first worried me, but now I found out what to do with it: I simply transfer the entries (names) from the field where they have been until now to the corresponding new custom fields at the bottom (with a simple copy and paste) (see the attached image).

- After saving this modification and then changing to the new skin, all entries (names) are at the right place (as it were with the old skin) but now without the links. Perfect!

Ivek23, once more many thanks for all your fantastic work and support:)

7
Support / Re: Can I avoid the links?
« on: August 26, 2016, 01:40:23 pm »
O.k. Perhaps I will try again at another time. At the moment it is too complicated for me. :-\ For the time being I will stay with PVD in its "normal" version (= with the links).

Nevertheless your fantastic support is highly appreciated, Ivek23. It is not your fault but mine that until now I was no table to get it to work. Once more many thanks for your work, your help and your patience. :)

8
Support / Re: Can I avoid the links?
« on: August 25, 2016, 09:57:08 pm »
That sounds good.  8)

I tried the new skin but I have a problem with the following:

All custom fields have the same places as the normal fields in PVD for Darsteller, Regie, Drehbuch, Produktion, Musik (for Actors, Director, Writer, Producer, Composer).

When I add a new movie, the fields look like on the attached picture ("New skin"): The fields for Darsteller (Actors), for Regie (Director) etc. are not visible although I can see the appropriate entries in the xml-file you created.

9
Support / Re: Can I avoid the links?
« on: August 25, 2016, 03:09:19 pm »
Your description and your pictures are very useful, but I think that nevertheless the whole procedure is too complicated for me.  :-\

In detail:

The txtinfo_en (0a).psf  file can not be converted from Wordpad in a txt file, because then they will no longer work. The same applies to all files .psf extension.
O.k. That was a misunderstanding from my side. You meant to create a new txt file directly in Wordpad.

Files with .psf extension copy in C:\Program Files\Personal Video Database\Scripts. The same also applies to the txtinfo_en (0a).psf , txtinfo_en (0b).psf and txtinfo_en (0c).psf  file
O.k. Done.

To movie.txt files, which I have added myself and all those movie.txt files, which you create yourself, so you make a special folder, which will then all these movie txt file saved for later because you will then needing to transfer information in your PVD Movie Database.
O.k. Done too.

Now that you have all this, PVD, run the program and create custom fields as you see in the attached sshot-40 picture.
O.K. (Very useful your picture.  :) )

Then edit your txtinfo_en (0a).psf file as a whole the attached sshot-41 picture. Now, in the Import tab locate the txtinfo_en (0a).psf file and import movie information for a specific movie title, open a window in which to find previously mentioned folder where you saved txt file for a particular movie and you click on it and will take place the transfer of information in your PVD Movie Database for a particular movie (see images at this link: http://www.videodb.info/forum_en/index.php/topic,4061.msg19764.html#msg19764 ).
I tried to do this also and I have now all the names etc. indeed without links (as I wanted it). But this information is not in the appropriate fields of PVD but all in the field "Comments" ("Kommentare") (see attached picture AVB). So I would have in a next step to transfer the data (by copy and paste) to the appropriate fields (above).

Moreover I conclude from your explanations that I would have to make alle the procedure (to create a txt.file etc.) for every movie separately, as you write:

Repeat the last part of every movie and so you will have almost all the information in your PVD Movie Database, whatever you find there is a need to manually enter the PVD Movie Database or simply movie.txt file these data for a particular movie does not contain.

That's a lot of work (compared to copy and paste directly from my original Word doc to the original fields in PVD).  :-\

So I think that at least for the time being I will remain to use PVD in its "normal" way and I will try to "live" with all the hyperlinks in the names. Perhaps some other time in the future I will try again to work with your script.

Anyway I appreciate very much your helpfulness and your good explanations. Thanks once more for all the time, work and patience you have invested in order to create the script and to support me in this difficult matter, Ivek23. :)

Maybe in the next time I will come back with some other - smaller ;) -  questions concerning PVD.

10
Support / Re: Can I avoid the links?
« on: August 22, 2016, 01:14:43 pm »
I checked, it's all right as it should be and there are no empty files.

You are right! :) I use TUGZip to unpack zip-files and obviously this program has a problem with 7z files: It unpacks the 7z file but it shows its contents only as empty files with 0 KB! I tried now to unpack with WinRAR and all worked fine. I was also successful in unpacking with TUGZip the zip file you attached now (the result were no 0 KB files but correct files). So there must be a specific problem between TUGZip and 7z files. Sorry that I (or better: TUGZip) caused this confusion.

I changed now the txtinfo_en (0a).psf via Wordpad to a txt file. But what is to do now?

I do not really understand where I have to put the information (let's say about "Director") now. In the txt file? Where exactly there? And where is the place in the PVD folder where I have to put the txt file and the psf file?

11
Support / Re: Can I avoid the links?
« on: August 22, 2016, 02:51:58 am »
Hello Ivek23,

thank you very much for all your work, your efforts and your explanations!

Sorry that I already need more help.  ;)

I downloaded the Movies & Scripts 7z file and unpacked it. With Wordpad I opened the files which are inside (= the three psf.files [txtinfo_en (0a).psf etc.] and the txt files for the individual movies). But all files have size 0 KB and consequently in Wordpad I can see nothing, respectively only a blank white page.

So please can you check again the files you attached within the 7z file? Thanks a lot.

12
Support / Re: Can I avoid the links?
« on: August 14, 2016, 02:54:42 pm »
Thanks for your efforts and the information, Ivek23.  :)

13
Support / Re: Can I avoid the links?
« on: August 13, 2016, 12:52:55 pm »
O.k. I attach an excerpt (about 7 pages) of my Word document with movies.

Relevant concerning the links are the following 5 catgeories. I use (in Word and in PVD) the German language. For better understanding here I mention the corresponding English expressions of PVD too:   

Drehbuch (or sometimes: Buch) = Writer
Regie = Director
Darsteller/innen = Actors
Produktion (or sometimes: Produzent) = Producer
Musik = Composer

I transfer the names of these categories by copy and paste to PVD (where they appear as links).

(There are also some additional fields in PVD which create automatic links [like "Studio"]. But I do not use these fields. Only the 5 mentioned above.)

I hope this helps.  :)

14
Support / Re: Can I avoid the links?
« on: August 12, 2016, 08:49:07 pm »
Thanks for your suggestion, Ivek23. Of course I can send you such a Word document (at least an extract, as the orginal has already over 300 pages). But I doubt if this will help, as the "problem" (the automatic creation of links) also exists when I do not copy and paste something from Word. For example, I can also type a name directly in the field "Actors" of PVD and a link will be created for this name.

15
Support / Re: Can I avoid the links?
« on: August 10, 2016, 07:31:44 pm »
For this it will be very useful Comment box in which you can copy information from Word Document and you have all the information in one box for later viewing such information.
If I put all the information in one field (e.g. the Comment box) I could no longer make use of the structure of PVD: the distinction between actors, director, writer etc. in separate fields. But this structure is one of the reasons that make the software so useful.

When you wrote above:

[...], eligible for such action may come only a script, where it can invoke the information is transmitted to custom fields.

Does this mean that there could be a solution with a script?

16
Support / Re: Can I avoid the links?
« on: August 10, 2016, 04:19:10 pm »
Hello Ivek23,

thanks for your answer and your support. 

You write:
To better help solve the problem, which plugin or script using and from which pages downloading movie information.

I assume you mean this as a question about how I use the software. In this case the answer is simple: I do not use any plugins or scripts nor do I download any movie information from the Internet. I simply transfer my data about the movies (persons, description, country, year etc.) from a Word document (where I have stored this information until now) by copy and paste. 

17
Support / Re: Can I avoid the links?
« on: August 10, 2016, 10:45:47 am »
Hello afrocuban,

thanks for your reply. Yes, by reading a little bit in the forum I saw that PVD is not actively developed at the moment. I thought that possibly Ivek23 or other members of the forum might have an idea how it could work to "get rid of" the links. (The same applies to some other questions that perhaps I will post later on.)

18
Support / Can I avoid the links?
« on: August 07, 2016, 02:02:19 pm »
Hello!

Of course the first words I have to say are: Many thanks for this excellent software! During the last days I have tried various applications for organizing my movies, and Personal Video Database was by far the best one for me. It is very easy and comfortable to use and the appearance of the data looks great.

In a certain respect PVD offers even too much features for my needs.  ;) Whenever a name is written into fields like "Actors", "Director", "Writer" etc. a link is automatically created. As I do not use these links at all, it would be fine if their creation could be avoided or if at least they could be deleted afterwards (so that the names can be seen in the field simply with their letters). Exists such a possibility?

Thanks in advance for your reply.

Pages: [1]