Skip to main content

Questions & Conversations

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

  • 2,917 Topics
  • 10,067 Replies
2917 Topics
E
Sidekick
efitskieSidekick
asked in Questions & Conversations
How to automate login to universal to download deployment scripts

We have deployed the Software Factory to Azure. With the new 2022.1 release we are unable to save the deployment .sql scripts. As workaround (or improvement) we can download the files from indicium (/iam/sf/code_file?$filter=project_id eq '<project>' and project_vrs_id eq '<project_version>' and code_file_generated_code ne null&$select=code_file_id, code_file_generated_code) I would like to automate the download process, but struggle to get the login token from indicium. How do i programmatically authenticate to indicium to download the deployment scripts?

1226
E
Sidekick
J. de Lange
Hero
J. de LangeHero
asked in Questions & Conversations
Change detection @col parameter not filled.

Hi, I’m struggling with the change detection. It seems that our @col_id parameter doesn’t get filled (always null). In the docs it says that the column will only have a value when the logic is called if the table to which the column belongs, is shown as a detail. In our case we display the grid of a table and we have the form of this object under a detail tab. Context, layout and default procedures have no problem reading our @col_id but in the change detection, the value is always null. I thought the primary key columns of an object would be available and filled when a detail tab is opened or a row is selected. Is this not the case? Is there a way around this? I would rather not refresh all objects whenever one object gets changed.

1595
Anne Buit
Community Manager
Freddy
FreddyThinkwise Local Partner Brasil
asked in Questions & Conversations
How to recursively call HTTP connector?

For our demo App we are utilizing API's that have to be called per row. So we have 28 states and to get my data I want to have a solution that checks which data is missing and then automatically fetches this data per state in this case. Same goes for a company with multiple locations… how do i get my App to automatically get all the coordinates for these locations? Basically a cursor for the HTTP connector. I've tried another solution in the community to go to the first row and then cycle to the last.. but it didn't work because the key values are not passed on and secondly it's a GUI action so the user has to wait until the GUI visually went through all the locations. Any suggestions on how I can subsequently invoke a http connector based on a query result?

825
Freddy
Freddy
FreddyThinkwise Local Partner Brasil
asked in Questions & Conversations
Max number of geo locations with Maps component?

HI. I have a company with 49 active locations… but I cannot seem to show them all on the map. Is there a limit somewhere defined? And how do I overrule it?

503
Freddy
Blommetje
BlommetjePartner
posted in Questions & Conversations
Drag & Drop destination table

Hi, I have a table ‘contract’. I have a table ‘charges’. I’ve created a connecting table ‘contract_charges’ I want to enable Drag&Drop so that the user can easily select (multiple) charges, drop them into the connecting table, and there see an overview of all connected charges for that contract. I’ve created views based on the tables. I open ‘contract’, and show both ‘charges’ and the connecting table as detail. The view for ‘Charges’ is a select * from charges cross join contract. When I drag to from ‘charges’ to table ‘contract’, the task works ok. The row shows in ‘contract_charges’ - however, I think it is counter-intuitive to drag to ‘contract’. I want to drop them into the connecting table. When I try to do this, SF automatically sets both parameters to ‘Check for equality’. This is due to the fact that the parameters exist in both tables(?). If I remove contract_id from the view, it won’t show as a detail (; therefore the cross-join). Can I create a workflow where you can drop i

844
Mark Jongeling
Administrator
Freddy
FreddyThinkwise Local Partner Brasil
asked in Questions & Conversations
Thinkstore problems?

I keep getting asked to login.. and I am 100% sure the credentials are correct.

925
Mark Jongeling
Administrator
Freddy
FreddyThinkwise Local Partner Brasil
asked in Questions & Conversations
Universal GUI - Maps

Hi. Is there more elaborate documentation available on the Maps component for the Universal GUI? I've read the docs and some postings here, but can't figure it out how I should set it up. And is there also a listing of supported Maps providers? Before I used MapQuest, does this still work?

