Monday, 18 February 2008

Version 2 of the Colour (color) Calendar Released

I have finished working on what I hope is the final version of the colour calendar.

The previous version was well received but was lacking in a couple of areas. Firstly it required the creation of custom calendar lists. The custom list was based on the in-built calendar list but was missing some of the functionality like Connect to Outlook. Secondly you had to manually add the colour coder web part to calendar view screens.

The new version is built right into the existing SharePoint calendar list. Once you have deployed the solution you will find a new option under list settings for calendar lists to enable and disable the colour coding functionality.

Enabling the functionality creates the needed columns and adds the web part to any calendar views present on the list. Simply by clicking the enable button you will have a working colour calendar.

Disabling the functionality simply switches the display titles back to the default, it does not remove the colour coding web part or remove the columns so that you do not lose data. You can simply switch it back on again to see the colouring.



The colour coder web part works as before defaulting to a central colour mapping list in the root web but you can override to a local one if you wish.

If you add additional calendar views to your list, simply disable and then re-enable the functionality to have it applied to the new views.



It has been built so as to be upgradeable from the previous version. If you run the upgrade script as opposed to the deploy script then you will find your old colour calendar lists still work but the option to create a "Colour Calendar List" will be removed. You can obviously just use the new method for any new colour calendars you wish to create.

Thanks for all the feedback so far.

As usual the latest release can be found here

Regards,

Mark Wilson

176 comments:

Anonymous said...

Thank you so much, i posted my question yesterday. And with this version it works beautiful on my existing calendars.

Greets en keep on building these great addons

Anonymous said...

First of all thank you for your webpart.

I experimented a little with your latets creation. I changed the choise column in the Colour list to single line text. So that I dont need to change the events choise a three places.
Now i want to change the Event Category column in the Calendar to a lookup Column. But a calculated column cant use a lookup column for input.
Is there a way to achieve that you dont need to put in choises in the calendar Event Category column?

Thank you for your time,

Daniel

Mark Wilson said...

I am not sure what you are trying to achieve? If you want to just update the colour categories in one place you can do this now. The Event category column is defined as a site column in the root site. On the root site, go to Site Settings -> Site columns and add the caetgories to Event Category and choose the option to push the changes down. All calendars and the mapping list will now pick up the changes automatically.

Anonymous said...

Hello!!!Great addition to the calendar!!

Could I change the colors so they are based on the user that created the item?

Thanks in advance

Anonymous said...

Thank you for this webpart ... it is exactly what I was looking for!

Myron

Ole Andreas said...

Is it possible to use multiple Event Categories? For instance, in addition to having the default category with "Business", "Important", "Meeting", and so on, is it possible to have another category such as "Consultant" (examples "John Doe", "Mark Nobody", "Johnny Puma")?

Ole Andreas said...

Mark, excellent work! v2 is easy to both install and implement, I really like it. Thank you so much.

I have managed to customise it so that for different calendars I have different event categories. For instance, I have a calendar based on people where I have colour coded items by name, as well as another one colour coded by task status (Started, Completed, Invoiced, etc).

What would be really cool is the opportunity to have multiple colour coding categories per calendar, with necessarily one being the default/overriding one since there can be only one colour coding active in any one view at a time. Following my example above, I could use a calendar to register jobs/tasks to be done for clients, and then have one view colour coded by tasks assigned to people and one view colour coded for task status.

Do you think this is possible?

Mark Wilson said...

You should be able to do that now. If you crate a new calendar view on the list, disable, the re-enable the colouring it will place a colour coder web part on the new calendar view. That web part can be configured to point to a different mapping list somewhere and you can update the categories to include both types. The only slight drawback is having to have a single choice column with all the categories from both views in it.

Anonymous said...

I still have an error :

"reference to an inexistante column"

?

Mark Wilson said...

Can you provide a screenshot? Did you have the previous version installed? I have not seen this error before. You can email me with more detail blog@planetwilson.co.uk

Yonz said...

Hello,

This is exactly what I was looking for. Thanks for the good work!!!

However my department had already started using the "Old" Colour Calendar, so my question is ... is there a way of moving the data from old to new?


Yonz

Yonz said...

Hi Mark,

Disregard my last comment ....

I managed to transfer the Calendar data from one cal to another via MS-Access

Yonz

Uwe said...

