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

Benjamin Hodge
Benjamin Hodge Member Posts: 8 ✭✭
in Proclaim Forum

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

Comments

  • MJ. Smith
    MJ. Smith MVP Posts: 55,538

    35 bump

    Orthodox Bishop Alfeyev: "To be a theologian means to have experience of a personal encounter with God through prayer and worship."; Orthodox proverb: "We know where the Church is, we do not know where it is not."

  • Brian Burkhart (Faithlife)
    Brian Burkhart (Faithlife) Member, Logos Employee Posts: 37

    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)
    Brian Burkhart (Faithlife) Member, Logos Employee Posts: 37
    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
    Benjamin Hodge Member Posts: 8 ✭✭
    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.

Categories