Replies posted by Harm Horstman

355 Replies

Hugo Nienhuis
Superhero
Hugo NienhuisSuperhero

SSH-protocol support for FTP-connectorOn the backlog

We built an integrated solution for receiving, processing and sending EDI messages via E-mail, HTTP and FTP. We have been able to automate this extensively with the help of process flows and it works to everyone's satisfaction.Unfortunately, we now find out that the FTP connector does not support SFTP, while there are many clients that only want to communicate via SFTP.I see that a request for this has been pending for years.When can we expect a solution?

5
Eric F
Rookie
1 day ago
Harm Horstman
Superhero
Harm HorstmanSuperhero
asked in Questions & Conversations

StartupProcedure not working anymore?

Added the idea, please vote 

7
Harm Horstman
Superhero
8 months ago
Harm Horstman
Superhero
Harm HorstmanSuperhero
asked in Questions & Conversations

StartupProcedure not working anymore?

Mark,Thanks, your idea is clear to me and I will be able to make this.Anyway, it will result in a much more complicated solution and mistakes can be made easily.I will add an idea for a StartupProcedure and ShutdownProcedure that work also for Universal enviroments.  

7
Harm Horstman
Superhero
8 months ago
Harm Horstman
Superhero
Harm HorstmanSuperhero
asked in Questions & Conversations

StartupProcedure not working anymore?

Mark,Ok it is clear to me that using the StartupProcedure is not a good approach anymore, because it won't work for users that are using Universal or make use of the platform via Indicium.According your response to the Question below, using a StartObject and start a task is a better approach. The problem I see here is that proper function depends very much on an action to set the StartObject for users(groups) by the IAM administrator.

7
Harm Horstman
Superhero
8 months ago
Harm Horstman
Superhero
Harm HorstmanSuperhero
asked in Questions & Conversations

StartupProcedure not working anymore?

Hello Mark,I have checked the branch and tried again this:create or alter procedure "proc_startup"( @model_id "text_1024" output, @message "text_max" output)asbegin -- Do not count affected rows for performance SET NOCOUNT ON; --control_proc_id: proc_startup --template_id: proc_startup --prog_object_item_id: proc_startup --template_description: EXEC dbo.tsf_send_message 'This is just a test', NULL, 0endgogrant execute on "proc_startup" to public go andcreate or alter procedure "proc_startup"asbegin -- Do not count affected rows for performance SET NOCOUNT ON; --control_proc_id: proc_startup --template_id: proc_startup --prog_object_item_id: proc_startup --template_description: EXEC dbo.tsf_send_message 'This is just a test', NULL, 0endgogrant execute on "proc_startup" to public go I still see different behavior for the Windows- and Universal GUI and Windows- and RDBMS authentication.Windows

7
Harm Horstman
Superhero
8 months ago
Roel
Moderator
RoelModerator
published in News & Blogs

Seamless synchronization with Microsoft Graph

Mark,Nice work! I'm sure this will avoid some frustrations.

41712
Harm Horstman
Superhero
9 months ago
Roel
Moderator
RoelModerator
published in News & Blogs

Seamless synchronization with Microsoft Graph