Great feature!!! But I cannot get it running :-( I have deployed it successfully. But when I click on "Enable Colour Calendar" only the error-side appears. We use WSS 3.0 english but with German language enabled - could this be the reason? Is there a solution/workaround?

Mark Wilson said...

Can you send me an example of the error please?

Anonymous said...
This post has been removed by a blog administrator.
Mark Wilson said...
This post has been removed by the author.
Susan Lennon said...

Thanks Mark!! Great work. I plan on using your code from Code Plex as part of a demo at the Orlando Code Camp - scheduled for March 22, 2008. Just wanted to let you know and I'll be sure to give you full credit and provide everyone with the links to Code Plex and your blog.

Susan Lennon

Anonymous said...

I have only used Sharepoint for a short time - thank you so much for doing this!! But I must be doing something wrong because I cannot seem to see it listed in my General settings? I have WSS V 12.0.0.4518. I ran the executable but it states the the site URL is wrong? I am sure I typed it in correctly http://mysite/ but it does not load? Is there a step I am missing? do I need to add those file definitions like in the previous version? This is a new fresh install by the way - I have never used the previous version. thanks!! C

Mark Wilson said...

Can you email me the errors you got running the script?

Thanks,

Mark

Cyndi said...

I would be happy to email the error to you - what email should I use? thank again!

Mark Wilson said...

blog@planetwilson.co.uk

Anonymous said...

I'm not sure how to deploy this calendar. I really havent' done a lot of this - yet..........

Anonymous said...

Hi Mark,
Love the idea but just cannot make it work, I updated the PWEventCategory with our choices which work for 1 calendar item but all the others show the category followed by ||| then the description, e.g. "Business ||| Site Visit ". can you point me in the righ tdirection please.

Mark Wilson said...

Can you email me directly at blog@planetwilson.co.uk and I'll see what I can do.

Tom said...

Nice addon. It would be helpful if you consolidated the instructions for the setup. The old article says to go to version 2 but then version 2 doesn't give instructions for setup of color mapping, etc...

nick said...

Thank you for this feature. It is very nice. I like how easy it is to set it up. A question I have is this, "How do you change the categories and what color is associated with them?"

Mark Wilson said...

The categories are defined in a site column, go to site settings in the root site, site columns and change the event category column. A colour mapping list is created in the root then maps foreground and background colours to the categories. I will try and get time to produce a proper manual for it.

Michael said...

Great work Mark! I'm having an issue and hopefully you can help. We use MOSS 2007 Enterprise. Our main site is a Team Site Collaboration. I created a Calendar List and enabled Colour on it. I also customized the list with catergories and colors. Everything looks perfect when I'm viewing the Calendar List directly. But, when I create a Web Part on the front page to the Calendar, it's not in color. Instead it displays "PTO|||Test PTO". The first PTO is the Category, the Test PTO is the Event.

Mark Wilson said...

You need to add a colour coder web part to the page after th calendar view web part.

Enabling the colour coding does this for you on the main calendar screen itself.

Michael said...

I figured it out. I added the wrong Web Part below the Calendar. I first added the Web Part under Site Gallery that didn't work. I then added teh Web Part under Server Gallery and that did it! Thank you so much!

Anonymous said...

Great feature!!! But I have the same problem as "uwe". When I click on "Enable Colour Calendar" only the error-side appears.
Did you find a solution/workaround for the language problem?
I use WSS 3.0 installed in French language.

Thanks in advance

Anonymous said...

Hi Mark,
firts, Thank you for good work.
the installation is ok
but when i try to Enable Colour Calendar
i have an error: reference to an inexistante column
i haven't the previous version installed.
thanks a lot for your help

Mark Wilson said...

To those having problems with the non existent column issue, are you all running on a language pack? Can you email me at blog@planetwilson.co.uk

Anonymous said...

Mark - thank you very much for your colour calendar. It works GREAT ! Just would like to ask you if you are planning to post some instructions about how to change the colour schema and rename the categories. Thanks !!!
Andrei.
andreich01@yahoo.com

Mark Wilson said...

There is an event category column defined as a site column in the root site, ad new categories in there (choose option to cascade changes don) and then go to the colour mapping list in the root site and change the colours in that list which have been mapped to each event.

Anonymous said...

>Great feature!!! But I cannot get it running :-( I have deployed it successfully.
>But when I click on "Enable Colour Calendar" only the error-side appears.
>We use WSS 3.0 english but with German language enabled - could this be the reason? Is there a solution/workaround?

i encountered the problem myself on a my sharepoint which is in french and found the solution:

in the assembly, in the enablecalendar() method, when the field PWEventCategoryTitle is created, the formula references the 'Title' field
the problem is in formulas, references are on the display name (too bad..) so the solution here is to get the display name of the title field instead of hardcoding it, so it will work with whatever display name is set in the title field.

thanks for this awesome feature anyway.

Mark Wilson said...

Thank you for that, I will see if I can come up with a solution for this.

Cheers,

Mark

Meakin said...

Hi,

I've had a few issues with my MOSS installation and I'm trying to completely remove the Colour Calendar but I'm having problems deleting the PWEventCategoryTitle column. How do I remove this column?

Thanks

Andy

Mark Wilson said...

Hi Andy, sorry for late reply, I am out of the country at the minute, I will look into this and get back to you. I think it might be due to a bug, I need to fix it and do a new release,

Apologies for any inconvenience. You should also be able to remove the field using the excellent SharePoint explorer tool in the meantime http://www.codeplex.com/spm

Anonymous said...

Great addition Mark, I have this on my iPear Ltd Intranet t;-)

Mark Wilson said...

I have updated the release which should sort out the problem o removing the event category title column and hopefully language issues too.

Uwe said...

Great Mark!!!
With version 2.1 this great tool is running properly with other languages too. Thank you very much!!!

Anonymous said...

The version 2.1 didn't resolve the language problem :(

With the solution explained a little higher, I get rid of the problem ...

On Sharepoint, in the Parameters Of the list where I want color enabled, I create manualy a column with this info :
name: PWEventCategoryTitle
type: Calculated Value
formula: [Event Category]&"|||"&[Titre]
result type: Text

For other languages as french, in the formula, change the value [Titre] with the one in your language. ("Title" = "Titre" in french)

After that, I can enable the the Color Calendar without any problem :)

Neel said...

Mark,
I installed redeploy.bat file successfully but the color calendar template not able to see inside the Custom list. Also, colour calendar mapping template able to view. Let me know, where I made the mistake

Mark Wilson said...

The colouring option appears in the settings for a normal calendar.

Anonymous said...

Mark,
I saw, that the comments will not be published immediately, so I would like to specify my problem: If your solution also works under WSS 3, I can tell you the error I receive in the event log:

