1.1.6.3. Import Data in the Wizard (Item Number Search)

The Wizard ( Article Assignment Wizard [Article assignment wizard - article number] dialog box - article number [Article assignment wizard - article number] ) opens on the Source tabbed page.

  1. You may want to click the " Catalog Selection" button and select "articleassignmenttest".)

    You will see a preview table with 3 attributes (Catalog, Partnumber, ID) and 6 rows.

    For details, see Section 1.1.6.4.1, “Tabbed page "Source"”.

  2. Go to the Target catalog [Target catalog] tabbed page.

    Open the list box and select the " Catalog" [Catalog] checkbox, since the catalog name is located here.

    Click outside the list box to close it and accept the selection .

    -> The table now displays the catalog entries from the CSV file.

    -> The header displays the following:

    6 Products | 0 Products mapped | 0 Products selected

  3. Click the Execute Search [Execute Search] button.

    -> The catalog name from the CSV file is compared with all available catalogs (that is, all those that also appear in the PARTadmin online catalog list ).

    [Note]Note

    In the Info column, you can see which uninstalled catalogs returned matches. Check whether you want to install these catalogs now.

    For details, see Section 1.1.6.4.2, “Tabbed page "Target Catalog"”.

  4. Go to the " Article Numbers [Article numbers]" tabbed page.

  5. Select from the " Part Number" list box.

    -> The preview shows 5 rows with entries in the PSOL catalogs and Article number (CSV) columns.

  6. Select the first row (without checking the " Keep" checkbox).

  7. Click the Search button (1 selected).

    -> During the search process, a progress bar is displayed.

    -> Once the search is complete, the table displays the result for the first row.

    The " Quality " column shows that there is a 100% match. The " PSOL catalogs / Article number (CSV) " and " PSOL Result " columns confirm this in detail.

    Search type: Reverse lookup

    Keep: The checkbox was automatically selected because there is a positive search result.

  8. Select the " Only unmatched [Only unmatched]" checkbox.

    The button changes its appearance to " Search unmatched [Search unmatched]."

  9. Click the "Search [Search unmatched]" button "unmatched [Search unmatched]."

    -> After the search is complete, search results are returned for all table rows. The search may take longer, especially the first time it runs, because a user-defined index is generated.

    Clicking on a result in the " PSOL Result " column opens it in PARTdataManager.

    [Note]Note

    In the " Search type " column, you'll see the entries " Reverse lookup" [Reverse lookup] and "Sub search [Sub search]." " Reverse lookup " always returns a 100% match, while with " Sub search," the match can appear anywhere in the string.

    The checkbox in the "Keep [Keep] " column can be manually checked or unchecked, or selected using the options at the bottom in the list boxes.

    For details, see Section 1.1.6.4.3, “Tabbed page "Article Numbers"”.

  10. Go to the Export tabbed page.

  11. Deselect all rows in the Export column except for one (e.g., "Bosch").

    ( For illustrative purposes, not all rows are exported at once here.)

  12. Check the " Export selected products [Export selected products]" checkbox.

  13. Click the " Start export [Start export]" button.

    -> A status message appears.

  14. Run the export again, but this time select the options " Export all products " and " Overwrite existing product links."

    -> Now all rows will be exported.

  15. Go to the " Log" tabbed page.

    The Tabbed page "Log" [Log] contains all products from the selected CSV catalog for which no match could be found in a PSOL catalog, along with the reason for each. You can switch to this page at any time to review the information.

    For details, see Section 1.1.6.4.5, “Tabbed page "Log"”.

  16. Click the X or the Close button to close the dialog box.

    -> The " Save state? " dialog box opens.

    Enter a name and click Save.

    -> The " Reload? " dialog box opens.

    Click Yes.

    -> In the PSol Catalogs [PSol Catalogs] docking window, if the " Only show assigned classes [Only show assigned classes] " option is enabled, all catalogs for which assignments have been made are displayed.

  17. Navigate to the lowest level of a catalog.

    Here is the exported product link.

  18. Mappings Check: See Section 1.1.9, “Mappings Check”.

  19. Validating mappings: See Section 1.1.10, “Validate Mappings”.

  20. Links Export to a CSV file: See Section 1.1.11, “Links Export to CSV file”.

  21. Exporting data in a link : See Section 1.1.14, “LinkDB export (directly or via CSV file)”.