Field Types Editor


The field editor enables you to act perform actions on a data source in order to:

  • View its contents.
  • Select the columns that can be used by widgets pointing to it.
  • Check the exact type of each field, e.g. date, integer, etc. and correct it manually if required so that data can be correctly processed by widgets. The automatic detection of field types may not work correctly for certain types of data sources such as REST data sources or CSV files.

Example

You want to correct the field type in a CSV file containing the yearly number of incidents handled by Service Desk employees.

Data source Field type
Automatic recognition Manual modification

Field Types Editor - Datasource example.png

Download Zip icon.png Download example (CSV file)

  • Support Member: Unrecognized type
  • 2015 / 2016 / 2017: Integer
  • Support Member: String
  • 2015 / 2016 / 2017: Integer, thousands separator None

Notes

  • For EasyVista data sources, information on field types is automatically retrieved from the Product name - ev itsm.png database.
  • By default, all of the data source columns are selected.
  • In edit mode, only the first 15 data source records are displayed. In execute mode, all of the data source records are displayed.
  • You can use different options for certain field types to narrow down the field.

Example documentation icon EN.png  

  • Integer field ==>  Specify the thousands separator
  • Date field ==>  Specify the date format

Caution

  • For CSV data sources, remember to specify delimiters for the downloaded file. This enables the field editor to read file data correctly.

Example documentation icon EN.png  In the example below, the Column Separator Character property is specified. This property identifies the delimiter in the CSV file used to separate each row of data into columns.

Not check icon.png   Incorrect configuration Check icon.png   Correct configuration

Column Separator Character: ,   (comma)

==>   The editor displays a single column (all data source columns are concatenated)

Bad configuration example.png

Column Separator Character: ;   (semicolon)

==>   The editor displays the five columns in the file

Good configuration example.png

Best Practice big icon.pngBest practice

  • You can add a field to the data source selection in two ways. Open url.png See the Screen description.
    • Select the move handle Apps - Grip icon.png of a field to move it to the relevant area in the data source.
    • Use the radio button next to each field to place it automatically in the last position in the data source.

Screen description

         Field Types Editor.png

Access: In the Properties Inspector of a data source, click the button found below the Configure Field Types property

The field editor is made up of two zones:

  • The left pane (1): List of fields available, not selected in the data source.
    • These fields cannot be displayed in widgets pointing to the data source.
       
    • Move handle Apps - Grip icon.png above the field or radio button next to the field: Used to display a field in the data source by moving it to the right pane.
       
  • The right pane (2): Preview of the selected fields in the data source and the first 15 records of the data source.
    • These fields can be displayed in widgets pointing to the data source.
       
    • Move handle Apps - Grip icon.png above the column header. Used to move the column within the table.
    • Check icon.png : Used to remove the field from the data source selection by moving it back to the left pane. You can also use its move handle Apps - Grip icon.png.
    • Apps - Edit icon.png : Used to rename the field. You can also click in the column header.
    • Type: List of field types available. A list of additional options will automatically be displayed for certain field types.

How to use the field editor

1. In the Properties Inspector of a data source, click the button found below the Configure Field Types property. The field editor will appear.

2. Select the fields you want to display in widgets pointing to the data source.

  • To display a field available in the left pane:
    • Click the radio button next to the field. It will automatically be positioned after the last data source column.
    • You can also select the move handle Apps - Grip icon.png and move the field to the relevant area in the right pane.
  • To remove a field from the data source selection in the right pane:
    • Click Check icon.png in the column header.
    • You can also select the move handle Apps - Grip icon.png and move the field to the left pane.

3. Check that the type of each field is correct in the right pane. If required, modify it using the Type drop-down list found below each column header. Specify the additional options that are automatically displayed based on the type of field.

4. Select the move handle Apps - Grip icon.png found above each column header to arrange the columns in the order you want in the right pane.

5. If you want to modify the name of a column, you can click Apps - Edit icon.png or click the column header.

6. Click [ OK ]. The field editor will close. All widgets pointing to the data source will automatically be updated.

Tags:
Last modified by Unknown User on 2017/10/10 14:00
Created by Administrator XWiki on 2017/10/10 14:00

Shortcuts

Recent Updates

Haven't been here in a while? Here's what changed recently:

-   Product name - ev itsm.png
-   Product name - ev sas.png

Interesting Content

How to Automate Integration
Add a Shortcut to an App
History
Quick Dashboard
Full text search - Stop Words

Powered by XWiki ©, EasyVista 2018