The application-specific permission settings do not grant Local Activation permission for the COM Server application with CLSID
{61738644-F196-11D0-9953-00C04FD919C1}
to the user NT AUTHORITY\NETWORK SERVICE SID (S-1-5-20). This security permission can be modified using the Component Services administrative tool.

Any ideas?
Thank you very much,
C.

Mark Wilson said...

To anyone having problems with the language packs please get the latest v2.2 version which fixes them.

Mark Wilson said...

To the person with the eventlog error - this is a common error with SharePoint and not to do with the calendar. You can ignore the error or fix it by changing launch/activate permissions in component services for the IISWAMREG service.

Anonymous said...

Hello Mark,
[Still using "Anonymous", as I have no other identity :-( If the mentioned event log is "normal", I will ignore it at this time]

I reinstalled your tool version 2.2, but still I cannot see the web part on my calendar.

I think the web part is installed correctly, as I can see this information on the "solution management" page:
planetwilson.sharepoint.colourcalendar.wsp Deployed http://SERVERNAME:12345/
(the port 12345 is matched to https ...)

To be sure, that problem is not because of any language problem (I am using english WSS3 with german team sites), I have created a english team site, but still cannot find anything of your web part on the list settings ...

I really would like to use your tool, as my director yet asked for a colored calendar :-(

Do you have any idea? What or where can I check the corrdct installation? Is it definitly working on WSS 3???

C.

Mark Wilson said...

Can you email me directly at blog@planewilson.co.uk ?

Kerrie said...

Hi-
Does this web part pull across site collections and not just sites within a collection?

jerome said...

about the problem with languages:
instead of looping for all fields until you find the one with a correct internal name, you can do this directly:
list.Fields.GetFieldByInternalName("Title")
and the value in <fieldref name='' /> is supposed to be the internal name so the original code was good.

hope it helps

Mark Wilson said...

Are you saying that you are still experiencing a problem with v2.2 and languages?

Rich R said...

Thanks for this very useful web part.

When I try to edit a page with a Colour Calendar web part, I get an error message that I cannot edit the page because it contains a web part that is not registered as safe.

Do I need to take some extra steps to register this web part as safe?

Anonymous said...

Great work!. However, I haven't been able to install this solution.
I don't know if this is the best approach but I did the following:
I could added the .wsp file but not to deploy it.When I tried to deployed via command line with "stsadm -o deploysolution -name PlanetWilson.SharePoint.ColourCalendar.wsp -allowgacdeployment -immediate"
I get: "This solution contains resources scoped for a Web application and must be deployed to one or more Web applications."

I don't know what to do now.

Pls advice.

Thanks

Mark Wilson said...

Rich r - how did you install it? using the batch file with the solution? You can email me directly if you are still having problems. blog@planetwilson.co.uk

Mark Wilson said...

The solution install provides the safecontrol entries, are you a site collection admin? Did the install batch file give any errors? email me if you need some more help

AndyJ said...

Hi Mark, great work. I just found this while investigating ways I could implement a simple centralised holiday tracking system. I combined your work with the existing SP template (the HR tracker one) and its pretty much exactly what I was after. Only thing I can't figure out is how to make the colour calendar base its "Event Category" column on the existing "Absence Type" column found in the HR thing. I get the impression that this is quite possibly a very obvious thing for someone who knows a little more sharepoint than I do!

Bei said...

Mark, excellent work! Thank you for sharing this with the sharepoint community.

Anonymous said...

I downloaded v3.3

I am really confused about how to install etc.

This is the first time I am visitng this blog and although I am into Information technologoy field, I am not a sharepoint expert or hardcore developer.

I have a XP machine for me (which has visual studio 2005 with .Net 2.0 loaded). We have a MOSS server on the intranet which I can access locally. I do not have access to WSS.

My questions are :-

a) From the installation zip file, what should I put in the redeploy.bat where it says "http://localhost". The IIS in my XP machine has multiple virtual directories. So do I need to create a new virtual directory with a different port and then put that where it asks in redeploy.bat?

Also since MOSS server is not on machine (as it is XP), do I need to run redeploy.bat on MOSS ?

After this, I guess redeploy.bat will run those WSP files and then I can directly go and check features of calendar?

Requesting anyone to suggest (including those who have downloaded and worked it out) how to install and workaround. This seems to be a great application.

I understand it may be very basic questions, but immediate help would benefit me further.

Mark Wilson said...

Yes you need to run the install on one of your SharePoint web front end servers.

Anonymous said...

>>>> Mark Wilson said...
Yes you need to run the install on one of your SharePoint web front end servers.

-----------------------------

Thanks.

So I should be installing on the MOSS server I mentioned in my earlier post?

Also what should I put in redeploy.bat (where it say "localhost")

Also from the source which file I should check to see "where coloring logic is handled" and "how calendar events are defined/triggered".

Expecting your quick reply as you always do.

Appreciate your help.

Mark Wilson said...

I am unsure what you are trying to do.

Installation:- run the intall on the SharePoint server, run the batch file and enter the URL of your SharePoint site when prompted. Alternatively download latest release and look at the user manual.

For development you will require Windows Server with SharePoint and Visual Studio installed. SharePoint development is a whole different topic you will need to Google.

Anonymous said...

Thanks Mark.

I hope I understood your points.

I will setup a windows 2003 box and on that I will put MOSS and visual studio 2005 (net 2.0). Then on this box I will run redeploy.bat and put v3.3 sourcezip on that 2003 box and start working.

Correct me if above is fine.

Also does the v3.3 source open with visual studio 2005 (net 2.0).?

Thanks again.

Mark Wilson said...

Yes that would get you an environment where you can view the source code. You do not need to have installed the release though if you just wish to work with the source code. The solution file has been upgraded to VS2008, however you should still be able to open the project itself in VS2005.

Anonymous said...

Thanks Mark.

My visual studio is 2005 with 2.0 framework. and when I opened the solution file it gave me errors.

Questions

1) After retrying I could open "PlanetWilson.SharePoint.DebugSwitcher" solution file. I can use the debug one or "PlanetWilson.SharePoint.ColourCalendar" solution file?

