How to import parameter items

How to import parameter items

Summary

This article explains how to import parameter items into a product by using the Product Designer Import Wizard.

More Information

In order to import parameter items you must first create the import file. This file needs to be created with a specific format:

  • It must be a tab-delimited file
  • Each parameter item must be on a separate line
  • Each line should have the following data (delimited by tabs): Parameter name, List value, Width, Height, Number and Text.

The easiest way to create a import file is with Microsoft Excel. Put the data in the columns on the spreadsheet and then save the spreadsheet as a text file (tab delimited).

The following steps will demonstrate how to create and import a sample Width Allowance parameter list.

Creating the sample file

  1. Run Microsoft Excel
  2. Enter the following text in cells A1 and A2: Width Allowance
  3. Enter the following text in the cell B1: IB
  4. Enter the following text in the cell B2: OB
  5. Enter 0 for cells C1, C2, D1 and D2
  6. Enter 0.125 for cell E1 and 0 for E2
  7. Choose File, Save As and save the file with a type: Text (Tab delimited).

Create the Parameter List

  1. Run Product Designer.
  2. Open the product you want to import the data into.
  3. From the View menu click Parameters.
  4. Enter a new row, using "Width Allowance" for the parameter name. Click off the row to make sure it gets added.
  5. Close the Parameters window.

Import the file

  1. In Product Designer, click Import from the File menu.
  2. From the list, choose Parameter Items.
  3. Click the Browse button and select the text file you created.
  4. Click the Import button.
  5. From the View menu click Parameters.
  6. Double-click on the parameter Width Allowance.

APPLIES TO

  • Product Designer 4.2

    • Related Articles

    • How to import list items

      Summary This article explains how to import list values into a product by using the Product Designer Import Wizard. More Information In order to import list values you must first create the import file. This file needs to be created with a specific ...
    • How to Export/Import Customers in 4.2

      Summary This knowledge base article will outline the process of using the Export Utility to export data from a 4.2 database, then using the Import Utility to import the data back in. Instructions 1 – In your File Explorer (The little manilla folder) ...
    • How to Import a Price Chart from Excel

      Summary  This article will explain how to take a price chart from an excel spreadsheet and import it into the Product Designer 5 software A - Locate the chart on your Excel spreadsheet.     1 - Remove all $ signs, inch marks (“), and commas.     2 - ...
    • How to reorder line items in Solatech Focus

      Summary Solatech Focus gives users the ability to easily reorder line items on a quote - even if those lines are not shown on the same page of the Quote Review screen.  This article describes the process of reordering line items. Reordering items on ...
    • Line items are not sorted correctly in Order Entry

      Summary This article explains why line items in Order Entry may not sorted by the line number. More Information It is possible to sort the line items in Order Entry by any of the visible columns. If you have sorted by the description column, or any ...