Importing from Excel or Delimited Text Files into a Folio

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

Tip: Other ReliaSoft 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 heading and maps the data to a column in the data folio.

    • If the heading displays a letter, the data in that column will not be imported.

    • If the heading displays a name, the data will be imported to the column associated with that name.

    • To remove the column mapping, click inside the column and click the corresponding button again.

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

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

    • If you enter a value that is less than the number of columns that were mapped with the Stress button, the "extra" stress column data will not be imported.

    • If the number is greater, the additional stress columns will be created in the new folio and you can enter the data later.

  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 or *.rgaim in Weibull++) 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 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.

Related Topics and Links