2) Do I need to put framework 3.0 runtime on the server?

I am using sharepoint 3.0 central administration.

I appreciate your time and help.

Mark Wilson said...

You need to open the project file, the solution file is only compatible with VS2008. Email me directly if you have any more questions. blog@planetwilson.co.uk

Emmanuel Perez said...

Hi all,

Thanks for this great tool.

I have deployed successfully but when I try enabling I get:

Unable to find list "colour calendar mapping" in site "http://mxmex-sp01:43870/. Please check that the list exists and/or you have permission to it."

Pls help!

Emmanuel

Mark Wilson said...

Can you check that you have permissions in the root site? Can you get to site manager there and see if you can see the mapping list?

TH said...

Great work! Installation was a breeze.

Is it possible to use this with a calendar view of a custom list like a task list or does it only work with /calendar.aspx lists?

Anonymous said...

Very very nice. Thank you for all the effort.

Al

Jim said...

Looks good. Unfortunately I receive the following error during the final installation step (activatefeature).

Feature 'a3c57d6d-bc96-44ea-a169-0e41bb429ee1' is not installed in this farm and can not be added to this scope

Any suggestions? I'm trying v2.3 with WSS 3.0 and W2K3.

Mark Wilson said...

Can you email e directly with a screenshot - any errors during deployment?

Anonymous said...

Hi Mark, Great web part, thanks. I've been using the previous version for a while now and love it. have yet to play with this new version. One question I have. Periodically, when I "expand all" on Calendar view, I still have some days where "# more events" is listed at the bottom of certain days in Month View. Someone else posted a comment on your previous version's blog on 14 January, where he'she had observed the same issue. Were you ever able to look into this? ... your original response on 14 Jan ... "I am not too sure at the moment, I think it must be down to the stylesheets having some target media stuff i them. I'll see if I can find out..." I'm curious if you found anything out. Is this a bug in the Microsoft SP Calendar code or something else? Again, no criticism and thank you for your great work!
R/Scott Macdonald Norfolk, VA USA

Mark Wilson said...

My code doesn't do anything with that so it must be the way SharePoint behaves.

Anonymous said...

Thanks Mark...I'll keep trying on this end...thought it was a Microsoft issue.
R/Scott Macdonald

NWBlue said...

Hi

This has been deployed on the server (I have no access to it or the web application) by the administrator and now I cannot access the Site Column gallery on the top level site (the URL it is deployed to)it just comes up with unknown error.
The subsites column gallerys can be accessed but not edited and the new catagories can be seen and they are also the enable colour coded calendars has appeared on all the sites calendars.
Please can you advise what to do or how to uninstall?

Mark Wilson said...

I am afraid that without any more detail as to what happened during installation I do not know what has gone wrong. If you wish to uninstall then simply edit the redploy.bat file to only run the first half of the commands which retract then remove the solution.

NWBLue said...

Hi, thanks for the quick response - all I know is they got errors on the first attempt and nothing appeared - when I rang them it turned out they hadnt put the port number (its part of the URL) in - they run it again and putting the corrct URL - this is when the error occured when trying to access the colunm gallery.
I would like to try and get it working if possible what do you suggest?

Mark Wilson said...

They probably need to try and uninstall from the first server and then reinstall again, it is hard to say without looking at errors they have had back. Were any errors reported the second time it ran?

NWBlue said...

Hi
There were no errors the 2nd time it ran. I will ask them to remove and reinstall and see what happens.
Can you confirm if Deleting everything after
ECHO On
to uninstall?

TIA

Mark Wilson said...

There are 6 lines running stsadm commands in the script, the 1st 3 uninstall and the last 3 install. Depending on what you want to do, run either the first 3, the last 3 or all of them.

NWBlue said...

Sorry but I am still having trouble with this - the script was run again after editing to remove the webpart and I still have no colunm gallery and this error appears underneath the calendar on the top level site

Error: System.IO.FileNotFoundException: The site http://proteus:28608/ could not be found in the Web application SPWebApplication Name=SharePoint - 28608 Parent=SPWebService. at Microsoft.SharePoint.SPSite..ctor(SPFarm farm, Uri requestUri, Boolean contextSite, SPUserToken userToken) at Microsoft.SharePoint.SPSite..ctor(String requestUrl) at PlanetWilson.SharePoint.ColourCalendar.CalendarColourCoderWebPart.GetColourMappings() at PlanetWilson.SharePoint.ColourCalendar.CalendarColourCoderWebPart.Render(HtmlTextWriter writer)

any ideas

Mark Wilson said...

It is very diificult to help through these comments, can you email me directly please at blog@planetwilson.co.uk

Also you will need to get copies of the output when the script is being run.

Anonymous said...

Hello Mark,

I have used your calendar control and I have following questions.

a) Is there a way to print the calendar? Are there any tools/good links that will help to generate printout of calendar appointments (with color)?

b) Is there a way to export the calendar appointments as an "appointment entry" to outlook/lotus notes such that user gets it as an appointment (not as an email text)?

