2021.02.001

SpiceCRM 2021.02.001

After the Slim framework update performed in the Winter it was only logical to add the SpiceCRM REST API documentation. The objective is not only to make the REST API accessible for developers but also to add validation checks on variables passed and therefore ensure application security and stability. Beside backend changes and having in mind that a CRM is a communication tool, we added the SpiceCRM Page Builder to simplify the creation of newsletters and landing pages directly in the CRM. For the CRM users themselves we added a real time notifications, making it possible for users to subscribe on records and be informed right away about content changes. And finally we started a security offensive by implementing a Two-Factor Authentication (2FA) based on GoogleAuthenticator app.

The API Inspector

The API is directly documented in the CRM itself. The strict definition of the request parameters that can be sent to the CRM, matches the security requirements. Developers can try out the requests within the Inspector and check the results without needing any additional software.

The SpiceCRM PageBuilder

The PageBuilder makes it possible to drag&drop content elements and generate full designed pages without any technical knowledge.

Release Details 2021.02.001

1000409 : Spice Page Builder

Spice Tool for building Html Landing Pages and Newsletter emails. Drag and drop elements into the page and configure the layout from the builder panel.

1000413 : Starface VOIP Integration

Integration Starface Telephony System.

1000415 : Generic telephony components

1000425 : Calendar Enhancements

Improve Calendar performance. Google Calendar Integration.

1000427 : Add Pipes to template compiler

Ability to change values using various functions before they are inserted.

1000469 : Calendar Show/Hide my own Events

Allow Users to show/hide their own calendar in the calendar monitor.

1000480 : Global Notifications

Display the user notifiactions in a dropdown.

1000509 : Backend: Get a collection of related beans

Modify get_linked_beans() to accept array of link names as first parameter

1000516 : Improved Code Quality on Backend

Moved $GLOBALS Class instances to singletons.

1000523 : Model List Service: Improvement. Disable Auto Loading

Move the get list data command from the model list service to the components that use the model list service.
Add a disableAutoLoad flag to the object list component for the list 'all'

1000526 : Mailbox Manager View Improvement

Added three different split options to the view. 'No split', 'Horizontal split' and 'Vertical Split'. With the possibility to configure a custom component set for the horizontal view.

1000527 : Object Related List Files Big Thumbnail

Added big thumbnail option to display the file tiles with big a thumbnail preview.
It can be toggled by the icon button on the panel header.

1000528 : System Richtext Editor Embedded Tools

Reserved the right corner of the toolbar for ng content to allow rendering custom tools embedded in the component.

1000529 : Field Richtext - Signature

Added a signature dropdown in the toolbar with the options (none, mailbox, my signature) and automatically write the signature in the content if exists.
Added email signature field for mailbox module to allow using the signaure of the mailbox.

1000530 : Mailboxes - Email Signature Field

Added a new field 'email_signature' to the mailbox to be used while sending emails.

1000531 : Bug Fix: Spice Importer: File Too Big Calculation

Corrected the fileTooBig value to calculate the count csv rows and not the file raws

1000532 : Emails - New Subject Field

Added a new field type email subject to display a status icon of the email and the subject beside. It also adds a line through the text when the email is closed and bold if the email is unread.

1000533 : Activity - New Field Activity Date

Added a new field type activity date to display a short formatted date based on the past, today, and the year.

1000534 : System Checkbox - added indeterminate option

Added indeterminate option to the system checkbox.

1000535 : Groupware Attachments - Toggle Select All

Added a select all checkbox for the attachment in groupware.
The attachment can be selected by default by a sugar config variable.

1000536 : Field Email Status - added status icon "send"

Added status icon send to the field type email status

1000538 : Questionnaire Field

Allows an entire questionnaire to be displayed as an input field.

1000539 : Richtext Editor: Improvements

- Added useMediaFile option to enable/disable using media file module
- improved the fullscreen logic
- added insert image from url tool

