CAD tip # 13757:

Question CAD
% platform category

Bulk editing of drawing properties (DWGprops) from Excel.

With the freeware LISP utility DWGpropsCSV you can set 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.

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 25063×

Comments Tell a friend

Prices - CAD eShop:

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: Automatically save raster images edited in Raster Design.

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:

CAD: OS: Categ:
Text:	FAQ glossary

Featuring:
DwgTextTranslator translates a series of drawings from one language to another using MS Access.
Download a fully functional trial version.

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

	CAD Forum - tips, tricks, utilities, help, how-tos and FAQ for AutoCAD, LT, Inventor, Revit, Map, Civil 3D, Fusion 360, Forma, 3ds Max and other Autodesk software (support by Arkance Systems) - see About	Arkance Systems CZ s.r.o. (CAD Studio) - Autodesk Platinum Partner & Training Center & Consulting Services Partner	CONTACT: webmaster.cz@arkance-systems.com tel. +420 910 970 111
	Copyright © 2024 \| Advertise with us \| Online privacy

CZ \| EN \| DE
Login or
registration
	Visitors: 13468