topic Betreff: Excel data to Block Attribute by unique ID in Visual LISP, AutoLISP and General Customization Forum

Excel data to Block Attribute by unique ID

Anonymous — Sat, 22 Apr 2017 10:39:21 GMT

Hi we are making archaeology project with 3 000 Items and some properties of them. I have made Block with Name ITEM and some attributes inside: (Unique) ID, VALUE1, VALUE2, VALUE3. Any way I must find manually that ITEM in map mark it, give an Unique ID number. All data with 3 000 ITEMS and it properties is in Excel format. Is't possible with AutoLISP import excel or .csv data to block Attributes by matching unique ID and other properties?

Betreff: Excel data to Block Attribute by unique ID

cadffm — Sat, 22 Apr 2017 11:06:39 GMT

There are some Tools, Google: Autocad Excel Lisp
non-dynamic-Blocks? Use ATTIN/ATTOUT from EcpressTools Menu

One other(better) example: http://www.lee-mac.com/macatt.html

Betreff: Excel data to Block Attribute by unique ID

Anonymous — Sun, 23 Apr 2017 10:30:43 GMT

I can make Data Extraction for global Block attribute collection and save data to excel format it's first part of AutoLISP Global extractor. And how I do understand second part of this AutoLISP Global attribute editor function is simple select similar block and for all selected blocks change one global value 🙂

I am missing global data import (update) from Excel or .csv file to Block with Unique ID.

Something similar should be Data Extraction with Linked data, but in this case Block attributes should be also updated by excel data.

Betreff: Excel data to Block Attribute by unique ID

Anonymous — Sun, 23 Apr 2017 13:17:44 GMT

I have found on Express Tools Tab magic Attributes Import/Export commands that can perfectly finish my job without AutoLISP.