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.
_______________________________________________
Mailing list: https://launchpad.net/~openlp-core
Post to : [email protected]
Unsubscribe : https://launchpad.net/~openlp-core
More help : https://help.launchpad.net/ListHelp
