openlp-core team mailing list archive

[Jon Tibble <meths@xxxxxxxxxxxxxx>]

The stack trace above is nothing to do with this in case anyone wonders.

I've fixed up the importer so it will import from book and verse CSV
files.  Please test and hammer.

Still to do:
* Get confirmation from testers if the progress bar looks like it's incrementing correctly - I may have hit 100% around the Johns.
* The code is there to handle testament files but they need adding to the CSV page of the wizard.

** Changed in: openlp
       Status: New => In Progress

** Changed in: openlp
     Assignee: (unassigned) => Jon Tibble (meths)

-- 
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:
  In Progress

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.