Thanks a lot. Please respond.

Mark Wilson said...

I don't think any such tools exist currently, it is just a normal SharePoint calendar, you can use this post to give pointers on how to export to iCal format.

http://blogs.msdn.com/sharepoint/archive/2007/05/14/understanding-the-sharepoint-calendar-and-how-to-export-it-to-ical-format.aspx

Anonymous said...

Thanks Mark for the feedback.

For printing, I found this. Is this something good? please suggest. I wanted to implement this.

http://blog.thekid.me.uk/archive/2007/07/22/easily-print-sharepoint-lists-using-your-own-template.aspx

Many thanks.

Mark Wilson said...

I don't think that could be used in this instance it is fairly simple css layout of XML data. It would require a complex stylesheet to generate a calendar in the same way.

Anonymous said...

Hello Mark,

I posted two more questions after your last reply. Hope they are received on this blog. Should I repost them?

Many thanks.

Mark Wilson said...

Can you email me directly please at blog@planetwilson.co.uk, the blog comments isn't an ideal forum for detailed discussion!

Chanda said...

Hi Mark,

Great feature - we've been looking for something like this for a while now. I've been able to install the solution just fine, but I do have a question. Is it at all possible to use a field other than Event Category as the basis for the color coding? For example, we have a room reservation calendar that allows end users to create event items but requires approval of those items by a subset of folks. I'd like to color code the calendar items based on the "approval status" column so that Pending items display in red while those that are Approved show normally. Is there a way that I can accomplish this using your solution?

Thanks in advance - Chanda

Mark Wilson said...

Yes but would require a change to the source code to make the calculated column work off different fields. Alternatively you can try the more manual approach to colouring calendars in one of my earlier posts from September last year.

Anonymous said...

I am having problems customizing the colors. I can get the drop down to list the correct options I want to show, but when any of them are selected, no colors show up (as if this wsp was not installed). I added a color map list to the sub-site I am trying to get colored, but am unable to connect into it. When I look at the properties of the "PWEventCategoryTitle" all I get is "Calculated (calculation based on other columns)" and am unable to view/change the calculation.

How can I get it to use my new color map?

Mark Wilson said...

Can you email me directly with some screenshots?

Anonymous said...

Hi, Can I use this calendar with WSS 3.0?

Thanks,

Mark

Mark Wilson said...

Yes you can.

Anonymous said...

Mr. Wilson,

You have made my employees very happy with this! Thank you very much! We really appreciate it!

I have a question. I know you can sync SharePoint and outlook calendars.

Could the SharePoint color codes be tied to the "LABEL" color codes in the outlook calendar so that if I color code the SharePoint calendar the synced outlook calendar would have the same colors?

I'm guessing there maybe a "hardcode" issue with what SP passes to outlook, hence the green synced calendar (With Outlook 2003).

But, I believe that Outlook 2007 allows full calendar sync. So do the colors come over into Outlook 2007? If not, could your calendar be setup that way?

Thanks,

Mark

Mark Wilson said...

This ia common request but I believe the answer is no, Outlook would need to know to take the category field and somehow apply a label to it.

Joe said...

Hi Mark,

Can i use this with WSS 2.0??

Mark Wilson said...

No unfortunately not. You can get colouring workign by following one of my earlier blog posts from last year but it is a lot more complicated to do.

Stephane said...

Hi Mark,

Thank so much for this very cool feature I cannot understand why M$ could not think about it. I wanted to know if the same feature could work in a small calendar ?, I found this mini calendar csegSmallCalendar and my idea is to display a year page of mini calendars with days colored base on the event category.

Thanks in advance for your advice.
Best Regards
St.

Mark Wilson said...

My solution relies on the exact html output by the MS calendar - the principle could work just fine - it would depends on the html output by that guy's solution. It would still require some recoding though.

Anonymous said...

Mark,

Thank you for this.

Question, How do I populate Event Catagory when create a custom Color Mapping? My dropdowns never have anything in them.

Thank you.

Mark Wilson said...

Go to Site Settings -> Site Columns in the root site. Edit the event category column and select the option to cascade the changes down. This will force the category drop downs to update.

mark said...

Mark thanks for a really cool feature. I just told our team last week that MOSS doesn't have color calendar funcationality, and then I was just finishing the testing on Outlook Categories (colors) and thought I'd do a search online and I found this tool. GREAT tool. Everything works fine after you figure it out (Color LIST that stores the color values).

Awesome. I'll check back for updates regularly.

We are deploying MOSS 2007 middle of September so we're kicking the tires quite a bit. Any suggestions on document management tagging would be great!

Anonymous said...

any chance you are going to fix it to work with non-english sites?

Mark Wilson said...

It has been fixed to work with non-English sites.

If you are still experiencing a problem, please contact me directly at blog@planetwilson.co.uk

Anonymous said...

i installed and it worked great on a one server farm (web moss and db all in one).

But when I attempted to install on farm with a wfe i am running into problem.

I attempted to install on the WFE and it could not activate it. when I checked solution i saw it was not deployed, so I manually deployed.

I reran the redeploy after that it appears to have activated.. though I can't see it anywhere in site features.

However, after all that I don't see the enable option in list settiongs general.

If I attempt to run the activate step manually from the command line it says it's already activated. But why is it not even in my feature list?

One difference I see is that in solutions it list all the moss servers instead of saying globally deployed like all my other solutions.

Thanks.

Mark Wilson said...

You need to check Site Collection features NOT site features. Are you a site collection admin?

Joe said...

Hi - where can I find the instruction manual?

Mark Wilson said...

