Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
OpenUtilities
  • Product Communities
OpenUtilities
OpenUtilities Wiki Sharing content across multiple sites
    • Sign In
    • +OpenUtilities
    • Access Service Request Manager
    • +Bentley sisHYD Multi Utility
    • Design Features - promis.e Functionality - Promis.e Standard
    • +OpenUtilities sisNET - English
    • +OpenUtilities Substation
    • Promis.e Paths
    • -Promis.e Wiki
      • +CONNECT Edition - Promis.e
      • About Promis.e
      • +Administration Features - Promis.e
      • +APIs_VBA - Promis.e
      • +Automation Features - Promis.e
      • +Component Features - Promis.e
      • -Component Management - Promis.e
        • +Catalog Manager - Component Management - Promis.e
        • +Create Macro - Component Management - Promis.e
        • +Create Symbol - Component Management - Promis.e
        • +Family Creation - Component Management - Promis.e
        • +Parts Database - Component Management - Promis.e
        • Sharing content across multiple sites
        • +Terminal_Pin_Plug Manager - Component Management - Promis.e
      • +CONNECT Services - Promis.e
      • +Data Manager - Promis.e
      • +Database Platform Support - Promis.e
      • +Display - Promis.e
      • +Drawing Management - Promis.e
      • +Engineering Design Considerations - Promis.e
      • Error - Object reference...General
      • +Find_Replace - Promis.e
      • Finding the Tutorial
      • +Installation_Configuration - Promis.e
      • +Interoperability - Promis.e
      • +Licensing - Promis.e
      • +Maintenance Features - Promis.e
      • +Migration - Promis.e
      • +OS Support - Promis.e
      • +Panel Layout - Promis.e
      • +Performance - Promis.e
      • +PowerPlatform Support - Promis.e
      • +Print_Publish Features - Promis.e
      • +ProjectWise Integration - Promis.e
      • Promis.e Help file
      • +Reports_Output Features - Promis.e
      • +Template Management - Promis.e
      • +Text Tools - Promis.e
      • Training FAQs
      • +Wire Numbering - Promis.e
      • +Wiring Features - Promis.e
      • +Project Management - Promis.e
      • Promis.e Title
      • Working from home with Promise.e
    • Replace Family - Find_Replace - Promis.e
    • SQL Server Login

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

    Sharing content across multiple sites

      Product(s): Promis.e, Bentley Substation
      Version(s): through 08.11.13.140
      Environment: N\A
      Area: Component Management
      Subarea: N\A

    We have users working at various geographically separated sites. How can we share supporting data that get updated regularly like symbol catalogs and parts databases?

    Background

    The short answer to this question is to keep local copies of the symbol catalogs and parts databases at each site, since accessing these items over a wide area network is known to result in poor performance.

    With such a strategy, the "master" catalogs and parts database are periodically copied to the various sites, depending on how often they are updated. This is often done nightly/off hours when no user is connected to the catalog databases or parts databases that would be getting overwritten.

    If multiple users create content, then a "librarian" is chosen and the creators send their content to the librarian who then updates the master catalogs and parts database. This article discusses this strategy.

    Steps to Accomplish

    • Creators can keep a personal catalog in which they create content, then export the content or entire catalog using Export Catalog. The librarian can then use Import Catalog to import the creators' catalogs. If no review is required, it is possible to import the catalog directly into the master catalog.
    • Since individual records from the parts database cannot be exported via the Promis.e or Bentley Substation interface, users could submit part number addition/change requests to the librarian who would make the change to the master database via Parts Database Manager.
      • Alternatively, creators could add/modify part numbers using Parts Database Manager, then send the local parts database file and/or notify the librarian who could use a tool like the Import and Export Data* application to import the data into the master parts database.
        • A template spreadsheet could be created that users would fill in with new part number information and send to the librarian. The librarian would import the spreadsheet into the master parts database using Import and Export Data*. The template spreadsheet should contain column headers named to match the fields of the parts database to make mapping the fields during the import easier.
      • Since the parts database is purely a database (no drawings or other related data), it could be converted to a SQL database if not converted already, and then replicated to the various sites using SQL Server functionality.

    *Import and Export Data is an application included with recent versions of SQL Server. This application can transfer data between various database formats, including Access (.mdb), Excel (.xls), and SQL Server.

    An alternative to the above is to have remote users use Promis.e or Bentley Substation via Citrix and have all users connect to the master catalogs and parts database. Recent versions of Promis.e and Bentley Substation can be run on Citrix, but this requires knowledge of how to publish applications on Citrix and may require additional hardware (Citrix servers).

    The master catalogs and parts databases would be copied to the sites periodically. Windows task scheduler could be used to schedule the execution of a batch file that would perform the copy.

      Original Author: Matt_P
    • Catalog Manager
    • parts database
    • promis.e
    • Bentley Substation
    • en
    • Installation_Configuration
    • Component Management
    • Share
    • History
    • More
    • Cancel
    • Matt_P Created by Communities MVP Matt_P
    • When: Wed, Nov 22 2017 11:48 AM
    • Matt_P Last revision by Communities MVP Matt_P
    • When: Wed, Nov 22 2017 11:53 AM
    • Revisions: 2
    • 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