Pre-Sales

Architecture of event table setup

Feel free to ask questions you might have before purchasing a subscription in here.

Postby DeanPerry » Wed Mar 20, 2013 12:04 am

Hi

Looks like you have a great looking product - I need some assistance on how to architect for my client's site; part of which is the version that I need to procure.

We have meeting dates (and times) set in an existing MySQL table which is copied from a legacy software system in the business. I am conscious that I don't want to store the same piece of data in two places for obvious data primacy reasons.

How does JEvents handle this situation, if at all? I have some quite specific downstream processes (e.g. automated PDF meeting agendas) already working that I would prefer not to spend too much time re-engineering.

Can someone please help me with some high level advice?

Thanks

Dean
DeanPerry
 
Posts: 1
Joined: Tue Mar 19, 2013 11:58 pm

Postby Tonyp » Wed Mar 20, 2013 12:46 am

Hello Dean,

Geraint will be able to provide some more indepth advice tomorrow. (working UK times 9-5).

But, JEvents is an ICal based calendar. You can use it as the primary or the slave, i.e. if you have an ICal url you can create a new calendar in JEvents and have a cron run to auto-update this. You can also set certain events to locked which are not to be overwritten by the master calendar.

For date formatting we use the standard ICal date formatting.

Can you produce an ICal file from your current system? even a url?

If not, can you integrate with Google? so you can then pull from Google?

Regards
Tony
---------------------------------------
Feel free to PM me if you would like Custom Installs or Joomla! related work for a competitive quote.

User avatar
Tonyp
Team Staff
 
Posts: 23834
Joined: Tue Oct 12, 2010 9:12 pm
Location: Isle of Man

Postby Geraint » Wed Mar 20, 2013 6:22 am

Also we have a couple of silver level club member scripts that allow the importing of events from SobiPro, Community Builder and JomSocial - these construct iCal files from database data. So if you know some basic PHP you could adapt one of these scripts to match your own database structure.
JEvents Club members can get priority forum support at the Support Forum. As well as access to a variety of custom JEvents addons and benefits. Join the JEvents club today!
User avatar
Geraint
 
Posts: 42850
Joined: Fri Feb 15, 2008 6:14 pm


Return to Pre-Sales

  • Who is online
  • View new posts
  • View unanswered posts
  • In total there are 0 users online :: 0 registered and 0 hidden (based on users active over the past 5 minutes)
  • Most users ever online was 94 on Tue Sep 01, 2009 12:33 am
  • Users browsing this forum: No registered users