Data sources

Problem with connect external database

0 2

Hi, I add new connection (MSSQL database) - test it with success. Next I add new data source with some SQL query which returns some data when I test it. If I save that connection Webcon shows the error: "Failed to retrive column from data source XXX. No connection settings." If I want to test that data source in choice form field I've returned: Nieznany błąd: The ConnectionString property has not been initialized.. Does anyone have some idea what I should do to fix it? Than you (...)

SQL: Unknown error:Incorrect syntax near ')'...

0 6

Hi there, does anybody know why this error occurs? Happens the following way: - Business rule retrieves datasource column (from [CacheOrganizationStructure]) COS_AD_name by means of a form field value (see 1.png) - Rule works fine if clicked on 'Test' button - This business rule is used in the cyclical action 'Update related workflow instance' with the goal to update a workflow's form values on an interval (thus using 'Change value of single field is not available as an action) - In (...)

Import-Export Template Process with zip archive - ERROR

2 1

Hello, I tried to import some templates from DEV environment to TEST environment and when I uploaded the .zip archive the following error occured on the .xlsx report: "Value cannot be null. Parameter name: securityProvider" Does anyone know why do we get this error? Thanks!

Active Directory Contacts as Data Source

0 7

Hi everyone, Does anyone has an idea on how to retrieve all "objectClass=contact" from Active Directory and use the result as a Data Source? Thank you.

Stored Procedure as Datasource

0 2

Hello. Is there a way to use a stored procedure as datasource instead of a view or table or Select statement? I use at the moment a query on two tables (UNION) which has an inner join on another table. The speed is not really breathtaking, thus I wanted to use a stored procedure where I can perform all the timetaking steps already on the SQL server. Regards Klaus

Integration with Sales Force

0 4

Hello Community, Does anyone established the connection between Sales Force and Webcon? I have all the documentation on the Webcon side for the REST API but I'm finding some difficulties on the Sales Force side as I'm not sure on where and how to configure the necessary steps to get the connection between the 2 systems. Thank you all for the attention!

Datarow is not updated after deployment

0 0

Hi community! We implemented a document template with certain fields coming from a custom datarow (based on SQL-Query). We deployed the solution and the document template to PROD and everything was fine. After that we added one new field to the datarow (SQL query was modified) as a new requirement and added the new field also to document template. On DEV system everything looks fine, we deployed the solution to PROD and suddenly this new field is missing in Word Add-In (in the selection of d (...)

Initialize Item List with SQL Query from Oracle DB

0 4

Hello all, Does anyone configured an Item List to be initialized with a SQL query that will query from another database? In this case I want to query from an Oracle DB and initialize the columns with the columns from the query: select milestone as {DCNCOL:185}, milestone_date as {DCNCOL:186}, amount as {DCNCOL:187}, currency_code as {DCNCOL:188}, amount_euro as {DCNCOL:189} from PL_Invoicing I'm trying to this but it's not working. Hope anyone has ideas for this! Thank yo (...)

Interact with Microsoft Business Central

1 1

Are there best practices how interaction with business central (formerly known as MS Dynamics NAV) can take place? What would be the preferred interface? I remember a communication with Webcon where comon data source was mentioned. Where are we here?

Start Workflow using Sharepoint Library

0 1

Hi all, I'm taking some time to explore the possibilities of Sharepoint and Webcon. I have a process set up to approve internal documents and they need to be renewed after 1 year from the previous date. I was trying to set up the beginning of the process in the Library List (and in the future use the renewal date do display the Start Workflow option for the line) and took the example of https://community.webcon.com/posts/post/starting-workflow-from-the-sharepoint-document-library/54 (...)

Add Item List for Sharepoint Calendar

0 2

Hello all, Does anyone set up an action to add items in a Sharepoint Calendar? I'm using this https://howto.webcon.com/sharepoint-calendar-adding-entries-from-bps-workflows/ to help in the configurations and I'm able to send the information to Sharepoint: Message Log for my Action Message Address of a Sharepoint list: https://visionboxdomain.sharepoint.com/sites/customers/Lists/Calendar Inserting values: Title: Renovation Doc, Location: PT, EventDate: 3/12/2021 12:00 AM, EndDate: 3/14/ (...)

SQL-Query for short Workflow History Data-Source

3 1

Hi all, i thought it might be a good idea to share useful queries that should be reusable for any of us as they are. Although I personally find the built in Workflow-History very useful and really like it for admin-purposes, it might be some kind of an detail-overkill for common users. In order to give users a more simple look of what happened so far in the workflow, I created a datasource that should work for all workflows and translations. Values are shown depending on the users browser la (...)

Problem with using WEBOCN with external SQL in Master Data Management

0 2

We are implementing a solution of Master Data Management and are trying to use Webcon as a User interface with all the logic behind forms. The database is prepared in MS SQL with different tables. The challenge we are having is to update entries with foreing keys. Scenario: Table 1: Country has one column (apart from ID) – 'Country' Table 2: City has two columns 'Country ID' (Choice column from table Country) and 'City' So in City table, we have one foreign key that shows on Country table. (...)