1.1.  Article assignment (initial filling of the LinkDB)
1.1.3. Create catalog from CSV file
Prev  Next

1.1.3. Create catalog from CSV file

To be able to conduct assignments/links you have to create a catalog from your CSV data at first.

In the first step you read in a CSV file.

The following example uses the adjoining CSV file.

[a]

CSV data

CSV data

[a] The example file used article_meta_search.csvcan be found at "$CADENAS/training/partdatacenter/article_number_assignment".

  1. In the context menu of Workspace -> Catalogs -> Import catalog, click Import from CSV.

    Create catalog from CSV file

    Create catalog from CSV file

    [Note]Note

    You can create any number of CSV catalogs (from CSV files) and use them anytime.

    Catalogs - Directory structure

    Catalogs - Directory structure

    If you want to remove a catalog again, you will find the Remove catalog command in the context menu.

    The removal is first carried out locally. As long as no commit has been executed, you can undo [Revert changes] the deletion with Undo changes [Revert changes]. If a commit has already been executed, use the Restore removed catalogs command.

  2. CSV file selection

    Select the desired CSV file by clicking on the Browse ... button.

    Determine the data type: Fixed column width or separated by comma for example

    Determine CSV file

    Determine CSV file

  3. Specify data encoding

    Specify the column separator and optionally a text separator.

    Determine the column separator

    Determine the column separator

  4. Column names

    If the first line of the CSV file contains column names, activate the checkbox under Column names can be found in the first line [First line contains column names].

    Column names in first line: Yes/No

    Column names in first line: Yes/No

  5. Document selection (optional)

    If the CSV file contains paths to geometries and preview images you can optionally choose the respective column name in the list field.

    Document selection (optional)

    Document selection (optional)

  6. Language and Identifier selection

    Determine the language and identifier. As the ident number is absolutely unique, please select this as the identifier.

    Language and Identifier selection

    Language and Identifier selection

    Finally, confirm by clicking on Done [Finish].

  7. If the import of the CSV file is successful you can see 100% in the progress bar and "Finished" is displayed.

    Progress bar 100% - Finished

    Progress bar 100% - Finished

    Close the dialog box.

  8. Under Workspace -> Catalogs -> CSV catalog name (self-assigned, in this example "article_meta_search") -> Products, all data records in the CSV file are now displayed.

    Products " dialog page

    Products " dialog page

  9. Optional: If you are not working locally, you can now commit your local changes.

    Before committing the single items show a blue plus sign.

    Before Commit

    Before Commit

    After committing the single items show a green checkmark.

    After Commit

    After Commit

Prev Up Next
1.1.2. User interface and processes at a glance Home 1.1.4. Manual assignment