Files


Appending HTML Lines Using String Builder

Appending HTML Lines using a String Builder Step requires a few steps to get the data from the database and then select the information needed to Append an HTML line into Text. The String Builder Steps...

Create Excel Data from Object Data

Data objects can be exported to CSV format within a flow by using the Custom Merge [NVelocity] and Create Text File components. Part 1 of this example will first show how to create data for an Excel...

Writing a File to the Local File System

The Create Text File component saves a plain text file to the local file system. Add it to a flow in the Flow Designer. In the Toolbox panel, under the category Integration > File, drag a Create Text File component to the workspace.

Upload File with FTP

File Transfer Protocol (FTP) is a secure method to transfer files across a network. Some FTP servers allow an anonymous connection, but many require that you enter the user name and password for the FTP server when connecting. Use a flow to upload a file to an FTP server, using the authentication information you specify.

Allow Runtime CSS File Name

This tutorial demonstrates how to allow different CSS documents at runtime on the Form. This feature is implemented in Decisions 4.0. With this feature we can style our Forms dynamically at runtime. Example: In...

Loading an Excel File into a Flow

The Import Excel or CSV flow component loads tabular data from CSV or Excel-formatted files. The function of this step is to import an excel or csv file into a data type.

Converting an Excel File to CSV

The Convert Excel to Csv component converts Excel-formatted tabular data to CSV format. To use the Convert Excel to Csv component in the Flow Designer, drag it to the workspace from the Components panel's Data > List > Excel and CSV category.

Using For Each Excel Or CSV Row Step

This tutorial demonstrates how to use For Each Excel Or CSV Row step. This step can be found in Data > List > Excel and CSV category in the ToolBox. Example: In this example we are going to create...

Edit And Update Excel Document

This tutorial demonstrates how to use specific Steps in the Flow Designer to get values from an Excel Document, and how to Update values in the Excel Document (Set Values, Replace Values, Delete Row, etc.)...

Converting CSV to an Excel File

The Convert Csv to Excel component converts CSV tabular data to the Excel format. To use the Convert Csv to Excel component in the Flow Designer, drag it to the workspace from the Toolbox panel's Data > List > Excel and CSV category.

Creating And Styling Excel Document

This tutorial demonstrates how to Create an Excel Document in the Flow. Additionally, this tutorial demonstrates how to apply different Styles to this Excel Document. Create New Excel File step can be...

Splitting Excel Columns by a Custom Delimiter

Using the Split Excel Column component in a flow, the data in an Excel spreadsheet's column that is separated by a delimiter can be split into several columns and then displayed in a data grid or converted into a CSV file.

Fetching Data From Database to CSV File

Overview Database entities represent external databases which can be integrated with a flow and then displayed on a CSV file. In this example, we are going to fetch data from the database into a CSV file....

CSV To Object Mapping Step

This tutorial demonstrates how to use CSV To Object Mapping step. This step can be found in Data > List > Excel and CSV category in the ToolBox. Example: In this Example we are going to...

Editing CSV Records in a Form

The CSV Editor form component allows for the editing of CSV-formatted tabular data, such as a spreadsheet.

CSV To List Mapping Step

This tutorial demonstrates how to convert data from Excel Document to a Simple List of Strings using CSV To List Mapping step from Integration > Excel and CSV category in the ToolBox. Example: We...

Using Run Flow For CSV Step

This tutorial shows how to use Run Flow For CSV step. This step can be found in Data > List > Excel and CSV category in the ToolBox. Example: In this Example we will use Run Flow For CSV...

Using Split Excel Column Step

Using the Split Excel Column component in a Flow, the data in an Excel spreadsheet’s column that is separated by a delimiter can be split into several columns and then displayed in a data grid or converted...

Filling in PDF Forms Using Flow

The Set PDF Form Fields component in a flow can populate a PDF form template with data. When used in a flow, this step reads a PDF form template to identify its fields, then provides input fields for...

Turning RichText/HTML into PDF

The HTML to PDF component in a flow can convert text to PDF format. When used in a flow, this step reads in an HTML or text file, then converts it to PDF. This step does not actually create the file; it...

Retrieving and Processing PDF Form Fields in a Flow

Overview PDF form field values can be extracted and used as variables in a flow using the Get PDF Form Fields component. This component is found in the Toolbox panel under the Data > PDF category. Example In...

Reading Text Files from a File System

The Read Text File component reads and outputs the contents of a file as plain text. Add it to a flow in the Flow Designer, in the Toolbox panel, by expanding the category Integration > File and dragging a Read Text File component to the workspace.

Listing Files in a File System

The List Files in Directory component creates a list of filenames for a given directory. Create a flow to list the files in the Flow Designer. In the Toolbox panel, under the category Integration > File, drag a List Files in Directory component to the workspace.

HTML to Word Document Step

This tutorial shows how to use Html To Word Document step. This step can be found under Data > Html category in the ToolBox in the Flow Designer. This step can be used to convert Html Document into...

Appending Word Documents

Overview This tutorial demonstrates how to append Word documents by using a Combine multiple Word documents Step within a Flow. Example Begin in a designer Folders and Create a Flow. Name your...

Unit Testing (Advanced)

Unit Tests can be used using various techniques within Decisions designer studio. Unit Test's can be created using a flow and a rule to test data as it passes through. Advanced Unit Test's have advantages...

Download File with SFTP

Secure File Transfer Protocol (SFTP) is a secure method of transfering files across a network. You can use a flow to download a file from an SFTP server with the proper authentication information. To...

Download File with FTP

File Transfer Protocol (FTP) is a secure method to transfer files across a network. Some FTP servers allow an anonymous connection, but many require that you enter the user name and password for the FTP server when connecting. Use a flow to download a file from an FTP server, using the authentication information you specify.

Creating a File Watcher Event

A File Watcher event monitors a specified directory, then tells the system to perform an action when a file is added to that directory. The system can delete, move, or rename the file. Use the Schedule...

Replace Bookmarks With Text

Overview This tutorial demonstrates how to use Replace Bookmarks With Text step from Data > Documents category in the ToolBox. This step gets bookmarks from the Constant Word Document, replaces them...

Replacing Bookmarks With Text (Dynamic)

Overview This tutorial shows how to replace Bookmarks in a Word Document with desirable Text. The Step that can be used for this function is called a Replace Bookmark With Text (Dynamic) Step. A Word...