Welcome to the Invelos forums. Please read the forum rules before posting.

Read access to our public forums is open to everyone. To post messages, a free registration is required.

If you have an Invelos account, sign in to post.

Invelos Forums->Posts by mediadogg Page: 1 2 3 ...11  Previous   Next
Message Details
A corrupted profile can definitely gum up the works. I am assuming you are well aware of DB Repair. So, I'm sure you have done that. Do a Full Repair. Once done, do a database backup, which I am sure you have already done.

Now:

(1) Open a new clean database
(2) Restore your best backup into it
(3) Backup
(4) Run DB Repair
(5) Backup again

You should have a gloriously clean and functioning database at this point.
Posted:
Topic Replies: 13, Topic Views: 547
Just seeing this thread. Yes, I get 3D sometimes. I have 2 LG TV's with 3D and an Epson projector. Main problem I have with 3D is that by definition you lose brightness because you have a shutter that is distributing energy from the LED between alternating stereoscopic views that you watch thru polarized or shuttered glasses. But you have been watching your brilliant 2D images for days, weeks or months, and then when you switch to 3D, you notice. Mainly psychological, but a real effect.
Posted:
Topic Replies: 9, Topic Views: 374
Quoting surfeur51:
Quote:
Quoting Jimmy S:
Quote:

As long as it works offline I don't see the problem as I do all my profiles from scratch since everything is done the way I want it to be done...

Dead or not, I haven't find anything better for my collection...

+1

Me too. You know, there is nothing to stop a community of people from contributing to and sharing profiles. Ken Cole, in his creative glory provided a bunch of ways to do it, plus enablers to allow extensions:

(1) There could be a cloud copy of DVD Profiler running on a windows server hosted by somebody that would allow a limited number of users to connect and download profiles. People would have to be civil and connect just long enough to get what they need.
(2) There is exported XML
(3) There is database backup / restore (already used to support the headshots DB)
(4) There are profile digital files
(5) There is phpProfiler, which is enabled by a well documented model (maybe inadequate, but we know exactly what it is)
(6) There are plugins - we have a bunch, but they just scratch the surface of what Ken has enabled them to do. Of course, we could only use the aspects that do not rely on the online connection.

Nothing says we have to try and replicate 100'000s of the existing database. Start from now, and move forward. As approved profile updates come along, add them. That could be a start. As an aggregate group, the community probably has a large percentage of the profiles that a new user would need. We could find a way to index a consolidated view of all collections (by permission) and have a way to request profiles not in the server.

Keep an open mind. What more wonderful legacy for a guy to have, than to have provided a platform with so many enablers that remain to be unique and world class, even after a long period of no updates.

And of course, as I have mentioned before, there is nothing to stop anybody from contacting Ken and /or his family to put some kind of deal on the table: offer him some money in return for a license to use the online API and the contributions infrastructure. That would be a start, and perhaps a way to help fund the web site while Invelos recovers from whatever is going on. The absolute biggest risk we face, is the web site shutting down. I would definitely lay down some bucks to help keep that from happening.
Posted:
Topic Replies: 96, Topic Views: 10225
What a shame. The clash I was hoping for, was one of great minds over the schema structure, not over egos. Was really looking forward to that. I don't have the skills - you guys do ... 
Posted:
Topic Replies: 40, Topic Views: 693
Three mighty warriors. Let the games begin and a schema emerge!!! 
Posted:
Topic Replies: 40, Topic Views: 693
Ooo ... clash of the Titans ... yum.
Posted:
Topic Replies: 40, Topic Views: 693
Great insight and much appreciated!!!!
Posted:
Topic Replies: 40, Topic Views: 693
Quoting movie_madness:
Quote:
In database lingo, the re-design needs to accommodate more "one-to-many" relationships (anyone who has database experience knows what that means).  The current database structure doesn't have the "many" relationship for things like countries, media companies, and screenshots, and that is why you can't have a disc linked to unlimited countries, companies, pictures, etc.  And you will never be able to do that UNTIL the database structure is re-designed to accommodate such one-to-many relationships.  A re-design after the fact would be difficult and may even be impossible.  That was why I designed my own.

