| Author |
 Topic  |
|
|
Michael Clarke
New Member
United Kingdom
84 Posts |
 Posted - 19 Jun 2012 : 00:10:26
|
I've asked this question before so here goes.
The Directors are always imported into the Actors database along with the Actors as requested by the script.
When selecting the CREW of a film, then the director, the info will show correctly for that director except for the Movies in Database which is greyed out. The problem is that when I tidy up the actors database by using the plugin "Actors Cleaning" this shows the last column as "Actors without any movie". All the column's are clear except this one, which lists all the directors (1280 of them) plus a few actors. I could go through them all to select the actors, but with 1800 films this is not a good option.
Now if Directors could be linked to the films they have Directed within my database, then they would not show in that last column, and the tool would be more useful.
It would also enable me to list a Director, and see all the films that he has Directed that might be in my collection.
I hope I have explained this OK....Thanks |
|
|
JDommi
Administrator
Germany
4644 Posts |
Posted - 19 Jun 2012 : 10:55:47
|
New release of "Actors Cleaning" http://dl.dropbox.com/u/77430248/Actors.rar
Haven't tested it yet but the tool should now observe the directors, too.
Please check it and report any error, thanks. |
In order to achieve what is possible, you have to try the impossible over and over again.
Hermann Hesse |
 |
|
|
Michael Clarke
New Member
United Kingdom
84 Posts |
Posted - 19 Jun 2012 : 19:18:40
|
| Thanks JDommi tried this and it appears to work OK. Now that it seems to give me a list of Actors without Movies I'll go through some of the list and check them in the database. Let you know how it goes later when I have time |
|
|
|
JDommi
Administrator
Germany
4644 Posts |
Posted - 19 Jun 2012 : 20:22:58
|
| Okay, but one User has reported a bug. I assume tghat I have forgotten to check the new list against no director entries. But I have to check that tomorrow before work. |
In order to achieve what is possible, you have to try the impossible over and over again.
Hermann Hesse |
|
|
|
JDommi
Administrator
Germany
4644 Posts |
Posted - 20 Jun 2012 : 11:35:54
|
| Corrected version is now available under same link: http://dl.dropbox.com/u/77430248/Actors.rar |
In order to achieve what is possible, you have to try the impossible over and over again.
Hermann Hesse |
|
|
|
Michael Clarke
New Member
United Kingdom
84 Posts |
Posted - 20 Jun 2012 : 18:44:29
|
That version works great, even picks up on the database used, it's now a very useful tool. Just need to get the directors into the Directors table instead of mixing them with the Actors. Also if more than one Director, then split the link in the HTML sheet
Thanks |
|
|
|
JDommi
Administrator
Germany
4644 Posts |
Posted - 20 Jun 2012 : 19:25:30
|
Do you mean as additional feature for the CleanActors?
I don't think that this table is used in XMM. But that would make no big problems to realize. |
In order to achieve what is possible, you have to try the impossible over and over again.
Hermann Hesse |
|
|
|
JDommi
Administrator
Germany
4644 Posts |
Posted - 21 Jun 2012 : 11:36:31
|
As splitting directors from actors table would implement a change in XMM I have add the possibility to append each director to the Actors table.
Same could be done for as example the producers, too. But I think that the directors are enough.
Please check if all works fine.
I have tested it without problems on 2 different databases.
By checking the directors I have found a bug in XMM itself: As the Directors field in the database is a text field it's length is restricted to 255 and so if you have multiple directors these names can be cut at the end. |
In order to achieve what is possible, you have to try the impossible over and over again.
Hermann Hesse |
|
|
|
Michael Clarke
New Member
United Kingdom
84 Posts |
Posted - 21 Jun 2012 : 18:45:00
|
I did at one point split the directors from the actors and built the table "Directors" with the same structure. I then looked at making the HTML card look for the directors table rather than the actors table, but this is where I got stuck. My HTML knowledge is not good. I have just marked this as an unfinished project and I'm sure I'll go back to it.
More than one director for a film is not a major problem but the HTML Card does not see it as a link because of the separator I presume. The IMDB script adds multiple directors as separate people OK as far as I can tell. |
|
|
|
Prinz
Senior Member
Germany
1522 Posts |
Posted - 21 Jun 2012 : 19:10:45
|
quote:
Originally posted by Michael Clarke
I then looked at making the HTML card look for the directors table rather than the actors table, but this is where I got stuck.
Not possible. You only have access to variables that are programmed into XMM and are written in the HTML File.
I would seriously advice Ale against to ever use the Directors etc. Tables in the Database. This would only increase the Problems. There is a far better way to organize a Persons Table with some linked Sub-Tables for all Professions at once, but that would require some low-level changes to the handling for Actors,... in XMM. |
|
|
|
Michael Clarke
New Member
United Kingdom
84 Posts |
Posted - 21 Jun 2012 : 21:12:45
|
| Thanks Prinz at least I know, the question was worth asking |
|
|
|
Alessio Viti
Forum Admin
Italy
9171 Posts |
Posted - 22 Jun 2012 : 08:49:48
|
Hello Guys,
You are right, at this time the old database structure is really bad...
I should change it like XMusicM, where there are tables and relationship tables. What do you think?
Of course this is a big change to do, I need to find maybe 2 weeks of intense work to change everything.
Let me know your ideas.
Thank you,
Ale |
http://www.facebook.com/pages/eXtreme-Movie-Manager/47220214342?ref=mf
 |
