| Message |
Details |
Quoting mediadogg:
Quote:
Oh yes, nothing hard to do there.
Let me confirm:
You say you would like to get a fake profile with all cast and crew with no BY. This is easy to create. You don't need to do anything but click "Go". I can create the fake profile, by using the next available manual profile ID in your database.
Next, all I need to do is add every cast and crew to the fake profile by first setting entry BY (to "0" or null?) and add to the fake profile if not already there. If I use your filter idea, you will be missing some cast and crew - the entries that originally have no BY.
So, which do you want: the fake profile with all cast and crew and no BY set, or only the ones which originally had BY set?
Either way will have the same cast and crew entries in the database, it just affects which cast and crew get assigned to the fake profile.
And last question is how do you want to handle "credited as"? Do you want a checkbox, or always handle it the same way?
Sorry one more question: do you want me to access the set of accepted BY and fix any that are incorrect while scanning?
Quoting mediadogg:
Quote:
If you think we are converging on an idea, I will be using a "SubPlugin". This is a piece of code that is very easy to install and update, and much easer for me to code, test and maintain than a regular plugin.
But there is a catch. All subplugins are hosted by a master plugin called DVDPFauxAPI. This is installed only once and never again unless a bug fix is needed. From then on, you can run any and all subplugins simply by copying one file into a specific folder.
So, before I start writing code, please verify that you can install DVDPFauxAPI plugin. It does nothing until you copy a subplugin file, which is automatically recognized and run. Easy. You can disable it and re-enable it the normal way, using Tools>View Plugins.
Let me know if I am on the right track.
Quoting mediadogg:
Quote:
Oh I see now, I don't think my BY checking males sense. I would only be able to delete the cast or crew entry if the BY was not found in the accepted list. And to do that, I would first have to remove the entry from every profile that used it. Way too much work and risk I think. Profiler does not allow removing a cast or crew entry that is being used, or the program would crash.
These are the unanswered comments / questions. I have some time today and in the mood to play with some code. | Posted: Topic Replies: 168, Topic Views: 10418 |
 |