It would be great to see the "ideal" schema for a DVDP database re-design. Out of curiosity, in your opinion, could some of the aspects of a many-to-one relationship for the fields in question be simulated by using hidden child profiles using custom profileIDs?
Posted:
Topic Replies: 40, Topic Views: 693
Quoting GSyren:
Quote:

... The "pipe dream" was to create a desktop program that rivals DVD Profiler's user functionality, including customization.
... you haven't even scratched the surface of the problems involved in replicating all Profiler's features. It can't be done in ASP.

Wow, those words made me reflect on how much we miss the creative genius of Ken Cole, and how much we still enjoy the results of his efforts. I, for one, am grateful to whomever it is that is allowing this Forum to proceed in his absence, and wish him and his family well. Sorry for the off-topic. Just got a little misty-eyed, that's all. 
Posted:
Topic Replies: 40, Topic Views: 693
Quoting marcelb7:
Quote:
Quoting AiAustria:
Quote:
Back on topic: Credit Lookup Plus

Did anyone manage to run this very handy piece of software under Windows 10?

... or is there any other tool to get information out of the CLT tool?

Still working for me! 

Hey that's great! Maybe share your setup - which browser, and "compatibility" settings, or anything else you think might be contributing to your success where others have failed? I will probably still continue with my project, but I'm sure some people would love to continue using that program, although apparently the author doesn't want it being used. But that is a decision that each person makes for themselves.
Posted:
Topic Replies: 93, Topic Views: 11007
Darn it, seems like some stuff you can't do anymore - at least not easily. Might have to resort to AutoIt to press a few keys. I'm not the only one. Seems others are having the same problem pressing keys inside a modern browser these days. They seem to now require an actual UI action. I'll  keep plugging away. I'd like to avoid AutoIt if I can, but I've used it before and it does work well.
Posted:
Topic Replies: 93, Topic Views: 11007
Quoting AiAustria:
Quote:
Quoting zappman:
Quote:
The third type of collection I would like  to track is my books.

... off toipic...

I really apreceate Calibre for my books, no matter which format. A few custom fields and it work like charm for anything around books. The only anoyance from my point of view: no headshots for authors.

... but I am Windows centered...

Here is an old thread about books.

Pictures have been lost, but here was the process of making a wine "skin."

A Book Profiler - pictures are lost in the post. Maybe contact that user?

Oh wait, Gunnar, maybe that is one of the coolest features yet, and right down your alley - the notion of "skins" for UI and nomenclature customization??? Combine that with the filter / query of Profiler Query and you are closing in on a "profile anything"?
Posted:
Topic Replies: 40, Topic Views: 693
Quoting GSyren:
Quote:
Quoting mreeder50:
Quote:
I completely agree with removing the Other crap and having all languages and subtitle languages available including "country specific" Audio Descriptive, Audio Tracks and Subtitle Tracks.
Yeah, I would think that configurable lists of countries and languages would be nice. And since you mentioned audio tracks, I would like to be able to enter who's doing commentaries.

Actually, not having to relate to a common online database would mean less demands on compatability, so one could allow free text in the audio content field, like "Commentary by Bey Logan", rather than just "Commentary".

Whoa, careful! "Common Online" is not the culprit. It is the fact that people want to share profiles, and / or the metadata they contain. Otherwise, each person could design their own open, free-form data structure and store it in an Excel spreadsheet, and share it by sending a drop box link to the "online" CSV file for others to figure out.

Meanwhile, anyone who wants to add custom data and fields to existing profiles can do it today simply by:

(1) Custom fields supported by several plugins
(2) HTML app running inside notes (notes HTML option)
(3) HTML window app (might need a simple plugin to allow saving of json or other format into Notes)

My recommendation for anybody looking to undertake the development of a new program - standalone or not, FIRST attempt to get consensus on a common data model. Maybe even establish a forum / web site to support it. Then regardless of what happens, people will be able to still share, develop mobile apps, define transformations between other models and the "common" one, establish an online repository for those who want it.

To me. the real value comes from the ability to share and collaborate. IMHO, a standalone effort will be doomed as soon as (or if) we loose this free platform to talk about it (unless of course replaced by something else).
Posted:
Topic Replies: 40, Topic Views: 693
Quoting GSyren:
Quote:
Quoting mediadogg:
Quote:
In that context, I have always dreamed of having a way to focus more on the artists.

