move files from one folder to other folder in network drive.

HI Team,
I am exploring moving files (cut paste) functionality in Alteryx using Run command tool. and I successfully moved files one folder to another folder. But when i am trying to achieve this on network drive, files are getting deleted from source folder but not moving to destination folder.
Can someone help how can we achieve moving files on network drive.

I have used same below workflow as reference just changed file paths.

movefiles.yxmd

Batch Macro

Dynamic Processing

Run Command

Accepted answers

All comments

KGT

Looks fine, and so unless it's some funky thing with the MOVE command (I didn't think that was an issue, but seem to remember having to use XCOPY years ago).

Check whether they are mapped drives.

I'm assuming this is on your desktop, that the running user is not going to be an issue.

Can you perform the move in File Explorer?

WirkKarl

I’ve run into this before—network drives can behave differently than local folders because of permissions and network latency. Make sure the account running the Alteryx workflow has write permissions on the destination folder. Sometimes adding a small delay before the move command helps, especially if the network is busy.

sparkle

HI @WirkKarl ,

Can you please guide, how to check these write permissions in Alteryx.

sparkle

HI @KGT

If I get any sample workflow, it would be great help.

OllieClarke

@sparkle
I think the issue will be the directory/drive you're running the command from.

As you're writing your .bat script to your temp drive, see if you can run a copy file (rather than move) command from the command line?

In windows explorer, type "%temp% into the address bar to navigate to your temp drive.

Then write "cmd" into the address bar and hit enter to open commandline from that location

Then take, say the first row of your [Command] column, change "Move" to "Copy" (so you don't lose the original file) and see if that command will run from the temp location.

If it does, then try with "Move" rather than "Copy"

sparkle

HI @OllieClarke.

Thank you for your comments.

Can you please configure run command tool for me. I have tried to change location, but no success. Please note, below are the location details and workflow for moving files.

Input location : \\pu-cdot02-corp01\home\mamtal\microtesting\IP

output location: \\pu-cdot02-corp01\home\mamtal\microtesting\Archived

onlymovingtest.yxmd

KGT

I would say that probably holds your answer then. Some kind of permission etc, as that command should work if you have access.

Try navigating to the file in cmd and investigate why it can't find that file. If the command won't work when running it in cmd, it won't work in the Run Command.

So, your option is to either get the command working from there, or change the location of the bat file to somewhere it does work, such as on that drive. That does make it somewhat less dynamic though.

Try changing "%temp%\RunCommand.bat" to "\\pu-cdot02-corp01\home\mamtal\microtesting\IP\RunCommand.bat". That may not be best going forward, but it'll help you to find this issue.

jrlindem

Reading through this thread. Lots of great responses. One thing to note about using the MOVE command, is that it does not inherently COPY/PASTE. So the file itself can and will inherit any permissions from the source folder and adopt those into the destination folder.

Meaning if USER does not have permission to DIRECTORY_A but does have permission to DIRECTORY_B; then using MOVE to relocate a file from DIRECTORY_A to DIRECTORY_B could still prohibit USER from accessing the file, even if they have permission to DIRECTORY_B.

Better to use COPY or ROBOCOPY. If you need to after that, you can always circle back and remove the source file after the copy has been performed and verified.

Think of this in steps:

Copy the file and paste it into the new location
IF EXISTS in new location THEN delete the source version of the file

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703