CS Nuggets

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.

Bill,

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.

Take it easy,

Bill

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

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.

Take it easy,

Bill

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".

Thanks.

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.

Thanks.

Hey stumpy, on the install script, try doing a search for '8000' and replace with '4000'.  That may fix your problem.

Bill,

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.

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?

Thanks,

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.

Take it easy,

Bill

Bill,

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.

Thanks,

Jimmy

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.

Take it easy,

Bill