Opens the Para-Flex settings

May 21, 2024

Start

Pro

Description

Opens the dialog for Para-Flex settings. Configurations can be saved and loaded for back-up functionality or duplicating settings to colleagues. Some changes require a restart of Para-Flex, this will be mentioned when clicking on Apply to save the new settings.

The settings are grouped by the different Sections in Para-Flex, for example Optimize and Custom Database. Different tabs below the main buttons show the corresponding groups.

Clicking on a setting triggers the information panel on the right side, which shows the purpose of each setting and its options.

Custom database connections

Para-Flex is able to connect with a wide variety of databases for materials, products and order information. By default Para-Flex gets its materials from a Microsoft Access database. The drivers and example data is pre-installed with the Para-Flex setup package. However, it’s also possible to connect to other custom databases, that can be configured in CustomDb tab of the settings form.

At the moment Para-Flex supports legacy ODBC and the more modern, OleDb connections. Para-Flex can be configured to use multiple mix of different database connection(type) for each data object.

DataObjects Version
Material 24.4.0.0
Edgebanding 24.4.0.0
SheetmetalMaterial 24.4.0.0
OrderInfo 24.4.0.0

Compatibility data structure

In order to be compatible with the data structure within Para-Flex , each DataObject needs to be configured with the following 3 items:

By default the ConnectionString should be an OleDb connection string. More info

If the ConnectionString is based on an ODBC connection, (e.g. FireBird or MySql), the connection string must start with odbc: followed by the connection string. For example, if the ODBC link is created by a System-DSN the ConnectionString should look like:

odbc:DSN=PARAFLEX-ORDERINFO

Each brand of database has it’s own specific column and table identifier character. To configure the identifier, enter the start- and ending-identifier character.

 

Database Identifier  
SQL “ “ 2x double quote
Mirosoft SQL [ ] Open bracket, close bracket
MySql ` ` 2x single quote

Each data object should be compliant with pre-defined column names and data types for each view or table. The name of the views or tables can be customized and do not need to have a specific naming convention.

3A. Material

Material is part of the Material data object. Materials are all non-sheetmetal boards with a length, width and thickness. E.g. Wood, glass , plastics.

Column Name DataType Version
MaterialsCode System.String 24.4.0.0
MaterialsDescription System.String 24.4.0.0
MaterialsGrain System.String 24.4.0.0
MaterialsThickness System.Double 24.4.0.0
MaterialsPictureFileName System.String 24.4.0.0
3B. Boards

Boards is part of the Material data object. The BoardsMaterialCode has a unique key on the MaterialsCode of the Material view/table and contains all the board dimensions, stock quantity and cost for each material.

 

Column Name DataType Version
BoardsMaterialCode System.String 24.4.0.0
BoardsCode System.String 24.4.0.0
BoardsLength System.Double 24.4.0.0
BoardsWidth System.Double 24.4.0.0
BoardsStockQuantity System.Int32 24.4.0.0
BoardsCost System.Decimal 24.4.0.0
BoardsType System.Int32 24.4.0.0
3C. Edging

Edging is part of the Edgebanding data object. The edging table stores edgeband data for applying edges on wooden panels.

 

Column Name DataType Version
EdgeCode System.String 24.4.0.0
EdgeDescription System.String 24.4.0.0
EdgeThickness System.Double 24.4.0.0
EdgeCoreTrim System.Double 24.4.0.0
3D. Material (Sheetmetal)

The material for sheetmetal is part of the Sheetmetal Material DataObject. The Table view definition is the same as for material of non-sheetmetal.

3E. Material (Sheetmetal)

The boards for sheetmetal is part of the Sheetmetal Material DataObject. The table or view definition is the same as for boards of non-sheetmetal.

3F. OrderInfo

The Orderinfo is part of the OrderInfo data object. The Order info contains customer and order information:

 

Column Name DataType Version
Code System.String 24.4.0.0
Number System.Int32 24.4.0.0
ProjectName System.String 24.4.0.0
ProjectDescription System.String 24.4.0.0
StartDate System.DateTime 24.4.0.0
DeliveryDate System.DateTime 24.4.0.0
CustomerRecognition System.String 24.4.0.0
CustomerName System.String 24.4.0.0
Phone System.String 24.4.0.0
Email System.String 24.4.0.0
Address System.String 24.4.0.0
ZipCode System.String 24.4.0.0
City System.String 24.4.0.0
Type System.String 24.4.0.0
Remarks1 System.String 24.4.0.0
Remarks2 System.String 24.4.0.0
Remarks3 System.String 24.4.0.0
Barcode1 System.String 24.4.0.0
Barcode2 System.String 24.4.0.0
Barcode3 System.String 24.4.0.0

 

3G. OrderInfo

The Orderinfo is part of the OrderInfo data object. The Order info contains customer and order information:

 

Column Name

DataType

Version

Code

System.String

24.4.0.0

OrderItemNumber

System.Int32

24.4.0.0

OrderNumber

System.Int32

24.4.0.0

Description

System.String

24.4.0.0

Position

System.String

24.4.0.0

DeliveryDate

System.DateTime

24.4.0.0

Barcode1

System.String

24.4.0.0