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->DVD Profiler: Plugins Page: 1... 22 23 24 25 26 ...36  Previous   Next
Database Query - Version 3.0 now available
Author Message
DVD Profiler Unlimited RegistrantMark Harrison
I like IMDB
Registered: March 13, 2007
Reputation: Great Rating
United States Posts: 3,321
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionEdit postDirect link to this postReply with quote
I made a small change with Country Of Origin.  Korea is now South Korea to match the main program.  I also added Iran, Romania and Russia.
Get the CSVExport and Database Query plug-ins here.
Create fake parent profiles to organize your collection.
DVD Profiler Unlimited RegistrantStar Contributorruineddaydreams
Registered: Dec. 2, 2002
Registered: March 14, 2007
United States Posts: 1,339
Posted:
PM this userEmail this userView this user's DVD collectionEdit postDirect link to this postReply with quote
Mark,

    I believe you have doubled the value of your plugin... rouge birthyears are one of my number one pet peaves yet somehow they always wind up in my collection... i suspect due to headshot imports and possibly the online db... i don't fully trust it to pass things through properly. this allows me to check for them periodically and remove.
-JoN
DVD Profiler Unlimited Registrantjmbox
Registered: April 14, 2007
United Kingdom Posts: 415
Posted:
PM this userVisit this user's homepageView this user's DVD collectionEdit postDirect link to this postReply with quote
The initial BY list, or reloading from Invelos, does not include John Barry (1935)

Presumably because he is listed as John Barry (1935 - 1979) in the thread...

And I agree with Muckl on the wording. I have difficulty reading it the way you see it.

Great addition though! 
DVD Profiler Unlimited RegistrantStar Contributorruineddaydreams
Registered: Dec. 2, 2002
Registered: March 14, 2007
United States Posts: 1,339
Posted:
PM this userEmail this userView this user's DVD collectionEdit postDirect link to this postReply with quote
Quoting jmbox:
Quote:
The initial BY list, or reloading from Invelos, does not include John Barry (1935)

Presumably because he is listed as John Barry (1935 - 1979) in the thread...

And I agree with Muckl on the wording. I have difficulty reading it the way you see it.

Great addition though! 


Same thing with Kevin Smith 1963
-JoN
DVD Profiler Unlimited RegistrantMark Harrison
I like IMDB
Registered: March 13, 2007
Reputation: Great Rating
United States Posts: 3,321
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionEdit postDirect link to this postReply with quote
If they're listed in a non-standard format in the Birth Year thread, you can add them manually to the list.  If there are a lot of them, I might be able to put in something to program around them.  But it's always going to be a tough process.  The better approach would be to clean the few entries in that thread I pull the data from.
Get the CSVExport and Database Query plug-ins here.
Create fake parent profiles to organize your collection.
DVD Profiler Unlimited RegistrantMsPaula
Ms Paula
Registered: March 14, 2007
United States Posts: 168
Posted:
PM this userEmail this userView this user's DVD collectionEdit postDirect link to this postReply with quote
Quoting Mark Harrison:
Quote:
If they're listed in a non-standard format in the Birth Year thread, you can add them manually to the list...


How can I do that? 
I've got a Lars Hanson with a birthyear of 1886 appearing in Flesh & the Devil, but I also see that name in the cast of The Notorious Bettie Page.  The latter was filmed in 2006, but the Lars Hason that appeared in the Flesh & the Devil died April 6, 1965 so I doubt he is the same person but I cannot really find much on whomever this newer person is.
DVD Profiler Desktop and Mobile RegistrantStar ContributorStaid S Barr
Registered: Oct 16, 2003
Registered: May 9, 2007
Netherlands Posts: 1,536
Posted:
PM this userEdit postDirect link to this postReply with quote
Your second Lars Hanson is probably the one born in 1963. There's another one born in 1945, but his name is usually spelled as Hansson.

Apart from that, I am also interested to know how to add persons manually to the list.
Hans
DVD Profiler Unlimited RegistrantMuckl
That's my common name.
Registered: April 9, 2009
Reputation: Great Rating
Germany Posts: 858
Posted:
PM this userVisit this user's homepageView this user's DVD collectionEdit postDirect link to this postReply with quote
Quoting Mark Harrison:
Quote:
If they're listed in a non-standard format in the Birth Year thread, you can add them manually to the list.  If there are a lot of them, I might be able to put in something to program around them.  But it's always going to be a tough process.  The better approach would be to clean the few entries in that thread I pull the data from.

Aren't you using a regular expression to retrieve the years? In that case you could just replace the closing bracket after the digits with something like that: (\)|-|\s-)
 
1.0.1, iPhone 3GS, iOS 4.1.0

Trivia v0.3.1
My HSDB v5 additions, HTML windows and other stuff
 Last edited: by Muckl
DVD Profiler Unlimited RegistrantMark Harrison
I like IMDB
Registered: March 13, 2007
Reputation: Great Rating
United States Posts: 3,321
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionEdit postDirect link to this postReply with quote
Quoting MtnMike:
Quote:
Quoting Mark Harrison:
Quote:
If they're listed in a non-standard format in the Birth Year thread, you can add them manually to the list...


How can I do that?


Open the Options window.  Go to the tab furthest to the right called Accepted Birth Years.  There you can right-click to load the data.

