Uploading PDFs to patient's file

For complex topics that regular users would not be interested in. For power users and database administrators.
Post Reply
rasheemo
Posts: 15
Joined: Wed May 27, 2020 6:01 am

Uploading PDFs to patient's file

Post by rasheemo » Tue Nov 10, 2020 7:58 am

Is a .dll plugin the only way to accomplish this or can you read the folder list from the DB and write files in with a DB insert? I looked at the query list and couldn't find anything related to this.

Thanks in advance!

rasheemo
Posts: 15
Joined: Wed May 27, 2020 6:01 am

Re: Uploading PDFs to patient's file

Post by rasheemo » Tue Nov 10, 2020 8:09 am

I remember being pointed to the sheets table, but I don't see reference to folders at all there

User avatar
jordansparks
Site Admin
Posts: 5739
Joined: Sun Jun 17, 2007 3:59 pm
Location: Salem, Oregon
Contact:

Re: Uploading PDFs to patient's file

Post by jordansparks » Tue Nov 10, 2020 6:12 pm

You don't have to involve the db at all. Just drop the files in the the patient's folder. The name of their folder is in the db as patient.ImageFolder. The next time the user opens that patient images module, it will automatically recognize the new file(s) and prompt to add to db. You should never do a db insert or update for any reason.
Jordan Sparks, DMD
http://www.opendental.com

rasheemo
Posts: 15
Joined: Wed May 27, 2020 6:01 am

Re: Uploading PDFs to patient's file

Post by rasheemo » Wed Nov 18, 2020 9:02 pm

Thanks Jordan. How would we specify which folder in the patient's chart we want the PDF to go in without touching the db? Seems like it just goes to a default folder in the patient's chart and can't be categorized

User avatar
drtech
Posts: 1647
Joined: Wed Jun 20, 2007 8:44 am
Location: Springfield, MO
Contact:

Re: Uploading PDFs to patient's file

Post by drtech » Thu Nov 19, 2020 11:27 am

just drag it to the folder you want or right click and change the category from the properties window
David Fuchs
Dentist - Springfield, MO
Smile Dental http://www.887-smile.com

rasheemo
Posts: 15
Joined: Wed May 27, 2020 6:01 am

Re: Uploading PDFs to patient's file

Post by rasheemo » Thu Nov 19, 2020 11:55 am

drtech wrote:
Thu Nov 19, 2020 11:27 am
just drag it to the folder you want or right click and change the category from the properties window
We're uploading the PDFs programmatically and there's no API for this

User avatar
jordansparks
Site Admin
Posts: 5739
Joined: Sun Jun 17, 2007 3:59 pm
Location: Salem, Oregon
Contact:

Re: Uploading PDFs to patient's file

Post by jordansparks » Thu Nov 19, 2020 8:17 pm

Correct. You can't specify the folder. I think it ends up in the first folder. So you could organize the folders with your "in" folder at the top, if that's how it's normally used. I'll think about some sort of special prefix or suffix that could be added to the filename to designate destination folder and maybe import silently.
Jordan Sparks, DMD
http://www.opendental.com

rasheemo
Posts: 15
Joined: Wed May 27, 2020 6:01 am

Re: Uploading PDFs to patient's file

Post by rasheemo » Fri Nov 20, 2020 8:17 am

jordansparks wrote:
Thu Nov 19, 2020 8:17 pm
Correct. You can't specify the folder. I think it ends up in the first folder. So you could organize the folders with your "in" folder at the top, if that's how it's normally used. I'll think about some sort of special prefix or suffix that could be added to the filename to designate destination folder and maybe import silently.
That would be great Jordan, otherwise if we are going to be competitive with other vendors that DO upload to the correct folder, we will have to write to the DB, which nobody wants to do

User avatar
jordansparks
Site Admin
Posts: 5739
Joined: Sun Jun 17, 2007 3:59 pm
Location: Salem, Oregon
Contact:

Re: Uploading PDFs to patient's file

Post by jordansparks » Fri Nov 20, 2020 8:30 am

I think we might be able to add that today to the head, and maybe backport to beta if it looks extremely safe.
Jordan Sparks, DMD
http://www.opendental.com

rasheemo
Posts: 15
Joined: Wed May 27, 2020 6:01 am

Re: Uploading PDFs to patient's file

Post by rasheemo » Sat Nov 21, 2020 10:06 am

jordansparks wrote:
Fri Nov 20, 2020 8:30 am
I think we might be able to add that today to the head, and maybe backport to beta if it looks extremely safe.
Thanks Jordan! and that would work only for offices on the latest version of OD whenever you roll this out i assume

User avatar
jordansparks
Site Admin
Posts: 5739
Joined: Sun Jun 17, 2007 3:59 pm
Location: Salem, Oregon
Contact:

Re: Uploading PDFs to patient's file

Post by jordansparks » Sun Nov 22, 2020 8:19 am

Beta is 20.4. I saw progress on this Friday, but it's not quite done.
Jordan Sparks, DMD
http://www.opendental.com

User avatar
jordansparks
Site Admin
Posts: 5739
Joined: Sun Jun 17, 2007 3:59 pm
Location: Salem, Oregon
Contact:

Re: Uploading PDFs to patient's file

Post by jordansparks » Tue Nov 24, 2020 8:31 pm

It's been posted. Prefix your files with _#_, where # is the DefNum. It will strip off the prefix and then import to the specified category.
Jordan Sparks, DMD
http://www.opendental.com

rasheemo
Posts: 15
Joined: Wed May 27, 2020 6:01 am

Re: Uploading PDFs to patient's file

Post by rasheemo » Thu Nov 26, 2020 5:26 am

Another issue we're facing: not all patients will have a folder designated in the file directory right off the bat. And there's no default naming convention for a folder that maps back to a patient. meaning we would have to go into open dental manually to create a default folder for a patient, and THEN read the db to find out what the physical directory is named, and THEN upload a file there for uptake by OD.

User avatar
jordansparks
Site Admin
Posts: 5739
Joined: Sun Jun 17, 2007 3:59 pm
Location: Salem, Oregon
Contact:

Re: Uploading PDFs to patient's file

Post by jordansparks » Sat Nov 28, 2020 8:45 am

That's a trickier problem. I suppose we could add a pref that creates a folder whenever a patient was created.
Jordan Sparks, DMD
http://www.opendental.com

Post Reply