WELCOME TO THE COMMUNITY
find what you are looking for or ask a new question
Home > Forum > Data sources

Data sources

Have any of you implemented or are planning to implement in your company an interface for operating the KSeF (e-invoice) system via WEBCON? Similarly, has anyone successfully visualized an e-invoice according to ministry-defined template (xsd)? This would be a real GameChanger for WEBCON and natural for accounting document workflows. Maybe there are ready-made SDK libraries available or does anyone have an idea how to implement it at the lowest possible cost? https://www.podatki.gov.pl (...)

Hello, I created a few BPS users and I found out that they are saved in BPS_Config instead of BPS_Content. From the Administration tab I activated license for some users, but I have no idea in what table I can see this information. I want to make a calculated column in a dictionary report where I can see witch user has license. So in what table I can find if a BPS user has license or not? Thank you, Best regards!

Hello Community, I want to set form fields based on a dropdown selection which gets its data from a sharepoint list. I can set the value from the selection just fine. However I can only access the data with type ID and Name. The rest of the data has no type and does not show up for any rules I want to configure. How can I address this data in the form? Thanks Oliver

Hi I have a question. I imported a dictionary from Excel from the dictionary process and it duplicated the lines. I would like to upload this data from the beginning. How to delete all dictionary content.

Hi, We recently migrated Webcon to new servers on SharePoint 2019. Apparently, the configuration under Webcon BPS Configuration on each SharePoint site got lost (the database name etc.). 1. Is this behavior expected during migration? 2. Is it possible to set it globally or is it necessary to set it manually on each SharePoint site/subsite? 3. Are there any other such settings that might have gotten lost during migration? Thanks! Mark

Hello, is there any way to connect other data sources (MySQL or Generic-ODBC)? If not, is there a plan to implement this in the future? Thanks in advance Markus

Hi, I have 2 dictionaries: Countries and Cities. In the Cities dictionary, the form field 'country' is a picker field from the Countries dictionary.I would like this field to become a hyperlink which would take me to the Country dictionary instance for that country. I was expecting this to work at least in the Dictionary report Cities but it doesn't. For example when creating the Barcelona city instance in the Cities dictionary I selected Spain as a country. After saving I want to be able to (...)

How to display data from another database (added as an MSSQL data source) in a report? How to do this in a new report? Or maybe it could be added to another process report

Hello all, We have implemented a new ticket system called Jitbit and I would like to connect it to WEBCON via REST web service. Unfortunately, I don't understand how to configure a "Basic authentication" or "Token authentication" in WEBCON. Using Postman, the authentication including the queries already worked. Enclosed you can find the documentation from Jitbit: https://www.jitbit.com/helpdesk/helpdesk-api/#/?id=helpdesk-api Could you please help me with the configuration? Many than (...)

hello, I need to migrate local groups from production to dev environment, do you know database table or do you have sql that will show me all local grups, even empty one ? thanks in advance.

Hi, how to set a filter in the data source for a data table so that search-filtering by date works. The usual filtering according to the scheme does not work: 1. "some date (iso or browser settings)" = "field in the data table with a date" (like attachment) 2. "some date (iso or browser settings)" like "field in the data table with a date"

Hi everyone, I tried to connect to one of our sharepoint online sites. For some reason, I get a message that the login or username is not correct. (see screenshot) If I use the same login data for our on-prem Sharepoint 2013, it works fine. (see screenshot) On the Sharepoint online site which I want to connect, I am logged in with my valid credentials and I am both in the member and the owner group. (see screenshots) Our on-prem AD is fully synchronised with MS Entra ID (formerly Azur (...)

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 database 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 of products should change but it doesn't. And also, I can't get the price for the product... (...)

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 information, the list comes empty. Anyone tried this? Do you know how to bring reports instead of (...)

MVP

Hi, We have an issue related to the usage of columns from a datasource (dictionary, BPS internal view) within a choicefield-type field. The user 'windows user' has created a new application, a new process, and a new dictionary. After configuring these, the user created the corresponding datasources for them. They created a new process where they associated the dictionary/process with choicefield-type fields. For data filtering, they used the fields from the datasources as filters. An (...)

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 owner of the Site Collection. What could be the cause of this? Thanks in advance!

Hello. Has anybody an idea if and how it is possible to create a data source from two different data connections? I.e. I have a database (MS SQL) with visitor data and the CacheOrganizationStructure table in the webcon content DB (MS SQL, too). Now I want to create a datasource for a Choice field, where I could query for names in both tables. It is purely for reading data. Kind regards Klaus

Hello all, Does anyone knows or have configured something that can relate the country vs national holidays in the country? Like having the calendars for Portugal Holidays, Spain, etc I know that we have to manually insert the holidays in the System configuration for calendar's table but in this case, the idea is, if I'm abroad and inserting extra hours, by defining where I am, the system could check if it's an holiday or not. Thanks!

Hello all, Does anyone configured an action where the value in a specific column for an item list is a value coming from a datasource different than MS sql server? My idea is, I need to get from an oracle table the rate for a specific employee, so I'm using the action with Datasource = my table and in the advanced filter, I just add the person id and the dates for comparison but this is not working. I've added a screenshot. If I use the field manually, I'm able to get that specific lin (...)

How can I initialize attachments on the item list in the subworkflow? The initializing query retrieves text fields, but does not retrieve attachments. I receive an error message: Validation Error, SubElems (ID: 9031) Attachment not found. SubElems (ID: 9031) Attachment not found.