Interesting! How would you envision that implemented? Would you be satisfied with a notes field plus links to external sites, or would you require some kind of structured data (to make it easier to search, perhaps?)

Oh man, please don't do any work on this!!!!    OMG I am not worth the effort. Please, any of your efforts focus on those guys who are the backbone of DVDP - the contributors!

But, following along just as a thought experiment, what I am thinking of goes way beyond a notes field. There was a thread a while back where somebody mentioned a site. I'll try to find it.  For example, often performers are members of groups prior to going solo. And they move around. So, who were the "XXX Band" in 1963? Or what groups did "Molly Milly" sing in from 2001 - 2008? Who were the members of Morning Musume in 2003? What bands did "Davey Drummer" play with before going solo in 1987?

Ability to save lots of pics and head shots. Links to and notes about trivia. Celebrity parent / sibling / spouse linkages. Stuff like that. Obviously there are tons of web sites devoted to that stuff. But it would be fun to keep tarck of a few of my favorites in the context of the movies or other media they have been a part of.
Posted:
Topic Replies: 40, Topic Views: 693
Quoting GSyren:
Quote:
Sometimes I get the notion that I could write my own Profiler. Then of course I realize that without an online collection it would be no match. But what if Invelos shuts down its servers? Well, you could still use DVD Profiler, of course. But it would lose that advantage.

Ok, I see now your premise: if you are stuck with stand-alone, what would be a better one than using Profiler ...

In that context, I have always dreamed of having a way to focus more on the artists. I have a fascination with artists: singers, dancers, actors, etc. I like to read the bios, keep up with what they are doing, and how they are progressing in their careers, especially young up and coming stars. It is fun to watch them grow in talent and accomplishments. So, yeah, some cool features that allows a focus on the artist - pictures, awards, family life, gossip - you name it, I want it!!! Case in point, your countryman, Alicia Vikander, what a stunning resume for somebody so young!
Posted:
Topic Replies: 40, Topic Views: 693
Quoting zappman:
Quote:
Quoting GSyren:
Quote:
Quoting zappman:
Quote:
The thing I would most is to be able to track my Video Game collection. I would like to have the program manage / keep a separate database of the video games, I would like to the video games to have their own collection numbers. Currently I use https://vgcollect.com/ to track my video games , it has a nice on-line database, but there is no stand alone program. It can export your collection (I can't remember if the the export is in CSV or XML format.)


What steps do I need to do, to start a separate database for my video games, that will have different collection numbers from my movie collection?

I want it  to be totally separate form my DVD collection.

There are a couple of users that have done this - way long ago. Try a forum search with "video games" or similar. Maybe you can find those old posts.
Posted:
Topic Replies: 40, Topic Views: 693
Along the lines of my prior post, I have long wondered:

- would Invelos be willing to license / sell its technology (or even the company?)
- would Invelos be willing to offer a small financial interest to a set of dedicated users with the skills to augment program updates, website and database maintenance, support, forum moderation, etc.
- are there any users who would want to do any of the above?

The list of product features I made, IMHO would take an enormous effort in time and resources to duplicate or improve upon in a reasonable time frame. Think of the multi-million dollar companies that have not built a "better" version in all these years.

I would prefer to find a way to preserve what we have, vs. making an attempt to duplicate or compete with it.
Posted:
Topic Replies: 40, Topic Views: 693
I'm not sure how typical I am of Profiler users, but the greatest features for me are:

(1) the collaborative attention to the building of accurate and useful profile information
(2) the ability to almost effortlessly download information for a newly obtained DVD
(3) the ability to integrate other aspects of the media such as trailers, reviews, cast / crew info, and the movies themselves
(4) a collaborative forum for sharing information and ideas
(5) ability to customize the program via layouts, custom views, HTML windows, docking windows
(6) ability to use filters and create reports
(7) ability to augment the functionality via plugins
(8) cross platform sharing on Android and iOS
(9) cross platform client / server operations using a windows based server

None of the things that you mentioned would be important enough to me personally to switch from simply using DVD Profiler itself as a standalone program, even if I had to write my own plugin for "cloud" operations.

