Product updates
Ideas
Groups
E-learning
Documentation
Events

Community
Search

Replies posted by Tejo van de Bor

54 Replies

Oldest first

Newest first

Tejo van de BorCaptain

asked in Questions & Conversations

Using SQL functions in calculation fields

ah, subroutines! I was betting on control procedures.. Now I see there is a reference in the documentation, but your example is beter Thank you!

Tejo van de BorCaptain

asked in Questions & Conversations

SQL Reserved words

hi Mark,Ah, I see the validation now, but it is only a warning (in testing I normally skip these warnings 😬 ). Shouldn’t this be an error as the sql code breaks when executing?

Tejo van de BorCaptain

asked in Questions & Conversations

SQL Reserved words

Ah, jep, 2021.3 here. Thanks, we need to update :-)

Tejo van de BorCaptain

asked in Questions & Conversations

Enter parameter in preview component

hi Erwin, I understand that variants can be used when opening a document and change the screentype, but in this situation switching between id 5 (no preview) and 6 (working pdf preview) doesn’t change the variant. Or am I missing something?

Tejo van de BorCaptain

asked in Questions & Conversations

Enter parameter in preview component

In this case the both documents (zpl and pdf) are linked to the shipment, the zpl is not readable for the previewer. For the zpl I can generate an additional image/pdf and save it in this record to show it to the user. There is no context procedure which detail to show, both zpl and pdf records should be shown.

Tejo van de BorCaptain

asked in Questions & Conversations

Use printers in data model

Hi Mark, Thanks for your response, I understand that Thinkwise has no further printer settings, besides naming a printer for reporting. So specific printers (and trays) for specific users can only be controlled by creating different applications for every combination. That’s not a real solution, right? It’s a workaround. So I guess the only solution is to create a project-datamodel around these printers and users so we can define the specific settings for printing. Do you know if there are examples for print commands from a task, specifying the exact printer? I searched in documentation but could only find https://docs.thinkwisesoftware.com/docs/sf/tasks#windows-command

Tejo van de BorCaptain

asked in Questions & Conversations

Use printers in data model

Thanks Mark, that we indeed can use for reports!We also have pdf’s and text files as varbinary in the database that should be printed directly from the Thinkwise GUI, to a specific printer. Any solution or hints for that too?

Tejo van de BorCaptain

asked in Questions & Conversations

Get file content without temporary saving file

hi Mark,So there is no database equivalent of the ‘read-file’ action process action? I tried an approach with a process procedure, and some t-sql I found for encoding the base64 into a string: SELECT @zpl_file_code = dbo.decode_utf8_string(result) FROM (SELECT CONVERT(VARCHAR(MAX), CAST('' AS XML).value('xs:base64Binary(sql:column("BASE64_COLUMN"))', 'VARBINARY(MAX)')) AS resultFROM(SELECT file_content AS BASE64_COLUMNFROM shipment_documentWHERE document_id=@document_id) a) x This works in order to get the zpl code from the file, but when executing in the process action, it takes almost a minute to process:Any idea’s for this?

Tejo van de BorCaptain

asked in Questions & Conversations

Get file content without temporary saving file

hi Mark,The function is indeed the issue, I got it from https://stackoverflow.com/questions/28168055/convert-text-value-in-sql-server-from-utf8-to-iso-8859-1 so I guess I have to get another decode function :-) But I get the idea of the process procedure, although it’s a shame it’s not showing in the process flow designer. Thanks for your help!

Tejo van de BorCaptain

asked in Questions & Conversations

Creating json message with column alias

Thanks Mark, I’m gonna try this!

Tejo van de BorCaptain

asked in Questions & Conversations

Get rid of control procedure

Thanks Renée, I thought you always needed a new definition→project version etc. Never stop learning 😄

Tejo van de BorCaptain

asked in Questions & Conversations

API data show in popup grid

Thanks Erwin, never thought of a view getting the json data. Now I got the view showing (set the extended properties for floating document width), selecting the record and save the code.Still wondering how to continue with the initial process flow. By opening the document the flow is stopped right? Or can it be continued after executing the task in the view? e.g. after saving the code there are some extra things I’d like to execute.

Tejo van de BorCaptain

