point coordinates to excell
point coordinates to excell
(OP)
hi all,
We have been modelling pipes using polyline routing through coordinate points and then using this polyline to Rib feature.While drafting we are supposed to supply this point data so it can be fed to cnc machine to get the required pipe. Therefore we need to put the point data in table and the table is insereted to detail drawing of that particular pipe.So, do any of you guys know any work around so that i can get these point coordinate in table format into drawing directly without creating table seperately and inserting in the drawing so that we can reduce the time?
Thanks in advance
We have been modelling pipes using polyline routing through coordinate points and then using this polyline to Rib feature.While drafting we are supposed to supply this point data so it can be fed to cnc machine to get the required pipe. Therefore we need to put the point data in table and the table is insereted to detail drawing of that particular pipe.So, do any of you guys know any work around so that i can get these point coordinate in table format into drawing directly without creating table seperately and inserting in the drawing so that we can reduce the time?
Thanks in advance





RE: point coordinates to excell
Noted that our tubing guys have a macro for that so they even get the bend radius in the table, but that macro is obfuscated so I don't know how they did it.
RE: point coordinates to excell
Anyway if you need a script look in the FAQ... you'll find something that extract XYZ of point to a text file.
The Text file can be turned into a CSV file with Excel then imported in a CATDrawing...
indocti discant et ament meminisse periti
RE: point coordinates to excell
thanks for the reply, could you please elaborate your point a little bit more, probably with an example
thanks in advance
RE: point coordinates to excell
2 - Create a drawing view
3 - Check properties of the view so that points are generated
4 - Multiselect the points in that order you want the points to be ordered in the table
5 - Activate point coordinate table feature (hidden with the dimensioning features)
6 - In the new window chose which coordinate system the coordinates should be based on (if multiple axis systems exists)
7 - Place table in view
Note that if you create points on the fly with polyline then the feature carries the points, in that case you need to expand the polyline feature and make those points visible
RE: point coordinates to excell
azreal thanks for the reply,
Can you please tell me how can i make the points visible int the drawing view
RE: point coordinates to excell
RE: point coordinates to excell
sorry azreal
another question, the command is in passive mode how can i make it active
thanks in advance
RE: point coordinates to excell
RE: point coordinates to excell
It works, You reduced our time in doing that
once again thanks