Skip to content

2021

Lime CRM 2023.1 - Møllehøj

Product: Lime CRM Status: Cancelled

Description

To celebrate our Danish colleagues this release is named after the highest mountain in Denmark, Møllehøj! To be honest, maybe it’s not a mountain, more like a hill. A great hill though! Just like this release.

Features

⚡ Faster Save

We added the possibility to turn of database customizations on save. This will reduce the complexity and database traffic when saving objects. The benefits are:

  • Faster save
  • Reduced risk of deadlocks in the database
  • Less load on the database

This feature can be enabled with the feature flag run_sql_customizations_on_update set to false. It will then disable these SQL customizations:

  • csp_beforeupdate, csp_afterupdate, csp_afterdataupdate and csp_afterupdatecompleted.
  • SQL for update.
  • Update if relation has changed.

The main replacement at the moment where logic should be moved instead is Custom Limeobject.

📅 User Preferences: Date Formats

Select how you want to present time and dates. For example 2023-03-31 or 31.03.2023 for dates and 13:37 or 1:37 PM for times.

🍬 Some small goodies

  • Possibility to add prepare_update() hook for Custom Limeobject, which runs before the database transaction starts. Which could reduce the risk of deadlocks in the database when saving.

Bugfixes

We never have bugs, so I guess this section will always be empty

🧰 Included services and frameworks

  • LDC - 12.9.????
  • LISA - 12.8.35
  • Elastic Search - 5.6.16
  • Java Development Kit (JDK) - 8u111
  • Ngnix for Windows - 1.23.1.1 SnapDragonfly
  • NSSM - 2.21-134
  • Microsoft ODBC Driver 18 for SQL Server (MSODBCSQL18) - 18.0.1.1
  • Microsoft Visual C++ 2010 x86 Redistributable (VC Redist) - 10.0.40219.0
  • Microsoft Visual C++ 2015 x64 Redistributable (VC Redist) - 14.0.23026.1
  • Microsoft SQL Server 2012 Native Client (SQLNCLI) - 11.4.7462.66
  • Erlang OTP - 25.0.2
  • RabbitMQ Server - 3.10.5

Erlang and RabbitMQ needs to be manually uninstalled to get upgrade. Check version first, if it’s the same versions installed no action is needed. It’s optional to upgrade. If upgrading, both Erlang and RabbitMQ needs to be upgraded. Instructions can be found here: Uninstall Erlang and RabbitMQ when doing Lime CRM Server upgrade

Lime CRM 2021.1 - Kangchenjunga

Description

We continue to honor the diversity among the coworkers at Lime by dedicating a release to a mountain of their homeland. The dangerous and mighty Kangchenjunga, the highest mountain in India and third highest in the world, stands in stark contrast with this release. The first release of 2021 is a smaller release containing bugfixes but also some much wanted functionality.

Features

👨‍👩‍👧‍👦 Azure AD: Create Users and Groups

The Azure AD integration has gained the ability to create users and groups. By configuring your Azure AD you can automatically have the appropriate users, in the corrected groups, created in Lime CRM when they join your company. The functionality is easy and fast to configure.

❤️ Lime Admin Love

Lime admin has received some UI love. For instance an always expanded left menu and save buttons always visible at the top.

Lime%20CRM%202021%201%20-%20Kangchenjunga%20e3363edc88af45bfa9fceefa209163c9/Untitled.png

🔄 Export + import of views

Now you can export and import all views for a solution at the click of a button. Saves you a lot of time when migrating configuration (or doing a backup of your views)

Lime%20CRM%202021%201%20-%20Kangchenjunga%20e3363edc88af45bfa9fceefa209163c9/Untitled%201.png

Lime%20CRM%202021%201%20-%20Kangchenjunga%20e3363edc88af45bfa9fceefa209163c9/Untitled%202.png

👩‍🔬 Experimental features

With this release we release a number of features as experimental. They can be added by installing the associated extra packages or enabling a feature switch. Experimental features are not quite ready for everyday use yet, but can be tested and played with.