And since I am working on the tool, it would be interesting to focus on my comments and questions. However if the xml export works for you, then my tool is not needed. Let me know as soon as possible.
Oh by the way, I see DJ is on the scene. I am happy to defer if you would like to write the tool. Maybe a nice addition to the Find Name Duplicates tool? | Posted: Topic Replies: 168, Topic Views: 10418 |
|
| Oh I see now, I don't think my BY checking males sense. I would only be able to delete the cast or crew entry if the BY was not found in the accepted list. And to do that, I would first have to remove the entry from every profile that used it. Way too much work and risk I think. Profiler does not allow removing a cast or crew entry that is being used, or the program would crash. | Posted: Topic Replies: 168, Topic Views: 10418 |
|
If you think we are converging on an idea, I will be using a "SubPlugin". This is a piece of code that is very easy to install and update, and much easer for me to code, test and maintain than a regular plugin.
But there is a catch. All subplugins are hosted by a master plugin called DVDPFauxAPI. This is installed only once and never again unless a bug fix is needed. From then on, you can run any and all subplugins simply by copying one file into a specific folder.
So, before I start writing code, please verify that you can install DVDPFauxAPI plugin. It does nothing until you copy a subplugin file, which is automatically recognized and run. Easy. You can disable it and re-enable it the normal way, using Tools>View Plugins.
Let me know if I am on the right track. | Posted: Topic Replies: 168, Topic Views: 10418 |
|
Oh yes, nothing hard to do there.
Let me confirm:
You say you would like to get a fake profile with all cast and crew with no BY. This is easy to create. You don't need to do anything but click "Go". I can create the fake profile, by using the next available manual profile ID in your database.
Next, all I need to do is add every cast and crew to the fake profile by first setting entry BY (to "0" or null?) and add to the fake profile if not already there. If I use your filter idea, you will be missing some cast and crew - the entries that originally have no BY.
So, which do you want: the fake profile with all cast and crew and no BY set, or only the ones which originally had BY set?
Either way will have the same cast and crew entries in the database, it just affects which cast and crew get assigned to the fake profile.
And last question is how do you want to handle "credited as"? Do you want a checkbox, or always handle it the same way?
Sorry one more question: do you want me to access the set of accepted BY and fix any that are incorrect while scanning? | Posted: Topic Replies: 168, Topic Views: 10418 |
|
Quoting Magmadrag:
Quote:
Quoting GSyren:
Quote:
So yeah, it's just a listing. If it's no help at all, then sorry!
Well, I wanted to try... but I can't! I would need to export my (whole) collection to xml and export doesn't work anymore. It runs and runs... and at about 99 % the Error-Popup comes... I got an xml but with Zero KB size. So in this case I got no chance to try it.
Is there any chance that the tool opens the "Actors"-File in the programm folder (no idea if the DAT or the IDX is relevant) but this would avoid (the for me impossible) export
Maybe consider the possibility of testing the idea with less than the full export? One step at a time. | Posted: Topic Replies: 168, Topic Views: 10418 |
|
Have you looked at DJ Doena tool Find Name Duplicates?
What does the tool you envision need to do beyond that? Maybe something can be built on top of that one. | Posted: Topic Replies: 168, Topic Views: 10418 |
|
Well if you are not interested in my recent comments, I will move on. Gunnar by choice does not write plugins. I do. When / if you decide the exported XML approach does not work, maybe you can take a look at my idea and give me your comments.
By the way, even the API does not have the ability to open the Actors file. I mentioned that I would double check, and I did. If you would like to continue helping understand what you need, I think I know how to write the code. | Posted: Topic Replies: 168, Topic Views: 10418 |
|
Another idea would be a tool that would show the reverse relationship between cast and crew. Click on a name_BY, and get a listing of all profiles with that name_BY. Then what would you want to do?
Or suppose you click on a name_BY and there are no profiles associated? What would you want to do?
Would you want the list of approved BYs to be involved in these tools somehow? If so, how? | Posted: Topic Replies: 168, Topic Views: 10418 |
|
I need to re-read this thread a few more times. The example was perfect. I know the problem is not profile specific, but the tool needs to scan profiles to get to cast and crew, so that's why the example makes sense.
Actually let me take a look at the API more carefully, and see if there is a sneaky way to access the Cast and Crew tables globally by scanning those tables instead of profiles. If so, would that work?
If not, I think I can envision a magic trick:
(1) Scan all profiles and create a dictionary of cast and crew entries.
(2) Scan the dictionary and look for the cases in your example
(3) Using a dummy profile, add the required cast and crew entry, saving the profile each time
(4) When done, delete the dummy profile. The cast and crew entries should remain defined, even though unused the moment.
I will mess around with this someday soon. | Posted: Topic Replies: 168, Topic Views: 10418 |
|
Quoting GSyren:
Quote:
I was asked by mediadogg if I could write a graphical user interface for CommandOnEvent, so I did:
CommandOnEventGUI 1.0
And I love it! Thanks Gunnar! | Posted: Topic Replies: 7, Topic Views: 4888 |
|
I have read your description of what this tool would need to do, several times and still don't get it.
Would you mind giving an example or two, using data from existing profiles? | Posted: Topic Replies: 168, Topic Views: 10418 |
|
Quoting Magmadrag:
Quote:
@mediadogg: Would you be so kind and give me a link for CLTBoss?
And: Your second post I am absolutely unable to understand.
There are several tools available which can do this and that. A read several descriptions but was not able to find THAT function I (and in my opinion: all users) would need to have. So I started this thread especially for programmers like you who know their tools much better as any description could be.
As I have given up the hope for any update in close future, I try to solve a problem of an extraorginary size.
Just for your imagination: I am not done with letter B of the BY-List (http://www.luigifilocamo.it/BY.html) and had to correct actors in more than 100 profiles. Only a few of them are wrong in the central database, but the rest got wrong by download as I didn't have actors w/o birthyear. Until I am done with the complete list it might last months. And especially then I want to avoid that such mistakes become part of my local database again.
Somehow I thought I made CLTBoss for you. My bad. Read about it here:
http://www.invelos.com/Forums.aspx?task=viewtopic&topicID=1003379&PageNum=1 | Posted: Topic Replies: 168, Topic Views: 10418 |
|
| For example if you load the profile list with the profiles from your database and the set the variants table to a pair of entries, one with and one without the BY and do the scan. Maybe something like that ... | Posted: Topic Replies: 168, Topic Views: 10418 |
|
Have you checked to see whether existing tools could be of help, and then you would have a bit of work of still left to do?
For example CLTBoss?
DJDoena's tools?
It is late in the day here, so I will need to re-read your explanation again in the morning. | Posted: Topic Replies: 168, Topic Views: 10418 |
|
Guys the website server apparently crashed. It was restored from whatever point in time the backup was. Nothing mystical. Just be glad it wasn't worse. Whomever is watching will definitely benefit from your detailed descriptions of what is messed up, so keep it coming, but also keep in perspective what likely happened.
FYI there is a new plugin out there DVDPFauxAPI and a companion sub-plugin CommandOnEvent that can be easily setup to keep a running log of each time a profile is refreshed from the online or edited locally.
I can probably figure out a way to save the corresponding copies of the profile if you want me to try that. | Posted: Topic Replies: 8, Topic Views: 6068 |
|