You are viewing limited content. For full access, please sign in.

Question

Question

Changes to Excel document lost on check in?

asked on November 29, 2016

Hi,

I'm trying to determine what may have caused data loss in an Excel document when checking it back into Laserfiche.

A user checked out a document last week and made a series of changes over the course of the day and returned to the document yesterday to make further changes. Once complete they printed a copy of the document, which contained these changes. They then checked in the document and re-opened it, yet reported that all the changes were lost.

I could find no other versions of the document in Laserfiche, and in the users Windows recycle bin I found a copy of what seems to be the deleted version (from when the document was checked in) but it didn't contain the changes. The temp folder also contained a copy of the document but again it didn't contain the changes.

Obviously the user is very frustrated with the this and blames Laserfiche for causing this loss but proving otherwise is very difficult. I've always suspected the handling of temp files and directories maybe open error.

What scenarios or circumstances may have contributed toward this loss? Without knowing the exact mechanism of the check in/out procedure it's difficult to pinpoint the potential causes and appease the user.

 

0 0

Replies

replied on November 29, 2016

If you aren't on the latest version (currently 10.1 update 2), this might already be fixed.

0 0
replied on November 29, 2016

OK thanks that's good to know as they are running 9.2. Is there a specific issue we should be aware of until that upgrade is planned? Some client (such as these) are easy to upgrade but for other it is a long process (test, UAT etc) so trying to eliminate risk where possible.

0 0
replied on November 30, 2016

One scenario is that, the document is opened for long time and the connection may have been disconnected for some reason. 

0 0
replied on April 4, 2017

Couple of my clients are facing similar issues. Its occurring intermittently and they where finidng it hard to replicate. I suspect the connection to LF from MS Office was the case. Is there anything that can be done to identify this?

0 0
replied on April 5, 2017

since the issue occurs intermittently, it seems logging doesn't help much. Do you know how the users usually do when work with MS Office documents? for example, press Ctrl+S, click save button, or any others operation? The information can help us narrow down the cause and figure out the solution. Thanks.

0 0
replied on April 5, 2017

Hi Huazhen Liu,

Thank you for the response.

Users been doing Cntr+S as well as click save button. Today, i was watching how they where doing the save to laserfiche and figured out that, if the LF client is closed while working on an excel that is opened from Laserfiche,the connection will be lost and hence cannot save the changes within laserfiche. Confirmed with LF support that, this was not the case with previous versions of LF (Seems not to work for LF 10 and above) as they could do it before in version LF 9.0

 

 

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.