... | ... | @@ -7,44 +7,55 @@ Sure it would! I hope to explain how you can do this. But first a warning! |
|
|
**Check the Bible Copyright to see if you are allowed to make any changes to the Bible!**
|
|
|
Bibles are either in the Public Domain or the copyright is owned by the folks that created the translation. Some copyrights will allow you to write notes in the margins and some don't even want you to do that! All copyrights do not allow you to give copies of the Bible to anyone after you modify the bible! So check out the copyright so no copyright police come and knock on your door!
|
|
|
|
|
|
For the rest of this page I am going to use the American King James Version of the Bible...This Bible is in the Public Domain so there are no copyright restrictions to worry about. I am also starting with the Bible already loaded in OpenLP.
|
|
|
For the rest of this page I am going to use the English Standard Version of the Bible...This Bible is in the Public Domain so there are no copyright restrictions to worry about. I am also starting with the Bible already loaded in OpenLP.
|
|
|
|
|
|
OpenLP allows you to add a Bible, remove a Bible, edit the metadata of a Bible...it does not allow you edit the actual Bible or export it.
|
|
|
|
|
|
Step 1 is to make a copy of the OpenLP KJV Bible.
|
|
|
a.) Locate the OpenLP data directory.
|
|
|
b.) Open the Bible directory.
|
|
|
c.) Copy the KJV.sqlite file.
|
|
|
d.) Create a new directory in your Documents directory.
|
|
|
e.) Paste the copied file into the new directory.
|
|
|
Step 1 is to make a copy of the OpenLP ESV Bible.
|
|
|
1. Locate the OpenLP data directory.
|
|
|
1. Open the Bible directory.
|
|
|
1. Copy the ESV.sqlite file.
|
|
|
1. Create a new directory in your Documents directory.
|
|
|
1. Paste the copied file into the new directory.
|
|
|
|
|
|
Step 2 is to export the OpenLP Bible to a Comma Separated Value(CSV) file. OpenLP uses SQLITE databases. To export a SQLITE database you will need to use a database browser.
|
|
|
a.) Open the [online SQLITE browser](https://sqliteonline.com/).
|
|
|
b.) Use the ***File->OpenDB*** menu option to open the copy of the database.
|
|
|
c.) Double Click on the table titled 'book' in the left column. The center of the SQLITE browser window should now show the columns of the 'book' table with a few rows of data.
|
|
|
d.) Enter '' as the sql command and press the 'run' button.
|
|
|
Select the *Export* dropdown menu to select 'Table to CSV'
|
|
|
e.) Verify the settings for the export are:
|
|
|
1) Type = CSV
|
|
|
2) Delimiter = ,
|
|
|
3) Escape = "
|
|
|
4) Column Name = NONE
|
|
|
f.) click on the 'OK' button and a file will be downloaded to your PC.
|
|
|
g.) Move the file from your download directory to the directory with the copied database.
|
|
|
h.) Rename the file to 'books.csv'
|
|
|
i.) Switch back to the database browser and go through the same process choosing the 'verses' table, using 'SELECT book_id, chapter, verse, text FROM verse'as the SQL command and renaming the downloaded file to 'verses.csv'
|
|
|
j.) Close the database browser window.
|
|
|
1. Open the [online SQLITE browser](https://sqliteonline.com/).
|
|
|
1. Use the ***File->OpenDB*** menu option to open the copy of the database.
|
|
|
1. Double Click on the table titled 'book' in the left column. The center of the SQLITE browser window should now show the columns of the 'book' table with a few rows of data.
|
|
|
1. Enter '' as the sql command and press the 'run' button.
|
|
|
1. Select the *Export* dropdown menu to select 'Table to CSV'
|
|
|
1. Verify the settings for the export are:
|
|
|
`Type = CSV
|
|
|
Delimiter = ,
|
|
|
Escape = "
|
|
|
Column Name = NONE`
|
|
|
1. Click on the 'OK' button and a file will be downloaded to your PC.
|
|
|
1. Move the file from your download directory to the directory with the copied database.
|
|
|
1. Rename the file to 'books.csv'
|
|
|
1. Switch back to the database browser and go through the same process choosing the 'verses' table, using 'SELECT book_id, chapter, verse, text FROM verse'as the SQL command and renaming the downloaded file to 'verses.csv'
|
|
|
1. Close the database browser window.
|
|
|
|
|
|
Step 3 is to cleanup the exported file. The export is plain text and we will need all text inside quotes.
|
|
|
a.) Open the 'books.csv' file using your spreadsheet program of choice.
|
|
|
b.) Enter the book name abbreviations in the column to the right of the book names.
|
|
|
c.) Save the file as a spreadsheet. You will find that saving the file as a spreadsheet allows you to choose the options when saving as a CSV.
|
|
|
d.) Save the file as a CSV with quotes around the text and the separator needs to be a comma. I suggest you put the number 1 at the start of the filename....this keeps the original export from the database as a backup just in case something goes wrong!
|
|
|
e.) Open the 'verses.csv' file using your spreadsheet program of choice.
|
|
|
f.) Save the file as a spreadsheet. You will find that saving the file as a spreadsheet allows you to choose the options when saving as a CSV.
|
|
|
g.) Save the file as a CSV with quotes around the text and the separator needs to be a comma. I suggest you put the number 1 at the start of the filename....this keeps the original export from the database as a backup just in case something goes wrong!
|
|
|
1. Open the 'books.csv' file using your spreadsheet program of choice.
|
|
|
1. Enter the book name abbreviations in the column to the right of the book names.
|
|
|
1. Save the file as a spreadsheet. You will find that saving the file as a spreadsheet allows you to choose the options when saving as a CSV.
|
|
|
1. Save the file as a CSV with quotes around the text and the separator needs to be a comma. I suggest you put the number 1 at the start of the filename....this keeps the original export from the database as a backup just in case something goes wrong!
|
|
|
1. Open the 'verses.csv' file using your spreadsheet program of choice.
|
|
|
1. Save the file as a spreadsheet. You will find that saving the file as a spreadsheet allows you to choose the options when saving as a CSV.
|
|
|
1. Save the file as a CSV with quotes around the text and the separator needs to be a comma. I suggest you put the number 1 at the start of the filename....this keeps the original export from the database as a backup just in case something goes wrong!
|
|
|
|
|
|
Step 4 is to verify your csv files are able to be uploaded into OpenLP
|
|
|
a.) Start OpenLP
|
|
|
b.) Select Bible from the 'File->Import' menu.
|
|
|
c.) Use the Wizard to import a CSV Bible using the two files you saved from the spreadsheet program. |
|
|
\ No newline at end of file |
|
|
1. Start OpenLP
|
|
|
1. Select Bible from the 'File->Import' menu.
|
|
|
1. Use the Wizard to import a CSV Bible using the two files you saved from the spreadsheet program. The files should upload without any errors....if you have errors you will have to troubleshoot until you get a clean upload.
|
|
|
1. Shut down OpenLP and remove the bible sqlite file you just ceated from the Data/Bibles directory.
|
|
|
|
|
|
Step 5 is to modify the verse file to add different attributes to the Verses.
|
|
|
|
|
|
**Adding Chapter Titles**
|
|
|
|
|
|
**Adding sub titles**
|
|
|
|
|
|
**Adding Verse Notes**
|
|
|
|
|
|
**Adding Commentary** |