It took 11 days, but finally the cause for the failure to download solutions has been found.Indicium was not running in the background :-(   Thanks @Mark Jongeling Why was this not mentioned in the Thinkstore documentation? Why doesn't TSF give a warning? Why can't Indicium be launched from the GUI/TSF?

41712
Harm Horstman
Superhero
9 months ago
Roel
Moderator
RoelModerator
published in News & Blogs

Seamless synchronization with Microsoft Graph

Today, I have the possibility to try it on a different machine and I am now 1 step further and able to enter credentials to download a solution, but the status of the solution remains 'Queued’.As you can see, the desired solutions 'MS Graph Receive Events’ and 'MS Graph Send Events’ are not not available in SF 2023.2. 

41712
Harm Horstman
Superhero
9 months ago
Roel
Moderator
RoelModerator
published in News & Blogs

Seamless synchronization with Microsoft Graph

Hi Anne,I have made a ticket for this #7262SIn addition to this I like to mention that the 2 solutions 'MS Graph Receive Events’ and 'MS Graph Send Events’ are no longer visible in the Thinkstore. I am using SF 2023.2. 

41712
Harm Horstman
Superhero
9 months ago
StefanPater
Apprentice
StefanPaterApprentice
asked in Questions & Conversations

Use session log information in application

Hi Stefan,We are using a startup procedure that maintains a record in a table for each end user for this. The name of the procedure is defined as Extended Property (StartupProcedure)The procedure should contains something like this:​​​​​​​IF NOT EXISTS (SELECT 1 FROM tw_user WHERE usr_name = dbo.tsf_user())  BEGIN          INSERT INTO tw_user (         usr_name       , is_active       , last_login_date_time       , insert_user       , insert_date_time     )     SELECT usr_name              = dbo.tsf_user()          , is_active             = 1          , last_login_date_time  = GETDATE()          , insert_user           = dbo.tsf_user()          , insert_date_time      = GETDATE()  ENDELSE  BEGIN    UPDATE tw_user    SET    last_login_date_time = GETDATE()         , is_active             = 1         , update_user          = dbo.tsf_user()         , update_date_time     = GETDATE()    WHERE  usr_name = dbo.tsf_user()  END 

3
StefanPater
Apprentice
9 months ago
Harm Horstman
Superhero
Harm HorstmanSuperhero
asked in Questions & Conversations

Email provider for a branch

Dear Renée,It is clear to me that email providers can only be used for scenarios to send automatic notifications from the application. In the SF we can then predefine that and in IAM the credentials can be updated, correct?However, it is still not clear to me when and how the credentials were entered, in case of a non-SMPT provider.In addition, there is indeed a desire to allow end users to connect to a mailbox from applications to be able to send and/or receive email messages. For this I am waiting for a solution in the Thinkstore, as stated by Roel in his post: https://community.thinkwisesoftware.com/news-blogs-21/seamless-synchronization-with-microsoft-graph-4156I'm sorry to say, but there is very often a lack of understanding between your development team and us as functionally driven developers. It's a pity, because you are capable of making the most beautiful things, but it costs us unnecessary effort to get them implemented. That is why it would be nice if documentation gave mor

5
Renée Evertzen
Moderator
9 months ago
Roel
Moderator
RoelModerator
published in News & Blogs

Seamless synchronization with Microsoft Graph

Hi Roel,Sorry, but I still cannot download any Solution from the Thinkstore. Nothing happens after enter the credentials, no error messages, no nothing.Are there any special requirements or browser settings needed?Can you demo it to me?BR,Harm 

41712
Harm Horstman
Superhero
9 months ago
Harm Horstman
Superhero
Harm HorstmanSuperhero
asked in Questions & Conversations

Email provider for a branch

Hello Renee,Thanks, I understand this, but what I don't understand is how and when to enter the username and password for each email provider. Do I have to create a task with process flow myself?A full explanation with at least one example would be appreciated.Best regards,Harm 

5
Renée Evertzen
Moderator
9 months ago
Harm Horstman
Superhero
Harm HorstmanSuperhero
asked in Questions & Conversations

Users not able to reset password because Captcha seem never correct

Hi Erwin,I added the extended property ResetPasswordCaptchaNoise = Low to setting.iniThis is working, but now we have another problem, because following error message appears:Failed to send the "Validation code” by mail.  Why? SMTP settings are validated.  I made a ticket (#7259S) in TCP for this.

6
Harm Horstman
Superhero
9 months ago
Harm Horstman
Superhero
Harm HorstmanSuperhero
asked in Questions & Conversations

Users not able to reset password because Captcha seem never correct

I am now using version 2023.1.18 (Web) and the problem still exists.Cannot check a newer version at this time, I will try later. 

6
Harm Horstman
Superhero
9 months ago
Harm Horstman
Superhero
Harm HorstmanSuperhero
asked in Questions & Conversations

Users not able to reset password because Captcha seem never correct

@Erwin Ekkel,I now know what happened. If you try to change the password for a user with the 'Password / Allow Change' option unchecked, the question keeps repeating itself.In this case, a message should appear stating that the password cannot be changed.

6
Harm Horstman
Superhero
9 months ago
Michael
Sidekick
MichaelSidekick

Quick generation for one table which you made changes onOn the backlog

Hi @Jeroen van den Belt,It seems to be going in the right direction, but the Code Overview screen is just not complete. The 'Generate Code Group' task is missing. I had hoped for an option to generate the Layout, Default and Context procedures of a table or task in one go after adding or updating a column or parameter. But that is still not possible now.A disadvantage of the 'Go to Object in Code Overview' task is that a new main Tab is opened every time when the task is used.I would have liked to see the 'Deploy' screen as a detail tab for the objects (Tables, Tasks, Reports, etc..). That is not complex at all and would greatly improve productivity.In this way, the 'Code Overview' screen has no added value yet.

11
Mark Jongeling
Administrator
20 days ago
Harm Horstman
Superhero
Harm HorstmanSuperhero
asked in Questions & Conversations

Users not able to reset password because Captcha seem never correct

No idea, I didn't know there is a captcha noise setting.It is more the two weeks ago when the problem popped up, I forgot which environment it was.We couldn't wait so we have changed the password for the end user in IAM.

6
Harm Horstman
Superhero
9 months ago
Jeroen van den Belt
Administrator
Jeroen van den BeltAdministrator
published in Questions & Conversations

Survey closed, see topic for results: using the Model content (Full model) screen

I am using it quite often, mainly for global filter/search/update actions in following tables:Templates Task- / Report- / Subroutine- parameters Columns Tables (because don’t like the split of functionality in Tables and Subjects) References PrefiltersFor these kind of details tables, except Tables, this will never be possible in regular screens, I expect. I wish there was one screen like this to search thru all objects in a tree structure with a sort of super search engine behind it. 

43816
Jeroen van den Belt
Administrator
7 months ago
Roel
Moderator
RoelModerator
published in News & Blogs

Seamless synchronization with Microsoft Graph

@Roel,I try to download your solution form inside a blank 2023.2 Sandbox environment.It does not work, nothing happens after entering username and password.Will it be compatible with 2023.2?

41712
Harm Horstman
Superhero
9 months ago
E
Sidekick
Edwin SaanSidekick
asked in Questions & Conversations

ftp connection attempt returns -2

Hi Vincent,Yes, this is clear to me.Thank you. I will investigate further.

10
Harm Horstman
Superhero
9 months ago
E
Sidekick
Edwin SaanSidekick
asked in Questions & Conversations

ftp connection attempt returns -2

This morning Edwin Saan showed me his solution, which is very similar to my setup. The only difference is that his application is running on 2021.2 and in the documentation I have seen that the FTP connector cannot be used with the WinGUI or Universal GUI.  @Anne Buit can you verify this?

10
Harm Horstman
Superhero
9 months ago
Harm Horstman
Superhero
Harm HorstmanSuperhero

Being able to change filename of SSRS (Local) reportOpen

I wish to preview the report with a friendly/logical name for in case the user decides to save the file as pdf, docx or xlsx. Not it gets the (translated) name of the report. We like to add a row ID or timestamp to the name of the rendered report.

3
Jeroen van den Belt
Administrator
6 months ago
E
Sidekick
Edwin SaanSidekick
asked in Questions & Conversations

ftp connection attempt returns -2

Hi Anne, Thank you, this will hopefully lead to a working solution, but up till now, no success.The message which I receive now is ”Unable to connect to the remote server”. So I have to investigate further what is going wrong here. It takes ages because the debug information I get with the Windows GUI is very limited.By the way, I disagree and think that this paragraph ..."If you use STOR, you must put the full path to the file in the URL parameter. In your case, this is ftp://ftp.inone.nl/test.txt." … is crucial information for almost anyone who is setting up an FTP connection to upload files and should be in the documentation. In general, adding one or more examples in the documentation clarifies a lot, and is much more efficient than getting the information from different places to come to a working solution.  

10
Harm Horstman
Superhero
9 months ago
E
Sidekick
Edwin SaanSidekick
asked in Questions & Conversations

ftp connection attempt returns -2

@Roel / @Edwin Saan Same problem here...I have tried various URL formats:XX.XXX.XX.XX           (IP Address)ftp://XX.XXX.XX.XXftp.domain_name.nlftp://ftp.domain_name.nlftp://domain_name.nlBut still get the Status code -2 as responseThe FTP server is setup correctly, because with Filezilla it works fineI can't get any further on the basis of the documentation, because it is far too limited. Why are examples almost never given in the documentation?  

10
Harm Horstman
Superhero
9 months ago

Badges

Show all badges
Terms & ConditionsCookie settings