Once the data is loaded, just scroll to the bottom of the list and you should see a blank row.  There you can enter whatever name & birth year you want and add as many as you want.  But they'll be overwritten if you reload that data.
Get the CSVExport and Database Query plug-ins here.
Create fake parent profiles to organize your collection.
DVD Profiler Unlimited RegistrantMark Harrison
I like IMDB
Registered: March 13, 2007
Reputation: Great Rating
United States Posts: 3,321
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionEdit postDirect link to this postReply with quote
Quoting Muckl:
Quote:
Quoting Mark Harrison:
Quote:
If they're listed in a non-standard format in the Birth Year thread, you can add them manually to the list.  If there are a lot of them, I might be able to put in something to program around them.  But it's always going to be a tough process.  The better approach would be to clean the few entries in that thread I pull the data from.

Aren't you using a regular expression to retrieve the years? In that case you could just replace the closing bracket after the digits with something like that: (\)|-|\s-)


Yes I am using regular expressions to read the data.  So if I see someone listed as John Barry (1935 - 1979), is that the date of birth & death?  If so, I should be able to make a fairly small change to pull the birth year out in those cases.
Get the CSVExport and Database Query plug-ins here.
Create fake parent profiles to organize your collection.
DVD Profiler Unlimited RegistrantMuckl
That's my common name.
Registered: April 9, 2009
Reputation: Great Rating
Germany Posts: 858
Posted:
PM this userVisit this user's homepageView this user's DVD collectionEdit postDirect link to this postReply with quote
Quoting Mark Harrison:
Quote:
Yes I am using regular expressions to read the data.  So if I see someone listed as John Barry (1935 - 1979), is that the date of birth & death?  If so, I should be able to make a fairly small change to pull the birth year out in those cases.

Yes, if there are two years inside the brackets, the first one is the BY and the second one is the year of death (sometimes separated with "-", sometimes with " - ").
 
1.0.1, iPhone 3GS, iOS 4.1.0

Trivia v0.3.1
My HSDB v5 additions, HTML windows and other stuff
 Last edited: by Muckl
DVD Profiler Unlimited RegistrantMsPaula
Ms Paula
Registered: March 14, 2007
United States Posts: 168
Posted:
PM this userEmail this userView this user's DVD collectionEdit postDirect link to this postReply with quote
Quoting Mark Harrison:
Quote:
Quoting MtnMike:
Quote:
Quoting Mark Harrison:
Quote:
If they're listed in a non-standard format in the Birth Year thread, you can add them manually to the list...


How can I do that?


Open the Options window.  Go to the tab furthest to the right called Accepted Birth Years.  There you can right-click to load the data.

Once the data is loaded, just scroll to the bottom of the list and you should see a blank row.  There you can enter whatever name & birth year you want and add as many as you want.  But they'll be overwritten if you reload that data.


Thanks! I'd checked the Options, just never tried scrolling far enough over to the right.
It's a shame that reloading will remove my manual additions though - perhaps in a future version, you could include a way for user additions to be retained optionally?
DVD Profiler Unlimited RegistrantMuckl
That's my common name.
Registered: April 9, 2009
Reputation: Great Rating
Germany Posts: 858
Posted:
PM this userVisit this user's homepageView this user's DVD collectionEdit postDirect link to this postReply with quote
Quoting MtnMike:
Quote:
[...] perhaps in a future version, you could include a way for user additions to be retained optionally?

I'd love to see that, too! 
 
1.0.1, iPhone 3GS, iOS 4.1.0

Trivia v0.3.1
My HSDB v5 additions, HTML windows and other stuff
DVD Profiler Unlimited RegistrantStar ContributorJeroenX
Registered: March 14, 2007
Reputation: High Rating
Netherlands Posts: 287
Posted:
PM this userEdit postDirect link to this postReply with quote
When checking for bad commentary data, I came up with an error.
For example. the UK Blu-Ray of Batman has commentary ticked in features, and has an commentary audio track on place 9.
Still this shows up when running the query.
DVD Profiler Unlimited Registrantgardibolt
digitally Obsessed
Registered: March 13, 2007
Posts: 1,414
Posted:
PM this userVisit this user's homepageView this user's DVD collectionEdit postDirect link to this postReply with quote
Maybe the simplest thing with the birth year issue is to identify the non-standard ones that aren't being picked up and ask the Martian to make them standard.  That would save everyone a lot of problems.
"This movie has warped my fragile little mind."
DVD Profiler Unlimited RegistrantMark Harrison
I like IMDB
Registered: March 13, 2007
Reputation: Great Rating
United States Posts: 3,321
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionEdit postDirect link to this postReply with quote
Quoting Muckl:
Quote:
But one question: if "Ignore Accepted Birth Years" is checked, I get 265 rows – if not, I get only 152 rows. Shouldn't it be the other way round? 


Fixed with new wording.

Quoting Muckl:
Quote:
Yes, if there are two years inside the brackets, the first one is the BY and the second one is the year of death (sometimes separated with "-", sometimes with " - ").


Fixed to read birth years that have death years listed.

Quoting MtnMike:
Quote:
It's a shame that reloading will remove my manual additions though - perhaps in a future version, you could include a way for user additions to be retained optionally?


Fixed with new options to overwrite or merge.

Quoting JeroenX:
Quote:
When checking for bad commentary data, I came up with an error.
For example. the UK Blu-Ray of Batman has commentary ticked in features, and has an commentary audio track on place 9.
Still this shows up when running the query.


Missed this one. We used to only be allowed 8 audio tracks I think.  That's all the plugin is built to handle at this point.  I'll get to this one later.

Go to the website to see the release notes and grab the latest version.
Get the CSVExport and Database Query plug-ins here.
Create fake parent profiles to organize your collection.
    Invelos Forums->DVD Profiler: Plugins Page: 1... 22 23 24 25 26 ...36  Previous   Next