21910
Freddy
M
MatteoSangiorgiPartner
asked in Questions & Conversations
Cube screen type on Web: load all records

Is there a way to load all records in a Cube screen type using Web interface? I do not want to switch every page, i’d prefer to scroll down all records as in windows Gui. Is there a screen component I could use?

411
Anne Buit
Community Manager
E
Sidekick
ericbosmanSidekick
asked in Questions & Conversations
Application Insights - ‘snapshot debugger’.

Edited by moderator - Translated to English: We are currently investigating what Application Insights can do for us. We also run into the fact that there is something like a 'snapshot debugger'. As far as we currently understand it, the Snapshot debugger makes it possible to trace all events before and after the occurrence of an error. We believe this could be of great help in analyzing problems. Is the snapshot debugger from Indicium-Universal supported? The documentation I found on this from Microsoft is: https://docs.microsoft.com/nl-nl/azure/azure-monitor/app/snapshot-debugger https://docs.microsoft.com/nl-nl/azure/azure-monitor/app/snapshot-debugger-vm?toc=/azure/azure-monitor/toc.json Wij zijn momenteel aan het onderzoeken wat Application Insights voor ons kan betekenen. Daarbij lopen we er tegen aan dat er iets bestaat als ‘snapshot debugger’. Voor zover wij het momenteel begrijpen wordt het mbv de snapshot debugger mogelijk om alle events voor en na het optreden van een fout te

872
E
Sidekick
Freddy
FreddyThinkwise Local Partner Brasil
asked in Questions & Conversations
Database field with SVG image, how to show in Universal

Database field (VARBINARY) with SVG image, how to show in Universal

752
Freddy
E
Sidekick
Edwin SaanSidekick
asked in Questions & Conversations
Printing labels on Zebra printer

Has anyone dealt with printing labels on a Zebra Printer. With 2 of my clients I have the same issue that I cannot use the full width of the label. The label is automatically scaled to about 70% of it’s label size. And whatever setting I do, I just does not use the full width of the label. I have created reports in as well Dev Express as SSRS and both have the same problem. With DevExpress If I print my label on a HP Laserjet on A4, the label size is correct. If I print it to the Zebra printer the label is scaled to about 70%. I have contacted Zebra and they told me that the paper size of the label is not correct, but I setup the paper size of the label correctly in Dev Express and in the printer driver itself (I’m getting a bit nuts of this) The label size is 105 x 83. I already tried to change every single parameter step by step, but the label is still scaled to about 70%. The last attempt was a bit bigger but still 3-4 centimers of the label is not used. Preview in DevExpress Page s

3812
E
Sidekick
Freddy
FreddyThinkwise Local Partner Brasil
asked in Questions & Conversations
Universal GUI: Everything in detail tab gets selected and first row not visible

Hi. I created a detail (view) and for some reason when I open it the first row stays blank and the rest gets selected.. which I cannot undo. When I change the sort order it starts showing the first row. In the debug screen I find it odd that with every click on a record in this detail.. a layout() is called..

272
Freddy
T
Apprentice
Thomas OfmanApprentice
asked in Questions & Conversations
Best practices on managing old project versions in the SF

The database of our SF is starting to become a little too big for our liking, and this may result in slower upgrades whenever Thinkwise releases a new version. When we first started using Thinkwise software, we were told it was not necessary to delete any old versions, as one could lose some history in for instance the template code history. I was wondering whether there are any updated best practices or recommendations from Thinkwise on how old project versions and branches can managed.

442
T
Apprentice
R
Hero
RolandHero
asked in Questions & Conversations
Subflow not working - not supported?

This is the first time I’ve tried a subflow. I made sure the flow parameters are fed with the values from the main process flow. However it doesn’t run. When I check debug info in the gui it says: “ExecuteSubFlow is not supported in the Windows or Web gui” Does this mean subflows don’t work at all? We’re on the latest 2022.1 version.

