Created on 30 September 2014
icon_unfollowing
Login to follow
csvutil

CSVUtil

Stable version 1.11.8 (Compatible with OutSystems 11)
Other versions available for 10 and Older
Uploaded on 21 April 2023 by 
csvutil

CSVUtil

Documentation
1.11.6

Instructions for Importing or Loading


1. Create the dependencies that allow the usage of the component

This can be achieved by clicking CTRL + Q or by clicking the plug icon in the toolbar. Apply the dependencies as below.

Manage Dependencies


2. Understand the configurations



- Encode: Encode of Binary File. (Default is utf-8, see here for available encode names)

- IsSkipHeader: Whether skip first head line (Default is true)

- IsIgnoreColumnChange: Whether ignore or raise error if # of fields changed (Default is true)

- FieldDelimiter: Delimiter of the field (Default is comma, use Chr(9) for tab)

- IsDisableDoubleQuote: Disable double quote enclose/escape.(Default is true).
 Set to false ONLY IF your data DO NOT contain comma/CR/LF/double quote

- AttrFilter: Attributes that need to be loaded (Ex: EmployeeName,EmployeeFurigana)

- IsDropCommentRow: Whether drop the row that started with # (Default is true)


3. Define a List or a RecordList.

Create a variable and set is Data type as a List or RecordList


4. Create a flow to load or import the data

First thing we need is to create a server action that allow the execution of the ToObject() function, associate the configurations for the loading and be able to display the data



Now we can create the client action that will call the previous flow that we build





Instructions for Exporting


1. Create the dependencies that allow the usage of the component

This can be achieved by clicking CTRL + Q or by clicking the plug icon in the toolbar. Apply the dependencies as below.


2. Understand the configurations



- IsShowHeader: Whether export head line (Default is true).
 If CustomHeader specified,export CustomHeader as head line. Otherwise, export the name of Attributes as the headline..

- FieldDelimiter: Delimiter of the field (Default is comma, use Chr(9) for tab)

- EncodeMode: Mode of escape special characters (Default is auto)
 auto: Automatically escape if need
 quote: ALWAYS escape
 noquote: DO NOT escape but will throw exception if there are special character included
 noquote_nocheck: DO NOT escape

- Line Separator: Line separator (Default is CRLF)

- CustomHeader: Custom headline when IsShowHeader is enabled

- AttrFilter: Attributes that need to be exported (Ex: EmployeeName,EmployeeFurigana)

- Encode: Encode when exporting Binary. (Default is utf-8, see here for available encode names)

- HasBOM: BOM when exporting Binary. (Default is false, Learn more here)


3. Define a List or a RecordList.

Create a variable and set is Data type as a List or RecordList


4. Create a flow to export the data

First thing we need is to create a server action that allow the execution of the ToObject() function, associate the configurations for the exporting file




Now we can create the client action that will call the previous flow that we build





Support options
This asset is not supported by OutSystems. You may use the discussion forums to leave suggestions or obtain best-effort support from the community, including from  who created this asset.
Dependencies
CSVUtil has no dependencies.