1000540 : Object Related List - Display Edit Modal

On save failure on object related list because of required fields are empty, edit modal will open to allow user to fill in the required fields.

1000541 : Assignable Vardefs - Assigned User ID Type Adjusted

Changed to assigned_user_id field type from 'relate' to 'varchar' length 36

1000542 : Address Field - Google Place fill with Current Language

When the Google Place API retrieves the address by the place id, the current language will be considered and the results will be returned with the current language.
This affects the AddressField Type when searching by google places.

1000544 : Email Schedules - Added Parent Fields

Added parent_id, parent_type to to the EmailSchedules module to allow displaying the Schedule in Activity Stream or in a related panel.
Displayed the EmailSchedules subpanel under TargetLists Campaign Tab.

1000545 : Field Email Addresses - Opt In Status, Improvment

Adjusted the usability for managing multiple email addresses. Added field opt_in_status to the email addresses relation table to display a status icon for an email address. Added singleMode option to allow using the field for only one email addresss.

1000546 : New dictionary type "shorttext"

Added a new dictionary type shorttext that also can hold a length. Used mainly for Oracle to hold fields with up to 4k and not create BLOBs since that siginifcant increases performance.

1000547 : Cleanup DB column removal

Updated the column removal tool to better usability. The tool allows to compare actual DB structure with the vardefs and remove columns in the Database that are no longer needed.

1000548 : Add Option to load more manually in Listviews

It is an option to allow the user to load more items manually rather than automatically loading when reaching the end of the list in an infinite list view

1000549 : Added an option for item numbers in the ObjectList

An option has been added to number the lines in a listview supporting the viewing and navigation in large datasets.

1000550 : Added count of selected item in List Header Details

Added Information on the number of selected items in the list view to the list header details. This makes it easier in case of selection scenarios to easily understand how many records are selected.

1000551 : DIsable Export Buttons if no record is selected

added the feature that the export buttons in the list header are disabled if there is no record selected. Increasins usability.

1000552 : Added Range select option to the list actions

Added a new option with the component ObjectListHeaderActionsSelectRangeButton allowing a user to select a number of records based on a range specified.

1000553 : Module Subscription Button

Added a subscription button in the header in details view to enable/disable subscribing on a specific record to get notifications if any field value was changed.

1000554 : New Field - Icon Condition

Added a new field icon condition which displays an icon based on the given module filter condition match. It can also be used to display a neutral icon without condition.

1000555 : New Field - Email Activity Openness

Adde a new field email activity openness to enable toggling the email openness status between 'open' and 'user_closed'.

1000556 : Added pagination buttons to the subpanel

Added a pagination button bar to the subpanels, so in additon to the view all there is now also a pagination bar.

1000557 : Properly set default currency

Changed logic in the currency field so the default currency is pulled properly from the user preferences. Also removed the default values in the generic copyrules for Opportunities and Salesdocs.

1000558 : Added length limit to text field

Added length indicator and limit to the text field if a length is set. This is also to accommodate ORACLE text fields (nvarchar) that have a length limitation of 4000 chrs before they become a blob.

1000559 : Proper Number formatting in list count and aggregates

Added number formatting for the items, totalcount and the aggregate item count in the list views

1000564 : FTS and Logger Transactional

Make FTS transactional and logging in separate DB connection

1000571 : Change Assitant to pull from Elastic

Changed the Assistant on the front page to retrieve the entries from the FTS engine with clear configurability using the module filters.

1000572 : Added Workflow Tasks to the Assistant

added Workflow Tasks to the Assistant on the home screen. This allows to also bring open Workflow Tasks to the assistant and thus to the user. Also added a separate view and field for the workflow task name that directly then links to the parent item.

1000573 : Meeting and Call reminders

Re-added the reminder field allowing the user to set a reminder on calls and meetings. This will prompt a popup with an alert in CRM and also a desktop notification when set and allowed the set duration before the event occurs.

