Questions & Conversations

I'm trying to move our product to the Cloud using this blog post: https://community.thinkwisesoftware.com/blogs-21/to-the-cloud-leveraging-microsoft-azure-paas-155. I'm facing some difficulties regarding the differences between an on-premise environment (SQL Server and a file system) and Azure (Azure SQL Database and Azure File Storage). To start with, it's the difference in handling files. In the on-premise setting I'm able to upload files and read them using methods in SQL Server like xp_DirTree for reading a directory, and openrowset / bulk insert reading the contents of the file. In an Azure environment this isn't possible. Lets say the steps for the end user are currently as following: The user starts a task where it can upload a file using a 'File upload' control. This upload is bound to an Azure File Storage location, so it'll upload immediately. The user executes the task: The sql procedure of the task is called to process the uploaded file. In example the user uploads a

I want to upload a contract for a employee. The file should be stored in a employee folder on the file server. The domain assigned of the file-upload column contains a predefined network path. This path should be variable depending on the employee name. For example: I upload a contract for the employee "NVP\d.vanleeuwen". The uploaded file should be stored in the following file path: \\fileserver\file_upload\Employee\d.vanleeuwen\contract.pdf In this case the path must be created as follows: \\fileserver\file_upload\Employee\@variable_employee_name\@uploaded_file I've created a domain with control_id "File upload" and a file_storage_id who is linked to a storage location on our file-server (For example: \\fileserver\file_upload\Employee\). I've already tried to write and executed the following code for the insert_trigger of the employee_contract table. Unfortunately this doesn't work because it changes the path but does not move the file. code:-- parameters declarendeclare @us

I'm trying to move an on-premise environment to an Azure environment using this blog post: https://community.thinkwisesoftware.com/blogs-21/to-the-cloud-leveraging-microsoft-azure-paas-155. I've deployed the product and IAM databases to an Azure SQL database, and the Web GUI also to an Azure App Service (IIS). This works, but I don't know how to get the images of tasks / filters etc. visible. The help document / blog post isn't very useful for me. https://office.thinkwisesoftware.com/docs/docs/deployment/web_gui.html#images-are-missing The blog says this: Any files that would be on disk will have to be deployed together with the package. This process is a bit like how mobile applications are deployed and how it is currently done by the Web GUI or Indicium developers. Currently, all files in the application model are files on disk and must be packaged. This would be background pictures, icons and report files. I have no clue about how to deploy / package those resource files, I cann

Is the Android version of the Thinkwise mobile GUI compatible with Android 6.0? We have a customer with a tablet that is used as a vehicle board computer that is running on that Android-version.

The SF suite 2019.1 features a validation check "All rights role will become deprecated". It warns a user about the fact that the "all rights" option on a role will be removed in a new version of the SF suite. I was wondering: when this option will be removed, will all the roles, which had this option set tot yes, be converted into a role with full access to every object available within this project (version)?

We are upgrading tot Crystal Reports 2016 for developing (not the viewer). Does version 2016 work fine with the Software Factory?

When I start a report in my TW-application normally I get my report on my screen without any login. Now a login screen (like this) pops up: https:// Whatever I fill in, it doesn't connect to the database server. I get the following pop-up: https:// The application works further fine. I only cannot print any report. Any ideas? SQL 2017 express on a DC with windows server 2016

I have a table assigned a screen type. I want to use the same table with different screen type Or maybe create a Variant and assign the other screen type. I also don't want to use the related table in detailed tab just the main table

I actually have a Screen Type assigned to a Table I have created two view tables I want to assign these two view tables on same screen type for the above table

I have upgraded a project to SF2019.1. I am trying to synchronize to IAM on a different server. Since I do not have a direct connection I am trying to write the synchronization files to disk. Unfortunately I run into an error in the i_sync_project Program object: [Unknown action(Unknown action failed because the specified path is invalid)] I am not sure but I think it may have to do something with one of the warnings in the validation: 'Background picture path is outside the project folder'. This warning is referring to a path specified in the Thinkwise_default theme.: S:\Software_Fabriek\Applicaties\SQLSERVER_SF... I am unable to change the specified path and deleting the theme does not work...it pops up again after generating the definitions.

