Search found 42 matches

by SriramChellappan
Sat Apr 01, 2023 5:53 pm
Forum: Advanced Topics
Topic: Open Dental hosted in cloud - middle tier or VPN
Replies: 2
Views: 3530

Re: Open Dental hosted in cloud - middle tier or VPN

Any help hosting the middle tier in the cloud?
by SriramChellappan
Thu Jun 16, 2022 9:33 am
Forum: API
Topic: Events
Replies: 4
Views: 3266

Re: Events

Have you considered looking into DB replica logs to capture the changes in DB.
by SriramChellappan
Sat Nov 20, 2021 10:45 am
Forum: Main Forum
Topic: Procedure Button in Chart Module for 3 Unit Bridge
Replies: 8
Views: 6331

Re: Procedure Button in Chart Module for 3 Unit Bridge

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...
by SriramChellappan
Sat Nov 20, 2021 5:42 am
Forum: Main Forum
Topic: Procedure Button in Chart Module for 3 Unit Bridge
Replies: 8
Views: 6331

Re: Procedure Button in Chart Module for 3 Unit Bridge

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...
by SriramChellappan
Fri Nov 19, 2021 2:55 am
Forum: Main Forum
Topic: Procedure Button in Chart Module for 3 Unit Bridge
Replies: 8
Views: 6331

Re: Procedure Button in Chart Module for 3 Unit Bridge

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
by SriramChellappan
Thu Nov 18, 2021 1:48 pm
Forum: Main Forum
Topic: Procedure Button in Chart Module for 3 Unit Bridge
Replies: 8
Views: 6331

Procedure Button in Chart Module for 3 Unit Bridge

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...
by SriramChellappan
Sat Oct 02, 2021 7:11 am
Forum: Developers
Topic: Multiple clinics as MultiTenant
Replies: 8
Views: 8674

Re: Multiple clinics as MultiTenant

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...
by SriramChellappan
Sat Oct 02, 2021 3:06 am
Forum: Developers
Topic: Improving SFTP server transaction speed
Replies: 3
Views: 6038

Re: Improving SFTP server transaction speed

SFTP server is hosted outside of the office. I will check out the speed using SFTP client and verify the speed.
by SriramChellappan
Sat Oct 02, 2021 3:05 am
Forum: Developers
Topic: Multiple clinics as MultiTenant
Replies: 8
Views: 8674

Re: Multiple clinics as MultiTenant

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...
by SriramChellappan
Fri Oct 01, 2021 8:12 am
Forum: Developers
Topic: Multiple clinics as MultiTenant
Replies: 8
Views: 8674

Re: Multiple clinics as MultiTenant

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?
by SriramChellappan
Sun Sep 26, 2021 3:42 pm
Forum: Developers
Topic: Multiple clinics as MultiTenant
Replies: 8
Views: 8674

Re: Multiple clinics as MultiTenant

A framework layer between Middle tier and database with a filter for clinic based on the user login, would this work?
by SriramChellappan
Wed Sep 22, 2021 3:18 pm
Forum: Advanced Topics
Topic: Hamachi VPN
Replies: 2
Views: 14732

Re: Hamachi VPN

Have you tried OpenVPN?
by SriramChellappan
Wed Sep 22, 2021 1:22 pm
Forum: Advanced Topics
Topic: SFTP for images
Replies: 5
Views: 14398

Re: SFTP for images

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
by SriramChellappan
Wed Sep 22, 2021 1:17 pm
Forum: Developers
Topic: Multiple clinics as MultiTenant
Replies: 8
Views: 8674

Multiple clinics as MultiTenant

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?
by SriramChellappan
Sun Sep 19, 2021 5:50 am
Forum: Developers
Topic: Improving SFTP server transaction speed
Replies: 3
Views: 6038

Improving SFTP server transaction speed

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.
by SriramChellappan
Sun Sep 19, 2021 5:09 am
Forum: Advanced Topics
Topic: SFTP for images
Replies: 5
Views: 14398

Re: SFTP for images

Has the Key Based Authentication with SFTP server been implemented?
by SriramChellappan
Fri Sep 17, 2021 3:01 pm
Forum: Developers
Topic: DLL interaction with OpenDental to change patient selected
Replies: 8
Views: 10624

Re: DLL interaction with OpenDental to change patient selected

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...
by SriramChellappan
Thu Sep 16, 2021 2:11 pm
Forum: Developers
Topic: DLL interaction with OpenDental to change patient selected
Replies: 8
Views: 10624

Re: DLL interaction with OpenDental to change patient selected

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...
by SriramChellappan
Thu Sep 16, 2021 1:07 pm
Forum: Developers
Topic: Single Sign On
Replies: 10
Views: 8127

Re: Single Sign On

Can you please add user ID to program link command line arguments.
by SriramChellappan
Thu Sep 16, 2021 6:18 am
Forum: Developers
Topic: Single Sign On
Replies: 10
Views: 8127

Re: Single Sign On

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.
by SriramChellappan
Fri Sep 10, 2021 2:33 am
Forum: Developers
Topic: Single Sign On
Replies: 10
Views: 8127

