How to Organize PDFs and PNGs with PowerShell ISE for Patient Records?
Asked by
CuriousCoder92
Hi everyone! I'm an intern support engineer at a hospital, and I'm working on a project that involves organizing files. Here's the deal: I have a folder structure where each folder is linked to unique consultation IDs. Inside each main folder, there are two subfolders: "report" that contains PDF files and "imagesets" that has PNG images.
My main task is to compare the PDFs in the "report" folders with the PNGs in the "imagesets" folders. I've already extracted patient info from the PDFs, but I'm stuck on how to match the images to the reports and create a new folder structure organized by the patient's name and consultation day. The new structure should also have a separate folder for unused images.
I want to know how I can achieve this using PowerShell ISE. Any guidance or script examples would be super helpful!
Answers
Before automating the process, ensure you really need to sort these files. What’s the end goal? It sounds like you're aiming for better archiving, which is great for saving storage space. But make sure your process is actually benefiting the overall project goals and not just adding more work for yourself!
Reply to this answer
It sounds like a challenging but rewarding project! I'd recommend starting by creating a temporary folder to gather all your files. You can write a script that will loop through all the nested folders and bring everything to the root of your temp folder.
Next, you might want to keep a CSV file with all the patient names. Your script can then use regex to match the patient names against the files in your root folder. Any matched files can be moved into a new folder named after the patient. For anything that doesn't match, you might need to handle them manually later on.
Reply to this answer
Instead of scrambling to organize everything right away, consider using metadata! It can make your life much easier. Rather than sorting through and moving files endlessly, you can present the data however you want without changing the file locations. It'll save you from diving deep into organizing nested folder structures.
Reply to this answer
Add your answer
Answers are reviewed before publication.
Related Discussions