MsSQL CRM Contact question

[Cytranic]

I have a custom MySQL CRM lookup. All works well, Contacts import. However, I have the setting "Query CRM" set to always and it doesn't seem to be working.

If I call in, it creates a contact based on the information from the CRM.
If I change the CRM's name and call in again, its the original name of the contact.
If I delete the contact and call in again, the correct name is created.

Would my understanding be correct that it should always pull from the CRM and never look in the phonebook?

 

[edossantos]

This is probably due to the 10 minutes cache in the CRM engine. When you make a second call from the same number in less than 10 minutes, the contact details are taken from cache. If you wait 10 minutes, the contact details should be updated.

 

[Cytranic]

Yeah, this specific issue arose from a lead that was updated a few days ago.

Your explanation certainly explains the testing I just did..... I'll wait 10 min and try again

 

[Cytranic]

Ok so the contact did change after 10 min. Is there a limit to how many Contacts 3cx can have? I cleared the entire CRM Contact database in 3cx and it appears to be working.

We're prob importing 50-80kk contacts a month? Is there a limit? The problem seems to crop up around the 3 month mark, and I've just been deleting the entire database since then.

 

[edossantos]

There is no limit, but too many contact might slow down the lookup....

 

[Cytranic]

Yeah if thats the case, it would be ideal to have some sort of option to clear CRM records after 30 days or something.

 

[edossantos]

It's not possible to do this automatically, you will need to login to the 3CX Console > Advanced > Contacts > Delete CRM Contacts.