Need Help with AppleScript

I have a Tab delimited .txt file with 23 columns and several hundred records. FileName is one of the 23 fields. I also have a folder of .jpg files that match the filenames in the txt file.

I need to read input .txt file and If the StudentID field is not blank, rename the associated .jpg file with the StudentID.jpg and move it to a Processed output folder.

if StudentID field is blank rename the associated .jpg file in the input folder with Grade_LastName_FirstName.jpg and move the file to the “Errors” output folder. The last thing is to produce two txt files as explained in # 3 and 4 below. These new txt files will be reference files to go with each output folder. The output folders and txt files can be created on the desktop.

Inputs:

1) Operator selected Folder containing .jpg files - default location desktop

2) Operator selected Tab delimited .txt file with 23 columns - first record is header with field names

Input File has the following fields:

SequenceNumber

FirstName

LastName

StudentID

Teacher

Grade

HomeRoom

Custom1

Custom2

Custom3

Custom4

Retouch

Spray

FileName

GSBR

Outputs to be created by AppleScript - Script will move renamed files to these two folders:

1) Folder named with name of input folder & “_” & “Processed” i.e. If input folder is named Branford, output folder would be Branford_Proceessed

2) Folder named with name of input folder & “_” & “Errors” i.e., If input folder is named Branford output folder would be Branford_Errors

3) Tab delimited .txt file with fields FirstName LastName StudentID Grade FileName from the input file for each record that has a StudentID. File should be named with name of input Folder & “_” & “Processed” i.e. If input Folder is named Branford, output file would be Branford_Processed.txt

4) Tab delimited .txt file with fields FirstName LastName StudentID Grade FileName from the input file for each record that did not contain a StudentID. File should be named with name of input Folder & “_” & “Errors” i.e. If input Folder is named Branford, output file would be Branford_Errors.txt

Any help will be soooo much appreciated.

Posted on Jan 7, 2023 11:07 AM

Similar questions

Applescript: Copy files from a folder that contains jpegs using txt files that contains unique codes I found this very helpful thread: Automator/Applescript: Copy Files to Fold… - Apple Community This really helped me! But my situation is a bit different. My list only contains the unique codes. So I need to copy all the files that contains the list of unique codes on their filenames. This is the code that I am using: (I got from the mentioned thread) --------------------------------------------------------------------------------------------------------------- property defloc : (path to desktop as text) as alias property msg1 : "Select the input folder" property msg2 : "Select the output folder" property msg3 : "Select the input file with filenames" use scripting additions set name_list to {} set match_list to {} try set infolder to (choose folder default location defloc with promptmsg1 without invisibles, multiple selections allowed and showing package contents) set outfolder to (choose folder default location defloc with promptmsg2 without invisibles, multiple selections allowed and showing package contents) set name_file to (choose file default location defloc with promptmsg3 without invisibles, multiple selections allowed and showing package contents) display dialog infolder's POSIX path & return & outfolder's POSIX path & return & name_file's POSIX path -- read names from file into quoted filename list set name_list to read name_file as «class utf8» using delimiter linefeed with timeout of 1800 seconds tell application "Finder" -- get every filename in infolder hierarchy whose filename matches names in name list set match_list to (every item of entire contents of folder infolder whose name is in name_list) as alias list -- copy the files to outfolder with exact permissions and overwrite if required repeat with anItem in match_list duplicate anItem to outfolder with replacing and exact copy end repeat end tell end timeout on error errmsgnumbererrnbr my error_handler(errnbr, errmsg) end try return on error_handler(nbr, msg) return display alert "[ " & nbr & " ] " & msg as critical giving up after 10 end error_handler --------------------------------------------------------------------------------------------------------------- My list contains only the unique codes: (screenshot below) But from the folder where I want my script to copy some files contains variants of the unique codes from my list. I hope someone could help me. Thanks!
674 10

46 replies

JB001 Author

Level 1

6 points

Jan 12, 2023 10:38 AM in response to Tony T1

One other thing. The files in the errors folder show up as documents because they don't have an extension. If I manually add .jpg the image shows.

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Need Help with AppleScript