Open Dental Forum

ForrestGumpDDS

Did I ask my question in a wrong place?

ForrestGumpDDS

Good afternoon, I am trying to enhance my website by embedding some e-services features on the page dedicated to the patients. The website is implemented on a Wordpress. The features I'm looking to add to the website - ability of the new patient to schedule the appointment (as described in the manua...

ForrestGumpDDS

The issue was that the Workbench was refusing to operate on the database giving me the error that the database version is not supported. I spent hours trying to find a backup tool that supports the MariaDB and was wondering how is it at all possible that MariaDB wasn't supported by Workbench. Turned...

ForrestGumpDDS

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

ForrestGumpDDS

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

ForrestGumpDDS

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

ForrestGumpDDS

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

ForrestGumpDDS

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

ForrestGumpDDS

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

ForrestGumpDDS

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

ForrestGumpDDS

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

ForrestGumpDDS

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

ForrestGumpDDS

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

ForrestGumpDDS

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

ForrestGumpDDS

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

ForrestGumpDDS

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

ForrestGumpDDS

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

ForrestGumpDDS

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

ForrestGumpDDS

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

ForrestGumpDDS

Thanks, Jordan.

ForrestGumpDDS

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

ForrestGumpDDS

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

ForrestGumpDDS

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

ForrestGumpDDS

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

ForrestGumpDDS

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.

ForrestGumpDDS

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

ForrestGumpDDS

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

ForrestGumpDDS

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

ForrestGumpDDS

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

ForrestGumpDDS

Thanks, will do.
I was hoping it was going to be something easier, like a custom query I can do.

ForrestGumpDDS

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

ForrestGumpDDS

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

ForrestGumpDDS

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

ForrestGumpDDS

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

ForrestGumpDDS

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.

ForrestGumpDDS

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

ForrestGumpDDS

I was about to say "it's not Dentrix I'm seeing, right"?
Welcome back, Arna!

ForrestGumpDDS

Thanks, looks like I'm going to need to wait till 18.4

ForrestGumpDDS

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?

ForrestGumpDDS

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

ForrestGumpDDS

Just the time that it takes the OD to update, well, maybe megabytes too, each backup is close to 0.5Gb (archived version).

ForrestGumpDDS

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

ForrestGumpDDS

I was running this tool today in a hope to deflate the emailmessage table.
Is this output normal?

ForrestGumpDDS

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

ForrestGumpDDS

Thank you,
It says "approved". Anyway voted +20 points.

ForrestGumpDDS

ForrestGumpDDS

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.

ForrestGumpDDS

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?

ForrestGumpDDS

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.

ForrestGumpDDS

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,...

ForrestGumpDDS

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

ForrestGumpDDS

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

ForrestGumpDDS

OK, I will.
It is not giving me any inconveniences, just noted what I think is a bug.

ForrestGumpDDS

Yes, correct.

ForrestGumpDDS

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

ForrestGumpDDS

Excellent, thanks.
That's what I was looking for.

ForrestGumpDDS

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

ForrestGumpDDS

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

ForrestGumpDDS

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

ForrestGumpDDS

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

ForrestGumpDDS

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

ForrestGumpDDS

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

ForrestGumpDDS

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

ForrestGumpDDS

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

ForrestGumpDDS

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

ForrestGumpDDS

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

ForrestGumpDDS

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

ForrestGumpDDS

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

ForrestGumpDDS

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

ForrestGumpDDS

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

ForrestGumpDDS

Gerat, will do tomorrow.

ForrestGumpDDS

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,...

ForrestGumpDDS

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

ForrestGumpDDS

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

ForrestGumpDDS

Thank you.
Any plans for the future to add this "non-covered" calculations into the engine?

ForrestGumpDDS

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

ForrestGumpDDS

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

ForrestGumpDDS

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

ForrestGumpDDS

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

ForrestGumpDDS

Thanks!

ForrestGumpDDS

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

ForrestGumpDDS

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?

ForrestGumpDDS

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

ForrestGumpDDS

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

ForrestGumpDDS

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

ForrestGumpDDS

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

ForrestGumpDDS

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

ForrestGumpDDS

Confirmed!
It worked. Thank you

ForrestGumpDDS

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

