CADWorx Plant tab: Database > Export
Plant menu: Accessory > Database > Export
Command line: DBFGEN
Exports CADWorx component information to a Microsoft Access or Microsoft Excel file.
When using live database, this command updates the appropriate database setup for the drawing.
Database Type
Select Access to write to a Microsoft Access file, or select Excel to write to a Microsoft Excel file.
Browse
Click to define the file name and folder location. The disabled boxes at the bottom of the dialog display the file name and folder in use.
Append/Sync
Synchronizes the drawing and the database file by removing entries from the database that no longer exist in the drawing and updating components in the database according to the drawing. You can use this command as often as is necessary to maintain the database according to the drawing. Many users can append to the same database file at the same time.
New
Creates a new database file based on the chosen folder and database type.
-
On the Database panel, click Export .
You can also type DBFGEN in the command line.
Enter an option [Line number/Select component] <Select component>.
-
Select Line Number to select components using line numbers.
Enter an option [List/Select component] <Select component>.
-
Choose List to select the line number from a list. For more information, see Select Item Dialog Box.
or
Choose Select component to select the needed components by crossing, window, or any other preferred method.
-
Select the components to write to the database file. Right-click or press ENTER when you are finished.
The Select Database Type dialog box displays.
-
Select Access or Excel to define the file type.
-
Click Browse, and define the folder and file name.
-
Select New if you are creating a new file.
or
Select Append/Sync if you want to synchronize an existing file.
-
Click OK.
If live database is being used, the prompt Continue to update live database? [Yes/No] <Yes>: displays.
-
Click Yes to update the database.
or
Click No to stop updating the live database.