The very useful notion of separating film data from product data could possibly be accomplished by use of the custom and alternate profile IDs which were created partly to allow people to implement a different concept of metadata organization.

If you were to invest your formidable skills towards preserving the legacy of accurate metadata and collaboration among dedicated individuals, I would vote for a forum / online to pick up the slack in case of that awful event you mentioned. Having a better standalone, IMHO, does not address the greatest risk of losing Invelos - it is the risk of losing the value of collaboration and customization.
Posted:
Topic Replies: 40, Topic Views: 693
Scraping did turn out to be relatively easy. Just a bit of a snag getting the page turning logic smoothed out. Once I nail that, I will have a list of UPCs that I can run through the API, which has an "all localities" option, so I don't need to scrape the localities which would be a real pain. At that point I will have the complete list of ProfileIDs from which to request download of the XML for export.
Posted:
Topic Replies: 93, Topic Views: 11007
Ok, here is my compromise:

I tried to make as much as possible identical to Profiler XML, except the credits info is formatted to make it super easy to parse for you and not force you to redo the work of parsing dividers and episode markers. Any other DVD Info that you want / need, of course I can add that easily to the export.

Quote:

<?xml version="1.0" encoding="windows-1252"?>
<!-- Credit Information Export (c) 2019 mediadogg Software -->
<CLTInfo>
<DVD>
  <ID>5051889528654.8</ID>
  <ID_Base>5051889528654</ID_Base>
  <ID_LocalityID>8</ID_LocalityID>
  <ID_LocalityDesc>France</ID_LocalityDesc>
  <Title>Black Storm</Title>
  <OriginalTitle>Into the Storm</OriginalTitle>
  <ProductionYear>2014</ProductionYear>
  <CLTCredits>
    <CLTCredit type ="crew" Episode="" GroupName="Visual Effects by [Hy*Drau&quot;Lx]" FirstName="Will" MiddleName="" LastName="Wallace" BirthYear="0" CreditType="crew" CreditedAs="" Role="Visual Effects" Voice="False" Uncredited="False" Puppeteer="False"/>
  </CLTCredits>
</DVD>
<DVD>
  <ID>723952078414</ID>
  <ID_Base>723952078414</ID_Base>
  <ID_LocalityID>0</ID_LocalityID>
  <ID_LocalityDesc>United States</ID_LocalityDesc>
  <Title>Rock Slyde Private Eye</Title>
  <OriginalTitle></OriginalTitle>
  <ProductionYear>2009</ProductionYear>
  <CLTCredits>
    <CLTCredit type ="cast" Episode="" GroupName="" FirstName="Will" MiddleName="" LastName="Wallace" BirthYear="0" CreditType="cast" CreditedAs="" Role="Steve Bookerson" Voice="False" Uncredited="False" Puppeteer="False"/>
    <CLTCredit type ="crew" Episode="" GroupName="" FirstName="Will" MiddleName="" LastName="Wallace" BirthYear="0" CreditType="crew" CreditedAs="" Role="Producer" Voice="False" Uncredited="False" Puppeteer="False"/>
  </CLTCredits>
</DVD>
<DVD>
  <ID>8712626073345.30</ID>
  <ID_Base>8712626073345</ID_Base>
  <ID_LocalityID>30</ID_LocalityID>
  <ID_LocalityDesc>Belgium</ID_LocalityDesc>
  <Title>Ash vs Evil Dead: Seizoen 3</Title>
  <OriginalTitle></OriginalTitle>
  <ProductionYear>2018</ProductionYear>
  <CLTCredits>
    <CLTCredit type ="cast" Episode="4. Unfinished Business" GroupName="" FirstName="Will" MiddleName="" LastName="Wallace" BirthYear="1971" CreditType="cast" CreditedAs="" Role="Gary" Voice="False" Uncredited="False" Puppeteer="False"/>
    <CLTCredit type ="cast" Episode="6. Tales from the Rift" GroupName="" FirstName="Will" MiddleName="" LastName="Wallace" BirthYear="1971" CreditType="cast" CreditedAs="" Role="Gary" Voice="False" Uncredited="False" Puppeteer="False"/>
  </CLTCredits>
</DVD>
</CLTInfo>

Posted:
Topic Replies: 93, Topic Views: 11007
Quoting GSyren:
Quote:
I like it! But ...

