topic Re: List of a Vault folder's contents in Vault Customization Forum

List of a Vault folder's contents

Anonymous — Fri, 15 Dec 2017 07:25:17 GMT

Hi folks. What is the best way to get a list of the files which reside within a specified Vault folder?

Ideally, I'd like to be able to limit it to just ".idw" files, but all the files would be a good start.

I have been trying some rather convoluted mechanisms which are not working out for me and feel like they are probably unnecessarily complex.

It seems like there would be a rather straight-forward way to get a listing of a folder's contents. Just a list of strings would be fine - or File objects or whatever. Thanks!

Best regards,
--Jeff

Re: List of a Vault folder's contents

gilsdorf_e — Tue, 19 Dec 2017 10:20:59 GMT

Hello, that does not seem to be a big deal in the Vault SDK.

 public List<String> getFilesInVaultFolder(DocumentService _docServ, String _folderPath)
        {


            Folder searchFolder = _docServ.GetFolderByPath(_folderPath);

            File[] fileArray = _docServ.GetLatestFilesByFolderId(searchFolder.Id, true);

            List<String> fileNames = fileArray.Select(x => x.Name).ToList();

            return fileNames;

        }

If you only use IDW and not IPN or Inventor DWG, you could use

  public List<String> getFilesInVaultFolder(DocumentService _docServ, String _folderPath)
        {


            Folder searchFolder = _docServ.GetFolderByPath(_folderPath);

            File[] fileArray = _docServ.GetLatestFilesByFolderId(searchFolder.Id, true);

            List<String> fileNames = fileArray.Where(y=>y.FileClass == FileClassification.DesignDocument).Select(x => x.Name).ToList();

            return fileNames;

        }

to only get the IDWs. Otherwise it is a bit more tricky and involves either the PropertyService or you need a search with FindFilesBySearchCondition().

Re: List of a Vault folder's contents

Anonymous — Tue, 19 Dec 2017 18:43:27 GMT

Thank you very much, Erik! That worked great.

For anyone who might find this and be using VB.NET, the similar LINQ expressions portion would be like this:

Dim filenames As List(Of String) = Nothing

'(All files in folder)
filenames = fileArray.[Select](Function(x) x.Name).ToList

'(IDW's only)
filenames = fileArray.Where(Function(y) y.FileClass = ACW.FileClassification.DesignDocument).[Select](Function(x) x.Name).ToList

Best regards,
--Jeff

Betreff: List of a Vault folder's contents

i.rudd — Wed, 20 Apr 2022 14:35:48 GMT

Hello,

You can also get the information to excel without the need of using any code:

1) In Vault: open folder of interest

2) Select column(s) of interest

3) Press Ctrl+c

4) Open an excel sheet and press Ctrl+v