Skip to main content

Questions & Conversations

Software Factory & IAM (Installation, Development, Deployment, Integration) | E-learning | Documentation | Community

  • 2,800 Topics
  • 9,679 Replies
2800 Topics
R
Superhero
René WSuperhero
asked in Questions & Conversations
Moving to Azure SQL database & Azure File Storage

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

8594
R
Superhero
Dennis van Leeuwen
Hero
Dennis van LeeuwenHero
asked in Questions & Conversations
How to make a File Storage path variable?

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

2582
R
Superhero
R
Superhero
René WSuperhero
asked in Questions & Conversations
Images of tasks / filters / resources etc. visible on Azure

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

1204
R
Superhero
John Lunenburg
Apprentice
John LunenburgApprentice
asked in Questions & Conversations
Compatibility Thinkwise mobile GUI

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.

372
John Lunenburg
Apprentice
Arjan Sollie
Thinkwise blogger
Arjan SollieThinkwise blogger
asked in Questions & Conversations
All rights role will become deprecated

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)?

1152
Arjan Sollie
Thinkwise blogger
Guido Speelziek
Apprentice
Guido Speelziek
asked in Questions & Conversations
Crystal reports 2016 compatible with Software Factory?

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

942
Guido Speelziek
Apprentice
M
Sidekick
Marco KleiwegSidekick
asked in Questions & Conversations
Crystal Reports pops up with a login screen

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

1561
M
Sidekick
A
Vanguard
AshwiniVanguard
asked in Questions & Conversations
How do I or Can I Assign Screen Type to a Variant table?

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

1171
Mark Jongeling
Administrator
A
Vanguard
AshwiniVanguard
asked in Questions & Conversations
How to assign multiple view tables in one UI screen?

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

2676
Mark Jongeling
Administrator
Hugo Nienhuis
Superhero
Hugo NienhuisSuperhero
asked in Questions & Conversations
Error using Write to disk feature

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.

1242
Hugo Nienhuis
Superhero
A
Vanguard
AshwiniVanguard
asked in Questions & Conversations
Can I create tabs in UI for different stores from store table?

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

993
Anne Buit
Community Manager
Hugo Nienhuis
Superhero
Hugo NienhuisSuperhero
asked in Questions & Conversations
Renaming / relocating the IAM_ont database

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?

903
Anne Buit
Community Manager
M
Sidekick
Marco KleiwegSidekick
asked in Questions & Conversations
Can anyone help me with double backslash in domain username

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

7454
M
Sidekick
R
Apprentice
Rémon BalApprentice
asked in Questions & Conversations
Radio button in mobile app

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?

1153
Jasper
Superhero
Jop ter Horst
Vanguard
Jop ter HorstVanguard
asked in Questions & Conversations
Hide keyboard when barcode control

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?

1361
Jasper
Superhero
E
Sidekick
Edwin SaanSidekick
asked in Questions & Conversations
2 way authentication on WEB

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

992
Erik Brink
Moderator
P
Sidekick
Peter de WitSidekick
asked in Questions & Conversations
Export Excel from TW-application

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' ?

1351
Jasper
Superhero
H
Rookie
Hauke Albertsen
asked in Questions & Conversations
Change look up for a specific variant

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?

1322
H
Rookie
Harm Horstman
Superhero
Harm HorstmanSuperhero
asked in Questions & Conversations
Show text (CSV, HTML, XML, JSON, etc..) in Document previewer

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?

2454
Harm Horstman
Superhero
R
Apprentice
Rémon BalApprentice
asked in Questions & Conversations
Translation not visible in mobile app

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?

1587
Jop ter Horst
Vanguard
A
Vanguard
AshwiniVanguard
asked in Questions & Conversations
Creating a Editable Calendar

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.

2071
Moller Toma
Captain
Harm Horstman
Superhero
Harm HorstmanSuperhero
asked in Questions & Conversations
White space in tasks

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

1041
Jasper
Superhero
R
Apprentice
RonyApprentice
asked in Questions & Conversations
Look up pre-filters stay active

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.

4088
M
Sidekick
C
Rookie
ChandanKaviRookie
asked in Questions & Conversations
Error while saving data

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

2478
Mark Jongeling
Administrator
H
Rookie
Hauke Albertsen
asked in Questions & Conversations
Copy queries from views in upcycled databases

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!

1441
Kevin Horst
Thinkwise blogger

Badges

Show all badges
Terms & ConditionsCookie settings