Thursday 28 January 2021

PC going to sleep and MySQL 'gone away'

 There have been a number of incidents recently where problems have been reported with the database such as MySQL gone away.  Investigation has linked these to when the PC goes to sleep and this causing a disconnection to the server which in turn causes the database to disconnect the PC.


This seems prevalent among laptop users taking their devices off to meeting rooms for video calls and resuming Annapurna session straight afterwards.  If this is relevant then please review the PC sleep settings and/or restart Annapurna after returning.

Sunday 3 January 2021

Using Lens and Treatment combination to specify a different lens.

This documentation describes how it is possible to allow a combination of lens and treatment to be converted to a lens that has the treatment included. An example is an order for a lens with a sunglass tint that is converted to a pre-tinted lens code.

The data is maintained in a CSV file. The CSV file is accessible from Data / Lens Data.  In the bottom right there is a “More…”.  Click on this and then click on “Pre-tint Conversion CSV”. The CSV file will then opened.

The combination is based on lens and the treatments. If a treatment such as coating, tint or UV is not be considered then it is left blank in the CSV file.

The conversion csv file is deployed when the lens data is deployed.