Reply to topic  [ 20 posts ]  Go to page 1, 2  Next
IMDB shortcuts 
Author Message
Supporting actor

Joined: Sat Aug 02, 2008 10:25 am
Posts: 72
Post IMDB shortcuts
When I upload an actor I want a shortcut of the IMDB site from the actor on the page, sometimes it is , sometimes non, can you help me ;)


Mon Nov 14, 2011 11:19 am
Profile
Black Belt Squirrel
User avatar

Joined: Fri Feb 20, 2009 3:34 pm
Posts: 1096
Location: France
Post Re: IMDB shortcuts
Hi,

Are you using several scripts for movies/persons ?
This may occur if you've downloaded a person (or all his/her movies) using another script than imdb script.

You can get the imdb shortcut displayed on person's page just by adding the URL in the person update window, 'Other' tab.
Or, use imdb script to update the person's infos.

JeF


Mon Nov 14, 2011 1:01 pm
Profile
Supporting actor

Joined: Sat Aug 02, 2008 10:25 am
Posts: 72
Post Re: IMDB shortcuts
I only use IMDB scripts and it doesn work :( :(


Mon Nov 14, 2011 3:42 pm
Profile
Supporting actor

Joined: Sat Aug 02, 2008 10:25 am
Posts: 72
Post Re: IMDB shortcuts
maybe a plugin for give all the persons their IMDB shortcut ??????????????? ;) ;) ;) ;)

P.S. the movies have all their IMDB shortcut but the people not


Mon Nov 14, 2011 3:44 pm
Profile
Black Belt Squirrel
User avatar

Joined: Fri Feb 20, 2009 3:34 pm
Posts: 1096
Location: France
Post Re: IMDB shortcuts
alpa wrote:
maybe a plugin for give all the persons their IMDB shortcut ??????????????? ;) ;) ;) ;)
P.S. the movies have all their IMDB shortcut but the people not
Maybe the following workaround may do it :
The idea is to identify movies that have at least one person without person imdb url and then update those movies so that persons imdb url are 'refreshed'.

To be done first on a TEST (copied) database...

Step by step :
- Import (hit 'import' and copy/paste) following query into ExtraQueries plugin
Code:
Qry = select 'tt' || imdb_code as Imdb_id from movies where in_collection = 1 and imdb_code > '' and code in (select distinct movie from data where person in (select code from persons where code not in (select person from persons_codes where lower(script) = 'imdb')))
Desc = Imdb Ids of movies with persons having no person imdb url
- Use export button to get the list into excel for instance
- copy/paste that Ids list into add movie window
-> this will bulk download movie data (and, as a consequence, persons imdb urls) for movies having at least one person without imdb url...

Please let me know if it did the job.
;)
JeF


Mon Nov 14, 2011 5:26 pm
Profile
Supporting actor

Joined: Sat Aug 02, 2008 10:25 am
Posts: 72
Post Re: IMDB shortcuts
I try what you say and thats all what I have;

Image

Uploaded with ImageShack.us

Image

Uploaded with ImageShack.us


Tue Nov 15, 2011 2:11 am
Profile
Supporting actor

Joined: Sat Aug 02, 2008 10:25 am
Posts: 72
Post Re: IMDB shortcuts
Look Jeff, I'm just download the actor "Phil Reeves" again

Image

Uploaded with ImageShack.us

Script for movies = IMDB

Image

Uploaded with ImageShack.us

Script for persons = IMDB

Image

Uploaded with ImageShack.us


Tue Nov 15, 2011 2:17 am
Profile
Black Belt Squirrel
User avatar

Joined: Fri Feb 20, 2009 3:34 pm
Posts: 1096
Location: France
Post Re: IMDB shortcuts
Hmmm... As i can see there is an url entry but the link is blank, right ?
Was that url entry (with blank url but 'imdb' as site name) present before running the query ?
If the answer is yes then try to :
- manually delete that entry using the minus button
- download again infos for one of his movies
- check again that person url entries
JeF


Tue Nov 15, 2011 8:11 am
Profile
Supporting actor

Joined: Sat Aug 02, 2008 10:25 am
Posts: 72
Post Re: IMDB shortcuts
I did what you say Jef and it works
1) Image

Uploaded with ImageShack.us

and I download a movie with this actor and YES
2) Image

Uploaded with ImageShack.us


Thanks Again Jef for your help :P :P :P :P


Tue Nov 15, 2011 11:42 am
Profile
Black Belt Squirrel
User avatar

Joined: Fri Feb 20, 2009 3:34 pm
Posts: 1096
Location: France
Post Re: IMDB shortcuts
alpa wrote:
Thanks Again Jef for your help :P :P :P :P
You're welcome.

Now you may want to fix all actors in a go, don't you?
So here's the modifed query which should take into account present but blank url entries... You already know the steps.
Code:
Qry = select 'tt' || imdb_code as Imdb_id from movies where in_collection = 1 and imdb_code > '' and code in (select distinct movie from data where person in (select code from persons where code not in (select person from persons_codes where lower(script) = 'imdb' and site > '')))
Desc = Imdb Ids of movies with persons having no (or blank) person imdb url

;)
JeF


Tue Nov 15, 2011 12:28 pm
Profile
Display posts from previous:  Sort by  
Reply to topic   [ 20 posts ]  Go to page 1, 2  Next

Who is online

Users browsing this forum: No registered users and 4 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group.
Designed by STSoftware.