- Picklists limitation
- Posted by Diogo Monteiro on November 21st, 2005
Hi there,
Is there any limitation in the size of a picklist? we have a 5000 count to
import to a picklist. Is this possible?
Thanks in advance
- Posted by Ronald Lemmen on November 21st, 2005
Hi Diogo,
There is no physical limitation to picklists. The problem will be the
usability of a picklist with that amount of values.
With kind regards,
Ronald Lemmen
Avanade Netherlands
"Diogo Monteiro" wrote:
- Posted by Diogo Monteiro on November 21st, 2005
Thanks Ronald
"Ronald Lemmen" wrote:
- Posted by CRM Expert on November 21st, 2005
No Limitation of size.
--
All about Microsoft CRM 3.0- read
http://microsoftcrm3.blogspot.com
"Ronald Lemmen" wrote:
- Posted by Ronald Lemmen on November 21st, 2005
You're welcome 
Have you thought about splitting the data into more picklist attributes?
this might be a lot easier for the enduser. It is more difficult to create
though.
Ronald Lemmen
Avanade Netherlands
"Diogo Monteiro" wrote:
- Posted by MJ Miller {MSFT} on November 21st, 2005
You will run into a problem if you have a large picklist like that. Because
MSCRM uses views to return your picklist data, it needs to embed them into
that view. SQL Server will run out of stack space long before you hit 5000
items. You might consider upgrading to 3.0 and putting your picklist data in
a custom entity. That way you can get around the stack limitations.
--
MJ Miller
Microsoft CRM Technical Lead
** The opinions and comments in this post are my own and in no way reflect
the opinions of Microsoft or the Microsoft CRM team. This posting is not an
offer of support, either immediate or ongoing, and no support is implied.
Some of the information posted may include non-supported workarounds and
code samples.
"Ronald Lemmen" <RonaldL@-REMOVETHIS-avanade.com> wrote in message
news
0B1C3DA-9D0C-4A5F-8186-0FE8C354BA01@microsoft.com...