eXpress

  Help
×
Menu
Index
Search
 
   
   
   
 
 
 

Spreadsheet Failure Effect Import

 

Feature Description

 
Failure Effects can be imported from an Excel spreadsheet using a Failure Effect data source. This is often useful for importing data from FMECA spreadsheets. The data source can be set up to import either object failure effects or design failure effects.
 

How to Create a Failure Effect Data Source

To create a Data Source for importing failure effects in the Data Source Administration dialog follow these steps:
1
Invoke the Data Source Administration dialog by selecting "Data Source Administration" from the Import submenu within the File menu.
Alternative : Press the Ctrl+D key combination.
2
Click on the "New" button (the Create Data Source dialog will appear).
Alternative: Right-click on the "Plug-In Data Sources" folder and select "New Data Source..." from the pop-up context menu.
3
Using the Create Data Source dialog, select "Spreadsheet Failure Effect Import" and click on the "OK" button.
4
Select the fields on the Failure Effect Import Data Source panel that will now appear on the Data Source Administration dialog shown below.
5
Click on the "Update Now" button to cause the import to occur.
6
If you wish to maintain an active link to the spreadsheet file (so that values are re-imported when the file changes), enable the "Update Interval" checkbox.
7
Press the "Done" button to exit the Data Source Administration dialog.
 
You can  import failure effects using an object Attribute as the Object Key Field (rather than the object name or item reference). You can also import the usage settings for each failure effect (use the new advanced options dialog to set this up).