XYZ Export Function from CAD to Excel.

[Anonymous]

Hey guys. I know this may be a rookie question, but I haven’t used CAD in a few years so I’m having to relearn some of the functions.

I am trying to export our Facilities XYZ coordinates for certain points in the building along with that points value/name (the name of the point I’m getting XYZ for). Pretty straightforward.

However, each time I export the XYZ’s I only get the XYZ’s without the name/value of that point. It exports the name/value as “1”; that isn’t the name of the point.

Ultimately, how do I extract the name/value of the point with the corresponding XYZ coordinates? I am exporting every point and their XYZ, but can’t carry over the name/value of that point.

[ВeekeeCZ]

There is no such thing as a name of a point in plain acad. 

So either you have some vertical, then need to use so its tool to grab the name, or you won't be able to do that.

Better post some sample to take a look what is it.

[ChicagoLooper]

What is the label of the point name? Is the label mtext? Is it a text object? Dtext? Is it a block attribute? What is it? This is vital information and you have left it out in your explanation. Please click the label and use the description that's displayed at the top of the Properties Palette. The top of the Properties Palette will display the 'official' AutoCad term' and that term will likely determine the workflow you'll need to resolve your situation.

BTW, if the label of the point name is mtext, then you're halfway there. Getting the point's name and the x,y,z coordinates is possible if it is mtext. As long as you are willing to exert some elbow grease and physically move each individual mtext object using your mouse, can resolve your problem.

Don't be fooled. There is no way a single command that can do what your want without you exerting elbow grease, or moving each individual text label to where it needs to be and since each label's orientation varies from point-to-point, relative to its target location, each label will need to be treated on an individual basis, not by a single universal command.

With a single label selected, take a screenshot of your modelspace with the properties palette included in the screenshot. The properties palette will display the properties of the label while the screenshot will display the facilities layout.