Automating Data Capture of PDF & Images
It's always interesting to measure the metrics of how long something takes. Adding automation to a process not only saves time, but makes it less mentally taxing. This increases the sense of accomplishment and can make the process itself more gratifying.
I remember being at an amusement park and showing my kids how to measure the amount of time they might be in line by counting the amount of time it took between each time a roller coaster pulled in and how many people it accommodated. By then counting how many people were in line before them, they would know approximately how long they would be waiting.
This same type of thought process can be applied to any routine task within FileMaker. With the knowledge of the tools available, you can likely automate that task such that you reduce the total time it takes. That's the bulk of what we're doing when we're making software - simply reducing the amount of time it takes to do things.
In this video, I walk through the process of automating text capture from either a PDF or image files. FileMaker has built-in features on the Macintosh and it can certainly be accomplished within Windows as well. If there's anytime you're working with a PDF, PNG or JPG, then let's learn about the tools we have for automating the capture of data.
Comments
Extracting data from images
Hello Matt,
This was interesting and useful, to be sure, but I was hoping you would discuss data extraction from the PNG you saved to the desktop. What sort of data can you get from a PNG, for example, and is that automated in the same way as the PDF file you used?
It was shown in the video
The second (or third) time I brought something into the container field it was the PNG file. The script also showcases using the GetLiveText function. This did extract the data from the PNG image for capture.
If you're needing to do this on the Windows side of things you'll likely need to use a plug-in like MBS and OCR the image to extract the text. Either that, or you'll need to install an OCR binary into the OS and have it process and hand the text back to FileMaker.
Unless you're looking for something else?
-- Matt Petrowsky - ISO FileMaker Magazine Editor
Sometimes the container field doesn't show the thumbnail preview
Hi Matt,
Sometimes the container field doesn't show the thumbnail preview - it shows the filename and an OS icon (MacOS, FMp 19.6)
Is that a limitation of the file being displayed, or a container setting, or something else?