Re: Man, I'm just really banging my head over this one...
There is always the open source ColdCalendar. Admittedly I haven't touched it for ages. Go for it - just don't SELL anything you do with it without letting me know first. http://www.coldgen.com/ In fact it has a misnomer (an office in/out application). Check out open source that you can use for bagging every Calendar app first at least. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225659 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Man, I'm just really banging my head over this one...
It's an event calendar and I'm totally cool with inserting an event giving it a date and time, and outputting it ordered by date. Cake. No worries there... However, my frickin head starts to explode when I start taking into account every frickin' possible way to add an event, especially when I look at this client's current list of events. There are events that are once a week, some are on say, the first and third monday, then others are every wednesday, etc. It's those recurring weirdly scheduled events that are causing me the most consternation. It just seems like if you take into account one way to do recurrence, some other way creeps in, and you've got to make another exception, then you start to feel like you're cobbling together code and slowly moving further and further away from a manageable application. Are there easy to use, easy to implement CF based calendars out there that I could use instead? Or is this easy enough to write yourself, but you've got maybe do certain things that I'm overlooking? Has anyone had to approach this problem of creating an easy to use, updateable, calendar that can spit out dates and gives the end user the ability to insert more than just a single event on a single day? Something even *approaching* robust? Anyone have any pointers, examples, code tutorials, anything that can make this a little easier to accomplish? -- Jeff Small LHWH Advertising Myrtle Beach, SC 29577 843-448-1123 Ext 254 ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225612 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Man, I'm just really banging my head over this one...
www.springfieldfirst.com/calendar.zip has the capacity to add events every day, every other day, every third day, every week, every other week, every third week, every month, every other month, every third month, every sixth month, every year, and every other year for a repeatable duration from one day to 6 years. Hope it helps. Sincerely, Andrew -Original Message- From: Jeff Small [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 29, 2005 1:21 PM To: CF-Talk Subject: Man, I'm just really banging my head over this one... It's an event calendar and I'm totally cool with inserting an event giving it a date and time, and outputting it ordered by date. Cake. No worries there... However, my frickin head starts to explode when I start taking into account every frickin' possible way to add an event, especially when I look at this client's current list of events. There are events that are once a week, some are on say, the first and third monday, then others are every wednesday, etc. It's those recurring weirdly scheduled events that are causing me the most consternation. It just seems like if you take into account one way to do recurrence, some other way creeps in, and you've got to make another exception, then you start to feel like you're cobbling together code and slowly moving further and further away from a manageable application. Are there easy to use, easy to implement CF based calendars out there that I could use instead? Or is this easy enough to write yourself, but you've got maybe do certain things that I'm overlooking? Has anyone had to approach this problem of creating an easy to use, updateable, calendar that can spit out dates and gives the end user the ability to insert more than just a single event on a single day? Something even *approaching* robust? Anyone have any pointers, examples, code tutorials, anything that can make this a little easier to accomplish? -- Jeff Small LHWH Advertising Myrtle Beach, SC 29577 843-448-1123 Ext 254 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225614 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Man, I'm just really banging my head over this one...
If your client has a groupware server, (Exchange, Groupwise, etc), you could tap into those resources. We use Outlook/Exchange. I built an ASP-based solution that pulls data from Exchange and stores it in a SQL database. Then, our web sites pull from the database for the presentation. The calendar admins can use any of the supported recurring appointment types and Exchange just outputs the events on the chosen dates. It works great. M!ke -Original Message- From: Jeff Small [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 29, 2005 1:21 PM To: CF-Talk Subject: Man, I'm just really banging my head over this one... It's an event calendar and I'm totally cool with inserting an event giving it a date and time, and outputting it ordered by date. Cake. No worries there... However, my frickin head starts to explode when I start taking into account every frickin' possible way to add an event, especially when I look at this client's current list of events. There are events that are once a week, some are on say, the first and third monday, then others are every wednesday, etc. It's those recurring weirdly scheduled events that are causing me the most consternation. It just seems like if you take into account one way to do recurrence, some other way creeps in, and you've got to make another exception, then you start to feel like you're cobbling together code and slowly moving further and further away from a manageable application. Are there easy to use, easy to implement CF based calendars out there that I could use instead? Or is this easy enough to write yourself, but you've got maybe do certain things that I'm overlooking? Has anyone had to approach this problem of creating an easy to use, updateable, calendar that can spit out dates and gives the end user the ability to insert more than just a single event on a single day? Something even *approaching* robust? Anyone have any pointers, examples, code tutorials, anything that can make this a little easier to accomplish? -- Jeff Small LHWH Advertising Myrtle Beach, SC 29577 843-448-1123 Ext 254 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225619 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Man, I'm just really banging my head over this one...
On 11/29/05, Peterson, Andrew S. [EMAIL PROTECTED] wrote: www.springfieldfirst.com/calendar.zip has the capacity to add events every day, every other day, every third day, every week, every other week, every third week, every month, every other month, every third month, every sixth month, every year, and every other year for a repeatable duration from one day to 6 years. Hope it helps. Yowza. I took a look at that code and its licensed for non commercial use only. While I do some NFP work most of it is commercial, so no go for me, BUT... If working your own calendar, why not approach the issue of recurrence methodically and create something that has a host of options pre-built in, like the above? User gets an Add Event form that has a drop-down with the boatload of options of your choice, which in turn leads to a cfswitch that neatly handles each desired interval to the desired length of repetition? Use a mini popup calendar view for picking start date and stop date? A lot of legwork but from a conceptual standpoint is fairly straightforward. -- --mattRobertson-- Janitor, MSB Web Systems mysecretbase.com ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225628 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Man, I'm just really banging my head over this one...
I wrote an events manager. I ended up splitting up the database structure to handle once date-specific (16th-19th) events versus day-specific (every second Tuesday). Then just use some of the built-in functions and those from cflib to compile it all for display. I took a bit of an easy approach though, I don't have a calendar display but it shouldn't take too much effort to get to there from where I am now. -- Damien McKenna - Web Developer - [EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 #include stdjoke.h ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225629 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Man, I'm just really banging my head over this one...
We've just overhauled our calendaring up to support recurring events. We just took the interface from outlook, and stored all that data in the events table. Then we have a separate table to store the eventDates (and it's just 3 fields, eventDateId, eventID and eventDate). When I save the event, I update the eventDate table and insert every date that the event falls on. So if it recurrs every third tues until next year, I loop monthly until next year and store every event date. I believe this is far more efficient then calculating it on the fly. I got some functions off cflib to calculate things like third tues of the month, etc. The only problem I foresee is when an event has no end date. But in that case, I'll probably pick some crazy date in the future and make that my stop date. -Original Message- From: Damien McKenna [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 29, 2005 4:17 PM To: CF-Talk Subject: RE: Man, I'm just really banging my head over this one... I wrote an events manager. I ended up splitting up the database structure to handle once date-specific (16th-19th) events versus day-specific (every second Tuesday). Then just use some of the built-in functions and those from cflib to compile it all for display. I took a bit of an easy approach though, I don't have a calendar display but it shouldn't take too much effort to get to there from where I am now. -- Damien McKenna - Web Developer - [EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 #include stdjoke.h ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225631 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Man, I'm just really banging my head over this one...
User gets an Add Event form that has a drop-down with the boatload of options of your choice, which in turn leads to a cfswitch that neatly handles each desired interval to the desired length of repetition? Boy, Matt, I'd love to see the code that processes all the options in that drop-down...got any of it handy? I was trying to go down this road once before with my calendars, but found the code (not CF code...don't remember what it was) that handles the calculations to be too demanding to take time to figure out. Thankfully, I haven't had any clients that demanded that much functionality...yet... Maybe some of you code guru's could post one piece of code at a time...like Here's the code that calculates every 3rd Monday of the month... Kind of like a short-installment tutorial... Rick -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 29, 2005 4:14 PM To: CF-Talk Subject: Re: Man, I'm just really banging my head over this one... On 11/29/05, Peterson, Andrew S. [EMAIL PROTECTED] wrote: www.springfieldfirst.com/calendar.zip has the capacity to add events every day, every other day, every third day, every week, every other week, every third week, every month, every other month, every third month, every sixth month, every year, and every other year for a repeatable duration from one day to 6 years. Hope it helps. Yowza. I took a look at that code and its licensed for non commercial use only. While I do some NFP work most of it is commercial, so no go for me, BUT... If working your own calendar, why not approach the issue of recurrence methodically and create something that has a host of options pre-built in, like the above? User gets an Add Event form that has a drop-down with the boatload of options of your choice, which in turn leads to a cfswitch that neatly handles each desired interval to the desired length of repetition? Use a mini popup calendar view for picking start date and stop date? A lot of legwork but from a conceptual standpoint is fairly straightforward. -- --mattRobertson-- Janitor, MSB Web Systems mysecretbase.com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225639 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Man, I'm just really banging my head over this one...
I have a web application that is very robust, you could resell it to your client. Does all the recurring events and then some. No download or installation needed. http://www.calabunga.com As low as $2.95/month if you are the only admin, $5.95/month for multi-admin functionality. -- Josh Nathanson - Original Message - From: Jeff Small [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tuesday, November 29, 2005 11:20 AM Subject: Man, I'm just really banging my head over this one... It's an event calendar and I'm totally cool with inserting an event giving it a date and time, and outputting it ordered by date. Cake. No worries there... However, my frickin head starts to explode when I start taking into account every frickin' possible way to add an event, especially when I look at this client's current list of events. There are events that are once a week, some are on say, the first and third monday, then others are every wednesday, etc. It's those recurring weirdly scheduled events that are causing me the most consternation. It just seems like if you take into account one way to do recurrence, some other way creeps in, and you've got to make another exception, then you start to feel like you're cobbling together code and slowly moving further and further away from a manageable application. Are there easy to use, easy to implement CF based calendars out there that I could use instead? Or is this easy enough to write yourself, but you've got maybe do certain things that I'm overlooking? Has anyone had to approach this problem of creating an easy to use, updateable, calendar that can spit out dates and gives the end user the ability to insert more than just a single event on a single day? Something even *approaching* robust? Anyone have any pointers, examples, code tutorials, anything that can make this a little easier to accomplish? -- Jeff Small LHWH Advertising Myrtle Beach, SC 29577 843-448-1123 Ext 254 ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225641 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Man, I'm just really banging my head over this one...
On 11/29/05, Rick Faircloth [EMAIL PROTECTED] wrote: Boy, Matt, I'd love to see the code that processes all the options in that drop-down...got any of it handy? I was just sayin' that it sounded like a reasonable way to go about the task. I hadn't actually written anything. However I have a slow afternoon and need to brush up on my date functions, so here's one, formatted as text for easy presentation http://mysecretbase.com/dateswitch.txt What I wrote here covers just reminders at 1-7 day intervals, and includes a date-based end date which will terminate the event build if the selected number of repeats goes past the designated stop date, and a skip interval (as in every three days, but skip one or more three day periods in between). This is just the 'daily' case of the cfswitch, and yes it allows you to select intervals that are a little zany, but if your philosophy is to let users select whatever the heck they want no matter how crazy, this is in that direction. Other cases for the switch would be named days -- Every Monday, every other Monday, every third Tuesday etc. (using the same skip interval idea), Numbered days -- The 23rd of every month. Specific days -- first Monday of every month. First and third Tuesday. That sort of thing. annual dates -- birthdays and such CF and cflib together would let you do all sorts of things. First business day of every month, for example. - --mattRobertson-- Janitor, MSB Web Systems mysecretbase.com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225651 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Man, I'm just really banging my head over this one...
Thanks for the pseudo-code, Matt. I'll study that and see if I can wrap my brain around your approach... Rick -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 29, 2005 8:05 PM To: CF-Talk Subject: Re: Man, I'm just really banging my head over this one... On 11/29/05, Rick Faircloth [EMAIL PROTECTED] wrote: Boy, Matt, I'd love to see the code that processes all the options in that drop-down...got any of it handy? I was just sayin' that it sounded like a reasonable way to go about the task. I hadn't actually written anything. However I have a slow afternoon and need to brush up on my date functions, so here's one, formatted as text for easy presentation http://mysecretbase.com/dateswitch.txt What I wrote here covers just reminders at 1-7 day intervals, and includes a date-based end date which will terminate the event build if the selected number of repeats goes past the designated stop date, and a skip interval (as in every three days, but skip one or more three day periods in between). This is just the 'daily' case of the cfswitch, and yes it allows you to select intervals that are a little zany, but if your philosophy is to let users select whatever the heck they want no matter how crazy, this is in that direction. Other cases for the switch would be named days -- Every Monday, every other Monday, every third Tuesday etc. (using the same skip interval idea), Numbered days -- The 23rd of every month. Specific days -- first Monday of every month. First and third Tuesday. That sort of thing. annual dates -- birthdays and such CF and cflib together would let you do all sorts of things. First business day of every month, for example. - --mattRobertson-- Janitor, MSB Web Systems mysecretbase.com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225652 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Man, I'm just really banging my head over this one...
On 11/29/05, Rick Faircloth [EMAIL PROTECTED] wrote: Thanks for the pseudo-code, Matt. That code actually runs :-) The idea is that the switch is a self-contained processor of sorts. Each case handles a different class of reminder (one of which I duplicated in my last email when describing options) :-). If someone comes up with a whole new breed of cat, you can add another case without ripping apart the rest of your (working) code. Design and organization of the input process so it doesn't overwhelm/confuse the user is as critical as processing the inputs. -- --mattRobertson-- Janitor, MSB Web Systems mysecretbase.com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225653 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Man, I'm just really banging my head over this one...
Ok...good. Thanks for the real code... ;o) Rick -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 29, 2005 8:51 PM To: CF-Talk Subject: Re: Man, I'm just really banging my head over this one... On 11/29/05, Rick Faircloth [EMAIL PROTECTED] wrote: Thanks for the pseudo-code, Matt. That code actually runs :-) The idea is that the switch is a self-contained processor of sorts. Each case handles a different class of reminder (one of which I duplicated in my last email when describing options) :-). If someone comes up with a whole new breed of cat, you can add another case without ripping apart the rest of your (working) code. Design and organization of the input process so it doesn't overwhelm/confuse the user is as critical as processing the inputs. -- --mattRobertson-- Janitor, MSB Web Systems mysecretbase.com ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225655 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54