CAD/CAM discussion forum > CAD > Export coordinates of blocks, attribute extraction problem

Export coordinates of blocks, attribute extraction problem

Rank: 1

Menno

Newbie

posts: 10

Registered: 2013-6-4

Message 1 of 5

 Export coordinates of blocks, attribute extraction problem
27-06-2013 04:20 . pm | View his/her posts only
Hi,
I have many blocks in my drawing and now i need the x and y coordination's, preferably into excel. Is there a way to export whole layers or at least by selecting the blocks you want the coordinates of and export them to a CSV file or directly to excel?

There are plenty of these tools for autocad so i figured there should be some for ZWcad too otherwise i might write one myself since i have some coding experience but there is not much support for scripting in ZWcad.

Rank: 1

ioan

Newbie

posts: 27

Registered: 2011-7-12

Message 2 of 5

27-06-2013 06:08 . pm | View his/her posts only
try "tools>attribute extraction"
you will be able to select what to export.
it works

Rank: 1

Menno

Newbie

posts: 10

Registered: 2013-6-4

Message 3 of 5

27-06-2013 06:58 . pm | View his/her posts only
Thanks, this is looks like it's exactly what i'm looking for. But it asks a template file and the documentation is really not helping (Incorrect English too).

I tried to put this in the template:
Center X
Center Y

But it does not yield anything, i get an empty file as output. It would also be nice to extract the value of an attribute too, i named all the blocks inside the blocks attribute field.

Rank: 1

ioan

Newbie

posts: 27

Registered: 2011-7-12

Message 4 of 5

27-06-2013 07:13 . pm | View his/her posts only
you have a window (page 3 of 5), which lets you select the properties you want to export. The "Exclude general block properties" must not be selected, and you will be able to check the exact properties you want exported (X coordinate and y coordinate). after this, next and check the "exterior file" where you will select .xls, as your export exterior file format. save and that's that

1111.png
2013-6-27 19:13


Rank: 1

Menno

Newbie

posts: 10

Registered: 2013-6-4

Message 5 of 5

27-06-2013 07:27 . pm | View his/her posts only
Post Last Edit by mgouw2702 at 2013-6-27 19:56

What is the command of this? I can't find it in the UI but was able to find the command "attext". Here i do not get the option of selecting the properties of the block, just a template file.
-edit-

I found out how to make a template file:
BL:X N016004
BL:Y N016004
D C016000


I have a attribute field named "D" which exports correctly. However i get 0.000 for the first 2 lines. But in the manual they say i have to use BL:X for the insertion X coordinate. 16 characters would be enough with 4 decimals.
See also