Ajax Event Calendar Support Product Page
Use JSON object as a data source
Asked 03 Aug 2012 14:30:31
1
has this question
03 Aug 2012 14:30:31 John O'Melia posted:
I have a site that uses a ticketing service (TicketLeap) that makes our events available as a JSON feed. I know the event calendar is built only to use database recordsets or a Google Calendar feed but I noticed that one of the included js files the calendar uses is jquery.jsonp-1.1.1.min.js. Is there a workaround I could use that would allow the use of a JSON object? Many thanks. Replies
Replied 09 Aug 2012 06:41:53
09 Aug 2012 06:41:53 Teodor Kuduschiev replied:
Hello,
Unfortunately it is not possible to use JSON as a data source.
Unfortunately it is not possible to use JSON as a data source.
Replied 09 Aug 2012 11:37:20
09 Aug 2012 11:37:20 John O'Melia replied:
Actually, I came up with my own workaround for anyone interested but it's a real hack.
I created a PHP page that calls the JSON feed, loop through the results for the items I wanted and inserted them into an empty MySQL table. When that's done I load the calendar with a recordset from the new db. It's a little slow but the calendar isn't loaded on the page until the user clicks a tab so that gives me the extra time I need.
I created a PHP page that calls the JSON feed, loop through the results for the items I wanted and inserted them into an empty MySQL table. When that's done I load the calendar with a recordset from the new db. It's a little slow but the calendar isn't loaded on the page until the user clicks a tab so that gives me the extra time I need.