Re: [Imdbpy-help] imdbpy2sql - some movies are missing nr_order for the cast
On Tue, Dec 13, 2011 at 19:58, Davide Alberani wrote: > > However, this doesn't explain your 19 and 0... :-/ > My db is not up-to-date: I'll recreate it tomorrow and see the result > of your queries. Pardon for the delay. I have the same data, and they are from the 'writer.list' file. Most probably, they are wrong submissions or have some arcane meaning for the IMDb database. :-) Happy holidays! -- Davide Alberani [PGP KeyID: 0x465BFD47] http://www.mimante.net/ -- Write once. Port to many. Get the SDK and tools to simplify cross-platform app development. Create new or port existing apps to sell to consumers worldwide. Explore the Intel AppUpSM program developer opportunity. appdeveloper.intel.com/join http://p.sf.net/sfu/intel-appdev ___ Imdbpy-help mailing list Imdbpy-help@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/imdbpy-help
Re: [Imdbpy-help] imdbpy2sql - some movies are missing nr_order for the cast
On Tue, Dec 13, 2011 at 19:01, darklow wrote: > > I can confirm that the problem with missing nr_order appears also in latest > data files (9.dec.2011) > Hope there is some solution and it is not permanent. At a very first look, it seems to me that these information, for these movies, are completely missing from the data files (most probably because they are unknown: IMDb puts the credits order only if they were officially taken from the movie credits) It can be tested with a regexp like this: zcat actors.list.gz actresses.list.gz | grep -P '\011Ceremony\ \(2010\).*<.*>' Which, on my set of files, returns nothing (meaning that there are no actors or actresses with credits order for that movie). However, this doesn't explain your 19 and 0... :-/ My db is not up-to-date: I'll recreate it tomorrow and see the result of your queries. Bye! -- Davide Alberani [PGP KeyID: 0x465BFD47] http://www.mimante.net/ -- Systems Optimization Self Assessment Improve efficiency and utilization of IT resources. Drive out cost and improve service delivery. Take 5 minutes to use this Systems Optimization Self Assessment. http://www.accelacomm.com/jaw/sdnl/114/51450054/ ___ Imdbpy-help mailing list Imdbpy-help@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/imdbpy-help
Re: [Imdbpy-help] imdbpy2sql - some movies are missing nr_order for the cast
I can confirm that the problem with missing nr_order appears also in latest data files (9.dec.2011) Hope there is some solution and it is not permanent. Thanks a lot On Tue, Dec 13, 2011 at 11:42 AM, Davide Alberani wrote: > On Tue, Dec 13, 2011 at 09:26, darklow wrote: > > > > It looks like there is something wrong, becaouse i have never seen so > much > > nr_order missing before > > I've downloaded the latest set of files; I'll look at it as soon as > possible. > > As usual, thanks for the report! > > -- > Davide Alberani [PGP KeyID: 0x465BFD47] > http://www.mimante.net/ > -- Systems Optimization Self Assessment Improve efficiency and utilization of IT resources. Drive out cost and improve service delivery. Take 5 minutes to use this Systems Optimization Self Assessment. http://www.accelacomm.com/jaw/sdnl/114/51450054/___ Imdbpy-help mailing list Imdbpy-help@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/imdbpy-help
Re: [Imdbpy-help] imdbpy2sql - some movies are missing nr_order for the cast
On Tue, Dec 13, 2011 at 09:26, darklow wrote: > > It looks like there is something wrong, becaouse i have never seen so much > nr_order missing before I've downloaded the latest set of files; I'll look at it as soon as possible. As usual, thanks for the report! -- Davide Alberani [PGP KeyID: 0x465BFD47] http://www.mimante.net/ -- Systems Optimization Self Assessment Improve efficiency and utilization of IT resources. Drive out cost and improve service delivery. Take 5 minutes to use this Systems Optimization Self Assessment. http://www.accelacomm.com/jaw/sdnl/114/51450054/ ___ Imdbpy-help mailing list Imdbpy-help@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/imdbpy-help
[Imdbpy-help] imdbpy2sql - some movies are missing nr_order for the cast
Hi, Just noticed that some movies are missing nr_order for the cast. For example: Titles: *Snow White and the Huntsman* (2012) and *Ceremony*(2010) select * from cast_info where movie_id=(select id from title where title='Snow White and the Huntsman'); NR_ORDER column is for every cast_info entry beside one, which has value *19* http://www.imdb.com/title/tt1735898/ select * from cast_info where movie_id=(select id from title where title='Ceremony' and kind_id=1 and production_year=2010); NR_ORDER column is for every cast_info entry beside one, which has value *0 *http://www.imdb.com/title/tt1341341/ It looks like there is something wrong, becaouse i have never seen so much * nr_order* missing before I am using latest dev version of imdbpy2sql (IMDbPY==4.9dev-2024) (PostgreSQL) Data files date: 24.Nov.2011 I just ran update with newest datafiles (09.Dec.2011) I'll notice as soon as it ends if there will be any changes. Maybe you already have some ideas what could went wrong? Thanks. -- Systems Optimization Self Assessment Improve efficiency and utilization of IT resources. Drive out cost and improve service delivery. Take 5 minutes to use this Systems Optimization Self Assessment. http://www.accelacomm.com/jaw/sdnl/114/51450054/___ Imdbpy-help mailing list Imdbpy-help@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/imdbpy-help