Apple Script to rename images using CSV file

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

In Numbers,

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

You can then convert the formula in col D to the concatenate string by selecting the column, copy (⌘C), then Paste Formula Results (⇧⌘V). and delete col B and C

I really appreciate this thread. I'm trying to do something similar with .wav files. I have a CSV with col 1 being a non-descript filename (HiFe_345.wav) and I want to give it a familiar name (CrowCall_02.wav) which is listed in col 2 in my CSV file.

I've set up an Automator Workflow with the Shell Script as shown.

It ran perfectly... except, all my .wav files are now considered "documents" and won't open/play.

becomes

If I manually delete the .wav extension and retype ".wav", Finder prompts me to confirm I want to change the filetype. Should I not include the file type extension in the familiar name column in my CSV? There are way too many files to manually change all the extensions... do I need to run another automator workflow?

Thanks Tony,

No spaces. I tried adding a rename file extension task to the workflow.... but it still produces a "document".

Manually changing the extension properly restores the file to a working .wav file. Strange.

neither of those worked.

Not sure if this is relevant, but the line: rm $OldImageName" didn't have a preceeding " so I added one. (The script as written was throwing an error.)

So, rm "$OldImageName" allowed it to run correctly. However... the files produced are still "documents" and not .wav files.

Bah! Same result.

I'm wondering about the shell script, and possible typos... should

NewImageName=

