| T O P I C R E V I E W |
| Michael Clarke |
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 |
| 20 L A T E S T R E P L I E S (Newest First) |
| Prinz |
Posted - 27 Jun 2012 : 10:26:04
All the Problems would be solved with my design. Of course the MoviePersons Table has to include additional fields: Role, Description and Picture at least. |
| JDommi |
Posted - 27 Jun 2012 : 09:22:30
Another thing to think about is when the director is an actor in the same movie. And in some movies the director is an actor and the (co-)producer. |
| Michael Clarke |
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. |
| Masonic |
Posted - 26 Jun 2012 : 06:57:10
Ohh i love this idea, cant wait to see the final look!! |
| Prinz |
Posted - 24 Jun 2012 : 13:01:08
My Example is of course incomplete. Some Tables have to include more Fields. |
| Mawu |
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 |
| Prinz |
Posted - 23 Jun 2012 : 19:06:51
I would say something Profession neutral...
Just a Example:
 |
| Odin |
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) |
| JDommi |
Posted - 22 Jun 2012 : 12:13:00
Well. Then you should include some of the plugin functions directly into your code, Ale 
|
| Alessio Viti |
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 |
| JDommi |
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? |
| Alessio Viti |
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 |
| Michael Clarke |
Posted - 21 Jun 2012 : 21:12:45
Thanks Prinz at least I know, the question was worth asking |
| Prinz |
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 |
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. |
| JDommi |
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. |
| JDommi |
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. |
| Michael Clarke |
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 |
Posted - 20 Jun 2012 : 11:35:54
Corrected version is now available under same link: http://dl.dropbox.com/u/77430248/Actors.rar |
| JDommi |
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. |
