Solved

Is it possible to convert a free text field to a drop down list from the current data it has ?

Posted on 2007-11-21
1
594 Views
Last Modified: 2012-05-05
I have a filed in the crm for contact source. since we upgraded from ACT! this field is a free text one so everyone can write what he/she wants. Now I need to convert this field into a dropdown without loosing it's data so that the drop down will contain the text from this field.

thanks
0
Comment
Question by:Biju708
1 Comment
 
LVL 9

Accepted Solution

by:
Biffster007 earned 500 total points
Comment Utility
Hi,

There's no out of the box way of converting this to a drop down box as far as I'm aware.

What I would do, which is a bit long winded but will work, is:

1) Extract a list of all the distinct contact source text values for this field.  Store these in a table in a temporary database.
2) Extract a list if the contact GUID and it's associated contact source and store in another table in the temporary database.
3) Remove the Contact Source field from the contact form in CRM.
4) Delete the contact source field.
5) Create the contact source attribute again with the same name as a picklist.
6) Add the distinct values of the contact source extracted in step 1 as picklist values.
7) Add the values to each item in the picklist to the table created in step 1 so each name has an associated value.
8) Join the table created in step 1 with the values to the table created in step 2 on the contact source field.  This will give you a contact guid and contact source value combination.
9) Then you could do 1 of 2 things:
   a) Supported - You could write a DotNet assembly to update the contact source field of the contacts with the new picklist value.
   b) Unsupported - You could update the database directly.

As I said long winded but it will work.
Hope this helps.,

Che,
MH
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Suggested Solutions

This is a walkthrough guide I wrote whilst upgrading my on-premise MS Dynamics CRM 3.0 deployment to 4.0. This covers the actual installation of the product to a working level for my system, I ran into a lot of issues that the steps below fixed so h…
On Sep 22nd 2014 Microsoft released Update Rollup 1 for Microsoft Dynamics CRM 2013 Service Pack 1 and back in July Update Rollup 3 was released.  So we now have:   Update Rollup 1Update Rollup 2Update Rollup 3Service Pack 1Update Rollup 1 for S…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now