asked in Questions & Conversations

API data show in popup grid

Ah, thanks Edwin. The lookup option is indeed a beter way for handling the popup, and all steps are now in 1 processflow. Got it working now!

Tejo van de BorCaptain

asked in Questions & Conversations

Use printers in model (2)

Hi Vincent,That is an interesting approach :-) so create like 10 printers in the model, and based on the name they can be linked to our user-linked-printers in the database, and with that info the decision can choose the correct model printer. And when deployed, set the actual printer address in IAM.It’s a workaround i’m gonna try, still the variable option would be preferred. Thanks!

Tejo van de BorCaptain

asked in Questions & Conversations

Execute system task with Windows Command

hi @Mark Jongeling,I tried the printer actionbut this also needs user input after executing the processflow. We were advised to use a windows command so we can use 3rd party tools for silently (nu input needed) printing pdf’s. So why is it possible to add a windows command task to an Execute system task when it’s not really supported?So it is not possible to run windows command’s in a scheduled flow without user input? Any idea’s on a workaround?

Tejo van de BorCaptain

asked in Questions & Conversations

Use printers in model (2)

Added this in idea’s

Tejo van de BorCaptain

Hide add button in row entryClosed

hi Erik,Based on the approved status of a parent entity we want to fix the details and therefore disable or hide the edit/add buttons. Some details are only shown in grid, the + in front of a row is confusing.

Tejo van de BorCaptain

Hide add button in row entryClosed

So the idea is quite simple, add the “Add row visibility” as an option in the Layout procedures, with hidden, enabled and disabled. So when you cannot add a record, you don’t have to see the “add row”.

Tejo van de BorCaptain

asked in Questions & Conversations

Show project version

Thanks Renée, we’ll fix it in the translation and wait-and-see what the 2023.1 version will look like 😊

Tejo van de BorCaptain

asked in Questions & Conversations

Use generated columns in default sort

Thanks Renée, I’ll take this question with me to TEC to figure out the dynamic model.

Tejo van de BorCaptain

asked in Questions & Conversations

disable drag drop in context

ah, thanks Renée, I had the tasks hidden, not disabling them. Now it works, or beter, it doesn’t when we want to 😊

Tejo van de BorCaptain

asked in Questions & Conversations

Use generated columns in default sort

Thanks @Arie V this worked!

Tejo van de BorCaptain

asked in Questions & Conversations

Passwords visible in Process flow monitor

Hi Anne,thank you for the reply, I don’t understand why a simple password question leads to the use of a different GUI or system flows handling the API call. So I have a processflow which needs user input, and then processes an API call. With the Windows GUI, the advantage of the processflow is that I can debug it, with a systemflow only the output/errors are shown in indicium (outside the client).A simple solution can be, hash the password string. So it’s unreadable in the database but not for the software. It frightens me everytime I see a password as plain text in the database, this should be part of the model, right? It’s an intelligent platform, it should handle password’s properly.End user mode is something you declare in the configuration file, a user can bypass it.So looking forward to new developments planned, but I think this is something basic and should be handled by the model.

Tejo van de BorCaptain

asked in Questions & Conversations

Indicium port 5000 setting

Wow @Dick van den Brink , thanks, this works! Do you know if this can be set in the appsettings.json or anything else? Could not find anything in documentation or community. Now I’m curious if there are more indicium.dll startup parameters :-)

Tejo van de BorCaptain

asked in Questions & Conversations

Extra fields and translations for enduser

Another option would be to add a freelabel_xx expression field with a label control before each of the freefield input fields, that retrieves the value of the label from a configuration table. Thanks Jasper, I got this working in a form, but in a grid I can’t fix the column-names

1
2
3

Page 1 / 3

Badges

Martijn_Reedehas earned the badge Geek
Dennis Kallanseehas earned the badge Geek
Alban_Thas earned the badge Generator
martijngaasbeekhas earned the badge Preparator
SanderAdamhas earned the badge Preparator

Show all badges

Powered by Gainsight

Terms & Conditions Cookie settings

Sign up

Already have an account? Login

Login

Login to the Thinkwise Software Community

Login

Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.

Username or e-mail

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

OK

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.

OK