looking for lisp that extracts
Rakesh Rao
If you wish to extract the block attributes without opening the drawing,
you must use ObjectDBX programming.
For extracting block attributes from the current drawing, there are a
number of shareware and free lisp routines available. You can use some
blocks and attributes manipulation Lisp from the FREE sections of our
TechCenter download at extract attributes and send them to an ASCII
file.
You may want to check these out.
Regards
Rakesh
zx6roo wrote:
> Hi,
> I am looking for a lisp that can extract specificattributes out of a
> cad file and copy it to an excel spreadsheet (or anywhere, even to the
> actual file name if possible).
> Does anyone know of one or anything else that may help.
>
> Basically I have about a few thousand drawings that have attribute
> blocks in them and I need to retreive the information as fast as
> possible, preferably without opening each individual file.
> Can anyone help?
> Thanks.
--
AutoCAD customization for Engineering/Mapping/GIS
Get GeoTools @ http://www.4d-technologies.com/geotools
Build MyGeoTools @
http://www.4d-technologies.com/geotools/my_geotools.htm
FREE downloads : http://www.4d-technologies.com/techcenter
Andy Freeland
From AutoCAD Help ...
EATTEXT
With Enhanced Attribute Extract, you can query drawings for block attribute
information and save it to an external file in comma-delimited ASCII text
format, tab-delimited ASCII text format, or in either Microsoft Excel or
Access file format (if the appropriate application is installed on your
system).
Enhanced Attribute Extract is ideal for producing a schedule or bill of
materials directly from your drawing data. For example, a facilities drawing
might contain blocks representing office equipment. If each block has
attributes identifying the model and manufacturer of the equipment, you can
generate a report that estimates the cost of the office equipment.
The Attribute Extraction wizard guides you through selecting drawings,
blocks, and block attributes.
;HINT ... don't use a template.
;******* or *******
ATTEXT
Command line: attext
Specifies the file format for the attribute information, the objects from
which you want to extract information, and the template and output file
names for the information.
File Format
Sets the format for the file into which you are extracting the attribute
data.
Comma Delimited File (CDF)
Generates a file containing one record for each block reference in the
drawing that has at least one matching attribute tag in the template file.
Commas separate the fields of each record. Single quotation marks enclose
the character fields.
Space Delimited File (SDF)
Generates a file containing one record for each block reference in the
drawing that has at least one matching attribute tag in the template file.
The fields of each record have a fixed width; therefore, field separators or
character string delimiters are not appropriate.
DXF Format Extract File (DXX)
Produces a subset of the AutoCAD Drawing Interchange File format containing
only block reference, attribute, and end-of-sequence objects. DXFT format
extraction requires no template. The file name extension .dxx distinguishes
the output file from normal DXF files.
Select Objects
Closes the dialog box so you can use the pointing device to select blocks
with attributes. When the Attribute Extraction dialog box reopens, Number
Found shows the number of objects you selected.
Template File
Specifies a template extraction file for CDF and SDF formats. Enter the file
name in the box, or choose Template File to search for existing template
files using a standard file selection dialog box. The default file extension
is .txt. If you select DXF under File Format, the Template File option is
not available.
For information about creating a template file, see Attach Data to Blocks
(Block Attributes), in chapter 16, Draw Geometric Objects, in the User's
Guide.
Output File
Specifies the file name and location for the extracted attribute data. Enter
the path and file name for the extracted attribute data, or choose Output
File to search for existing template files using a standard file selection
dialog box. AutoCAD appends the .txt file name extension for CDF or SDF
files and the .dxx file name extension for DXF files.