[Openlp-core] [Bug 1391015] Re: Add song topics with CCLI USR file import

[Phill]

It appears this has been long supported. Tested with trunk and imports
fine.

** Changed in: openlp
   Status: Confirmed => Fix Released

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

Title:
  Add song topics with CCLI USR file import

Status in OpenLP:
  Fix Released

Bug description:
  I noticed that .usr files from SongSelect contain song topics. (The
  text files do not however).

  Could the SongSelect import be expanded to add this field as well?

  I'm using OpenLP beta 2.1.1. build 2455 on Mac OS X 10.10 Yosemite.

  For the record, here's a sample SongSelect .usr file: (I'll leave out
  the lyrics for fear of copyright infringement)

  [File]
  Type=SongSelect Import File
  Version=3.0
  [S A6016351]
  Title=10,000 Reasons (Bless The Lord)
  Author=Jonas Myrin | Matt Redman
  Copyright=2011 Said And Done Music | sixsteps Music | Thankyou Music | 
worshiptogether.com songs | SHOUT! Music Publishing (Admin. by Crossroad 
Distributors Pty. Ltd.) | (Admin. by Crossroad Distributors Pty. Ltd.) | 
(Admin. by Crossroad Distributors Pty. Ltd.) | (Admin. by Crossroad 
Distributors Pty. Ltd.) | 
  Admin=SHOUT! Music Publishing/tCrossroad Distributors Pty. Ltd.
  Themes=Adoration/tBlessing/tChristian Life/tPraise
  Keys=G
  Fields=Verse 1/tVerse 2/tChorus 1/tVerse 3/tMisc 1
  Words=*

  
  Best regards,

  Aaron

To manage notifications about this bug go to:
https://bugs.launchpad.net/openlp/+bug/1391015/+subscriptions

___
Mailing list: https://launchpad.net/~openlp-core
Post to : openlp-core@lists.launchpad.net
Unsubscribe : https://launchpad.net/~openlp-core
More help   : https://help.launchpad.net/ListHelp

[Openlp-core] [Bug 1827792] Re: Bible Import Crashes OpenLP

[Phill]

This error is caused because we assume that the book name is the same as
that used in the url.

OpenLP gets the book name here:
https://bazaar.launchpad.net/~openlp-core/openlp/trunk/view/head:/openlp/plugins/bibles/lib/importers/http.py#L521
reading the content in the h4 tag, but in the case of the Chinese bible the 
book name does not match url component. Instead we should be getting that from 
anchor href tag:


https://www.biblestudytools.com/cuv/chuangshiji/;>
創世記


Unfortunately its not that quite simple as the http importers currently
make no provision for the url component being different to the book
name, and there's no column in the db to store it.

** Changed in: openlp
   Status: New => Confirmed

** Changed in: openlp
   Importance: Undecided => Medium

** Summary changed:

- Bible Import Crashes OpenLP
+ Crosswalk importer uses different urls to book names

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

Title:
  Crosswalk importer uses different urls to book names

Status in OpenLP:
  Confirmed

Bug description:
  OpenLP crash with the following error when using Crosswalk -> Chinese
  Union Version

  
  Traceback (most recent call last):
File "openlp\core\ui\wizard.py", line 216, in on_current_id_changed
File "openlp\plugins\bibles\forms\bibleimportform.py", line 632, in 
perform_wizard
File "openlp\plugins\bibles\lib\http.py", line 641, in do_import
File "openlp\plugins\bibles\lib\db.py", line 312, in get_book_ref_id_by_name
File "openlp\plugins\bibles\lib\db.py", line 878, in get_book_reference_id
File "openlp\plugins\bibles\lib\db.py", line 858, in run_sql
File "openlp\plugins\bibles\lib\db.py", line 839, in get_cursor
  sqlite3.OperationalError: unable to open database file

  Operating System: Windows 10 (32-bit)
  OpenLP version 2.4.6

To manage notifications about this bug go to:
https://bugs.launchpad.net/openlp/+bug/1827792/+subscriptions

___
Mailing list: https://launchpad.net/~openlp-core
Post to : openlp-core@lists.launchpad.net
Unsubscribe : https://launchpad.net/~openlp-core
More help   : https://help.launchpad.net/ListHelp