Identifier for Open Dental Installation

This forum is for programmers who have questions about the source code.

Identifier for Open Dental Installation

Postby tholmes » Tue Jun 05, 2018 7:43 pm

We're currently in the midst of syncing the data from multiple Open Dental installs into a single multi-tenant database.

1) What's the best way to uniquely identify an Open Dental Installation (e.g. instance of a database)?

2) Is there an identifier or a label (e.g. SiteID, Install_Id) that uniquely identifies an install?

Thanks in advance!
-Tyler
tholmes
 
Posts: 16
Joined: Fri Feb 16, 2018 11:39 am

Re: Identifier for Open Dental Installation

Postby cmcgehee » Wed Jun 06, 2018 7:32 am

tholmes wrote:1) What's the best way to uniquely identify an Open Dental Installation (e.g. instance of a database)?

The way to uniquely identify a database is by the registration key. You can use this query: SELECT * FROM preference WHERE PrefName = 'RegistrationKey';
2) Is there an identifier or a label (e.g. SiteID, Install_Id) that uniquely identifies an install?

Could you elaborate on what you mean by this question?
Chris McGehee
Open Dental Software
http://www.opendental.com
User avatar
cmcgehee
 
Posts: 496
Joined: Tue Aug 25, 2015 5:06 pm
Location: Salem, Oregon

Re: Identifier for Open Dental Installation

Postby tholmes » Thu Jun 07, 2018 6:38 pm

Hey Chris,

Thanks for the reply. The second question is looking for a more "human readable" version of the first answer.

Is there anything besides a RegistrationKey that describes an install?

Are there any Non-unique traits of an OD install that help identify a Site/Practice (e.g. Joe's Dental, Smile Dental Practice #182)? I'm ok with human entered/generated descriptive text that I can use to pair with less meaningful identifiers.
tholmes
 
Posts: 16
Joined: Fri Feb 16, 2018 11:39 am

Re: Identifier for Open Dental Installation

Postby adearmondsattler » Fri Jun 08, 2018 8:40 am

Nearly every preference in FormPractice should help to identify a database somewhat uniquely. If you are fine with human entered info then that would be the best choice.
“If debugging is the process of removing bugs, then programming must be the process of putting them in.”

Allen DeArmond-Sattler
Open Dental Software
http://www.opendental.com
User avatar
adearmondsattler
 
Posts: 163
Joined: Fri Aug 23, 2013 11:29 am


Return to Developers

Who is online

Users browsing this forum: No registered users and 7 guests