Apple Script to rename images using CSV file

Should be simple with this bash script.

Change ~/Documents to the Folder where the files reside (assumes that the csv file and the jpg files are in the same Folder):

#!/bin/bash

cd ~/Documents

while read line

do

OldImageName=${line%,*}

NewImageName=${line#*,}

mv "$OldImageName" "$NewImageName"

done <"TheFile.csv"

In applescript it goes something like this:

(*

this all assuming the CSV file is a plain text file with a comma delimiting

the old and new filenames on a given line. If you have another structure

you need to give specifics so this can be modified

*)

set theCSVData to paragraphs of (read "/path/to/theCSVFile.csv")

set {oldTID, my text item delimiters} to {my text item delimiters, ","}

repeat with thisLine in theCSVData

set {oldFileName, newFileName} to text items of thisLine

tell application "System Events"

set name of file oldFileName of folder "path/to/folder of images" to newFileName

end tell

end repeat

set my text item delimiters to oldTID

Note that I've made a lot of assumptions about your csv file, any or all of which may be wrong. please clarify as needed.

You can also make this into and Automator Workflow or App.

Add this shell script:

cd "$1"

while read line

do

OldImageName=${line%,*}

NewImageName=${line#*,}

mv "$OldImageName" "$NewImageName"

done <"$2"

as part of this Automator Workflow:

Edit: twtwtw posted an Applescript example (which is what you're looking for) while I was posting this Automator example. You now have 3 ways to tackle your problem 🙂

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

Sorry, I didn't realize the headers were written directly into the CSV file. You'll want to skip the first line. Or maybe better, catch and ignore file-doesn't-exist errors like so:

tell application "System Events"

try

set name of file oldFileName of folder "path/to/folder of images" to newFileName

end try

end tell

kittersa wrote:

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

Great 😎

I'm not sure if it's easier to add _1 to every row name in Numbers

If you can add it to a new column, then you could just use a formula:

....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.

To do this, add one line in the script to first Copy and rename (cp) before the rename (mv)

cp "$OldImageName" ~/Documents/"$NewImageName"_1

so the script (to add to Automator) now looks like:

(this will copy and rename first to the Documents Folder)

cd "$1"

while read line

do

OldImageName=${line%,*}

NewImageName=${line#*,}

cp "$OldImageName" ~/Documents/"$NewImageName"_1

mv "$OldImageName" "$NewImageName"

done <"$2"

Oh, if you want the files with _1 in the same folder, just delete ~/Documents/ and use:

cd "$1"

while read line

do

OldImageName=${line%,*}

NewImageName=${line#*,}

cp "$OldImageName" "$NewImageName"_1

mv "$OldImageName" "$NewImageName"

done <"$2"

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

😎