Importing Words of Worship

RyanT · June 2019

During testing OpenLP seems to be just about everything that we want from presentation software, but it will not convert my Words of Worship songs. I've managed about three of the 20 or so I have tried, and we have hundreds. The error ends with...

TypeError: ord() expected a character, but string of length 0 found

Any ideas? The songs play fine in WOW so I haven't a clue.

JohnM · June 2019

Sorry your having trouble with the conversion.....
What version of OpenLP are you running and on what OS?
and what version of WOW have you been using?

RyanT · June 2019

Sorry, I should've mentioned that in the original post!
OpenLP 2.4 running on the latest Raspbian, and 5.1.1.0 of WoW.

JohnM · June 2019

No problems....
I am still asking around about the issue....
Would you be willing to upload your WOW directory of songs if it comes to that?
If no one has any fixes, I might be able to try it on the latest development version of OpenLP and save the songs in a format you can use.

JohnM · June 2019

I just got feedback that we have a developer working on the WOW importer for the next version of OpenLP. I am going to send you a link to upload your WOW songs to.....and while this isn't a fix yet, we should be able to help.

phill · June 2019

Hi Ryan,
As luck (if you believe in it) would have it I've been working on the Words Of Worship importer of late. Would you be able to zip up your songs and send them to bugs@openlp.org ?

I need some more test files to confirm my fixes are working as expected. If so, I would be able to convert them for you.

RyanT · June 2019

My thanks to both of you - I have just emailed about 400 songs in a zip.

JohnM · June 2019

Ryan it looks like something is hung up, can you put the zip file in the ondrive directory I sent you earlier?
Thank You!

RyanT · June 2019

I'm trying, but the page isn't uploading the file I'm trying to drop onto it. Bear with me...

RyanT · June 2019

No, I cannot upload anything - not zip files, not individual songs.

JohnM · June 2019

now that just isn't how it is supposed to work....let me try again. just sent a request through onedrive....maybe that will work

JohnM · June 2019

Ryan that worked....we have the file!
Thank You! this is a big help.....give us a bit to see if we can give you something back that will work

RyanT · June 2019

Thanks, waiting with bated breath :-)

JohnM · June 2019

Ryan we may be in luck. Phil is seeing the an error on some files! Now that he can see an error, there is a good chance he can get a fix working....the bad news is that the fix will be part of the new version of OpenLP we hope to release later this year. Don't panic! once he has the fix working, he will export the songs in OpenLPxml format that you can import into your current version of OpenLP.....

phill · June 2019

@RyanT Could you confirm a few things for me please?

Do you have a song called "MP079 Christ, whose glory fills the skies," in Words of Worship?

Also do you manually put the title in the first verse and author / copyright in the last verse?

RyanT · June 2019

Yes, "MP079 Christ, whose glory fills the skies" is a song in the zip, and I think (although I didn't create them and don't have access to the software at the moment) the hymns have the title at the top, then underscores, then the verses, with underscores and author etc at the bottom.

phill · June 2019

@RyanT will you have access in the near future? Sunday?

Yes that MP079 file is in the zip, but the data in that file doesn't exactly follow all the rules that we have for reading Words or Worship files. My gut feeling is that it's been corrupted. Would you be able to check if that file can be opened in Words Of Worship?

RyanT · June 2019

I'll ask one of the other fellas who do the presentations and ask them to check.

RyanT · June 2019

I've been sent a screenshot and the text in a Word doc - I've uploaded it to the OneDrive folder. Cheers.

JohnM · June 2019

Ryan Thanks for the file.....Please go back to the OneDrive folder and download the new ZIP file 'WordsOfWorshipToUpload' with files you can upload into OpenLP 2.4.6 using the 'OpenLyrics or OpenLP 2 Exported Song' importer. The one song we could not import was 079....it's format is different than the rest of the songs. I hope this helps you get up and running.....and yes we are still working to fix the upload issue!

RyanT · June 2019

That is absolutely fantastic, thanks! They all imported fine and the ones I have looked at are perfect. I just have another couple of of songs to convert ;-) I hope there isn't too long a wait until the next version. Cheers.

RyanT · June 2019

Actually, I've noticed (in eg song 325) that there are {minor} tags being shown.

{minor}Mission Praise - 325{/minor}

{minor}______________________{/minor}

I'm special because God has loved me,

For He gave the best thing that

He had to save me;
...

To know deep in my heart

That I'm Your special friend.

______________________

{minor}Graham Kendrick{/minor}

JohnM · June 2019

Ryan we noticed the "minor" tags also and had thought your group was using them.....if they are an error, please let us know....

RyanT · June 2019

I think they're used by Words of Worship to whether the font should be bold. I think the default is bold unless you tell it otherwise, and I think we use that option for the header and footer text we add.

JohnM · June 2019

Ryan
You can get the same results in OpenLP. You would need to set the font in the Theme to bold. This section of the manual shows how to set the font to bold. You would have to set the font in the main area to bold. Then I would suggest you create a custom formatting tag. You can find the information in the online manual.

Here is the information for the 'minor' Formatting Tag:
Description = 'Normal Font'
Tag = 'minor'
Start HTML = '<span style="font-weight:normal;">'
End HTML = '</span>'

This will allow your imported songs to work like they did in WOW and any new songs you import you can use the same process of setting the header and footer to non-bold text.

Thank you for your help with this issue and let us know how this goes.

RyanT · June 2019

Thanks very much for all your help!

Importing Words of Worship

Comments