{"id":16786,"date":"2016-11-21T00:04:15","date_gmt":"2016-11-21T00:04:15","guid":{"rendered":"http:\/\/www.safetyangel.com\/recdev\/?page_id=16786"},"modified":"2016-11-21T00:19:32","modified_gmt":"2016-11-21T00:19:32","slug":"example-1-importing-system-configuration-data-from-an-external-bill-of-materials-file-bom","status":"publish","type":"page","link":"http:\/\/www.safetyangel.com\/recdev\/example-1-importing-system-configuration-data-from-an-external-bill-of-materials-file-bom\/","title":{"rendered":"Example 1 – Importing System Configuration Data from an External “Bill of Materials” File (BOM)"},"content":{"rendered":"
\r\n

Example 1 - Importing System Configuration Data from an External 'Bill of Materials' File (BOM)<\/h2><\/div><\/div><\/div><\/div><\/div>
<\/div><\/div>
<\/div>
\n

Examples provided here are purely for illustrating software features and functionality.<\/span><\/h3>\n<\/div><\/div><\/div><\/div><\/div><\/div><\/div>
<\/div>
\n

Example 1 – Importing System Configuration Data from an External “Bill of Materials” File (BOM)<\/span><\/h3>\n

Download Example BOM File DR Thermostat BOM (*.xls)<\/a><\/b><\/p>\n

Background<\/span><\/h3>\n

There are times when you have external data that you need to analyze in Lambda Predict. This example will guide you through the basic techniques for importing system configuration data from an external “bill of materials” file (BOM) into Lambda Predict. In this case, the BOM data is in an Excel\u00ae file.<\/p>\n

Note that the sample BOM file in this example\u00a0was designed for the Telcordia SR-332\u00a0Issue 2 standard. If that standard is not included in your software license you can use any other standard available to you, but keep in mind that only the first eight data fields in the file can be mapped correctly. The rest of the fields may not have appropriate matches in the standard you are working with.<\/i><\/p>\n

Create an Import Template<\/span><\/h3>\n

Before you start the import process, you must first create an import template. Import templates help you match the parts data in your BOM file to the properties in the prediction standard you are working with, so that your data are imported into the correct fields. In this example, you will use the automatic mapping process to create an import template. Follow these steps:<\/p>\n<\/div><\/div>

\n

Step 1:<\/b> First, examine the sample BOM file and take note of the name of the Excel worksheet that contains the data and the row number where the column header names are stored.<\/p>\n

Step 2: <\/b>Create an import template by choosing Home > Templates > Import Templates<\/b>.<\/p>\n

<\/p>\n

In the Import Templates window, choose the Telcordia SR-332 Issue 2<\/b> prediction standard (or any other standard that is available to you if the Bellcore\/Telcordia standards are not included in your software license).<\/p>\n<\/div>

\"\"\/<\/div><\/div><\/div>
<\/div><\/div><\/div><\/div><\/div><\/div>
<\/div>
\n

Step 3<\/b>: Click the Automatic Mapping<\/b> icon. In the Automatic Mapping window, click the Browse<\/b> button to search for the sample BOM file you downloaded, and then use the information from Step 1 to populate the Worksheet and Column Header Row fields, as shown in the following example. Click OK<\/b>.<\/p>\n<\/div>

\"\"\/<\/div><\/div>
\n

Step 4<\/b>: Lambda Predict will attempt to match the column header names found in the Excel file to the fields used in the selected prediction standard. The results will be displayed in the Selected Fields<\/b> area. Any column header names that do not have a match will be displayed in red text with an Info icon next to it.<\/p>\n<\/div>

\"\"\/<\/div><\/div>
\n

Click OK<\/b> to create the prediction folio. Because you specified that you will be importing the system configuration data from a BOM file, the Import BOM Wizard will appear automatically once the folio is created.<\/p>\n

Step 8:<\/b> In the Import BOM Wizard, enter the following information:<\/p>\n

    \n
  • In the Import Template<\/b> field, click the drop-down arrow to select the import template that you created in the first part of this example or the (…<\/b>) icon to search for the template.<\/li>\n
  • In the File Type<\/b> field, choose Excel<\/b>.<\/li>\n
  • In the Source File<\/b> field, click Browse<\/b> to search for the sample BOM file that you downloaded.<\/li>\n
  • In the Worksheet<\/b> field, choose the Excel worksheet that contains the data, and in the Starting Row<\/b> field, enter the row number where the actual data starts.<\/li>\n
  • In the Import Options<\/b> area, select the Import as new<\/b> option.<\/li>\n<\/ul>\n<\/div><\/div>
    For example, the following picture shows a template where the column name “technology” is not recognized. To fix this, click and drag the corresponding field name from the Available Fields<\/b> area (in this case, “Technology IC”) and drop it on top of the unrecognized column name to create a match; otherwise, the data in the “technology” column will be excluded from the import process.<\/div>
    \"\"\/<\/div><\/div>
    \n

    Import the BOM Data<\/span><\/h3>\n

    Once you have created the required import template, follow these steps to import the sample BOM data into Lambda Predict:<\/p>\n

    Step 6<\/b>: Create a prediction folio by choosing Insert > Project Item > Prediction Folio<\/b>.<\/p>\n

    <\/p>\n

    Step 7<\/b>: In the setup window, type a name for the folio in the Name<\/b> field, then select the Import bill of materials (BOM)<\/b> option and choose the prediction standard you will be working, as shown in the following example.<\/p>\n<\/div>

    \"\"\/<\/div><\/div><\/div>
    <\/div><\/div><\/div><\/div><\/div><\/div>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"fullwidth.php","meta":{"footnotes":""},"class_list":["post-16786","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"http:\/\/www.safetyangel.com\/recdev\/wp-json\/wp\/v2\/pages\/16786","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.safetyangel.com\/recdev\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"http:\/\/www.safetyangel.com\/recdev\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"http:\/\/www.safetyangel.com\/recdev\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.safetyangel.com\/recdev\/wp-json\/wp\/v2\/comments?post=16786"}],"version-history":[{"count":4,"href":"http:\/\/www.safetyangel.com\/recdev\/wp-json\/wp\/v2\/pages\/16786\/revisions"}],"predecessor-version":[{"id":16795,"href":"http:\/\/www.safetyangel.com\/recdev\/wp-json\/wp\/v2\/pages\/16786\/revisions\/16795"}],"wp:attachment":[{"href":"http:\/\/www.safetyangel.com\/recdev\/wp-json\/wp\/v2\/media?parent=16786"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}