I have created basic patient records. The basic information is
patient_data: fname, lname, street, pid, pubid, and usertext1
I have also uploaded their word docx files to their respective folders. what should have happened is that there should be one file per one folder. So for example, patient with PID of 7 should have one file in …documents/7/wordfile.docx. the usertext1 has the actual word file name in it. so the mapping should go:
patient_data.pid = ..documents/pid/ and patient_data.usertext1 = ..documents/pid/usertext1
I would like to cross check the data I have in my patient_data table with the folder and file names in the documents dir. Anyone know how to easily do this with BASH or Python?