Import pricing information to a requisition

Use the Import Requisition Pricing commands to import the pricing information that you want to use in the current requisition from a steelXML file or a Microsoft Excel worksheet. You can also import pricing from an email attachment that is either a Microsoft Excel worksheet or a steelXML file. New pricing information can be imported multiple times.

Note: If you want to reuse the imported pricing information later, you also need to update the pricing information to a pricing database.

For more information, see Update pricing information.

Import pricing information from an Excel worksheet

In the Requisition # dialog, click the Requisition ribbon tab.
On the menu, select Import Requisition Pricing > Import Pricing From Excel File.
In the Open dialog box, browse to find the worksheet from which you want to import the pricing information.
Select the worksheet, and click Open.

For sample files, see Excel Spreadsheet Sample Import Files.

You need to use the columns in the sample file. You can use the non-required columns for your own purposes.
In the Verify Excel Import Data dialog box, verify that the information is correct.

If you want to exclude information on particular rows from being imported, you can double-click the rows.
Click OK.

The Import Field Map dialog box opens. In the dialog box, the headings of the Excel worksheet need to be mapped to the Tekla PowerFab standard field headings.
If the values of an item in the Import Field and Tekla PowerFab Field columns do not match or are not correct, do the following:
1. Select the unmatched Import Field value.
2. On the right side of the dialog box, select a suitable field in the Tekla PowerFab Field list.
3. Click Set Field Mapping.
When you have mapped all fields together, click OK to continue.
In the Import dialog box, view the status of the import process.

To view the import process as a text file, you can click Open Import Log.
To close the Import dialog box, click the Close button (X) in the upper-right corner.

Import pricing information from an XML file

When you have received the steelXML results from a supplier, you can import them to Tekla PowerFab.

In the Requisition # dialog, click the Requisition ribbon tab.
On the menu, select Import Requisition Pricing > Import Pricing From steelXML File.
In the Open dialog box, browse to find the file from which you want to import the pricing information.
Select the file, and click Open.
In the Import dialog box, view the status of the import process.

To view the import process as a text file, you can click Open Import Log.
To close the Import dialog box, click the Close button (X) in the upper-right corner.

Import pricing information from an email attachment

Note: You can import pricing information from email attachments only if you are using Microsoft Outlook.

In Microsoft Outlook, select the email whose attachments you want to import.
In the Import dialog box, view the status of the import process.

To view the import process as a text file, you can click Open Import Log.
To close the Import dialog box, click the Close button (X) in the upper-right corner.