WELCOME TO THE COMMUNITY
find what you are looking for or ask a new question

search results

for data

(...) anciszek Sakławski   Introduction When creating the configurable e-mail templates there is the option to add fields from the form. This article describes how to add an item list and SQL data table fields.   Fig. 1. A list of fields available in the system   To enter these types of fields in the template is needed: Basic knowledge of HTML language (specific (...)

(...) Applies to version: 2020.1.x and above; author: Dawid Golonka   Introduction Some processes in WEBCON BPS require data from some other source to operate correctly. This data can be provided from external data sources such as SQL databases or SharePoint lists. Internal sources can also be created in the system such as Fixed value lists or references to data contained in WEBCON BPS work (...)

(...) tion When creating support for business processes in WEBCON BPS, it is important to remember that even the simplest workflow with a minimum number of steps and form fields will be reflected in the database – all of its instances and settings are represented in the content database – which is the main place of the system’s operation. There are also “virtual tables” auto (...)

(...) .xlsx, tiif, and zip. Their storage location is a particularly important aspect of the system configuration. When organizing your document management system, you can decide to create a separate database to store the attachments. What is the attachments database and why is it created? An attachments database is a dedicated database that stores the attachment files. After creation, the datab (...)

(...) Applies to version: 2019.1.4.x and above; author: Marcin Pisarek   Introduction In the WEBCON 2020 version, we introduce the ability to export the content of a “data table” form field to an Excel file (this option is available in the MODERN form). The article describes how to use this functionality.   Business case The new functionality can be used when is (...)

(...) es to version: 2020.1.x; author: Marcin Wiktor   Introduction SOLR (added in the 2019 version) is a search engine that allows you to efficiently search for content even for very large data sets. A detailed description of the functionality can be found in the article “Portal search engine – how does it work?”. From version 2020 WEBCON BPS allows creating reports bas (...)

(...) Applies to version 2020.1.3; author: Konrad Wojtycza   Introduction In WEBCON BPS data stored e.g. in the external database can be retrieved and displayed by: Defining data connection and SQL query Creating a data source and using filters This article describes both approaches to use data in WEBCON BPS, differences between them, and problems of their configuration. & (...)

(...)   Introduction One of the functionalities significantly extending the potential of WEBCON BPS is the possibility of using the REST API interface. This article describes how to configure a data source based on information returned by the external services that provide their API. An example of using a REST data source can be a “Contractors” data source – connecting the (...)

(...) Applies to version 2020.1.3; author: Michał Kastelik   The article is an update of the already existing article, for the original see Importing and exporting data from an item list.   Introduction WEBCON BPS offers you the ability of importing data to the item list from an Excel file and exporting rows from the item list to an xlsx file. This article describes the (...)

(...) Applies to version: 2021.1.x and above; author: Konrad Wojtycza Introduction This article describes the “Read data from an Excel file” action that allows you to import data from an Excel file to the form. You can use this action in the following scenarios: Part of the information entered into WEBCON BPS is filled out by people who do not have access to the company’s inte (...)

(...) ersion 2021 has introduced a new feature for the environments in which there are many different people creating and modifying applications and processes. Now, you can define dedicated connections and data sources for your applications which should simplify the administration work. You will also avoid situations in which a person using a data source in one application modifies it without knowing that i (...)

(...) .x and above; author: Jacek Język From WEBCON BPS 2022.1.1, the lowest supported SQL Server is 2014. In the case of WEBCON BPS installations using the higher versions of SQL Server, WEBCON BPS databases work with the compatibility level set to SQL Server 2014 by default. Changing the compatibility level from SQL Server 2014 to SQL Server 2019 is possible, but you need to disable the TSQL_SC (...)

(...) Starting with WEBCON BPS 2022.1.1, the lowest supported MS SQL Server version is 2014. Due to this, when installing/updating WEBCON BPS, the Compatibility Level for databases is set to 120 – which corresponds to SQL Server 2014. This setting is also used when installing WEBCON BPS with newer versions of SQL Server (2016, 2019…). When installing BPS databases on SQL server higher th (...)

(...)   Applies to version: 2021.x.x.xxx and above; author: Mateusz Syrek Introduction This article describes 3 variants for transferring WEBCON BPS databases to a different SQL server: new server has the same name as the old one, new server has a different name – applying SQL aliases, new server has a different name – no SQL aliases applied, changing configuration. (...)

(...) Author: Paweł Drab Introduction   Migration of databases to a different database environment or their recreation in such environment may require changing database name. If references to a database are present in several locations, external, logical change of database name is insufficient. The article describes the procedure of changing database name by modifying configuration. &nbs (...)

(...) Applies to version: 2022.1.3 and above; author: Maciej Kieblesz   Introduction This article describes a method of maintaining databases to ensure the highest possible performance of the SQL engine, and thus the BPS application itself. In practice, this will mean a reduction in the number of 'timeout' errors, for example, when loading a report. This mechanism is tailored to BPS (...)

(...) Applies to version 2022 R3 and above; author: Łukasz Maciaszkiewicz   Introduction WEBCON BPS 2022 R3 introduces a new functionality allowing users to disable sorting in item list and data table. The functionality displays data only in the sequence returned from the data source. This article discusses the above-mentioned functionality with an example of item list including installment p (...)

(...) Applies to version: 2022.1.4.47 and above; author: Grzegorz Straś Introduction data from WEBCON BPS can now be loaded in Odata format and used in Power BI Desktop and Online. This greatly simplifies WEBCON integration with Power BI, instead of manually constructing REST API queries and dealing with token-based authentication, we are able to use one of two custom connectors to easily lo (...)

(...) nts, and employees who carry out tasks assigned to them or who are otherwise affected by the process. In WEBCON BPS, the form fields that store information about a person are: Choice field data row Person or group data table One of the data sources for some of these fields can be Domain users. This article provides a definition and instructions for creating this data source, its co (...)

(...) After selecting Overview, user will see Key application indicators, and more precisely, the Per process tab, whose content will vary depending on the applications used and privileges granted. The data of individual applications in the report are grouped and displayed according to the current state, in alphabetical order, just like in WEBCON BPS Designer Studio. When you click on an application, a (...)