How to create events from database

[paul]

Hi,
I like your calendar and its very fast and look and feel like Google
calendar.
I want to use your application in my Web application.
I have Database where I keep all my events and manage with current
Google calendar.

Now how can I populate all events in calendar and display it.

( As rest of move , add and delete option is given ).

Looking forward for response.

thanks

Paul

[slenzi]

Hello Paul,

The calendar plugin is a client side UI element written in JavaScript
which runs in the browser and therefore cannot interact directly with
your database. Databases are server side, so you need to pick a server
side language of your choice (e.g., Java, PHP, ASP .NET, Ruby, etc) to
perform the SQL query to select the agenda items from your database. I
would recommend converting the results from the database query to JSON
and writing that back to the client (the browser.) On the client side
you can use jQuery to perform an AJAX call to your server side
component to retrieve the JSON calendar event data, then it's simply a
matter of looping through the events and calling the frontier calendar
addAgendaItem function to add the events to the calendar.

jQuery AJAX call
http://api.jquery.com/jQuery.ajax/

JSON
http://www.json.org/

You mentioned that you are currently storing your data in a Google
calendar? With Google calendar you should be able to export data in
iCal format. If you log into Google calendar and go to the settings
for your calendar you should see a green button link that says "ICAL".
Clicking that link will give you a URL to an iCal file that contains
all the events for that calendar. You can use the frontier calendar
loadICalSource functions to load that URL (which loads all the events
from the ical file into the calendar.)

Seth

[paul]

Thanks Set h for quick response.

I tried your second option to test "ICAL" option, with "Ical Test" in
your example with the URL I got from my Google Calendar,but its give
me following error

iCal load error: Returned data was null or empty string.

Source, http://www.google.com/calendar/ical/........../public/basic.ics

Any comments.

Paul

On Jul 6, 5:58 pm, slenzi <sle...@gmail.com> wrote:
> Hello Paul,
>
> The calendar plugin is a client side UI element written in JavaScript
> which runs in the browser and therefore cannot interact directly with
> your database. Databases are server side, so you need to pick a server
> side language of your choice (e.g., Java, PHP, ASP .NET, Ruby, etc) to
> perform the SQL query to select the agenda items from your database. I
> would recommend converting the results from the database query to JSON
> and writing that back to the client (the browser.) On the client side
> you can use jQuery to perform an AJAX call to your server side
> component to retrieve the JSON calendar event data, then it's simply a
> matter of looping through the events and calling the frontier calendar
> addAgendaItem function to add the events to the calendar.
>
> jQuery AJAX callhttp://api.jquery.com/jQuery.ajax/
>

> JSONhttp://www.json.org/

[slenzi]

You can only use the link to the ical file if you make your Google
calendar public. In all honesty I only tested the ical support with a
local file on my own machine. You can try downloading the .ics file
from Google and put it in the /extra folder with the fifa world cup
example ical file I provided. That should work....

Google calendar also allows you to export data as XML so you can
create a parser to parse the data from the xml file and load that into
the frontier calendar (calling the addAgendaItem function.)

I hope you realize that you can embed Google calendars in other web
sites. You may not even need my frontier calendar...

-S

On Jul 7, 11:29 am, paul <brd...@gmail.com> wrote:
> Thanks Set h for quick response.
>
> I tried your second option to test "ICAL" option, with "Ical Test" in
> your example with the URL I got from my Google Calendar,but its give
> me following error
>
> iCal load error: Returned data was null or empty string.
>

> Source,http://www.google.com/calendar/ical/........../public/basic.ics

[paul]

Seth,

Thanks for all quick response.

I was able to use Jquery Ajax call and get all events populated in
Calendar from MS Sql database.

using

jQuery AJAX call
http://api.jquery.com/jQuery.ajax/

How can I have Weekly or daily calendar option using your calendar ?


Other point that I can use Google Calendar , but for some users who
may mto want to use google calendar , I want to give your calendar
option.

We will be testing your calendar in next couple of days and will give
feed back.

Once again thanks and hope I will use this calendar in my application.

Waiting for weekly and Daily calendar guide line.

Paul

[slenzi]

I have good news and bad news.

Bad news is Frontier Calendar currently only provides a month view. A
week view would be a new addition... I'd have to find the time to do
it.

Good news is you could try looking into jquery-week-calendar plugin,

http://github.com/themouette/jquery-week-calendar
http://wiki.github.com/themouette/jquery-week-calendar/demos.

I see no reason why you couldn't use frontier calendar and this week
calendar together.

Another option might be, http://arshaw.com/fullcalendar/ which has a
full month, week, and day view all built together.

Hope that helps.

-Seth

On Jul 9, 2:53 pm, paul <brd...@gmail.com> wrote:
> Seth,
>
> Thanks for all quick response.
>
> I was able to use Jquery Ajax call and get all events populated in
> Calendar from MS Sql database.
>
> using

> jQuery AJAX callhttp://api.jquery.com/jQuery.ajax/

[shal...@tibssoftware.com]

Hi, 

   We couldn't able to bind the events dynamically from database in frontier calendar. can you provide the example      function .

[Darrel Viegas]

Hello,

I know it's been quite a long time for this question. But since this is a highly viewed thread, I've posted a sample tutorial using jsp, servlets and AJAX. The tutorial includes fetching from the database and displaying the events on the calendar. More details on that thread. Those interested in the same can refer the topic titled: Tutorial on how to use use jQuery Frontier Calendar with jsp servlets and AJAX

Regards,
Darrel Viegas