901
Mark Jongeling
Administrator
K
Vanguard
kensonlatchmansingVanguard
asked in Questions & Conversations
Tab page in Universal

Hi, Lately I have been trying to group some fields in my form component to another tab. This is very easy to do in web/desktop gui (img.1). img. 1 But now I’m trying to achieve the same thing in Universal but just can’t seem to figure it out. My form component in Universal is as seen on img. 2 img. 2 Keep in mind I would like do achieve this without adding another table. Is there a way I can do this for Universal GUI? Thanks.

971
Mark Jongeling
Administrator
ElenaTodirenchi
Vanguard
ElenaTodirenchiVanguard
asked in Questions & Conversations
Copy some values from selected column

Hello, I want to create a new row in my table with certain columns from another row. It is possible?

551
Mark Jongeling
Administrator
Freddy
FreddyThinkwise Local Partner Brasil
asked in Questions & Conversations
Process flow to send report (SRSS) to an email

Anyone has experience with how to set up the flow, especially how do I catch the generated PDF from de start_table_report to be able to send it by email? Where does it, by default, get saved?

20112
Freddy
Hugo Nienhuis
Superhero
Hugo NienhuisSuperhero
asked in Questions & Conversations
HTTP connector - encoding - nvarchar

I am using the HTTP-connector to sent a message with content-type application/json. I use a nvarchar(max) variable for the content input. I would like to know whether the http-connector sends the message UTF-8 encoded or UTF-16 encoded. I would like to use a Content-Type application/json; charset=utf-8 but I suspect I have to encode the content as UTF-8. Is this best done using a varbinary(max) or should I do this in a different way? Hope anyone can help.

952
Hugo Nienhuis
Superhero
Dennis van Leeuwen
Hero
Dennis van LeeuwenHero
asked in Questions & Conversations
Indicium | 422 - Unprocessable Entity Error Code

When executing a JSON request (by Postman), I get an 422 - Unprocessable Entity Error. In the Indicium log, the following error message can be traced. What does this error mean? [DBG] Endpoint '"{metaSourceAliasOrID:length(2,3):regex(^iam$|^api$|^sf$)}/{guiApplAliasOrID}/{**odataRoute}"' with route pattern '"{metaSourceAliasOrID:length(2,3):regex(^iam$|^api$|^sf$)}/{guiApplAliasOrID}/{**odataRoute}"' is valid for the request path '"/iam/test/customer"' (430aaaf2)[DBG] Endpoint '"{protocolSegment:length(4,5):regex(^odata$|^open$)}/{metaSourceAliasOrID:length(2,3):regex(^iam$|^api$|^sf$)}/{guiApplAliasOrID}/{**odataRoute}"' with route pattern '"{protocolSegment:length(4,5):regex(^odata$|^open$)}/{metaSourceAliasOrID:length(2,3):regex(^iam$|^api$|^sf$)}/{guiApplAliasOrID}/{**odataRoute}"' was rejected by constraint '"protocolSegment"':'"Microsoft.AspNetCore.Routing.Constraints.LengthRouteConstraint"' with value '"iam"' for the request path '"/iam/test/customer"' (5b506098)[DBG] Endpoint '

1593
D
Moderator
E
Sidekick
ericbosmanSidekick
asked in Questions & Conversations
Universal-GUI and Cors

Dear Thinkwise, Because the Universal-GUI uses the cache of the browser it is not allowed to have more than 1 webapplication of the universal-gui in 1 sub domain. But I’m having now: http://ericwebsite.acto.nl/acto-d-upgradetest-evo-indicium-universal http://ericwebsite.acto.nl/acto-d-upgradetest-evo-indicium http://ericwebsite.acto.nl/acto-d-upgradetest-evo-universal-gui So I want to change our IIS structure to support this. What I want to do is creating the next structure: http://ericwebsite.acto.nl/acto-d-upgradetest-evo-indicium-universal http://ericwebsite.acto.nl/acto-d-upgradetest-evo-indicium http://acto-d-upgradetest-evo-universal-gui.acto.nl This structure needs to use the ‘CORS’ possibilities of IIS/Thinkwise My questions is: do you support these new structure? And if so: how do I enable the CORS in this structure? I have read about CORS and indicium and found the next instructions and I tried them on the appsettings.json of indicium-universal, but these doesn’t seem to work

