Vault Professional Tree Structure Export?

[phlyx]

Seems like this should be a fairly simple task but seems to be eluding me.  I would like to export the folder tree structure of Vault Professional 2024 to an Excel file.  I have been playing with Autodesk Report Template Utility but can't find a way to configure that to just export folders as that seems to create reports that are file based and not folder based.  Is there a report template available or some method someone has to generate a tree structure to an Excel spreadsheet?  Doesn't seem like it should be a complicated task.

Thanks in advance for your assistance!

[andrewiv]

I'm not aware of a way to do this, but it would probably be better to ask this on the Vault forum.  The Autodesk guys that work on Vault watch that forum and they would be able to give you an answer.

[phlyx]

Thanks, I'll post it over there.  I didn't click on SHOW MORE from the Product Design & Manufacturing forum index page so the Vault forum didn't show up.  🙄 

[phlyx]

Seems like this should be a fairly simple task but seems to be eluding me. I would like to export the folder tree structure of Vault Professional 2024 to an Excel file. I have been playing with Autodesk Report Template Utility but can't find a way to configure that to just export folders as that seems to create reports that are file based and not folder based. Is there a report template available or some method someone has to generate a tree structure to an Excel spreadsheet? Doesn't seem like it should be a complicated task.

Thanks in advance for your assistance!

[phlyx]

Thanks for merging/moving this to the Vault Forums, now I just need a solution 😁 

[phlyx]

So, no engineer or Vault manager has ever had a need to output their Vault tree structure?  Wow......

[phlyx]

When all else fails, keep digging for a work-around. 

Is there any way to copy the complete Vault folder structure to your local workspace withOUT downloading any files???

[jose_oltra]

Well, in fact, there's a workaround.

Connect to your database using ssms.

run the query:
SELECT [VaultPath]
FROM [<YourDB>].[dbo].[Folder]

Get that list on a TXT.

Replace $ for your WorkSpace folder.

Run a Powershell script to create all those folders.

Hope it helps

[andrewiv]

Out of curiosity, what do you need the folder structure for?

[ihayesjr]

The Get Folder command is available in Vault 2025 & 2026.

Vault Help | Get Folder from Vault | Autodesk

[phlyx]

Thanks!  I do not have admin right on my ws so might not be able to do that.

[phlyx]

The company I work for started in the 1940's, obviously everything on drawing boards.  Then scanned on microfiche, then Unisys CAD, then AutoCAD, then Solidworks and Inventor (and then just Inventor), then we were run by a German corporation and they were pushing us to ProE (glad that never grew much), then we have changed hands a couple more times, merged several other companies with us, had several different product lines, each with their own engineering file structure, then random generated part numbers, then back to semi-intelligent part numbers divided by product line, then one number system for everything, and all of this is crammed into Vault.  We have probably +10,000 machines in the field that need to be supported, parts department goes crazy at times searching.  So I am trying to get a tree structure to make an index so we can find stuff quicker.... or sometimes even find stuff at all.

[phlyx]

O..... M...... G..... MM=mm and IN=in and now we can get folder in Vault....???   I need to push for us to upgrade!!! 😎 Thanks!

[phlyx · Accepted solution]

WAIT!  2024 has get folder!!!   I can just get the empty folders to my local workspace and generate a tree structure from that!   DUH!!!!!!!!!!!!!!!!!!!!!!!!  LOL 

[arkad_s]

I know it is late input but I thought it might be useful for others looking here in futur. It is about original question - export tree structure to Excel. You can try performing advanced search on folders only, for example using "Name contains *"

Then you need to check if "Folder Path" is enabled and try to export results to Excel:

Just few remarks:
- Above example is for full list of folders where logged in user has "Read" permissions (folders restricted for logged in user won't be listed)
- Above example is for root folder (you might try playing around with selecting specific sub structure fi needed

Be aware about "include subfolders" option being enabled or disabled when reviewing results

- When list of folders is long (exceed paging) you might need to expand search fully before exporting

I hope that helps.

[phlyx]

@arkad_s thanks for the suggestion.  I actually did a "get folders" to my local workspace which created the entire Vault folder structure locally without files.  Then I just went to a command prompt (cmd), switched to my workspace and did a tree /a >vault-tree.txt and that gave me a complete tree structure in a txt document I can mark up.  I am a DOS-a-holic so still find some things DOS can do that Windows can't.  😁