openlp-core team mailing list archive

[Frederic William Beck <question154577@xxxxxxxxxxxxxxxxxxxxx>]

New question #154577 on OpenLP:
https://answers.launchpad.net/openlp/+question/154577

I appreciate the great work you have done making OpenLP such a useful tool.

I would like to ditch our old, self-made worship program "Gospel" and continue with OpenLP. So far, I have manually copied lyrics of individual songs over from the old song DB before each service. Since there are about 300 songs, I would like to convert the old DB. I was wondering if those who have experience with writing import filters could give me a clue how I might be able to transform our existing song database into a format that OpenLP can import.

The existing songs are all stored in a single table in Access MDB format with no references to other tables. So I can have it available as CSV, HTML, Excel XLSX, Excel XML, or even SQLite table, but always in the same structure that I'm stuck with and need to change to a format that OpenLP can work with:


Table: Gospel                                                                                        Page: 1

Columns

         Name                                                  Type                        Size

         id                                                    Long Integer                             4
         LiedNr                                                Long Integer                             4

         Titel                                                 Text                                   100
         Refrain                                               Memo                                     -
         Strophe01                                             Memo                                     -

         Strophe02                                             Memo                                     -
         Strophe03                                             Memo                                     -
         Strophe04                                             Memo                                     -

         Strophe05                                             Memo                                     -
         Strophe06                                             Memo                                     -
         Strophe07                                             Memo                                     -

         Strophe08                                             Memo                                     -
         Strophe09                                             Memo                                     -
         Strophe10                                             Memo                                     -

         Strophe11                                             Memo                                     -
         Strophe12                                             Memo                                     -
         Strophe13                                             Memo                                     -

         Strophe14                                             Memo                                     -
         Strophe15                                             Memo                                     -
         Strophe16                                             Memo                                     -

         Strophe17                                             Memo                                     -
         Strophe18                                             Memo                                     -
         Strophe19                                             Memo                                     -

         Sequenz                                               Text                                    50
         Sprache                                               Text                                     1



The verses are all in their own column - Refrain (basically Chorus) and Strophe01 through Strophe19 (Verse 1 - Verse 19).
Within a Chorus/Verse field, line breaks are CR+LF. Some fields can probably be disregarded for OpenLP: id, LiedNr (just unique record or song numbers), and Sprache (language, at the moment either "E" for English, "D" for German, or "S" for Spanish or other languages).

I was thinking that perhaps this table in Excel XML format can be transformed to fit the OpenLyrics format - but I have no experience with scripts or with XSLT or whatever approach might be able to do this.

What's the best apprach to this?


Thanks

Fred Beck
Audio/visual director
Internation Bible Fellowship
Buchs, Switzerland

-- 
You received this question notification because you are a member of
OpenLP Core, which is an answer contact for OpenLP.