You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

Separate one sheet feed (scan) of student exam papers and rename according to student number.

The PDF is a scanned image PDF with lots of typed text, images, numbers and handwritten answers. At the top of every page however is the student id (eg "STUDENT NUMBER: 37313344") in font size 11.


I want to be able to separate the file into individual student files (again PDF) so I can distribute these back to the respective students and potentially import into Filemaker to mark onscreen at a later time.


I am hoping some of the ideas shared by VikingOSX may be adaptable and made to work.


I have tried using Chronoscan on a PC which is complicated and obviously not Mac.

Posted on Sep 20, 2024 9:11 PM

Reply
9 replies

Oct 11, 2024 7:19 AM in response to VikingOSX

For a scanned PDF that is not OCR'd in the process of scanning, one will need to use a PDF Editor to OCR that document content. I suggest the paid Code Industry Master PDF Editor (tested with v5.9.85 on 2024-10-11). One can download a free trial which allows one to OCR a scanned PDF in place without watermarking it or having to pay for the application.


Steps

  1. Make a duplicate copy of the PDF in Finder
  2. Know in advance the predominant font used in this PDF.
  3. Open the duplicate PDF in Master PDF Editor.
    1. Document menu > OCR
    2. Install languages (select the language used in the PDF (e.g. English)
    3. Font Family (from font family above)
    4. Editable Text is selected
    5. Advanced
      1. Select Deskew
      2. Minimal confidence level: increase to 80.00
      3. Leave unchecked manual text editing if confidence level not achieved
    6. Click OK
    7. A progress bar will appear as the PDF is OCR'd
    8. Click cmd+S or File menu > Save
  4. Run the Automator application by double-clicking on the Desktop
    1. Select the just OCR'd and saved PDF
    2. Press the ⌘-key and then select the output folder for the student number PDFs
    3. Both items 1 and 2 should be on your Desktop
  5. Observe the PDFs in the output folder bearing the student number and PDF pages associated with that student number.



Sep 21, 2024 8:01 AM in response to Quambone

Welcome!


You found the forum section for asking how to use the forum software. It gets very few views.


If you tell us what Apple device you are using, we can ask the moderators to move your question to a more active and appropriate forum section.


If a software question, there has not been a specific section for FileMaker support in these forums for a very long time. I last time I used FileMaker was before I retired nearly 20 years ago and I've forgotten most of the cool stuff I used to know (age gets to us all!). However, there is a general forum section called "Older Software" that may still have a few FM users still hanging out:


Older Software - Apple Community


TIP: If you start a new thread there, be sure to include "FileMaker" in the title so any old FM gurus can quickly spot it.


Best wishes! FM was a really great tool.


Sep 22, 2024 2:17 PM in response to Quambone

I have AppleScript/Objective-C code that has three phases:

  1. Get the unique, ordered student ID numbers in the PDF
  2. Get all sequential pages in the PDF for each student ID
  3. Write a PDF to a designated folder location that contains all PDF pages associated with that student ID. The PDF name will be the student ID number.


I have tested this in Apple's Script Editor and as an Automator action. Both work. My test document is a 7-page pdf with three student IDs (37313344 - 4 pages, 37313345 - 2 pages, 3711346 - 1 page) and the resulting split PDF documents reflect the same content.


The original PDF remains unchanged.


Tested on macOS Sequoia v15.0 only.


I am using two Automator actions:

  1. Files & Folders : Ask for Finder items
    1. I am choosing to ask for Files and Folders with allow multiple selections (using ⌘ key).
      1. Select the input PDF first, and then the Destination folder for the student's PDF. Order is important.
  2. Utilities : Run AppleScript


Remove the default code in the Run AppleScript action and replace it with the following:


use framework "Foundation"
use framework "PDFKit"
use AppleScript version "2.4"
use scripting additions

property ca : current application

on run {input, parameters}
	
	set pdfURL to ca's NSURL's fileURLWithPath:(POSIX path of (item 1 of (input as list)))
	set outFolder to POSIX path of (item 2 of (input as list))
	set pdf to ca's PDFDocument's alloc()'s initWithURL:pdfURL
	set pdfText to ca's NSString's stringWithString:(pdf's |string|())
	
	set pattern to "(?<=student\\snumber:)\\s*([[:digit:]]+)"
	-- list of all unique student numbers in original PDF
	set student_numbers to ca's NSArray's arrayWithArray:(my students(pdfText, pattern))
	
	repeat with astudent in student_numbers
		-- a list of all pages associated with that student
		set student_pages to my students_pages(pdf, astudent) as list
		-- split out students pages to a separate student number PDF in outFolder
		my students_pdf(pdf, astudent, student_pages, outFolder)
	end repeat
	return
	return input
end run

on students(ptext, regexPat)
	-- return unique list of ordered student numbers in PDF
	
	set sID to ca's NSMutableOrderedSet's new()
	set srange to ca's NSMakeRange(0, ptext's |length|())
	set regex to ca's NSRegularExpression's regularExpressionWithPattern:regexPat options:(ca's NSRegularExpressionCaseInsensitive) |error|:0
	set matches to regex's matchesInString:ptext options:0 range:srange
	repeat with match in matches
		(sID's addObject:(ptext's substringWithRange:(match's rangeAtIndex:1)))
	end repeat
	return (sID's allObjects())
end students

on students_pages(apdf, snumber)
	-- for a student number locate all of their pages in the PDF
	set pageno to ca's NSMutableArray's array()
	set found to apdf's findString:snumber withOptions:(ca's NSLiteralSearch)
	if not ((count of found) = 0) = true then
		repeat with sel in found
			repeat with n in sel's pages()
				(pageno's addObject:(n's label() as text))
			end repeat
		end repeat
		return pageno
	else
		return ["None"]
	end if
end students_pages

on students_pdf(apdf, snumber, pageList, outFolder)
	-- write out PDF bearing student number and their pages split from original
	set outPDF to ((ca's NSString's stringWithString:outFolder)'s stringByAppendingPathComponent:snumber)'s stringByAppendingPathExtension:"pdf"
	set pdfout to ca's PDFDocument's alloc()'s init()
	-- log (outPDF) as text
	
	repeat with n in pageList
		(pdfout's insertPage:(apdf's pageAtIndex:(n - 1)) atIndex:(pdfout's pageCount()))
	end repeat
	pdfout's writeToFile:outPDF
	return
end students_pdf



Sep 21, 2024 8:59 AM in response to Quambone

Anwering the first issue, if you search the web for "export pdf to individual pages" you'll find a number of solutions offered. Which will work best for you will depend on your exact situation, including whether each student exam paper is a single page or consists of multiple pages, and of course budget. Adobe's Acrobat can export a PDF to single pages, but of course it's not free.


I haven't used FileMaker in a long time so its current ability to import PDFs I'm not sure about. It won't be able to recognize the student numbers or other text, though, unless you use an OCR package to convert those PDFs into reable text. Claris, maker of FileMaker, has their own community here where you can get help with FileMaker questions:


https://community.claris.com/en/s/


Regards.

Sep 21, 2024 8:01 PM in response to Allan Jones

Thank you Allan,


I was not clear. This is more about renaming the split files with the student ID number.

Essentially I want to return the students handwritten scanned exams to them via a mail merge.

The entire scanned PDF could be 1500 pages long, comprising 100 student exams each of which are 15 pages long and all of which have the relevant student ID number at the top. I have a separate spreadsheet with the student email addresses and their student ID that I can use to easily send them their scanned exam if I can just split the big combined PDF and rename the new 15 page PDFs that it can be split into.


I saw a post from VikingOSX using Automator that seemed to do something similar for someone that had one page invoices but Im not sure if they were scanned PDF images or had searchable text.


Separate one sheet feed (scan) of student exam papers and rename according to student number.

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.