Log in Register FAQ Memberlist Search ContactReview Forum Index
A GoldMine Discussion and Support Community

ContactReview Forum Index » GoldMine Tips and Tricks » Online Calendar with RSS
Post new topic  Reply to topic View previous topic :: View next topic 
Online Calendar with RSS
PostPosted: Thu Oct 19, 2006 9:13 am Points: 0 Reply with quote
b2blog
n00b
Joined: 16 Jun 2006
Posts: 2
Location: Grand Rapids, Michigan




I posted this to my blog last week. For you Goldmine geeks, I'm on v6.6. If anyone knows if there is a way to add contact info to the calendar records when they become iCal format, I'd appreciate it.


A couple years ago I set up a simple online calendar for our service department to use so salespeople would be able to find out when their customers were getting service calls. Its there, but how many salespeople are going to check it regularly? While discussing this system with a rep, I suddenly had an idea: Make a calendar RSS feed!

Now what we were using doesn't have RSS feeds. Besides, it predated our installation of Goldmine CRM. So I'll generate a schedule in Goldmine, export a 'iCal' file, then use Google Calendar to display it and generate RSS.

Google experiment:
I took an existing '.ics' calendar file from Goldmine, then FTP to a spot on the web. In Google, I added an 'external' calendar...and Google didn't like it. Maybe its a problem with Google, maybe it is a problem with the way Goldmine generates the file. Experiment over.

Plan B: PHPiCalendar:
I've played with PHPiCalendar (PiC for short here) before, so I checked out its current version. Guess what: it does RSS! I made a new spot on the web for PiC and uploaded all the files. Unlike other PHP programs, it doesn't use a database, so no tinkering with mySQL. I did have to figure out how and where to create a 'temp' file for it to use, which took some experimenting. Then I manually FTP'd my '.ics' file and it worked.

Now Goldmine:
Goldmine is actually pretty cool when it comes to calendar functions. I selected what 'users' schedules to publish and what type of events, then put in the FTP information. It sends one iCal file with their combined schedule to the website. Then I set-up a 'server agent' to run the publishing of the file automatically a couple times a day.

What Goldmine doesn't do, however, is add any info to the iCal file about the contact the appointments are linked to, so we have to manually add this to the comments section when an event is scheduled.

RSS feeds:
PiC offers daily, weekly, and monthly feeds. Or you can create a custom feed for a date range. Now the reps and other non-Goldmine users who use an RSS reader will be able to be up-to-date on our service schedule.

Overall I'm very pleased with the way things turned out. I'm testing for a week before rolling out to our folks.

_________________
___________________
Dave J.
www.b2blog.com
View user's profile Send private message Visit poster's website

PostPosted: Thu Oct 19, 2006 10:05 am Points: 0 Reply with quote
DougCastell
GoldMine Guru
Joined: 15 Jun 2006
Posts: 1631
Location: Los Angeles, CA




Interesting. Can't wait to be able to try it out!


You may also be interested in the:

http://forums.frontrange.com/viewtopic.php?t=35574

_________________
Doug Castell

GoldMine Sales and Support:
http://www.castellcomputers.com/
office: (310)601-4738
View user's profile Send private message Visit poster's website AIM Address Yahoo Messenger MSN Messenger ICQ Number

TY
PostPosted: Thu Oct 19, 2006 10:20 am Points: 0 Reply with quote
b2blog
n00b
Joined: 16 Jun 2006
Posts: 2
Location: Grand Rapids, Michigan




Doug, looks like he is doing almost the opposite of what I am...pulling calendar info INTO Goldmine. The code is probably over my head, tho.

_________________
___________________
Dave J.
www.b2blog.com
View user's profile Send private message Visit poster's website

PostPosted: Thu Oct 19, 2006 11:09 am Points: 0 Reply with quote
DougCastell
GoldMine Guru
Joined: 15 Jun 2006
Posts: 1631
Location: Los Angeles, CA




Yeah, it's a bit over mine as well... still cool!

_________________
Doug Castell

GoldMine Sales and Support:
http://www.castellcomputers.com/
office: (310)601-4738
View user's profile Send private message Visit poster's website AIM Address Yahoo Messenger MSN Messenger ICQ Number

PostPosted: Tue Oct 24, 2006 7:01 am Points: 0 Reply with quote
DJ
GoldMine Guru
Joined: 29 Jun 2006
Posts: 2055
Location: Fitchburg, MA, USA




You may just want to take at the iCal as Published from GoldMine to the iCal Parser on my website. This will give you an idea as to how I use GoldMine to Publish my Calendars.

_________________
DJ Hunt

Phone: (978)342-3333
Email: DJ@DJHunt.US

GoldMine Premium - The Defintive Guide
One-on-One GoldMine Technical Support ( Fee Based )
www.DJHunt.US
View user's profile Send private message Send e-mail Visit poster's website AIM Address Yahoo Messenger MSN Messenger ICQ Number

PostPosted: Mon Apr 23, 2007 1:34 pm Points: 0 Reply with quote
Charlatat
GoldMine Journeyman
Joined: 16 Feb 2007
Posts: 31




DJ, is this still on your site?
View user's profile Send private message AIM Address Yahoo Messenger MSN Messenger ICQ Number

Online Calendar with RSS
  ContactReview Forum Index » GoldMine Tips and Tricks
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
All times are GMT - 7 Hours  
Page 1 of 1  

  
  
 Post new topic  Reply to topic  


Brought to you by Castell Computers, Doug Castell, Admin
RSS Feed
Powered by phpBB © 2001-2004 phpBB Group
Theme created by Vjacheslav Trushkin