Hi, I am attempting to import imdb plain text file using imdbpy2sql.py using 
the following command on ubuntu precise and am getting aKeyError: 'gender' . 
Can anyone assist? 

sye@dbuddy:~/imdbpy/bin$ sudo python imdbpy2sql.py -d /home/sye/database/ -u 

NOTICE: IF you're using InnoDB tables, data insertion can
be very slow; you can switch to MyISAM tables - forcing it
with the --mysql-force-myisam option - OR use the
--mysql-innodb command line option, but DON'T USE these if
you're already working on MyISAM tables, because it will
force MySQL to use InnoDB, and performances will be poor.

Traceback (most recent call last):
  File "imdbpy2sql.py", line 2589, in <module>
    CACHE_PID = PersonsCache()
  File "imdbpy2sql.py", line 1141, in __init__
    'namePcodeNf', 'surnamePcode', 'md5sum'])
  File "imdbpy2sql.py", line 638, in createSQLstr
    colNames.append(colName(table, col))
  File "imdbpy2sql.py", line 583, in colName
    return table.sqlmeta.columns[column].dbName
KeyError: 'gender'

Thanks Sye.

Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and 
threat landscape has changed and how IT managers can respond. Discussions 
will include endpoint security, mobile security and the latest in malware 
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
Imdbpy-help mailing list

Reply via email to