Need Help with AppleScript

Here's an update that adds #3 and #4 in your question.

Just save this this file as RenameAndMove.py on your desktop, and if you're not comfortable in Terminal, then just create a 1 line AppleScript, (edit for your desktop path) with:

do shell script "/usr/bin/python3 /Users/Tony/Desktop/RenameAndMove.py"

And then copy this into TextEdit, and save as a plain text file as: RenameAndMove.py

#!/usr/bin/python3

import os
import csv

InputDir = "/Users/Tony/Desktop/InputDir"
ErrorDir = "/Users/Tony/Desktop/ErrorDir"
ProcessedDir = "/Users/Tony/Desktop/ProcessedDir"
with open('/Users/Tony/Desktop/data.csv') as csvfile:
	reader = csv.DictReader(csvfile, delimiter = '\t')
	f1 = open('/Users/Tony/Desktop/Errors.txt', 'w')
	f2 = open('/Users/Tony/Desktop/Processed.txt', 'w')
	f1writer = csv.writer(f1)
	f2writer = csv.writer(f2)
	header = ['FirstName', 'LastName', 'StudentID', 'Grade', 'FileName']
	f1writer.writerow(header)
	f2writer.writerow(header)
	for row in reader:
		if not row['StudentID']:
			newFileName = row['Grade'] + '_' + row['LastName'] + '_' + row['FirstName']
			oldFileNamePath = os.path.join(InputDir, row['FileName'])
			newFileNamePath = os.path.join(ErrorDir, newFileName)
			os.rename(oldFileNamePath, newFileNamePath)
			newrow = [row['FirstName'],row['LastName'],row['StudentID'],row['Grade'],newFileName + ".jpg"]
			f1writer.writerow(newrow)
		elif row['StudentID']:
			newFileName = row['StudentID'] + ".jpg"
			oldFileNamePath = os.path.join(InputDir, row['FileName'])
			newFileNamePath = os.path.join(ProcessedDir, newFileName)
			os.rename(oldFileNamePath, newFileNamePath)
			newrow = [row['FirstName'],row['LastName'],row['StudentID'],row['Grade'],newFileName + ".jpg"]
			f2writer.writerow(newrow)
	f1.close()
	f2.close()

Didn't follow your naming convention of: "1) Folder named with name of input folder & “_” & “Processed”  i.e.   If input folder is named Branford, output folder would be Branford_Proceessed  and 2) Folder named with name of input folder & “_” & “Errors”  i.e., If input folder is named Branford output folder would be Branford_Errors", but that should be easy for you to edit in the python script

I only took a quick look, but I think you need to reference as file or alias (not as text )

    move ((inFolder & anItem's name) as file) to folder outFolder1

I did look at your code (nice work), but without any sample data I wasn't able to test, but if you've got everything working but the renaming of the file, I would think that it could be done with the following after changing file01.jpg and file02.jpg and desktop to your variables:

tell application "Finder" to set name of file "file01.jpg" of desktop to "file02.jpg"

(you should already be in a: tell application "Finder" to block, so you can delete that in your code)

OK, so after banging my head against the wall with AppleScript (I hate AppleScript 😄),

I decided to go the easier route with python (you can call this python script in AppleScript with:

do shell script "/usr/bin/python3 /Users/Tony/Desktop/RenameAndMove.py"

..changing the path of the py script.

I handled the first part of your question, and did not do "The last thing is to produce two txt files as explained in # 3 and 4 below. "

You will see that python is much more concise (..and change the Directory paths to yours):

#!/usr/bin/python3

import os
import csv

InputDir = "/Users/Tony/Desktop/InputDir"
ErrorDir = "/Users/Tony/Desktop/ErrorDir"
ProcessedDir = "/Users/Tony/Desktop/ProcessedDir"
with open('/Users/Tony/Desktop/data.csv') as csvfile:
	reader = csv.DictReader(csvfile, delimiter = '\t')
	for row in reader:
		if not row['StudentID']:
			newFileName = row['Grade'] + '_' + row['LastName'] + '_' + row['FirstName']
			oldFileNamePath = os.path.join(InputDir, row['FileName'])
			newFileNamePath = os.path.join(ErrorDir, newFileName)
			os.rename(oldFileNamePath, newFileNamePath)
		else:
			newFileName = row['StudentID'] + ".jpg"
			oldFileNamePath = os.path.join(InputDir, row['FileName'])
			newFileNamePath = os.path.join(ProcessedDir, newFileName)
			os.rename(oldFileNamePath, newFileNamePath)

I didn't follow your naming convention of: "1) Folder named with name of input folder & “_” & “Processed”  i.e.   If input folder is named Branford, output folder would be Branford_Proceessed  and 2) Folder named with name of input folder & “_” & “Errors”  i.e., If input folder is named Branford output folder would be Branford_Errors", but that should be easy to edit in the python script. I'll look into items #3 and #4

To have the operator select the input file as the first step, we just need to add arguments to the script.

Better to first run from Terminal for you to test this (Are you the only user of the script?)

Should be possible to add this to AppleScript, Automator or Shortcuts, but let's get the script to work for you first.

Copy this script into TextEdit and save as a plain text file named RenameAndMove.py (or any name you want)

Then:

1. Open Terminal.
2. Enter "chmod u+x", a space, then 'drag' the script into the Terminal Window and press return

(the script is now executable)

3. Drag the python script into the Terminal Window, drag the csv file into the Terminal Window,

and then drag the Input Folder into the Terminal Window and press return

And, as always, test the python script on copies of your data and files

(This worked for me using the data you provided)

#!/usr/bin/python3

import sys
import os
import csv

if ((len(sys.argv) != 3)):
	exit("usage: " + os.path.basename(sys.argv[0]) + " file_containing_list" + " copy_from_folder" )

file_containing_list = sys.argv[1]
copy_from_folder = sys.argv[2]

ErrorDir = copy_from_folder + "_errors"
if not os.path.exists(ErrorDir):
	os.mkdir(ErrorDir)
ProcessedDir =  copy_from_folder + "_processed"
if not os.path.exists(ProcessedDir):
	os.mkdir(ProcessedDir)
errors_txt = os.path.dirname(copy_from_folder) + "/Errors.txt"
processed_txt = os.path.dirname(copy_from_folder)  + "/Processed.txt"

with open(file_containing_list) as csvfile:
	reader = csv.DictReader(csvfile, delimiter = '\t')
	f1 = open(errors_txt, 'w')
	f2 = open(processed_txt, 'w')
	f1writer = csv.writer(f1)
	f2writer = csv.writer(f2)
	header = ['FirstName', 'LastName', 'StudentID', 'Grade', 'FileName']
	f1writer.writerow(header)
	f2writer.writerow(header)
	for row in reader:
		if not row['StudentID']:
			newFileName = row['Grade'] + '_' + row['LastName'] + '_' + row['FirstName']
			oldFileNamePath = os.path.join(copy_from_folder, row['FileName'])
			newFileNamePath = os.path.join(ErrorDir, newFileName)
			if os.path.exists(oldFileNamePath):
				os.rename(oldFileNamePath, newFileNamePath)
				newrow = [row['FirstName'],row['LastName'],row['StudentID'],row['Grade'],newFileName + ".jpg"]
				f1writer.writerow(newrow)
		elif row['StudentID']:
			newFileName = row['StudentID'] + ".jpg"
			oldFileNamePath = os.path.join(copy_from_folder, row['FileName'])
			newFileNamePath = os.path.join(ProcessedDir, newFileName)
			if os.path.exists(oldFileNamePath):
				os.rename(oldFileNamePath, newFileNamePath)
				newrow = [row['FirstName'],row['LastName'],row['StudentID'],row['Grade'],newFileName + ".jpg"]
				f2writer.writerow(newrow)
	f1.close()
	f2.close()

JB001 wrote:

Yes, let's get it working for me first. Then we really need to get it to work with either AppleScript or automator.

So, to make it easier, lets run the python script into Automator (easier than AppleScript).

You'll still need to have a copy of the python script you saved on your Desktop (or any Folder you choose)

Open Automator, and select: New Document->Application

This screenshot will show the 3 actions needed (Note my highlights)

Save, then just click the Automator App to Run

The Run Shell Script Action is:

/usr/bin/python3 /Users/Tony/Desktop/RenameAndMove.py "$1" "$2"

I've noticed this question has been getting views but no replies.

This may get you started.

Picking your input data folder:

set myFolder to (choose folder with prompt "Please pick just one folder" default location (path to desktop) without multiple selections allowed)

--> Returns an alias to the folder which allows the variable to be used as-is with the "choose file" command

Choosing your data file:

set sourceFile to (choose file with prompt "Please select just one text file" of type "zip" default location myFolder without multiple selections allowed)

I would use the read command to access your text file then parse each record individually in a separate handler.

I am self-taught so feel comfortable saying there is probably a better way to do this but these suggestions may get the ball rolling.

Hope this helps.

The first thing I'd try is to enclose the Name property text in parentheses, "{name:( {name:(jobName & "_errors" as string)}) to force your script to resolve that into a string before it tries to assign it to the name.

This command is seeing something it doesn't recognize and this might be the only issue.

If this works then do the same with your "Processed" files.

I'm not at all conversant in Objective-C so can't help much there.

Renaming files should be as quick as "set the name of file myFile to Grade & "_" & lastName & "_" & firstName & ".jpg"

Hope this helps. B

Try this:

-- Move and rename error files
	set outFolder1 to (make new folder at adesktop with properties {name:jobName & "_errors"}) as string
	set matchList to (every item in folder inFolder whose name is in errorList) as alias list
	repeat with anItem in matchList
		move ((inFolder & anItem's name) as file) to folder outFolder1
	end repeat