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.
Comments
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.
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.