(...) view how it is done :) BPS 2023+ It would be perfect if such an overview could be added out-of-the-box (e.g. such dashboard) of the groups (at least the ones directly used which can be SQLed from data base) - alike in the kb article by Mr. Baszak :) https://community.webcon.com/posts/post/checking-user-and-group-privileges/258/3
(...) HI, When installing Webcon, the SQL Server compatibility level is set to 120 (default). To use advanced functions like `string_split` and data processing functions from JSON, it is necessary to manually change the compatibility level to 150. These functions are essential in developing more complex processes. If we manually upgrade the compatibility level from 120 to 150, Webcon will no longer pr (...)
(...) Hello, Is there a way to ensure uniqueness of items in Webcon's dictionary when importing data from Excel, to avoid duplication? Thanks.
(...) I'm trying to connect to Webcon with Power Bi. Service I set up Odata user and API key as described here https://community.webcon.com/posts/post/odata -format-in-webcon-bps/346. I do not have a problem to connect using Power Bi desktopapp but after uploading report to Power Bi service there is a problem with refreshing although I set up on-premise gateway on Webcon vm - invalid credentials. Has any (...)
(...) Hello everyone, I need your help with a task that should actually be relatively simple. I'm trying to establish a connection to my Site Collection in SharePoint and have entered the relevant data (Server and Site Collection, User, ...). When I click on "test", it loads for several seconds, and I get the error: Unable to connect to the remote server. Regarding my rights in SharePoint: I am the own (...)
(...) Hello, I' m new in webcon and i try to fix issue connected with attachments. I don't know much about attachments data base but as i saw there are two places where i can find data : [BPS_Content].dbo.WFdata Attachmets and [BPS_Content_Att].dbo.WFAttachmentFiles When im trying to add attachment like always going step by step in my workflow everything is ok - attachment is being added in both ta (...)
(...) Hello, I am trying to use the webcon REST API to create a new instance and to upload an attachment. I am having troubles finding the version that should go into the URL ex: /api/data /v2.0/db/{dbId}/elements/{id} (in this case is "v2.0"). How can I find the version for my project? I have used the following examples from webcon: https://community.webcon.com/community/public/posts/post/examples-of-u (...)
(...) Hi, the API endpoint returns a list of all processes inside a appliation. /api/data /v5.0/db/{dbId}/applications/{idguid}/processes It would be great, if the result would contain a property to check, whether a process in the result is only a relation. { "processes": [ { "id": 0, "guid": "string", "name": "string", >> "isRelation": "boolean"
(...) specific: 0 - Not needed 1 - Create/Buy 2 - Already owned So from yes/no I have to move to Choice Fields, and here comes the question - how to change field type, but in a way that won't create data loss? I know that WFD_AttBoolX will become WFD_AttChooseY, and propably it's possible to move that data with global cyclic actions like translate WFD_AttBool to WFD_AttChoose, but how should i clear (...)
(...) 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 (...)
(...) Selecting a users took now multiple seconds. You can see that there are three calls for the people field "Responsible" which took in total about 5 seconds. I worked around this by creating an SQL data source, which made the form usable again. In the screenshot the "Owner" field uses the sql data source. The drawback this has is, that it's no longer a people field and everywhere I have to select (...)
(...) Hello, Does anyone has a rest api configured to access Sales Force? I have a connection and I use it in a process but I'm getting the data from Opportunities. I would like to bring in a specific report. I've checked how to do this and I came up with this query using the GET /services/data /v52.0/analytics/reportTypes/Opportunity But when I use the field as a data table in order to check the info (...)
(...) per. We have to add 0 prefix to hour "7", so it is "07". It is one more click + one more typing. Allowing format h:mm or even h:m would be ergonomy enhancement for faster entering the date & time data :) Best Regards, Dominik
(...) : { "id": 565, "sessionGuid": "2c8664cd-1862-4978-9355-1d0b7c3c47d5", "userTime": "2023-08-31T05:51:09.457", "userLogin": "xxx", "userLanguageCode": "en-US", "userBrowserdata ": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/116.0.0.0 Safari/537.36 Edg/116.0.1938.62", "events": [ { "id": 11030, "userTi (...)
(...) Hello, I copied one item list from one process to another and after trying to save the process I get the below in the attached image. There are some data row field in the item list that are showing data coming from business rules. I guess they are causing the problem. The main issue is that designer studio doesn't show the fields anymore so I'm unable to delete the item list that I copied. As you ca (...)
(...) Hello, I've spend today over an hour copy/pasting data between notepad and webcon into run subworkflo action configs. In my use case - i have to start 1-10 subworkflows (each having different start condition), with different workflows, and forms, but with partially shared attributes (marked blue). I'm configuring actions in new process, so i've copied them from existing process, to avoid refillin (...)
(...) Hello Durning installation of the Webcon BPS for Microsoft Outlook Addin 2021.1.4.195 plugin and opening Outlook, the error "Access denied to the path c:\Users\xxx\Appdata \local\Temp\Deployment\A3Y823NQ.KMT\9J59YY7H.WXE\sk" appears when loading the plugin. \Webcon.Workflow.Outlook2010.resource.dll" (I'm attaching a screenshot). Massive deployment from sccm . Command line : Execute-MSI -Action Instal (...)
(...) Hi, Sorry for my lack of knowledge but I've just installed WEBCON 2 days ago. Please help! I want to add in a item list rows from a SQL data base but: Querying data is ok. I want to select a product name based on that query (from a Choice field) and get the correspondent price from the query... Also my query is based on another field as a filter When I change the value of that filter, the list o (...)
(...) I try to render values from a rich text editor (multiple lines of text; Mode: Rich) as a column of a table on a Word-Document. But after the Wordfile generation the formatting is lost. In the data base the value is stored as: X2OTestBla Is it possible to generate the Wordfile with the given formatting? Thanks in advance. 1st Image: Value in the Rich-Text-Editor 2nd Image: Result (...)
(...) Hello, we use the actions "Convert word to PDF" and "Generate/Update a word file" and we assign the documents to a dynamic category. The category is not saved to the table WFdata Attachmets, the field (ATT_Attribute1) stays empty. in version 2021.1.4.55 it did work fine. Thank you! Balint