Calendar of Events

[RobD]

Can anyone provide details on setting up an Event Calendar that reads events from a database table?

I want to display a monthly calendar that shows what events are happening on dates within that month based on data from a database table. I've tried several Javascript and JQuery calendars I found online, however I can't seem to get them to populate events from a database.

[Wai]

We have an example in the MyWorld demo that does exactly that.

Let me see if I can provide a link to download an export of the form. What version of Ebase are you using?

[RobD]

Thanks for replying Wai. We are using version 4.4.2 and building/testing on both Windows and Linux platforms. We are building an application for a Personal Training business and need to use the calendar quite heavily to make and display bookings, so this is a real 'kicker' for us.

Have to say we are only new to the product but are having fun learning and exploring, and see heaps of possibilities for it's use!

[Wai]

The MyWorld sample application has an event calendar. It reads records from a database table and displays it in a calendar on an Ebase form.

You can download a full Ebase 4.4.2 environment (windows), that includes the sample application from the following URL:

www.ebaseftp.com/download/forum/Ebase_4 ... ld_pkg.rar

Start the Ebase server and designer in the usual way. The sample application forms and scripts are within the MyWorld project.

To run the form, once the server is up, copy and paste this URL into your browser:

http://localhost:3030/ufs/ufsmain?formi ... SS=MYWORLD

Log into the application using user1/user1 as the username and password.

Click on the Events menu item, then click on My Calendar, select March in the drop down to view some events.
You can click on an event item to view the details.

[Wai]

Screenshot:

www.ebaseftp.com/download/forum/myworld_calendar.jpg

[RobD]

Thanks for this Wai, I'll let you know how it all goes!

[Dave]

Hi Rob - it looks likely that we're about to build a generic booking component for a local government customer of ours. The functionality will allow calendars/booking slots to be defined in the back-office and a front-end that presents a calendar and accepts bookings. The back-office will also be able to administer bookings (cancel, change) and produce appointment schedules, etc.

You can download a redacted specification from here:

http://www.ebaseftp.com/download/forum/ ... dacted.pdf

Even though the customer is local government the booking module will be generic.

Our plan will be to make this module available to the Xi community as either a free or low price unsupported add-on - this side of things yet to be decided.

The front-end part will replicate/improve the booking calendar shown at:

http://www.supersaas.com/schedule/demo/ ... 1&month=12

Let me know if this is something of interest to you?

[RobD]

Hi Dave,

The Therapist calendar functionality is exactly what we are working on producing with only a couple of very minor differences. Do you have any sort of timeframe of when it might be available? After downloading Wai's sample application today we have been able to implement a calendar no problems and our next task is to create the ability to make a reservation from the calendar page/timeslot, exactly as your demo does. If your timeframe is going to be too far forward for us, would it be possible to get the code for the demo as is? We're happy to push forward from that point as it will save us a day or 2 for sure.

Thanks for the assistance provided so far - it's been a great help!

Cheers,

Rob

[Dave]

Hi Rob - assuming it goes ahead, I'd have thought we'll have the whole thing available by the end of Feb. The demo link I sent is just something that we found on a site that looked like a good/modern implementation of what our customer wanted - nothing to do with Ebase I'm afraid, just an example of the kind of thing we plan to implement. So, can't help you with any code as yet. Only thing we've done so for is decide on a technical design, and checked out a few jQuery plugins (like the DatePicker) to make sure they'll slot in ok. Happy to discuss our thoughts on how it will work in Xi - might be of some use to you? Email me at drawlins@ebasetech.com if you want us to set up a call.

Apart from that, the best we can offer form the moment is to keep you posted on the project progress.

Regards,
Dave

[RobD]

Hi Dave, thanks again for your response. We are going to push ahead ourselves with a calendar and see how it goes. We would like to have it implemented into our customer's site a bit earlier than end of Feb but if we are struggling and can't get it working satisfactorily then we might have to rely on your implementation as a fall-back. The demo you showed us is almost exactly what we are after so it is a good mock up for us at the least. Thanks for the offer of a call - I will email you if we get to a point where we have to hassle you with that.

I would appreciate it if you could keep us advised of any significant updates in your project and likewise, I will let you know how we are traveling in case it's of any interest to you.

Cheers,

Rob

[Dave]

Hi Rob - sure, no problem. Be interested to see how you get on. Will keep in touch on this one.

Regards
Dave

[neilnewman]

Did the calendar feature ever become an offering as part of Ebase as suggested in this thread.

"Our plan will be to make this module available to the Xi community as either a free or low price unsupported add-on - this side of things yet to be decided."

[civanderputt]

Hi Neil,

We do have a working example of a booking/calendar app available to view, if you would be interested?

Best wishes
Constance

[neilnewman]

Hi Constance,
Yes please, we are looking to create a room booking form, but the calendar creation side of Ebase does not appear to be too straight forward!

Kind regards
Neil