Thursday, May 1, 2008

Point Location Export To EXCEL

PURPOSE: To quickly create an application that can export point location information to EXCEL. The application should be reusable and flexible. The application must have the ability to export location information for a single point, a pattern of points (or point feature with multiple points), and/or all points in the model.

APPLICATION CREATION TIME: 1 hour

BENEFITS TO CUSTOMER: The following is a list of benefits of using this application inside Pro/ENGINEER:
  • The finished application is a plug-in to Pro/E (No custom programming or toolkit required).
  • The application's user interface is simple, functional, and easy to understand for the end user.
  • The application is accessible to all Pro/E users through the built-in library.
  • The application is very flexible and is easy to change for more potential options down the road.
  • The application can be used on any model at any point in time.
CONTACT INFORMATION: If you are interested in learning more about this application, please contact:
Kim Roemer
kim@sigmaxim.com
781.329.5235 x 301

STEPS FOR END USER:
  1. Open the model on the screen that contains the desired point(s). The image below shows a model with datum points and coordinate systems displayed.


  2. Browse your application library using the SmartAssembly pulldown or icon. The library have a structure similar to that of Windows Explorer so it is very familiar to all users. The library can contain as many applications as you want. There is no limit. Click on the EXCEL export application.


  3. The user interface for the EXCEL export application will appear on the screen. The application has an image at top describing graphically what the application does for the user. It also contains buttons for the user to select items in Pro/E (such as the datum point and/or CSYS) and a radio button that enables the user to pick one of three possible outputs (export the location of a single selected point, all locations of the pattern or point feature, or all points in the entire model).


  4. Select OK from the dialog box (or select your middle mouse button). Your data points and their locations from the selected CSYS will be exported to EXCEL. The image below shows the resultant output to EXCEL. Row 1 states that all point are measured from the selected CSYS and adds the actual coordinate system name. The second row displays the titles for the columns (Point Name, Loc X, Loc Y, and Loc Z). All remaining rows display the values for each point.