Diesel command for pile co-ordinates

[Anonymous]

Hi,

I have a pile setting out drawing where the contractor has requested the co-ordinates of the pile centres rather than the setting out dimensions.  Is there a diesel routine to enable me to select all the piles and create a list of all the co-ordinates so we can put them in a table all at once? I know you can ID each pile separately and cut and paste but this is a lengthy process, when I had full version of AUTOCAD there was a lisp routine to do this, just wondering if anyone is clever enough to do one for AutoCAD LT please? Many thanks. 

[cadffm]

I knowing nothing about a pile setting out drawing and your used cad objects.

Upload a small sample (source dwg and the wanted result xls)

[Anonymous]

Hi thanks for your reply,

basically it is about 100 small circles on a drawing that I need to get the co-ordinates for, preferably all in one go to put in to a table,

failing that, if you can click on the centre of the circle and a text box is produced next to the circle with the co-ordinates on it would suffice?

[Paul_Gander]

I would start by creating an attributed block and set the default attribute value to be a field that displays the block's insertion co-ordinates. (Field, BlockPlaceholder category, Position property.)

Then insert the block at the centre of each of your circles and regen to update the field values.

Once you have the blocks in position you can use attribute extraction to create a spreadsheet table that can be pasted or linked into your drawing.

As already requested, please post a sample drawing showing a small part of your model and the format of the information you require to be tabulated so that we can give more specific help.

Finding out if it's possible to write a diesel program to automatically insert the blocks at the circle positions will be an interesting challenge...

[Anonymous]

Hi,

thanks for your response. I've tried creating the block and it seems to work but I can't extract the info? the block is called pile and I've just tried 2 in the top right hand corner.

I've attached the drawing showing the table to the left, the easting's and northings will be the co-ordinates. 

thanks

Mandy

[cadffm · Accepted solution]

the problem now is not the extraction, it is because you don't talk about the point numbers!

When you add a third attribut with the Point number (not a stupid text near to a stupid circle or vlockreference),

then you can export Pointnumber+coordinates.

Read about ATTEXT [F1]

example:

BL:NAME C020000
MISSINGPOINTNUMBERINFO C020000
EASTING C020000
NORTHING C020000

Result.txt:

'pile','P030','E42036.291','N34882.840'
'pile','P020','E40236.291','N35403.051'

Now you can open the that file in Excel an do what you want.

Create a template for the whole table and copy cells from Excel, pastespec -> Acad objects

and you will get a real autocad table, not only loose lines and text objects.

[cadffm]

@Anonymous

[Anonymous]

Thank you very much, extremely helpful. I was on my way to creating the block with the point number on as I realised I needed that information but I was struggling with the extraction but now I've read the ATTTEXT and you sent that last message, I've created the template now and it's extracted as you said thanks.

[john.vellek]

Hi @Anonymous,

I see that you are visiting as a new member to the AutoCAD LT forum. Welcome to the Autodesk Community!

This process would be rather simple in AutoCAD but in LT it is going to be a challenge.  How do you locate the piles on your plan in the first place? Is it possible in future drawings to use blocks with attributes instead of simple circles? If so, you could use attribute extraction (ATTEXT) to gather the full list very easily.

If you would like to share a drawing sample, I could try to determine some means to do this like attaching tags with fields to each circle. This would still take some time but might be worth the effort.

Please select the Accept as Solution button if my post solves your issue or answers your question.

[Paul_Gander]

@Anonymous

This simple macro is a variation on an old favourite that will allow you to quickly insert @cadffm's block at each pile cap position using the system variable USERI1 as an incrementing counter to set the pile cap number attribute.

*^C^Cattdia 0 -insert pile \1 1 0 $m=$(substr,P000,1,$(-,4,$(strlen,$(getvar,useri1))))$(getvar,useri1);;;attdia 1 useri1 $(+,1,$(getvar,useri1))

First reset the counter by typing USERI1 1 at the command line and then start the macro. Pick each insertion point in the order that the pile caps have already been numbered.

You may want to research the CUI command if you need to learn about using macros.