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.

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