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
Quote from: 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.

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
Quote from: 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 :)

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
Title: Re: Consolidated events overview of different projects
Post by: arlo on February 03, 2020, 11:23:41 PM
Yesterday's release adds a JSON feed option to the calendar widget page, and those settings have been moved to Account > Website Widgets.

All yesterday's changes are listed here:

http://www.bandhelper.com/support/release_notes.html
Title: Re: Consolidated events overview of different projects
Post by: Chris on February 04, 2020, 01:46:04 PM
Awesome! Will check it out soon...

Cheers
Title: Re: Consolidated events overview of different projects
Post by: JerryK on February 05, 2020, 06:44:39 AM
Quote from: 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

Google calendar offers a choice per-entry of Public or Private
Title: Re: Consolidated events overview of different projects
Post by: Chris on February 05, 2020, 01:58:23 PM
@JerryK: thanks for the explanation. I am using the JSON-feed now though.

@arlo: great implementation! I am now able to format the gig-overview as desired :)
Title: Re: Consolidated events overview of different projects
Post by: Chris on March 12, 2020, 12:03:03 AM
Hi arlo,

just wondering whether there is an option to show cancelled gigs on my website as well (i.e. by having them crossed out).
Idea is that currently, somebody checking my website might see a gig today but not the next time he/she returns to my site being unsure why it has gone...
I would prefer that a gig if marked as "public" which gets cancelled does not simply vanish from the feed.

I did not find an according setting in the widgets area so assume this is not yet possible?

Regards,
Chris
Title: Re: Consolidated events overview of different projects
Post by: arlo on March 12, 2020, 08:31:27 AM
Good point. I'll put that on my to do list.
Title: Re: Consolidated events overview of different projects
Post by: arlo on March 12, 2020, 12:22:18 PM
Okay, this is done. Cancelled events will appear, with their dates crossed out and the word "Cancelled" after the date. You can override the style of the bandhelper_cancelled and bandhelper_cancelled_label CSS classes if you wish.

My band has had some events cancelled this week, too.  :(
Title: Re: Consolidated events overview of different projects
Post by: Chris on March 12, 2020, 12:52:21 PM
Hail to Corona  :-[
Title: Re: Consolidated events overview of different projects
Post by: Chris on March 12, 2020, 12:55:35 PM
Quote from: arlo on March 12, 2020, 12:22:18 PM
Okay, this is done. Cancelled events will appear, with their dates crossed out and the word "Cancelled" after the date. You can override the style of the bandhelper_cancelled and bandhelper_cancelled_label CSS classes if you wish.

My band has had some events cancelled this week, too.  :(

Am I guessing correctly this is not yet done for the JSON-feed? As there is no crossing out yet... would you have a quick idea how I can have it solved? If not, I will simply add a note to the event instead.
Title: Re: Consolidated events overview of different projects
Post by: arlo on March 12, 2020, 01:55:30 PM
In the JSON feed, there is no visual style to alter, but a "cancelled" flag is included.
Title: Re: Consolidated events overview of different projects
Post by: Chris on March 12, 2020, 11:44:29 PM
Great... I will check then how I can have this accounted for :)
Title: Re: Consolidated events overview of different projects
Post by: arlo on October 01, 2020, 02:52:53 PM
Coming back to this part of the thread:

Quotethe widget on my webpage still shows a gig that took place yesterday regardless if I add the 16th as the end-date or not

It turns out I had it set to keep displaying events until one day after they ended. Now that seems confusing, so I just removed that. Does that fix it for you?

Note that if an event has an end time at or after midnight, it will still appear on the following day, but then it will disappear the next day.
Title: Re: Consolidated events overview of different projects
Post by: Chris on October 01, 2020, 10:21:19 PM
Hi arlo,
thanks for still looking into this. Currently no gigs to display due to COVID-19 but will check with some made-up ones.

Cheers