search results

(...) : 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 necessary to modify/sa (...)

(...) users added in this way can log in to the system via BPS Auth., be granted privileges, and can be assigned tasks in the system. To save time, you can use the ability of adding more users from an excel file.   Adding users from an excel file To add users, prepare an excel file based on the defined template. This template can be downloaded from WEBCON BPS Designer Studio – go to (...)

(...) 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 inter (...)

(...) Hi everyone, is someone here how understands power query? I got a task to retrieve data from a BPS report in excel to use it for additional analysis. I was able to retrieve the data but transforming the json response to a table is beyond me. Just in case there's someone who would be able to do it but doesn't know how to retrieve the data I add the logic below which can be put into the advanced edito (...)

(...) Is it possible to loop over all rows of an excel file? I have an excel file with employees information(say 50 rows of employees). I want to navigate through each row, read and populate data in my form from excel columns and then trigger a workflow for each employee.

(...) Data table attribute gives opportunity to export containing data to excel using its default configuration, the sole problem is it can only export top 1000 rows, when its quite common to display bigger chunks of data in that form field. Documentation that redirects to below website doesn't mention anything about such limit: https://howto.webcon.com/exporting-a-data-table-form-field-to-an-excel -file/ (...)

(...) g processes between DEV / TEST / PROD. I don't have to think about replacing the name /DOCTEMP/f8e86bc...e967af9b62 with another guid in appropriate action. The same I wanted to do for generating MS excel attachments. Unfortunately I get the error: WebCon.WorkFlow.Common.Exceptions.WorkFlowException: An (name) action execution error on a menu button occurred. ---> System.Net.WebException: Cannot get d (...)

(...) Hello, I made a report in WEBCON Designer Studio and one of the columns is "Link". However, when I export that report to excel , that column is converted to a simple text (not a link). Can I in some way configure it to receive in the exported excel that column as link? Best regards, Vitalii Lukash

I know that in webcon report there is only possibility to show only one "Item list" attribute but is there any possibility to create some technical data table or atribute to show more than one list? Or maybe you can give some example of SQL function which select more than one "Item list". Thank you in advance for your help.

(...) Dear Webcon Community! Problem: with import excel action you can import excel tables only if you have a table container already added. Sometimes it is difficult if we want to process data in excel table coming from third party. Proposal: there is a way to define column mapping for itemlist file importing. It would be nice to have a feature in import action to take into account that one, inste (...)

(...) Hi, it is posible to export data from item list to excel in action but only id from column value? Only way i found is map item list to excel table (Sheet1!Table1). In this way the whole (id and name) of column is exported. But I want only id or name.

(...) Working on a project whereby there is a process to track delinquent loans and create collection activities based on ageing. We receive loan data as a daily dump in excel and new or modified rows should either fire new instances of our workflows or trigger certain paths in existing workflows.Unsure of how to go about this

(...) Hi all! We are using the action 'Invoke REST Web service' a lot, but there are some limitations I am struggling with. I want to download an excel file using this action, using an external REST service. My first approach was to store the response body into a multi-line content field. I am also using a HTML field with a download button, to save this file from content field to disk. This meth (...)

(...) Hello, I have a short question. I want to generate an excel file with my data from the BPS datasource. I created an excel template with a worksheet(test) and a table(myTable) and a action create excel . I write the assignment like this: test!myTable and my data to the right cell. But I always get an error. (Invalid cell name) If I just want one data set and just write the cell names for each l (...)

(...) 1. In Automation (action) I create excel file from template and add few data to specific cells. 2. The excel file is attached to the form in attachment section. 3. I would like to create pdf file from that excel file. (i don't see that option) in design studio. what I would like to do: 0. create template with excel (done) 1. from fields update excel template (done) 2. excel template save as a (...)

(...) Hi everyone, if you are using BPS 2023 and the option to translate labels via excel , make sure to save all reports again. The following numbers are referring to the second attachment. After importing the translation the report configuration will look like (1) in the database. There's nothing wrong with it and it works just fine in the current environment. When you export the application and i (...)

(...) Hi everyone! We are currently using BPS 2023.1.2.44 in our office. Is it possible to exclude certain report columns from an excel export? We need to display the columns in the Web report, but don't want to show them in excel . Best regards, Christoph

(...) Hi, I have a dictionary process. I built the report based on it. I can export it to excel . Can I customized this excel ? On report I have 3 columns. In excel there are to more ID and DocType + headers of the columns have additional info about attributes from Webcon (type and guid). Can I modify it somehow that I will get only my 3 columns with only names in excel ? BR Adam

(...) Hello, I have an template with a simple excel file that has a table named "Tableexcel ". This table has 4 columns: DATE,CUSTOMER,VALUE,CURRENCY. In designer I created an item list with 4 colums that have the same name. When I map the columns in designer I use "Sheet1!Tableexcel " and on the right i drag the columns from the item list. Every time i run the action i get : Invalid cell name If i try (...)

Hi! I wanted to ask if the removal of the preview of XLSX files could be reconsidered? Perhaps as a toggled parameter. :) It was an important functionality for our company and after upgrading to BPS2023 we have to come up with a different solution for the preview of simple spreadsheets that are attached to BPS documents. Thanks, Patryk