Run Command - Copy Files

Question

Dear all,

I am struggling with the issue of copying a xlsm file from one network drive location to another one.

I was following the instruction of the this post, which are fine if I am using local folders on C: https://tarsolutions.co.uk/blog/move-or-copy-files-in-alteryx/

However if I am using UNC paths I am facing here troubles. If I am entering the statement from my bat-file into the windows cmd programs it runs without any issues:

I treid it with this macro, which is working only in the designer but not on the Gallery.

https://github.com/bobpeers/Alteryx_SDK_FileCopyMove

I highly appreciate if you can help me with my issue!

Many thanks!

Johanna

Jay-RDC · Answer

Do you have a list commands for the run command tool. (e.g. Copy, move, replace etc.)

TheOC · Answer

hey @Jo-B

Just on the same lines as @Luke_C , i would recommend setting up another interface tool (like a dropdown list, theres an example workflow with exactly what you need) with the options deriving from a file on the network drive too. This will help isolate whether this is an issue with the network drive or specific tool.

Cheers,
TheOC

Luke_C · Answer

Hi @Jo-B

Does Alteryx server have the necessary permissions to the folders as well as to execute these commands? You may need to reach out to your admin.