Number contents of "Adoru"

You are here

I'm starting to try to get a spreadsheet going for Adoru: Ekumena diserva libro, the 2001 Esperanto hymnal jointly published by IKUE and KELI, the leading international organizations of Catholic and Protestant Esperantists respectively. This is, as the title suggests, properly a service book and not just a hymnal, though it contains hundreds of hymns.

The Wiki says "Hymnary.org's practice has been to index everything in a hymnal that has a hymn number -- hymns, doxologies, musical responses, readings, etc." but while this sounds straightforward, it seems to assume that "a hymn number" is a whole number. In Adoru, however, a fair number of items have what amount to decimal numbers. While most of these are not hymns, some are. For example, on p. 907 the first item is numbered
531
("Estro de l' vivo, atentu pri mi." - a translation of the German "Herr meines Lebens" to be sung to SLANE), and the second item is numbered
531
     4

("Min lasu ĉe Vi resti." - a translation of the German "Laß mich dein sein und bleiben" to be sung to VALET WILL ICH DIR GEBEN [= ST. THEODULPH])

How should these numbers be handled? Will the Hymnary's software accept 531.4 as a hymn number?

I've put a tentative spreadsheet (about 50 rows of data) here, in Google docs so you can see what I'm talking about. The yellow-highlighted rows are the only ones that are actually hymns. This spreadsheet covers the first 42 pages of the book. Starting about p. 427, the hymnic content becomes much closer to 100% of the total content, and this continues for the most part through p. 1376.

Haruo = Leland


Comments

I just uploaded scans of 8 representative pages to illustrate the issue. Please look at the scans and the Google-doc spreadsheet and tell me if the system used in my test spreadsheet is the way to do this.

Also, when contents are numbered with more than 9 subordinate numbers, should they be entered as


150.8
150.9
150.10
150.11

(as they appear in the book) or do they need to be entered as


150.08
150.09
150.10
150.11

so that Excel will order them correctly (in my experience, sometimes Excel has alphabetized numerals so that unless leading zeroes are supplied as just above, 150.11 would be treated as preceding 150.2 in a list)?

The scans are located at
http://fremontbaptistchurch.org/evergreensings/scans/Adoru/Adoru_p18-p19.pdf
http://fremontbaptistchurch.org/evergreensings/scans/Adoru/Adoru_p36-p37.pdf
http://fremontbaptistchurch.org/evergreensings/scans/Adoru/Adoru_p38-p39.pdf
http://fremontbaptistchurch.org/evergreensings/scans/Adoru/Adoru_p714-p715.pdf

and the test spreadsheet, as previously noted, is here. Comments on other aspects of the test spreadsheet content/format (which covers the first two scans, the intervening material, and a little bit following) would be welcome. Before I do too much of this work, I'd like to be doing it right.

Haruo aka Leland

Yes, Hymnary.org can handle arbitrary strings as hymn numbers. In fact, the authority IDs used for hymns (e.g. "amazing_grace") are "hymn numbers" internally. Ordering is independent, so you wouldn't need to use 150.08 rather than the 150.8 that's printed in the hymnal -- you'd just need to specify the correct order in which the pages appear.

---------------
Harry Plantinga
CCEL Director

It looks like you are using an ad-blocker. Ad revenue helps keep us running. Please consider white-listing Hymnary.org or getting Hymnary Pro to eliminate ads entirely and help support Hymnary.org.