Options

The CSV importer offers various settings and options, which will be explained below.

Please also read the general information before importing data with the CSV importer.

Import Settings

After uploading a file in the "CSV File" field, the following settings are available:

OPTION
DESCRIPTION

CSV File

First click on this button to select a CSV file for the import. Via the "X" you can remove the file again.

CSV Field Names

Select the row where the column names are located so that they are not imported as records.

Target Field Names

Object Type

Select the object type you want to import the data into.

Pool

Select the pool in which the new records should be created. The pool is set only when records are inserted. If existing records are updated via the CSV importer, the pool will not be changed. For this purpose, please use the group editor.

Mask

Select the mask which should be used for the import.

File Upload Method

Select a method for uploading files. For more details please check the file upload example.

Direct: The file is downloaded and then uploaded with /eas/put.

URL (Remote PUT): The file is not downloaded and /eas/put is accessed directly from the file URL. The file is downloaded from the server and uploaded. (This option is the fastest).

Ignore Files: All files will be ignored and not imported.

Metadata Mapping

Select the metadata mapping that should be applied when importing files.

Tag Mode

Select whether tags from the CSV file should be added to existing tags or should replace existing ones when updating records.

Field for Updates

By selecting the default entry "- Insert New -" all rows of the CSV file will be created as new records in FYLR. Select a field here to identify existing records and update them with the contents from the CSV file. Please note that you must first select fields in the "Import Mapping" tab so that they are available in this pulldown. Select the file field if you have file names in your CSV and want to update records using the file name. In case of multilingual fields you have then the possibility to make the matching over a certain language (e.g. name#de-DE or name#en-US).

Append Records in Nested Fields

By default, when updating existing records in FYLR, all records in nested fields (i.e. keywords) are replaced by the content from the CSV file. With this option, in case of nested fields, the content from the CSV file will be appended to the existing records instead. Use this option, for example, to add keywords in addition to those already assigned to the record.

Append Records in Reverse Nested Fields

By default, when updating existing records in FYLR, all records in reverse nested fields (i.e. images) are replaced by the content from the CSV file. With this option, in case of reverse nested fields, the content from the CSV file will be appended to the existing records instead. Use this option, for example, to add images in addition to those already assigned to the record.

Create Linked Records

Specify whether linked records should be created during the actual import or not. If this option is switched off, all linked records must already exist in FYLR. If you click on "Prepare", a corresponding message will appear if the CSV file refers to records that could not be found in FYLR.

Pool for Linked Records

This option only appears if the selected object type refers to another object type for which pool management is also activated. This means that different pools can be specified for linked records.

Comment

Enter a comment for the CSV import, which will appear in the change history of the imported / updated records.

Chunk Size

Size of the processing chunks that are sent to the server. In case of very complex data models and data volumes, a timeout may occur. In this case, try using a smaller chunk size.

Show Display Names

If activated, the second tab "Import Mapping" for the FYLR fields will show the display names from the editor/detail. Otherwise the internal field names from the data model are used.

Overview

Below the import settings, an import overview is displayed after preparing. The checkboxes are used to filter the entries in the table view.

NAME
DESCRIPTION

Rows

Number of rows in the CSV file.

Ready

Number of rows ready to import.

Invalid

Number of rows that are invalid.

Processing

Number of rows that are currently being processed.

Done

Number of rows that have been finished.

Errors

Number of rows with errors.

Warnings

Number of rows that can be imported but for which there is a warning.

Inserts

Number of rows / records that would be inserted.

Updates

Number of rows / records that would be updated.

Deletes

Import Mapping

Fields for which no mapping has been selected will not be changed when updating records that already exist in FYLR. Fields for which a mapping has been selected, but for which there is no content in the CSV file, will be emptied when updating records.

Table View

In the table view you can see the data from your CSV file. After preparing and importing, additional information is automatically added (recognizable by the column names "fylr|"). What information this is, you can read at the end of this article in the "Protocol" section.

Record Preview

In the "Record Preview" tab you can see the data that would be imported according to the import mapping. Please note that this is only a preview of the mapped fields. When updating already existing records the result may differ.

JSON Preview

In the "JSON Preview" tab you can see the data that would be imported according to the import mapping in the JSON structure.

Options

The lower part of the CSV importer contains the following functions:

BUTTON
DESCRIPTION

Reload

Reloads the CSV file and discards any information already loaded by preparing it.

Download CSV

When preparing and after saving, more information is generated, which is written back to your CSV file (see table below). With "Download CSV" you can save this file to your desktop.

Download Import Settings

Download the configured import settings and the import mapping as a JSON file.

Upload Import Settings

Upload the JSON file with the import settings and import mapping.

Prepare

Prepares the CSV import. This includes checking the data, as well as searching for existing and linked records.

Insert

Starts the actual CSV import and inserts all new records. Already existing records will not be updated.

Update

Starts the actual CSV import and updates existing records. Not yet existing records will not be created. Note, however, that empty columns in the CSV will cause the update to empty the contents of these fields in the records.

Insert & Update

Performs both inserts and updates directly one after the other.

Protocol

After preparing and after importing certain information is generated by FYLR. These can be seen in the table view in the CSV importer or can be downloaded as a CSV file after the import.

ROW
DESCRIPTION

fylr|row_idx

Number of the row, starting with 0

fylr|operation

Action that will be performed ("insert", "update", "delete")

fylr|status

Import status ("ready", "invalid", "failed", "done"). Rows with status "invalid" cannot be imported (example: wrong date format). Rows with the status "failed" were not imported correctly (example: mandatory field violation).

fylr|timestamp

Date + time when the import/update/deletion of the CSV import

fylr|status_text

Contains further information about the error that occurred in the case of the status "invalid" and "failed"

fylr|warning_text

Contains more information in case of trying to import invalid JSON into custom data type fields

fylr|id

ID of the record found in FYLR (for records created by CSV import this column remains empty)

fylr|version

Version of the record

fylr|id_parent

ID of the parent entry (only for hierarchical object types)

fylr|depth

Depth of the record (only for hierarchical object types), starting with 0

fylr|path

Path of the record (only for hierarchical object types)

fylr|eas_ids|file

Contains the internal EAS id of the file uploaded via the CSV importer (see Upload files).

fylr|eas_ids|file|metadata

Contains the metadata taken from the file uploaded via the CSV importer (see Upload files).

fylr|object type|mask

For all linked object types a separate column is generated. After preparing you can see whether the entries referred to already existed (an ID is displayed for them), whether they are newly created (they appear with "new") or, if the option "Create linked entries" is deactivated, whether they were not found (they appear with "searching").

Last updated