CCLI SongSelect Import does not accept username and password in OpenLP 2.4.6 with Windows 10

raoul

We are not a partner, and we don't use their API.

The reason we are not their partner is because they require a yearly license fee of (when I last spoke to them) $5000 in order to use their API, and they refused to accommodate us.

What OpenLP does is navigate through the SongSelect website. You're actually using the website, but it's hidden for you behind a nice user interface. Unfortunately because of how we do this, at times the website changes and OpenLP doesn't know how to handle the changes.

In OpenLP 3.0 we're probably just going to open an internal web browser so that you can log in and use the website from within OpenLP. Then you'll just click a button and OpenLP will import the song you want. Hopefully this will circumvent the login issues we are seeing at the moment.

niyaleon

raoul We are not a partner, and we don't use their API.The reason we are not their partner is because they require a yearly license fee of (when I last spoke to them) $5000 in order to use their API, and they refused to accommodate us.What OpenLP does is navigate through the SongSelect website. You're actually using the website, but it's hidden for you behind a nice user interface. Unfortunately because of how we do this, at times the website changes and OpenLP doesn't know how to handle the changes.In OpenLP 3.0 we're probably just going to open an internal web browser so that you can log in and use the website from within OpenLP. Then you'll just click a button and OpenLP will import the song you want. Hopefully this will circumvent the login issues we are seeing at the moment.

OpenLP doesn't partner with SongSelect due to their costly API fee. Instead, it navigates SongSelect's website, but changes can disrupt it. In OpenLP 3.0, they plan an internal web browser for smoother access.

Goinkey

Thank you.  That is the most logical answer to-date.

essergee

CCLI and SongSelect charge enough as it is. $5000 for API is just more dis-ingeniousness and probably MAC snobbishness. I betting Worship Extreme is heavily MAC/Apple slanted and Windows/Android users just get warm fuzzy feelings. I have paid the MediaShout fees for more than my small church can handle...hence I love OpenLP and so glad I found it. Got tired of being forced to pay to upgrade to something that did not function near as good for my needs as OpenLP. So on the subject of OpenLP v3.0, any possible projection on release?

raoul

@essergee we're pushing for a beta release in the next month or two. No one works on OpenLP full time, so we just work on it when we can. Sometimes real life takes priority and we can't work on what we want to.

essergee

I understand fully. I really like the chord functionality of the beta. Great work. Keep up the efforts. And people using free software cannot make complaints.

georgebryans

Can anyone give an update on this?

raoul

@georgebryans the latest release of OpenLP 3.0 is a Release Candidate. This means it should be stable enough for every day use, though not without a couple of bugs. In this version, the SongSelect import has been completely revamped.

FromOZ

@raoul - hello I am just curious if the OpenLP team had done anything specific for this requirement in a way which does not rely on the expensive (will not happen) CCLI API.

I mean there are ways to get at and parse the CCLI web page lyric content in Python. I'm looking at one of their song pages.

If there is nothing (yet) done specifically in OpenLP to address this are you interested?

FromOZ

Hi {"mention":{"name":"raoul","userID":2}} - is the above still the plan? Out of interest I setup Qt on my development machine (PyQt6) and got the tutorial book from Martin Fitzpatrick. I was surprised to see how simple (simple, not easy until one is familiar with PyQt of course) it was to make a simple browser app.

@raoul — scratch that I just installed the RC1 (2.9.4) version on my test Windows 10 VM (my main computer is macOS) and checked out the CCLI import. Looks great and very functional, the preview is nice. It's using QWebEngineView I guess.

Couple of suggestions:

Is the URL bar necessary? I mean given that it is meant to be locked into https://songselect.ccli.com/. Maybe the 'Back' button could go down to the bottom toolbar then it could function as a general back operation — return from Preview or go back a page in the website. I mean people are likely anyway to use the SongSelect 'Search' function to look for a song and if they choose one from the search list and want to go back then they can use the 'Back' button. But it's very unlikely they will need to see/use the URL address bar.I was able to get the URL entry widget active. It starts off disabled but if you go to a song, choose preview and then hit Back the URL widget becomes enabled. As the importer is modal it's (understandably) not possible to go to the main OpenLP window. It would be nice to be able to show the existing song list in a (?) side panel.If someone persists in importing a duplicate of an existing song then the confirmation dialog would be nice to say something like "Duplicate song imported, check the song database"

raoul

@FromOZ thanks for the observations and the suggestions! I don't think we're going to be able to get to all of them before pushing out 3.0, but we can definitely add them to our list of issues.

JohnnyFowler

If you have a copy of the data/songs previously used then you can copy ALL the folder data from openlp/data/songs from there into the 2.9.4 or 2.9.5 and the Songs will be there.

Johnny Fowler

TRB143

This has been resolved (for now) in the 3.1 rc2 release today. The changes have reduced the impact that future website changes will have on the importer.

It now should be possible to import songs and songs with chords.

Within the importer, you navigate to the page you wish to import and press the download icon on the web page. The Song is automatically downloaded and imported.

« Previous Page