I hope Telligent takes this fix as well as your other bug fixes for the next CS release. Thank you for the excellent work!
Thanks CADman,
I believe that Dave entered into their bug tracking system, so we'll see what happens with CS 3.0. I'm not sure if there is going to be another service pack before it is released, so we have to just wait an see on that as well.
Take it easy,
Bill
Bill,
I had to roll back the changes due to a problem that popped up when users were logging in or trying to use the NotRead.aspx as it caused exceptions on my CS 2.1 Sp2 .NET 1.1. Shoot me an email if you want to discuss more details. I did notice however the icons were for once in a very very longtime working as expected but the side effect exceptions cause me to sadly roll back.
Shaan
Well, it appears that we have fixed Shaan's issue. He is using the NNTP Gateway addon and a 3rd party made some changes to one on the stored procedures that I fixed, to correct some issues with the gateway. Once those changes were added to to my corrections, everything worked.
Updated the exception test as I figured out what they were trying to do, but wasn't working. They were attempting to make sure that they didn't get stuck in an infinite loop, but the code wasn't doing that. This isn't how an infinite loop test should be performed, but it's all we have to work with.
UPDATE: While working with Shaan and his very large database, I have identified some performace issues and some issues with 3rd party patches or addons. If you have a 3rd party patch/addon, you will need to incorporate those changes into this bug fix. If you have any problems or questions, please contact me.
If you have a small to medium sized database, you should not have any problems with the fix that is currently available. However, if you have a large database, please contact me before you attempt to implement this bug fix. With Shaan's help, things are looking good and I hope to post an update soon.
UPDATE 03/01/2007:
The download has been updated to the version that has been incorporated into CS 2007. There is a new blog post about the changes, but it should now be compatible with very large databases. Please take a look at the new post and be sure to read all of the download information.
I've updated the post and added a link to:
www.opensourcec.org/.../948.aspx
which is a status update. I'll be releasing the control later this week.
I updated the package to include some missing images and to fix a minor bug that occured if a user updated their profile. Just copy the contents of the Web folder over your installation, replacing the existing files, and all should be good.
Does the [cal:] code work for any application in CS, or just for the blogs?
Thanks!
-Robert
Hey Robert,
It works in Blogs, Forums, Files and Galleries, just like Dan Bartels original control does.
I think instead of the [cal][/cal] tags, it would work like the other modules for TextParts, in this format: [cal: 6/1/2007]
Also, if you change the date after it's posted, does your component automatically update the date in the database? What about if you delete the tag from the post?
The reason that [cal]date[/cal] is being used, is for backwards compatability with Dan Bartels CS 2.x control. I'll look into your suggestion, but I think that it may cause confusion as the tags are designed to be an extension to BBCodes.
As for automatically updating, yes they do. The birthday events do as well, if you change the birthdate setting in your profile.
There is; however, an issue with deleting or moving a forum. If you delete or move a forum, the events won't be updated as the system does not process any events for these block changes which will leave orphaned records in the table. If this happens, you may want to re-run the RebuildCalendarEvents.sql script, which will remove all of the records from the tables and rebuild them.
I followed your instruction in the readme.txt file. However two issues found:
1. I need to add an entry in resouces.xml file of <resource name="calendar">Calendar</resource>. Othereise I got resource name not found error.
2. The clock image does not show in my /Calendar page.
Hi, Robert,
To fix the clock image issue, I have to modify the calendar.aspx.
From: <img src='../images/calendar/clock.jpg' align="right">
To <img src="../images/calendar/clock.jpg" align="right">
Hi Qingsong, your are correct. I left out the resources.xml entry. I'm putting together a new package and have added it to the instructions.
Thanks
Hi, Bill,
I downloaded your updated version. Even though the crash error message is gone, the post which contain the [cal] tag does not get an entry in Calender.
No entry, no error message either.
I have to reverse back to the previous version, at least that version can get entry for the new post.
Can I do the samething for Photos as well?
Should I change the code in galleries.Master, or gallerysidebar.ascx?
Thanks,
Qingsong
Hi Qingsong, that is exactly how the updated version is desgined to work. If you read the instructions (paragraph 2 in the main post above), you will need to run the rebuild script after making any such changes. The previous build will not write calendar event records properly, if at all, due to API bug.
Just implemented on my site and added a test post in a forum and used the format but nothing shows up on the calendar.
I looked at the wgb_CalendarEventThread and wgb_CalendarEventUser tables and there is an entry in the wgb_CalendarEventThread table but nothing in the wgb_CalendarEventUser table.
I am using the UserCalendarModule in the communityserver.config file.
Please advise.
Thanks.
stumpy, try running the rebuild script and see if it shows up then. Before you do that though, could you write down and post the values for the fields of the record in the thread table? The user table currently only holds birthdays, so that just means that no one in your database has registered a birthday.
Here is the record that is in the THREAD table:
ThreadID---PostID---SettingsID---EventDate---EventYear---EventMonth---EventDay
111---310---1000---6/9/2007 12:00:00 AM---2007---6---9
I ran the rebuild script and still nothing on the calendar.
Also I did notice that I got an error when running the InstallCalendar.sql portion that creates the fnWGB_ExtractPropertyValue FUNCTION. Could this be the cause? The error I get when trying to create that function is "Expression result length exceeds the maximum. 8000 max, 16000 found".
That function is used to parse the extended properties of the user membership records, which is why your user table is empty as it is unable to parse the birthdates. I'll take a look at it tonight and see if I can find anything wrong with it. I am assuming that you are using SQL Server 2000, correct?
As for the record above, it looks like a good record. The only thing that would prevent it from showing up on the calendar is permissions. Is the account that you are logged in as able to read the post?
Yes it is SQL Server 2000.
The user that I'm logging in as is the user that created the post and has admin privileges. I can read the post fine but cannot see anything on the calendar.
Ok guys, I created a new post with a temporary fix for the issue, but it is ONLY for those who are using the SDK. Everyone else will need to wait until Telligent provides a patch. Go to my CS2007: Temporary Bug Fix for Forum Posts post for more information.
Hey stumpy, on the install script, try doing a search for '8000' and replace with '4000'. That may fix your problem.
Thanks, Bill,
It works nicely.
Hi there. My company might well be in the market for a commerical version of your event calendar for CS 2007.
I have to confess that I'm struggling to get my head round what it does - is there somewhere I can see the existing version in action, and maybe have a play?
Hey Andrew,
This addon basically does two things, gives you the ability to turn a post (blog, forum, file, or gallery) into a calendar event, plus it turns the birthdays of users into calendar events as well. The current control is free for anyone to use, just download and install it.
The commercial version will be released later this year and will contain some Outlook type functionality in addition to what the current control provides. Things like personal calendars, event sharing, as well as other features.
Thank you for updating and releasing the calendar addon for CS2007. Nice features and exactly what we like to have on our site.
I have installed/configured using your instructions, however the events do not automatically show in the calendar control.
Running the rebuild script does add them. I have tried adding event posts using different users with different CSRoles and using both CalendarModules - not at the same time ofcourse :)
Am I missing a config option or something else? Please advise.
Regards,
Migael
Hey Migael, I'm glad you like it. Out of the box, the control only supports events created by Administrators and Managers. If you want other users to be able to add events as well, you will need to change which CSModule is used in your communityserver.config.
I've been thinking about creating a CalendarEventManager role, which you can give out individually as I think allowing all users to add events can cause problems. The rebuild script does not check user rights and adds events for all posts, which is why it is working for you.
I'm going to look into implementing this, but it may take a week or two for me to get to it.
Take it easy, Bill.
I've added your Calendar Module (very nice!) after doing a brand new install of CS 2007 SP2 and for the life of me I can't get an event to show up at all (I've triple checked all the instructions for file changes and the tables, sprocs, etc are there). I've added the appropriate tag to a blog entry and it won't show up. I've re-run the Rebuild script numerous times and it never adds anything and always says 0 rows affected.
Is it possible that something changed in SP2 (which came out after your last update) that is disabling things?
Blog Post: 208.106.246.24/.../default.aspx
Calendar: 208.106.246.24/.../calendar
I'm doing all this with the Admin module and my role is set to System Administrator. Any ideas?
Jimmy
Hey Jimmy,
You are having the same issue as another person was having. I think it was a comment under a different blog thread. You need to make sure that the tags are placed in the body of the text and not the tag area. I think it was a big mistake to use the term tag for the category tag area, but it's too late to change. Move the tags to the body of the post and everything will work for you.
Thanks that was it. You know I had spent a couple minutes wondering why your blog posts that were on the calendar didn't have any "CS Tags" on them.
Thanks a bunch it works great!
One appearance tip that I will add for anyone reading this. If you create a css class in the appropriate file or override and give it a "display: none;" style and then when you insert your [cal:] tag put it in a div with that class. That way when you edit the post the tag shows up (so you know it's there of course) both in WYSIWYG and HTML mode, but when the post displays to the public the tag isn't there. Makes things a little cleaner, without changing the operation of the calendar.
Jimmy,
You don't need to do that. If you have rights to create calendar events and you place a tag in the body of your post, the tag is removed from the display body of the post. All posts within CS have a Body field that contains the editor contents and a FormattedBody field that contains a scrubbed version of what is in the Body field and is used for display.
You said your CS2007 Calender is compatible with Dan Bartels' Calender control. Does that mean that I can use your control in my CS2.1 SP3 installation?
Razza
Hi Razza, if you upgrade to CS 2007, the answer is yes. The control is a Chameleon control, which is not supported in any version prior to CS 2007. Dan Bartel's CS 2.x control is currently the only solution for CS 2.x.
-Bill
Hi,
I am keeping get the following error messages in the exception report:
User Agent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; FunWebPr
Path: /themes/default/forums/threadlist.aspx?ForumID=169 as HTTP GET
Referrer: /forums/default.aspx?GroupID=24
Message: Object reference not set to an instance of an object.
Any clue?
Make sure that you didn't change something by accident (i.e. typo) and that you followed the instructions exactly as they are written. Does this occur on every page? If you only see this in the logs, then it is either a hacker or some one who has disabled cookies.
This should be included in 2007! It's a bug that it's not!
Is it possible to have an event last more than 1 day?
No, but you can add multiple [cal] tags to a single post.
For some reason the non-admin logins cannot view the calendar. They get "Not Found: Forum Not Found
The forum you requested does not exist." Am I doing something wrong. I tried Dan's version and I get eh same error. Please help. I am almost there.
Are the users able to read the forum directly? It sounds like you have not given them permission to read the forum where the posts are. Make sure they can navigate to the post w/o using the calendar. If they can't, you will need to fix the permissions.
How to control the height?
I am using the Height="1000px" in the WGB:EventCalendar property, but the calendar still cut off the dates if there are too many events in one day.
Can we define the "Auto" for the heights? Which means the control will auto-expand to hold all the events and all the date in one month.
Hi Qingsong. I just tried it myself and it seems to be working as expected. Changing the Height to 1000 attribute does make the calendar area longer. The actual calendar is being created by the ComponentArt control. The control does not support an Auto feature that I am aware of. Have you tried setting the Height to 2000?
As I said before, it appears that you are attempting to use the calendar in a way that it was not designed to be used and is not supported by ComponentArt. I would seriously reconsider the way that you are using it and think about alternatives.
Hello... I am new to this and could use some help. I installed the calendar and it shows up fine. I added a test post with the cal tags but nothing shows up on the calendar... any ideas
Hi flynnjo. Did you place the tags in the body of the message?
hi,
I downloaded your calendar control and I am trying to make it work in my local CS installation. I did all as you mentioned in the readme.txt file but I still can't see the calendar tab in my homepage. anything else I might be missing?
cheers,
-Edge
Hi Edge,
It looks like I left out one step, which I'll add to the ReadMe.txt file. Step 7 should read that you need to merge the SiteUrls_merge.config file into your SiteUrls.config file. That is what adds the Calendar tab to you menu.
Take it easy,Bill
Hi Bill, we are currently implementing CS2008 into our community and I would love to add your calender addon. Any beta for testing available yet?
Would be great. Please inform me: ralf (at) sip-scootershop.de
Thanks and greetings,
Ralf
Hi Ralf,
The long term contract that I was working on just ended last Friday, so I'll be starting on the new control this week. I've got some new ideas on how I'd actually like to do it, but it's going to take a bit of testing to see if it will work. I'd like to make the entire calendar 100% configurable from the ASPX, including the layout.
Rob Howard while working in Microsoft, was one of the architects of .NET Framework v2.0. You can read his early posts in his weblog in http://weblogs.asp.net/rhoward to read about his contribution.
It's no mystery that CS in using the same technology and design patterns...
George J.
Hey George,
Long time no see. I've known about Rob's 6+ years at Microsoft for quite a while and that he is one of the original "architects" of ASP.NET, but I didn't really know about how much of an involvement he had with the .NET Framework other than consuming it for the ASP.NET System.
Very few people know why certain things were done the way that they were, as many of reasons haven't been documented. This article should help a great number of people who have been struggling with the data access portion of Community Server and give them ideas on how they can use it in other applications and areas.
Is possible to add calendar control in sidebar like at www.getinspiredhere.net
Hi reyza,
The answer there is no. That is a completely different type of calendar and functionality. The functionality that that site is using is already a part of Community Server. It is just one of the many blog themes available, though they are using a custom one. Check out the diffent blog themes to do what they are doing there.
I've been with CS since 2.x and it's sad to see old pros leaving the community. I'm just a hobbyist who didn't want drupal or some other LAMP-app which wasn't finished. Now it seems that I'll just have to be content with what Telligent serves us since most CS pros are gone.
Thanks for helping me at the forums!
Hey Tore,
I'm going to be around for a while, so don't be too bummed out. I talked with Rob Howard and Josh Legard about my concerns and they have assured me that they are addressing my concerns, some of which have already been addressed. I promised them that I wouldn't make some of what we talked about public, but if you can hang in there for about a year, you should be pretty happy.
Right now there aren't any options for small to mid-sized businesses and hobbyists as CS no longer supports them and Graffiti doesn't have enough features. Over the next couple of months Telligent is increasing their investment into Graffiti and around May of next year you should see all of the features that you need.
I hope this helps,Bill
Hi Bill,
We do have a document which covers the CSContext changes. I am hoping we get it published today.
The changes were much bigger than we had hoped, but were a necessary change to make to support Wiki and other behind the scene updates we are hoping to make in the future.
Scott
Hey Scott,
That's cool. I've been doing quite a few custom jobs lately, so the CSContext changes sort of stuck out, especially when I tried to compile my calendar control. I'm hoping the events have been fixed, in particular the blog events, but I haven't had a chance to look at them yet.
Thanks for the comment,Bill
I see where you're going on this, Big Guy. You're right, WinMerge and other approaches are way too messy. Once I walk through this in my head (after a few slaps) I'll flash that huge smile your way. Thanks for the post.
What parts of announcement did you find disturbing? While there will be future changes, existing customers/users should not be effected.
There have been quite a few changes over the past 6 months that have made it impossible for anyone that does not have a budget of at least $100K to use Community Server. The changes that Burt announced and the changes in pricing are making it very clear that Telligent does not want to do business with anyone but Enterprises.
I know that you were trying to move these other people to Graffiti, but you have to agree that it will be at least a year before Graffiti is at a level equal to that of CS2.1 or CS2007. Not having a search ability in CS makes the forums useless. What are these people suppose to do in the mean time?
Also, the very first item for Q1 09 CS 2009 is, "New default theme". The #1 complaint that I have seen since CS 2008 was released is this constant changing of themes which costs users huge amounts of money to update their custom themes. It was only 6 months ago that you said you were only going with Hawaii and to design everything based on that theme, and now you are dropping Hawaii. That is what is disturbing.
Hello-
I am about to do a CS2008 install for a University Alumni Assoc.
Would really like to have a Calendar Control. :)
Tony Camero
641-919-7415
As I mentioned on the thread at communityserver.com this is being looked into and will be corrected.
Rob
Hey Rob,
I am sure that you understand the concerns and look forward to see how this is addressed.
I really like your post. Does it copyright protected?
Hi Katty,
I'm not sure what you are asking. Could you restate it?
Thanks,Bill
Yeah, I'm really disappointed too. I was a big Telligent and CommunityServer fan back in the day, and I kept hoping that Graffiti would take off.
Thankfully, I never bought a license for Graffiti, but I do need to migrate away from CS.