topic Re: Lisp To Automatically Create a DATA EXTRACTION to EXCEL Document Automatically when Saving. in Visual LISP, AutoLISP and General Customization Forum

Lisp To Automatically Create a DATA EXTRACTION to EXCEL Document Automatically when Saving.

Anonymous — Fri, 05 Feb 2021 14:29:04 GMT

Hello all,

We have a drawing that is full of set blocks that will never change, and we use these blocks to create 2D floor plans of the same modular building set up. But for different clients.

We have all of our attributes set up and we can manually extract all the data to an excel document so we run this often to see the data.

We have been trying to get this section automated. If I was to save the drawing, we are trying to get the inventory list to automatically save in a shared location so that can then be handed out to staff.

We have looked into the lisps and we are pretty much self taught so we are a bit stuck with the Auto Lisp creation.

Any advice / help would be appreciated.

Re: Lisp To Automatically Create a DATA EXTRACTION to EXCEL Document Automatically when Saving.

devitg — Fri, 05 Feb 2021 14:47:15 GMT

@Anonymous Do you mean some like a automatic ATTOUT ??

Re: Lisp To Automatically Create a DATA EXTRACTION to EXCEL Document Automatically when Saving.

Anonymous — Fri, 05 Feb 2021 14:59:07 GMT

Hello,

We currently use command: DATAEXTRACTION and then we follow the instructions through.

We have not set this up for ATTOUT, but again we are self taught so we may not have looked into that?

Re: Lisp To Automatically Create a DATA EXTRACTION to EXCEL Document Automatically when Saving.

devitg — Fri, 05 Feb 2021 15:12:43 GMT

As far as I know , DATAEXTRACTION can not be do by lisp .

or try it

http://www.lee-mac.com/macatt.html

Re: Lisp To Automatically Create a DATA EXTRACTION to EXCEL Document Automatically when Saving.

Anonymous — Fri, 05 Feb 2021 15:12:24 GMT

So how does ATTOUT differ from data extraction?

Re: Lisp To Automatically Create a DATA EXTRACTION to EXCEL Document Automatically when Saving.

devitg — Fri, 05 Feb 2021 15:54:48 GMT

attout is a native acad command

Please read my private e-mail I sent you

Re: Lisp To Automatically Create a DATA EXTRACTION to EXCEL Document Automatically when Saving.

maratovich — Fri, 05 Feb 2021 17:50:07 GMT

Please attach an example of your file.
And an example of what you want to get.

Re: Lisp To Automatically Create a DATA EXTRACTION to EXCEL Document Automatically when Saving.

Sea-Haven — Sat, 06 Feb 2021 02:01:52 GMT

Maybe Solved: Data extraction lisp - Autodesk Community - AutoCAD

NOT TESTED.

Re: Lisp To Automatically Create a DATA EXTRACTION to EXCEL Document Automatically when Saving.

Anonymous — Mon, 08 Feb 2021 08:39:32 GMT

Hello,

I have attached the DWG that we would send to Clients and the data extraction which we are currently doing Manually at the moment,

Re: Lisp To Automatically Create a DATA EXTRACTION to EXCEL Document Automatically when Saving.

Anonymous — Mon, 08 Feb 2021 09:03:08 GMT

We have looked at Lee Mac before, I will take another look to see what information is there.

Re: Lisp To Automatically Create a DATA EXTRACTION to EXCEL Document Automatically when Saving.

Sea-Haven — Tue, 09 Feb 2021 02:17:50 GMT

Post 2 not useful ?

Re: Lisp To Automatically Create a DATA EXTRACTION to EXCEL Document Automatically when Saving.

pbejse — Thu, 11 Feb 2021 12:40:59 GMT

@Anonymous wrote:

Hello,

I have attached the DWG that we would send to Clients and the data extraction which we are currently doing Manually at the moment,

I assume that these items are not direclty exported thru DATAEXTRACTION hence the request for a lisp code.

The data needed to come up with the values for this are on the blocks. but some are 0.0 or no values at all like rental rate. I guess thats the role of the "staff" to finsih it for you.

I bet its Count x [ ELECPREP_TIME / PREP_TIME / RENTAL_RATE ], but yeah, the values are 0.00 on the block

its an interesting request i give you that.