• Performance monitor - Merge SQLite databases if running from separate regions - Just Sharing

    Maybe someone has a PowerShell script to do the same thing or a neater way? (Merging multiple sqlite databases to one - Machines were from different regions with no access to a central db) For this I required sqlite3.exe from the sqlite tools bundle and…
  • Where can I find reference material for writing Projectwise SQL queries?

    Hi, I need to populate some attributes using SQL queries. I can't find any information on the table names, or field ID's. Can anyone point me in the right direction please?
  • Populating Document Attribute with 'Connected Project GUID' With SQL Statement

    Hi all, I've been trying for a while now to cobble together an attribute that contains a "Get Link"-like address to the target document. The intention is to keep a trail to the source document whenever it's exported (through attribute exchange), attribute…
  • Error in ProjectWise Administrator

    Hello community, When I try to create a new datasource (in the server that I created in "SQL Server") in "Projectwise Administrator" I get the following message: "You will not be able to modify global Projectwise Integration Server properties on (my…
  • Projectwise database register issue

    Hi , I've got some issue in connecting database through Orchestration Framework. I've tried connect via ODBC and Direct Database Connection, both of them show the same error " Invalid object name 'eimVersion'. " How do I fix this issue. Thanks for every…
  • SQL Statement to create a filtered picklist for Doc Code Attribute

    Hi, I am currently building a new set of environments for my organisation and have started to build the document code. I have managed to successfully define it but I would like to introduce a few smarts like filtering it around a project number and…
  • Saved Search with Complex SQL Query

    I am creating a ProjectWise SAVED SEARCH that will list all Work Area folders that have discipline folders (a,c,e,i,m,s,cs) that have permissions (folder and/or document) assigned to groups or users other than "Administrator" (1) or "CADD Admins" (2)…
  • Sub-Work Areas and Work Area Property Inheritance

    Is there a way for sub-work areas to access the work area properties of a parent work area? In this post it mentions that you may be able to drive them via SQL statement, but I'm having trouble getting that to work. The Value area of a work area property…
  • Active Project Participants filtered by active Project number

    Has anyone been able to use active project participants as an attribute in a PW Environment? What we are trying to do is get a list of the active project participants, which are prefixed with the active project number and then pass that as an attribute…
  • Custom SQL non clustered indexes

    Is this true? From our database team ... Our DBAs feel we no longer need to ask Bentley’s approval to create non-clustered indexes. They just need to inform the PW Administrators that they are creating it, after having tested it in the environments. Index…
  • PW: Generate document file name and description automatically (SQL)

    Hi. I am working on a new document import wizard. So far I am able to create a Document code generator which stores the ID to an attribute. This attribute is used as document name automatically. I have also created an Attribute tab with several other…
  • Proejctwise - SQL Statement

    Hi I have been trying to find the SQL statement to extract the value from a Projectwise attribute and place into a new attribute (placeholder) Current string 123456-CAL-DRG-0001 Required string CAL-DRG-0001 ie..remove the first 7 chars I would…
  • Yet another SQL Express setting to note…

    On some configurations, you will need to reach another Server for offload of Automated Processers requiring SQL Express. Sometimes in trying to connect to the remote server, you may get a “SQL server does not exist or access denied” message. A fix…
  • SQL Lockout Correction can be a Useful Tool !

    There is a new Technote on the Select Server Licensing area of the Wiki that might benefit some ProjectWise new installs. A User may need to use the logical database account (SA) for the SQL Server or SQL Express to connect to the database in New Datasource…
  • Have You Outgrown Your Environment? Four Steps to Free Your Data.

    ProjectWise now allows you to add new attributes and to delete old ones from an Environment; But what about the attribute that is now too small or the wrong data type? Are you stuck with the past? This blog is going to show you how to replace one field…
  • Database Maintenance for ProjectWise

    We get asked a lot what kind of database maintenance or things to keep in mind that a user should do on their ProjectWise system's database. These should be basic tasks that a database administrator would take care of, but sometimes that is not the case…