Apps by Arlomedia

BandHelper => Schedule Help => Topic started by: Chris on March 29, 2019, 04:56:51 AM

Title: Consolidated events overview of different projects
Post by: Chris on March 29, 2019, 04:56:51 AM
Hi arlo,

planning to move to a pro-account but there is one question that strikes me:

the widgets are currently designed to only show the data of one single project.
Is there a way to have data of multiple projects consolidated in an overview? Maybe meaning that a php-query would be needed instead of directly using the widget?

Background is that I am singing in various bands and would like my website to show all events I participate in regardless of the band they are connected to (each band is a separate project in my account).

Regards, Chris
Title: Re: Consolidated events overview of different projects
Post by: arlo on March 29, 2019, 01:24:33 PM
This is not currently possible. You would have to display the events in separate sections on your website, one for each project.

I have a wish list item to return a JSON string, in which case you could add your own code to combine the data from each project and display it. Would that be helpful to you (i.e., would you know how to work with that)?
Title: Re: Consolidated events overview of different projects
Post by: Chris on March 29, 2019, 01:52:13 PM
My preferred way would be the ability to have a DB-query via php but if JSON is the intended option, I would try to dig myself into that instead.
So +1 from me on this entry of the wishlist
Title: Re: Consolidated events overview of different projects
Post by: arlo on March 29, 2019, 06:35:39 PM
Got it. That would be more secure and more modular than allowing people to run queries directly on the database.
Title: Re: Consolidated events overview of different projects
Post by: Chris on April 02, 2019, 03:14:18 PM
Appreciated. Looking forward to your implementation   :D
Title: Re: Consolidated events overview of different projects
Post by: Chris on June 12, 2019, 11:49:23 AM
Hi arlo,

was wondering if you already have a "beta"-version of the JSON-string set up?

Regards,
Chris
Title: Re: Consolidated events overview of different projects
Post by: arlo on June 12, 2019, 02:01:37 PM
No, this is still on my wish list.
Title: Re: Consolidated events overview of different projects
Post by: Chris on June 12, 2019, 03:11:46 PM
Thanks for the update
Title: Re: Consolidated events overview of different projects
Post by: JerryK on June 13, 2019, 06:08:19 AM
Chris:
As a User of Google Cal, I can see many calendars at once.  It may be that you can set up a shared calendar for each project and display them concurrently, as one calendar view on your web page.
Title: Re: Consolidated events overview of different projects
Post by: Chris on June 13, 2019, 06:16:48 AM
Hi Jerry,

thanks for the idea.
Already thought about that option and I have set up an iCal-feed in my calendar already to have all my projects show on there.
But for my webpage, I do not consider it working as it would show all gigs (even the non-confirmed or non-public ones which I want hidden).
Or am I missing a filtering option I could use to prevent those from showing?

Regards,
Chris
Title: Re: Consolidated events overview of different projects
Post by: arlo on June 13, 2019, 09:07:13 AM
No, the iCal feed is meant for internal use and shows all events.
Title: Re: Consolidated events overview of different projects
Post by: Chris on June 13, 2019, 11:06:05 AM
I played around a bit with the widget you already provide, arlo, and I must say that it already suits my needs from a details- and formatting-perspective.
Might it be easier for you to allow a widget selecting events based on a Bandhelper-user (i.e. login) before creating a new JSON-feed on the long run?

I could imagine the connected database-request to check for the username instead of the project-number (which I assume is the current way it works).
If this would be an option indeed and you need somebody for testing, I will gladly volunteer :)
Title: Re: Consolidated events overview of different projects
Post by: arlo on June 13, 2019, 11:11:56 AM
Okay, I'll put that on my wish list as an alternative.
Title: Re: Consolidated events overview of different projects
Post by: Chris on June 17, 2019, 07:27:51 AM
Hi arlo,

quick question: the widget on my webpage still shows a gig that took place yesterday regardless if I add the 16th as the end-date or not. Should I raise a ticket or did I set the event wrongly?

Regards, Chris
Title: Re: Consolidated events overview of different projects
Post by: arlo on June 17, 2019, 09:37:24 AM
Unless it's a multi-day event, you can leave the end date empty. Does that make a difference?
Title: Re: Consolidated events overview of different projects
Post by: Chris on June 17, 2019, 12:06:51 PM
That was actually the initial setting. I added the end-date as I thought this might make a difference.
Also after withdrawing the end-date again, the event is still showing in the widget.
Title: Re: Consolidated events overview of different projects
Post by: arlo on June 17, 2019, 12:32:10 PM
Okay. I bet if it's still showing yesterday's gig, it will disappear at the end of today. That could be a time zone issue.
Title: Re: Consolidated events overview of different projects
Post by: Chris on June 17, 2019, 12:35:43 PM
Already assumed that. Will keep an eye on it  :)
Title: Re: Consolidated events overview of different projects
Post by: Chris on June 18, 2019, 06:42:49 AM
Okay. I bet if it's still showing yesterday's gig, it will disappear at the end of today. That could be a time zone issue.

Totally right. Event was gone this morning (GMT+1 that is).

Cheers
Title: Re: Consolidated events overview of different projects
Post by: arlo on June 18, 2019, 03:41:56 PM
Okay, I'll put that on my to do list.
Title: Re: Consolidated events overview of different projects
Post by: Chris on June 19, 2019, 09:35:04 AM
I played around a bit with the widget you already provide, arlo, and I must say that it already suits my needs from a details- and formatting-perspective.
Might it be easier for you to allow a widget selecting events based on a Bandhelper-user (i.e. login) before creating a new JSON-feed on the long run?

I could imagine the connected database-request to check for the username instead of the project-number (which I assume is the current way it works).
If this would be an option indeed and you need somebody for testing, I will gladly volunteer :)

Until you find the time for implementing one of the alternate options, I am using a separate project functioning as a "gig-overview" only. As I can add each event to multiple projects, I simple add all of them to the overview-project and use the connected widget.
Not sure why I did not come up with that idea earlier...

Cheers