User talk:Kkroon
Verified Editions
That sounds good Kkroon. What is this feature on your spreadsheet program - concaterate? - what does it mean and what does it do? Bobnotts 04:41, 4 October 2006 (PDT)
Kurtis replies: CONCATENATE takes all its parameters and chains them together in the order given. The word comes from (Vulgar?) Latin concatenare: con "together" + catena "chain" + verbal ending. So, "to chain together".
Here's how I use it: in my spreadsheet program, I list page titles in column A, and CPDL IDs in column B. In column C, I type:
=CONCATENATE("[[",A2,"|",B2,"]]<br>")
For a more concrete example, say cell A2 contains the text "Margot labourez les vignes (Jacob Arcadelt)", and cell B2 contains "687". The concatenate function strings everything together with the pertinent wiki markup ([[ | ]]), and writes [[Margot labourez les vignes (Jacob Arcadelt)|687]]<br> in cell C2. I copy this from my spreadsheet and paste it into the page I'm editing, and the Wiki does the rest.
I don't actually retype the function each time: instead, I use my spreadsheet's fill function (Edit > Fill ... > Down).
I hope this explanation helps ... and I can send you my spreadsheet if you want.
Kkroon, 2006-10-21
Verified Editions
Oh and by the way, at least some of the editions that you said you couldn't find are on CPDL. Try typing #602 into the search box. Bobnotts 05:12, 4 October 2006 (PDT)
I didn't say that this method was flawless. I should have said "it's better than stabbing blindly in the dark". Kkroon 21 October
Genre categories and Christmas
I changed the genre category for Ich steh... (Bach) from Category:Uknown_genre to Category:Carols - which is how this work should be classified. It might help for you to check the ChoralWiki:Music Subcategories page to see what relevant categories already exist. I hope this helps, because your efforts are much appreciated.
As for the new Christmas category you've created, we have been reluctant in the past to launch a Category:Christmas_music several reasons: (1) there is the question as to whether Advent and Epiphany music should be included (such works often appear on "Christmas concerts" or are sung in church services at or near Christmas; (2) there is the question of whether we should also similarly categorise such seasonal music as Easter music, Lenten music, Ascension Music, Pentecost music (you get the idea); (3) the sheer quantity of such Christmas music is enormous, and hence it has been felt that launching such a category for Christmas (and/or categories for other seasonal music) should only be attempted when we can expect a commitment of (probably several) volunteers to devote concentrated energy to the arduous task fleshing out such a category as completely as possible.
In the meantime the Category:Carols captures most of what people are looking for, and indeed your new Category:Christmas only has two entries which are also correctly categorised as Carols.
OF COURSE, if you are intending to spend a LOT of time categorizing Christmas music ...
Cheers! ChuckGiffen 07:51, 30 October 2006 (PST)