openlp-core team mailing list archive

[Jon Tibble <meths@xxxxxxxxxxxxxx>]

Your CSV is in the wrong format so you're either missing a column or
have them in the wrong order.

See
http://openlp.org/en/forums/development/feature_requests/help_with_bible_import.html

-- 
You received this bug notification because you are a member of OpenLP
Core, which is subscribed to OpenLP.
https://bugs.launchpad.net/bugs/687309

Title:
  CSV Bible import fails in 1.9.3

Status in OpenLP - Worship Presentation Software:
  Fix Released

Bug description:
  While trying to import a Bible into version 1.9.3 I got the following 
  error message:

  Traceback (most recent call last):
  File "c:\Documents and Settings\raoul\My Documents\My 
  Projects\openlp\release-1.9.3\build\pyi.win32\OpenLP\outPYZ1.pyz/openlp.plugins.bibles.forms.importwizardform", 
  line 256, in onCurrentIdChanged
  File "c:\Documents and Settings\raoul\My Documents\My 
  Projects\openlp\release-1.9.3\build\pyi.win32\OpenLP\outPYZ1.pyz/openlp.plugins.bibles.forms.importwizardform", 
  line 408, in performImport
  File "c:\Documents and Settings\raoul\My Documents\My 
  Projects\openlp\release-1.9.3\build\pyi.win32\OpenLP\outPYZ1.pyz/openlp.plugins.bibles.lib.manager", 
  line 178, in import_bible
  File "c:\Documents and Settings\raoul\My Documents\My 
  Projects\openlp\release-1.9.3\build\pyi.win32\OpenLP\outPYZ1.pyz/openlp.plugins.bibles.lib.db", 
  line 203, in register
  File "c:\Documents and Settings\raoul\My Documents\My 
  Projects\openlp\release-1.9.3\build\pyi.win32\OpenLP\outPYZ1.pyz/openlp.plugins.bibles.lib.db", 
  line 293, in create_meta
  File "c:\Documents and Settings\raoul\My Documents\My 
  Projects\openlp\release-1.9.3\build\pyi.win32\OpenLP\outPYZ1.pyz/openlp.core.lib.db", 
  line 152, in save_object
  File "c:\Documents and Settings\raoul\My Documents\My 
  Projects\openlp\release-1.9.3\build\pyi.win32\OpenLP\outPYZ1.pyz/sqlalchemy.orm.scoping", 
  line 127, in do
  File "c:\Documents and Settings\raoul\My Documents\My 
  Projects\openlp\release-1.9.3\build\pyi.win32\OpenLP\outPYZ1.pyz/sqlalchemy.orm.session", 
  line 671, in commit
  File "c:\Documents and Settings\raoul\My Documents\My 
  Projects\openlp\release-1.9.3\build\pyi.win32\OpenLP\outPYZ1.pyz/sqlalchemy.orm.session", 
  line 378, in commit
  File "c:\Documents and Settings\raoul\My Documents\My 
  Projects\openlp\release-1.9.3\build\pyi.win32\OpenLP\outPYZ1.pyz/sqlalchemy.orm.session", 
  line 362, in _prepare_impl
  File "c:\Documents and Settings\raoul\My Documents\My 
  Projects\openlp\release-1.9.3\build\pyi.win32\OpenLP\outPYZ1.pyz/sqlalchemy.orm.session", 
  line 1354, in flush
  File "c:\Documents and Settings\raoul\My Documents\My 
  Projects\openlp\release-1.9.3\build\pyi.win32\OpenLP\outPYZ1.pyz/sqlalchemy.orm.session", 
  line 1432, in _flush
  File "c:\Documents and Settings\raoul\My Documents\My 
  Projects\openlp\release-1.9.3\build\pyi.win32\OpenLP\outPYZ1.pyz/sqlalchemy.orm.unitofwork", 
  line 261, in execute
  File "c:\Documents and Settings\raoul\My Documents\My 
  Projects\openlp\release-1.9.3\build\pyi.win32\OpenLP\outPYZ1.pyz/sqlalchemy.orm.unitofwork", 
  line 753, in execute
  File "c:\Documents and Settings\raoul\My Documents\My 
  Projects\openlp\release-1.9.3\build\pyi.win32\OpenLP\outPYZ1.pyz/sqlalchemy.orm.unitofwork", 
  line 768, in execute_save_steps
  File "c:\Documents and Settings\raoul\My Documents\My 
  Projects\openlp\release-1.9.3\build\pyi.win32\OpenLP\outPYZ1.pyz/sqlalchemy.orm.unitofwork", 
  line 759, in save_objects
  File "c:\Documents and Settings\raoul\My Documents\My 
  Projects\openlp\release-1.9.3\build\pyi.win32\OpenLP\outPYZ1.pyz/sqlalchemy.orm.mapper", 
  line 1428, in _save_obj
  File "c:\Documents and Settings\raoul\My Documents\My 
  Projects\openlp\release-1.9.3\build\pyi.win32\OpenLP\outPYZ1.pyz/sqlalchemy.engine.base", 
  line 824, in execute
  File "c:\Documents and Settings\raoul\My Documents\My 
  Projects\openlp\release-1.9.3\build\pyi.win32\OpenLP\outPYZ1.pyz/sqlalchemy.engine.base", 
  line 874, in _execute_clauseelement
  File "c:\Documents and Settings\raoul\My Documents\My 
  Projects\openlp\release-1.9.3\build\pyi.win32\OpenLP\outPYZ1.pyz/sqlalchemy.engine.base", 
  line 896, in __execute_context
  File "c:\Documents and Settings\raoul\My Documents\My 
  Projects\openlp\release-1.9.3\build\pyi.win32\OpenLP\outPYZ1.pyz/sqlalchemy.engine.base", 
  line 950, in _cursor_execute
  File "c:\Documents and Settings\raoul\My Documents\My 
  Projects\openlp\release-1.9.3\build\pyi.win32\OpenLP\outPYZ1.pyz/sqlalchemy.engine.base", 
  line 931, in _handle_dbapi_exception
  IntegrityError: (IntegrityError) column key is not unique u'INSERT INTO 
  metadata ("key", value) VALUES (?, ?)' [u'dbversion', u'2']

  This appeared immediately after entering the file names and pressing
  the "go" button.

  I have sucessfully imported the CSV file into version 1.x of openLP.