danthedeckie / OpenLP-To-ProPresenter5-Converter

A small simple converter from OpenLP to ProPresenter5
18 stars 9 forks source link

Problem with OPENLP_DATABASE #4

Closed juandaho closed 7 years ago

juandaho commented 8 years ago

Hello,

I tried to compile a file OpenLP, but I get the following error:

Loading Database:    /Users/juandaho/songs.sqlite

Sorry - There was a problem loading the OpenLP Database. (/Users/juandaho/songs.sqlite) Maybe OpenLP is not set up on This user?

If you know Where the database is, you can edit the path at the top of this script and in September it manually.

Converter.py file I have the following configuration:

Configuration Options:

OPENLP_DATABASE = "/Users/juandaho/songs.sqlite" Output_directory = "/ tmp /"

I clarify that both file songs.sqlite converter.py like I have it in my folder / Users / juandaho

I appreciate your help, because I know that more must fix. Thank you very much.

bigj6360 commented 8 years ago

I have this same issue, even with a fresh, unedited, converter.py

I should say that I am running the latest OS X version of openLP (2.4. downloaded Oct. 1, 2016)

When importing the database from OpenLP version 2.2 I can get a portion of the library to import. Here is the error produced:

OpenLP to Pro-Presenter 5 converter.

Loading Database: /Users/sanctuary/Desktop/songs.sqlite

Cool. 1444 songs loaded.

And writing the new files to /tmp/

Traceback (most recent call last): File "./converter.py.orig", line 370, in main() File "./converter.py.orig", line 344, in main for v in ParseLyric(song['lyrics'])]) IndexError: list index out of range

61ue5peed commented 7 years ago

@bigj6360 and @juandaho the fix is to remove one of the fields in the query: remove "song_number" In line 275 and it will work.

juandaho commented 7 years ago

Hi, It worked for me. Thank you so much