I have a table for stores I want to create a UI project, where all the stores mentioned in the table have a tab Tab will have store details of the respective stores

We have a new server with SQL server 2016 installed. I would like to relocate our Software Factory to the new location. Simultaneously I would like to rename the database. I was able to backup and restore the iam_ont and sf database to the new server. However, I cannot seem to rename the iam_ont database. When I do, the application wants me to login to the 'old name' iam_ont. All logins fail because the 'old name' database no longer exists. Is there a way to do this?

When I want to start my application as a domain user, I get the following message "Cannot open database "..._IAM" requested by the login. The login failed. Login failed for user 'DOMAIN\\user'." All the domain users work properly, only the users that has been set on "disabled" and later set back to "enabled" have the double backslashes. When I start SSMS i can normally logon to the databases. windows2012R2 SQL2008R2 Can anyone help me on this? Thanks in advance

Hello, I have two fields on a screen ( a text field and a radio button) and I clear the fields in the screen. Text field is made empty and the radio button is made null. When I select a value of the radio button, the text field is defaulted with the previous value before clearing the field. This only happens in the mobile app. How can I prevent the mobile app to default the value of a text field when chaning the radio button?

For a project I'm using Android scanners to scan barcodes. When I tap on a field where the domain has the control barcode, the keyboard pops up like with any regular field. Is it possible to refrain the keyboard from popping up?

Does anybody know (if possible) how to deploy 2-way authentication via the WEB-login? Like SMS-passcode or Google authenticator?

There are two options: 'directly' or 'advanced options'. Choosing 'directly' causes rows from 15 and 30 (and more... ?) height depending of the content of a cell. To avoid this you need to choose for 'advanced' and set 'Tekstterugloop' off. Apparently this setting is 'on' when you choose 'directly'. Is it possible to change this setting to avoid choosing 'advanced' because of the 3 follow-up screens you have to skip before you can choose 'Voltooien' ?

While implementing an application I have the following challenge: I want to change the look-up of a specific field for a variant separately from the default setting for this subject. Unfortunately the custom look-up is disabled and greyed out in the variant settings. Is there a possibility to change it separately for each variant?

We like to show the contents of interface messages in a previewer control. I found out that this is possible with an expression field, with the formula like below and use a domain with control type HTML. ' body { font-family: Calibri, Tahoma, Arial; font-size: 14px; font-weight: bold; } ' + REPLACE(REPLACE(REPLACE(t1.message_body, '<', '<'), '>', '>'), CHAR(10), ' ') + ' ' It is nice, but it does not fully give the desired output. Any suggestions?

Hello, I have a column in a table with a translation object created for this column. If I open the table in Windows it displays the correct name for the column. If I open the same screen in a mobile app it doesn't show the correct name but shows the original field name. All the other fields are translated well. I don't use a tab variant for this table. Is there an option to add the translation object for the mobile app as well?

We are working on a project, where we have to create a calendar with months and respective weeks (Similar to resource scheduler). -Similar to Excel as we can assign work on the specific cell with conditional colors or typing.

How can I get rid of white space behind fields in tasks?

Hi, We have a situation where a 'suggestion-contains' control has a lookup with a couple of prefilters. Now when one of the prefilters is active, the lookup (with the pop-up closed) still only shows items within the prefilter. This feels a bit counter-intuitive, because every time I want an item belonging to another prefilter, I need to open the pop-up and change the prefilters. Is there something I can do to reset the filters every time the pop-up is closed? Thanks.

I am getting data type conflict while saving data below is the query I got when I tried to debug

During the upcycling of an application I got to the following problem: The views has been transferred from the upcycling database into the SF correctly but all the programmed logic behind it so the SQL queries hasn't. What I can do is copy the queries manually from the views in the upcycled database into the SF to make it run there. This is a proper solution if there are only some views. But in my case there are many of them, more than a hundred. Is there any possibility to do this automatically f. e. with a script? That would help a lot!