Hi @Felipe_Ribeir0 and guys,
I tried your macro of moving files, and I got an error. Can you please help me with this? See below error.
If there's any other way the easiest that workflow can call, please do also let me know.
Please advised.
Thanks,
Kamen
Hi @KamenRider
This seems related to passing invalid FileOrigin/FileDestination parameters to the macro. You must pass valid filepaths (you can test it copying them and trying to open them with your windows explorer), and each FileOrigin/FileDestination must be unique.
Thanks for the response. Here's my plan, I wanted to remove the previous files and send to archive folders. I do hope my workflow sequence will works as below:
Is is possible that the origin of the files is not in the folder just like below? I noticed that your macro origin is from folder to folder, however mine reports starts not a folder to call. Can you help me how we can change the configuration. I tried to put "" in the formula tool instead of a folder name but it is not working.
Please advised.
Thanks,
Kamen
Hi @KamenRider
As long as you use full valid windows filepaths, it will work.
For example, for the bellow file it is C:\Users\user01\Downloads\Batch Input (1)\FileToMove.xlsx
May I ask what will be the syntax in the formula tool you have since I don't want my files to be put in another folder. I tried changing the syntax to REPLACE ([FILE_ORIGIN], " ", 'OUTPUT ARCHIVE') but it is not working.
As stated I would like my 3 files in kind of scenario.
Please advised
Kamen
Hi @KamenRider
You could try to type the full path manually and concatenate it with the filename like this:
I was able to change its destination path in formula tool and along the way of running the workflow, I've encountered an error saying file is already exist in the destination path. Is it possible that macro can overwrite the files in the destination folder?
I also noticed that moving does not follow the "block until done" tool because while it should work the first process, it works the last. Not sure why?
Please see my screenshot below.
Please advised.
Kamen
Hi @KamenRider
Unfortunately this macro does not have the capability to overwrite files yet. I will put this capability on the next week.
About the block until done, when you have some a little more complex scenarios it does not always work as you first expect. One way of dealing with this is using the append tool to allow the cmd to work just after you move the files, like this:
I tried your suggestion however, I still got an error in moving the files. Still the process of moving the files first did not work as it should be because before it move the first two files in the Output Archive, I see template saving on the drive and later 3 errors occurred.
I made some observations. If the output folder does not have anything to copy to the output archive, running the workflow is successful (copy to template the data and renaming). By the way, I made some changes on my workflow as follows:
If the Output has the 3 data files, running the workflow to move the files is not working. It will just move the other two files and then errors will be generated. By the way, I'm using network drive in my origin and destination and I am not sure if your macro will read this.
Aside from that, the workflow also gives an error if the files in the output folder has duplicates or already exists in the Output Archive folder. (hope you could share me your updated macro where overwriting data is possible)
Another error is under my cmd as follows: Hope you could advised me how to fix this one.
Thanks and looking forward you could still assist me in solving this scenarios until it will work perfectly.
Kamen
