Wiki Detay | wiki workcube

WBP (Workcube Best Practice) are preset packages that facilitate and minimize the sectoral customization process of Workcube. These packages help customers optimize their business processes by providing adaptable solutions quickly and efficiently.

Path:Control Panel > System > DEV Tools > DB Manager

Creating WBP Script

When DB Manager is clicked, the Dashboard welcomes us. We can see information such as schema, table and column in the database through the Dashboard on the page. You can create and edit WBP scripts from your own database or from the Workcube Database page.

Select the schema of the database table you want to create from the menu on the left and click on the table.
If you want to include all the rows in the table in the script, click the "Export" button at the top right of the loaded screen.

If you want to select only certain rows, when you run a query after opening the table, the result field appears at the bottom. In this result area, check the boxes next to the rows you want and click the "Send to Data Script" button.
Then you can download it by filling in the relevant fields and pressing the "Download" button.
Edit the script file you downloaded, make any changes you want and save it. Having only INSERT INTO lines in the .txt file you downloaded will be sufficient for WBP installation. You should delete the CREATE TABLE section.

Loading WBP Scripts

You should keep the WBP Scripts in the relevant schema folder in the Best Practice you want. After installing the scripts in the right place, you can run them.

Path:Control Panel > System > DEV Tools > Best Practice

Search for the Best Practice you want to install in the list and go to its detail page.
At the bottom of the screen. From the "Components" box, go to the folder of the schema in which you want to install the script. For example; If you want to upload to a table in the "Main" schema, list the directory as "Install > Data_library > Main".
Click the "+" icon next to the "Type" folder you want to upload to within the schema folder you have selected,Open the Data Script Export box.
Fill in the file upload fields:
- Best Practice and Type: These fields are automatically filled in based on the Best Practice you are in and the Type folder you selected. If you have selected the correct folder, you do not need to change it.
- WO: Select the WO it is associated with.
- File: Select the script file you want to upload.
- Head: A header with the same name as the file you uploaded.
- Detail: Add a description or detail.
- Create Date: Select the date you uploaded.
- Author id: Enter the id of the person who created the script.
"Export to You can install the script by pressing the "WBP Folder" button.

Running WBP Scripts

You can run WBP Scripts single scripts that you associate with the WO from the "Steps" page.

Family and Select the module.
On the screen that opens, click on the "WBP" icon on the right side of the WO you will install.
You can view the connected scripts in the opened WBP box.
When you press the install button, the company selection screen will appear and you can run it by selecting the companies you want.

Note: If you do not see any company in the company selection box, the WBP script has previously been used in all companies. was operated.

Tips

Record was not found

Feedback

Did you find this content helpful?

Please Write Your Feedback!

Name*

Last Name*

Email *

About Workcube Objects

Database

It allows accessing the database to view, add tables and run queries.

Type: WBO Version: Catalsyt v2 Licence: Standard Author: Workcube Core

Release Notes

Automatic Table Transactions in Period and Company Schemas

Added Function: In newly opened table and column operations in Period and Company schemas, columns are automatically opened and tables are added in all periods and companies.

Benefit: In this way, the innovations made opening company-based columns or adding tables were eliminated and automated.

Feature Cognitive 18.07.2025 tasks/155159_ugurhamurpet → master

Primary Key to DB Manager

Added/Edited Function: PK feature has been added to DB Manager to add Primary Key that is forgotten or left missing when opening a table. Added filter to table list to list non-PK tables. In the Table detail that does not have a PK column, PK is added by selecting the column with the +PK button. This feature works on MS SQL and Postqre databases.

Feature Cognitive 27.08.2024 tasks/149747_betamax → beta

Total 2 Register