Related Topics:

Import, Export and Data Conversion

Importing from Excel or Delimited Text Files into a Folio

In Weibull++/ALTA, RGA and DOE++, it is easy to import data from any of the following file types into a folio.

Tip: Other Synthesis applications use different tools for importing/exporting via Excel (i.e., for importing Bill of Materials data in Lambda Predict and failure mode data in Xfmea/RCM++/RBI and MPC). For more information about those features, please consult the documentation for each particular application.

First, open the project that you want to import into and choose Project > Management > Import/Export.

 or

In the wizard, choose Other file and click OK.

Browse for the file you wish to import from and click Open. Note that:

Selecting Which Data Sheets Will Be Imported

The left side of the utility displays the data from the Excel or delimited text file that is currently selected. If you wish to open a different source file, click Open.

 

If you are importing from an Excel file that has multiple worksheets, use the tabs at the bottom of the window to view and set the import preferences for each sheet.

Use the options at the top of the control panel for each sheet to specify whether the data will be imported.

Using the Control Panel to Map the Columns That Will Be Imported

If you are not using a template, or if you need to modify the settings after an import template has been applied, do the following:

  1. Use the Data Type drop-down list to specify which type of folio to import into. This can be different for each sheet, and it determines which options will be available in the rest of the control panel.

  2. Click inside each column that you wish to import and then click the corresponding button in the control panel to map it to a column in the data folio. This updates the column header and maps the data to a column in the data folio.

    As an example, the following picture shows data that will be imported into a Weibull++ standard folio. Column A will not be imported. The rest of the data has been assigned to columns that are used in the standard folios.

  3. If you are importing to an ALTA standard folio, use the Number of Stresses field to specify how many stress columns will be created in the new folio (maximum = 8). Note that:

  4. If the source file contains column headings or other introductory material that should not be imported, use the Start from Row field to specify where the actual data begins. For example, in the picture above, the first row contains heading labels so the data import should begin from Row 2.

Setting the Import Template Directory

If you will be importing data from multiple files that have the same structure, you can use saved template files (*.waim in Weibull++/ALTA or *.rgaim in RGA) to automatically map the columns for all other similar files that you need to import from.

By default, template files will be stored at C:\Users\<username>\AppData\Roaming\ReliaSoft\<application>\Import Templates. This directory determines which templates will be displayed in the Import Template drop-down list in the control panel. It also sets the default path for saving any new templates you create.

If you want to access templates from a different location, click the Import Template Directory button at the top of the window and select a different folder.

Creating a New Import Template

  1. Open a data file and use the control panel buttons to map the columns.

  2. Click the Save icon in the Import Template area on the control panel.

  3. Specify a name and click Save.

Applying a Saved Import Template

  1. Open the data file and select Import sheet to display the rest of the control panel options.

  2. Make sure the Import Template Directory is set to the folder that contains the applicable template file(s).

  3. Use the drop-down list in the Import Template area to select the template you want to apply.

    The utility will automatically assign the column mappings defined in the template. If desired, you can use the control panel to make further adjustments before import.

  4. When you are satisfied with the mapping, click Import to create the new folio.

Tip: If you make adjustments after applying the template, you have the option to click Save in the Import Template area to either replace the existing template, or create a new template with a different name.

Importing the Data

When you are ready to import the data, click the Import button.

By default, the application will import the data into a new standard folio. The status bar will display "Import into New Folio," as shown in the following example.

If you prefer to import into an existing folio instead, click the Import to Existing Folio button and choose one of the available folios. When you return to the import window, the status bar will now display the name of the selected folio, as shown in the next example.

 

© 1992-2016. ReliaSoft Corporation. ALL RIGHTS RESERVED.

E-mail Link