ForrestGumpDDS

I converted to MyISAM as soon as I installed the new server.

ForrestGumpDDS

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,...

ForrestGumpDDS

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

ForrestGumpDDS

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

ForrestGumpDDS

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

ForrestGumpDDS

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

ForrestGumpDDS

Thanks.
I am planning to upgrade it end of this week.

ForrestGumpDDS

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

ForrestGumpDDS

Rickliftig wrote:viewtopic.php?f=1&t=6384
Here ya go!

Thank you Rick!

ForrestGumpDDS

That worked! Thanks

ForrestGumpDDS

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

ForrestGumpDDS

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

ForrestGumpDDS

There was another table (total 2 tables were giving me the error).

Do I want to do anything with them, or just leave them alone?

ForrestGumpDDS

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

ForrestGumpDDS

Thank you for posting it.
Are there any instructions on how to set it up?

ForrestGumpDDS

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

ForrestGumpDDS

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

ForrestGumpDDS

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,...

ForrestGumpDDS

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

ForrestGumpDDS

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.

ForrestGumpDDS

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"

ForrestGumpDDS

Thanks, Jason.
What's the name of the service I will have to narrow my search by when checking event viewer?

ForrestGumpDDS

any suggestions?

ForrestGumpDDS

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

ForrestGumpDDS

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

ForrestGumpDDS

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

ForrestGumpDDS

Thanks for clarification, Jason.

ForrestGumpDDS

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

ForrestGumpDDS

I remember testing it first myself prior to giving other patients the access and everything was working fine.

ForrestGumpDDS

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

ForrestGumpDDS

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

ForrestGumpDDS

Great, thanks Jason!
Good compelling reason to try the beta for the first time, have always been afraid to touch them.

ForrestGumpDDS

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

ForrestGumpDDS

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

ForrestGumpDDS

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!

ForrestGumpDDS

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?

ForrestGumpDDS

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

ForrestGumpDDS

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

ForrestGumpDDS

I will have to check to speak certainly. Will be in that office only next week.

ForrestGumpDDS

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

ForrestGumpDDS

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

ForrestGumpDDS

: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...

ForrestGumpDDS

Yes! It worked. My backups are useful now! Thank you dgraffeo.

ForrestGumpDDS

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

ForrestGumpDDS

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

ForrestGumpDDS

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

ForrestGumpDDS

Just sent you an email Arna.

ForrestGumpDDS

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

ForrestGumpDDS

ok, manualy it is.

ForrestGumpDDS

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?

ForrestGumpDDS

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

ForrestGumpDDS

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

ForrestGumpDDS

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

ForrestGumpDDS

Thanks Jason!

ForrestGumpDDS

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

ForrestGumpDDS

OK, understood. Will do in 30 mins.

ForrestGumpDDS

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" -...

ForrestGumpDDS

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?

ForrestGumpDDS

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

ForrestGumpDDS

marked

ForrestGumpDDS

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

ForrestGumpDDS

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.

ForrestGumpDDS

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

ForrestGumpDDS

Thanks a lot, it worked.

I was going crazy...

ForrestGumpDDS

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

ForrestGumpDDS

ok, thanks!

ForrestGumpDDS

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

ForrestGumpDDS

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

ForrestGumpDDS

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

ForrestGumpDDS

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

ForrestGumpDDS

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

ForrestGumpDDS

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

ForrestGumpDDS

bump. Still have not figured it out.

ForrestGumpDDS

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

ForrestGumpDDS

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

ForrestGumpDDS

Thank you,
At least a good start. Let's see what can be done.

ForrestGumpDDS

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

ForrestGumpDDS

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

ForrestGumpDDS

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?

ForrestGumpDDS

Thanks,
So, will OD team be able to find the bug using a backup of opendental database?

ForrestGumpDDS

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

ForrestGumpDDS

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

ForrestGumpDDS

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

ForrestGumpDDS

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

ForrestGumpDDS

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

ForrestGumpDDS

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

ForrestGumpDDS

Thank you, guys.
We are debating now.

ForrestGumpDDS

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

ForrestGumpDDS

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

ForrestGumpDDS

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

ForrestGumpDDS

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

Search found 180 matches