CAD tip # 13757:

Question

CAD

% platform category

Bulk editing of drawing properties (DWGprops) from Excel.

With the freeware LISP utility DWGpropsCSV you can populate the values of the drawing properties (DWGprops) of all DWG files in the whole folder at once, according to an Excel table with the property prescriptions.

Download the DWGpropsCSV utility from Download, load it into your AutoCAD using APPLOAD and run it, even in an empty drawing, by typing DWGPROPSCSV.

In the first prompt, enter the name of the text CSV (comma/semicolon-separated values, e.g. from Excel) file containing the prescription (import-rules) for the property settings. It may look something like this:

Lines beginning with a semicolon are comments. The first content row contains a list of property names to be set (column names with property values). One of these properties must be DWGNAME - the name or wildcard mask of the DWG filename(s) to update (use "*" for All DWGs).

The next lines of the file then list the property values for the individual DWG files. The individual files are identified by their filename in the DWGNAME column, or collectively by a mask (wildcard), perhaps even just "*" for uniform property settings applied for all DWG files in a folder. If no name in the table matches the name of the currently processed DWG file, no changes will be made to it.

You can set both standard properties, e.g. "Author", and also set/add any additional custom properties.

In the next prompt (dialog) you specify the folder from which all DWG drawings will be successively processed. However, the actual property settings (changes) will only be applied for DWG files whose name is specified in the CSV file (DWGNAME column) or whose names match the specified filename mask. The property settings will be applied from the first row of the table that matches the DWG name.

Note: If you want to use comma-separated (or semicolon separated) CSV files even in local environments, set the LISP variable:

(setq _CSVdelimiter ",")

ACADADTPlantACADMCivilMap

*CAD

8.6.2023 26863× FAQ

Comments Tell a friend

applies to: AutoCAD · AutoCAD Architecture · AutoCAD Plant 3D · AutoCAD Mechanical · Civil 3D · AutoCAD Map 3D ·

See also:
Tip 13891:	How to remove personal data from a document (Properties)?
Tip 13599:	How to read iProperties from Inventor models and drawings in AutoCAD DWGs?
Tip 13056:	How to copy DWG Properties from one drawing to another?
Tip 12796:	How to reorder custom DWG properties?
Tip 9516:	Automating properties in DWG drawings - hidden gem in Express Tools.

Selected tip: How to run Fusion 360 in a web browser? (URL)

Back All CAD Tips

Parametric text content in Fusion 360 sketches (and models). « | » How to add the SEARCH/REPLACE command into AutoCAD Web?

Have we helped you? If you want to support the CAD Forum web service, consider buying one of our CAD applications, or our custom software development offerings, or donating via PayPal (see above). You may also add a link to your web - like this "fan" link:

Text:

FAQ

Featuring:
Publish interactive 3D PDF models from AutoCAD, Inventor or Revit with Share3D More info

Please use these tips at your own risk.
ARKANCE is not responsible for possible problems that may occur as a result of using any of these tips.

CADforum

Tips, tricks, utilities, help, how-tos and FAQ for AutoCAD, LT, Inventor, Revit, Map, Civil 3D, Fusion, Forma, 3ds Max and other Autodesk software (community support by ARKANCE). See About CADforum.

ARKANCE CZ (CAD Studio) - Autodesk Platinum Partner & Training Center & Consulting Services Partner

CONTACT:
webmaster.cz@arkance.world | tel. +420 910 970 111



Visitors now: 7481