Re: Single Sign On

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.
by SriramChellappan
Tue Sep 07, 2021 3:36 am
Forum: Developers
Topic: Single Sign On
Replies: 10
Views: 8127

Re: Single Sign On

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.
by SriramChellappan
Fri Sep 03, 2021 2:59 pm
Forum: Main Forum
Topic: MYSQL to MariaDB conversion
Replies: 3
Views: 5087

Re: MYSQL to MariaDB conversion

Are you using Middle tier? I am assuming with Middle tier the workstation upgrade shouldn't be that much.
by SriramChellappan
Thu Sep 02, 2021 2:24 am
Forum: Developers
Topic: Single Sign On
Replies: 10
Views: 8127

Re: Single Sign On

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.
by SriramChellappan
Sat Aug 28, 2021 4:51 pm
Forum: Developers
Topic: Single Sign On
Replies: 10
Views: 8127

Single Sign On

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.
by SriramChellappan
Fri Jun 11, 2021 3:16 pm
Forum: Developers
Topic: DLL interaction with OpenDental to change patient selected
Replies: 8
Views: 10624

Re: DLL interaction with OpenDental to change patient selected

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?
by SriramChellappan
Sat Jun 05, 2021 11:12 am
Forum: Developers
Topic: DLL interaction with OpenDental to change patient selected
Replies: 8
Views: 10624

Re: DLL interaction with OpenDental to change patient selected

"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...
by SriramChellappan
Thu Jun 03, 2021 12:25 pm
Forum: Developers
Topic: DLL interaction with OpenDental to change patient selected
Replies: 8
Views: 10624

DLL interaction with OpenDental to change patient selected

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?
by SriramChellappan
Sat May 15, 2021 5:15 am
Forum: Developers
Topic: Realtime Transfer of Updated and Deleted data to Cloud
Replies: 13
Views: 15926

Re: Realtime Transfer of Updated and Deleted data to Cloud

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...
by SriramChellappan
Thu May 13, 2021 8:07 am
Forum: Developers
Topic: Realtime Transfer of Updated and Deleted data to Cloud
Replies: 13
Views: 15926

Re: Realtime Transfer of Updated and Deleted data to Cloud

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...
by SriramChellappan
Thu Apr 22, 2021 6:56 am
Forum: Developers
Topic: Insurance Allowed amount Entered from EOB
Replies: 3
Views: 7558

Re: Insurance Allowed amount Entered from EOB

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, ...
by SriramChellappan
Thu Apr 22, 2021 6:36 am
Forum: Developers
Topic: Realtime Transfer of Updated and Deleted data to Cloud
Replies: 13
Views: 15926

Re: Realtime Transfer of Updated and Deleted data to Cloud

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.
by SriramChellappan
Wed Apr 21, 2021 11:43 am
Forum: Developers
Topic: Realtime Transfer of Updated and Deleted data to Cloud
Replies: 13
Views: 15926

Re: Realtime Transfer of Updated and Deleted data to Cloud

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...
by SriramChellappan
Wed Apr 21, 2021 11:37 am
Forum: Developers
Topic: Call back API
Replies: 3
Views: 8056

Re: Call back API

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...
by SriramChellappan
Wed Apr 21, 2021 9:28 am
Forum: Developers
Topic: Insurance Allowed amount Entered from EOB
Replies: 3
Views: 7558

Insurance Allowed amount Entered from EOB

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...
by SriramChellappan
Tue Apr 13, 2021 12:02 pm
Forum: Developers
Topic: Call back API
Replies: 3
Views: 8056

Call back API

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...
by SriramChellappan
Tue Apr 13, 2021 11:52 am
Forum: Developers
Topic: Realtime Transfer of Updated and Deleted data to Cloud
Replies: 13
Views: 15926

Re: Realtime Transfer of Updated and Deleted data to Cloud

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...
by SriramChellappan
Tue Apr 13, 2021 8:00 am
Forum: Developers
Topic: Realtime Transfer of Updated and Deleted data to Cloud
Replies: 13
Views: 15926

Re: Realtime Transfer of Updated and Deleted data to Cloud

I am looking for read only from OD database to keep the cloud tables updated.
by SriramChellappan
Mon Apr 12, 2021 8:23 am
Forum: Developers
Topic: Realtime Transfer of Updated and Deleted data to Cloud
Replies: 13
Views: 15926

Realtime Transfer of Updated and Deleted data to Cloud

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...
by SriramChellappan
Thu Mar 18, 2021 12:34 pm
Forum: Main Forum
Topic: Multiple Instances of OpenDental running on server
Replies: 8
Views: 9175

Re: Multiple Instances of OpenDental running on server

I don't see multiple OD services running in our server.
by SriramChellappan
Thu Mar 18, 2021 12:32 pm
Forum: Main Forum
Topic: Multiple Instances of OpenDental running on server
Replies: 8
Views: 9175

Re: Multiple Instances of OpenDental running on server

How big of an issue is this for us to upgrade now.
by SriramChellappan
Sun Mar 14, 2021 1:12 pm
Forum: Main Forum
Topic: Radiographs and Intraoral Cameras
Replies: 56
Views: 110455

Re: Radiographs and Intraoral Cameras

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?