Skip to main content

Questions & Conversations

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

  • 2,855 Topics
  • 9,841 Replies
2855 Topics
R
Apprentice
RonaldApprentice
asked in Questions & Conversations
Task popup window

We have an strange probleem with the popup field on the web by an task; In IAM the same problem exists that the buttons will disappear, so please advise me what to do?        

1795
R
Apprentice
P
Sidekick
Peter de WitSidekick
asked in Questions & Conversations
Update 'modified on' during merge branche -> trunk

What is the trigger to update ‘modified on’ within templates ? I see in my merged version using Full model, item Templates that when I sort on ‘modified on’ some templates have the same date as in the previous version (Trunk or Branche) and some not. But when I check the needed changes in that templates the changes are there ! It would be much better (and more trustfull...) if every changed templates has the right (=last) ‘modified on’ from Trunk or Branche, depending the chosen merge-action. I read the topic  'How is code history in templates supposed to work?’ but I'm talking about the date modified in the template itself

1154
Bart Metselaar
Moderator
Marcel van Langen
Sidekick
Marcel van LangenSidekick
asked in Questions & Conversations
Requirements to become a certified TW associate?

In the eLearning environment of TW the last step is an exam to become a 'Certified Thinkwise Associate’. At the moment I'm not sure what the requirements are? Is the exam about ALL the courses available, so including SQL and reporting Is it required to have done all the exercises (also from SQL) Are there any other requirements other than the courses available? I'm also curious in what form the exam is held. Open questions, multiple choice, cases etc. Perhaps an example exam to prepare would be nice, maybe that is already available?

2671
Gijs
Apprentice
R
Superhero
René WSuperhero
asked in Questions & Conversations
SF On Premise, End Product (runtime configuration) in Azure, how?

Currently we have the development environment on a local SQL Server Environment (On Premise). The product is targeting the Azure environment (Azure SQL database & App Service). For testing purposes I want to be able to attach a project (branch) to an Azure SQL Database. Problem here is that it's kinda mixed mode: The SF-databases uses the Windows Active Directory (AD), whereas the Azure environment uses ‘rdbms’ users. When I set up the ini file I sort of have the following: metasource = sfserver = dev-serverdatabase = software_factoryauthentication = mswindowsproject = branchlanguage = engrdbms = sqlserverexecutionmode = developer Problem here I use mswindows as authentication. But the Azure SQL Server uses ‘rdbms’. I have a kind of a hack for it; I’ve added the same user/login to the on premise environment with matching name and password. That works, but I would prefer to use different credentials for the Azure environment. Is there a way to do this? Or should I see if it's possib

973
Jasper
Superhero
E
Sidekick
Edwin SaanSidekick
asked in Questions & Conversations
Choose printer in task?

I read the topic how to create a new printer.  That post helped me a lot to print a shipment document to a dedicated printer. But guess what … We have another site where we need to print shipment documents on another  dedicated printer on that site. What’s the best way do do that.. I could create another report pointing to the same report definition and the only thing that changes is the printer. Or is it possible to create a report parameter where you can let the user choose the printer and by calling the report this printer is send to the report. So can I overwrite a report property (the printer) with a report parameter value. In that case I should create a table or a domain with printers to let the user choose in a drop down.  (And why is the field related topics filled with ‘Introduction to Machine Learning Services on SQL Server? Will the machine decide it self which printer to use, that would be awsome :-)   I can’t change that)

1113
Erik Brink
Moderator
E
Sidekick
Edwin SaanSidekick
asked in Questions & Conversations
Dynamic user filter used on opened tabs for the same subject

We have the following requirement: We would be able to let the user set a use filter for f.e. an ordernumber. The user can open the orders tab/document and set the filter. The filter data is stored in an employee_filter record in the application The next step is to let the user open a new  tab/document - also orders - and the user set the filter to another order_number so he’s able to work on 2 different orders in one moment.  So the 2nd should not affect the first opened tab.  The problem is when setting the filter for the 2nd opened tab, de data on the 1st opened tab is changed conform the new filter when pressing F5 (refresh)  We store the filter data in the application database per user.. A pre filter on the orders subject takes care of selecting the data based on the user filter as set in the application. At this moment we have 1 employee_filter record with user filter data. We could create more but the problem is that we are not able to assign a specific filter record to a specif

1103
Frank Wijnhout
Thinkwise blogger
K.Bakkenes
Captain
K.BakkenesCaptain
asked in Questions & Conversations
Creating IAM users via an EndProduct

