[Vtigercrm-developers] 500k to leads changing a lot

[Tony Sandman]

Same this: &

T

On Thu, Dec 24, 2020, 2:04 AM Rubén A. Estrada Orozco <rulotec1 at gmail.com>
wrote:

> Sure Uma,
>
> For example: "Rubén". Create that item in a picklist. Then create a csv
> file containing rows using the same value and do an import.
> Not only Vtiger won't be able to recognize the value already exists, but
> it will create a new value for each row. So, if your csv contains 10 rows
> you'll end up with something like this in your picklist:
>
> Rubén
> Rubén
> Rubén
> Rubén
> Rubén
> Rubén
> Rubén
> Rubén
> Rubén
> Rubén
> Rubén
>
>
> I'm not 100% sure that vtiger will store é as the htmlentity &eacute. It
> might be something else because it was a long time ago that I saw that
> behaviour and since then I do not use accents in picklists. I don't know
> about other languages, but latin languages (spanish, french, italian,
> portuguese, ...) will have the same problem because of accents.
>
> Saludos
>
> Rubén
>
>
> On Tue, Dec 22, 2020 at 11:19 PM Uma S <uma.s at vtiger.com> wrote:
>
>> Hi Ruben,
>>
>> Can you share an example for these picklist values which is leading to
>> this issue?
>>
>> On Wed, Dec 23, 2020 at 4:11 AM Rubén A. Estrada Orozco <
>> rulotec1 at gmail.com> wrote:
>>
>>> The problem with duplicate picklist entries has happened to me as well.
>>> In my case it was because of using accents. Since then I never use accents
>>> and try to avoid most special characters in picklists. That's a bug and
>>> should be fixed though.
>>>
>>> Saludos
>>>
>>> Rubén
>>>
>>>
>>> On Tue, Dec 22, 2020 at 3:08 PM Tony Sandman <tonysandman999 at gmail.com>
>>> wrote:
>>>
>>>> Seems like import duplicated picklist values creating thousands of
>>>> picklist entries. Should not happened actually?
>>>> Sniffing around...
>>>>
>>>> On Tue, Dec 22, 2020 at 12:51 AM Rubén A. Estrada Orozco <
>>>> rulotec1 at gmail.com> wrote:
>>>>
>>>>> turn on the slow queries log of mysql/mariadb. That will give you a
>>>>> hint of where the bottleneck is.
>>>>>
>>>>> Also, how much ram memory do you have? increasing ram would probably
>>>>> help.
>>>>>
>>>>> Saludos
>>>>>
>>>>> Rubén
>>>>>
>>>>>
>>>>> On Sun, Dec 20, 2020 at 8:15 PM Tony Sandman <tonysandman999 at gmail.com>
>>>>> wrote:
>>>>>
>>>>>> So, I get around 500k to leads and from that moment to get edit
>>>>>> record I need to wait 30s.
>>>>>> removed imported but the issue persists. Is it something observed
>>>>>> before?
>>>>>>
>>>>>> T
>>>>>> _______________________________________________
>>>>>> http://www.vtiger.com/
>>>>>
>>>>> _______________________________________________
>>>>> http://www.vtiger.com/
>>>>
>>>> _______________________________________________
>>>> http://www.vtiger.com/
>>>
>>> _______________________________________________
>>> http://www.vtiger.com/
>>
>>
>>
>> --
>> With
>> Best Regards
>> Uma.S
>> Vtiger Team
>> _______________________________________________
>> http://www.vtiger.com/
>
> _______________________________________________
> http://www.vtiger.com/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20201224/e0bbcc76/attachment-0001.html>