1000574 : MS Exchange: improve response error handling

Some errors shall be returned to screen as exception before the logic falls into a php error.

1000575 : Disable Aggregate checkboxes when search is running

Minor change to disable the aggregate selection checkboxes when a search is running. This avoids conflicting and overlapping requests.

1000576 : Campaign Task - Send attachments with the email

Added attachment panel to Campaign Task to enable sending attachments with the campaign email

1000577 : Email Reply/Forward: Clone related entries from reference

Added field 'reference_id' to email.
Clone the reply/forward email related entries from the reference (original) email.

1000580 : Updated the Merge Feature

Amended the merge feature and dialog:
- Merge has been added to the list header actions. So entries can be selected from the list and merged from there
- In additon a check is made that the to be merged records can all be deleted
- Merge now also considers the attachments of a record
- The layout of the merge dialog has been amended. Also making it clearer from which record the merge has been triggered
- The merge als emits a message in the app internal broadcast channel and will trigger a reload of activities internally automatically showing the immediate results ater the merge in terms of related records.

1000581 : Handle delete event in navigation tabs

If a record is deleted (e.g. in a merge) and there is still a tab open with that record, the tab will be automatically closed (enforced) and also not prompting the user.

1000583 : Core Library Updates

Updated to
- Angular 12
- rxjs 6.6.7
- zone.js 12
- underscore.js 1.13.1

1000584 : FTS: config option for min and max ngram

Added the config options for min_ngram and max_ngram for the ngram analyzer and tokenizer.

$sugar_config['fts']['min_ngram'] = '2';
$sugar_config['fts']['max_ngram'] = '20';

enables customers to set min and max values

1000586 : Add connect now option to reconnect dialog

Added an option to reconnect manually right away in the reconnect await dialog. Also extended the default reconnect time to 10 seconds

1000587 : Checklists: Logic improved, Refactored.

FieldChecklist refactored to ObjectChecklist.
Focus/blur Logic improved.
Separated saving.
Temporary Backup fields added.

1000588 : Filter Panel - Multienum Type adjusted

Built an appropriate filter query for the fields from type multienum.

1000592 : Two-Factor Authentication (2FA)

Added 2Factor Authentication with TOTP Tools like google Authenticator

1000597 : API Log Enhancements

Consolidated the KREST log to the API log that now also captures the In and Outgoing Requests. This also captures incoming SOAP Requests. This also includes an update on the API Log viewer and the API Log config to have one central point to capture all events.

1000598 : CRM Log Viewer

Harmonize the CRM log viewer to be in line with the API Log viewer.

1000599 : Add embedded templates to template compiler

Added an option in the template syntax to add an embedded template in the syntax.

1000600 : Default navigation is now tabbed

Set the default navigation paradigm to tabbed view for the user preferences.

1000601 : Bug Fix: Audited text value was not saved properly

DBMananger was retireving the field type first from the type property which is not always the db type of the field.
Adjusted the DBManager class to retrieve the db type of the audited field to prevent saving the value in the wrong field in audit table.
Bug was discovered in workflow definition audit.

1000602 : New Component - System Checkbox Toggle

Added a new system component renders an input checkbox toggle and handle the value by angular two way binding.

1000603 : BeanFactory::getBean - Added "forceRetrieve" Option

Added 'forceRetrieve' Option on BeanFactory::getBean. This helps to ensure retrieving list items that are referenced to each other.

1000604 : Impersonation Login (ReIntroduction)

Only admin users may login as another user.

1000614 : Bug Fix: Reporter - Filter Reference Operator

Backend: In KReportQueryArray reference operator from type datetime fixed.
Frontend: ِFixed the reference dropdown values.

1000623 : HotFix Parameters description for route /configuration/spiceui/core/modelvalidations

CR1000634 : HotFix save validation rule für json string in action parameters

Save would not work when the parameter for an action is a json string