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.

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. 

Storing Send-in frames in a defined bin location

 

Bin number for Send in frames.

This is a simple way to record a location for the frames that are received and are waiting for lenses to arrive.

In Settings / Job Entry / Frame Actions, tick “Ask for Bin on Send In Frames”.

In Order Entry, when the order is placed a question for the frame bin number is asked. This is usually done by having a set of small tags / barcodes with bin numbers on. One of these is taken from the free list of unused tags and entered. This number is then recorded on the order and can be printed on the layout.

The frame is then taken to the area and placed in the appropriate bin with the tag. The frame bin can also be seen in View Order.

When the lenses arrive, the receive program is used to record the lenses which will also show the frame bin.

The frame is matched to the lenses. The tag can then be returned to the free list or placed in the tray. If there is a glazing reject then the tag can be used to return the frame to the bin. In this case when the order is completed then the tag can be returned to the free list.

Including EORI on delivery notes

There are program updates to include an EORI number in the delivery note.  

More details are here: 

EORI Updates

Automatic Sending Orders to Supplier

 Sending Orders to the suppler automatically.

Firstly, the 'Include in Auto' in the supplier configuration is ticked. If tracking status is to be obtained then the 'Tracking' is ticked also.

Santiago is used to start a task to send the orders automatically. This is normally done by creating a batch file to do this.

Eg

l:\progs\annapurna.exe USER=xxxx PASSWORD=yyyy AUTO

User xxxx needs to be created in Annapurna with Password yyyy. Importantly in the user configuration for xxxx in the “Automatic” section, then 'Send Orders' needs to be ticked. This setting tells Annapurna when the user logs in to start the order sending.

Normal operation is to send orders and then look for status updates. It is possible to change this by starting Annapurna (or amending the batch file) to have

SENDONLY to send orders only

TRACKONLY to read the tracking only.

Some sites will have SENDONLY running every 30 minutes but TRACKONLY set for twice a day. This is done by creating separate Santiago entries.

Privacy on Orders - Employee accounts

 There is a new flag on the customer record which will prevent standard users from viewing the prescription details on an order.

Send an email when 'Watched' orders are completed.

 Orders can be marked as watched when there is a need to follow the progress of the order. Usually this is because there is a dialogue with the customer over the order.  There is now a setting to send an email when these orders have been completed.

More information is here:Email watched