Data Drop from Excel into Patient Information-

For complex topics that regular users would not be interested in. For power users and database administrators.
Post Reply
Data Resources
Posts: 1
Joined: Tue Nov 25, 2008 8:09 am

Data Drop from Excel into Patient Information-

Post by Data Resources » Tue Nov 25, 2008 8:21 am

I would like to know if it is possible to merge files from excel into the family portion of the patient information?

Our organization receives patient information referrals in an excel format. Instead of manually entering the patient information manually, we would like to merge to data from the excel lists into Open Dent.

Is this possible?
Top
User avatar
jordansparks
Site Admin
Posts: 5746
Joined: Sun Jun 17, 2007 3:59 pm
Location: Salem, Oregon
Contact:
Contact jordansparks

Re: Data Drop from Excel into Patient Information-

Post by jordansparks » Tue Nov 25, 2008 2:20 pm

You could write an Excel script to convert your spreadsheet to an XML file following this structure:
http://www.open-dent.com/manual/import.html
It will not be trivial.
Jordan Sparks, DMD
http://www.opendental.com
Top
Post Reply

Return to “Advanced Topics”