forum

Transporting applications to different environments overwrites business entites

1 2

Hi, We have a problem with the transport mechanism and how business entities are handled, we have a development environment in house which we use to prepare application templates (products) which we transport to multiple customer environments and every time we do so the business entities in the target environment are overwritten when the business entity ID exists in both environments. Is there any possibility to prevent this form happening?

Issue with sender email address

0 2

Hi, I'm using MS Graph to send emails. No matter what I define in the notification action on process level, Webcon uses the default email address set in the System settings > Email notifications > Configuration of sending emails. Is this a known bug or is it me that is doing something wrong? The version I'm using is 2022.1.2.59 Thank you in advance for a reply.

Problem in using search panel of application report value in step field

0 0

Hi, While using search panel of application report I run into a problem where the report doesn't show any results. The problem occurs after selecting a value in the step field (screenshots below). Has anyone met similar issue and know how to fix it? Is it a bug?

Date difference

0 1

Hi, I have a formfield where I have a starting date and I have the form field with the end date. How can I calculate the diffrence in days between this days?

New calculated column in a SharePoint report version

0 0

Hi, I want to add a few calculated column in my report(Webcon Sharepoint version) but the button "Add calculated column" is disabled and I don't know why. Do you know why this button is disabled?

Initialize Item List with an integer form field

0 7

Hello all, I'm trying to set up a payment process in webcon for Rents. The idea is: - Open request and save the date of request (as the current date) - Calculate how many months until end of year (civil year) - Initialize the item list with the number of rows as the number of months - Each row will create independently the payment for that month Although I have all the idea structured, I'm facing some questions in regards to: - How can I initialize dynamically the item list with an in (...)

WEBCON tables via MS SQL Server Management Studio

1 2

Hello, Does anyone can help me, how can I see WEBCON tables via MS SQL Server Management Studio? What the process of connecting to the WEBCON server looks like? When I tried to enter the server name (test.company.corp) into MS SQL Server connection dialog box it didn't work. Regards

Change attribute field name on form

0 0

Hello, Is there any possibility to change attribute field name on form based on different attribute value?

Using SQL script to update WFD_Signature in WFElements

0 0

Currently I'm migrating files from SharePoint to a custom built WEBCON DMS application. Normally the Instance number is generated according to a rule which is perfect for new files. The customer wants to keep their document numbering. For the existing files I would like to update the Instance number (Database: WFD_Signature) using a small SQL script. But is it safe and is it wise to do that? I'm aware the numbers need to be unique in the system, and I know they are unique in the old system. (...)

Connection between an item list and a dictionary

0 4

Hi, I want to compare(lookup) an item list with dictionary items. On a start step I have the item list where I want to upload some rows from an excel file, then I want to check if uploadet rows exist in the dictionary. If exists, webcon should mark a column in the item list that the entry exists. Do you know how to achieve it? Could you help?

SQL query for calculated column suddenly no longer working when added as constant

0 1

Hello folks, We have used constants which contain SQL queries for calculated report collumns a couple of times already, so this does work. But i now have a query which works perfectly when added into the calculated collumn directly, but no longer works when stored in a constant. (img attached) Through logs we found that he has a problem seemingly with strings, but we found no way to baypass that. Anyone have an idea what is done with the query on the way or why this might be the case?

Branch problem as the task is created in postivie step

0 1

I have a workflow when I have a branch that's check whether user ticked the box 'yes' or 'no'. If user ticks the box yes - the workflow goes to the postivie finished step. However, I needed to configure the task creation, and that worflow stays as a user task . How do I omit the user task creation?

Setup SOAP web service

0 0

Hi, we would like to use the SOAP web service in WEBCON (DBVersion 2022_1_2) . How can we get the delivering result? Webcon by default marks only the "Messages" area. See screenshot. Unfortunately, other markings are not possible... Thanks a lot! Florian

Translation of ALERT and CONFIRM contents in Form Rules

0 4

Does anyone know if it is possible to provide translations for the Form Rule Functions ALERT and CONFIRM? I tried with "MyText$$DE$$Mein Text" but that doesn't do anything. Cheers Pasquale

Populating Dropdown List from REST

0 8

Hi there has anyone an example on how to populate dropdown lists from REST data sources ? I got the working requests in POstman, but I cannot get them to work at all in webcon. and its kinda hard to debug since error messages or logs are seemingly not available... thanks for your help in advance.

Check VAT Status [Poland] error

0 4

Dear Community, from last Friday (29th of July) I experience issues with SOAP Web Service at https://sprawdz-status-vat.mf.gov.pl that checks if Supplier is active VAT payer. Does anyone have same issue? Should we consider "migrating" to https://wl-api.mf.gov.pl REST Web Service, where we can check VAT status also? What about limitations of wl-api service? Thanks in advance for any response here. Best, Adam Hatak

Item list and adding new items with Javascript

0 6

Hi all! We are wondering if there is a good way to add new items to an item list on the client side. We already found a way to add new item (which can be triggered by a form rule) and set some form fields before, which then act as default values for the new row. Since it all is asynchronous it has to be a promise chain, like this pseudo code: p.then(() => { SetValue(formField, 'Value') }).then(() => { InvokeRule('#{BRUX:1526:ID}#') }) This is working fine but unfortunately this s (...)

Fileupload failing

0 0

I need to upload attachments to our company cloud services. Below is the web api endpoint that accept a file: [HttpPost("createfilewithcontent"), DisableRequestSizeLimit] public async Task<ActionResult<GoogleFile>> CreateFileWithContent([FromForm] GFileWithContentWrite fileInfo) { var stream = fileInfo.File.OpenReadStream(); var createdFile = await _driveService.CreateFileAsync( new GoogleFileWrite() { Description= fileInfo.Description, MimeType = fileI (...)

Adding multiple attachments

0 2

Hi everyone, I have problem with adding multiple attachments. When I use action "Add attachment", I can add only one attachment (picture1). When I use the same action, but the SQL query returns more the one attachment - the action doesn't work (and it doesn't matter if the ID's of attchments are in the one row or many rows). Thank you for your time :)

Delay start of workflow for 1 minute

0 3

Hi all! We are currently biting our nails with the following problem: We need to delay execution of workflow for 1 minute, after 1 minute it should go to a path. Every attempt to achieve that failed up to now. The attached setting should trigger after 1 minute (as far as I understand that), but it seems to start immediately. What are we doing wrong here? Many thanks & best regards, Nik