filter by multi-enum not work

[yuri]

Hi, You might have issues with file permissions. Check Administration > System Requirements.

[Etienne]

Hi,

in administration -> système requirements, all is success

[Maximus]

Check or update your permission according to this https://www.espocrm.com/documentatio...-based-systems

[Etienne]

Hello,

espo work under windows serveur 2006 and iis.
juste for the test, i changed the security on the files and "everybody" is read and write for all.
but... same problem :-(

thx

[Etienne]

Hello

Hello,

I have exported 2 or 3 contacts with multiselect encoded in espo to check the structure.
after, i created a csv with the same column name and the same mutiselect structure for example : ["CDDS","MICE"]

after import, if i edit a contact, i see the field with "CDDS" and "Mice" but if i search a type_contact it's not work.

after i edit this contact, i delete "CDDS" and "Mice" in the field type_contact, i save, i edit again this contact and add CDDS and Mice in field type_contact and i save again.
now, the seach is ok.

have you a idea ?

other test: i checked in DB and the content is the same.

during an import, are there not relationships that would not be created?

thx

[Etienne]

hoooo ok,i find

i checked in DB and i see a table "array_value"
in this table, these fields : ID - deleted - value - attribute - entity_id - entity_type

ex: 5c811f9dca0637e1a - 0 CDDE - typeDeContact - 5c7f8f46c969c7bb1 - Contact

if i add a record in this table, the find fonction work well !

the type_contact field is import in contact table but not in array_value. (the find fonction use array_value table and not contact table).

the last problem... if i import the data in array_value via phpmyadmin, the id field does not automatically populate.

have you a idea ?


thx

[yuri]

Check this https://forum.espocrm.com/forum/gene...ray-field-help

[Etienne]

thank you for you link yurikuzn.

who pupulate the id field (like "5c811f9dca0637e1a") ?

in your link, i see value '12345' for id:
INSERT INTO `job` (id, service_name, method_name, execute_time) VALUES ('12345', 'App', 'jobPopulateArrayValues', NOW()) thx

[Etienne]

Hello

I study the id field. 8 first ones characters is the timespam convert to hexa.
but the last 9, I don’t know

do you think I can pupulate with this ?:

for example:
5c811f9d000000001
5c811f9d000000002
5c811f9d000000003

etc...

the id from table "array_value" used for anything else?

thx

[yuri]

Hi,

Sorry, I don't get the point. I provided the link where the same problem has been solved. Do you have cron working in your system? EspoCRM is nothing w/o cron. If you don't have cron configured EspoCRM will not work as it intended to work.

[Etienne]

Hello Yurikuzn,

ok I check this.
thx

[Etienne]

Hello Yuri,

it's ok now.
thank you so much !