Fee Schedule MYSQL Table

For complex topics that regular users would not be interested in. For power users and database administrators.
Post Reply
User avatar
Manny Ramirez
Posts: 129
Joined: Tue Mar 06, 2012 3:07 pm
Location: Miami/Puerto Rico
Contact:

Fee Schedule MYSQL Table

Post by Manny Ramirez » Tue Aug 21, 2012 8:06 pm

A doctor has my same fee schedules. I would like to copy the fee without having to export and import each and every schedule.
Question? What file can I copy inside his database to import into mine ?
Manny Ramirez
Senior Network Engineer
E-ssential Networks LLC

User avatar
jsalmon
Posts: 1553
Joined: Tue Nov 30, 2010 12:33 pm
Contact:

Re: Fee Schedule MYSQL Table

Post by jsalmon » Tue Sep 25, 2012 10:08 am

Although it's tedious, exporting and importing each and every fee schedule is the safest way to do it. Your fee schedule's have unique keys that I can almost guarantee are different then his keys which means copying his file into your database will cause a plethora of errors in the system. The only other way to do this would be a custom query copying or updating his database table into yours but even that has consequences if done incorrectly. We would most likely charge a fee to do that for you (if it's even possible to do accurately). I'd recommend exporting and importing a couple of fee schedules a day. That tool was written for this exact purpose so it's my preferred suggestion.
The best thing about a boolean is even if you are wrong, you are only off by a bit.

Jason Salmon
Open Dental Software
http://www.opendental.com

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

Re: Fee Schedule MYSQL Table

Post by jordansparks » Sun Oct 07, 2012 5:18 pm

It would be a feature request to add the capability to do multiple fee schedules simultaneously.
Jordan Sparks, DMD
http://www.opendental.com

Post Reply