Opent de Para-Flex instellingen
Start
Pro
Omschrijving
Opent de Para-Flex instellingen
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 |
| Kantenband | 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 |
| Telefoon | System.String | 24.4.0.0 |
| 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 |
|
Omschrijving |
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 |
