Hoping to get some help from someone at Faithlife regarding our song history

At present, our Faithlife Presentation Team > Insights > Song History only displays one year of history, and the CSV download has the same range.

I would really like a copy of our entire song history, if possible, and was hoping someone at Faithlife would be able to access this from their side via the database. This is a one-time ask. Going forward the one year span will suffice.

I emailed support about this close to a month ago and never got a reply (aside from the automated one), so I thought I'd reach out here.

Thanks,

Benjamin Hodge

Find more posts tagged with

Comments

MJ. Smith

35 bump

Brian Burkhart (Faithlife)

Hello, Benjamin --

I'm sorry for the lack of response for your query...

I am not certain that we have a way to go back beyond a year with the reporting function. I will double check on that and will let you know what I uncover.

Best regards,
Brian Burkhart - Support@Faithlife.com
Faithlife - Technical Support Representative, Church Products

Brian Burkhart (Faithlife)

https://community.logos.com/discussion/comment/1137517#Comment_1137517

Hello, Benjamin --

I've passed this to our developers who confirmed that at present there is no ability to go back beyond a year with the reporting function.
They were a little curious about the request as we understood that the reporting period/frequency for CCLI is every six months.
Is there a particular reason that you need to go back past a year?

Best regards,
Brian Burkhart - Support@Faithlife.com
Faithlife - Technical Support Representative, Church Products

Benjamin Hodge

https://community.logos.com/discussion/comment/1137576#Comment_1137576

Hi Brian,

It's completely unrelated to CCLI reporting. We're a small church and I'm new to the role of worship leader. I was interested in the complete list of song titles for the purposes of having a list of every song the congregation is familiar with.

My hope had been that all data - all the way back to the beginning of our account - would be stored in a SQL database (or similar relational database) and that directly querying the database (by a developer) could achieve what I'm after. I do some SQL stuff for my day job. The servers we use have similar reporting functions that only displays by month or year, but the source data is all in a database and that goes back many years. Here's some pseudocode that might make sense to them.

SELECT * FROM (database.song_table_name)

WHERE song_table_name..(CustomerAccountNumber) = ############

A database query like that would hopefully return every song we've ever done. The results could be manually exported into a CSV file and emailed to me.