Apple Script to rename images using CSV file

Hi Tony,

Thank you for your reply and sorry - I did not realize that my post did not reply directly to the post I was referencing.

This should hopefully be a one time operation. We changed our entire inventory over to a new set of part numbers and so I need to rename all my image files for our website. I was using the part of the thread where you set up an Automator Workflow and inserted a shell script I thought I had it working but have since realized I do not. It says workflow complete - but doesn't do anything. No files are altered. I inserted the piece about moving the files to a new folder. Here are two screen shots - one of my csv file and one of my Workflow set up. If you don't mind would you take a look and see if you can determine what I'm doing wrong... I read through the whole thread in case there were edits or modifications so that I would hopefully not be wasting anyone's time but at this point I'm in need of help! Much appreciated. Thanks again!

In case you can't read it from the image below - this is the shell script used (with your move to new folder mod)

cd "$1"

while read line

do

OldImageName=${line%,*}

NewImageName=${line#*,}

mv "$OldImageName"

"Desktop/NEWFOLDER/$NewImageName"

done <"$2"

Hi Tony,

I tried both of your suggestions, moved the mv all to one line and the script ran and workflow complete - but again nothing happened.

When I ran the debug script nothing happened either - workflow complete but no txt file to be found anywhere.

Thanks

I've multiple times and haven't gotten anything. I even tried searching my mac for the debug.txt file just in case it was hiding somewhere. But no luck. Soooo I really don't know what's going on. Thanks anayway, appreciate your efforts to try and help me.

It's possible that the script is not reading the .csv file.

Is the .csv file a plain text file?

To test, replace

done <"$2"

with

done <"$HOME/Desktop/files.csv"

and then put a copy of the files.csv on the Desktop

and also put copies of a few of the files on the Desktop

I really appreciate you putting this script in for Automator because I have the same issue. I think I have copied the form you laid out in my Automator but after I run the program - it apperars to run ok (all green checks) but I can't find the resulting images with their new names. this is what my Automator looks like. -- I have two file folders on my desktop - one named Old Image Names (this contains 10 Jpeg files with their old names) and a second folder named New Image Names ( this contains a single CSV file named statestudentnumberonly with 10 numbers )

Thanks for any help you can offer.

1st post a few lines of what's in the file "statestudentnumberonly"

Then the 2nd step is to debug using echo.

Change

mv "$OldImageName" "Desktop/NEWFOLDER/$NewImageName"

to

echo mv "$OldImageName" "Desktop/NEWFOLDER/$NewImageName" >> $HOME/Desktop/debug.txt

and post a few lines of what you see in the debug.txt file created on the Desktop

Hi Tony!

Sorry to be picking up this issue again, but I've been reading through the whole thread and after a while it's gets messy. I lost track of which step I should follow in order for it to work after trying several steps and changing back and forth of the AppleScript etc.

If it's not too much to ask I would love some further help from scratch.

I've created the .csv file and placed all images in a folder - How and where should I place these files?

And what script am I supposed to write in the last step for the Shell Script? Please write the full code with clear marks where and what I need to change.

As I've been trying several steps mentioned earlier in this thread the closest I've come in order for it to work is that the script runs without errors but nothing happens to the file names...

Note that I have zero experience from using these tools in OS X so please use a language that I can understand 🙂

Thank you very much in advance!

(Sorry about the Swedish language in screenshot!)

Note: the following line is missing the $ in the HOME variable and the quotes are unbalanced. The script will fail.

echo "$OldImageName >> "HOME/Desktop/MissingFiles.txt"

should be

echo "$OldImageName" >> "$HOME/Desktop/MissingFiles.txt"

Mark,

Thanks for your feedback.

I made your requested change and also moved some files according to the script (I did some thinking of my own).

So the script runs without errors now but it doesn't generate the change of the files names... So it runs the script but nothing happens.

Please see attached screenshot.

Thanks in advance for your further assistance!

vnylund wrote:

I made your requested change and also moved some files according to the script (I did some thinking of my own).

So the script runs without errors now but it doesn't generate the change of the files names...

So it runs the script but nothing happens

The change was for debugging purposes, not to move files.

There should be a file on your Desktop named "debug,txt", please post a few lines from that file.

Tony,

You are referring to my answer to Marks post. Please my answer to your post above.

I made your change in the script but no .txt file was generated on my desktop. So I can't provide you with the data you're asking for, sorry!

vnylund wrote:

Tony,

You are referring to my answer to Marks post. Please my answer to your post above.

I made your change in the script but no .txt file was generated on my desktop. So I can't provide you with the data you're asking for, sorry!

ok, first get the script back to where it was.

change:

echo mv "$OldImageName" "$NewImageName" >> $HOME/Desktop/debug.txt

to:

mv "$OldImageName" "$NewImageName"

Now, before the if statement, add:

echo mv "$OldImageName" "$NewImageName" >> $HOME/Desktop/debug.txt

Is there a debug.txt file created on the Desktop now?

I see now that you hard-coded the folder as the Documents Folder (sorry, I missed that before).

In this case, then both the CSV file and the images need to be in the Documents Folder (and also the only Automator Action needed is the Run Shell Script Action).

>vnylund wrote:

>I see.

>Tried to make it work but same problem still occurs.

>The script runs without any problems but the action is not generated so the names of files is not being changed...

Can you post a few lines of the CSV file?

Sorry about my mistake!

Attached is a screenshot of the text in TextEdit and following are lines directly copy pasted:

OldImageName;NewImageName

0256_027.jpg;0256027L.jpg

0283_3KH.jpg;PI02833KHL.jpg

0283_3KH.jpg;PI02833KHM.jpg

0283_3RH.jpg;PI02833RHS.jpg

05DPP036_SM_PD22_n1z1.jpg;Y41R98070.jpg

0705_4RF.jpg;07054RFM.jpg

0705_4RF.jpg;07054RFS.jpg

0705_4RF.jpg;07054RFXL.jpg

0705_4RF.jpg;07054RFXXL.jpg

0711_3RH.JPG;PI07113RHXL.jpg

0877_3YY.jpg;PI08773YYM.jpg

0991706 GEL BLOCK.jpg;EL0991706.jpg

11111029-31._BibTight Elite AmFIB_Blk_2010.jpg;PI11111031021M.jpg

11111029-31._BibTight Elite AmFIB_Blk_2010.jpg;PI11111031021XL.jpg

11111032021.jpg;11111032021L.jpg

11111032021.jpg;11111032021M.jpg

11111033-35._BibTight El. Th.Fleece_Blk_2010.jpg;PI11111035021M.jpg

11111037._Pant Sel. Barrier WXB_Blk_2010.jpg;PI11111037021L.jpg

11111037._Pant Sel. Barrier WXB_Blk_2010.jpg;PI11111037021S.jpg

11111037._Pant Sel. Barrier WXB_Blk_2010.jpg;PI11111037021XL.jpg