Go to website
Import and store parameters and useful data for several processes.
What should I use a database for?
In Flokzu, users who are Administrators or Business Analysts can create databases to use in their processes. Potential uses for a database: Store information that will be repeated in several processes (e.g. a list of countries, a list of products, Supplier's contact details, etc.). You can use this information to populate the options of a combo box in a form. If you want to add a new country, product or supplier, you can simply add the record to the database and all related combo box
Linking combo boxes by database using Filters
Linking combo boxes by database using Filters In Flokzu you have the possibility to link combo box fields to make your form smarter. The way to achieve this is by using Filters. The first step to link combo boxes is to create the combo boxes you want to link, e.g. A combo box named 'Country' and another one named 'Cities'. Once you have done this, you must c
How to add records to a database
How to add records to a database In Flokzu there are several ways to add records to an internal database. We list each one below. Adding records manually First, you have the possibility to add data from a file manually, adding records to an internal database one after the other. This is useful when the number of records that you will add to the database is small or won't suffer variations for a long time, e.g. A database with the contact data of all the Providers of an organisation.
Add record to a database through Web Service
In Flokzu you can obtain all the documentation available for review at any moment, either through the Metrics & Reports section, the Historical data of the process instance, simple and advanced searches, etc. However, in some cases, it could be useful to store some relevant information (or information that you are going to use constantly) in an internal database. To add data from a form into an internal Flokzu database you must follow the following steps: Create a DB with the correspondi
Update database records
Not only can you add new records to a Flokzu database at any stage of your process, but you can also update those records if some of the information previously sent to the database has changed. Example: You have an Office Supplies Request process where you buy supplies from different Suppliers. Some of the contact information from your Suppliers may vary, which is why it’s necessary to be able to update your database when needed. The first option to update your database is doing so manually.
Problem with special characters when importing a database
Solution This problem is due to the coding of the document, we always recommend it to be UTF-8 without BOM. In case you already have your file you can fix it this way: 1) Open the .csv file in Notepad++ 2) Click on "Encoding" and then select "Convert to UTF-8 without BOM". 3) Ready.