if you download the latest release you will find a PDF in the zip file.

Sean Moran said...

I am having a similar situation. When I deployed to a one server farm, all was well. When I deployed to a farm with central admin on Machine1 and web content on Machine2, I cannot see the calendar in site collection features. I can see the files in the 12 hive and GAC. I have always installed features like this on Machine1, so I'm assuming that is where these go. Can you help figure out how to activate this feature. I have not bounced IIS or the machine (it's production). Is this necessary for a multi-server farm? I thank you for your help (and the cool component!)

Mark Wilson said...

I am not sure I understand your situation, if the machines are members of the same farm then all web apps should be available on all web front ends. It is roles which split on to different machines.

Sean Moran said...

Let me see if I can be more clear.

I installed the Colour Calendar on the machine running Central Administration. I was logged in as a farm administrator that is also a site collection owner. The install went well, and all of the files are on the machine. However, there is no mention of the web part, or the site columns where they are supposed to be.

When I installed this component on a singe-server farm (2 in fact) it all worked just as it should have.

Any help will be appreciated.

Mark Wilson said...

..and you have definitely checked the feature is enable under site collection features on the site you deployed to? Probably easier to discuss this over email, blog@planetwilson.co.uk

eCurb AO said...

A brilliant piece. I was asked about this yesterday and google brought me to you!! This works great and was what I was looking for! Thanks Mark

Tom Winter said...

Works great and installed easily. Thank you very much.

I would like to be able to have two different views that color the events based on two different fields. I know you can do this, but all the categories have to be in one column (which I'm afraid will confuse my users). It would be great if the next version, perhaps in the webpart, allowed you to pick which column to color code things based on.

Anonymous said...

Hi Mark

thanks for your solution.
I'd like to ask you a qyestion. When I use you color calendar the month view title is Title ( it's clear cause it's specifed:[Absence Type]&"|||"&Title ). the problem is that I need to see a "create by" cause it's more importatnt then the title. Unfortunatelly I cannot use calculated value:[Absence Type]&"|||"&[Created By] cause it's not allowed by sharepint ( wrong date type )
Do you have any solution how to see not Title but Created by value of the item.
thanks in advance
peter

Mark Wilson said...

I am afraid that the Person type field cannot be used in a calculated column, You would need to code an event handler which took that value upon a listitem update and did some action like setting a text field that you could use in a formula.
That would require development however.

ggill1970 said...

All -- if you Calendar View still shows calendat items listed as "Category|||Event-Title", make sure the PlanetWilson Calendar Colour Coder web part is BELOW your calendar. i am using a flavor of V2 BTW. this "Category|||Event-Title" seems to be the case on web part pages & the calendar view (web part page).

imiddleton25 said...

I love the calendar in school it looks great but when parents view(or anyone outside) it does not see for yourself at


http://89.105.117.210:26418//Lists/School%20Calendar/calendar.aspx

any ideas as i am getting a lot of stick about it

Mark Wilson said...

It looks to me like the user that the external users come in as (anonymous user?) can't see the mapping list. Have you tried to edit the access on the mapping list to allow anonymous access? if you can't allow that on the main list at root you may need to create a new mapping list in the calendar site itself and use that.

Fredrik J said...

Thank you for a great feature. I have two questions.

1. Is there a way to show the "PWEventCategory" next to the "Title"´in the calendar view. I know the field shown in the calendar veiw is "PWEventCategoryTitle", but is there a way to get that calculated field to show the categoy in text?

2. Is there a way to change the default colorlist pointer. Mine points to a bad place by default for some reason, so i have to change the mapping on all calendars I create. Running the redeploy.bat does not help.

Thanks in advance!

Mark Wilson said...

No I am afraid that there is no way to change the default mapping list. Also the calculated PWEventCategory column would need to be change to something like

category & "|||" & category & " " title

or similar, I don't have it up in front of me. You could create a new calculated field and configure the calendar to use that instead.

Lester said...

Mark, thanks for your solution. I'm not sure if I'm overlooking something or what but I'm trying to change the default Color mapping for my calendar. I cannot find any url property to alter. Please explain how to find the property. Thanks.

Mark Wilson said...

You need to edit the page with the calendar view on it, then you need to edit the properties of the colouring web part which should appear under the calendar itself.

aroh said...

Hi Mark,

I have followed these steps:

Step1: Open the SharePoint Central Administration page >> Operations page and click on Solution Management >> Clicked on PlanetWilson.SharePoint.ColorCandar.wsp and deployed successfully.



Step2: Site Collection Administration >> Site collection features >> Activated the "PlanetWilson SharePoint Colour Calendar"


Step3: Site Administration >> Site libraries and lists >> Customize "Calendar"

Step4: General settings>> Click "Enable Colour Calendar"

Step5: Go to home and got the some error.
Unable to find list "colour calendar mapping" in site "http://win2k3r2ee/. Please check that the list exists and/or you have permission to it."

It would really great of you could you help my about this. I really struggled for 3-4 days to solve this.
Thanks a lot for help in advance.

Regards,
Aroh

Mark Wilson said...

I discovered a bug in the code which I fixed today, can you get the latest version install and try again?

Chad said...

Mark first great post, but I'm having the same issue as a few others.
****************
I receive the following error during the final installation step (activatefeature).

Feature 'a3c57d6d-bc96-44ea-a169-0e41bb429ee1' is not installed in this farm and can not be added to this scope
*****************
Is there a solution for this error
Thanks in advance Chad

Mark Wilson said...

The script does nothing magical other than run a few stsadm commands, can I suggest that if the solution has been added that you go into Central Admin -> Operations -> Solution Management and manually deploy the solution to the correct web applications there. If that has been done then go in to Site Collection Features in the site you wish to use it and activate the feature. Note "Site Collection features" and NOT "Site features".

DrvCrAsH said...

I made a new mapping list under one of my sites. but i cant figure out where to tell that calender on that site to use it? where is that configured? thanks

Mark Wilson said...

Edit the calendar page and edit the properties of the colour calendar "colouring" web part which is below the main calendar.

dinger said...

I am trying to disable the colour on a calendar that I created, but I am getting the error message - "The file is not checked out. You must first check out this document before making changes.".

Also, I am not able to get the color web part working. I add my calendar view in a web part, then add the colour coder web part after it, but the color part is not working. Am I missing a configuration option?

Thanks for everything.

Mark Wilson said...

I am not sure how you are trying to use the colour calendar, you need to enable it in the list settings of the calendar, that will place the web part on the calendar view pages automatically. It sounds like you are trying to add it manually to a publishing page?

dinger said...

Yes, I was trying to add it to a page on a team site. can that be done?

Mark Wilson said...

When you say a page on the team site - is this a site with publishing switched on? There is no reason why it wouldn't work, you need to turn on the colouring under the list settings for the calendar. Add a calendar list view manually to the page in question then add a colouring web part UNDERNEATH the calendar list view.

David Tappan said...

Hello, great solution!

I'm interested in using Color Calendar with the Content by Type web part from Ton Stegeman (http://www.codeplex.com/eoffice/Wiki/View.aspx?title=ContentByType%20web%20part&referringTitle=Home), which has rolls up lists, and has a calendar view. First I created all the lists from a custom event content type, and configured them all to be color coded successfully. Then I configured the CBT web part to show all items of that content type in a calendar view. I tried adding your Color Coder web part to the page with the CBT web part, and it does appear to interact with it somehow (it made all the meetings disappear when they were created with a list column of PWEventCategoryTitle, but when I replaced that with a site column of PWEventCategoryTitle, they appear--but they're not color coded. Can you give me any guidance on how to get these two web parts to work together?

Thanks,

David Tappan

tylerw said...

Thanks for developing such a great feature.

Richard said...

Just wanted to say thanks! This installed perfectly and is working great for us. Now we can put birthdays on our company calendar and people are no longer confused between vacation days.

This is a fantastic add-on.

Anonymous said...

Hi, When I push to enable colours I get error: A Web Part or Web Form Control on this Page cannot be displayed or imported. The type is not registered as safe.
What i'm doing wrong?
Thanks

Mark Wilson said...

Have you got admin rights on the server, it sounds like some safecontrol entries have not been propagated into the web.config.

Can you try and install the wsp file manually using the stsadm command line and deploy through central admin, see if any errors occur during deployment?

Anonymous said...

yes, I have admin rights, but I'm not strong to install wsp with stsadm commands, is there some different way???
please help I need this add-on

Mark Wilson said...

Please contact me at blog@planetwilson.co.uk

Glen said...

Hello Mike,

I thank you for this effort of doing this, when I can get it working, I am sure it will be a boon to my organizations workflow.

I've done my best to follow all the instructions on implementing the color coder but the coloring isn't taking. I'm using the script you gave in instructions (as is at first, and then changed the word "colour" to "color" at every instance - to reflect american english - wasn't sure, thought to try anyway) but am still not getting the coloring results. I get the titling fine just no colors for categories did I miss something?

