I have used the CCLI database extensively over the last few years.
The CCLI database is made for the benefit of songwriters and the royalty companies -- not us.
That is why the CCLI database remains closed.
That is why song lyrics in each and every song is so poorly organized -- chorus first always????? how stupid. Pre-chorus? Never exisited until last year. Marked as Misc. Bridge? Marked as Misc. Chorus 2? Marked as Misc most of the time.
In short, even if you COULD automatically import the entire CCLI database, EACH and EVERY SONG would have to be manually corrected.
For now, I'll continue doing it the old-fashioned way: cut-and-paste-and-fixing-it.
Sorry, welcome to CCLI Reality Class 101.
P.S. Some commercial lyric projection software are able to link to CCLI so that once you find a song you can import it easily into your software -- i.e. automatic cut-and-paste. However, the problem with ehse commerical packages is that they normally don't EXPORT songs, meaning you aren't able to SHARE you song database with others.
Can you tell us which commercial programs? I'd like to see if I can intercept their HTTP requests and perhaps figure out what they're doing. Perhaps we can then reverse engineer it, although how legal that is might determine whether or not we implement it.
I have been working on and off on an import tool for CCLI's SongSelect. My tool is currently PHP based, utilizing curl to grab data from their web site.
I spoke with the VP of IT at CCLI a few weeks ago to verify that I was not breaking any rules by trying to grab such data. In short, I am not. CCLI has an understanding with the publishers that any CHURCH may use any tool they wish to access and retrieve data from the SongSelect database. The problem with the agreement between CCLI and the publishers is that CCLI is forbidden at the moment to assist developers in retrieving that data. Basically, they can tell us that we can get the data, but not how.
The thing to keep in mind is that they only allow the import of CCLI information from the church holding the CCLI license. You can't obviously distribute a program with CCLI songs within it. Nor can you develop a program that hosts CCLI songs for access by churches.
In openlp's case, it would be fine with them to write a program that will take a user's CCLI username, password and then import songs to their openlp installation.
At any rate, you would be most welcome to the bit of jibberish I have begun scripting to import items from CCLI. I have by no means completed it, but have a handle on a portion of it. I have written it in PHP for a project that I and another guy are working on called "openworship". We are hoping to build a program similar in scope to planningcenteronline.com and other ministry planning tools and tying it into openlp (as that is what my church is currently using). We also have some of the basics already in place to work with OpenSong. Anyways, you can email me at landersk (at) gmail (dot) com if you would like.
Thanks,Kevin L.PS - CCLI is hoping to work out a deal with the publishers within a year or so to develop an API. At the moment, of course, they are not allowed to do so.
Ah yes, I remember having a quick look at the openworship site, although at that stage there wasn't much there (why not use Python, rather than PHP?).
Thanks for that information, it's very helpful. I'd definitely be keen on taking a look at that script of yours.
i must be hearing things - ccli change the authors lyrics to put the chours first ? and people put up with it ? what reason do they give ? why would anyone do such a stupid thing - there must be a reason to do with how one of the software works or something .... but even then ??
apologies ( and this is my first post - please forgive me ) but i find it a sinister display of arrogance to change someone else's song - think about it.
i only last week recommened songselect to our worship leader - but i wouldnt have if i had known this - i would dearly love for someone to write back to here and tell me that i have misunderstood, or that the issue has been changed ... please
[ yes notwithstanding the obvious issue of the nuisance edit -- which by the way is particularly more awkward for us than in a usual setup - for very long and complicated reasons that i wont bore you with]
apologies once more if i appear OTT
the OpenLP version 1.2.2 contains a new feature to import song lyrics from CCLI's SongSelect. Have a look at http://openlp.org/en/download.html
You mentioned that CCLI changed the order of chorus and verse in a certain song. They normally take the songs straight out of songbooks without making any changes. Have you contacted them to tell them about this. Maybe it was a mistake - or there is a reason for it.
We like SongSelect a lot and the new import feature in OpenLP is great!