Identifier for Open Dental Installation

This forum is for programmers who have questions about the source code.
Post Reply
tholmes
Posts: 16
Joined: Fri Feb 16, 2018 10:39 am

Identifier for Open Dental Installation

Post by 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

User avatar
cmcgehee
Posts: 711
Joined: Tue Aug 25, 2015 5:06 pm
Location: Salem, Oregon

Re: Identifier for Open Dental Installation

Post by 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

tholmes
Posts: 16
Joined: Fri Feb 16, 2018 10:39 am

Re: Identifier for Open Dental Installation

Post by 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.

allends
Posts: 235
Joined: Fri Aug 23, 2013 11:29 am

Re: Identifier for Open Dental Installation

Post by allends » 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.
Allen
Open Dental Software
http://www.opendental.com

Post Reply