Update Value not working on text string

Question

Hello

I have a macro that I am using to pass data to an SFTP site. Within the parameters being passed I am trying to send the SFTP site and passkey, hostkey etc. This will allow use by others.

Using multiple update values I was hoping to replace certain text within a string to build the argument for a cmd line program calling winscp.

What I am finding is the substrings never get replaced. The original text references

SFTPADDRESS and te replace string is ticked but when I try to call the macro .The sftp logic fails with the error the host SFTPADDRESS does not exist.

Am I being too ambitous or is the update value the correct approach. Is there anything else I am missing with the macro?

Thanks in advance

C

SFTP Macro.PNG

patrick_digan · Answer

@CJD1978 Another option is to use reference shortcuts. This would allow you to test your macro in a much easier fashion. This KB article walks you through it, and I've walked through a quick example at a user group meeting before.

BenMoss · Answer

My guess would be that having multiple update values is causing conflicts, the correct approach in this case would be to connect all of your interface tools to a single action tool (yes you can do this!) and then use the ‘update value with formula’ option to build out your ‘dynamic string’, for example...

”www.”+[#1]+”.com”+[#2]

where #1 and #2 are references to the different interface tools connected to your action.

I hope this is useful.

Ben