Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

File Copying and Moving

bobpeers
9 - Comet

If you want to move or copy files without using cmd or powershell solutions you can now install this tool made with the Python SDK.

 

AlteryxCategory

 

You can choose to keep the filenames the same but you can also rename them at the same time. It's a yxi package you can download and install from my Github site.

 

Happy moving!

 

https://github.com/bobpeers/Alteryx_SDK_FileCopyMove

37 REPLIES 37
psubramanian
7 - Meteor

Hi,

I am facing the same trouble/error as @JMart2135. Can someone please reply? The File Copy/Move works perfectly fine when run on the local machine, but fails when uploaded to Alteryx Gallery. Do we need any additional setup that needs to be done on the server?

Please help!!!

Wrigh6s
5 - Atom

Absolute hero, this is exactly what i needed. Even managed to work out how to change file name at the same time. I've pasted my example flow if anyone is struggling to work this out. 

 

Wrigh6s_0-1670522991340.png

 

 

PanPP
Alteryx Alumni (Retired)

Hi @psubramanian 

 

In order to utilize this tool on the server machine, it will need to be installed on the Server machine. Following the steps below will ensure the tool is installed properly.

 

1) Run Designer as admin on Server machine

2) Click File top left in designer

3) Click Open workflow

4) Browse to the .yxi file to install the tool for all users.

 

Below are the directories for the tool installation:

 

Client machine (non admin install) - C:\Users\username\AppData\Roaming\Alteryx\Tools

Server Machine (Admin install) - C:\ProgramData\Alteryx\Tools

 

Hope this helps, if it does please like this message so other users can see.

Wrigh6s
5 - Atom

Thanks this makes so much sense. 

CaitlinFallows
7 - Meteor

Hey bobpeers,

 

This is a great tool, but I seem to be having a drawback to it I'm hoping you can help me with. The files write into the folder as expected, but when I try to pull it onto the canvas (I run these daily and need to compare one day to another), Alteryx doesn't recognize the filepath - I'm dragging it directly from the new folder location so it's not mistyped, and Alteryx acknowledges there's two tabs in the Excel file, but gives an error that the filepath might be incorrect. Has this happened before/have I done something wrong?

 

(Excuse the rough redaction)

CaitlinFallows_0-1683293397811.png

 

dkazup
5 - Atom

Hello, When I run a workflow with this tool from a local desktop, it runs fine.  However, when I run the same workflow from a virtual machine, in which I have different credentials, it presents almost immediately a "The designer x64 reported: Unknown Fatal Error".  Everything else is the same... the virtual machine has the desktop alteryx designer.... anyway you might be able to help? I'm limited in my ability to share information on this site but will try to answer any questions as best as I can.

hbonsu198
5 - Atom

Hey bobpeers! thanks for putting this amazing tool together. Does this tool work with copying file from and to a SharePoint folder using the Sharepoint input and output tools? I tried a number of times but the file_result says "Source file doesn't exist". thanks in advance for your response!

sowjanyayinti
6 - Meteoroid

hi there,

 

thank you so much for the awesome tool. It works great for copy/move but what am I missing when it comes to renaming the files .

 

I am using the formula tool as you mentioned but I still do not see any changes to the file names. I used the format given https://knowledge.alteryx.com/index/s/article/How-to-Dynamically-rename-output-files-1583460182987 to rename the file

 

 

Rename1.PNG

Labels