About Me

My photo
Kottarakara, Kollam, Kerala, India
Though currently in Thiruvananthapuram, my residence is at Kollam district in Kerala which is almost 75 kms away from the office

I Me Myself !

Hi all, as a ASP.NET professional i would like to use this as a technological and informative site. Maybe, this contains my personal portfolio, funny matters, videos, photos too. Still i mainly intend to use this for official purpose.

Currently specialising in Microsoft's Dynamic CRM 4.0, am engaged in an assignment to successfully develop and deploy a CRM product as per the custom business logic. I am employed in a microsoft partnered switzerland based firm, know more...

The technologies/languages/packages i am confident in are:


  1. ASP.NET (vb/C#)

  2. C#.net

  3. vb.net

  4. sql server

  5. Adobe photoshop

  6. Macromedia Flash

  7. MS Dynamics CRM 4.0

My achievements includes:
1) Cisco Certified Network Associate (CCNA).
2) Active member of ASP.NET forum.
3) Active member of CRM Dynamics Community.

My professional career:


  • Web Designer at AUFIDUS INDESIGNS, Ernakulam, Kerala

  • Computer Lecturer at SRV Govt Higher Secondary School, Ernakulam, Kerala

  • Software Instructor at IGNOU, Ernakulam, Kerala

  • Lower Divison Clerk (LDC) at Melattur Grama Panchayat, Malappuram, Kerala

  • Software Trainer in .NET at Sun Infosys, Kottayam, Kerala

  • Software Trainer in .NET at NIIT, Adoor, Kerala

  • Computer Lecturer at UIT, Adoor, Kerala

  • Senior Systems Executive at PIT Solutions, Technopark, Thiruvananthapuram, Kerala

CRM 4.0 - Making & saving picklist values to CRM database dynamically

There is a common issue with picklist and CRM 4.0. If we add picklist items statically, while saving the values will be saved to CRM database properly. But while we add items dynamically it won't be saved with proper values but with NULL !!!

I have found a nice workaround for this issue as follows:

1) Instead of picklist type i declared the attribute as simple text
2) On the onLoad event i created a html select control dynamically and binded the values from CRM database.
3) i added this SELECT control to the innerHTML of our attribute
4) hide our CRM attribute (so now our CRM attribute is hidden and SELECT control is visible)
5) On onSave event i loop through the SELECT control and get the selected item
6) Set the selected item's value to the hidden CRM attribute
7) So while saving the correct selected value will be saved to database
SUCCESS

Limitations:

Can't declare the CRM attribute as business required
don't get any events like onChange for created SELECT control

Refered links are:

http://forums.microsoft.com/Dynamics/ShowPost.aspx?PostID=2839313&SiteID=27
http://www.stunnware.com/crm2/topic.aspx?id=JS1