Show no. of open or closed activities (history) on the CRM form.

Posted by on May 18, 2009 in CRM 4.0, Customizations, JavaScript |

Hello all,

Have you ever wanted to see the total no. of outstanding/completed activities on a Case, Account, Opportunity, Contact etc..?  

Well now you can, simply add the following JavaScript code to the onLoad event of the entity, it will query the webservice and it will give you the exact count of open/closed activities.

Update: 9th March 2010 – I have updated the code below and tested.

Any comments or suggestions are welcome!

Read More

Add custom toolbar buttons to the Case Entity form.

Posted by on May 17, 2009 in CRM 4.0, Customizations, JavaScript |

Hi All,

Have you ever wanted to add some toolbar buttons to the CASE/CONTACT/ACCOUNT form?

Well now you can, you can use the ISV.config provided by CRM.

  1. Export the ISV Config Customizations from CRM
  2. Edit the XML file
  3. Find the <entity name=”incident”> node and add the following – I couldn’t paste the XML because of wordpress limitations.

  4. Note: the following are custom images: taskicon.gif, emailicon.gif and phonecallicon.gif.

  5.  Save the XML and import into CRM and publish the customizations.

Code explantion:

JavaScript="locAddActTo(4210)" PassParams="0" WinParams="" WinMode="0" Client="Web, Outlook" AvailableOffline="true"

Here we are using the CRM javascript function locAddActTo() and using the entity identifier (this being a phone call) which is located in the SDK and we are telling CRM to show this button is Outlook and the web version of CRM

JavaScript="resolve();" PassParams="0" WinParams="" WinMode="0" Client="Web, Outlook" AvailableOffline="true"

We are using the resolve() function on the case entity form which will resolve the case like you would when going to the actions menu > resolve case

Read More

Backing Up Sharepoint & ZIP (compress)

Posted by on May 16, 2009 in Sharepoint |

Hi All,

I want to publish the backup script i use to backup sharepoint every night. It is a very basic BATCH script (.bat) which uses STSADM sharepoint command line tool to backup sharepoint then uses winrar to zip and compress the file in date format then copy to the destination drive. 

# setting a the variable stsadm as the location of the command line tool
set stsadm="C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\BIN\stsadm.exe"
# set the variable %todaysdate% as todays date
set %todaysdate%=%date:~7,2%_%date:~4,2%_%date:~10,4%
# make a directory for today's sharepoint backup
mkdir E:\Backups\Sharepoint\File\%todaysdate%
# we are using the STSADM tool to make a full sharepoint backup
%stsadm% -o backup -directory E:\Backups\Sharepoint\File\%todaysdate% -backupmethod full
# this is zipping up the sharepoint backup as SharepointBackupXX_XX_XX.rar from contents of E:\backups\sharepoint\file\
"c:\program files\winrar\winrar.exe" a -u -r -m5 "E:\Backups\Sharepoint\Zip\SharepointBackup%date:~7,2%_%date:~4,2%_%date:~10,4%.rar" "E:\Backups\Sharepoint\File\%todaysdate%\*.*"
# this is copying the contents of "ZIP" to the destination backup drive which is mapped as S:\
 xcopy "E:\Backups\Sharepoint\Zip" "S:\Sharepoint\" /Y /E


Any comments or suggestions are welcome.

-Ibrahim

Read More

Sharepoint – EventID: 17137

Posted by on May 16, 2009 in Sharepoint |

You recieve the event (17137) in the eventlog when you migrate the databases to a different disk or partition (in this case i moved it to a different partition).

The description for Event ID ( 17137 ) in Source ( MSSQL$MICROSOFT##SSEE ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: WSS_Content.

 The problem here is that when we re-attached the database to the SQL server the ‘AutoClose’ option (this option when ON closes the database cleanly when the last user logs off) is set to true.

FIX:

  1. Start SQL management studio and connect to the MSSQL#SSEE instance (this is the default sql instance installed by WSS for windows server 2003) – Server name should be: np:\\.\pipe\MSSQL$Microsoft##SSEE\sql\query
  2.  

  3. Select the database from which the event in the event viewer is complaining about and go to properties > options and set the ‘AutoClose’ option to ‘false’

Read More

I’m back!!

Posted by on May 16, 2009 in General |

Hello All,

I’m back and wish to start once again posting on my blog. I will now be adding content for CRM, Sharepoint, Server 2003/Exchange 2003 & some linux as this is what i work on all day…

Keep checking back for more updates.

– Ibrahim

Read More
%d bloggers like this: