Search found 177 matches

by ForrestGumpDDS
Tue Jun 27, 2023 11:43 pm
Forum: Main Forum
Topic: Restoring from backup after converting to MariaDB
Replies: 1
Views: 2399

Restoring from backup after converting to MariaDB

Hello, I used to run OD on the MySQL and restoration/testing of backups was done by using MySQL Workbench. Now, when I converted to MariaDB, I am not able to use Workbench any longer. The reason I use my own backups is because I use an automated script that dumps the databases daily and organizes/ro...
by ForrestGumpDDS
Sun Jul 11, 2021 8:46 pm
Forum: Main Forum
Topic: Database splitting by clinics issues.
Replies: 1
Views: 3806

Database splitting by clinics issues.

Good evening, I'm in the middle of splitting the database by "clinics" entries, evaluating the test splits. Suggestions are appreciated for the account balances issues. The main issue I'm having right now is the account balances are randomly off for many accounts. For example. Let's name the databas...
by ForrestGumpDDS
Wed Mar 24, 2021 9:13 am
Forum: Main Forum
Topic: Report for ADA codes per clinic per provider
Replies: 1
Views: 4460

Report for ADA codes per clinic per provider

Hello, I was wondering how to adapt the current report to separate income generated by certain codes (or code groups) per clinic? We use a "Clinic" feature and want to see the report on one clinic separate from the other one. The codes we are looking for on the report are: a. How many D1110, D1120 b...
by ForrestGumpDDS
Mon Nov 30, 2020 7:52 am
Forum: Main Forum
Topic: EClipboard is not saving face photos
Replies: 1
Views: 2432

EClipboard is not saving face photos

Good morning, I think the app is not writing to the file share where the OpenDentImages reside. I have a mysql service and sambashare for the files, all located on a network, the workstations are provided with the path. Works fine. Using the feature "climics". Signed up for clipboard for one of the ...
by ForrestGumpDDS
Tue Aug 18, 2020 9:14 am
Forum: Main Forum
Topic: Production report for provider w. minimal daily pay
Replies: 1
Views: 2891

Production report for provider w. minimal daily pay

Hello, Is there any ready to use query that would allow add a minimal daily guaranteed amount to %-age of collection ? The closest solution I came up with is this. Dentist gets paid a % of a djusted production . Adjustments are for write offs and discounts during pay period. If the daily value is le...
by ForrestGumpDDS
Mon Jun 15, 2020 3:23 pm
Forum: Main Forum
Topic: Critical error "String was not recognized as a valid DateTime."
Replies: 7
Views: 32081

Re: Critical error "String was not recognized as a valid DateTime."

I think we are going to need to collect a copy of your database to locate the bug. Would you mind calling support again? I made a change on our side to remove your eConnector from the blacklist. Try restarting it again. It helped for 5 minutes and then I'm blacklisted again. It looks like my client...
by ForrestGumpDDS
Fri Jun 12, 2020 2:06 pm
Forum: Main Forum
Topic: Critical error "String was not recognized as a valid DateTime."
Replies: 7
Views: 32081

Re: Critical error "String was not recognized as a valid DateTime."

Thank you and the technician for help. The e-Connector works now. Any estimates when the bug can be located and fixed, so I can upgrade to 20.1? Edit. 20 mins later. e-Connector crushed and is not staying on. It looks I might be getting blacklisted on your end again. eConnector shutting down due to ...
by ForrestGumpDDS
Tue Jun 09, 2020 12:27 am
Forum: Main Forum
Topic: Critical error "String was not recognized as a valid DateTime."
Replies: 7
Views: 32081

Re: Critical error "String was not recognized as a valid DateTime."

On a top of that, eConnector service quit working. The service stops immediately after the start. I reinstalled it manually per instructions and getting this: 06/09/20 03:22:21:534 ODSocketRemoteImmortal is stopping and will not restart. 06/09/20 03:23:34:105 failed - Value cannot be null. Parameter...
by ForrestGumpDDS
Mon Jun 08, 2020 8:31 pm
Forum: Main Forum
Topic: Critical error "String was not recognized as a valid DateTime."
Replies: 7
Views: 32081

Re: Critical error "String was not recognized as a valid DateTime."

Thank you It took me awhile as I realized that some database maintenance routines required global privileges and had to run them as root user. I stumble upon one "button" that threw another exception about missing table: Error Encountered - 06/08/2020 11:15:35 PM Unhandled exception: Table 'opendent...
by ForrestGumpDDS
Sat Jun 06, 2020 3:42 pm
Forum: Main Forum
Topic: Critical error "String was not recognized as a valid DateTime."
Replies: 7
Views: 32081

Critical error "String was not recognized as a valid DateTime."

Updated from 19.3.66 (i believe) to the latest stable, 20.1.something. Upon login, I see this: Unhandled exception: String was not recognized as a valid DateTime. System.FormatException at System.DateTimeParse.Parse(String s, DateTimeFormatInfo dtfi, DateTimeStyles styles) at System.DateTime.Parse(S...
by ForrestGumpDDS
Wed Feb 19, 2020 12:15 pm
Forum: Main Forum
Topic: Adding "Consent" type of sheet as online form
Replies: 1
Views: 4845

Adding "Consent" type of sheet as online form

Hello, Trying to add a Consent to release records as online form. Getting an error "The form does not have required fields "FName". "LName", "Birthday"". I was thinking to add them somewhere on the form to satisfy the requirements, but they don't come up in the list of available fields. I do see tho...
by ForrestGumpDDS
Fri Nov 08, 2019 6:19 am
Forum: Main Forum
Topic: Patient Self Check-in
Replies: 5
Views: 9437

Re: Patient Self Check-in

New app by Open Dental will be available for version 19.2 in the next couple of weeks. Patients can self check in, fill out forms and take pictures of self for your system, auto uploads. https://www.opendental.com/manual192/eclipboard.html broken link. 404 - File or directory not found. The resourc...
by ForrestGumpDDS
Thu Nov 07, 2019 2:50 pm
Forum: Main Forum
Topic: EINs - one dentist in 2 locations.
Replies: 0
Views: 17151

EINs - one dentist in 2 locations.

Hello, I'm trying to setup office billing credentials for a second clinic and see that EIN is rather bound to the treating dentist rather than a clinic. This places a wrong EIN on claims in a second clinic that has a different EIN than the one where the provider used to work before starting working ...
by ForrestGumpDDS
Tue Nov 05, 2019 7:13 am
Forum: Main Forum
Topic: Typical security permissions to associate dentist
Replies: 0
Views: 16918

Typical security permissions to associate dentist

Hello, A question to dentist owners. What are the typical security permissions that you give to the associate dentist for running reports? I would like to fine tune the permissions so my part-time associate can see her production, collection and adjustments for herself only. So far I found Security-...
by ForrestGumpDDS
Mon Oct 07, 2019 2:26 pm
Forum: Main Forum
Topic: eRx provider identification lost after switching on CLINICS
Replies: 1
Views: 3375

Re: eRx provider identification lost after switching on CLIN

Update. It looks like the solution is clicking on your name in the upper left corner, then selecting a clinic and then going to the admin tab. There's a link at the very bottom of the admin activity links, saying "registration", so you check registration status and it was showing some short non-info...
by ForrestGumpDDS
Mon Oct 07, 2019 1:34 pm
Forum: Main Forum
Topic: eRx provider identification lost after switching on CLINICS
Replies: 1
Views: 3375

eRx provider identification lost after switching on CLINICS

Switched on "Clinics" and now not being able to electronically sign eRx as I used to. Possibly related to the fact I moved my patients from "headquarters" to "clinic1". Manually re-assigning the pt. to "unassigned" clinic option does not help. eRx interface allows me to select patient, medications a...
by ForrestGumpDDS
Mon Oct 07, 2019 1:22 pm
Forum: Main Forum
Topic: Adding another location.
Replies: 6
Views: 7954

Re: Adding another location.

Thanks, Jordan.
by ForrestGumpDDS
Sun Sep 29, 2019 4:36 pm
Forum: Main Forum
Topic: Problems with Dexis bridge.
Replies: 3
Views: 7192

Problems with Dexis bridge.

Hello. I am having issues accessing Dexis through OD on recently purchased laptop. The Dexis is installed properly, I can access all the patients (through Dexis management tool from this laptop). All my existing workstations are functioning as intended and I am able to call Dexis from Opendental on ...
by ForrestGumpDDS
Sun Sep 29, 2019 3:59 pm
Forum: Main Forum
Topic: Adding another location.
Replies: 6
Views: 7954

Re: Adding another location.

Thank you Jordan. I'm going to try this way. I started the "clinics" way and liked it because of these reasons: My frontdesk person sitting in one office can get the patients scheduled to another clinic by switching the "clinic" in one click of the mouse. I can use claims processing software on pati...
by ForrestGumpDDS
Sat Sep 28, 2019 9:42 pm
Forum: Main Forum
Topic: Adding another location.
Replies: 6
Views: 7954

Re: Adding another location.

Thank you. How would "Clinic" feature be different in terms of restrictions as compared to 2 separate databases managed by CEMT tool? Would it be possible in the future to run a query and get an exportable list of patients that belong to one of the clinics with a purpose of migrating them into a sta...
by ForrestGumpDDS
Thu Sep 26, 2019 3:57 pm
Forum: Main Forum
Topic: Adding another location.
Replies: 6
Views: 7954

Adding another location.

When another office is acquired, what would be the correct protocol to setup the new location? The locations will not share patients on the day to day basis, however it would be nice if the patient's information could be alienated from one practice to another one per patient's request with minimum e...
by ForrestGumpDDS
Tue Sep 17, 2019 8:32 am
Forum: Main Forum
Topic: eRx on eServices
Replies: 2
Views: 4547

Re: eRx on eServices

I dug a bit deeper from my desktop and it looks like you guys transitioned to DoseSpot feature which is not yet setup in my system yet, hence the error.
by ForrestGumpDDS
Mon Sep 16, 2019 4:09 pm
Forum: Main Forum
Topic: eRx on eServices
Replies: 2
Views: 4547

eRx on eServices

Just noticed eRx tab, I'm on latest beta. Wow, that's the feature I was missing for years! Big thanks to you guys! Now, the not so good part. When I log in to mobile web as an erx authorized user, then click on erx button, select the patient, I am getting this error message: "Missing DoseSpot User I...
by ForrestGumpDDS
Tue Aug 27, 2019 6:52 am
Forum: Main Forum
Topic: Integration of Online Appointmentswith the website.
Replies: 2
Views: 4297

Re: Integration of Online Appointmentswith the website.

When you look at the following demo page, which may be something similar to what you are going to be using, the web schedule portion is displayed as an Iframe(separate page within your page). http://patientviewer.com/demo/wsnp_embedded/ You'll certainly be able to track individuals arriving at your...
by ForrestGumpDDS
Fri Aug 23, 2019 6:47 pm
Forum: Main Forum
Topic: Integration of Online Appointmentswith the website.
Replies: 2
Views: 4297

Integration of Online Appointmentswith the website.

I've been contemplating adding online appointments functionality to my website for awhile. Now, as I'm planning to overhaul my website soon, I want to make sure I don't miss anything important when describing the project for the web company. So, I looked here: https://opendental.com/site/websched.ht...
by ForrestGumpDDS
Tue Aug 13, 2019 4:26 pm
Forum: Main Forum
Topic: Lighthouse 360 vs Open Dental Texting
Replies: 10
Views: 18141

Re: Lighthouse 360 vs Open Dental Texting

I'm looking for the same now too. Would like to hear from the people who integrated texting and also other mobile services. The time has come for my website to be re-made, so I wanted to make sure I write the project for the web designer clearly from beginning. I was wondering if anyone implemented ...
by ForrestGumpDDS
Thu Aug 08, 2019 11:00 am
Forum: Main Forum
Topic: Provider field on the statements.
Replies: 2
Views: 4666

Re: Provider field on the statements.

Thanks, will do.
I was hoping it was going to be something easier, like a custom query I can do.
by ForrestGumpDDS
Tue Aug 06, 2019 4:08 pm
Forum: Main Forum
Topic: Provider field on the statements.
Replies: 2
Views: 4666

Provider field on the statements.

Hello,
One of my patients asked that the statements should reflect provider's name.
How do I add the column (preferably it should reflect provider's real name or a short version of one, not the opendental login like DOC1 or HYG1)?
Thank you
by ForrestGumpDDS
Tue Jun 11, 2019 8:10 am
Forum: Main Forum
Topic: Insurance reversed payment 6 months after the procedures
Replies: 2
Views: 4805

Insurance reversed payment 6 months after the procedures

Good morning. Sorry if it's been asked before, can't seem to find the answer right away. Pt. had a services done Dec 2018. A crown and filling w. xray, 2 claims. Insurance paid 1 months later. We mark the claims received, created 2 payments - Billed amount, minus w/o, applied percentage, indicated p...
by ForrestGumpDDS
Thu Apr 04, 2019 10:56 am
Forum: Main Forum
Topic: Add recall type to default list of recalls for new patients.
Replies: 3
Views: 4976

Add recall type to default list of recalls for new patients.

Trying to do it in a hurry and cannot seem to find the way.
I noticed that all my patients get assigned 2 types of recall - prophy and 4BW while Pano recall is missing. I can add it manually, but want this to be added by default to any new pt.
How do I do this?
Thank you
by ForrestGumpDDS
Tue Jan 29, 2019 5:13 pm
Forum: Main Forum
Topic: Emails not working.
Replies: 4
Views: 6658

Re: Emails not working.

Well... Here's an idea of "more descriptive" output. 108.177.XYZ.KJH SURICATA Applayer Detect protocol only one direction - 01/29/2019-20:10:24 This is what the suricata seems to be blocking. Not sure if OD has to do anything with it. Update. After reading this , I disabled this rule in Suricata, an...
by ForrestGumpDDS
Tue Jan 29, 2019 5:01 pm
Forum: Main Forum
Topic: Emails not working.
Replies: 4
Views: 6658

Re: Emails not working.

Thanks Jason, More descriptive error would help, but that what all I was getting, sorry... My firewall has not changed, however I accidentally just figured out it was my Suricata behaving that way, probably after recent update. Will be digging deeper to find out which rules are blocking gmail traffic.
by ForrestGumpDDS
Tue Jan 29, 2019 4:21 pm
Forum: Main Forum
Topic: Emails not working.
Replies: 4
Views: 6658

Emails not working.

18.3.44 When trying to send an email - "Failed to send email. Error message from the email client was: Failure sending mail." Upgraded to the latest stable 18.3.47 No luck. Trying to call - no one calls back. Sorry for giving an impression of being impatient, but we have to send a bunch of emails to...
by ForrestGumpDDS
Tue Jan 29, 2019 4:15 pm
Forum: Main Forum
Topic: Welcome Back
Replies: 9
Views: 12849

Re: Welcome Back

I was about to say "it's not Dentrix I'm seeing, right"?
Welcome back, Arna!
by ForrestGumpDDS
Thu Nov 29, 2018 11:55 am
Forum: Main Forum
Topic: Patient portal login issues.
Replies: 5
Views: 6164

Re: Patient portal login issues.

Thanks, looks like I'm going to need to wait till 18.4
by ForrestGumpDDS
Wed Nov 28, 2018 10:06 am
Forum: Main Forum
Topic: Patient portal login issues.
Replies: 5
Views: 6164

Re: Patient portal login issues.

I'm on 18.3.26 (beta)
18.3.27 was released just yesterday (same day you posted your response, adearmondsattler). So there's a good chance you are talking about updating to the version I'm on now.
In what version was it suppose to be fixed?
by ForrestGumpDDS
Tue Nov 27, 2018 4:09 pm
Forum: Main Forum
Topic: Patient portal login issues.
Replies: 5
Views: 6164

Patient portal login issues.

I recently enable sending an invites to the patient portal. Today I had one patient complaining that she received an email, but was not able to log in. I was able to reproduce it with making an appointment for a test patient with my own email address. The email came with the username and temp. passw...
by ForrestGumpDDS
Tue Nov 27, 2018 4:00 pm
Forum: Main Forum
Topic: Raw email tool
Replies: 5
Views: 5314

Re: Raw email tool

Just the time that it takes the OD to update, well, maybe megabytes too, each backup is close to 0.5Gb (archived version).
by ForrestGumpDDS
Tue Nov 13, 2018 10:57 am
Forum: Main Forum
Topic: Raw email tool
Replies: 5
Views: 5314

Re: Raw email tool

My guess is that you have a lot of email messages that do not have a matching email address. If that's the case, this query would return a high number: SELECT COUNT(*) FROM emailmessage m LEFT JOIN emailaddress a ON a.EmailUsername=m.RecipientAddress WHERE a.EmailAddressNum IS NULL The number retur...
by ForrestGumpDDS
Fri Nov 09, 2018 6:47 pm
Forum: Main Forum
Topic: Raw email tool
Replies: 5
Views: 5314

Raw email tool

I was running this tool today in a hope to deflate the emailmessage table.
Is this output normal?
Image
by ForrestGumpDDS
Sat Oct 20, 2018 7:39 am
Forum: Main Forum
Topic: Prescription Monitoring Program.
Replies: 0
Views: 10978

Prescription Monitoring Program.

Hi, a quick question. Is there any bridge for prescription monitoring app exist in OD so I can view patient's currently taken medication or currently taken controlled substances without directly logging into PMP website each time? What I have now, is enrollment in eRx, which allows me being taken to...
by ForrestGumpDDS
Thu Oct 18, 2018 2:06 pm
Forum: Main Forum
Topic: Pay periods semi-monthly
Replies: 4
Views: 4976

Re: Pay periods semi-monthly

Thank you,
It says "approved". Anyway voted +20 points.
by ForrestGumpDDS
Thu Oct 18, 2018 11:25 am
Forum: Main Forum
Topic: Pay periods semi-monthly
Replies: 4
Views: 4976

Re: Pay periods semi-monthly

bump
by ForrestGumpDDS
Fri Oct 12, 2018 3:36 pm
Forum: Main Forum
Topic: Pay periods semi-monthly
Replies: 4
Views: 4976

Pay periods semi-monthly

Hello,
I was wondering if it is possible to create an option for semi-monthly pay periods as opposed to bi-weekly.
We report our payrol taxes semi-monthly and when I am setting up the pay periods, I have to go one by one and correct the dates to each of them.
by ForrestGumpDDS
Tue Sep 11, 2018 8:51 am
Forum: Main Forum
Topic: Changing lab slip due time.
Replies: 4
Views: 6063

Re: Changing lab slip due time.

yes, correct, I want to re-hard-code it to another time.
Do you think I can do it by changing the value of certain variable in mySQL?
by ForrestGumpDDS
Tue Sep 11, 2018 6:21 am
Forum: Main Forum
Topic: Changing lab slip due time.
Replies: 4
Views: 6063

Re: Changing lab slip due time.

Bump
ForrestGumpDDS wrote: I went into "sheets" and see that the time is defined by the "labcase.DateTimeDue" variable. If I am correct, how do I change its value?
Thanks.
by ForrestGumpDDS
Fri Sep 07, 2018 8:03 am
Forum: Main Forum
Topic: Changing lab slip due time.
Replies: 4
Views: 6063

Changing lab slip due time.

Hello, I'm trying to figure out the way to change all my lab slips to the 10AM time. No it shows 5PM by default. Unless the assistant edits the time manually, the cases show 5PM. This creates issues when we miss out and do not allow for extra day for the lab. The lab is on time, the case is on time,...
by ForrestGumpDDS
Wed Jul 25, 2018 9:48 am
Forum: Main Forum
Topic: Exception when Emails functionality on new beta
Replies: 2
Views: 3603

Re: Exception when Emails functionality on new beta

cmcgehee wrote:Congrats on jumping on to the beta version. We have fixed this error in 18.2.5: "Email, loading the inbox caused a UE."
Well... once you go beta, you never come back! Or so they say ))
It is fixed indeed! Working now on 18.2.6
Thank you
by ForrestGumpDDS
Wed Jul 25, 2018 6:50 am
Forum: Main Forum
Topic: Exception when Emails functionality on new beta
Replies: 2
Views: 3603

Exception when Emails functionality on new beta

I'm on new beta - 18.2.4 When go to Manage->emails, getting this: Error Encountered - 07/25/2018 9:49:29 AM Unhandled exception: Column 'IsHtml' does not belong to table . System.ArgumentException at System.Data.DataRow.GetDataColumn(String columnName) at System.Data.DataRow.get_Item(String columnNa...
by ForrestGumpDDS
Mon Jul 02, 2018 7:04 pm
Forum: Main Forum
Topic: Possibly a bug in reports.
Replies: 4
Views: 6028

Re: Possibly a bug in reports.

OK, I will.
It is not giving me any inconveniences, just noted what I think is a bug.
by ForrestGumpDDS
Thu Jun 28, 2018 9:37 am
Forum: Main Forum
Topic: Possibly a bug in reports.
Replies: 4
Views: 6028

Re: Possibly a bug in reports.

Yes, correct.
by ForrestGumpDDS
Tue Jun 26, 2018 7:25 pm
Forum: Main Forum
Topic: Possibly a bug in reports.
Replies: 4
Views: 6028

Possibly a bug in reports.

I noticed today that when I am comparing numbers between Daily report (insurance payment row) and Monthly report for the same date (also insurance income), the numbers don't match. Daily report seems to be short of money, bythe amount that I can only attribute to one $30 check. The only $30 check I ...
by ForrestGumpDDS
Fri Jun 15, 2018 6:31 am
Forum: Main Forum
Topic: Show production numbers on appointments
Replies: 2
Views: 3428

Re: Show production numbers on appointments

Excellent, thanks.
That's what I was looking for.
by ForrestGumpDDS
Thu Jun 14, 2018 3:15 pm
Forum: Main Forum
Topic: Show production numbers on appointments
Replies: 2
Views: 3428

Show production numbers on appointments

I apologize if it was discussed somewhere, Is there a way to show the estimated production on patient's appointment or/and somewhere in the appointment view for the patient or total? The idea is the FD would know how their action affects the daily production goal when the patient is getting schedule...
by ForrestGumpDDS
Wed Apr 11, 2018 10:34 am
Forum: Main Forum
Topic: e-Claims, which clearinghouse to choose?
Replies: 3
Views: 5649

Re: e-Claims, which clearinghouse to choose?

Thank you. Looking into their info right now. It's either .37c per claim, or $25/month, which translates into 11c per claim and gets 3c cheaper after first 225 claims in the tier where I see my practice. Question to the OD team - is there any way to see the number of claims sent each month in the re...
by ForrestGumpDDS
Wed Apr 11, 2018 10:22 am
Forum: Main Forum
Topic: Electronic Eligibility. How practical?
Replies: 2
Views: 5321

Electronic Eligibility. How practical?

Researching a new e-claims vendor and wondering about this feature. Some vendors offer e-eligibility. Currently, I have a staff member whose chief responsibility is to verify the insurance coverage and get breakdowns. I do not use e-eligibility currently. If I order this feature, what are my chances...
by ForrestGumpDDS
Wed Apr 11, 2018 8:14 am
Forum: Main Forum
Topic: e-Claims, which clearinghouse to choose?
Replies: 3
Views: 5649

e-Claims, which clearinghouse to choose?

Stumbled upon this while making my research on clearinghouse selection: Regarding Tesia, I would like to say that we have been informed that Renaissance will be phasing out Tesia. They will be transitioning Tesia's users to a custom Renaissance format that does not have data validation within Open D...
by ForrestGumpDDS
Tue Apr 10, 2018 4:00 pm
Forum: Main Forum
Topic: REMINDERS OF SOME FORMS
Replies: 7
Views: 12250

Re: REMINDERS OF SOME FORMS

We are currently enrolled with DemandForce. Even a mere thought of starting to change things gives me a throbbing pain in my behind. I still remember the patients calling and complaining about receiving several unwanted text messages on the days DemandForce introduced changes into their system, or t...
by ForrestGumpDDS
Sat Apr 07, 2018 6:46 am
Forum: Main Forum
Topic: REMINDERS OF SOME FORMS
Replies: 7
Views: 12250

Re: REMINDERS OF SOME FORMS

Yes, I've been thinking about this in exactly same way (well... maybe without capitalizing every single letter of my thoughts :twisted: ). Dentists are required to update medical hx almost every time the patient comes, definitely every 6 months. So, from my understanding, what OP is asking and what ...
by ForrestGumpDDS
Fri Apr 06, 2018 3:33 pm
Forum: Main Forum
Topic: Could not find path to A-Z folder upon version upgrade. Bug?
Replies: 4
Views: 7955

Re: Could not find path to A-Z folder upon version upgrade.

When you open Open Dental, do you typically run it as an administrator? Perhaps when Open Dental relaunches after upgrading, it does not have high enough permissions to read your A-Z folder. Sorry to be late with responses, I am subscribed to the replies, but somehow do not get notifications when t...
by ForrestGumpDDS
Fri Apr 06, 2018 3:28 pm
Forum: Main Forum
Topic: Login window out of focus. Bug?
Replies: 7
Views: 11717

Re: Login window out of focus. Bug?

cmcgehee wrote:Does this happen only when Open Dental is starting up, or does it also happen after clicking the "Log Off" menu item?
Only on a startup.
I notice there was the answer from Jason after that.
Thank you
by ForrestGumpDDS
Fri Mar 09, 2018 5:23 pm
Forum: Main Forum
Topic: Could not find path to A-Z folder upon version upgrade. Bug?
Replies: 4
Views: 7955

Could not find path to A-Z folder upon version upgrade. Bug?

I noticed this behavior quite a few versions ago. I'd say a year or longer. When I upgrade to the next version, as a part of the upgrade I have to re-launch the application. During this first launch (regardless what workstation I use), I get the "copying files" message and then I am able to see the ...
by ForrestGumpDDS
Fri Mar 09, 2018 5:15 pm
Forum: Main Forum
Topic: Login window out of focus. Bug?
Replies: 7
Views: 11717

Login window out of focus. Bug?

When I start OD, it brings the login window. In the past I believe I could just go ahead and type the password and it will go straight in. My login entry is at the top, so it was selected automatically upon start. All I needed was to add the password. Now, the password goes nowhere, unless I pick up...
by ForrestGumpDDS
Fri Feb 23, 2018 3:41 pm
Forum: Main Forum
Topic: Missing new CDT code D5612
Replies: 6
Views: 10646

Re: Missing new CDT code D5612

Indeed, it was under "Never used" which in its turn was hidden.
Pulled the code back to the daylight where it belongs :). Thank you!
I am currently on 17.3.38, it's a bit outdated, I know.
Thank you
by ForrestGumpDDS
Fri Feb 23, 2018 7:34 am
Forum: Main Forum
Topic: Missing new CDT code D5612
Replies: 6
Views: 10646

Missing new CDT code D5612

It looks like ADA updated some prostho codes, removing some and adding some new, in some cases 2 for one removed (to differentiate upper and lower arch codes). I was trying to add a D5610 just to find out that it was replaced with D5611 (mandib.) and D5612 (maxillary). The later one is missing in OD...
by ForrestGumpDDS
Fri Feb 16, 2018 3:13 pm
Forum: Main Forum
Topic: Moving lab slip to another patient.
Replies: 2
Views: 4133

Re: Moving lab slip to another patient.

Yes, and this is in fact what I end up doing. I just looked how the consent forms are handled and thought it would be a good idea. We use lab case feature very often, every day. There are few things that could be different. One of the biggest features that I am missing is inability to continue the c...
by ForrestGumpDDS
Thu Feb 15, 2018 12:30 pm
Forum: Main Forum
Topic: Moving lab slip to another patient.
Replies: 2
Views: 4133

Moving lab slip to another patient.

Hello, Is it technically possible to move/reassign the lab case and the lab slip to another patient? I just noticed, that one of my lab cases was created from the wrong patient's chart. Everything other than that is fine with the case. Is it possible to reassign it to a correct patient w/o deletion ...
by ForrestGumpDDS
Tue Dec 12, 2017 5:14 pm
Forum: Main Forum
Topic: Fee schedule based PPO.
Replies: 2
Views: 3827

Re: Fee schedule based PPO.

Gerat, will do tomorrow.
by ForrestGumpDDS
Tue Dec 12, 2017 5:14 pm
Forum: Main Forum
Topic: Potential bug? Ver. 17.3.31
Replies: 2
Views: 4279

Potential bug? Ver. 17.3.31

I noticed that after upgrading, the payments are split in the daily payments report while the patient made one payment. I assume, it has something to do with the procedures getting automatically allocated to the payments. Or if the patient intentionally overpaid. So, if this is an intended behavior,...
by ForrestGumpDDS
Tue Dec 12, 2017 4:44 pm
Forum: Main Forum
Topic: cancel by accident
Replies: 5
Views: 7580

Re: cancel by accident

We are very unlikely to ever change the order, spacing, or position of the OK and Cancel buttons for any forms. We try to keep a consistent position and spacing of the OK and Cancel in our windows throughout the program and they are only ever moved when we are trying to make room for other buttons ...
by ForrestGumpDDS
Tue Dec 12, 2017 4:34 pm
Forum: Main Forum
Topic: Fee schedule based PPO.
Replies: 2
Views: 3827

Fee schedule based PPO.

Hi everyone. Setting up a new insurance. Very similar to the HMO with supplementals as described in manual, except for it's a PPO and has deductible and yearly maximum. So, the insurance has a maximum allowable charge, but the patient pays the portion based on the separate fee schedule rather than o...
by ForrestGumpDDS
Fri Aug 11, 2017 10:44 am
Forum: Main Forum
Topic: HMO writeoffs
Replies: 5
Views: 8690

Re: HMO writeoffs

Thank you.
Any plans for the future to add this "non-covered" calculations into the engine?
by ForrestGumpDDS
Thu Aug 10, 2017 1:17 pm
Forum: Main Forum
Topic: HMO writeoffs
Replies: 5
Views: 8690

Re: HMO writeoffs

Ok, great. I thought that I was getting crazy. I was trying to show my manager what she was doing wrong because i clearly remember it was working when the same plan was setup as a ppo "normal+copay" and remember specific instructions for the co-pay to be set as "0" in order for the writeoff to work ...
by ForrestGumpDDS
Thu Aug 10, 2017 11:24 am
Forum: Main Forum
Topic: HMO writeoffs
Replies: 5
Views: 8690

HMO writeoffs

Hello, Another HMO question. How do writeoffs calculated with HMO type insurance in OD? I set no "normal" fee schedule, proper co-pay schedule, type=Capitation, and "do not substitute codes". Now, if the co-pay schedule has a positive dollar amount for any given procedure, then I see a write off to ...
by ForrestGumpDDS
Thu Aug 03, 2017 1:41 pm
Forum: Main Forum
Topic: HMO claim affects the patient balance.
Replies: 11
Views: 13401

Re: HMO claim affects the patient balance.

>>>You should enter the payment as a patient payment or an insurance payment, but not both . If you decide to enter it as a patient payment, then you can sidestep having to create a claim and enter the payment there. I totally agree. The reason you see it on the screenshots is because I had to find ...
by ForrestGumpDDS
Tue Aug 01, 2017 2:43 pm
Forum: Main Forum
Topic: HMO claim affects the patient balance.
Replies: 11
Views: 13401

Re: HMO claim affects the patient balance.

As long as you have Claim Procedure with a status of Received or Supplemental, it should allow you to click Finalize Payment. Are you changing the status on the Claim Procedure to a different status like CapComplete? No, I'm not. This is what I do. the (dummy) pt. has an insurance set to that inisu...
by ForrestGumpDDS
Tue Aug 01, 2017 2:01 pm
Forum: Main Forum
Topic: A/R report question.
Replies: 2
Views: 4970

Re: A/R report question.

Thanks!
by ForrestGumpDDS
Tue Aug 01, 2017 6:59 am
Forum: Main Forum
Topic: A/R report question.
Replies: 2
Views: 4970

A/R report question.

Hi guys.
I have a question about AR breakdown report.
I see the columns "Total" "-W/o est", "-Ins est", "=PATIENT"
Will pre-determinations sent to the insurance affect these rows or these are strictly the numbers for the work that has been done?
Thanks
by ForrestGumpDDS
Sun Jul 23, 2017 1:43 pm
Forum: Main Forum
Topic: Electronic benefit verification
Replies: 5
Views: 14242

Re: Electronic benefit verification

Thank you,
Do you know if Claim Connect is able to verify insurance coverage for HMO plans or is it working for PPO plans only?
by ForrestGumpDDS
Thu Jul 20, 2017 5:56 pm
Forum: Main Forum
Topic: Electronic benefit verification
Replies: 5
Views: 14242

Electronic benefit verification

Hello, I am thinking to subscribe to the e-benefit verification service. Any clear winners between those suggested in manual? I currently use Tesia for claim processing and was wondering if any of the recommended services have both e-claims and e-verification at comparable rates? I pay Tesia 40 a mo...
by ForrestGumpDDS
Thu Jul 20, 2017 5:22 pm
Forum: Main Forum
Topic: HMO claim affects the patient balance.
Replies: 11
Views: 13401

Re: HMO claim affects the patient balance.

ok :| One last question. I checked w. OM about attaching the checks with the payments from Capitation InsCo's to the dummy procedure. She says she is having problems to attach the payment and using "Finalize payment" button. She creates the claim to Capitation, edits the amounts as recommended, clic...
by ForrestGumpDDS
Thu Jul 13, 2017 4:30 pm
Forum: Main Forum
Topic: HMO claim affects the patient balance.
Replies: 11
Views: 13401

Re: HMO claim affects the patient balance.

To do this, create a new billing type called something like "Capitation Carrier Payments" and set that as the billing type on your dummy carrier patient. Then whenever you run the A/R Aging report, unselect the "Capitation Carrier Payments" billing type. Just did it! Excellent! My office manager is...
by ForrestGumpDDS
Thu Jul 13, 2017 10:08 am
Forum: Main Forum
Topic: HMO claim affects the patient balance.
Replies: 11
Views: 13401

Re: HMO claim affects the patient balance.

Because we don't have the ability to enter payments on capitation claims, the workaround is to mark the plan as a PPO. You can then enter the fee schedule for the carrier as the amount insurance pays plus the patient copay. In your case the fee for the exam would be $30 and the fee for the PA would...
by ForrestGumpDDS
Wed Jul 12, 2017 6:03 pm
Forum: Main Forum
Topic: HMO claim affects the patient balance.
Replies: 11
Views: 13401

HMO claim affects the patient balance.

Hello guys, Could you please clarify something for me? I am setting up an HMO plan and trying to check it if the claim for supplemental payment will work properly. Following this instructions: http://www.opendental.com/manual/plancapitation.html Precisely, this particular part of it: If You Need to ...
by ForrestGumpDDS
Thu Jun 29, 2017 12:03 pm
Forum: Main Forum
Topic: Unable to log in to mobile web
Replies: 3
Views: 7452

Re: Unable to log in to mobile web

Confirmed!
It worked. Thank you
by ForrestGumpDDS
Mon Jun 26, 2017 10:04 pm
Forum: Main Forum
Topic: Unable to log in to mobile web
Replies: 3
Views: 7452

Unable to log in to mobile web

Hello, I'm on 17.1.22 When I point my browser (mobile or desktop) to https://patientviewer.com/?MID={XXX} I get the error window instead of the login screen. Error status text: Internal Server Error Error status code: 500 Error text: Could not load file or assembly 'OpenDentBusiness, Version=17.1.22...
by ForrestGumpDDS
Mon Jun 12, 2017 2:23 pm
Forum: Main Forum
Topic: Not able to start OD after moving A-Z folder to new server
Replies: 6
Views: 13633

Re: Not able to start OD after moving A-Z folder to new serv

I converted to MyISAM as soon as I installed the new server.
by ForrestGumpDDS
Mon Jun 12, 2017 1:02 pm
Forum: Main Forum
Topic: Tables containing patient personal information.
Replies: 4
Views: 9328

Re: Tables containing patient personal information.

There are many tables that might include personally identifiable information, and many that one might not realize It's funny you mentioned it, I was just thinking how I can accidentally expose the data and came up with "notes" too. I think we are looking to work with insurance carriers, their fees,...
by ForrestGumpDDS
Mon Jun 12, 2017 6:36 am
Forum: Main Forum
Topic: Tables containing patient personal information.
Replies: 4
Views: 9328

Tables containing patient personal information.

Hi guys, I am setting up the access for the service that will get me statistics reports. Something like a dashboard where I can see office performance. For the access, I would like to exclude the tables, that will or may contain patient sensitive information so this information would not get on such...
by ForrestGumpDDS
Mon Jun 12, 2017 6:30 am
Forum: Main Forum
Topic: Not able to start OD after moving A-Z folder to new server
Replies: 6
Views: 13633

Re: Not able to start OD after moving A-Z folder to new serv

There was also max_allowed_packet size problem again, I'm not sure why it keeps resetting. Your new virtual server might not have the correct settings within its my.cnf file. I would copy over your my.cnf from your old server and update any settings that are specific to the old server over to the n...
by ForrestGumpDDS
Mon Jun 05, 2017 5:38 pm
Forum: Main Forum
Topic: Not able to start OD after moving A-Z folder to new server
Replies: 6
Views: 13633

Re: Not able to start OD after moving A-Z folder to new serv

Yes, 17.1.10 I called you guys and spoke to Chris, he remoted in the latest setup on my computer and that fixed the problem. There was also max_allowed_packet size problem again, I'm not sure why it keeps resetting. Now, I'm on the latest version. I also noticed the support for SSH for the A-Z folde...
by ForrestGumpDDS
Mon Jun 05, 2017 3:53 pm
Forum: Main Forum
Topic: Not able to start OD after moving A-Z folder to new server
Replies: 6
Views: 13633

Not able to start OD after moving A-Z folder to new server

Hey guys, I hope it's something simple. I moved the A to Z folder from one virtual server (CentOS5) to another one (CentOS7). Migrated MySQL the same route about 2 months ago, have had 2 servers for awhile and now moved the AZ folder. The OD starts all the way to the login screen which shows current...
by ForrestGumpDDS
Wed May 17, 2017 1:37 pm
Forum: Main Forum
Topic: Exception while double clicking a group note. v 17.1.13.0
Replies: 3
Views: 9858

Re: Exception while double clicking a group note. v 17.1.13.

Thanks.
I am planning to upgrade it end of this week.
by ForrestGumpDDS
Tue May 16, 2017 7:01 pm
Forum: Main Forum
Topic: Exception while double clicking a group note. v 17.1.13.0
Replies: 3
Views: 9858

Exception while double clicking a group note. v 17.1.13.0

Just noticed. Could be the issue related th capital/lower case in the code due to the fact I run mysql on Linux. I'm not seeing any bad things, just the dialogue window. Clicking "Continue", pasting the text in there, e-signing, OK - all works. MySql.Data.MySqlClient.MySqlException (0x80004005): You...
by ForrestGumpDDS
Tue May 16, 2017 6:55 pm
Forum: Sharing
Topic: Perio Chart Voice Command Cheat Sheet v 1.1.0
Replies: 4
Views: 22069

Re: Perio Chart Voice Command Cheat Sheet v 1.1.0

Rickliftig wrote:viewtopic.php?f=1&t=6384
Here ya go!
Thank you Rick!
by ForrestGumpDDS
Thu Apr 06, 2017 3:19 pm
Forum: Main Forum
Topic: Unreadable characters after upgrade
Replies: 2
Views: 4580

Re: Unreadable characters after upgrade

That worked! Thanks
by ForrestGumpDDS
Thu Apr 06, 2017 12:57 pm
Forum: Main Forum
Topic: Unreadable characters after upgrade
Replies: 2
Views: 4580

Unreadable characters after upgrade

Sorry if this was described as a bug already, After upgrading 16.2.72 to 16.3.36 somewhere in December 2016 I noticed, that the procedure descriptions randomly incorporate a character in the text. The field where it's happening is "Description", so it is not editable to me. http://i.imgur.com/lFE7c9...
by ForrestGumpDDS
Thu Apr 06, 2017 12:45 pm
Forum: Main Forum
Topic: 'max_allowed_packet' value exceeded
Replies: 7
Views: 15346

Re: 'max_allowed_packet' value exceeded

Importing does a INSERT INTO [new_table] SELECT * FROM [old_table] so I could see why that would be exceeding your limit. We would have to treat that as a bug in our import tool but I'm not sure how we'd solve that because a table could have only one row and that one row could potentially be larger...
by ForrestGumpDDS
Thu Apr 06, 2017 11:11 am
Forum: Main Forum
Topic: 'max_allowed_packet' value exceeded
Replies: 7
Views: 15346

Re: 'max_allowed_packet' value exceeded

There was another table (total 2 tables were giving me the error).
Image
Do I want to do anything with them, or just leave them alone?
by ForrestGumpDDS
Thu Apr 06, 2017 10:32 am
Forum: Main Forum
Topic: 'max_allowed_packet' value exceeded
Replies: 7
Views: 15346

Re: 'max_allowed_packet' value exceeded

Thank you. I was on 16.3.51 at that time. The error I mentioned, has happened another time when importing. That required me to tweak the mySQL server's settings. The error looked less descriptive ERROR 2006 (HY000) at line 2874: MySQL server has gone away I went ahead and look at the offending entri...
by ForrestGumpDDS
Thu Apr 06, 2017 10:21 am
Forum: Sharing
Topic: Perio Chart Voice Command Cheat Sheet v 1.1.0
Replies: 4
Views: 22069

Re: Perio Chart Voice Command Cheat Sheet v 1.1.0

Thank you for posting it.
Are there any instructions on how to set it up?
by ForrestGumpDDS
Sun Mar 12, 2017 2:56 pm
Forum: Main Forum
Topic: 'max_allowed_packet' value exceeded
Replies: 7
Views: 15346

'max_allowed_packet' value exceeded

Hi guys, I was getting things ready for mygrating to a new server, when I encountered this error while creating a backup from existing database: 17:34:18 Dumping opendental (all tables) Running: mysqldump.exe --defaults-file="c:\users\user\appdata\local\temp\tmpowfbmb.cnf" --set-gtid-purged=OFF --us...
by ForrestGumpDDS
Tue Oct 11, 2016 1:56 pm
Forum: Main Forum
Topic: OD capabilities for dr's websites
Replies: 2
Views: 6290

Re: OD capabilities for dr's websites

Thank you, Arna. I do use forms. I do NOT use online scheduling or patient portal. Do I understand it correctly that on my side I do not need to use https when I have eServices components embedded to my website? I would like to build the support of online scheduling and patient portal at this time w...
by ForrestGumpDDS
Mon Oct 10, 2016 10:15 am
Forum: Main Forum
Topic: OD capabilities for dr's websites
Replies: 2
Views: 6290

OD capabilities for dr's websites

Hello, I'm re-designing my website and at the stage of contemplating the results with the people who will help me on this. From the technical point of view, what are the possibilities that OD can do for someone's website? I know, the question is very vague, but I'm not looing for the precise answer,...
by ForrestGumpDDS
Fri Aug 26, 2016 9:22 pm
Forum: Main Forum
Topic: Patient Portal - file path not found
Replies: 23
Views: 30784

Re: Patient Portal - file path not found

Jason, I did what you suggested, there were a few log events related to starting or stopping the eConnection service, nothing special. I am inclined to think that the guy made it up. I will double check with him when he's in the office, so I can see on my own where the problem is. Other wise I canno...
by ForrestGumpDDS
Fri Aug 26, 2016 9:18 pm
Forum: Main Forum
Topic: Patient Portal
Replies: 16
Views: 26686

Re: Patient Portal

Turns out the Windows computer that hosts the service was hung up. It was not down, but hung up. I had to hard reset it and the connection came to normal after restart.
by ForrestGumpDDS
Fri Aug 19, 2016 4:16 pm
Forum: Main Forum
Topic: Patient Portal
Replies: 16
Views: 26686

Re: Patient Portal

Hmm... Interesting. I just got the same error. I'm on a latest stable version, but not the latest patch.
"No immortal socket connection found for this RegistrationKeyNum"
by ForrestGumpDDS
Mon Aug 15, 2016 12:16 pm
Forum: Main Forum
Topic: Patient Portal - file path not found
Replies: 23
Views: 30784

Re: Patient Portal - file path not found

Thanks, Jason.
What's the name of the service I will have to narrow my search by when checking event viewer?
by ForrestGumpDDS
Sat Aug 13, 2016 9:49 am
Forum: Main Forum
Topic: Patient Portal - file path not found
Replies: 23
Views: 30784

Re: Patient Portal - file path not found

any suggestions?
by ForrestGumpDDS
Thu Aug 11, 2016 2:46 pm
Forum: Main Forum
Topic: Patient Portal - file path not found
Replies: 23
Views: 30784

Re: Patient Portal - file path not found

Hello everyone, I just noticed the problem returned back. One of my patients call me about trouble getting into te patient portal with the following message: Good morning! I can't access patient portal. I know my password, I'm just getting error: "Internal server error. Please notify the dental offi...
by ForrestGumpDDS
Thu May 19, 2016 10:52 am
Forum: Main Forum
Topic: Backup files have large size.
Replies: 31
Views: 42957

Re: Backup files have large size.

Hmm... the automated backup size is even better :) http://i.imgur.com/t2AJ4nW.jpg I guess this is because of the compression. Uncompressed is slightly over 500Mb That is awesome. I just checked on a test server and everything seems to be working fine! I did notice some code is still left after the u...
by ForrestGumpDDS
Wed May 18, 2016 5:02 pm
Forum: Main Forum
Topic: Backup files have large size.
Replies: 31
Views: 42957

Re: Backup files have large size.

Phew, that was mighty complicated and took a long time to fix. I can say for certain now that the enhancement to not "double store" attachments will be included with v16.1 which will stop future emails from downloading and storing the extra bloat of Base64 string representations of every attachment...
by ForrestGumpDDS
Mon Mar 07, 2016 1:15 pm
Forum: Main Forum
Topic: HTML code in email items.
Replies: 2
Views: 4224

Re: HTML code in email items.

Thanks for clarification, Jason.
by ForrestGumpDDS
Sat Mar 05, 2016 3:24 pm
Forum: Main Forum
Topic: HTML code in email items.
Replies: 2
Views: 4224

HTML code in email items.

Hello, I came across a weird issue. When I am looking at the chart of one of the patients I see the email item and it looks like a bunch of html code with all html tags, body text, headers etc. When I double click on it it shows me a window with a properly formatted human readable text in the body c...
by ForrestGumpDDS
Thu Feb 04, 2016 2:45 pm
Forum: Main Forum
Topic: Patient Portal - file path not found
Replies: 23
Views: 30784

Re: Patient Portal - file path not found

I remember testing it first myself prior to giving other patients the access and everything was working fine.
by ForrestGumpDDS
Wed Feb 03, 2016 4:07 pm
Forum: Main Forum
Topic: Patient Portal - file path not found
Replies: 23
Views: 30784

Re: Patient Portal - file path not found

Hello, Found this topic searching for the "file path not found" phrase. Suggest if I should start is as a separate topic. One of my patients just called and told me that "the links to the statements are broken" in patient portal. I went in myself and checked through my account. Just to be sure used ...
by ForrestGumpDDS
Tue Jan 26, 2016 7:09 am
Forum: Main Forum
Topic: Rolling the changes from back-up
Replies: 5
Views: 8979

Re: Rolling the changes from back-up

1. Emails. You can simply CommLog them in this case. No need to resend. 2. Claims. You can re-create and mark them 'Sent Verified'. What Clearinghouse do you use? Why would you think you need to resend (I may be missing something). 3. Forms is a trickier one. Those aren't easily moved from one data...
by ForrestGumpDDS
Fri Jan 22, 2016 7:03 am
Forum: Main Forum
Topic: Backup files have large size.
Replies: 31
Views: 42957

Re: Backup files have large size.

Great, thanks Jason!
Good compelling reason to try the beta for the first time, have always been afraid to touch them.
by ForrestGumpDDS
Thu Jan 21, 2016 3:48 pm
Forum: Main Forum
Topic: Rolling the changes from back-up
Replies: 5
Views: 8979

Re: Rolling the changes from back-up

Thank you. Good thing it was just one day. I just decided to do it manually. The problems that I see now are: Sent emails. You can only copy one by sending a new one. Sent claims. I must send new claims and cancel the old ones. Patient forms and consents. I have to generate PDF's and keep them as at...
by ForrestGumpDDS
Thu Jan 21, 2016 7:13 am
Forum: Main Forum
Topic: Rolling the changes from back-up
Replies: 5
Views: 8979

Rolling the changes from back-up

Hello everyone, I am looking for a help with backup strategy. Our main database was down for one day and I have a back-up for a day before everything was shut down. Nothing was lost, I just had a connectivity problem to the database and because I did not want to have one more day down for the practi...
by ForrestGumpDDS
Wed Jan 20, 2016 5:14 pm
Forum: Main Forum
Topic: Backup files have large size.
Replies: 31
Views: 42957

Re: Backup files have large size.

Jason, I really appreciate your work, and desire to help us all. I'll wait for the fix for everyone, it's not a big deal for me to wait whatever is necessary.
And yes, the green hat looks cool! :-)
by ForrestGumpDDS
Tue Jan 19, 2016 12:07 pm
Forum: Main Forum
Topic: Backup files have large size.
Replies: 31
Views: 42957

Re: Backup files have large size.

Jason,
I uploaded the backup file to Dropbox. I'll try to pull my.cnf from the server.
Where do I send you a link?
by ForrestGumpDDS
Tue Jan 19, 2016 6:26 am
Forum: Main Forum
Topic: Backup files have large size.
Replies: 31
Views: 42957

Re: Backup files have large size.

My database has ~82,000 emailmessage entries and the table is only ~60MB if that tells you anything... is your mysql folder encrypted or anything that would cause this additional bloat? 60MB will make me a whole lot happier. I don't think I am encrypting anything. But even in that case the increase...
by ForrestGumpDDS
Sat Jan 16, 2016 10:54 am
Forum: Main Forum
Topic: Backup files have large size.
Replies: 31
Views: 42957

Re: Backup files have large size.

What are the size differences uncompressed? daily_opendental_ 2014-12- 15 _02h02m_Monday.sql.bz2 14,456 KB compressed 86,492 KB unzipped <- fully functional, all the tables are present. daily_opendental_ 2014-12- 16 _02h02m_Tuesday.sql.bz2 288,657 KB compressed 478,143 KB unzipped <- 20 times the s...
by ForrestGumpDDS
Fri Jan 15, 2016 11:34 am
Forum: Main Forum
Topic: Backup files have large size.
Replies: 31
Views: 42957

Re: Backup files have large size.

I will have to check to speak certainly. Will be in that office only next week.
by ForrestGumpDDS
Thu Jan 14, 2016 3:20 pm
Forum: Main Forum
Topic: Backup files have large size.
Replies: 31
Views: 42957

Re: Backup files have large size.

I still don't get the reason for that instant jump https://photos-4.dropbox.com/t/2/AABAdNhwswTWTYr-KRKmZQTV8ZEawHac3ABIMHp41-PCjA/12/8646785/jpeg/32x32/3/1452830400/0/2/increase%20in%20size.jpg/EIzQtwYYrxcgBygH/fIpaYQLV8T7mGuixA99PTeJiKK4sXV-97wqCP4CREWE?size_mode=5&size=32x32 I checked the patient...
by ForrestGumpDDS
Thu Jan 14, 2016 2:54 pm
Forum: Main Forum
Topic: Backup files have large size.
Replies: 31
Views: 42957

Re: Backup files have large size.

You'll never get back to the tiny 20MB backups, just the RXNORM and SNOMED tables are ~24MB each (the downfall of code systems). But goodness me, you must send a lot of emails because that table is monstrous in comparison to all your other tables! :shock: Your email table pretty much where all your...
by ForrestGumpDDS
Thu Jan 14, 2016 7:02 am
Forum: Main Forum
Topic: Backup files have large size.
Replies: 31
Views: 42957

Re: Backup files have large size.

:lol: :lol: :lol: OK, I'm on 15.3.32 currently. -rw-rw---- 1 mysql mysql 24836812 Jun 25 2015 rxnorm.MYD -rw-rw---- 1 mysql mysql 24906636 Jan 13 19:29 securitylog.MYD -rw-rw---- 1 mysql mysql 27411736 Jun 25 2015 snomed.MYD -rw-rw---- 1 mysql mysql 38292016 Jan 7 15:29 sheetfield.MYD -rw-rw---- 1 m...
by ForrestGumpDDS
Wed Jan 13, 2016 2:32 pm
Forum: Main Forum
Topic: Is it possible to select a different database?
Replies: 3
Views: 6159

Re: Is it possible to select a different database?

Yes! It worked. My backups are useful now! Thank you dgraffeo.
by ForrestGumpDDS
Wed Jan 13, 2016 2:07 pm
Forum: Main Forum
Topic: Backup files have large size.
Replies: 31
Views: 42957

Re: Backup files have large size.

Wow, I thought you WERE Jason there for a little bit, that's uncanny! Anyways, what are you backing up? Is it JUST the database files or are you also backing up the OpenDentImages folders? I can tell you the database itself shouldn't really be that big; typically databases even with a lot of inform...
by ForrestGumpDDS
Wed Jan 13, 2016 1:28 pm
Forum: Main Forum
Topic: Is it possible to select a different database?
Replies: 3
Views: 6159

Is it possible to select a different database?

I am trying to verify the quality of my backups. The backup file that I test has been unzipped and the data was imported into another server instance that has a MySQL server running. A database 'opendental' and user 'opendental' with appropriate permissions were created prior to the import. I am try...
by ForrestGumpDDS
Wed Jan 13, 2016 12:13 pm
Forum: Main Forum
Topic: Backup files have large size.
Replies: 31
Views: 42957

Backup files have large size.

Hi everyone, First of all, I am not sure what the "normal" size would be for the backup file. I have an office with under 2,000 patients, maybe 1500 active ones. Backups are done on daily basis by the script, they are created and kept on the server, then rsynked to another machine. I noticed that on...
by ForrestGumpDDS
Thu Dec 03, 2015 6:08 am
Forum: Main Forum
Topic: eRx issue. Unable to transmit due to account configuration.
Replies: 13
Views: 18750

Re: eRx issue. Unable to transmit due to account configurati

Clicking on eRX will enable the program link, however in order to proceed with EPCS, you'll need to go through Identity Proofing and Credentialling (if you haven't already): http://opendental.com/manual/erxenable.html Once that is done, you'll have the option in the Admin tab to sign up for EPCS. h...
by ForrestGumpDDS
Tue Dec 01, 2015 5:29 pm
Forum: Main Forum
Topic: Remove automatic backups
Replies: 7
Views: 10534

Re: Remove automatic backups

ok, manualy it is.
by ForrestGumpDDS
Tue Dec 01, 2015 2:02 pm
Forum: Main Forum
Topic: eRx issue. Unable to transmit due to account configuration.
Replies: 13
Views: 18750

Re: eRx issue. Unable to transmit due to account configurati

Arna,
I believe I did. Are you talking about initial sign-up process when I clicked on eRx button first time and was brought to the setup screen?
Do you need me to call you with account information?
by ForrestGumpDDS
Tue Dec 01, 2015 1:52 pm
Forum: Main Forum
Topic: Remove automatic backups
Replies: 7
Views: 10534

Re: Remove automatic backups

OK, so I think that answers my question #1. About the question #2. Would that make any sense for anyone other than me to request a feature to have a shortcut button in the system to access those old backups for the purpose of controlling their growth? We are also talking about old setup files in the...
by ForrestGumpDDS
Tue Dec 01, 2015 12:02 pm
Forum: Main Forum
Topic: Remove automatic backups
Replies: 7
Views: 10534

Remove automatic backups

Hello there, I was reviewing mysql backups that I have and noticed a weird thing. While I have a script doing a structured backup jobs daily I found there were several backup archives there were not created by my script. These were full database dumps as if I did them through opendental menu. Except...
by ForrestGumpDDS
Tue Dec 01, 2015 7:15 am
Forum: Main Forum
Topic: eRx issue. Unable to transmit due to account configuration.
Replies: 13
Views: 18750

Re: eRx issue. Unable to transmit due to account configurati

Ok, it seems like my Admin interface does not even have the Electronic Prescribing Setup link group... Not sure how to attach a screenshot here, so i just copied a block on the right side of the page: Lists Location Pharmacy List Account Healthplan List Account Drug Set/Compound List Reports Pharmac...
by ForrestGumpDDS
Sat Nov 28, 2015 7:00 pm
Forum: Main Forum
Topic: Changing the computer that is allowed to run updates.
Replies: 2
Views: 5537

Changing the computer that is allowed to run updates.

I noticed that right now all the updates are allowed to be checked for and installed from one computer. Having a listener service installed on a different computer brings a problem now with the listener service. The workaround I found is to uninstall the service, then run the update from the setup f...
by ForrestGumpDDS
Wed Nov 25, 2015 12:18 pm
Forum: Main Forum
Topic: eRx issue. Unable to transmit due to account configuration.
Replies: 13
Views: 18750

Re: eRx issue. Unable to transmit due to account configurati

OK, understood. Will do in 30 mins.
by ForrestGumpDDS
Tue Nov 24, 2015 6:42 pm
Forum: Main Forum
Topic: eRx issue. Unable to transmit due to account configuration.
Replies: 13
Views: 18750

eRx issue. Unable to transmit due to account configuration.

Hello, I'm trying to send an eRx to the pharmacy and have no issues until I get to the screen for actual transmission, where I have 2 options - to print a prescription and to transmit. If I click "print" - it prints and appears in OD as a prescription to the pt. as it should. If I click "transmit" -...
by ForrestGumpDDS
Wed Nov 11, 2015 6:47 pm
Forum: Main Forum
Topic: fetching secure emails fails.
Replies: 2
Views: 5480

Re: fetching secure emails fails.

Derek,
You are right. The exception appears to be only when running the OD under unprivileged user.
Which is the way I hope it should be working. Looks like a permission issue to me. How do I fix this behavior?
by ForrestGumpDDS
Fri Oct 30, 2015 9:31 pm
Forum: Main Forum
Topic: fetching secure emails fails.
Replies: 2
Views: 5480

fetching secure emails fails.

Hello guys! When I follow these instructions http://opendental.com/manual/emailinbox.html and click on "Email" button in "Manage" module I get an exception (details attached below). Where do I look first? BTW, I have not installed the security certificates on the machine where I am getting this erro...
by ForrestGumpDDS
Fri Oct 30, 2015 9:09 pm
Forum: Main Forum
Topic: EHR Help
Replies: 1
Views: 4131

Re: EHR Help

marked
by ForrestGumpDDS
Fri Oct 30, 2015 9:06 pm
Forum: Advanced Topics
Topic: Appointment QR code idea.
Replies: 2
Views: 6176

Re: Appointment QR code idea.

I think it's an interesting idea. I just see 2 things that may become an obstacle. 1. You have to display it somewhere, and it cannot be a screen of the frontdesk desktop. Something like a screen-pad, like a mouse pad which is capable of show output. 2. The patient will need to have a scanner app on...
by ForrestGumpDDS
Mon Feb 24, 2014 2:26 pm
Forum: Main Forum
Topic: Best Provider for eClaims?
Replies: 25
Views: 38580

Re: Best Provider for eClaims?

wjstarck wrote:Can't speak for anything other than Emdeon 'cause that's all we've ever used.

No problems for going on at least 6 years now (maybe more).
Thanks. I gave them a call, will try them for $39.95/mo. No contract required.
by ForrestGumpDDS
Sun Feb 23, 2014 6:35 pm
Forum: Main Forum
Topic: Best Provider for eClaims?
Replies: 25
Views: 38580

Re: Best Provider for eClaims?

Looking to find an answer to the same question. With some companies developing faster, some slower the solutions become outdated sometimes. The last answer in this topic is 2 years old. So what's the good and cost efficient service to process eClaims out there these days? I signed up with Tesia, mai...
by ForrestGumpDDS
Wed Jan 08, 2014 9:04 am
Forum: Main Forum
Topic: Preview in scans.
Replies: 2
Views: 3012

Re: Preview in scans.

Thanks a lot, it worked. :)
I was going crazy... :)
by ForrestGumpDDS
Thu Jan 02, 2014 3:52 pm
Forum: Main Forum
Topic: Preview in scans.
Replies: 2
Views: 3012

Preview in scans.

Hello everyone, I'm looking for the solution of the problem that appears during scanning. I have a scanner Canon MG3112 that is attached to a workstation by usb cable. Upon clicking on either of the "scan" buttons in OD I used to see a preview window where I could crop on the element to be scanned. ...
by ForrestGumpDDS
Tue Nov 05, 2013 4:50 pm
Forum: Main Forum
Topic: Add order in the Kiosk of the imported web forms
Replies: 2
Views: 3313

Add order in the Kiosk of the imported web forms

I noticed that I cannot change (add) order number for the forms imported from web portal. The form gets imported, but when I try to assign the number to it by doubleclicking on it, it allows me to add the number, but does not allow it to exit by clicking OK. I cannot click OK without seeing a dialog...
by ForrestGumpDDS
Sun Nov 03, 2013 6:41 pm
Forum: Main Forum
Topic: PPO with co-pays.
Replies: 2
Views: 3535

Re: PPO with co-pays.

Thanks Jorge, The "co-pay" type procedure will not change totals for the other procedures and it shouldn't. Since there is no way for the system to accomodate it I will do this work around. I will add a pop-up to every patient on the plan for the front desk to collect $25 each visit. Then we will ha...
by ForrestGumpDDS
Thu Oct 31, 2013 4:28 pm
Forum: Main Forum
Topic: Crown initial or replacement
Replies: 14
Views: 14052

Re: Crown initial or replacement

Well, it's just like a medicine taste. It annoys you, you complain about it's not being tasty BUT you know it's there for a reason. So I'm with Jordan here. I give it a face when it pops up and next second say "Thanks, OD". My only problem with the field is that it requires the day and the month (wh...
by ForrestGumpDDS
Thu Oct 31, 2013 12:20 pm
Forum: Main Forum
Topic: PPO with co-pays.
Replies: 2
Views: 3535

PPO with co-pays.

Hi all, I have an issue that I feel should have a simple solution, however I am asking for your hands. We signed up with Federal Employees Plan and one of them has following features: The insurance has a fee schedule (they call it maximally allowable charges, or MAC) Pt. pays a co-pay of $25 for all...
by ForrestGumpDDS
Sat Jul 27, 2013 10:48 am
Forum: Main Forum
Topic: Cigna HMO setup.
Replies: 8
Views: 12861

Re: Cigna HMO setup.

OK, I will try this tonight. Just a though about the tutorial. I think it applies to the situation when both the insurance AND the patient have their set fees that are due upon procedure completion independent on each other. That's why you suppose to add patient's co-pay to supplemental fees and put...
by ForrestGumpDDS
Sat Jul 27, 2013 8:58 am
Forum: Main Forum
Topic: Cigna HMO setup.
Replies: 8
Views: 12861

Re: Cigna HMO setup.

Thank you! That makes sense now. I have another question, I noticed a very strange behavior in OD. Let's say ins. suppose to issue supplemental payments for the procedures and the pt. has a "0" co-pay. I set those procedures in OD as follows: 1. Create 2 identically named plans (one Normal, one co-p...
by ForrestGumpDDS
Tue Jul 16, 2013 9:49 am
Forum: Main Forum
Topic: Cigna HMO setup.
Replies: 8
Views: 12861

Re: Cigna HMO setup.

bump. Still have not figured it out.
by ForrestGumpDDS
Fri Jul 12, 2013 9:04 pm
Forum: Main Forum
Topic: Cigna HMO setup.
Replies: 8
Views: 12861

Re: Cigna HMO setup.

If your issue is only for this one procedure then... In the code setup for composite filling on posterior teeth there is an option to apply the alternate benefit of an amalgam restoration. You can over ride this setting in the insurance setup by checking the "Don't Substitute Codes" option in the i...
by ForrestGumpDDS
Thu Jul 11, 2013 8:34 pm
Forum: Main Forum
Topic: Cigna HMO setup.
Replies: 8
Views: 12861

Cigna HMO setup.

Hi all, I desperately need your advice. Looks like I am doing something wrong. I have a Cigna DHMO plan that I need to set up. The plan features 2 fee schedules. One is a common fee schedule for all members. It has a name "Supplemental fee schedule" (let's call it SFS for short). The other one is na...
by ForrestGumpDDS
Tue Apr 09, 2013 9:19 pm
Forum: Main Forum
Topic: How do I set up a plan like that?
Replies: 2
Views: 3409

Re: How do I set up a plan like that?

Thank you,
At least a good start. Let's see what can be done.
by ForrestGumpDDS
Tue Apr 09, 2013 3:52 pm
Forum: Main Forum
Topic: How do I set up a plan like that?
Replies: 2
Views: 3409

How do I set up a plan like that?

My wife is having an issue setting up two ins plans. Let me start with the first one. It's a discount plan, but with some modifications. For the procedures marked as FC$30 the pt. pays a one time co-pay $30 per visit AND the insurance pays $15, making $45 total. For one FC$30 procedure, or for all o...
by ForrestGumpDDS
Thu Feb 14, 2013 4:59 pm
Forum: Main Forum
Topic: To set up a referral letter
Replies: 3
Views: 6478

To set up a referral letter

I need to setup the way to issue referral (letter? slip?) to physician's office for medical consult prior to treating certain type of patients. What would my steps be? Which type of sheet will suit my needs best? Slip? Letter? The "letter type" seems to be what I want it to be except I cannot add a ...
by ForrestGumpDDS
Tue Jan 15, 2013 5:56 pm
Forum: Advanced Topics
Topic: Exception while viewing pt. information
Replies: 5
Views: 6581

Re: Exception while viewing pt. information

Database maintenance! Now I got a true meaning of your words, Jsalmon :)
It did fix the issue. Thanks!
Do I have to do anything with mysql on a server?
by ForrestGumpDDS
Tue Jan 15, 2013 11:04 am
Forum: Advanced Topics
Topic: Exception while viewing pt. information
Replies: 5
Views: 6581

Re: Exception while viewing pt. information

Thanks,
So, will OD team be able to find the bug using a backup of opendental database?
by ForrestGumpDDS
Sat Jan 12, 2013 6:48 pm
Forum: Advanced Topics
Topic: Exception while viewing pt. information
Replies: 5
Views: 6581

Exception while viewing pt. information

Long story short. We added a new patient and at any time I click on buttons on the left side (Family, Account, Treatment plan etc.) the corresponding patient info gets displayed, however immediately after that I get an exception window with information below: See the end of this message for details ...
by ForrestGumpDDS
Tue Aug 21, 2012 7:33 pm
Forum: Main Forum
Topic: CareCredit
Replies: 28
Views: 41007

Re: CareCredit

We've only been doing this for a short while, but our method is not as involved. Under payments we created a CareCredit payment type and under Adjustments we created a CareCredit Adj (which will be the fee taken by CareCredit). When the deposit gets made into the office checking account, we make an...
by ForrestGumpDDS
Tue Aug 21, 2012 7:27 pm
Forum: Main Forum
Topic: CareCredit
Replies: 28
Views: 41007

Re: CareCredit

please explain to me the purpose of this exercise? do you do this for all of your credit card payments also? why not calculate all the charges in your Quickbooks files? Let me try to explain this. Care credit transactions are different in the nature because they are a third party payment which are ...
by ForrestGumpDDS
Mon Aug 20, 2012 11:06 pm
Forum: Main Forum
Topic: CareCredit
Replies: 28
Views: 41007

Re: CareCredit

I'm wondering if there have been any changes or improvements since 2009. And also: Adjustment for CC pt that is named "Care Credit amount" - do I post it to Care Credit patient? What sign do I add? Seems to be the sign should be same as actual CC charge and opposite to Full fee. Which is conflicting...
by ForrestGumpDDS
Sun Apr 29, 2012 9:38 pm
Forum: Main Forum
Topic: Where to enter insurance's fee schedule?
Replies: 6
Views: 7513

Re: Where to enter insurance's fee schedule?

Thank you Jorgebon, your explanation makes it clear. And what would I want to do if some procedures are not covered? I was planning to skip non-covered procedures as I enter plan fees in Procedure Code window for that carrier. That should bring my fees on estimates and show pt's portion as 100% of m...
by ForrestGumpDDS
Sun Apr 29, 2012 10:04 am
Forum: Main Forum
Topic: Where to enter insurance's fee schedule?
Replies: 6
Views: 7513

Re: Where to enter insurance's fee schedule?

Thank you bpcomp and Jordan for pointing my wife into right sections of manual. I'm a dentist and know just some stuff about billing, and she does not have any billing experience at all. So we both have a lot of questions that might look rather straightforward ones. Now, let me mak sure I understood...
by ForrestGumpDDS
Fri Nov 18, 2011 5:40 pm
Forum: Main Forum
Topic: Technical q.'s on setting up a new office with OD
Replies: 9
Views: 10222

Re: Technical q.'s on setting up a new office with OD

Thank you, guys.
We are debating now.
by ForrestGumpDDS
Tue Nov 15, 2011 8:19 pm
Forum: Main Forum
Topic: Technical q.'s on setting up a new office with OD
Replies: 9
Views: 10222

Re: Technical q.'s on setting up a new office with OD

Thank you for your answers, Jordan and drtech. OK, let me recap. OD - supported by OD team. Installed on Windows machines. MySQL - support has to be through MySQL team, regardless of platform it is hosted. Right now it is planned by my friend to have an admin computer with Win7+OD and remotely conne...
by ForrestGumpDDS
Mon Nov 14, 2011 7:21 pm
Forum: Main Forum
Topic: Technical q.'s on setting up a new office with OD
Replies: 9
Views: 10222

Re: Technical q.'s on setting up a new office with OD

As Jordan said, if you want easy, use windows...if you want more power and better backup, use linux. If you are comfortable running linux and don't need server support, then I would by all means recommend using it. I have been running Ubuntu for years now and love it (besides a few hurdles of getti...
by ForrestGumpDDS
Mon Nov 14, 2011 6:57 pm
Forum: Main Forum
Topic: Technical q.'s on setting up a new office with OD
Replies: 9
Views: 10222

Re: Technical q.'s on setting up a new office with OD

1. Linux server installations can't receive the same level of support because our remote connection software doesn't work and we don't have the resources to figure out alternatives. It's very handy to have OD itself on the server machine for troubleshooting. 2. Since you will be using a Windows ser...
by ForrestGumpDDS
Sun Nov 13, 2011 6:19 pm
Forum: Main Forum
Topic: Technical q.'s on setting up a new office with OD
Replies: 9
Views: 10222

Technical q.'s on setting up a new office with OD

Hello everyone, I'm starting a new office, hopefully it'll be open in 3-4 months so it's time for me to start making decisions on hardware and OD setup. i'm lucky to have my friend helping me with ideas on network setup and hardware options. Here's a list of some technical questions that my friend g...