Sourcing Bibles

This page is out-dated.

Introduction
Bibles in openlp.org 2.x have a file extension of .bible3. This differs from openlp.org 1.x where the suffix is only .bible. The main reason for this change in file extension is due to the fact that openlp.org 2.x uses SQLite 3 databases, where as the openlp.org 1.x files are all SQLite 2.8 databases.

Sword Bible Software
There are two OSIS bibles (exported from Sword) in the openlp-2/resources/bibles directory in the repository. New bibles can be downloaded over the internet using the Sword software.

mod2osis > name.osis   :Note the is case sensitive on all environments.
 * 1) After using the Sword software Media Manager to download the required bible.
 * 2) From the command line (works on Windows and Linux)


 * 1) Start OpenLp and select the Bibles Verses in Media Manager
 * 2) Select "New Bible"
 * 3) Select "File Import Page"
 * 4) Enter a Bible name
 * 5) Select the OSIS file either key the path and file name by hand or use the file lookup button
 * 6) Enter text in the version, copyright and permission fields
 * 7) Press the Save button.
 * 8) The progress bar will keep you informed of progress.

Web Downloads from Crosswire
Openlp 2.x has the ability to download required fragments of bibles over the internet and store theses fragments in a bible specific database. Once the bible has been registered it will be available within the "Quick Search" tab. If the "Verse" search for identifies that a Bible chapter is required and is not available in the database the database will be updated automatically if the computer is connected to the internet. This chapter will then become available locally for further searches. The "Advanced Search" Tab is unable to use Web Downloaded bibles as it has no understanding as to what state the bible is in.

openlp.org 1.x Conversions
Bibles need to be converted from Sqllite2 to Sqlite3 format. This needs to be done by dumping the data from the existing database.

SQLite on Windows
A SQLite 2 binary executable can be found at http://www.ch-werner.de/sqliteodbc/. Download and install it. If you get a virus warning (which is a false alert) which prevents installation, then try downloading an older version.

You also need to download and install SQLite 3 from the SQLite web site or one is provided with the above download.

SQLite on Linux
On Ubuntu Linux systems, you need to install the  and   packages. Apparently Fedora doesn't have SQLite 2 in it's repositories, so you'll have to work around it by using the Windows SQLite 2 binary under Wine. timali@tigger3:~ $ wine "C:\Program Files\SQLite ODBC Driver\sqlite.exe"

Converting the Bible
Run the following command to convert the Bible files from version 2 to version 3:

raoul@animal:~ $ sqlite kjv.bible .dump | sqlite3 kjv.sqlite   <<<< replace kjv with each of your bibles.

The migration utility will automatically make any necessary changes to the database structures.