Update database of movies

Talk to other Pedia users about the programs, share tricks and tips or ask questions about existing features.
judocama
Addicted to Bruji
Addicted to Bruji
Posts: 265
Joined: Sun May 24, 2009 6:16 am

Re: Update database of movies

Post by judocama »

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

Post by judocama »

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.
User avatar
Conor
Top Dog
Posts: 5343
Joined: Sat Jul 03, 2004 12:58 pm
Contact:

Re: Update database of movies

Post by Conor »

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.
judocama
Addicted to Bruji
Addicted to Bruji
Posts: 265
Joined: Sun May 24, 2009 6:16 am

Re: Update database of movies

Post by judocama »

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.
User avatar
Conor
Top Dog
Posts: 5343
Joined: Sat Jul 03, 2004 12:58 pm
Contact:

Re: Update database of movies

Post by Conor »

To remove the links you would need to do them by hand.
judocama
Addicted to Bruji
Addicted to Bruji
Posts: 265
Joined: Sun May 24, 2009 6:16 am

Re: Update database of movies

Post by judocama »

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.
User avatar
Conor
Top Dog
Posts: 5343
Joined: Sat Jul 03, 2004 12:58 pm
Contact:

Re: Update database of movies

Post by Conor »

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

Re: Update database of movies

Post by judocama »

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

Post by judocama »

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.
User avatar
Conor
Top Dog
Posts: 5343
Joined: Sat Jul 03, 2004 12:58 pm
Contact:

Re: Update database of movies

Post by Conor »

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".
judocama
Addicted to Bruji
Addicted to Bruji
Posts: 265
Joined: Sun May 24, 2009 6:16 am

Re: Update database of movies

Post by judocama »

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

Post by judocama »

(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.
User avatar
Conor
Top Dog
Posts: 5343
Joined: Sat Jul 03, 2004 12:58 pm
Contact:

Re: Update database of movies

Post by Conor »

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.
judocama
Addicted to Bruji
Addicted to Bruji
Posts: 265
Joined: Sun May 24, 2009 6:16 am

Re: Update database of movies

Post by judocama »

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.
User avatar
Nora
Site Admin
Posts: 2155
Joined: Sun Jul 04, 2004 5:03 am
Contact:

Re: Update database of movies

Post by Nora »

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.
Post Reply