ms crm field names capitalised

(0) Share

Report

Posted on by Community Member

Hi,

1. Has anyone come across a case where the field names in MS CRM are capitalised? Typically this wouldn't be possible as the UI would automatically convert all field names to lowercase.

2. I need to cater for this eventuality, but unsure of how to replicate. Any idea how to create upper case characters in field names?

*This post is locked for comments

I have the same question (0)

All responses (11)

Answers (0)

Rajkumar Rajaraman on at

Like (0)

Report

Karlo,

Refer this thread:

social.microsoft.com/.../microsoft-dynamics-crm-2011-onchange-event-uppercase-text

Hope this helps.

Regards,

R.Rajkumar

"Please mark my answer as verified if you found it helpful"

Was this reply helpful? Yes No
Suggested answer

BackToTheCrm on at

Like (0)

Report

Hello Karlo,

The logical name will always be lowercase, however the schema name can be uppercase.

The schema name is used in the SQL database and in the odata field names.

At the creation of the field, you only need to enter the uppercase field name. When the field is saved, the name will be shown in lowercase but if you go in the grid view you will see 2 columns one in lowercase (logical name) and one in uppercase (schema name).

Hope it will help.

Clément

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Clément,

In this case both logical and schema contain uppercase characters. This causes an issue with fetchxml which now seems to be case sensitive.

Difficult to replicate and test, unless I know how this could happen.

Was this reply helpful? Yes No
anilambadan 1,160 on at

Like (0)

Report

When you are creating an attribute system will automatically set the logical name as lowercase. but it can be edited. so somebody may have manually put the Capital Letters with logical name. We faced the same issue before.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks Anil,

What was your resolution? Rename to lowercase? I'm unable to edit any schema fields via the UI. How could one go about renaming these to uppercase to test?

Was this reply helpful? Yes No
Mahendar Pal 45,095 on at

Like (0)

Report

Even if you will write name in Capital letter system will convert it back to lower case, so there is not control on name field in supported way at least.

Was this reply helpful? Yes No
anilambadan 1,160 on at

Like (0)

Report

If the attribute is not contains any data, you can delete the attribute and recreate it. If its contains data, you have to create some temporary attribute and move data to the temporary field (SQL update/write some code to do the data movement), delete the attribute and recreate it and move the data from temporary field. Then delete the temporary field.

Was this reply helpful? Yes No
Suggested answer

Surmeet Singh 3,075 on at

Like (0)

Report

Hi Karlo,

You will have to delete the existing fields and recreate and at the time of creation before saving you will have to change the field name to Uppercase letters.

Was this reply helpful? Yes No
Suggested answer

BackToTheCrm on at

Like (0)

Report

Karlo,

I misunderstood the question. In this case, I think the field was created with the SDK (Here is an example : msdn.microsoft.com/.../Gg509014.aspx ).

As the others say, you must create a new field, transfer the data in this field (with a SQL query if you're on premises) then delete the old field.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi,

I tried this with the 2011 SDK, but even a capitalised logical name end up created in lowercase. Perhaps this was possible in previous releases.

My question I guess is whether this capitalised fields should be treated as unsupported customizations (if we cannot even replicate in MS CRM anymore).

Was this reply helpful? Yes No