Mark Wilson said...

I am not sure what you mean by follow a script...are you talking about the original hand cranked version or did you install the solution?

Feel free to email me directly.

Anonymous said...

Hi there,

I think this is a great webpart!
But I do have a request, because I cant seem to get the coulor to fill the space between Start Time and End Time. It only coulors a small part at the Start Time. Could this be done some how?

/niax

Anonymous said...

Awesome work!

Downloaded, installed and works like dream. I have couple questions, is it ok to rename the event category field for own name standard? or does it cause some problems. There is Event Category Title formula =Event category&|||&title but it doesnt return event category for me only title and color, is there someway that can be corrected?

and one out of topic question, is it anyway possible to add user principal name from AD to month view title? thats pretty lame when there is only title and only one topic to use, hard to find certain user appointments etc..

Jesper J said...

Hello,

First wanna thank you for the colour calender, its really a help creating now special calender with categories. We just implemented absence and vacation webpart from microsoft, and we have a small problem in implementing the colours for each absence type.
We wanna join like the event category color with the absence type list. so if you choose the absence like "sickness" it automatically shows a specific color. Any ideas how to "combine/preselect" the absence list in conjunction with the event category ?

MarkG said...

this is really cool, My only question is, can the colors be linked to the categories that are availible in Outlook 2007 calendar view? If so, you have made my day!

Mark Wilson said...

Unfortunately not, I know of no way to do this. Unless you mean just setting up the same colours by hand? Otherwise if you are talking about sharing the calendar in Outlook then no.

Anonymous said...

Hi Mark,

I have finished the fresh installation of the webpart sucessfully on the SharePoint server.I can see the webpart in the gallery and I activated features on the site only.

The problem is now everything is setup correctly.I don't see any options called enable colour or disable colour in setting on the existing list I have on the site.

Could you please let me know what can be done to bring out those options on to the list.

Thanks in advance
Jay

Mark Wilson said...

The feature is at the site collection level not site level, also are the lists calendar lists?

Anonymous said...

Now I am able to see the options.

Here what happend actually:

