topic Re: Adding attribute value column into block data export csv through lisp in Visual LISP, AutoLISP and General Customization Forum

Adding attribute value column into block data export csv through lisp

abdul.raufJJ89F — Fri, 03 Apr 2020 07:47:56 GMT

Hi all,

I have a lisp that export block data (block name, Rotation, Layer and co-ordinates) to CSV into the same location as of dwg. It has two options -either for all blocks or layer-wise.
So I need to add one more column for an attribute value in the CSV. The blocks will always have a single attribute tag (although block name and tag name will vary from case to case).

Please find the attached sample Image (additional column required highlighted by yellow) showing the desired result required with sample dwg.
Also, please find the attached lisp file.
Thanks

Re: Adding attribute value column into block data export csv through lisp

dlanorh — Fri, 03 Apr 2020 08:03:00 GMT

If you post a drawing saved as AutoCAD 2010 or earlier, I can update my lisp.

Re: Adding attribute value column into block data export csv through lisp

abdul.raufJJ89F — Fri, 03 Apr 2020 09:25:10 GMT

@dlanorh Please find the attached dwg in the 2010 version.

Re: Adding attribute value column into block data export csv through lisp

dlanorh — Fri, 03 Apr 2020 09:50:24 GMT

One question, does this require sorting on the contents (textstring) of the attribute? I will be busy for the next couple of hours but after that it shouldn't take more than an hour.

Re: Adding attribute value column into block data export csv through lisp

abdul.raufJJ89F — Fri, 03 Apr 2020 10:21:26 GMT

Yes I want them sorted in order from lowest to highest value

Re: Adding attribute value column into block data export csv through lisp

dlanorh — Fri, 03 Apr 2020 11:29:29 GMT

Attached is adapted lisp. Please check that this is to requirements, and if not let me know what need altering.

The current sort is by attribute string, block then layer.

Re: Adding attribute value column into block data export csv through lisp

abdul.raufJJ89F — Fri, 03 Apr 2020 14:04:57 GMT

@dlanorh

Thanks but it seems there is an issue with sorting. Here I am attaching the sample drawing in 2010 format and snap of output CSV. It sorts as T-1, T-10,T-11 rather than as T-1, T-2, T-3 etc.

Please have a look

Re: Adding attribute value column into block data export csv through lisp

dlanorh — Fri, 03 Apr 2020 15:07:55 GMT

It's not an issue, I am sorting the text as text, not number and this usually happens when you do that. That was my oversight.

I think I have something somewhere, or can find something on the forums to sort this out.

Re: Adding attribute value column into block data export csv through lisp

abdul.raufJJ89F — Fri, 03 Apr 2020 15:20:59 GMT

@dlanorh

I would like to mention that attribute value will be of either a prefix (letter) - number or simply number for all the cases.

Re: Adding attribute value column into block data export csv through lisp

dlanorh — Fri, 03 Apr 2020 16:32:04 GMT

OK. Attached is the revised lisp. This should sort properly. I have tested it in your supplied drawing by copying and adjusting the attribute text.

Re: Adding attribute value column into block data export csv through lisp

dlanorh — Fri, 03 Apr 2020 16:33:42 GMT

@abdul.raufJJ89F wrote:
@dlanorh

I would like to mention that attribute value will be of either a prefix (letter) - number or simply number for all the cases.

Is this a mix and match? If so does the prefix need to be taken into account in the sort?

Re: Adding attribute value column into block data export csv through lisp

Sea-Haven — Mon, 06 Apr 2020 04:22:37 GMT

The simplest way to fix the sort problem is t-1,t-10,t-11 etc use t-01,t-02 etc

I am pretty sure like you that this sort problem has been solved tried to find for something else I think it was one of Lee-mac's brilliant Lambda's. looks at ascii codes for numbers.

Re: Adding attribute value column into block data export csv through lisp

abdul.raufJJ89F — Wed, 08 Apr 2020 12:09:52 GMT

@dlanorh

There will be no mix cases. It will be either of two types-
a. The attribute will be of the format prefix (letter)-number
Eg- T-1, T-2,T-3,...........
AB-10, AB-20,AB-30,.............

b.The attribute will be simply a number or with a numeric prefix
Eg- 1,2,3,.........
501,502,503,..............
4-1, 4-2,4-3,................

Re: Adding attribute value column into block data export csv through lisp

dlanorh — Wed, 08 Apr 2020 15:23:40 GMT

Try the attached.

Re: Adding attribute value column into block data export csv through lisp

abdul.raufJJ89F — Thu, 09 Apr 2020 10:38:11 GMT

@dlanorh Much thanks..It is working fine!

Re: Adding attribute value column into block data export csv through lisp

dlanorh — Thu, 09 Apr 2020 11:34:06 GMT

Excellent.😁

Re: Adding attribute value column into block data export csv through lisp

abdul.raufJJ89F — Tue, 14 Apr 2020 07:02:30 GMT

@dlanorh
I hope you are doing well!
I need your additional help with this case where the block will have two attributes. I want only the second attribute value in the excel as a column (and not the first one) in this case.
Note that the second attribute has the property set as "Invisible" and here I don't require attribute data to be sorted in any specific order.

I am attaching the sample dwg (2010 version), your original blkdata lisp and the desired result image.
Thanks

Re: Adding attribute value column into block data export csv through lisp

dlanorh — Tue, 14 Apr 2020 10:33:56 GMT

Attached is modified lisp. I have renamed it CP_ID and this is also the command to run it. Also attached is produced csv file. This has also been renamed to *- CP_ID Block Data". If you want something else you can change it in the lisp.

Re: Adding attribute value column into block data export csv through lisp

abdul.raufJJ89F — Tue, 14 Apr 2020 13:13:49 GMT

@dlanorh

You are amazing. Thanks for your help.
I would like to mention that the tag name will not be constant (CP_ID) for various cases but it will be always invisible for all cases.
Just for depicting my case to you, I have randomly put "CP_ID" in the CSV column heading which I can change along with output CSV filename later on. in the lisp, as you mentioned above.
I just want to ensure that your lisp runs for any tag name.

In addition to the above-

Just one more thing I would like to ask, in future I may need to get both attributes values in the excel column.- Sequence (same as per the above sorting logic done by you) and CP_ID.I am attaching an Image depicting the format of the desired output.
You can use the above dwg attached for this one.
Thanks for the consideration!!

Re: Adding attribute value column into block data export csv through lisp

dlanorh — Tue, 14 Apr 2020 13:30:27 GMT

Will try to sort it out later this afternoon.