Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
ProjectWise
  • Product Communities
ProjectWise
ProjectWise Design Integration Wiki How to find all empty folders in ProjectWise
    • Sign In
    • ProjectWise Design Integration Wiki
    • ProjectWise Software Download
    • +ProjectWise Learning
    • +Projectwise Licensing
    • ProjectWise Programming and PowerShell
    • +Projectwise Documentation
    • -ProjectWise Explorer Client
      • +ProjectWise Client
      • +Featured Articles - Projectwise Explorer
      • +Audit Trail - ProjectWise Explorer Client
      • +Bentley IMS Login
      • +BS1192 Rules Engine - ProjectWise Explorer Client
      • +Check In Dialog - ProjectWise Explorer Client
      • +Document Code - ProjectWise Explorer Client
      • +Document Creation - ProjectWise Explorer Client
      • +Documentation & Help - ProjectWise Explorer Client
      • +Environments and Attributes - PWE
      • +Export / Import Tool - ProjectWise Explorer Client
      • -Folders / Subfolders - ProjectWise Explorer Client
        • Folder descriptions displaying instead of name?
        • Inherited Environment
        • Cannot change attributes or participant settings under project properties
        • Error 13: Error Creating a New Folder
        • Error 58040 Creating new document
        • Error 7209065 Creating a new folder - Access Denied
        • Error 90002 While opening a file in ProjectWise
        • Getting error trying to delete folder from ProjectWise, "Last error [ 58008 ] Error deleting a folder. Folder has subfolders. A folder that is a parent to other folders cannot be removed".
        • How can I determine how many files are in a single folder, or in a folder structure?
        • Last Error [50000] Not found
        • No PW Managed Workspace in Folder Properties
        • Shortcut from one ProjectWise folder to another?
        • Slow performance when navigating in folders hang
        • Error 58040 (access denied) upgrading a folder to a project
        • How to find all empty folders in ProjectWise
        • Last Error - Error Deleting folder
      • +GUI - ProjectWise Explorer Client
      • +Installation - ProjectWise Explorer Client
      • +Integration - General
      • +Integration - AutoCAD - ProjectWise Explorer Client
      • +Integration - Civil 3D - ProjectWise Explorer Client
      • +Integration - DGN Platform - ProjectWise Explorer Client
      • +Integration - MicroStation - ProjectWise Explorer Client
      • +Integration - Office - ProjectWise Explorer Client
      • +Integration - Revit - ProjectWise Explorer Client
      • +Logs Troubleshooting- ProjectWise Explorer Client
      • +Messaging Service - ProjectWise Explorer Client
      • +MISC - ProjectWise Explorer Client
      • +Open / Save / Copy / Move - ProjectWise Explorer Client
      • +Photo Preview - ProjectWise Explorer Client
      • +ProjectWise Managed Workspaces
      • +Project - ProjectWise Explorer Client
      • +Search - ProjectWise Explorer Client
      • +Security and Permissions - ProjectWise Explorer Client
      • +User Tools - ProjectWise Explorer Client
      • +Views - ProjectWise Explorer Client
      • +Workflows & States - ProjectWise Explorer Client
    • +ProjectWise Administrator
    • +ProjectWise Integration Server
    • +ProjectWise Caching Server
    • +ProjectWise Gateway Server
    • +ProjectWise User Synchronization Service
    • +ProjectWise Orchestration Framework
    • +ProjectWise Connected Services
    • +Working from Home with ProjectWise
    • +ProjectWise Glossary
    • ProjectWise Hosting - Manage Services

     
     Questions about this article, topic, or product? Click here. 

    How to find all empty folders in ProjectWise

      Product(s): ProjectWise Explorer Client
      Original Author: Mantas Nauseda

    Background

    Creating ProjectWise Projects from templates might be creating loads of empty folders even after the project is completed. And it might be reasonable to clean up empty folders after the Project is completed to save space in database and reduce amount of records.

    This method helps to find all folders (depending on specific search criteria) that does not have any documents inside them or any sub folders.

    Steps to Accomplish

    To find empty folders we can use the ProjectWise Search builder:

    1. Open ProjectWise Explorer and log in to datasource
    2. Open Search Builder:

    3. Select Look for: Projects and Folders; Criterion Type: General Properties; Property: Folder GUID; for value we use custom query:
      $FIELD$ in (select o_projguid from dms_proj where o_projguid not in (select o_projguid from dms_doc) and o_subprojects='N')



    4.  And click Add Criteria.

    5. In addition we can define additional parameters, like for example a parent folder to look for empty folders in. For that we add Property: Parent Folder and select the required folder from ProjectWise.
    6. Running this search will find all folders that does not have any documents inside them and no sub folders.
    7. After finding all these folders we can then delete them, or mane any other required action.
    8. If needed this search can be executed few times, so that higher level folders would also be found (after removing their child folders)

    • search
    • Folders
    • ProjectWise
    • search builder
    • en
    • ProjectWise Explorer Client
    • empty
    • SELECTsupport
    • Share
    • History
    • More
    • Cancel
    • mantas.nauseda Created by Bentley Colleague mantas.nauseda
    • When: Fri, Feb 12 2016 7:38 AM
    • Dana Guthrie Last revision by Bentley Colleague Dana Guthrie
    • When: Fri, Oct 7 2022 3:37 PM
    • Revisions: 5
    • Comments: 2
    Recommended
    Related
    Communities
    • Home
    • Getting Started
    • Community Central
    • Products
    • Support
    • Secure File Upload
    • Feedback
    Support and Services
    • Home
    • Product Support
    • Downloads
    • Subscription Services Portal
    Training and Learning
    • Home
    • About Bentley Institute
    • My Learning History
    • Reference Books
    Social Media
    •    LinkedIn
    •    Facebook
    •    Twitter
    •    YouTube
    •    RSS Feed
    •    Email

    © 2023 Bentley Systems, Incorporated  |  Contact Us  |  Privacy |  Terms of Use  |  Cookies