Move files without using Run Command tool

Question

Please suggest how can we move files in different folder without using Run Command tool.

We need to move file from a folder to Archive folder after processing.

rdlalli · Answer

I found this to work very well.  I have a couple of additional notes.

* I used os.listdir() to directly list files in source_dir without using os.walk(), thus avoiding interaction with subdirectories.
* for the source_dir and destination_dir, I found it better to use the UNC path rather than the drive-letter path as  raw strings (e.g., r'P:\...) for the directories.  Raw strings may be optimal for paths containing backslashes in Python. However, consider switching to UNC paths if there's a chance of drive mapping inconsistencies.

Finally, I added this small bit because I was only interested in Excel file types.

for filename in files:

# Check if the file is an Excel file

if filename.endswith(('.xlsx', '.xls', '.xlsm')):

source_file = os.path.join(source_dir, filename)

destination_file = os.path.join(destination_dir, filename)

Pawel_Lula · Answer

You can do move/"cut and paste" using Python script.

#################################
import os
import shutil
from glob import iglob

#################################
def move_all_latest_files(source_dir, destination_dir):
files = os.listdir(source_dir)

if not files:
print(f"No files found in {source_dir}. Skipping processing.")
return
'''
for filename in files:
source_file = os.path.join(source_dir, filename)
destination_file = os.path.join(destination_dir, filename)
shutil.move(source_file, destination_file)
'''
for root, directories, files in os.walk(source_dir):
for filename in files:
source_file = os.path.join(root, filename)
destination_file = os.path.join(destination_dir, os.path.relpath(source_file, source_dir))
shutil.move(source_file, destination_file)
print(f"Moved all files from {source_dir} to {destination_dir}")

#################################
source_dir = r'\Your_Source_Path'
destination_dir = r'\Destination_Path'

move_all_latest_files(source_dir, destination_dir)

Python_Move_Files.png

messi007 · Answer

@binay2448,

As my knowledge you can't do this without cmd.

Regards,