Skip to content

Main Navigation Guide Scripting Reference Tag Reference Developer Guide Operation Guide

Appearance

Sidebar Navigation

Flow Documentation

Welcome

Getting Started

End User License Agreement

Document History

Directories

Program Folder

Application Data Folder

SQL Server Data Folder

Components of Flow

Flow

FlowMonitorService

FlowMonitor

FlowService

FlowAPI

FlowWeb

FlowTransportWeb

Supporting Components

Third Party Components

Installing Flow

Planning the installation

Installation

What is installed?

Installing Microsoft SQL Management Console

Manual Installation

Required Tools

Services Control Panel

IIS Manager

FlowMonitorService

FlowMonitor

FlowService

FlowWeb

FlowTransportWeb

Users and passwords

Starting Flow

Software License

Configuration Databases

Creating a new configuration database

System Connections

Using Windows Authentication

Using SQL Server Authentication

Upgrading a configuration database

Backing up a configuration database

Restoring a configuration database

Shrinking a configuration database

Flow Designer

Modules, Templates, Packages, and Connectors

Administering Flow

Configuring Flow

Action Steps Tab

Custom Script Action

DB Disconnect Action

File Router Action

Map Action

Plugin Action

Report Action

Report

SQL Action

Shell Execute Action

Sub Action

Transaction Commit Action

Transport Action

Wait for File Action

Action

Data Tab

Execution Tab

Notification Tab

Trading Partners Tab

Actions

Common Pitfalls

Examples

Common Dialogs

Files Tab

Log Viewer

Overview Tab

SQL Tab

Transports Tab

Parameter Editor

Proxy Settings

SOAP Element Editor

Authentication Type

Destination Host

Destination Port

Method

Password

Private Key

SSH Port

SSH Server

SSH Settings

Source Port

Use Gateway Ports

Use Port Forwarding

Username

SSL Settings

Script Editor

Allow Execute

Allow Full

Allow Read

Allow Write

Deny Execute

Deny Full

Deny Read

Deny Write

Security Editor

User List

Common Pitfalls

Fixed-length field breaks linking

Advanced Tab

DB Connection

General Tab

DB Connections

ADO connection

DB2 connection

Examples

Informix connection

Interbase connection

MS Access connection

MYOB connection

Microsoft SQL Compact connection

Microsoft SQL Server connection

MySQL connection

ODBC connection

Oracle connection

PostgreSQL connection

QuickBooks connection

Data Connections

Common Pitfalls

Using local file paths

Examples

Inbound File

Local File Path

Network File Path (UNC)

Outbound File

File Connection

General Tab

File Connections

Authentication credentials not supplied

Common Pitfalls

Using web service path instead of WSDL path

WSSDL path not accessible

Examples

Local WSDL path

Remote WSDL path

General Tab

Web Connection

Web Connections

Common Pitfalls

Linking data views from different DB Connections

Linking dataviews on non-unique fields

Not emptying destination DB Definitions

DB Definition

Designer

General Tab

Main Screen

DB Definitions

Examples

Reading DB Definition

Writing DB Definition

Data Definitions

Data Views (Datasets)

Datasets - Records and Fields

Common Pitfalls

Incorrect Root Nodes in XML Files

EDI File

Examples

Flat File

XML File

Designer

File Definition

Disable automatic string trim

EDI File Type

Flat File Type

General Tab - EDI

General Tab - Excel

General Tab - Flat

General Tab - XML

General Tab

XML File Type

Main Screen

Partner Identification Tab

File Definitions

Common Pitfalls

Incorrect Root Nodes

Examples

Reading Web Definition

Writing Web Definition

Designer

General Tab

Main Screen

Web Definition

Web Definitions

Documentation Note

Documenting

Exporting and Importing

Folders

Auto Backup Tab

Email Setting Tab

Email Text Tab

General Setup

General Tab

Proxy Settings Tab

Shell Extensions Tab

Web Settings Tab

Global Setup

SQL Window

Service

Services

Access

Full Name

Password

Username

Users

View

Files Tab

Logs Tab

Logs

Transports Editor

Transports Tab

Common Pitfalls

Examples

Designer

General Tab

Main Screen

Parameters Tab

Map

Maps

Plugin Manager

Plugin

Common Pitfalls

Linked Data not assigned

Examples

Designer

General Tab

Main Screen

Report

Reports

Third Party Tools

XSD Inference

Common Pitfalls