✨ Experimental: New Object Card

We've rebuilt the Overview tab on the object card completely. This makes the card look better and load faster. We're using something called limel-form now, thus using the same technology we use for custom forms. This will enable us to provide awesome feature for this tab in a not very distant future

Lime%20CRM%202021%201%20-%20Kangchenjunga%20e3363edc88af45bfa9fceefa209163c9/2021-04-22_08.44.58.gif

🤓 Experimental: Create Advanced Filters

Now you can build practically any filter set you like in Lime Admin using the add-on Filter "Editor". You need some Lime Query skillz, so it's mainly targeted at application consultants and tech-savvy project managers.

Build advanced filters by writing raw Lime Queries

Build advanced filters by writing raw Lime Queries

🚀 Experimental: Web Client Bulk Update

With the new bulk update feature you can now update a property of several lime objects in one go!

Quickly update one or several properties in a table

Quickly update one or several properties in a table

💾 Experimental: Web Client Data Export

Exporting data from Lime CRM is a very useful feature, to easily continue working with your data in other systems. You can now export several lime objects to a CSV or Excel file in one go! It is possible to configure which groups have export access in Lime Admin.

Export data from a table to CSV or Excel

Export data from a table to CSV or Excel

📄 Experimental: Document templates in Web Client

With document templates you can can create new Word documents in Lime CRM based on templates with incorporated data from Lime CRM.

Lime%20CRM%202021%201%20-%20Kangchenjunga%20e3363edc88af45bfa9fceefa209163c9/2021-04-22_17.12.19.gif

Bugfixes and Minor Improvements

  • String fields of the type text are now supported in the webclient
  • Corrected date formats in web client
  • Client no longer crashes when system properties are used as first column in tables
  • Corrected a lot of annoying UI bugs
  • Various file improvements and fixes, including added object access for file endpoints
  • Support for additional operators for set fields when using QueryObjects
  • Fix for the task handler restarting

Included service and frameworks

  • Elastic Search 5.0.0
  • JDK 8.1
  • Ngnix 1.15.3.1 Crow
  • Erlang R16B03
  • RabbitMQ 3.2.4
  • SQL Native Client 11
  • Vcredist 2019
  • 1 min read

Build issues with lime-crm 1.6.2 and 1.3.1

Problem description

  1. You run poetry lock.
  2. After that either your tests are failing due to a missing library (win32com) or missing DLL-files

Solution

  1. Remove the pyproject cache by completely removing the folder %localappdata%\pypoetry.
  2. Re-run poetry lock.

Previous workarounds no longer valid

Previous workaround to add pypiwin==223 as a dependency to your solution is no longer needed and this dependency should be removed.

We've also seen workarounds where lime-ldc has been added as a dependency. That's not needed anymore and should also be removed.

  • 2 min read

CPU spikes because task handler service reports it is already started

Problem Description

CPU spikes because the task handler service continuously try to start and logs the following error messages:

ERROR: Pidfile (C:\ProgramData\Lundalogik\LIME Pro Server\Task Handler\task-handler.pid) already exists.
Seems we're already running? (pid: 2064)
ERROR: Pidfile (C:\ProgramData\Lundalogik\LIME Pro Server\Task Handler\task-handler.pid) already exists.
Seems we're already running? (pid: 2064)
ERROR: Pidfile (C:\ProgramData\Lundalogik\LIME Pro Server\Task Handler\task-handler.pid) already exists.
Seems we're already running? (pid: 2064)

Solution

We recommended a upgrade to solve this issue, but there also is a manual patch available.

Upgrade

Upgrade to latest Lime CRM Server.

