Posted Thu, 15 Mar 2018 22:16:30 GMT by Vinny Johnson Consultant

I am doing a migration from Fortis to DocuWare without the tool.  I need to capture the folder values from the FTBContainer tables and possibly import them as index entries in DocuWare.  I have 30+ databases with multiple doctypes in each database.  I guess what i'm looking for is the most efficient way to query each database that will show all folder values in columns associated with the F_documentID that describe the heirarchy  (top level, level1, level2, level3, etc....) of the folders as well as the index values.   

See poorly written query attached in screenshot.

 

thanks!

https://www.docuware.com/sites/default/files/forums-images/fortis%20sample%20script.png

Posted Thu, 15 Mar 2018 22:32:52 GMT by Ryan Ciszkowski Software Support Analyst

Good Evening Vinny, 

Are you on Fortis 6.11 SP1 or 6.12? 
Given the topic, would you be able to please create a Support Request through the Support Portal and we can take it further from there.

Ryan Ciszkowski
Software Support Specialist
Support Team Fortis – America

You must be signed in to post in this forum.