Wednesday, May 27, 2009

Sharepoint birthdays List on Codeplex

Today i have posted my first Codeplex project.
It 's a simple but useful feature.
It about showing birthdays on a Sharepoint (WSS & MOSS) Site

I based this list on a post

Here below there is the post I based my Sharepoint birthday List

As It didn't work as is, I decided to post it working on Codeplex.


_____________________________________________________________________________________


This web part is a very simple but handy part to show coming birthdays of people. You only use standard controls from SharePoint and you do not have to program anything. It also shows how to use some functions which are not directly available in calculated fields but can be used with a simple trick. so far as I know this trick be used for any other function which is not available for calculated fields. The following describes the steps to create this web part.

Choose "Manage Content" from the "Actions" menu. Choose "Create" and create a custom list. Choose "Modify settings and columns" and add the following columns:

Name, single line of text
Birthday, Date and Time

The Trick: You can not use the Today function directly from the calculated field. So we create a dummy column representing the Today function. The credits for this trick are going to Pete Blair.

Today, single line of text

Next we have to create two calculated fields. The first calculated field tranforms the day of birth to a date in the current year. This means that may 19th, 1971 will be may 19th, 2005.

BirthDayThisYear, Calculated, =TEXT(BirthDay,"M/D/")&TEXT(Today,"YYYY")

the second calculated field will calculate the number of days till that date.

BirthDayIsSoon, Calculated, =DATEDIF(Today,BirthDayThisYear,"d")

Now remove the Today column. The calculated fields will use the actual Today function in stead of the Today column. Make sure that whenever you want to change the calculated fields the Today column is created

Create a new view which will only show the columns Name and Birthday. In this view use the following filter settings showing only the birthdays in the next 14 days.

Wednesday, May 13, 2009

Commerce Server Marketing Manager while approving

I had created a new Direct Mail and when I tried to Approve it I got the next error message.

Commerce Server Marketing Manager while scheduling this direct mail (id = 1)


It happened that the Commerce Server Direct Mailer Service was off.



I trie to Start it but

I receive an error message when Commerce Server 2009 is installed on a computer that is running Windows Server 2008 64 bit


Windows could not start the Commerce Server Direct Mailer service on Local Computer.
Error 1075: The dependency service does not exist or has been marked for deletion

I tried this

http://support.microsoft.com/kb/949745


But It does not work

Labels:

Commerce Server Authorization Manager

To add users to the authorization roles
Click Start, click Run, type azman.msc, and then click OK.

In the Authorization Manager screen, right-click Authorization Manager, and then click Open Authorization Store.

In the Open Authorization Store dialog box, verify that the XML file option is selected, and then click Browse to locate the authorization policy for the Web service. For example, the catalog authorization policy XML file is located at \Inetpub\Wwwroot\ssCatalogWebService.

Select .xml, and then click Open.

In the Open Authorization Store dialog box, click OK.

Expand the authorization policy to \.xml\\Role Assignments\. For example, \CatalogAuthorizationStore.xml\CatalogandInventorySystem\Role Assignments\CatalogAdministrator.

Right-click , and then click Assign Windows Users and Groups.

In the Select Users, Computers, or Groups dialog box, in the Enter the object names to select box, type the name of the catalog administrator Windows group that you defined in the previous procedure, for example, ssCatalogAdminGroup. Alternatively, you can also type the name of an individual business user account. Click OK.

Repeat steps 2 through 8 for each authorization role in each Web service authorization store. When complete, you will have defined the following: