Apple Script to rename images using CSV file

Hello, thanks for the quick reply. I have tried using the script but can't seem to get it working. When I click Run on the AppleScript Editor I get a message stating:

Syntax Error

Expected end of line, etc. but found “while”.

Below is what I have changed. I put the CSV file in the same folder as the images

#!/bin/bash

cd /Users/aaron/Desktop/Images

while read line

do

OldImageName=${line%,*}

NewImageName=${line#*,}

mv "$OldImageName" "$NewImageName"

done <"/Users/aaron/Desktop/Images/CSVFile.csv"

Hello twtwtw,

I have tried your script and I get the following error message:

error "System Events got an error: Can’t set file \"Old Image Name\" of folder \"/Users/aaron/Desktop/Images\" to \"New Image Name\"." number -10006 from file "Old Image Name" of folder "/Users/aaronkitney/Desktop/Images"

How shall I export the CSVFile from Numbers? I currently export as Unicode UTF-8. Shall I put the CSVFile on my desktop or inside the images folder?

Thanks for your help as well Tony,

Hello Tony,

I managed to get your idea your Automator version working, really happy. Thanks.

I did have another Automator/Script issue that , istead of processing images I would like to rename the file image file in the Numbers doc. I need to put a _1 after about 600 images

As I am uploading two images per product item onto the website, I can't have them named the same because they will overwrite each other on the FTP. I'm not sure if it's easier to add _1 to every row name in Numbers, or save out the images (using the previous script provided) into a differen't folder (so it doesn't overide on my desktop) then add _1 to the each image. Either way I'm not sure how to write a script to accomadate this.

If this is confusing I make a few screen shots to help explain

I can't express how grateful I am already, I spent most of today testing different plugins to no avail

Thanks.

Going back to my original issue. After I finished my first batch of images I renamed that folder to 'Featured Images' and created a new folder called 'Images'. I tried to batch rename another CSV file with my Supporting website Images, but I encounter an error again. I cant figure out what I'm doing wrong. I'm essentially just trying to copy the script as before

I've attached an image - the error can be seen at the bottom of Automator

Dreamy. Glad you spot that.

Thanks again

Hello again,

Sorry for keep having to get in touch, I've been spending hours on this, sometimes it works and other times I get errors. I run into errors everytime I switch files. I've got to resave all the images again because I forgot to add the .jpg suffix and they won't upload into Wordpress (stressful for a friday)

I've attached a picture, I can only select 'Storage' in Variable, if i click the dropdown and click New Variable it just makes a 'Storage 2'. Maybe it's not even that which is the issue.

I hand typed 'Choose CSVFile' in the Ask for Finder Items.

Thanks for you help

Hey Tony,

Using the latest Script I got...

Error.txt

Old Image Name

I saved out the CSV file again and readded the photos into the folder, a test of 5 images worked. I'll do all 1000+ tomorrow and see how it goes

There is something that happens during the Automator that changes the .jpg file. They cannot be loaded into Wordpress I get an error message saying:

“Ditch_Witch_SK_300.jpg%0D” has failed to upload due to an error

Sorry, this file type is not permitted for security reasons.

Amazing as always.

In Numbers you wouldn't know how to add text in front of a word rather than at the end?

For example:

Ditch_Witch_SK_300.jpg > wp-content/uploads/2014/02/Ditch_Witch_SK_300.jpg

Much appreciated