cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - You can change your system assigned username to something more personal in your community settings. X

summary: Analysis Feature Export

JWayman
1-Newbie

summary: Analysis Feature Export

Original Question:
>>
I have 4 patterns of points along 4 different curves. I have been asked to
provide the coordinates of each point relative to a master coordinate
system.
I have tried an analysis feature, which gives me distance_x, distance_y and
distance_z for a given point on a given curve. I can reference pattern these
analysis features along the curve.
However, I want to use these distance values in a spreadsheet, so I need to
export them, as a text file, or as an excel file.
Now, if I click on each analysis feature in the model tree, right click,
model parameters, file, export, save, I can create a separate text file for
each of the 115 analysis features. I can then open each text file separately
and copy and paste the values into a single text file.
However, life is too short.

115 sets of 3 measurements...
An awful lot of clicks.

Is there a cunning way I can select a number of datum points and extract
their coordinates into another application? I'm hoping for a 'Yes' answer
here.<<

Thank you all for the replies. I never expected it to be possible in so many
different ways...

I have not tried this specific exercise, but would it be possible to set up
a repeat region in a Pro.REPORT table with cells populated by the values
from your analysis features? If you can do that, you can export that table
out as either text or spreadsheet. Might be worth trying.

See if the steps in the attached document will work for you.  This process
still requires a few steps, but far fewer than what you have mentioned.




If you don't have an answer yet here are 3 methods from PTC.

1) Select #Interface, #Export, #IGES, #Dtm Crv/Pnt to create an IGES

file, then create a datum

point array by selecting #Feature, #Create, #Datum,

#Point, #Offset Csys, select a

reference coordinate system, select the coordinate type

(eg Cartesion), #Read Points,

enter the IGES (.igs) file name previously created, and

#Done. Lastly, create the

desired column XYZ output by selecting #Feature,

#Redefine, select the datum point

array just created, #Done, and #Output.

2) Select #Info, #Measure, #Distance and manually pick points.

The coordinates are written

to the Message Window and trail file.

3) Create the IGES file as noted in technique 1 and search the

IGES file for datum

point entity types, type 116 where the coordinates can

be extracted.



How about adding the parameters to the family table, then exporting the
family table to excel?  You may even be able to use the find command to add
the analysis parameters to the family table quickly.

you may write model relations to switch the feature parameters from your
analysis features to model parameters:
e.g. X1=measure:FID_fid

where "X1" is your new model parameter, "measure" is the name of the
parameter you created with (inside) your analysis feature, "fid" is the
feature ID of your analysis feature

When you have created those relations for all your parameters go to "Tools"
==> "Parameters" and voila ... you see all your parameters.
You can export the parameters as "CSV" file and then easily import in Excel
...

You can export the part to STEP and only tickmark Datum Curves and Points.
Select your coordinatesystem as Reference.
Open the STEP file in an editor. All your point will be listed like this in
the file:
#131=CARTESIAN_POINT('PNT0',(8.715917277576E1,0.E0,-7.155869827115E1));
#133=CARTESIAN_POINT('PNT1',(0.E0,0.E0,-7.834151327316E1));
#134=CARTESIAN_POINT('PNT2',(-6.477588326915E1,0.E0,-5.663650526674E1));

With a little editing (search and replace) this can be transformed to a csv
format for Excel Import.




I used the method described in the attached file and I am glad to say it
worked very well indeed.



Thanks again, all


This thread is inactive and closed by the PTC Community Management Team. If you would like to provide a reply and re-open this thread, please notify the moderator and reference the thread. You may also use "Start a topic" button to ask a new question. Please be sure to include what version of the PTC product you are using so another community member knowledgeable about your version may be able to assist.
2 REPLIES 2

Hey John
I have to throw my 2 cents in...
I have a way that uses the Hole Table function in Drawing mode. I like it because I don't have to think much!

Give this a shot!

If you have points on a curve you can create a point table on a drawing and export the table to excel. This saves all the exporting to IGES steps required by other methods and also updates quickly as the points change.
This requires a coordinate system as the 0,0,0 point for the table.

Pro has a tendency to list by the first number it reaches in a name, I.E. PNT1, PNT10, PNT11, PNT12... PNT2,PNT20,PNT21... PNT3, PNT30,PNT31 and so forth. So it helps to change the names of the points to help keep track of where you are. Before I create the points, I rename the first point to PNT100 , all subsequent points will follow in the correct order. If you have more than 999 points, you might want to start with PNT1000.
1. Start a drawing and place the first view such that the coordinate system is oriented with "X" increasing to the right, "Y" increasing up, and "Z" comes out of the page at you.
2. Go to the TOOLS pull down
3. HOLE TABLE
4. CREATE
5. DATUM POINTS
6. (Read the dashboard) - Select the coordinate system (I use the model tree)
7. Select top left corner of table
8. the table will build showing all the points in the part.
9. Highlight the table
10. TABLE
11. SAVE THE TABLE
12. AS CSV FILE
13. Pro will add a number to the end of the export file name that must be removed.
(I.E. test-point.csv.1 needs to be test-point.csv)
14. import the file into Excel. Use comma delimiters.
Now all you have to do is regenerate the drawing and export the table each time the points change.

Martin T. Brown
Design Specialist
Merrick & Company
Direct: 865-241-4642
www.merrick.com

Hello Martin,

I use your method and have multiple models with tables in 1 drawing sheet.

For some reason the table gets disconnected from the 3D model and doesn't update.

Do you know restrictions for the described method?

Top Tags