1958
Freddy
Randolph Beekman
Vanguard
Randolph BeekmanVanguard
asked in Questions & Conversations
Example REST API Multipart Form using msxml2.xmlhttp

Hello all, Does anyone have an example of an t-sql request against a REST API with a Multidata/Form? We already call several REST APIs, but not with Multidata/form. Below is a setup (which does not work). The API converts a PDF document into fields in json format. It contains 2 fields that must be included: name (name of the document) document (base64 encoded string) Below is a first attempt, but it does not work :-). Thanks in advance for the reactions. declare @response table (txt nvarchar(max)); declare @object int , @url_endpoint nvarchar(200) , @response_format nvarchar(5) , @request nvarchar(250) , @json nvarchar(max) , @address address , @body varchar(max) , @status int , @document_file_name nvarchar(200) , @base64_document varchar(max) , @content_type varchar(100) , @status_text nvarchar(32) set textsize -1 set @url_endpoint = 'endpoint' set @document_file_name = 'document.pdf' set @base64_document = -- the base64 content set @content_type = 'multipart/form-data'; set @body = c

40609
Robbert van Tongeren
Thinkwise blogger
T
Apprentice
Thomas OfmanApprentice
posted in Questions & Conversations
Add index in SF for performance optimization in IAM synchronization

We are looking to upgrade our TW software to version 2022.1, and during my tests I encountered some performance issues while synchronizing our latest version. Our performance monitor pointed towards the function look_up_chain_granted. This function is called around 1.5 million times, as our application contains a high amount of Roles. At 1.25ms per execution this could take a very long time. The performance index suggested adding the index stated below and this decreased the avg execition time to 0.075ms, which helped with decreasing the total sync time from almost one hour to just ten minutes. I would suggest Thinkwise take a look at this suggestion as it has helped us very much. CREATE NONCLUSTERED INDEX [<Name of Missing Index, sysname, >] ON [dev_sf_upgrade_test_2022].[dbo].[ref_col] ([project_id],[project_vrs_id],[target_col_id]) INCLUDE ([abs_order_no])

493
Mark Jongeling
Administrator
Rucha Naik
Rucha NaikPartner
asked in Questions & Conversations
Can Universal GUI used without user_id and password

The project I am working on needs to fill a form (which is developed in SF) by the candidates. This form will be sent as the link to the candidate in an email. When the candidate clicks this link it should take the candidate to the form. My question is : If the candidate does not have the log in details for SF , can he still open and save his data through the form? Can the universal GUI url open without user id and password?

433
Mark Jongeling
Administrator
Freddy
FreddyThinkwise Local Partner Brasil
asked in Questions & Conversations
Universal GUI Business Intelligence

Hi. I am trying some cubes and charts. Why do only column values get shown the elements, as when they are added as a row they get their DB values. Socio Type (Combo with Elements), as a column and states as rows I see the named elements. Socio Type (Combo with Elements), as a row I see the DB values instead of elements.

622
Freddy
P
Vanguard
pvleeuwenVanguard
asked in Questions & Conversations
OAuth connector gives blank screen

I am trying to use the OAuth connector to make a synchronization with the tax service platform of the British Government. I have followed the docs and set everything up accordingly. However when the proces action of the OAuth login connector is reached, a white screen comes up and nothing is happening. I assume thinkwise is adding the client_id, scope and redirect_uri to the Authorization URL? I was hoping to find more information in the debug screen to find out what URL’s etc are being called, but that is not the case. Can someone tell me what I am doing wrong here? I below screenshots you can see my settings. Settings in OAuth servers White screen. Nothing happening. My proces flow

41317
P
Vanguard

Badges

Show all badges
Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings