English
Deutsch
Español
Français
Hrvatski
Italiano
Polski
Türkçe
Русский
中文
日本語
한국어
Legal notice
powered by CADENAS

Manual

Top Links

Manual

3.1.  Article assignment (initial filling of LinkDB)
3.1.10. LinkDB export (Directly or via CSV file)
Prev   Next

3.1.10. LinkDB export (Directly or via CSV file)

When exporting to the LinkDB it doesn't matter whether the assignments between CSV catalog and PARTsolutions catalog have been made manually or automatically and with which template. The following explanations apply independent of the previous approach.

[Note] Note

When exporting to the link database it is only about a transfer to another data storage, in other words it's not about linking / assignment. This already happened in the process.

In an intermediate step the product data with the link information of CSV and PARTsolutions catalog can be exported in a CSV file first. Then later the CSV file can be imported into the link database.

In this section, all lines marked as "Valid" shall be exemplarily exported into a CSV file.

  1. First a process has to be created for an export.

    Under Article Assignment, click on the context menu command Add new process.

    -> Under Article Assignment, a new entry is displayed.

    -> On the right side, the dialog area Process appears.

  2. Select the new entry.

    Click on the button Open a default template . -> A list field opens.

    Click on the command LinkDB Export.

    -> The dialog box Number search options appears.

  3. Determine source and target catalog (here exemplarily "article_meta_search" and "norm") and confirm with OK.

    -> In the Process dialog area the name of the Pipeline is displayed ("Export <name of your CSV catalog>" . One by one click on the nodes and edges. Thereby the respective dialogs are displayed. The respective selection is marked in yellow.

  4. Product Map Source: In the list field, choose the source catalog (created from the CSV file).

  5. data / Assignment splitter: Optionally determine conditions for the export. You may select one or several conditions.

    You have the following options available:

    • The assignment has to have at least a quality of x%

      [Note] Note

      An export with this option set on 100% is unproblematic, because only correct assignments are exported.

    • The assignment must not be a variant

    • The assignment has to be marked as valid

      See Section 3.1.7, “ Change category to ... Valid / Invalid ”.

    • The source product must not be assigned to other targets

  6. valid: Determine the mapping between CSV fields and LinkDB fields. Furthermore determine which CSV field contains the ERP number.

    In the example in hand, under Use, activate the lines Beschreibung (Description) and Material and under Mapping, select the LinkDB variables DESCRIPTION and MAT_NAME.

  7. LinkDB store: For example, select the option Export to CSV and determine the CSV file for the export via search button ....

  8. Finally click on Run.

    In the log window, you can see the export procedure.

    • Result in CSV file

      The assignments are exported in a unique format into the CSV file, so that they can be imported into the LinkDB anytime.

    • Result in LinkDB

Prev  Up  Next
3.1.9.2. Filtering via attributes of product links  Home  3.2.  Structure/classify products