Skip to content

CSVIM Editor

The CSVIM editor in the Eclipse Dirigible IDE allows you to open, save, delete, and edit the properties of CSV files. Such properties are:

Table

The Table input field can contain letters (a-z, A-Z), numbers (0-9), hyphens ("-"), dots ("."), underscores ("_"), and dollar signs ("$").

Schema

The Schema input field can contain letters (a-z, A-Z), numbers (0-9), hyphens ("-"), dots ("."), underscores ("_"), and dollar signs ("$").

File path

The File path input field can contain letters (a-z, A-Z), numbers (0-9), hyphens ("-"), forward slashes ("/"), dots ("."), underscores ("_"), and dollar signs ("$").

Here’s an example for a correct file path: /workspace/csv/subfolder/bigstats.csv. In this example, the file path consists of:

  • workspace

    The workspace is the place where you create and manage the artifacts of your application.

  • csv

    This is the name of your project.

  • subfolder

    This is the subfolder that contains the CSV file.

  • bigstats.csv

    This is the CSV file.

Note: If the file path is formatted properly but doesn't exist, you will be able to save the CSVIM file, but you won't be able to open it with the CSV editor. If the file path isn't formatted properly (for example, by having unsupported characters), you won’t be able to save the CSVIM file or open the CSV file.

Delimiter

The currently supported delimiters are comma (","), tab ("/t"), vertical bar ("|"), semicolon (";"), and number sign or hash ("#").

Note: If you’re trying to use an unsupported character such as "+", "The delimiter is not supported!" warning message will pop up. Nevertheless, you will be able to open the CSV file and save the CSVIM file.

unsupported_characters

Quote character

The currently supported quote characters are apostrophe ("‘"), quotation mark ("“"), and number sign or hash ("#").

Note: If you’re trying to use an unsupported character such as "^", "The quote character is not supported!" warning message will pop up. Nevertheless, you will be able to open the CSV file or save the CSVIM file.

Keys

Here you can add column names and column values by clicking Add Column Row and Add Value, respectively.

The columns and their values in the Keys field can contain letters (a-z, A-Z), numbers (0-9), hyphens ("-"), dots ("."), underscores ("_"), and dollar signs ("$").

Note: All column values and all values within a given column row must be unique. Otherwise, you won’t be allowed to save the CSVIM file.

There are three additional customization options:

If you select this checkbox, the first line of your CSV file will be treated as a column title or header.

Use header names

If you select this checkbox, the first line of the specified CSV file will be interpreted when importing the file. This option will work only if you have enabled the "Header" checkbox.

Distinguish empty from null

Select this checkbox if you want to make sure that the table-import process interprets correctly all empty values in the CSV file, which is enclosed with the value selected in the Quote character dropdown, for example, as an empty space. This ensures that an empty space is imported "as is" into the target table. If the empty space isn't interpreted correctly, it is imported as null.