Apple Script to rename images using CSV file

Hi Tony!

I tried it but still the same result; The script runs without any errors but the file names remain unchanged...

Please see attached screenshot.

Just want to say that I really appreciate your help and if we get it to work it will help me out a lot in my work!

I Had the same problem where the script would run without error but with no changes to my image names - due to my immediate need I ended up going to out source website (upwork) and hired a guy to write the script exactly as I needed and then email it to me. I have run it 6 times renaming 500 images each time - without error. I would love to learn to write the script but this time I took the easier way - although more expensive - cost me $60US but in this case well worth it. Good luck

Hi Tony!

Sorry for the lack of response here but I've been away for a few days.

I tried the script and this time it actually felt like something happened since it took a few seconds for the script to run. And the .tmp file showed on the desktop for a little while as well before it disappeared.

What's the next step? 🙂

Edit: I realized that I didn't place any images on the desktop so I did it again and it worked 😀!!!!!! One image didn't get renamed though but I'll check if there's something wrong in the .csv file. But as for now I hope it will work.

Edit#2: The script didn't process the last line in the .csv file so I just added a "dummy line" at the bottom and it renamed the last image as well.

Thank you very much Tony!!!

Tony, You seem to be giving a lot of help here and I appreciate that. I am trying to do something similar with pdf files, but I am not getting errors, nor are my file names changing.

Do you see anything wrong with the code?

Here are the sample csv lines:

OldImageName,NewImageName

Student1.pdf,Aizenberg_Samuel_0028

Student2.pdf,Alexander_Pierce_0024

Here are the results of the debug.txt file

cp OldImageName /Users/orrj/Documents/NewImageName

mv OldImageName NewImageName

cp Student1.pdf /Users/orrj/Documents/Aizenberg_Samuel_0028

mv Student1.pdf Aizenberg_Samuel_0028

jorrflv wrote:

I am trying to follow the bash script, but I can see right now that there will be an issue because the folders are on my desktop not in my documents folder... that would make a difference yes?

Should not make a difference.

The first action selects the Folder that has the files.

Now that I think about it, there is no need to debug the cd.

Run the Workflow Again (with no echo commands), then when it completes, click the [Results] box and you'll see the directory that the workflow is changing to:

In this example, I selected the Untitled Folder on my Desktop:

When you click [Results] you should see the folder with the files

added the line no go... here are the results of terminal command

OldImageName,NewImageName^MStudent1.pdf,Aizenberg_Samuel_0028^MStudent2.pdf,Alex ander_Pierce_0024^MStudent3.pdf,Anderson_Eric_8583^MStudent4.pdf,Apalategui_Aime e_7987^MStudent5.pdf,Attanasio_Nia_7722^MStudent6.pdf,Ayoub-Butcher_Angelina_009 9^MStudent7.pdf,Badger_Gage_7751^M

Hi Tony, sorry to bug on this old thread, but like the previous poster said you seem to be very helpful on this thread. I've used the script you created and it works perfect. My question can this script be modified for it to look under multiple folders? All the image files are within their own folder and was wondering if the script would be able to just find all the files in the different directories and rename the files according to the CSV file. As an ideal i'm attaching the screenshot of my CSV file, if that helps. if you notice that all the files start with a different number so each number corresponds to the file folder. Example of folder structure attached aswell. Any help would be greatly appreciated it! So far this script you created only works for files in one folder right? Thank you so much!

Thank you so much for you reply! Yes your understanding to what I'm trying to accomplish is correct. I tried running the script but the files I tested on, didn't rename. Can this script be used with the same set up you had for in automator or do I have to run it separately? Sorry, I'm a noob when it comes to scripting and still learning and trying to understand a lot.

Another question if i had all the folders in another folder on my desktop (ex. /Desktop/Color_Rename/14901) would i have to put the path in as follows cd ~/Desktop/Color_Rename/

Also by reading past posts do we still need to add the string if we're using a CSV file created on a Mac Excel?

Thank you again for helping me!

Hi Tony,

I noticed that you were using tr to change the carriage return to a newline. If you are attempting to change \r\n line-ending, then this usage of tr will result in \n\n. If that is not your planning, then this article shows how to use Perl and its '\R' meta-character to produce a solitary newline ending. The '\R' usage is basically, “I don't care what the line ending is, just make it the replacement value.”

Excel for Mac ends each csv line with just a cr (no newline), so deleting just \r will produce a file with no line endings, hence the need to tr \r' to \n.

This Excel file:

Saved as a CSV and viewed in Terminal with cat -e:

I posted a bash script, not an Applescript.

You would need to run this from Terminal.

Better to use twtwtw's Applescript example below if you're not familiar with bash scripts and Terminal

In the second Action, you need to use the Set Value of Variable Action, not Get

😎

edit: s/b :

enter "wp-content/uploads/2014/02/" in the column next to "Ditch_Witch_SK_300.jpg" and then in the 3rd column enter: =C3&B3 (the & concatenates the 2 strings):