Is there a way to bulk change the default volume for folders? As you know, laserfiche documents can be migrated to a new volume using Workflow. However, this is not the case with Folders (at least not that I've found so far). Due to an issue with a corrupted volume that won't allow to add electronic files, we need to migrate all folders contained within that volume to a new working one. However, there are over 30k folders that we need to change. Has anyone come across a situation like this? Any help is greatly appreciated.
Question
Question
Answer
SELECTED ANSWER
replied on August 20, 2014
•
Show version history
Although we (Laserfiche) normally recommend against this, the best way to solve this problem is to run an SQL query against the database hosting the repository to change this value. What needs to be done is to update "vol_id" column in the "toc" table in the database for folders. Let's say the new volume has a volume ID of 5, and DEFAULT has a volume ID of 1. Then the query would look something like: UPDATE toc SET vol_id = 5 WHERE etype >= 0 AND vol_id = 1. You should not have LFS running while running this query. Backing up the database before running this query would be strongly advised.
1
0
Replies
You are not allowed to reply in this post.
You are not allowed to follow up in this post.