You are viewing the documentation for Blueriq 17. Documentation for other versions is available in our documentation directory.
Resource
A resource either holds a reference to an external CSV file or the data of an imported CSV file itself. Imported data is read-only.
Property | Description |
---|---|
(Resource) type | Currently, Blueriq only supports resources of type CSV. |
Is external | The resource can be an external text file located on the server or internal data from the imported text file.
|
Field separation | If the items in the text file are separated by tabs, colons, semicolons, spaces, or other characters, select Delimited. If in every column all items are of the same length, select Fixed width. |
Delimiter (not available if field separation is Fixed width) | elect the character that separates values in your text file. If the character is not listed, select Other and enter the character. (These options are not available if field separation is Fixed width.) |
Number of columns (not available if field separation is Delimited) | Enter the number of columns and for each column the number of characters defining the width. |
File has column names on first row | Select File has column names on first row, if the first row in the text file contains headers. |
Text qualifier | Select the character that encloses values in your text file. When Blueriq Encore encounters the text qualifier character, all of the text that follows that character and precedes the next occurrence of that character is imported as one value, even if the text contains a delimiter character. For example, if the delimiter is a comma (,) and the text qualifier is a quotation mark (”), “Broccoli, beans or tomatoes” is imported into one cell as “Broccoli, beans or tomatoes”. If no character or the apostrophe (') is specified as the text qualifier, “Broccoli, beans or tomatoes” is imported into two adjacent cells as “Broccoli” and “beans or tomatoes”. |
Charset | Tha characer set that is used. |
(Data) type | Select the base type for each column. |
Format | If the data in your text file is not formatted according to the Blueriq formats, you should specify how Blueriq should convert the data. You can do so by specifying conversion formats per column. If the data in your file is formatted correctly, you can leave the format fields empty. |