Examples

Trading Community

Contact Details Tab

Email

General Tab

Trading Partner Attributes

Trading Partner

Transports Tab

Trading Partners Tab

Common Pitfalls

Examples

FTP

File Directory

Indicator File Ext

Move to Directory

Use temporary file name

HTTP

IBM MQ

Inbound Transports

LAN

MSMQ

POP

SOAP

AS2

Description

Common Pitfalls

Examples

Dont delete file from server

FTP

Use LIST command instead of NLST

HTTP

IBM MQ

LAN

MSMQ

Outbound Transports

SAP

SMTP

SOAP

ebXML

Transports

Configuring FlowMonitor

Installing FlowMonitor

Using FlowMonitor

Checking which Actions FlowService is executing

Actions

Error Handling

Events

Managing what data has been processed

Concepts

EDI Techniques

Integration Techniques

Configuring FlowService

Handling errors when starting FlowService

Publishing instance of FlowService

Scheduling Actions under FlowService

Starting Stopping FlowService

Accessing FlowWeb

Configuring FlowWeb

Starting FlowWeb

Accessing FlowWebTransport

Configuring FlowTransportWeb

Operating Flow

Developing with Flow

Maintaining your Flow installation

Backing up Flow

Upgrading Flow

Change Logs

Automatic Upgrade

Manual Upgrade

Rolling back an upgrade

Using Beta Versions

Relocating Flow

Tag Reference

Standard Tags

Data Tags

Super Global Tags

Local Global Tags

Parameter Tags

Partner Tags

License Tags

Scripting Reference

Script Editor

Scripts

Comments

Statements

Assignment

Begin...End

Try...Except

If

Case

While loop

For loop

Operators

Arithmetic Operators

Assignment Operator

Boolean Operators

Relational Operators

String Operators

Exceptions

Program Flow

Events

LinkedData

BeforeMap

AfterMap

OnMap

Data Types

Testing for Null etc

Boolean (Boolean)

Datetime (TDateTime)

Float (Double, Extended, Currency)

Guid (TGuid)

Integer (Integer, Cardinal, Int64)

String (String, Widestring)

Variant (Variant)

Blob (Blob, Memo)

Enumerations

TFloMD5HashType

TFloPartnerType

TFloFieldType

TRegConType

TVarType

TFieldType

TQuestionResult

Format Specifiers

Date Format Specifiers

Variables

LOCAL Variables

GLOBAL Variables

Global Datasets

Super Globals

Local Globals

User Parameters

Global Dataset Aliases

Referencing Fields

Classes

File Connection (FileCon)

FileCon.FileName

FileCon.CurrentFileName

FileCon.FileDir

FileCon.ProcessFileDir

FileCon.AuditDir

FileCon.ProcessAuditDir

FileCon.ErrorDir

FileCon.ProcessErrorDir

FileCon.SendViaTransport

FileCon.DoMoveToAudit

FileCon.MoveFile

FileCon.CopyFile

DB Connection (DBCon)

DBCon.Database

DBCon.Hostname

DBCon.Username

DBCon.Password

DBCon.OtherParams

DBCon.ConnectionType

Data Definition

DBConCount

DBCons

FileCon

StartTransaction

CommitTran

RollbackTran

Data Set

Dataset.BOF

Dataset.EOF

Dataset.FieldByName

Dataset.Fields.Count

Dataset.FieldByNumber

Dataset.Delete

Dataset.Find

Dataset.RecordCount

Dataset.RecordPosition

Dataset.Insert

Dataset.Edit

Dataset.Post

Dataset.CancelPost

Dataset.First

Dataset.Last

Dataset.Next

Dataset.Prior

Dataset.HasDetail

Dataset.IsDetail

Dataset.IsMaster

Dataset.RecordPKValue

TFloClientDataset.Create

Field

Field.Value

Field.AsSQL

Field.AsString

Field.AsInteger

Field.AsFloat

Field.AsDateTime

Field.FieldName

Field.FieldType

License

License.UserId

License.LicenseId

License.LicenseName

License.LicenseExpiry

Action

Action.Actions

Action.Partners

Partner

Partner.Id

Partner.CompanyName

Partner.FlowNetId

Partner.FirstName

Partner.LastName

Partner.PartnerType

Partner.CustomerId

Partner.TPSupplierId

Partner.SupplierId

Partner.TPCustomerId

Partner.Email

Partner.Phone

Partner.Fax