The users in our EndProduct can create employees for their company within the application. We have a task that creates a relation + an employee record. In addition to creating an employee we would like to be able to create an IAM user with the information and credentials the user has supplied. So we made a subroutine called ‘create_iam_user’. This subroutine does inserts/updates on the IAM database. After creating an employee record the subroutine will be executed. But when it does, we get the following error in return. The users in our EndProduct have no rights on the IAM database and the ‘User Admin’ rights are not granted. I tried altering the procedure to execute it as OWNER or as a SQL login that does have ‘User Admin’ rights. After changing the procedure the execution (via SSMS) of the procedure succeeded with a SQL login that has no IAM rights. However when trying to execute the procedure via the EndProduct user we still receive an error. Why doesn’t the ‘EXECUTE AS’ method work

2871
Frank Wijnhout
Thinkwise blogger
John Sangers
Apprentice
John SangersApprentice
asked in Questions & Conversations
Windows GUI on Microsoft RDS Server

We use a VDI solution for remote workers and need to know if we can move to a solution using Microsoft RDS servers with remote desktops or remote apps. Does anyone have experience running the SoftwareFactory Windows client on such a system? According to the documentation this is supported and “Depending on the amount of data and the use of the application the Windows GUI requires between 30 and 100 megabytes (MB) RAM memory per user.”. If you have experience in running the Windows GUI on RDS how many concurrent users can you run on each server and do you have any issues with memory, USER object or GUI object usage?  

1907
G
Vanguard
Mark Jongeling
Administrator
Mark JongelingAdministrator
asked in Questions & Conversations
Showing Caps lock warning when logging in on Web GUI application

Is it possible to enable a warning to tell the user if their Caps lock is turned on?    I know that the Windows GUI does have it but I don't seem to be seeing it nor being able to enable it for the Web GUI, hence the question. Kind regards, Mark Jongeling

351
Erik Brink
Moderator
Hugo Nienhuis
Superhero
Hugo NienhuisSuperhero
asked in Questions & Conversations
DBCC CHECKDB error in Software Factory database

I performed a DBCC CHECKDB on our databases and it found an error in our SF database: Msg 8947, Level 16, State 1, Line 1 Table error: Multiple IAM pages for object ID 349973069, index ID 1, partition ID 72057598823759872, alloc unit ID 72057598842699776 (type In-row data) contain allocations for the same interval. IAM pages (1:396048) and (1:292862). CHECKDB found 1 allocation errors and 0 consistency errors in table 'linked_project' (object ID 349973069). CHECKDB found 1 allocation errors and 0 consistency errors in database 'DB_software_factory'. repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (DB_software_factory). I have no clean backup and the DBCC is not able to repair the error. I can do a clean install of the SF, but I will need to export/import the projects. Is this possible? Are there other solutions, like replacing the 'linked_project' table?

2574
Hugo Nienhuis
Superhero
E
Sidekick
ericbosmanSidekick
asked in Questions & Conversations
SQL server 2019 support

