Cezary, you can use openrowset function from ms sql. https://www.sqlpedia.pl/import-danych-z-excela-do-bazy-sql-server-za-pomoca-t-sql/ https://www.mssqltips.com/sqlservertip/6178/read-excel-file-in-sql-server-with-openrowset-or-opendatasource/
The current version of the API allows updates for the following fields: { "name": "string", "email": "string", "phoneNumber": "string", "managerBpsId": "string", "jobTitle": "string" } It would be useful to expand the user API to include fields such as: - Department - isAct
Will you also be carrying out the action of splitting one PDF containing, for example, 10 pages into 10 individual PDFs? In other words, splitting the document?
In WEBCON SDK add-ons, there is WebCon.WorkFlow.Extensions.GDPR -> Removing attachments (The action completely removes attachments with history.) Have you tried this action?
Attachments in the table [BPS_Content].[dbo].[WFAttachmentFiles] were stored there when using the Express WEBCON license. When upgrading to an Enterprise license, a dedicated database for attachments is created, which is why newer attachments may be in the database [BPS_Content_Att].[dbo].[WFAtta
Hi, can someone from the community share information on how to properly create an OCR project for recognizing foreign invoices, e.g., German, Czech, Slovak invoices? How did you handle this?
If you need to generate more than 998 rows, the best way is as Recula wrote, but specify the data table attribute when generating the Excel file.
Currently, if a company has several content databases, for example 5, and users need to be synchronized across each database, the data is stored in 5 tables * 5 databases, resulting in the same data being present in 25 tables. CacheOrganizationStructure CacheOrganizationStructureExtendedTokens
A good and useful option for system users would be the ability to create filters on a column using a narrowing phrase. For example, by entering the phrase "BX2TD6" in the column filter with the function "contains phrase," users could create such a private view without having to mark each result. Eac
Hi Maksymilian, It depends on the process. In one process, data is updated based on another system, in other processes, many users make entries.
You can synchronize one person from system settings -> Users and groups synchronization -> search one person -> right click on person and synchronize
The history of items sometimes contains from several to several hundred or several thousand items. A proposal to add the possibility of presenting the last 5-10 history elements, because with hundreds of history elements a timeout error is received.
Hi Ajnar Try to generate new index for all process Reports -> Solr indexer queue -> Add -> Clear and reindex process or entire database - All process This takes time depending on the amount of data After this show you queue index
Hi ANDREELL B If i good understand, you have in WFD_AttText1 - WFD_ID from first ID. Try replace in calculated column from "wfd_id=3557" to " wfd_id=wfelems.WFD_AttText1"
Hi Damian In folder where you install solr, you have file "WebCon.BPSSearchService.exe.config" and in you can change 2g
Hi Check filed (Rating scale or Choice list (multiselect option you can get))
Hello, I try update webcon with SharePoint Foundation 2013 Update Webcon from 2021_1_4_55 to 2021_1_5_367 and i have error with webcon.sharepoint.core.wsp. Deploy solution dosent work Anyone know why this happen? Solution Deployment : Looking for 'ReceiverClass' attribute in manifest root no
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?
Hi, At the end in sql statement add "Order by ID"
Hi, I also confirm this case and for smaller 50k + reports also if there is grouping after the "assigned to" column, the loading is 10 times slower as it was before the current version 2021.1.4.84.