Partner.Address1

Partner.Address2

Partner.Address3

Partner.City

Partner.Country

Partner.Username

Partner.Userpass

Partner.AddrState

TStringList

TStringList.Count

TStringList.Add

Functions

Accounting

DiscountAmount

Discounted

TaxAmount

TaxExclusive

TaxInclusive

Barcode

EAN13toEAN128

Blob & Memo

CreateBlobValue

ReadBlobValue

COM

CreateOleObject

GetActiveOleObject

BinToHex

BinToInt

Conversion

CurrStrToFloat

FloatToStr

HexToInt

Int64ToStr

IntToBin

IntToHex

IntToStr

StrToFloat

StrToInt

StrToInt64

StrToIntDef

Database

ExecSQLStatementAndCommit

ExecSQLStatementDest

ExecSQLStatementSource

GetCustomDataSet

GetDataSetFromDest

GetDataSetFromSource

GetSQLValueFromDest

GetSQLValueFromSource

CompareDate

CompareDateTime

Date

Datetime

DayOf

DaysBetween

DaysInMonth

DaysInYear

DecodeDateTime

EncodeDateTime

EndOfTheMonth

Get20thOfNextMonth

IncDay

IncMonth

IncYear

IsPM

IsValidDate

IsValidDateTime

IsValidTime

LocalToUTC

MonthOf

MonthsBetween

Now

RecodeMonth

RecodeYear

StartOfTheMonth

StringToDateTime

Time

TryEncodeDateTime

UTCToLocal

YearOf

YearsBetween

Email

IsEmailValid

SendEmail

SendEmailEx

SendEmailExBCC

SendEmailTo

Base64Decode

Base64Encode

Encryption

MD5Convert

MD5Hash

MD5HashHex

RC4Decrypt

RC4DecryptKey

RC4Encrypt

RC4EncryptKey

ExceptionParam

ExceptionPos

ExceptionProc

ExceptionToString

ExceptionType

Exceptions

RaiseException

ChangeFileExt

ExcludeTrailingPathDelimiter

ExtractFileDrive

ExtractFileExt

ExtractFileName

ExtractFilePath

File

FileLocked

IncludeTrailingPathDelimiter

IsPathDelimiter

LoadFileToString

MakeUniqueFilename

MatchPattern

SaveToFile

TempFileName

Windows File Functions

Zip

ApplicationName

ApplicationPath

Flow

FormatDateTime

FormatFloat

Formatting

EmptyGuid

EmptyGuidString

Guid

NewGuid

NewGuidString

Host Specific

ExonetCleanStockcode

MYOB Exo

LogError

LogErrorAndContinue

LogInfo

LogWarning

Logging

MessageError

MessageInfo

MessageWarning

QuestionYN

Abs

Cos

Mathematical

Pi

Sin

Sqrt

Dec

ExtractNumber

Frac

Inc

Int

IsCurrencyNumber

IsDigit

IsNumber

Numeric

Round

Round2

Round2BR

Round2Up

Trunc

Parameters

CancelExecution

Exit

ProcessMasterRecord

Program Control

Sleep

StopExecution

AddQuotes

CompareText

Copy

DecodeLineFeeds

Delete

EncodeLineFeeds

Insert

LeftPad

Length

Lowercase

MatchesMask

Pos

RemoveLeadingZero

ReverseString

RightPad

SplitString

String

StringContainsOnly

StringOfString

StringReplaceAll

StringReplaceFirst

StringToToken

StripQuotes

Trim

URLEncode

Uppercase

ActivatePartner

ActivatePartnerByWhere

Partner

VarIsClear

VarIsEmpty

VarIsNull

VarToStr

VarToStrDef

VarToWideStr

VarToWideStrDef

VarType

Variant

Getting Support

Register for account on Flow website

Online Documentation

Knowledge Base

Professional Support

Purchasing Support Vouchers

What support is provided free?

Glossary

Other topics

Glossary

Changing Host Systems or Network Environment

Assigning Trading Partners to Actions

Managing Trading Community

Managing Trading Partners

Managing Security

Managing Users and Security

Managing Users

Staff Roles

On this page

Linking data views from different DB Connections

Delete this text and replace it with your own content.

Pager

PreviousCommon Pitfalls

NextLinking dataviews on non-unique fields

© Flow SoftwareCopyright, terms and conditions Privacy policy

Copyright, terms and conditions · Privacy policy

© Flow Software