|
|
|
JDommi
Administrator
Germany
4644 Posts |
Posted - 22 Jun 2012 : 10:40:00
|
In general a really good idea!
I see only one problem: doesn't have to be rewritten all plugins, too? |
In order to achieve what is possible, you have to try the impossible over and over again.
Hermann Hesse |
|
|
|
Alessio Viti
Forum Admin
Italy
9171 Posts |
Posted - 22 Jun 2012 : 11:55:23
|
Yes... I think that many of them has to be rewritten...
I have create a new folder on my PC just this morning, called XMM 8 
XMM should be rewritten in many parts from scratch, starting from database and to UI...
I will let you know... probably I could work intensively on this from the half of july.
Ale |
http://www.facebook.com/pages/eXtreme-Movie-Manager/47220214342?ref=mf
|
|
|
|
JDommi
Administrator
Germany
4644 Posts |
Posted - 22 Jun 2012 : 12:13:00
|
Well. Then you should include some of the plugin functions directly into your code, Ale
|
In order to achieve what is possible, you have to try the impossible over and over again.
Hermann Hesse |
|
|
|
Odin
New Member
Norway
67 Posts |
Posted - 23 Jun 2012 : 14:02:04
|
| I think it's a very good idea to create separate tables for directors/actors. How will the final database design look like? (just being curious) |
|
|
|
Prinz
Senior Member
Germany
1522 Posts |
Posted - 23 Jun 2012 : 19:06:51
|
I would say something Profession neutral...
Just a Example:
 |
|
|
|
Mawu
Senior Member
Germany
1026 Posts |
Posted - 23 Jun 2012 : 19:49:36
|
@Prinz
Your more common approach looks good. Maybe then its possible to integrate all crew members better into the database. At the moment not all can be imported and there are limited ways for search and display.
@Alessi
Are there any plans to integrate the new windows 8 metro style as an alternative gui?
Bye Byte and Happy Coding
Mawu |
www.schlemmerkino.de - Die Nr.1 für filmische Leckereien |
|
|
|
Prinz
Senior Member
Germany
1522 Posts |
Posted - 24 Jun 2012 : 13:01:08
|
| My Example is of course incomplete. Some Tables have to include more Fields. |
|
|
|
Masonic
Starting Member
16 Posts |
Posted - 26 Jun 2012 : 06:57:10
|
| Ohh i love this idea, cant wait to see the final look!! |
|
|
|
Michael Clarke
New Member
United Kingdom
84 Posts |
Posted - 26 Jun 2012 : 23:55:41
|
| One thing to think about when splitting actors and directors tables is that some actors have become directors in later career. An example would be Clint Eastwood who could be entered as a actor with a picture from his acting days and linked to all the films he has acted in, within your collection. Another entry in the directors table with a picture of the older Clint Eastwood, with links to his directed movies within your collection. |
|
|
|
Topic |
|
|
Splitting Actors from Directors