EspoCRM 5.6.0 released

[yuri]

Enhancements:

• WebSocket support;
• Ability to restore deleted records for admin;
• 'Recalculate Formula' mass action for admin;
• Ability to mass unlink related records;
• Ability to view & manage a list of followers of a specific record;
• Meetings: All-day meetings;
• Meetings/Calls: Acceptance button;
• Meetings/Calls: 'Set Held' and 'Set Not Held' actions on quick view modal;
• Phone Numbers: Invalid and Opted-Out attributes;
• Emails: Ability to view/manage user list, email record is available for;
• Settings: Ability to disable cron through UI;
• Settings: Ability to set Maintenance Mode through UI;
• Settings: Delay of email notifications;
• Dynamic Logic: Supporting File and Image field types;
• PDF: Supporting custom page size;
• Console: Upgrade command;
• Console: Ability to run specific job;
• Group Email Account: 'Keep Fetched Emails Unseen' parameter;
• Ability to disable/enable open tracking in mass email;
• Text field: Ability to disable markdown;
• Multi-Enum, Array fields: 'Max Item Count' parameter;
• Multi-Enum field: 'Is Sorted' param;
• Currency field: Ability to specify default number value and currency;
• Import: Silent Mode;
• Autocomplete address state list;
• Text Filter Search: Foreign fields support.

Improvements:

• Export: Less memory usage;
• ORM: Select query optimization;
• Tasks: Reminders available if date due time is not specified.

Changes:

• Dropped php 5.6 & 7.0 support.

All issues: https://github.com/espocrm/espocrm/m...ne/54?closed=1

Download: https://www.espocrm.com/download/

Upgrades: https://www.espocrm.com/download/upgrades/

[UnnamedUA]

Обновился на двух инсталах, работает
На втором почему то показывало 5.5.6, пришлось апгрейдить второй раз.

[tvittitoe]

Tried to upgrade from 5.5.6 and get "Your PHP version does not support this installation package." Can you tell me what version is required?

[yuri]

> Tried to upgrade from 5.5.6 and get "Your PHP version does not support this installation package." Can you tell me what version is required?
7.1.0

[rodrigocoelho]

Hi Yuri,

May you explain what does it mean? "

• WebSocket support;"

If enabled, what changes? Thanks.

And congratulations for the update. Just saw that you updated the Advanced package too.

[yuri]

> May you explain what does it mean?

Hi Rodrigo,

You can find more info here:
https://github.com/espocrm/documenta...n/websocket.md

https://en.wikipedia.org/wiki/WebSocket

[yuri]

Since this version it will be possible to upgrade from CLI by running the following command:

 
 php command.php upgrade

[yuri]

> Пропали уведомление о открытии писем при массовой рассылке.

It's disabled for GDPR. Can be enabled at Administration > Outbound Emails > Email Open Tracking.

[yuri]

For issues please create separate topics in bug reports.

[rodrigocoelho]

Yuri, after upgrading to 5.6,, the notifications by email stopped to happen. Any clue ?

[rodrigocoelho]

Yuri, after upgrading to 5.6,, the notifications by email stopped to happen. Any clue ?

Found the problem. Maybe can help others.

My Cron was calling php 5.6, I had to update it to call php7.3 since now previous versions are deprecated.

My server was already using 7.3, only CLI was 5.6.

Solved.

Thanks

[rodrigocoelho]

Yuri, I'm trying to understand how does the COMPLEX EXPRESSIONS works. What is the difference between them and the Formulas?

https://github.com/espocrm/documentation/blob/master/docs/user-guide/complex-expressions.md

Thanks

[yuri]

Complex expression represents SQL expression with functions.

IS_NULL:(sicCode) -> sic_code IS NULL

IN:(stage, 'Closed Won', 'Closed Lost') -> stage IN ('Closed Won', 'Closed Lost')

EQUAL:(status, 'Complete') -> status = 'Complete'

CONCAT:(firstName, ' ', lastName) -> CONCAT(first_name, ' ', last_name)

Example how it can be utilized in reports in group by:

IF:(LIKE:(name, 'Cloud%'), 'Cloud', name)

This will combine 'Cloud Basic', 'Cloud Enterprise' opportunities into one 'Cloud' group.

[rodrigocoelho]

Thanks for the explanation.

Complex expression represents SQL expression with functions.

IS_NULL:(sicCode) -> sic_code IS NULL

IN:(stage, 'Closed Won', 'Closed Lost') -> stage IN ('Closed Won', 'Closed Lost')

EQUAL:(status, 'Complete') -> status = 'Complete'

CONCAT:(firstName, ' ', lastName) -> CONCAT(first_name, ' ', last_name)

Example how it can be utilized in reports in group by:

IF:(LIKE:(name, 'Cloud%'), 'Cloud', name)

This will combine 'Cloud Basic', 'Cloud Enterprise' opportunities into one 'Cloud' group.

[rodrigocoelho]

Yuri,

last thing (I hope so).

I couldn't see how to use the new feature -- "Recalculate Formula’ mass action for admin"