Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
ProjectWise
  • Product Communities
ProjectWise
ProjectWise Design Integration Wiki Right Click Document Folder Export, Tools Export Import Wizard, Export Import with Excel TN
    • Sign In
    • ProjectWise Design Integration Wiki
    • ProjectWise Software Download
    • +ProjectWise Learning
    • +Projectwise Licensing
    • ProjectWise Programming and PowerShell
    • +Projectwise Documentation
    • -ProjectWise Explorer Client
      • -ProjectWise Client
        • Actions that Automatically Lock and Check Out Files in ProjectWise Integrated Autodesk Revit
        • Assign Spatial Location to Digital Images
        • Assign Spatial Locations Your Way with VBA
        • Command Line Arguments
        • Creating PDF Files Containing Project Explorer Links [CS]
        • Deploying a Custom Toolbox [TN]
        • Enumfolders.exe  TN
        • Error 55011
        • Exploring The Possibilities Of Properties [CS]
        • How To Setup Attribute Bulk Update [TN]
        • Permissions in ProjectWise [TN]
        • ProjectWise BatchPlot Quick Reference [TN]
        • ProjectWise Explorer White-Screen Socket Close Failure [TN]
        • PWV8.BRG Information Is Now Stored in the Windows Registry TN
        • Reload Workspace Dialog
        • Right Click Document Folder Export, Tools Export Import Wizard, Export Import with Excel TN
        • Send To Options missing from PW Menu
        • Setting Preview On For Microsoft Office Documents [TN]
        • Sharing Customized Toolbars Among ProjectWise Users [TN]
        • Suggested Document Viewers [TN]
        • Using The ProjectWise API In VBA
        • Using The Workspace Profiles Capability In Bentley ProjectWise [CS]
        • Error 56013 Cannot login to the datasource. Invalid database name
        • How to upgrade Projectwise
        • ProjectWise Explorer shows the splash screen for a second and crashes
        • ProjectWise list of services and folders to exclude from a Virus Scan
      • +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
      • +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. 

    Right Click Document Folder Export, Tools Export Import Wizard, Export Import with Excel TN

     

    Overview

    Projectwise provides three Export Import tools used for Exporting Datasource Data and files. Each tool provides unique features to accomplish different tasks.  This Technote will give a high level overview of what each tool could be used for, and how it works.

    • Document Export Wizard and Folder Export Wizard
    • Projectwise \ Tools \ Export or Import wizard
    • ProjectWise Export/Import (with excel)

     

    Prerequisite

    • Projectwise V8i Client Installation, that Includes the Projectwise Export Import Excel tool

    Document Export Wizard and Folder Export Wizard

    These tools are used when you want to send the file(s) out of ProjectWise to be edited by another user (for instance to a contractor) or maybe to work on them offsite. Once the file(s) are exported, the file(s) are locked and cannot be edited in Projectwise. When editing is completed you can then import the file(s) back into ProjectWise which removes the lock. Think of it as a long term checkout.

    Another option this tool offers is to “send the file to a folder” as an unmanaged copy. The file will not be locked in ProjectWise so it can still be edited by other ProjectWise users. This option is useful for forwarding the file(s) to someone to view or take out in the field for comparing to what is happening on site. Again, these files (that are on the desktop) should not be edited as they are unmanaged by Projectwise.

    Basic steps for using these tools

    Document Export Wizard

    • Highlight a file(s), right click, Export. The Document Export Wizard comes up
    • There are two options in this wizard
    • Export – this option locks the file so no one else can edit it.
    • Send to folder – This option creates an unmanaged local copy of the file(s)
    • To import the Exported (Locked) file(s) back into Projectwise simply Highlight then right click on the file(s) and choose import. The file(s) need to be located in the same directory they was exported to.

    Folder Export Wizard

    • The same options are available to export a folder, its sub folders and files.
    • Right click a folder and choose export.
    • You are presented with a similar dialog as the document export wizard where you can choose to export and lock the files or just send them to a folder.
    • It is not possible to import a folder as there is no right click option to import.
    • To import all the exported (Locked) files from the folder export, do a search in the folder for all exported files, Highlight all the locked files, right click then choose import.

    Projectwise \ Tools \ Export or Import wizard is used for Exporting Datasource Data and files

    Lets’ say you want to create another datasource that has the exact same environment and folder structure as your current one.

    Projectwise offers a set of tools to export and import environments, saved searches, projects and folders, documents, workspaces, rendition profiles and components, applications, departments, queries, and workflow.

    These tools can be found under Start \ Bentley \ Export to AAM file wizard or Import from AAM file wizard 

    The export process creates a script file with the extension of '.AAM' that contains records of the data that is exported. If exporting files, the files are saved as .DAT in dms folders.

    The import process reads the script file that was created during the export and directs the tool to create the objects in the new datasource as well as import the files.

    When you first run the tool you will notice that the export wizard does not offer all the options listed above. Some options like the workflow require the tool to be run via the command prompt with a switch.

    For the Export command line switches see the Projectwise Explorer help under:  Projectwise Explorer \ ProjectWise user tools \ Exporting Datasource Data \ to Export a Datasource using the command line

    For the Import Command line switches see the Projectwise Explorer help under:  Projectwise Explorer \ ProjectWise user tools \ Importing Datasource Data \ to Import exported Datasource data using the command line.

    For more information see: Exporting Datasource Data (bentley.com)

    ProjectWise Export/Import (with excel)

    The ProjectWise Export/Import tools are used to bulk import files and attribute data from external sources into ProjectWise, or to bulk export files and attribute data out of ProjectWise. The ProjectWise Export/Import tools use an Excel spreadsheet as the data interchange format. The ProjectWise Export/Import tools support the transfer of most standard ProjectWise attributes, including versions and the creation of new versions during import, but do not support workflows and states.

    The basic steps in using this tool are

    • Using the start \ Bentley \ Excel Export – Import\ Create an excel template, log in to the datasource and create the template with the properties and attributes you wish to capture.
    • Using the start \ Bentley \ Excel Export – Import\ Export to Excel, log into the datasource, choose the excel template you created, create the excel output spreadsheet, choose where to place the files on the desktop, choose the files to export, click finish.
    • The files will be exported and locked (if you choose that option) and the attribute data will be entered in the excel spreadsheet.
    • You can then edit files and edit the excel spreadsheet to change the attribute data.
    • Using the start \ Bentley \ Excel Export – Import\ Import from Excel, log into the datasource, choose your output excel spreadsheet and follow through the wizard to import the files and data.

    For more information on this tool see Using the Export to Excel / Import from Excel Tools (bentley.com) 

    See Also

    • Bentley ProjectWise Export/Import
    • Export / Import Wizard
    • Export Import
    • Share
    • History
    • More
    • Cancel
    • Dana Guthrie Created by Bentley Colleague Dana Guthrie
    • When: Fri, Mar 14 2014 10:44 AM
    • Dana Guthrie Last revision by Bentley Colleague Dana Guthrie
    • When: Tue, Dec 6 2022 11:26 AM
    • Revisions: 3
    • Comments: 0
    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