Skip to main content
  • EN

I have hundreds of image files that require renaming.

I have an Excel sheet with the oringinal file names in one column and in another colomn the prefered file name. I would like to replace the image file (.jpg) name with the new name the column in the spreadsheet. I found an article on how to do this, but I can't seem to get the script to work. I am new to FME. I have provided the workbench file and the spread sheet and a image file.

Can some one please help guide me with where I am going wrong?

I always find the FileCopy Writer not as intuitive as most other FME components and really need to dive in to get it working. As an alternative I prefer to use the SystemCaller transformer to do this with commandline:

rename "@Value(current_filepath)" "@Value(new_filename)"

so you get something like

rename "C:\Temp\New folder (4)\files\old.txt" "new.txt"

for each file.

2021-05-28_06h17_48Added a sample workspace demonstrating this. I prefer to doublecheck and the commandline manually before running it all through the SystemCaller.

 

Reply


Community Stats

30,177
Posts
114,556
Replies
37,843
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.