CSV

Reads the CSV file and writes the individual values (character strings) to the table columns in the data feed based on the specified parameters. A change of column is identified by the specified separator between the individual values.

The following parameters are available.

Parameters

Description

Source

Text file, with values that are separated by the same separator.

  • URL: HTTP address of the source file

    If another operator supplies the URL dynamically, the URL cannot be edited here.

    Example

    http://myhost.company:1080/documents/rest/links/03388871-367d-4abe-a2c9-37bc9fa44580?tenantid=default&revision=1

  • URL alias: Alias of a URL configuration. Only URL aliases for that you have the Usage privilege are available. Select a URL alias. For details, see Manage URL aliases.
  • File alias: Loads file from a resource directory. Files must be located in a defined resource directory on the MashZone NextGen server.

    Path prefix (alias): Alias of the resource directory with the path to a directory on the server. Select an alias of the local resource directory.

    In the input box, enter a path to the relevant data source file for the Path prefix (alias) selected.

    Example

    /documents/rest/links/03388871-367d-4abe-a2c9-37bc9fa44580?tenantid=default&revision=1

The file size is limited to 80 MB.

Insert parameter (Insert parameter)

Inserts user defined input parameters at the cursor position. The button is clickable only if at least one user input parameter, for example, Text user input, has been inserted in the feed definition.

For details, see URL parameter syntax.

Parameter options (Parameter options)

Enables you to set input parameter options.

Refresh rate ()

Specifies the time until the data source is read in again. Default value is 12 h.

Authentication

Specifies a HTTP basic access authentication or an existing authentication defined in the MashZone NextGen administration. User name and password are required for accessing the source file.

HTTP headers

Adds HTTP headers to the URL.

Separator

Separates the column values in the CSV file. Comma (,), semicolon (;), space, tab and pipe ((l)) are available. Default is comma.

Get column names from row

Specifies a specific row that contains the column names.

Activate the Get column names from row option and enter the number of the relevant row.

Data from row

Specifies a specific row from which the data source values extraction starts.

Advanced parsing options

Charset: Character set in which the source file is coded. The default value can be changed manually if the extracted data refers to a different coding type. Default: windows-1252.

Masking: Protects the enclosed characters against being split at the separator. If column values contain the specified separator, they can be enclosed in a pair of masking characters, for example, "1,23". Masking characters can be set as required (available masking characters: single-quote ('), double-quote ("), none).

Remove quote characters in column value: Removes the characters used for masking from the result data. If this option is deactivated the masking characters will remain as part of the result data.

Sanitize names: Transforms column names in such a way that they can be used as XML names. This affects the names containing blank spaces or other special characters. If this option is deactivated, the names are left unchanged.

Trim whitespace: Removes all leading and trailing whitespace from column values. If this option is deactivated, whitespace can be part of the result data.

Configure columns

Configures the columns list. You can unselect a column to exclude it from the result data. If you enter a new name for a column, this name is used in the result instead of the original column name. If you click Reset columns, the column list is reloaded from the data source and all changes in the list are undone.

Upload CSV files to the MashZone NextGen Repository. If required, you can upload CSV files to the MashZone NextGen Repository. For details, see Add External Resources as MashZone NextGen Files. To upload a file to the MashZone NextGen Repository administration privileges are required.

If you use an absolute URL, for example, http://myhost.company:1080/documents/rest/links/03388871-367d-4abe-a2c9-37bc9fa44580, an authentication must be set. All requests to the uploaded file are made with the specified user/password combination.

If you use a relative URL, for example, /documents/rest/links/03388871-367d-4abe-a2c9-37bc9fa44580, an authentication is not required. All requests to the uploaded file are made with the current logged in user.

In some cases, it might be necessary to grant view permission for a user. This can be done with the API console, e.g.:

{

"version":"1.1",

"sid":"PolicyService",

"svcVersion":"0.1",

"oid":"addPermissions",

"params":[

"fileName","type.entity.file","VIEW",

[{"principalId":"userID","principalTypeId":"User"}]]

}