Manual Patch

  1. Open Registry Editor on the Lime server.

    1. Go to key: 
      HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\lime-task-handler\Parameters

    Change AppParameters from:

    worker -A lime_task.worker -n taskhandler1@%h -l warning --pidfile "C:\ProgramData\Lundalogik\LIME Pro Server\Task Handler\task-handler.pid" -P gevent --concurrency 2

    To:

    worker -A lime_task.worker -n taskhandler1@%h -l warning --pidfile= -P gevent --concurrency 2

    2. Go to key: 

    HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\lime-task-scheduler\Parameters

    Change AppParameters from (remember that the install path might differ!):

    beat -A lime_task.worker --pidfile "C:\ProgramData\Lundalogik\LIME Pro Server\Task Handler\task-scheduler.pid" -s "C:\ProgramData\Lundalogik\LIME Pro Server\Task Handler\celerybeat-schedule" -l warning

    To:

    beat -A lime_task.worker --pidfile= -s "C:\ProgramData\Lundalogik\LIME Pro Server\Task Handler\celerybeat-schedule" -l warning
    2. Restart Lime Task Service 3. Restart Lime Task Scheduler

  • 1 min read

You must upgrade Lime CRM Desktop Client before you can connect to this server

Problem Description

User get a prompt saying: “You must upgrade Lime CRM Desktop Client before you can connect to this server.” when trying to login with Lime CRM Desktop client.

Solution

Download and install latest Lime CRM Desktop release or talk to your Lime CRM administrator, if you aren't allowed to install updates on your computer.

Details

The Lime CRM Server the user is trying to connect to doesn't approve the Lime CRM Desktop version being used. Usually this is because of a security update on the Lime CRM Server. To avoid this problem we recommend to have automatic updates turned on in Lime CRM Desktop and make sure to click update when there is a new version available.

  • 1 min read

UpdateLauncher error when trying to use Automatic Updates in Lime CRM Desktop

Problem Description

When a user is trying to install a new version from the Automatic Update banner in Lime CRM Desktop they get a prompt with this error:

“*File requested to be installed has either been tampered with or is missing its digital signatures.

This application will now exit and no action will be performed for security reasons..*”

Solution

Download and install latest Lime CRM Desktop release manually or talk to your Lime CRM administrator, if you aren't allowed to install updates on your computer.

Details

This is a bug in automatic updates which concerns Lime CRM Desktop versions 10. We haven't seen the issue in Lime CRM Desktop version 11 or later.

Version 10.18.221

Released April 8, 2020.

New features

  • The desktop client now works with 64-bit Office installations!

It is not possible to show inbox/calendar/contacts as panes if using 64-bit Office. Everything else should work as with 32-bit Office.

Bug fixes

  • For 64-bit Outlook: Document preview in Outlook now works when Lime CRM is running.
  • For 64-bit Outlook: Preview of meetings in calendar now works when Lime CRM is running.

Version 10.18.558

Released October 8, 2020.

Improvements

  • Added linker flag /LARGEADDRESSAWARE to enable 4Gb addresses in Windows x64. The client now has full access to 4Gb address space when running in 64-bit Windows.
  • Enhanced error handling
  • Refactored event handling for Outlook-integration
  • Added detailed logging for VBA initialization
  • Filtering while typing is now triggered via timer to reduce risk for deadlock
  • Added support for starting with VBA-macros disabled via /SafeMode commandline switch

Bug fixes

  • Fixed problems with HTML-formatting for email
  • Fixed crash related to ActiveUser.Record in databases where current user is not associated with any records
  • Fixed problem with outgoing mail being deleted before sent
  • Fixed problem where Localize-module was not properly detected for patching against known problem
  • Excluded WorkingFolder from published settings
  • Fixed major memory leak for filters in explorer views.
  • Fixed crash for accessing XML-property of collections.
  • Fixed crash in reports for “Microsoft Print to PDF” (or any other printer without paper bins).
  • Added binary back-off algorithm when retrying after server connection errors.
  • Added retry for IO-errors for server connection.
  • Added retry for calls via FileAPI to workaround problems with lost connection while loading VBA-file.
  • Added registry settings to guard shared VBA installation against uninstall.
  • Fixed problems with certificate revocation status.