Page 3 of 4

Re: Update database of movies

Posted: Mon Feb 14, 2011 9:46 am
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.

Re: Update database of movies

Posted: Mon Feb 14, 2011 5:02 pm
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.

Re: Update database of movies

Posted: Mon Feb 14, 2011 5:40 pm
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.

Re: Update database of movies

Posted: Tue Feb 15, 2011 5:05 am
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.

Re: Update database of movies

Posted: Tue Feb 15, 2011 4:32 pm
by Conor
To remove the links you would need to do them by hand.

Re: Update database of movies

Posted: Wed Feb 16, 2011 2:18 pm
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.

Re: Update database of movies

Posted: Fri Feb 18, 2011 9:49 pm
by Conor

Re: Update database of movies

Posted: Sun Feb 20, 2011 6:55 am
by judocama
Thanks a lot.

Re: Update database of movies

Posted: Thu Feb 24, 2011 5:47 pm
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.

Re: Update database of movies

Posted: Sat Feb 26, 2011 12:15 am
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".

Re: Update database of movies

Posted: Tue Mar 01, 2011 6:21 am
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.

Re: Update database of movies

Posted: Thu Jun 09, 2011 6:03 am
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.

Re: Update database of movies

Posted: Thu Jun 09, 2011 11:41 am
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.

Re: Update database of movies

Posted: Thu Jun 09, 2011 3:49 pm
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.

Re: Update database of movies

Posted: Mon Jun 13, 2011 10:30 am
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.