Convert zionworx 2014 database

bogbrush

Hi Can anyone help with this please?
I'm new to Linux so need simple explanations.
I need to convert the Zionworx 2014 database to import into OpenLP. I have access to the Database but not to Zionworx 2014 since removing windows 10 which was driving me up the wall.

Many thanks in anticipation

Malc.

tgc

Have you tried following the guide in the manual? http://manual.openlp.org/songs.html#importing-from-zionworx

bogbrush

Have you tried following the guide in the manual? http://manual.openlp.org/songs.html#importing-from-zionworx
Thanks for this tgc. Yes I have but it doesn't work. The file is too fragmented in it's lay out in that the songs break up across different columns and cells so you get loads of errors when trying to re import into Open LP. They are not for version 2014 which does not contain MainTable.Dat or Data.tdbd.

I was hoping there is another way to do it which does not involve completely re writing all the songs or csv file.

tgc

Would it be possible for you to email the zionworks db files to support at openlp.org? Then we could have a closer look at the changes.

bogbrush

Hi tgc sorry not been around for a while. I think I've solved the problem albeit long windedly.

There was a file in our drop box with all the song words in it in HTML format. I progressively worked through the file and stripped out the HTML stuff and left 5 lines between each song. I then saved the file as a txt file. Actually I broke it down into alphabetical text files and then deleted the existing song database in OpenLP. I then imported the songs using the 'Generic Document/presentation option. All imported without difficulty. I then exported the database to have each song in xml format. There may be another way of doing it which is not so labour intensive but it worked for me.

Thanks for your support.

tgc

@bogbrush: Good to hear you solved the issue! But we would still like a copy of your song db so we can see if we can create an importer for the new format :-)