Dear Thinkwise, Soon we want to install and use SQL server 2019. (Available since 4 nov 2019) We work with SF 2019.1, IAM 2019.1 (and higher), Indicium 2019.1.7 (and higher), WebGUI 2019.1.11 (and higher). On your website you only show support for SQL Server 2019 RC. (https://docs.thinkwisesoftware.com/docs/2019.1/kb/lifecycle_policy.html#microsoft-sql-server) Can you confirm that SQL Server 2019 in combination with the above named products is also supported? Yours sincerely, Eric

811
Jasper
Superhero
Hugo Nienhuis
Superhero
Hugo NienhuisSuperhero
asked in Questions & Conversations
export font settings to excel

Hi,   When exporting a grid to Excel the data will be shown in Excel with the standard Calibri font. I would like to see my data appear with the Tahoma font. When I change the default font in Excel to Tahoma, my data still appears in Calibri. Is this because the grid is exported with a standard lay-out using Calibri? If so, can I change this to Tahoma? Or do I have to use conditional formatting to change the ‘export’-font? I would like to do this for all grids by default.    

1622
Hugo Nienhuis
Superhero
R
Hero
RolandHero
asked in Questions & Conversations
Style SVG's used in image combo and other places

The Thinkwise suite adapts colors of SVG icons to the menu items and tabs they’re used in. That’s a really nice feature. But how do I color SVG icons in other places such as image combo’s and prefilters? Of course I could color SVG’s manually but I much rather control this in other ways such as themes and conditional layouts. I’ve tried conditional layout but it only affects text unfortunately. I would also like to be able to add padding to icons. The only way I have seen so far to make icons in a grid smaller is by making the column narrower but that’s not always an option. We’re on version 2019.2.

941
Jasper
Superhero
O
Vanguard
Onno SpoorVanguard
asked in Questions & Conversations
Set focus within mobile apps

Is there any easy way to set focus on fields within mobile apps. The layouts don't seem to work.

1043
Leroy Witteveen
Moderator
Harm Horstman
Superhero
Harm HorstmanSuperhero
asked in Questions & Conversations
Combined Filter Conditions

For big dataset it could help a lot for the performance to avoid using 'LIKE’ in where clauses. I expected a different behavior, depending on 'Filter Condition’  Example: Combined filter value: 2019 2020  Result:    SELECT .. FROM .. t1 WHERE (t1.[ACC_YEAR] LIKE '%2019%’) or (t1.[ACC_YEAR] Like '%2020%’) Should be: SELECT .. FROM .. t1 WHERE (t1.[ACC_YEAR] = 2019) or (t1.[ACC_YEAR] = 2020)  

1394
Harm Horstman
Superhero
P
Captain
Peter KruisCaptain
asked in Questions & Conversations
Offline functionality testing

Is it possible to test offline functionality in the 'debug viewer’.

1084
P
Captain
R
Apprentice
RonaldApprentice
asked in Questions & Conversations
task paramter

Hi all, Can someone explane what the purpose of the “Task parameter tags” and how it works. This can be found by the tasks.   There is no documentation avaibele on this subject yet.   Regards   Ronald Gombert  

1103
Mark Jongeling
Administrator
P
Captain
Peter KruisCaptain
asked in Questions & Conversations
Last opened screens

Is there a way for a user to see which screens and records he has opened lately, with the possibility to navigate to them right away?

632
P
Captain
Johan van Eijsden
Captain
Johan van EijsdenCaptain
asked in Questions & Conversations
Reset password

A user of the web GUI wants to create a new password for his user account. The authentication methode is “IAM” and login verification is set to “Password” in IAM. Because we host the application on our IIS for multiple customers, we are the administrator of IAM for these customers. I know I can set a new password in IAM myself, but I do not want to know the users password. So I want to let him change the password himself. The settings “Allow change” in IAM is set to “True”  and Expires is set to “Change after login”. The user is able to set a new password in the following form:   After changing the password, the following message appears: So far so good. But when trying to login with the new password, I get an error: But the user can login with his original password, so the change/update did not work! Same problem when trying to reset the password via the option “Change password” in the blue tab.     The Application Pool user has owner rights on the database, so that should not be the

1957
Johan van Eijsden
Captain
eurban
Captain
eurbanCaptain
asked in Questions & Conversations
Sql SEQUENCE

how to create sql sequence in SF 

1134
eurban
Captain
A
Vanguard
AshwiniVanguard
asked in Questions & Conversations
How do I set a table as a start object or landing page when ever a user logs-in

I have multiple users and I have to assign opening objects or landing page as per the users.. eg: buyer, supplier, management etc. When ever a specific role user logs in, he/ she is suposed to land on respective screens.

1191
Mark Jongeling
Administrator
Mark Jongeling
Administrator
Mark JongelingAdministrator
asked in Questions & Conversations
Expand/Collapse all items in Resource tree view - Resource scheduler

Is it possible in some way to expand and collapse all items in the Resource tree view with the Resource scheduler? Currently the resource tree is fully expanded by default but I would like to be able to collapse them all in one go if possible.

1192
Mark Jongeling
Administrator
Jop ter Horst
Vanguard
Jop ter HorstVanguard
asked in Questions & Conversations
Colorless SVGs

The Windows GUI can recolor black SVGs to match the label color, but the Universal GUI needs SVG's with no color. Should I uncolor all my SVGs or should I wait for a Universal release which fixes this?

1242
Jop ter Horst
Vanguard
Hugo Nienhuis
Superhero
Hugo NienhuisSuperhero
asked in Questions & Conversations
Mobile - username and password combination is incorrect

Hi,   I am trying to get an application for mobile up and running. I have made a small test application and deployed it on a test server using our test_iam. When trying to log in using the desktop viewer I receive the above error. The network tab in debug shows no error. Using insomnia I am able to login to retrieve the metadata using the same credentials. The IIS and indicium are working fine, we are also using it for communication with our webshop. I checked all iam user settings, but they seem fine since I can start the application with the desktop GUI as well. screen login:   What am I doing wrong here?  

1194
Hugo Nienhuis
Superhero
D
Vanguard
Dennis BeerenVanguard
asked in Questions & Conversations
Drawback of using unique index on column

Although I didn’t learn about this in my standard SF training I recently found out that there is a way in the SF to make a column unique by creating a unique index. See picture below:   I wonder if this is common practice when one needs a value in a column to be unique? Are there any drawbacks that I have to take into account? I also wonder why this option isn’t available when creating the column?

1352
D
Vanguard

Badges

Show all badges
Terms & ConditionsCookie settings