When re-importing Excel-sheet in Data Manager for the whole AutoCAD Plant 3D project, every affected single drawing will be opened

Autodesk Support

Oct 8, 2023

Products and versions covered

Issue:

When re-importing Excel-sheet in Data Manager for the whole AutoCAD Plant 3D project, every affected single drawing will be opened, which takes time. How to update the needed changes for a pipe line group in a faster way for the whole project?

Solution:

It is possible to update the information directly in the database. In this example the service for a specific line number should be updated for the P3DLineGroup-class. 

Follow these steps:
  1. Make a backup of your database!
  2. Open the specific project base
    1. SQLite project: Piping.dcf
      1. SQLite Editor like SQLite Expert Personal.
    2. SQL Server project: <prefix>_Piping.
      1. SQL Server Management Studio
  3. Run SQL statement like that one (replace the values or columns by your needs):
UDATE P3DLineGroup
SET Service = 'AV'
WHERE Number = '999';
  1. If the project is already open in AutoCAD Plant 3D, close and reopen it.

Products:

AutoCAD Plant 3D;

Was this information helpful?

Need help? Ask the Autodesk Assistant!

The Assistant can help you find answers or contact an agent.

Ask the Assistant

What level of support do you have?

Different subscription plans provide distinct categories of support. Find out the level of support for your plan.

View levels of support