Wouldn't it be better if you used the same terminology as Profiler's XML?
For example ID, ID_Base, ID_LocalityID and ID_LocalityDesc.
And <Credit> is Crew is Profiler's XML. And so on.

The closer you can make it to Profiler's XML, the less chance of confusion.

Just my two cents.

You got it! Now is the time when changes are easiest, and that is certainly most reasonable. I will make it as close as possible.
Posted:
Topic Replies: 93, Topic Views: 11007
Hot Dog! Figured out the scraping. Now just some brute force coding to put in the page loops and grab the profile IDs. Got a family function to attend over the weekend, but hopefully by early next week I'll have something in beta to mess with. Fun!
Posted:
Topic Replies: 93, Topic Views: 11007
Ok, I did find that I was forcing lower case, so I fixed that, and the missing closing bracket. I also added the credit type flag and reworked my divider handling. I tested a few profiles by relaxing the actor match and pulled the entire cast / crew XML and checked against the downloaded profiles. I think I've got it.

Here is a sample:
Quote:

<?xml version="1.0" encoding="ISO-8859-1"?>
<!-- Credit Information Export (c) 2019 mediadogg Software -->
<CLTInfo>
<Credit type="cast">
<Firstname>Will</Firstname>
<Middlename/>
<Lastname>Wallace</Lastname>
<Creditas/>
<Episode/>
<Groupname/>
<ProfileID>723952078414</ProfileID>
<ProfileIDBase>723952078414</ProfileIDBase>
<Locality>0</Locality>
<Localitystring>United States</Localitystring>
<Title>Rock Slyde Private Eye</Title>
<Originaltitle/>
<Productionyear>2009</Productionyear>
<Rolename>Steve Bookerson</Rolename>
<Puppeteer>False</Puppeteer>
<Uncredited>False</Uncredited>
<Voice>False</Voice>
</Credit>
<Credit type="crew">
<Firstname>Will</Firstname>
<Middlename/>
<Lastname>Wallace</Lastname>
<Creditas/>
<Episode/>
<Groupname/>
<ProfileID>723952078414</ProfileID>
<ProfileIDBase>723952078414</ProfileIDBase>
<Locality>0</Locality>
<Localitystring>United States</Localitystring>
<Title>Rock Slyde Private Eye</Title>
<Originaltitle/>
<Productionyear>2009</Productionyear>
<Rolename>Producer</Rolename>
<Puppeteer>False</Puppeteer>
<Uncredited>False</Uncredited>
<Voice>False</Voice>
</Credit>
</CLTInfo>


This was cut and pasted from MS Edge, so I guess it changes the codepage. My original is the expected 1252 that Profiler uses.

Still working on the scraping.

Not to be presumptuous, but Gunnar, how does that XML format look to you, should we be so lucky to have you do the advanced stuff? I am thinking you might benefit from a bit more structure, such as <DVD></DVD> elements?
Posted:
Topic Replies: 93, Topic Views: 11007
Quoting AiAustria:
Quote:
Quoting mediadogg:
Quote:
Good point about Cast vs. Crew. would you prefer an attribute, or grouping?

If it is no effort a flag would be fine...


So you will prefer:

(1)
<Credit>
  <CreditType>Crew</CreditType>
  ...
</Credit>

or (2)

<Credit type="crew">
  ...
</Credit>

or (3)

<CastCredits>
  <Credit></<Credit>
  ...
</CastCredits>

<CrewCredits>
  <Credit></Credit>
  ....
</CrewCredits>

or (4)

<CastCredit>
...
</CastCredit>

....

<CrewCredit>
...
</CrewCredit>


Or, some combination? Not much difference in the work effort. Just formatting.
Posted:
Topic Replies: 93, Topic Views: 11007
Ah, thanks. I didn't understand how to use the END divider.

I will check about the case of locality. I believe I'm grabbing it as supplied, but I will double check. This info is coming down directly from the Online, so it might well be formatted differently from the PC program. When I get time, I might do a comparison.

Good point about Cast vs. Crew. would you prefer an attribute, or grouping?
Posted:
Topic Replies: 93, Topic Views: 11007
Invelos Forums->Posts by mediadogg Page: 1 2 3 ...11  Previous   Next