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

Question

Question

Merge Parent Folders

asked on June 27, 2019

I need to create a workflow that will merge duplicate parent folders that contain sub folders and documents within those sub folders.  In some cases there maybe anywhere between 2-3 duplicates.  

I have the folders identified and was wondering would it be easier to merge them if the workflow referenced a table?

0 0

Answer

SELECTED ANSWER
replied on July 9, 2019

Technically, you already have a table. You could query against the propval table in the Laserfiche repository's SQL database with criteria on the ID of the "unique identifier" field and looking for values having count greater than 1.

What will speed things up though is if you spin off the merging as a separate workflow that you just invoke in your For Each loop. That way Workflow will parallelize moving documents or whatever other actions you're doing as part of the merge.

0 0

Replies

replied on June 28, 2019

Hi Bill,

By duplicate do you mean they are named the same but have a (2) or (3) after the name?  Are they duplicated because people are creating folders themselves?  If you have duplicate folders that are being created by workflow then you need to review your workflows and find out why it is duplicating instead of using the existing folder.

As to the move itself, how many duplicates do you have?  If it is a small amount would it be quicker to just manually move them?

Maybe you could include a screenshot of what you have and what you want the final result to be.

0 0
replied on June 28, 2019 Show version history

I guess I should clarify that the parent folders are duplicate, not the contents.

We have our folder structure based off of clients with each one having a unique identifier number, which is how we search for them.  During the initial ingestion of documents clients could have multiple folders so when we search by their identifier we can get multiple results.  Each parent folder has its on Entry ID but I can to combine the folders based off the unique identifier.

I have approx 800-1000 clients with multiple folders.

Capture.PNG
Capture.PNG (14.78 KB)
0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.