Hey Matze,
You can't make changes willy-nilly to a system and expect things to continue work properly.
When you changed the file name convention in column one from “1.pdf” to “1” (Number.Suffix to Number) the AppleScript pulled real number values for those items instead of text.
I have updated the script in Post #28 to version 1.51 to forcefully pull string values for the column one items.
BUT – the script is designed to work with Number.Suffix formatted file names in column one.
This was clearly explained in Post #18:
The format for the Excel rename template:
| Old Name | New Name |
|---|---|
1.pdf |
Kroell |
2.pdf |
Schroeder |
3.pdf |
Vollmer |
By happenstance – when I changed value to string value the script actually does work with numerical values only in column one (i.e. without the file suffix .pdf) – but that's just dumb luck.
The devil is in the details, and changing details without understanding exactly what you're doing will often get you burned.
I will post a macro soon that is a complete one to one name swap – OldName to NewName.
-Chris