Calendar Module Changes (Part Deux, iCal Adventures)

Comments

• 16 Comments sorted by Votes Date Added
• jonb

  July 2007 Vote Up0Vote Down

  in addition, here's my current revision of the calendar module. i tarballed it for convenience. however, you must still apply many of the patches to get the stuff here to work. there are many changes outside of the calendar module that must be applied.
• jonb

  July 2007 Vote Up0Vote Down

  oh, before anyone asks, i didn't make an interface for an end user to actually download the calendar (so there's no link within vtiger to get to the calendar). that will come later. if you want to use these patches as is, you can tell your users to subscribe to the calendar at the following address in ical or whatever.
  
  <!-- m --><a class="postlink" href="http://your-vtiger-install/index.php?module=calendar&action=ical">http://your-vtiger-install/index.php?mo ... ction=ical</a><!-- m -->
  
  if you really need a button to download a calendar within vtiger, just modify the appropiate file in vtiger-install/smarty/templates to create a link to the above.
• jonb

  July 2007 Vote Up0Vote Down

  here we go. this is a patch to the index file so the headers will be written out from the previous patch. it basically disables any output other than the text/calendar data.
  

  index: index.php
  ===================================================================
  --- index.php	(revision 140)
  +++ index.php	(working copy)
  @@ -274,6 +274,7 @@
   		ereg("^activityajax",$action) ||
   		ereg("^chat",$action) ||
   		ereg("^vtchat",$action) ||
  +		ereg("^ical",$action) ||
   		ereg("^updatecalendarsharing",$action) ||
   		ereg("^disable_sharing",$action) ||
   		ereg("^headlines",$action) ||
  @@ -303,10 +304,11 @@
   			ereg("^massdelete", $action) ||
   			ereg("^mailmergedownloadfile",$action) || 	ereg("^get_img",$action) ||
   			ereg("^download",$action) ||
  +			ereg("^ical",$action) ||
   			ereg("^massdelete", $action ))
   			$skipfooters=true;
   		//skip footers for all these invocations as they are mostly popups
  -		if(ereg("^downloadfile", $action) || ereg("^fieldtypes",$action) || ereg("^mailmergedownloadfile",$action)|| ereg("^get_img",$action))
  +		if(ereg("^ical",$action) || ereg("^downloadfile", $action) || ereg("^fieldtypes",$action) || ereg("^mailmergedownloadfile",$action)|| ereg("^get_img",$action))
   		{
   			$viewattachment = true;
   		}
  
• jonb

  July 2007 Vote Up0Vote Down

  this patch has been submitted to the trac.
  
  <!-- m --><a class="postlink" href="https://trac.vtiger.com/cgi-bin/trac.cgi/ticket/4080">https://trac.vtiger.com/cgi-bin/trac.cgi/ticket/4080</a><!-- m -->
• jonb

  July 2007 Vote Up0Vote Down

  does anyone have any suggestions for doing authentication? basically as-is, you need to login to be able to access the calendar. i'm thinking about setting it so it creates it's own connection to the database and turning it into an essentially stand alone script that queries the database and returns the public calendar. this way users can subscribe to the calendar in ical or whatever and not have to log in before hand. any thoughts on this?
• jonb

  July 2007 Vote Up0Vote Down

  i ended up modifying my version of the ical exporter to provide the calendar without authentication. i figure if someone manages to get into our internal network, viewing our calendar is the least of our worries. if you want your setup like this, move the ical.php in modules/calendar to your vtiger root and modify the beginning of it to resemble the following:
  

  <?php
  
  define('_bennu_version', '0.1');
  
  require_once('include/database/peardatabase.php');
  require_once('include/utils/commonutils.php');
  require_once('include/utils/userinfoutil.php');
  require_once('modules/calendar/calendarcommon.php');
  require_once('modules/calendar/icalendar_rfc2445.php');
  require_once('modules/calendar/icalendar_components.php');
  require_once('modules/calendar/icalendar_properties.php');
  require_once('modules/calendar/icalendar_parameters.php');
  
  // connect to the database anyway if we aren't logged in
  if(!isset($_request['action']) || !isset($_request['module']) ) {
  	global $adb;
  
  	$adb = newadoconnection($dbconfig['db_type']);
  	$adb->connect($dbconfig['db_server'], $dbconfig['db_username'], $dbconfig['db_password'], $dbconfig['db_name']);
  }
  
  $ical_query = "select * from vtiger_activity
                 where (
                     ( status != 'completed' and status != 'deferred' )
                     or status is null
                 ) and (
                     ( eventstatus != 'held' and eventstatus != 'not held' )
                     or eventstatus is null
                 )";
  
  etc...
  

  
  enjoy.
• chimaster

  August 2007 Vote Up0Vote Down

  hi jonb,
  
  i saw this post and followed on from the other thread. looks like excellent work from the screen shots. can you summary up best files / patches to be applied as i'm having some trouble getting the patches in.
  
  (most likely a result of my newbism).
  
  regards
  
  <!-- s:p --><img src="{smilies_path}/icon_razz.gif" alt=":p" title="razz" /><!-- s:p -->
• seaq

  October 2007 Vote Up0Vote Down

  jonb, how are you?
  
  i wonder if it's possible to add a vcard export functionality to the calendar via ical. i don't really know a lot about this, that's why i'm asking.
  
  what i had in mind is to attach the ical file for the event in particular when i create it and select send notifications. so when i get the email i can add the ical file to my calendar..
  
  what do you think about this?
• wolf88

  January 2008 Vote Up0Vote Down

  i am highly interested in the ical export and dont want to wait for the 5.1 version. but i do not manage to get it work. actually i totaly lost (or never got) the overview of all patches needed. from the first patch i also get some rejections.
  
  as i am no programmer: could someone please provide a concentrated patch or the patched and zipped calendar-folder (do i still have to change the db?). i am running the actual 5.0.3 version. thanx.
• bangstudio

  January 2008 Vote Up0Vote Down

  hi
  i'd like a summary path x ical too...
  
  totally lost....
  
  <!-- s:( --><img src="{smilies_path}/icon_sad.gif" alt=":(" title="sad" /><!-- s:( -->(((