${line#,*}

and not

${line#*,}

UPDATED:

Clearly not. Making this change just adds the two names together.

I'm super novice script man.

Message was edited by: bj49wd

Hey Tony,

I really appreciate your help on this. I don't want to beat a dead horse, nor do I want anyone else to on my behalf. I thought I'd just add one last update to this thread:

When I rename the file... I notice that there is a carriage return AFTER the extension! This line break isn't apparent in my CSV file, and I'm not sure where it's coming from.

Trying to rename the file reveals that there is a space beneath the file name. After I delete it—just the space—I get an alert about changing the extension. The option to keep the current extension ALSO has the line break.

Food for thought.

Hmm, no deal for either solution. Somehow, a return is still getting added to the end of the file extension.

I wonder if adjusting the CSV to hold the file name only, and then add the extension via the workflow... might that be a workaround? (clueless)

I appreciate your help here, if you have better things to do than to mess with this, I totally understand!😀

Got it. Need $'\r'

Words of the form $'string' are treated specially. The word expands to string, with backslash-escaped characters replaced as specified by the ANSI C standard

This should do it 🙂

NewImageName=${NewImageName//$'\r'}

so:

while read line

do

OldImageName=${line%,*}

NewImageName=${line#*,}

NewImageName=${NewImageName//$'\r'}

mv "$OldImageName" "$NewImageName"

done <"$2"

Interesting... the original spreadsheet did come from an external source, most likely Excel and then was delivered to me via Google Docs... and then I messed with it in Numbers... I wonder if there's a "Show Invisible Characters" feature in Numbers...?

Thanks again!

Hi, Sorry to add to this thread, but I'm strapped for time and I need assistance with the scripts described here; I am not able to get any of them to work. My situation is almost identical: The images are in a folder called "images" on my desktop (~/Desktop/images) and the csv file is contained within it (~/Desktop/images/SND.csv)

So, for example in line 1:I would like the file named 0031.jpg to be changed to 31-Dallas Morning News.jpg. I've been at this problem for a while, so any assistance would be greatly appreciate it.

Thanks for the prompt reply.

Originally, when running the script, there was no error, but there was no affect on any of the images.

On a second try, I omitted the first line cd ~/[Desktop]/images and tried saving the script in the folder with everything else and running it from there. At that point, I get a "while: bad interpreter: No such file or directory" error message in the terminal.

Nothing shows on the desktop at either point.

Perhaps I am executing the script incorrectly?

I used SublimeText to create a new script, which i called "rename.sh." I then navigated to it's directory, changed the permissions using the following command: "chmod +x ./rename.sh." I then ran it using the "./rename.sh" command.

Let me know if you need further details and thanks again.

Make sure that the 1st line in the script is:

#!/bin/bash

If it still doen not work, try using TextEdit and save as a Plain Text File

(TextEdit->Format->Make Plan Text)

If it still does not work, in Terminal, what do you get when you run: which bash

Still not working; when I run the script from the desktop directory, I get no errors and no affect on the images in the folder.

When the script is run from the images directory, I get the following, based on whether or not I include the first (second after #!/bin/bash) line.

cd: bad interpreter: No such file or directory

-or-

while: bad interpreter: No such file or directory

which bash yields "/bin/bash"

""

The above is what shows in "Result" when run as an AppleScript - still no effects on the image files.

Could it be a permissions issue on the image files themselves? I have Read & Write access to each image but "Everyone" and "staff" has Read only permission.

It will not allow me to. Keeps telling me there is an error. I can only post a small part.

ˇÿˇ‡

'

=

T

j

Å

ò

Æ

≈

‹

Û " 9 Q i Ä ò ∞ » · ˘ * C u é ß ¿ Ÿ Û

&

@

Z

t

é

©

√

fi

¯ . I d  õ ∂ “ Ó % A ^ z ñ ≥ œ Ï & C a ~ õ π ◊ ı 1 O m å ™ … Ë & E d Ñ £ √ „ # C c É § ≈  ' I j ã ≠ Œ  4 V x õ Ω ‡ & I l è ≤ ÷ ˙ A e â Æ “ ˜ @ e ä Ø ’ ˙ E k ë ∑ › * Q w û ≈ Ï ; c ä ≤ ⁄ * R { £ à ı G p ô √ Ï @ j î æ È > i î ø Í A l ò ƒ ! !H!u!°!Œ!˚"'"U"Ç"Ø"›#

#8#f#î#¬#$ $M$|$´$⁄% %8%h%ó%«%˜&'&W&á&∑&Ë' 'I'z'´'‹(

(?(q(¢(‘) )8)k)ù)–* *5*h*õ*œ+ +6+i+ù+—, ,9,n,¢

ÅkÅÕÇ0ÇíÇÙÉWÉ∫Ñ ÑÄÑ„ÖGÖ´Ü ÜrÜ◊á;áüà àiàŒâ3âôâ˛ädä ã0ãñã¸åcå ç1çòçˇéféŒè6èûê ênê÷ë?ë®í ízí„ìMì∂î îäîÙï_ï…ñ4ñüó

óuó‡òLò∏ô$ôêô¸öhö’õBõØú úâú˜ùdù“û@ûÆü üãü˙†i†ÿ°G°∂¢&¢ñ£ £v£Ê§V§«•8•©¶ ¶ã¶˝ßn߇®R®ƒ©7©©™ ™è´ ´u´È¨¨–≠D≠∏Æ-Æ°Ø Øã∞

æÑæˇøzøı¿p¿Ï¡g¡„¬_¬€√X√‘ƒQƒŒ≈K≈»∆F∆√«A«ø»=»º…:…π 8 ∑À6À∂Ã5õÕ5ÕµŒ6Œ∂œ7œ∏–9–∫—<—æ“?“¡”D”∆‘I‘À’N’—÷U÷ÿ◊◊‡ÿdÿËŸlŸÒ⁄v⁄˚€Ä‹ ‹ä› ›ñfi fi¢fl)fl؇6‡Ω·D·Ã‚S‚€„c„Ήs‰¸ÂÑÊ

ÊñÁ Á©Ë2˺ÈFÈ–Í[ÍÂÎpÎ˚ÏÜÌ ÌúÓ(Ó¥Ô@ÔÃXÂÒrÒˇÚåÛ ÛßÙ4Ù¬ıPıfiˆmˆ˚˜ä¯ ¯®˘8˘«˙W˙Á˚w¸ ¸ò˝)˝∫˛K˛‹ˇmˇˇˇ· 2Exif

<rdf:RDF xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#">

<rdf:Description rdf:about=""

xmlns:dc="http://purl.org/dc/elements/1.1/">

<dc:description>

<rdf:Seq>

<rdf:li xml:lang="x-default"/>

</rdf:Seq>

</dc:description>

<dc:subject>

<rdf:Bag/>

</dc:subject>

<dc:title>

<rdf:Seq>

<rdf:li xml:lang="x-default">Vanderploeg010</rdf:li>

</rdf:Seq>

</dc:title>

</rdf:Description>

</rdf:RDF>

</x:xmpmeta>