To export results if you are using the Oracle Quality Statistics Engine:You can export to a browser as a tab-delimited ASCII file. You can then import this information into a spreadsheet, statistical analysis, or graphical presentation software package for further analysis.
If you are using the Oracle Quality statistics engine, the information that is exported is limited and varies based on which window you exporting from.
Information is always exported to a browser as a tab-delimited ASCII file and can then be imported into spreadsheet, statistical analysis, or graphical presentation software packages.
By window, the information and the order that it is exported in is as follows:
| Control Charts | For each record that satisfies the selection criteria entered, the Subgroup Number entered (X-axis collection element), and the calculated X-bar average, X-bar range, X-bar Upper Control Limit (UCL), X-bar target value, X-bar Lower Control Limit (LCL), and the calculated R-bar UCL, R-bar target value, and R-bar LCL values are exported in this order. See: Creating and Viewing Control Charts. |
Note: If you have manually specified Upper X and R Control Limits, X and R Average values, and Lower X and R Control Limit values, these values are exported instead.
| Histogram | For each selected record, the calculated values for the range and number of occurrences within that range are exported. See: Creating and Viewing Histograms. |
| Pareto Chart | For each selected record, the X and Y collection element values are exported. For example, if you are charting the defect codes and the number of items classified with those codes, only the selected and charted values for defect codes (X) and quantities (Y) and are exported. See: Creating and Viewing Pareto Charts. |
| Trend Chart | For each selected record, the X and Y collection element values are exported. For example, if you are charting annealing temperatures recorded over a period of several weeks, only the selected and charted values for X (temperatures) and Y (dates) are exported. See: Creating and Viewing Trend Charts. |
| Descriptive Statistics | Only the values for the statistical element specified for each selected record. For example, if your statistical element is item number and your selection criteria indicates all items inspected in a given date range, a list of items, which may include duplicate entries, is exported. See: Viewing Descriptive Statistics. |
| Lot Quality | Only result records that meet the lot selection criteria and the record selection criteria entered in the Find Results window are exported. Values for all collection plan elements as well as the common collection plan elements - Created By, Collection Number, and Entry Date - are included for each record. See: Viewing Quality Results by Lot Number. |
| Serial Number Quality | Only result records that meet the serial number selection criteria and the record selection criteria entered in the Find Results window are exported. Values for all collection plan elements as well as the common collection plan elements - Created By, Collection Number, and Entry Date - are included for each record. See: Viewing Quality Results by Serial Number. |
| View Quality Results | Only result records that meet the record selection criteria entered in the Find Results window are exported. Values for all collection plan elements as well as the common collection plan elements - Created By, Collection Number, and Entry Date - are included for each record. See: Viewing Quality Results |
| Quality Results ReportWriter | Only the results values that are included on the report are exported. They are exported in columnar order. See: Using the Quality Results ReportWriter. |
| Update Quality Results | Only result records that meet the record selection criteria entered in the Find Results window are exported. Values for all collection plan elements as well as the common collection plan elements - Created By, Collection Number, and Entry Date - are included for each record. See: Updating and Deleting Quality Results. |
Collect quality results. See: Data Collection Options.
Consider asking your system administrator to run the Manage Collection Element Indexes Process, if you want to enable faster searches on user-defined collection element results to export.
To export results if you are using the Oracle Quality Statistics Engine:Query results in the View Quality Results, Update Quality Results, View Quality Results by Lot Number, View Quality Results, Pareto Charts, Trend Charts, Control Charts, Histograms, or Quality Results Report Writer window.
Choose Export Results from the Tools menu.
When Quality results are exported, a web browser window opens. Depending on your browser's configuration for MIME type, the exported results may appear on your browser, a helper application may open and display the data, or you may be prompted to save the data to your local file system.
