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

Page 1 of 1 (5 items)
This post has 4 Replies | 2 Followers

Posts 7
Benjamin Hodge | Forum Activity | Posted: Fri, Nov 13 2020 11:26 AM

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

Posts 31278
Forum MVP
MJ. Smith | Forum Activity | Replied: Sat, Nov 14 2020 11:29 PM

35 bump

Orthodox Bishop Hilarion Alfeyev: "To be a theologian means to have experience of a personal encounter with God through prayer and worship."

Posts 33
LogosEmployee
Brian Burkhart (Faithlife) | Forum Activity | Replied: Wed, Nov 18 2020 11:18 AM

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

Posts 33
LogosEmployee
Brian Burkhart (Faithlife) | Forum Activity | Replied: Wed, Nov 18 2020 2:15 PM

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

Posts 7
Benjamin Hodge | Forum Activity | Replied: Wed, Nov 25 2020 3:11 AM

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.

Page 1 of 1 (5 items) | RSS