Importing Candidates.csv
Found 3374 records in Candidates.csv
Updated 0 records in camp_fin_candidate
Traceback (most recent call last):
File "/home/fgregg/public/openness-project-nmid/.env/lib/python3.5/site-packages/sqlalchemy/engine/base.py", line 1139, in _execute_context
context)
File "/home/fgregg/public/openness-project-nmid/.env/lib/python3.5/site-packages/sqlalchemy/engine/default.py", line 450, in do_execute
cursor.execute(statement, parameters)
psycopg2.IntegrityError: null value in column "full_name" violates not-null constraint
DETAIL: Failing row contains (57, null, A., B., Valdez, null, null, (505) 753-4018, 2010-01-01 00:00:00-06, dvaldez@cybermesa.com, null, null, 0, 3149, 2478, 1824, 1, null, null).
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "manage.py", line 22, in <module>
execute_from_command_line(sys.argv)
File "/home/fgregg/public/openness-project-nmid/.env/lib/python3.5/site-packages/django/core/management/__init__.py", line 367, in execute_from_command_line
utility.execute()
File "/home/fgregg/public/openness-project-nmid/.env/lib/python3.5/site-packages/django/core/management/__init__.py", line 359, in execute
self.fetch_command(subcommand).run_from_argv(self.argv)
File "/home/fgregg/public/openness-project-nmid/.env/lib/python3.5/site-packages/django/core/management/base.py", line 305, in run_from_argv
self.execute(*args, **cmd_options)
File "/home/fgregg/public/openness-project-nmid/.env/lib/python3.5/site-packages/django/core/management/base.py", line 356, in execute
output = self.handle(*args, **options)
File "/home/fgregg/public/openness-project-nmid/camp_fin/management/commands/import_data.py", line 112, in handle
self.doETL(entity_type)
File "/home/fgregg/public/openness-project-nmid/camp_fin/management/commands/import_data.py", line 162, in doETL
self.addNewRecords()
File "/home/fgregg/public/openness-project-nmid/camp_fin/management/commands/import_data.py", line 520, in addNewRecords
self.executeTransaction(insert_new)
File "/home/fgregg/public/openness-project-nmid/camp_fin/management/commands/import_data.py", line 668, in executeTransaction
self.connection.execute(query, *args)
File "/home/fgregg/public/openness-project-nmid/.env/lib/python3.5/site-packages/sqlalchemy/engine/base.py", line 906, in execute
return self._execute_text(object, multiparams, params)
File "/home/fgregg/public/openness-project-nmid/.env/lib/python3.5/site-packages/sqlalchemy/engine/base.py", line 1054, in _execute_text
statement, parameters
File "/home/fgregg/public/openness-project-nmid/.env/lib/python3.5/site-packages/sqlalchemy/engine/base.py", line 1146, in _execute_context
context)
File "/home/fgregg/public/openness-project-nmid/.env/lib/python3.5/site-packages/sqlalchemy/engine/base.py", line 1341, in _handle_dbapi_exception
exc_info
File "/home/fgregg/public/openness-project-nmid/.env/lib/python3.5/site-packages/sqlalchemy/util/compat.py", line 202, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=cause)
File "/home/fgregg/public/openness-project-nmid/.env/lib/python3.5/site-packages/sqlalchemy/util/compat.py", line 185, in reraise
raise value.with_traceback(tb)
File "/home/fgregg/public/openness-project-nmid/.env/lib/python3.5/site-packages/sqlalchemy/engine/base.py", line 1139, in _execute_context
context)
File "/home/fgregg/public/openness-project-nmid/.env/lib/python3.5/site-packages/sqlalchemy/engine/default.py", line 450, in do_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.IntegrityError: (psycopg2.IntegrityError) null value in column "full_name" violates not-null constraint
DETAIL: Failing row contains (57, null, A., B., Valdez, null, null, (505) 753-4018, 2010-01-01 00:00:00-06, dvaldez@cybermesa.com, null, null, 0, 3149, 2478, 1824, 1, null, null).
[SQL: ' \n INSERT INTO camp_fin_candidate (\n id, entity_id, prefix, first_name, last_name, middle_name, suffix, business_phone, home_phone, address_id, status_id, date_added, contact_id, email, date_updated, qual_candidate_id, deceased\n )\n SELECT raw."candidateid"::bigint AS id, raw."entityid"::bigint AS entity_id, raw."prefix"::varchar AS prefix, raw."firstname"::varchar AS first_name, raw."lastname"::varchar AS last_name, raw."middlename"::varchar AS middle_name, raw."suffix"::varchar AS suffix, raw."businessphone"::varchar AS business_phone, raw."homephone"::varchar AS home_phone, raw."addressid"::bigint AS address_id, raw."statusid"::bigint AS status_id, raw."dateadded"::date AS date_added, raw."contactid"::bigint AS contact_id, raw."emailaccount"::varchar AS email, raw."datelastupdated"::timestamp with time zone AS date_updated, raw."qualcandidateid"::bigint AS qual_candidate_id, raw."deceased"::varchar AS deceased\n FROM raw_candidate AS raw\n JOIN new_candidate AS new\n ON raw."candidateid" = new.id\n ']