Apple Script to rename images using CSV file

To work with a tab delimited file, change:

OldImageName=${line%,*}

NewImageName=${line#*,}

to:

OldImageName=${line%$'\t'*}

NewImageName=${line#*$'\t'}

That is what I thought too but no dice. I wonder if my file is the issue?

Got it. Had to resave file to format "Windows Formatted Text"

>That is what I thought too but no dice. I wonder if my file is the issue?

Could be the line endings in the file. The script is expecting a UNIX \n, but could be a Windoes \r\n

Need to see what line endings are used in your csv file:

In Terminal, try cat -e on the text file to view the line endings (if a UNIX \n you'll see $ at the end, if Windows, you'll see ^M$)

If it is a non-UNIX file, you can convert the file with tr by deleting the carriage return \r:

tr -d '\r' < ~/Desktop/originalfile.csv > ~/Desktop/Newfile.csv

Then you can run the script on Newfile.csv

edit: Never mind, I see now that you solved it.

Thanks Tony. I like your solution and you were right it was seeing the windows format. Now all I have to do is get it to see leading zeros in the old file name. Thanks you again.

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!

If I understand correctly, you have a csv file (in a plain text file named TheFile.csv), for example:

test.pdf,testNew.pdf

test2.pdf,test2New.pdf

And you want to search for the 1st item in the csv file in a directory structure one level below where the search is to start (and rename that file to the 2nd item in the csv file).

So, if the Folders Structure you posted is on your Desktop, to search those folders (but not folders within those folders)

Try:

#!/bin/bash

cd ~/Desktop

while read line

do

OldImageName=${line%,*}

NewImageName=${line#*,}

find . -mindepth 2 -maxdepth 2 -name "$OldImageName" -execdir mv {} "$NewImageName" \;

done <"TheFile.csv"

(Note: Test before using on your data)

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!

You can use Automator, which will prompt you for the Folder to search.

Below is from the previous pages in the thread.

This will also convert line endings if necessary.

You just need to change the Run Shell Script Action to:

cd "$1"

tr '\r' '\n' < "$2" > ~/Desktop/file.tmp

while read line

do

OldImageName=${line%,*}

NewImageName=${line#*,}

find . -mindepth 2 -maxdepth 2 -name "$OldImageName" -execdir mv {} "$NewImageName" \;

done < ~/Desktop/file.tmp

rm ~/Desktop/file.tmp

https://discussions.apple.com/content/attachment/580142040

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

Or tr -d '\r' < dosfile > unixfile.

Tony this worked perfectly! Thank you so much for your help!!!

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:

antegrav88 wrote:

Tony this worked perfectly! Thank you so much for your help!!!

Great. 😎

Okay. Didn't have a Windows exported Excel CSV to test here, and you have cleared that line ending issue up.