Planning Center Integration

Why can’t I import songs from Planning Center?

Hey, not sure what you mean by export songs from Planning center? (I’m not familiar with the product, but it sounds more of a Planning Center question than a Quelea question at the moment.)

I’m so sorry. I had a wrong question. There is an option to import songs from Planning Center Online. I have logged in but for some reason, it does not work.

No worries - I’m afraid we can’t really help with that though as the planning centre integration was written by an external contributor, and we don’t have a planning centre account to test it with.

If other use the planning centre import option, they may be able to wade in and help however :slight_smile:

1 Like

Thank you! Planning Center is really a big help to our church ministry. There we schedule people and send out our set list for Sunday (including chords for musicians and lyrics for vocalists).
The integration would be helpful because we would not have to input songs in Planning Center AND Quelea. Considering we are a small church with minimal manpower.

I’m still exploring Quelea’s potential as a Church Presentation software.
I highly recommend Planning Center, too. We’ve been using it for months now, though it has been around for years.

I have the same issue, impossible to log into my plannigncenter account and so no way to import song from there.

1 Like

we also use Planning Centre, and cannot import.
I think that the songs need to be set up correctly in Planning Centre before they will import, but I haven’t yet figured out what that is.

1 Like

as the planning centre integration was written by an external contributor

Could you point me to the source code for that module?
Perhaps I can figure out what is required.
When you open the menu item to import from “Planning Centre Online” I am able to log in, but no songs are in the list, and there doesn’t seem to be an option to retrieve the list.
There are 107 songs in our PCO database, so there should be some way to connect them

Thanks!

Sure:

https://github.com/quelea-projection/Quelea/blob/master/Quelea/src/main/java/org/quelea/services/importexport/PlanningCenterOnlineParser.java

I had a look, but I can’t see what could be changed. I’ve asked Planning Centre for information, but from the log it appears that the current tool is working, but just not finding anything.

Sep 27, 2019 10:05:33 AM org.quelea.services.importexport.PlanningCenterOnlineParser getJson
WARNING: Error
Unexpected token END OF FILE at position 0.

I suspect that my PCO database is missing something, but at this point I don’t know what.

My guess is that Planning Center has changed how the data is accessed since this feature was added to Quelea. Looking at the API versions there seems to be a new version from February and my guess is that they made some breaking changes there.

Edit: Just noticed that the link refers to the “API about the Planning Center API”, so the version number might be irrelevant in this case. Either way, I still believe that Planning Center might have made some breaking changes. Don’t know if in Quelea the data is collected by web scraping (which is very sensitive to changes) or by using the official API, but either way it’s likely that we would need to adjust our code based on their changes for it to work. But as Michael wrote, without an account it’s difficult for us to resolve it.

I have further information that may bear on this issue.
In the docs:


there is a line that says, " First, make sure you have setup a [download path for additional files]"
(https://quelea-projection.github.io/docs/Import_Export).

I can find no place to set up such a download path.

I’m hoping that once I have that, then things may start to work…

Sorry for the late replay, haven’t been able to do any work for Quelea in quite some time. It seems that the tab for setting up the download path was removed from the options dialog but that we never moved it somewhere else. You could always try manually setting the download path by adding the line download.path=... in the quelea.properties file to see if that is where the issue lies.

Thanks!
I’ll give it a try when (if) we’re back to meeting as a group

Has anyone made this work? We use Planning Center extensively and we’re at a point that in order to use a worship presentation it must work with Planning Center.
I have tried everything stated in this topic with no avail.

If anyone had success please share the info on how to make it work.

Thank you

Not as of yet - but I notice Planning Center now offer a trial, so I’ve signed up for that and I’ll make it my job to see if I can sort this out once and for all for 2020. I’ll aim to get back to you by the end of this week with an update.

No point having an integration with something that doesn’t work!

Right, I’ve done some initial digging & started work on fixing this. More details here (https://github.com/quelea-projection/Quelea/issues/260) but the long and short of it is that this functionality will be in the next 2020.0 beta release, so please keep an eye out for that!

1 Like

This is now in the latest beta: https://github.com/quelea-projection/Quelea/releases/tag/v2020.0-beta-2

Awesome, I will give this a try. Thank you Berry