bulk file rename using csv

Good.

The following works on Mojave 10.14.6 (18G6020) as an Automator application. It prompts twice: 1) image folder, and 2) CSV file. I have enhanced it to automatically deal with Windows line endings in the CSV (if encountered), ignore any CSV header row, provided it finds oldfile in the header, and as previous, trims any double-quotes from the column items.

Here is the code for the Run Shell Script:

DIR="$1"
shift
CSV="$1"

# unnecessary, but if the CSV file doesn't exist, exit
[[ -s "$CSV" ]] || exit 1

cd "${DIR}"

# Dynamically adapt IFS to different CSV delimiters

# while IFS=$'\t,;:!' read oldfile newfile
while IFS=, read oldfile newfile
do
	# do not process headings
	[[ oldfile = "oldfile" ]] || continue

    # Skip entry if old filename in CSV doesn't exist in current folder
    [[ -e $oldfile ]] || continue
  
    #printf '%s\t%s\n' "$oldfile" "$newfile" > ~/Desktop/mycsv.txt

    # rename.
    mv "${oldfile}" "${newfile}"
# remove any double-quoted items and if from Windows, trim the CR from the line
done < <(sed -e 's/"//g;' "${CSV}" | tr -d '\r')

sleep 1
/usr/bin/osascript -e 'display dialog "Processing complete."' &> /dev/null
exit 0

Replace the Do Shell Script code with the following content. It is tested using your updated CSV data items, and works fine here.

DIR="$1"
shift
CSV="$1"

# unnecessary, but if the CSV file doesn't exist, exit
# [[ -s "$CSV" ]] || exit 1

cd "${DIR}"

# Dynamically adapt IFS to different CSV delimiters
while IFS=$'\t,;:!' read oldfile newfile
do
	# do not process headings
	[[ ! "${oldfile}" =~ \.(jpg|jpeg|png)$ ]] && continue

    # Skip entry if old filename in CSV doesn't exist in current folder
    [[ -e "${oldfile}" ]] || continue
  
    # printf '%s\t%s\n' "$oldfile" "$newfile" > ~/Desktop/mycsv.txt

    # rename.
    /bin/mv "${oldfile}" "${newfile}"
# remove any double-quoted items and if from Windows, trim the CR from the line
done < <(sed -e 's/"//g;' "${CSV}" | tr -d '\r')
# done < "${CSV}"

sleep 1
/usr/bin/osascript -e 'display dialog "Processing complete."' &> /dev/null
exit 0

A proper CSV does not have multiple, trailing empty fields in it, which your five commas represent. I have altered the script to automatically trim those commas from the newfile variable if present.

In the third category, the forward slash in the output filename, whether unescaped, or escaped, is invalid, and I have added code to replace that forward slash with an underscore, which does allow the script to process the third category.

DIR="$1"
shift
CSV="$1"

# unnecessary, but if the CSV file doesn't exist, exit
# [[ -s "$CSV" ]] || exit 1

cd "${DIR}"

# Dynamically adapt IFS to different CSV delimiters
while IFS=$'\t,;:!' read oldfile newfile
do
	# do not process headings
	[[ ! "${oldfile}" =~ \.(jpg|jpeg|png)$ ]] && continue

    # Skip entry if old filename in CSV doesn't exist in current folder
    [[ -e "${oldfile}" ]] || continue

	# strip any trailing empty column delimiters from end of newfile
	newfilex="${newfile//[,;:!\t]/}"
	# replace any detected illegal forward slash with an underscore
	newfilex="${newfilex//\//_}"

    # rename files
    /bin/mv "${oldfile}" "${newfilex}"
# remove any double-quoted items and if from Windows, trim the CR from the line
done < <(sed -e 's/"//g;' "${CSV}" | tr -d '\r')
# done < "${CSV}"

sleep 1
/usr/bin/osascript -e 'display dialog "Processing complete."' &> /dev/null
exit 0

The last code that I posted only accepts a true CSV with commas for delimiters. I have tested with your old and new filename examples, including those with five trailing commas indicating five empty columns. The code works here and renames correctly.

Don't be appending different CSV content with different delimiters to the same file, that will surely gum things up. I have code in place to remove double-quoted strings. The script also handles Windows and Mac row endings.

Post a few lines of text here representing the oldname,newname of the CSV content that does nothing. Let me test it on my end to see if there is something causing the issue.