Sign in

Microsoft.com

Microsoft

Remove From My Forums

CRM Text Field Convert to URL Format

Question
0

Sign in to vote

Hi

When my data for CRM was imported using Scribe, a field that was to contain an email address
called "new_personalemail" was set to a format of text instead of a url.

I noticed that when I looked at the details of the field, the format type was disabled.

What is the best way to resolve this issue.

Thanks.

Tuesday, September 3, 2013 2:33 PM

Answers

1

Sign in to vote
Hi,

You could not change the field type after creation (you may find some workaround which offer your to do this type change from DB, but I do not recommend it). Instead you could create the new field with the desired format, then use an on-demand workflow to copy the values from the old field to the new field. If you have lots of data, you could register a plugin temporarily to do all of these value copies easily.

My Weblog | My Website
- Proposed as answer by Payman BiukaghazadehEditor Tuesday, September 3, 2013 2:43 PM
- Marked as answer by Payman BiukaghazadehEditor Tuesday, October 15, 2013 5:36 PM
Tuesday, September 3, 2013 2:42 PM

Moderator
0

Sign in to vote
Agree with Payman, you coud also write a simple .net code to copy data from that field to another field with proper formatting.
Our Website | Our Blog | Follow US | My Facebook Page | Microsoft Dynamics CRM 2011 Application Design
Make sure to "Vote as Helpful" and "Mark As Answer",if you get answer of your question.
- Marked as answer by Payman BiukaghazadehEditor Tuesday, October 15, 2013 5:36 PM
Tuesday, September 3, 2013 4:21 PM

Moderator

All replies

1

Sign in to vote
Hi,

You could not change the field type after creation (you may find some workaround which offer your to do this type change from DB, but I do not recommend it). Instead you could create the new field with the desired format, then use an on-demand workflow to copy the values from the old field to the new field. If you have lots of data, you could register a plugin temporarily to do all of these value copies easily.

My Weblog | My Website
- Proposed as answer by Payman BiukaghazadehEditor Tuesday, September 3, 2013 2:43 PM
- Marked as answer by Payman BiukaghazadehEditor Tuesday, October 15, 2013 5:36 PM
Tuesday, September 3, 2013 2:42 PM

Moderator
0

Sign in to vote
Agree with Payman, you coud also write a simple .net code to copy data from that field to another field with proper formatting.
Our Website | Our Blog | Follow US | My Facebook Page | Microsoft Dynamics CRM 2011 Application Design
Make sure to "Vote as Helpful" and "Mark As Answer",if you get answer of your question.
- Marked as answer by Payman BiukaghazadehEditor Tuesday, October 15, 2013 5:36 PM
Tuesday, September 3, 2013 4:21 PM

Moderator