I have just saw the options for colouring when I newly created a Calender from the Tracking menu under site.

The existing lists are not calender lists but they are exported as list from access database tables.A calender view is created on the list which show events dynamically.


Now my question is how to enable these colouring options on the existing list which are not actually calender list but has calender view on it.

Hope I gave you correct picture what's going on.

Anonymous said...

does this require the use of Sharepoint Designer??

thanks !

Mark Wilson said...

No it doesn't

Timmy said...

Has anyone tried to use this in a hosted environment. We do not host our own Sharepoint environment. They allow for DWP uploads but I'm guess a WSP will be a no go as it might affect other customers. I've installed the previous version manually, but I'm really looking for the Connect to Outlook integration. Need to the color categories to be viewed the same whether in Outlook or web interface. Any suggestions? Is there a way to manually install this version?

Mark Wilson said...

You can use the simple JavaScript version, see the link on the right hand side of the main blog page.

I wouldn't imagine your hoster would allow the WSP version

You won't get Outlook connectivity either way though.

Amanda said...

Hi there. I applied the old version (non-deployable) and it works great - except for one thing. My March month is fully coded, my April is only half coded, and then May and on is color coded again. What's happening with the second half of April? The calendar entries have labels that are used in other color-coded entries. The last week in April is non-colored, but when that same week is viewed in the May month (as the first week), it's back to being color-coded.

Thoughts?
Amanda

Amanda said...

Hi there. I just posted a note with an issue I was experiencing with the non-deployable version of the color calendar. The second half of April is not color coding, and when you click MORE, not all items are color coded. Keep in mind that the same Event Categories are used for the color and non-color coded items. Some color and some don't.

I just deployed color calendar v2.4 and am experiencing the exact same thing. All of my months/events are color coded except for the second half of April. When seeing the last week in April viewed as the first week in May (in month view), the week goes back to being colored. Otherwise, when in April Month View, the last 3 weeks are Event Category ||| Title.

Any advise on this?

Mark Wilson said...

Having looked at Amanda's page source it transpired that she had put an invalid hex colour value in one of the mappings.

I guess my code could be a little more robust here but I don't do anything with the values just pass them through so that you can use either hex or web colour values.

Just a note to everyone to be careful with those values or else the colouring can stop working half way down a page!

Cheers,

Mark

Anonymous said...

Thanks Mark for your work and support!

I'm trying to deploy on a sharepoint server running off a different port. When I refer to that port using the redeploy.bat the install fails.

What was the work around for that?

Thanks again for providing this.

Mark Wilson said...

I would not bother with the script and run stsadm commands manually to add the solution then use central admin to deploy the solution to the relevant web application.

nickganga said...

Not to add to what everyone has already said but Great Job!

Anonymous said...

Hi, I used your orignal 2007 quick and dirty code because we use a hosted version of sharepoint... do you have any insight on the reason it dosnt work in firefox so I can alter that javascript to work in both IE and Firefox? Thanks!

bob said...

Cool program. I can't seem to get the category color to move from Outlook to Sharepoint (I email the apointments from Outlook to Sharepoint). I am using Outlook 2007 and made sure that the category names are identical...any thoughts?

Mark Wilson said...

It won't work like that. There is no connection between the Outlook colour coding and SharePoint unfortunately.

Mark Wilson said...

To the anonymous user with Firefox issues - I just tried it in Firefox and it worked fine (FF v3.0.10) - you can email me at blog@planetwilson.co.uk if wish to provide more info.

Anonymous said...

Mark, outstanding ! Job will done, but I need some help. I had this running great, everything was working just fine and all of a sudden the two options to turn calendar color off or on are now gone. I tried to reinstall but I still do not have anymore. I already tried a re-install and same thing, all other areas are still intact. How do I get this back without running the batch file.

Mark Wilson said...

Check to see if the feature is enabled under "Site Collection features", sounds like it has been turned off.

Anonymous said...

Mark, I've got the calendar installed and running but I want to change the names of the categories. I know I can go in there and add new ones but no colors get associated to them so how can I fix that?

Mark Wilson said...

You need to add a new entry to the mapping list for your new categories or edit existing entries to reflect your changed categories. Specify the colours in the mapping list entry.

jriesen said...

Mark - I love your calendar web part. I use it mainly for one reason ... the Enable Width Fix. I am also using the EasyTabZone web part so I can have multiple views of the calendar on one page. Everything was working great until I ajaxified the web zone the was the container for the calendars and your web part. Only the default on initial load of the page is displaying as it should. When I click on the tab to see another view the items in the calendar now display the category and title like so ... Category ||| Title ... and the dreaded vertical and horizontal scrollbars are back. Do you have any suggestions for fixing this? I tried moving the PlanetWilson Calendar Web Part into another zone below the calendar zone, but that had no effect.

Thanks in advance for your help.

Jill

Mark Wilson said...

I would need a little more detail on what "ajaxfied" means - you can email me at blog@planetwilson.co.uk

Anonymous said...

This is great! I have never added a new feature/solution to our site and managed to add and customize this in less than a day!
Thank you!!!!!

Anonymous said...

Hi Marc,
I remember how I loved your calendar when it still was using correctly... Since some month -and I haven't had the time so far to try to fix it- the colors disappeared and 3 vertical bars ||| are displayed between the Event Category and the Title.
Unfortunatly I do not have a clue what operation might have had triggered this behavior.

Any idea? Martin, Barcelona

Mark Wilson said...

If you email me the page source of the screen with the problem on then I will take a look.

Thanks,

Mark

blog@planetwilson.co.uk