powered by CADENAS

Manual

Manual

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 used sample file article_meta_search.csv can be found under "$CADENAS/training/partdatacenter/article_number_assignment".

  1. In the context menu of Workspace -> Catalogs -> Import catalog, click on 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 use the context menu command Remove catalog.

    The removing is performed only locally first. As long as no commit has been performed you can undo the removing by clicking on Revert changes. If a commit has already been performed use the context menu command Restore removed catalogs.

  2. CSV file selection

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

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

    Determine CSV file

    Determine CSV file

  3. Specify data encoding

    Determine the column separator and optionally a quotation symbol.

    Determine the column separator

    Determine the column separator

  4. Column names

    If the first line of the CSV file contains the column's caption activate the checkbox under First line contains column names.

    Column names in first line: Yes/No

    Column names in first line: Yes/No

  5. Document selection (optionally)

    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 Language and Identifier. Since the Ident number is absolutely unique please select it as identifier.

    Language and Identifier selection

    Language and Identifier selection

    Finally confirm by clicking on 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 (in the example in hand "article_meta_search") -> Products all datasets of the CSV file are displayed now.

    Dialog "Products"

    Dialog "Products"

  9. Optionally: If you are not working locally, you can commit the local changes now.

    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