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

Question

Question

Changing Default Volume for Large Number of Subfolders (vol_id)

asked on January 4, 2023

We’re troubleshooting doc export from ABBYY Flexicapture into Laserfiche.  It’s working, but not exactly how we would like it to for production.  It doesn’t seem to want to save to the subfolders that are already in place.  It will create a new set of subfolders off the Main folder and create the subsequent subfolders, but that creates a duplicate folder tree.  Not the desired outcome.  If we modify the output path to the existing root, it generates errors upon release and is unsuccessful.

Research is pointing to an issue where no Default Volume was set at the top level during the original setup, so a large number of subfolders do not have the 'vol_id' value set. 

I have set for all the top-level folders under the Main repository to the single volume that we use, but a vast majority of the subs do not have it set and I can find no way of cascading the change down through them from the GUI.

I'm wondering if going directly through SQL would be the fastest/best route.  Does anyone know if changing the 'vol_id' value to “2” (the id of the desired default volume in our repository) en masse to all the folders that are currently set to “NULL” in the dbo.toc table would be enough to achieve the goal?  Are their related values in other tables that would need to be changed as well?

Know of any other way to re-propagate the default volume value to all the subfolders?  There are about 3500 subfolders that will have to be modified manually, one-by-one, if I can't find a better way. 

Anyone else know any of other places to look re the original release issue if this doesn't resolve it?

 

0 0

Replies

replied on January 10, 2023 Show version history

A solution was arrived at yesterday morning that resolved our quandary:  We were able to do a search on folders only from within the Laserfiche 11 client. We did this by choosing the "Name" option from the "Customize Search" dropdown, and deselecting "document" and "shortcut" as options.

Once the results had populated, we selected all the folders that were returned then we were able to apply the change to all of them via an action called "Set Default Volume..." in the "Tasks" menu.  Took about 30-45 seconds to make the change across ~7000 folders in our system.

Pretty painless and doesn't leave any unanswered questions about additional SQL changes that might be required. 

3 0
replied on January 10, 2023

I tried this out out of curiosity on my Dev system by running a SQL command to update the vol_id column, filtered on parentid and where the vol_id = NULL.


After running this though it didn't update the default folder volumes so I suspect there are either constraints in place and/or other tables that need updating. Direct SQL updates are generally frowned upon though so it may be better to look at a workflow SDK script, or stick with the manual option. I don't have any code to hand that would achieve this but others may have done something similar.

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

Sign in to reply to this post.