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

Question

Question

how to bulk change folder default volume?

asked on August 20, 2014

 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.

0 0

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.

Sign in to reply to this post.