Update database of movies

Talk to other Pedia users about the programs, share tricks and tips or ask questions about existing features.

Re: Update database of movies

Postby judocama » Mon Feb 14, 2011 9:46 am

You have reason, I have downloaded a old beta, now work fine.

Thanks a lot.

How can I edit multiple film the field where are the link to official url? is in the links in the apartat "apartate ".

Thanks in advance.
judocama
Addicted to Bruji
Addicted to Bruji
 
Posts: 265
Joined: Sun May 24, 2009 6:16 am

Re: Update database of movies

Postby judocama » Mon Feb 14, 2011 5:02 pm

Conor I think still is not working full, take a look at this film:

WALL•E ( I get WALLE) http://www.filmaffinity.com//es/film744679.html

Thanks a lot.
judocama
Addicted to Bruji
Addicted to Bruji
 
Posts: 265
Joined: Sun May 24, 2009 6:16 am

Re: Update database of movies

Postby Conor » Mon Feb 14, 2011 5:40 pm

The links section is not part of the multiple edit as there can be any number of them. If you need to any a large number of links at the same time you would need to use the backend SQL command for that.

The WALL•E missing the • is an encoding issue with the site. Safari is smart enough to recognize it, but in the underlining Cocoa system you have to declare an encoding and we use the one declared in the content tag. By this day and age every site should be using UTF-8, when they switch it will fix itself. Luckily WALL•E is a rare exception when it comes to titles.
User avatar
Conor
Top Dog
 
Posts: 5206
Joined: Sat Jul 03, 2004 12:58 pm

Re: Update database of movies

Postby judocama » Tue Feb 15, 2011 5:05 am

Thanks Conors

Then if I wan to erase all the links (url official) to get info from filmaffinity how can erase this field and let the scrit get it?
The problem is that some films have links errors get to introduce some images by myself.

Thanks al lot.
judocama
Addicted to Bruji
Addicted to Bruji
 
Posts: 265
Joined: Sun May 24, 2009 6:16 am

Re: Update database of movies

Postby Conor » Tue Feb 15, 2011 4:32 pm

To remove the links you would need to do them by hand.
User avatar
Conor
Top Dog
 
Posts: 5206
Joined: Sat Jul 03, 2004 12:58 pm

Re: Update database of movies

Postby judocama » Wed Feb 16, 2011 2:18 pm

Thanks Conors, I will make so.

Only one problem, when I introduce a new film if only is there one results it don´t take good the title of film by the example:

Un mundo implacable : I get only one result " Network " if I choose this don´t add the film in field title traducted in Spanish.

So If I search how " Network " I get two results " La red social " and " Un mundo implacable " and if I choose " Un mundo implacable " then yes add the film in field title traducted in Spanish.

Is there a bug?.

Thanks in advance.
judocama
Addicted to Bruji
Addicted to Bruji
 
Posts: 265
Joined: Sun May 24, 2009 6:16 am

Re: Update database of movies

Postby Conor » Fri Feb 18, 2011 9:49 pm

User avatar
Conor
Top Dog
 
Posts: 5206
Joined: Sat Jul 03, 2004 12:58 pm

Re: Update database of movies

Postby judocama » Sun Feb 20, 2011 6:55 am

Thanks a lot.
judocama
Addicted to Bruji
Addicted to Bruji
 
Posts: 265
Joined: Sun May 24, 2009 6:16 am

Re: Update database of movies

Postby judocama » Thu Feb 24, 2011 5:47 pm

Sorry Conors, when I update the film don´t retrieve Animation data in the field cast, by the example:

Arthur and the Vengeance of Maltazard

http://www.filmaffinity.com/es/film431176.html

, Freddie Highmore, Penny Balfour, Mia Farrow

Thanks in advance.
judocama
Addicted to Bruji
Addicted to Bruji
 
Posts: 265
Joined: Sun May 24, 2009 6:16 am

Re: Update database of movies

Postby Conor » Sat Feb 26, 2011 12:15 am

Hi,

The removal of animation from the cast list is done on purpose but I have updated the beta to remove the initial extra comma for those movies. So it will now be "Freddie Highmore, Penny Balfour, Mia Farrow".
User avatar
Conor
Top Dog
 
Posts: 5206
Joined: Sat Jul 03, 2004 12:58 pm

Re: Update database of movies

Postby judocama » Tue Mar 01, 2011 6:21 am

Thanks Conors, now I understand.

I think still is the bug when the film title have " ( " by the example:

http://www.filmaffinity.com/es/film575149.html

I get to spaces insteand one

Seven (Se7en)

Why sometimes i get how url this type:

http://www.filmaffinity.com//es/film998690.html

instead

http://www.filmaffinity.com/es/film998690.html

The difference is in http://www.filmaffinity.com/es/
http://www.filmaffinity.com//es/

I don´t understand.

Thanks in advance.
judocama
Addicted to Bruji
Addicted to Bruji
 
Posts: 265
Joined: Sun May 24, 2009 6:16 am

Re: Update database of movies

Postby judocama » Thu Jun 09, 2011 6:03 am

(The links section is not part of the multiple edit as there can be any number of them. If you need to any a large number of links at the same time you would need to use the backend SQL command for that.)

Conors, you will answer me this.

I have no experience using SQL commands.

The problem is that several updates have been link me (or by dragging an image error) I want to erase.

there any way to edit my database to delete them all and then do an update that I take of my script (example FilmAffinity)

Thanks in advance.
judocama
Addicted to Bruji
Addicted to Bruji
 
Posts: 265
Joined: Sun May 24, 2009 6:16 am

Re: Update database of movies

Postby Conor » Thu Jun 09, 2011 11:41 am

If all the links share something in common that you can identify them by you would be able to remove them all with the SQL. As usual create a backup of your Database.pediadata file, as you can render the database unreadable with an SQL command. The file is located by default in your home folder at ~/Library/ Application Support/DVDpedia/Database.pediadata.

Then with Terminal you can run the following commands (removes all the links that have any folder "Images" as part of the path):
Code: Select all
sqlite3 ~/Library/Application\ Support/DVDpedia/Database.pediadata
DELETE from zlink where zurl like "%/Images/%";
.exit


I would recommend caution with the above command as it can remove all your links, should there be a mistake in the "where" part. I personally would do delete items and links by hand to be sure what I am removing. However, if you have thousands of links the above would be quite useful.

Updates you can run as usual from within the program under the get more info in the advance menu or with the gear button on the lower right of the edit window.
User avatar
Conor
Top Dog
 
Posts: 5206
Joined: Sat Jul 03, 2004 12:58 pm

Re: Update database of movies

Postby judocama » Thu Jun 09, 2011 3:49 pm

I don´t have link to movies only have the link to official url that i got from my scritp.

Would you to put how one option to edit multiple films?

Thanks in advance.
judocama
Addicted to Bruji
Addicted to Bruji
 
Posts: 265
Joined: Sun May 24, 2009 6:16 am

Re: Update database of movies

Postby Nora » Mon Jun 13, 2011 10:30 am

The information in the URL field you can delete for all entries by selecting them all and choosing 'Edit'. That'll bring up the multiple edit window where you want to check the box next to 'URL" and then leave the field blank.
User avatar
Nora
Site Admin
 
Posts: 2149
Joined: Sun Jul 04, 2004 5:03 am

PreviousNext

Return to PediaTalk

cron