Open Dental Forum

SriramChellappan

I see APIs for Tasks, however I don't see any APIs for tasknotes.

SriramChellappan

Any help hosting the middle tier in the cloud?

SriramChellappan

Have you considered looking into DB replica logs to capture the changes in DB.

SriramChellappan

Thanks Dr. that explains the way auto code is designed. Can the software recognize the pontic and post no BU on a missing tooth? So If I highlight a series of teeth and click for BU / crown / filling the software recognize the missing teeth and post only the BU / Crown / filling codes on existing te...

SriramChellappan

My objective is highlight a series of adjacent teeth and click a procedure button and see the following codes posted. 1. D6245 - for Pontic 2. D6740 - for Retainer 3. D2950 - for Buildup This objective appears to be a very common one. However with the current restrictions in auto codes I can have on...

SriramChellappan

Can you please tell me how to setup auto code for the following

1. D6245 - for Pontic
2. D6740 - for Retainer
3. D2950 - for Buildup

SriramChellappan

I am trying to setup a procedure button for Bridge. Example I am treatment planning on 10, 11 & 12, tooth #11 is missing. This procedure button will post pontic codes for tooth #11 and retainer codes for tooth #10 and #12. for the retainers tooth there will be two codes one for Crown and another one...

SriramChellappan

I read through this instructions https://opendental.com/manual/hostmultipledatabases.html This gives more clarity on how a multi tenancy in one webserver can be achieved. Wouldn't it be easier to maintain if there is one middle tier points to different databases based on the connection established b...

SriramChellappan

SFTP server is hosted outside of the office. I will check out the speed using SFTP client and verify the speed.

SriramChellappan

I have gone through the link multiple times. In the scenario of hosting 6 databases in the same MySQL server, how would the Middle tier be configured? Should I run 6 different middle tier with each configured to one database? Or the OD client can provide the Middle Tier with Tenant ID and middle tie...

SriramChellappan

I see your point, having one database for each tenant would make sense. However in this scenario would I have one middle tier for each tenant? Can the OD client communicate the tenant id for the middle tier to point to the database based on tenant ID?

SriramChellappan

A framework layer between Middle tier and database with a filter for clinic based on the user login, would this work?

SriramChellappan

Have you tried OpenVPN?

SriramChellappan

We tried setting up SFTP for trial. The performance test came out ok, however it takes 4-5 sec for each documents and these documents are of size less than 100k

SriramChellappan

Can we use the Multiple clinics as multi tenant. I see almost all tables have the clinic identifier. Does this mean the application also safeguards the visibility of one clinic information from another clinic?

SriramChellappan

Currently I have SFTP server in gigabit network and office at 200/25.

Each click on an image in image module takes about 4-6 secs for less than 100kb images. Wondering if there is any fine tuning that can help the response time.

SriramChellappan

Has the Key Based Authentication with SFTP server been implemented?

SriramChellappan

I am not looking to send claims. For example In OpenDental you can "Go to Account" from other windows. However I wish there is a option for "Go to Claim" ( in ERA) which will not only select the patient, go to account module and also highlight the claim. Similar to above functionality, I should be a...

SriramChellappan

Would you be able to turn back on the feature that effects the currently running OD? Example if the third party applications sends a request to the OD to select a particular patient, open the account module, scroll to a particular transaction...

SriramChellappan

Can you please add user ID to program link command line arguments.

SriramChellappan

The shared ID (or the key) can validate the request is coming from authenticated (open dental client) source, then the user ID can identify the individual logged into the OD.

SriramChellappan

I believe program links such as payconnect (merchant services) uses some kind of key to authenticate (coming from OD) and identify the client (if not user). If we can use that vehicle to add user identity, the bridges will have finer processing capability.

SriramChellappan

How about sending the user logged in ID, since the ID is unique the bridged application has access to OD database to use the passed ID for identification. No password involved and it's not necessary either. This will help the bridged application use OD client as the primary application for logging in.

SriramChellappan

Are you using Middle tier? I am assuming with Middle tier the workstation upgrade shouldn't be that much.

SriramChellappan

Looks like this uses windows domain services. Is there a way bridge or plugin can pass on the Identity to the 3rd party application without having to use windows domain services.

SriramChellappan

We are developing an application that will run on workstations. I am wondering if there is a way to have both OD client and application can use single sign on.

SriramChellappan

I see we can pass the currently selected patient information to the third party software through bridge. Can we send information such as currently selected claim information?

SriramChellappan

"A long time ago, we got that feature working by using command line arguments." Not sure what does it mean by command line arguments? The DLL I am thinking of like a bridge to another application. Currently looks like DLL can open third party application passing in the currently selected patient. Wo...

SriramChellappan

Can I use DLL to change the currently selected patient?
Can I use DLL to take the user to another module? example to Account Module and scroll up or down to a specific claim?

SriramChellappan

I have read either in the blogs or manual cautions about replication. Certain queries or reports are recommended NOT to run in multiple of computers at the same time while replication is turned on. Is there a topic where there is a consolidated list of things to be caution about while replication is...

SriramChellappan

Change Data Stream (CDC) appears to be the buzz word in replica or propagation of changes to secondary database. Currently exploring how to implement it in OD MySQL server. Any advises based on your experience implementing such functionality in MySQL server. I believe this CDC solution relies mainly...

SriramChellappan

The allowedOverRide in ClaimProc has the following def The allowed fee (not the override) is a complex calculation which is performed on the fly in Procedure.ComputeEstimates/ClaimProc.ComputeBaseEst. It is the amount that the percentage is based on. If this carrier has a lower UCR than the office, ...

SriramChellappan

No rows are deleted in patients table, is this true for all other tables as well? In that case I don't need to maintain a separate set of table to identify a deleted row in any table.

SriramChellappan

I am thinking of maintaining tables corresponding to each table (that we are interested in) in OD with just the Primary ID as their only column. This table will reside in the MySQL server as OD in a separate database. every few minutes will check for updated rows, inserted rows using the lastupdatet...

SriramChellappan

I am thinking along the lines of the local server can provide a list of services that are available only for the registered cloud servers. The services do only one way data push. Example if a cloud server registers to receive any changes to patient, then the data will be pushed whenever there is a c...

SriramChellappan

I believe this was added in the recent release. When entering EOB we are able to enter the Allowed amount specified in the EOB. Wondering which table and column this data is stored. I would like to run a query that shows the fee schedule in the database and the allowed amount from the EOB. this will...

SriramChellappan

I understand the security risk of running API services in dental office servers. However is there a way cloud servers can register with the dental office servers, so that the communication can be initiated from the dental office servers. The request could be waiting on the cloud server for the local...

SriramChellappan

Yes, that's what I was thinking of. However few challenges 1. I can lookup using the Primary key (Patnum for patients), as they are incremented when rows are added, to identify if any new rows were added since last sync. 2. I can use UpdateDateTime Stamp of the table to see what rows were modified s...

SriramChellappan

I am looking for read only from OD database to keep the cloud tables updated.

SriramChellappan

I am looking for ways to transfer data from local server to cloud realtime. I am interested in only selected few tables. I need to send created, updated and deleted records to cloud for the cloud to update the corresponding tables. This is not for backups however to build Apps on top of the transfer...

SriramChellappan

I don't see multiple OD services running in our server.

SriramChellappan

How big of an issue is this for us to upgrade now.

SriramChellappan

The TWAIN driver needs to be installed only in database / web server? All workstations can use the driver installed in the server and will not look for locally installed driver?

Search found 43 matches