Search found 46 matches

by drawab
Mon Nov 07, 2022 3:04 am
Forum: Advanced Topics
Topic: Open Dental DB on a NAS
Replies: 1
Views: 3270

Open Dental DB on a NAS

Would it be possible to install the SQL Database on a NAS drive connected to the main server via LAN? My guess is speed could be an issue but still thought it might be worth a try? I ask this mainly for security purposes, the NAS drive I can hide & lock away for security reasons / versus hiding / tu...
by drawab
Sun Nov 06, 2022 11:52 pm
Forum: Main Forum
Topic: Setting up Email - requires running Services?
Replies: 1
Views: 1352

Setting up Email - requires running Services?

I've been trying to setup email using Google / Gmail using tokens, but I'm unable to get it connected - it prompts "No Instance of Open Dental Service is running" -

im running 22.2.45 (foreign)
by drawab
Thu Nov 04, 2021 12:30 am
Forum: Advanced Topics
Topic: Using artificial intelligence in dentistry
Replies: 10
Views: 22035

Re: Using artificial intelligence in dentistry

Have you read about OVERJET.AI -- https://www.overjet.ai/ Seems to be taking AI to a interesting level - they claim to integrate with practice software - have they reached out / or have you seen implementation with Open Dental? They raised some funding as well -- TechCrunch > https://techcrunch.com/...
by drawab
Thu May 06, 2021 2:27 am
Forum: Advanced Topics
Topic: EmailAttachments Folder in OpenDentImages
Replies: 1
Views: 9261

EmailAttachments Folder in OpenDentImages

Hi I wanted to know the importance of the files being stored in the EmailAttachments folder within OpenDentImages - it has an In & Out folder as well - all three are taking up space in my OpenDentImages folder and wanted to know if I could do spring cleaning of this folder from time to time basis? A...
by drawab
Wed Jan 22, 2020 3:29 am
Forum: Main Forum
Topic: *Syncthing* FREE PC to PC sync between multiple offices
Replies: 6
Views: 24114

Re: *Syncthing* FREE PC to PC sync between multiple offices

Id be cautious on using it on OpenDental Database - in fact I'd suggest not to

this is only good for A-Z folders and I use it to sync across my X-ray database
bpcomp wrote:
Wed May 23, 2018 7:48 am
Looks like this handles the A-Z folder. How do you handle the database?
by drawab
Wed Jan 15, 2020 4:59 am
Forum: Advanced Topics
Topic: Using artificial intelligence in dentistry
Replies: 10
Views: 22035

Re: Using artificial intelligence in dentistry

The more digitized our practices become, the more possibilities shall open up into exploring how Deep Learning & AI can sift thru data in Open Dental. One amazing thing about OpenDental is the accessibility to all our data via User Queries - but you still need a super scientist on the front desk to ...
by drawab
Thu Oct 10, 2019 1:58 pm
Forum: Advanced Topics
Topic: Bridge for Carestream
Replies: 1
Views: 8989

Bridge for Carestream

I've been trying to integrate CareStream digital X-ray bridge into Open Dental but have repeatedly failed, despite trying Trophy Simple and Enhanced versions.

The error dialog that pops up

Code: Select all

Usage: patient [/h] [/c<str>] 
/h, --help
/c, --congig=<str>
Config xml file path
by drawab
Fri Nov 16, 2018 1:25 am
Forum: Main Forum
Topic: Create Planned Appointment with Highest priority - Pop-up
Replies: 3
Views: 5096

Re: Create Planned Appointment with Highest priority - Pop-u

thank you :D

the solution was a simple check/uncheck -- relieved

appreciate the help
by drawab
Thu Nov 15, 2018 12:09 am
Forum: Main Forum
Topic: Create Planned Appointment with Highest priority - Pop-up
Replies: 3
Views: 5096

Create Planned Appointment with Highest priority - Pop-up

Recently a dialog popup has started to annoy us as it seems to pop-up very frequently Create Planned Appointment with highest priority planned treatment selected? When we chart a treatment for a particular patient and in the process hop to the "images" section to view his/her pictures or xrays - or ...
by drawab
Thu Jun 28, 2018 1:47 pm
Forum: Advanced Topics
Topic: Replication error in my.ini
Replies: 3
Views: 7455

Re: Replication error in my.ini

Thank you for the suggestion I've seen some offices get stuck at the login screen when their primary key range has been used up in the securitylog table. Are you using random primary keys This is exactly what was up - I had 1,000,000 - 1,999,999 and it took approximately 2-1/2 years to use these key...
by drawab
Fri Jun 22, 2018 6:34 am
Forum: Advanced Topics
Topic: Replication error in my.ini
Replies: 3
Views: 7455

Replication error in my.ini

For a day One of my replication server seems to totally lock up - when I start the replication on the server - the OpenDental Freezes at the point of logging in to OD - I have figured that the problem may lie in the my.ini file - as when I restore it to default Opendental - with the default my.ini t...
by drawab
Thu Mar 22, 2018 6:52 am
Forum: Advanced Topics
Topic: Help migrating away from gotomypc to network environment
Replies: 6
Views: 10792

Re: Help migrating away from gotomypc to network environment

Jerry I went through approximately the same scenario expanded, from one practice to TWO practices wanting to share the same database with multiple users at each location - (you can extrapolate that to many more locations and maybe in your case 4+ locations if need be) I tip toed through the various ...
by drawab
Tue Oct 24, 2017 1:21 pm
Forum: Advanced Topics
Topic: Alternative to Crashplan - PC to PC backup over the Internet
Replies: 3
Views: 9269

Re: Alternative to Crashplan - PC to PC backup over the Inte

I've been using SYNCTHING [ https://syncthing.net/ ] for past two years Its in my opinion perfect for live Sync between two or even more computers - I copy the Open Dental Images folder across the two practices - so almost every 30 seconds it watches for changes and sends it across - I take it one s...
by drawab
Mon Oct 16, 2017 6:24 am
Forum: Main Forum
Topic: Multiple Location Strategies
Replies: 2
Views: 6252

Re: Multiple Location Strategies

its a touch and go situation - we also moved from one location to two, I tried the Remote Desktop idea but there was lag (slower internet speeds) - I have finally implemented Daisy Chain Replication setup and have enjoyed this service - but would not recommend this to the faint hearted, I must accep...
by drawab
Thu May 12, 2016 12:56 am
Forum: Main Forum
Topic: Wireless # automatically gets a US format
Replies: 3
Views: 7462

Re: Wireless # automatically gets a US format

WOW - little did we know the minor tweaks do matter a lot :) - it was indeed the Regional Settings which needed adjustment it can possibly sort a few other simultaneous issues as well. I tested this on one computer and it gave a warning that the database is in "English (United States)" I guess after...
by drawab
Wed May 11, 2016 5:52 am
Forum: Main Forum
Topic: Wireless # automatically gets a US format
Replies: 3
Views: 7462

Wireless # automatically gets a US format

Hi Im an Open Dental user (foreign) - the Wireless Phone field in the Family window - whenever we try to enter a cell phone number - it automatically defaults to add a 1(xxx) xxx-xxxx format Our numbers are in the 11 digit format 0123-4567890 but after entering the 8th digit is suddenly adds the 1(0...
by drawab
Mon Dec 21, 2015 11:36 pm
Forum: Advanced Topics
Topic: Replication: Unsafe statement written to binary log
Replies: 1
Views: 5524

Replication: Unsafe statement written to binary log

Hi After cautiously stepping into replication database as my solution to managing one database across two locations - my server error logs continuously show this type of warnings every read/write 2015-12-22 11:36:34, 2040, Warning, Unsafe statement written to the binary log using statement format si...
by drawab
Wed Nov 18, 2015 2:02 am
Forum: Advanced Topics
Topic: rsync openDentImages from linux to network windows machine
Replies: 2
Views: 6944

Re: rsync openDentImages from linux to network windows machi

Just a tip - ive been using Syncthing https://syncthing.net/ for a good 2 months and enjoy the Open Source app - its available in Linux / Windows & Mac version and is secure - install it on both computers and share the Device ID - link up the folder you want to share and let them sync - it watches f...
by drawab
Tue Oct 13, 2015 4:54 pm
Forum: Advanced Topics
Topic: Random Primary Keys - messes up Patient numbers
Replies: 1
Views: 4585

Random Primary Keys - messes up Patient numbers

Hi I was hoping to install Replication servers (due to horrible internet connections situations) - having set up the process - i turned on Random Primary Keys - and the new assigned patient numbers is jumping all over the place - what used to be a human readable chronologic order of 5 digit XXXXX ha...
by drawab
Sat Oct 10, 2015 3:56 am
Forum: Advanced Topics
Topic: Value was either too large or too small for an Int32
Replies: 6
Views: 11142

Re: Value was either too large or too small for an Int32

Thank you - worked like a charm !!
by drawab
Mon Oct 05, 2015 3:25 pm
Forum: Main Forum
Topic: Syncing Mulitple offices - OD Images folder: Syncthing
Replies: 0
Views: 4434

Syncing Mulitple offices - OD Images folder: Syncthing

For many days I've been hunting for a good app to sync the Open Dental Images folder (FYI do not sync DATA folder) across our two office locations We pondered over CrashPlan, BitSync and Dropbox etc - all paid and definitely reliable apps, but nothing beats an open source deployment that truly compe...
by drawab
Mon Oct 05, 2015 1:25 pm
Forum: Advanced Topics
Topic: Value was either too large or too small for an Int32
Replies: 6
Views: 11142

Re: Value was either too large or too small for an Int32

Thanks for looking into it - ive been using OD 15.2.13.0 for this setup (its a foreign version)

Thank you
by drawab
Mon Oct 05, 2015 2:54 am
Forum: Advanced Topics
Topic: Value was either too large or too small for an Int32
Replies: 6
Views: 11142

Re: Value was either too large or too small for an Int32

Update - trying to reverse import from the Google Cloud SQL to my localhost database - OD connects perfectly - so im now guessing its not an OD issue (?) but more or less a Google Cloud SQL configuration issue as OD tries to connect to it Also in the mean time ive been trying to setup a middle tier ...
by drawab
Sun Oct 04, 2015 4:34 pm
Forum: Advanced Topics
Topic: Value was either too large or too small for an Int32
Replies: 6
Views: 11142

Value was either too large or too small for an Int32

Hi In an effort to try and get the Database imported into a Google Cloud SQL instance - I run into this Int32 error - im guessing its the telephone number string acting up - but am lost - I tried fixing the database with the Telephone Tool - but it made no difference. - Google Cloud SQL instance is ...
by drawab
Fri Sep 18, 2015 3:37 pm
Forum: Advanced Topics
Topic: Database Timeout issue using EoIP
Replies: 4
Views: 8261

Re: Database Timeout issue using EoIP

UPDATE: The timeout setting in MySQL is set to 10 seconds a small tweak of the connect_timeout has solved this problem NOTES: Login to the MySQL Command Prompt and enter show variables like '%timeout'; then tweak from 10 seconds upwards - I personally found 60 seconds to allow enough of time for any...
by drawab
Wed Sep 16, 2015 3:11 pm
Forum: Advanced Topics
Topic: Database Timeout issue using EoIP
Replies: 4
Views: 8261

Re: Database Timeout issue using EoIP

Jason Thank you for the prompt reply, I think I have finally solved the problem, I think probably the port forwarding on the ADSL router probably worked - but for sure your various suggestions got me motivated to finally crack this puzzle - thank you for future references if someone stumbles across ...
by drawab
Mon Sep 14, 2015 3:40 am
Forum: Advanced Topics
Topic: Database Timeout issue using EoIP
Replies: 4
Views: 8261

Database Timeout issue using EoIP

Recently - we have expanded our network Initial setup - 192.168.1.* Expanded setup 192.168.2.* Both networks are connected to each other via Ethernet Over IP - (EoIP) using DD-WRT routers http://www.dd-wrt.com/wiki/index.php/EoIP_Routing and seting up advanced routing we were able to bridging both s...
by drawab
Fri Jun 12, 2015 11:41 pm
Forum: Advanced Topics
Topic: Blank FreeDentalConfig.xml
Replies: 2
Views: 4938

Re: Blank FreeDentalConfig.xml

Thank you that worked like a charm
by drawab
Tue Jun 09, 2015 6:30 am
Forum: Advanced Topics
Topic: Blank FreeDentalConfig.xml
Replies: 2
Views: 4938

Blank FreeDentalConfig.xml

Quite strangely - using 15.1.28.0 (foreign) and even the 15.1.26.0 - all computers connecting to OD get a Select Database dialogue everyday - and the staff has to manually choose the server and the database (I sometimes fear they may make a mistake to choose on of the older backups) I dug around and...
by drawab
Thu Apr 17, 2014 1:55 am
Forum: Advanced Topics
Topic: Over inflated EmailMessage.MYD
Replies: 3
Views: 5486

Over inflated EmailMessage.MYD

Hi I just noticed that one particular file EmailMessage.MYD is over inflated to over 1.5GB - it could have been that the software may have downloaded all the emails from the practice google / gmail account and have it archived into its own system OR is this file a record of all emails sent from the ...
by drawab
Fri Mar 07, 2014 11:20 pm
Forum: Main Forum
Topic: Upgrade to MySQL 4.1 error
Replies: 2
Views: 3722

Upgrade to MySQL 4.1 error

Just recently my workstation installations have started receiving an error [after a fresh Windows XP installation] Your version of MySQL wont work with this program: 5.5.14. You should upgrade to MyAQL 4.1 The main server is functioning correctly and any previous workstation installations are connec...
by drawab
Fri Mar 11, 2011 9:49 pm
Forum: Advanced Topics
Topic: Timeout in Database Integrity Check
Replies: 1
Views: 2909

Timeout in Database Integrity Check

Hi Today by coincidence I decided to do a Database Integrity Check to see if things were running smoothly was shocked to a see a huge list of problems - to an extent the popup dialog run beyond the screen and I could not locate <REPAIR> or <CANCEL> buttons, I assumed the cursor would be on default w...
by drawab
Wed Nov 03, 2010 3:09 am
Forum: Main Forum
Topic: google ranking
Replies: 2
Views: 3276

Re: google ranking

Jordan,

I salute your passion in creating this amazing software, I agree the least we can do is to provide link-backs to OpenDental. With time it shall make a difference

http://teeth.com.pk/blog
http://alvidental.com

Thank you
by drawab
Wed Dec 02, 2009 9:33 pm
Forum: Main Forum
Topic: Upgrade issue 6.8.24 [beta] [foreign]
Replies: 0
Views: 2550

Upgrade issue 6.8.24 [beta] [foreign]

Today I went through an upgrade of my installation - the main server upgraded perfectly downloaded the 6.8.24 [beta] [foreign] and went online after the usual procedures. When I ran the upgrade on the workstation it first searched for the "setup" file - which is usually stored in the OpenDentalImage...
by drawab
Wed Aug 19, 2009 4:12 pm
Forum: Main Forum
Topic: Time Clock
Replies: 5
Views: 5121

Re: Time Clock

It would be more user friendly if when a person enters their password to get into OD, a box pops up (like in MOGO) that asks if you want to clock in, Yes or No. When closing off the program the box also pops up asking if ready to clock out. Any thoughts? That is one way to solve the issue, but mind...
by drawab
Wed Aug 19, 2009 1:03 am
Forum: Main Forum
Topic: Any limitation in Open Source version?
Replies: 3
Views: 4145

Re: Any limitation in Open Source version?

I noticed that D Codes are disabled in compiled version. Thanks in advance. The D Codes are probably disabled because if i recall correctly the codes are copyrighted. Living in Saudia do you actually use the codes - we here in Pakistan dont and dont have any standards to follow or even any insuranc...
by drawab
Wed Aug 19, 2009 12:42 am
Forum: Main Forum
Topic: Time Clock
Replies: 5
Views: 5121

Re: Time Clock

While we are broaching the subject of time clocks - can I ask I wanted to have my staff securely punch in their time - meaning it should preferably be password protected. The way I have setup my office is that each computer logs in under a unique username [I do not assign staff and assitants sepeara...
by drawab
Mon Aug 10, 2009 4:33 pm
Forum: Main Forum
Topic: www.opendental.com
Replies: 7
Views: 6707

Re: www.opendental.com

Just saw this being tweeted around it does look as if you guys had a real tough battle.

http://domainnamewire.com/2009/08/10/op ... ental-com/

with the judgement posted here http://www.udrpsearch.com/case/1266265

All said im glad "we got it" w00t
by drawab
Thu Aug 06, 2009 11:33 pm
Forum: Main Forum
Topic: www.opendental.com
Replies: 7
Views: 6707

Re: www.opendental.com

Seriously a hearty congrats - one does not realize how important having the 'opendental.com' is - we seemed to have gotten used to the hyphen

Congrats to Dr. Sparks and his entire team, thats just one more feather in your cap
by drawab
Wed Jul 08, 2009 10:42 am
Forum: Main Forum
Topic: Easy Dental to Open Dental
Replies: 2
Views: 5295

Re: Easy Dental to Open Dental

I moved from Easy Dental to Open Dental about three years ago - after having used the Easy Dental software for eons [im thinking I was probably an ED user since 91 or 92 if not more]. The last purchase i had made was for the Easy Dental 2002 version used it for about four more years and finally in 2...
by drawab
Thu May 28, 2009 12:58 am
Forum: Main Forum
Topic: Supply Inventory
Replies: 16
Views: 15677

Re: Supply Inventory

Clive Impressive procedure, pending when OD revamps the Supply Inventory can I ask what software/tool are you using to enable your staff members to keep track of the stocks - I was clobbering around figuring out some Open Source solution but ended up finding Inflow Inventory [ http://www.inflowinven...
by drawab
Tue Mar 17, 2009 9:05 pm
Forum: Main Forum
Topic: Sheets: Printing Addresses on Envelops
Replies: 10
Views: 9916

Sheets: Printing Addresses on Envelops

Im really excited to see the ongoing development in the Sheets panel - I had one minor issue Scenario: Quite frequently I have wanted to send out individual letters to our patients and in the process just need the mailing address printed on the envelop [I don't have a label printer] Attempt to use S...
by drawab
Wed Feb 18, 2009 11:31 pm
Forum: Main Forum
Topic: Missing Teeth / Extraction Unhandled Exception
Replies: 3
Views: 3894

Re: Missing Teeth / Extraction Unhandled Exception

Thanks Jordan

thou the my.ini is as follows

Code: Select all

[mysqld]
basedir="C:/Program Files/MySQL/MySQL Server 5.0/"
datadir="D:/OpenDental/data/"
skip-innodb
I still downloaded and ran the Trial Installer - making sure that ONLY the my.ini were allowed to reinstall - but the same problem persists

Thanks
by drawab
Wed Feb 18, 2009 10:20 pm
Forum: Main Forum
Topic: RSS Feed?
Replies: 2
Views: 3602

Re: RSS Feed?

Id like to bump up this request for a Forum RSS feed - it would help us all keep an eye on the ongoing development and discussion. Tried to run it through a Yahoo Pipe but it just would not parse http://pipes.yahoo.com/pipes/pipe.info?_id=2042f87c68fe2a6d8a8b450a25db523b Thumbs up for Open Dental Team
by drawab
Wed Feb 18, 2009 1:56 am
Forum: Main Forum
Topic: Missing Teeth / Extraction Unhandled Exception
Replies: 3
Views: 3894

Missing Teeth / Extraction Unhandled Exception

Im getting an error when trying to list Missing Teeth or even extraction of teeth - have tried to do database maintainence but to no luck thanks --------------- See the end of this message for details on invoking just-in-time (JIT) debugging instead of this dialog box. ************** Exception Text ...
by drawab
Thu Nov 13, 2008 8:22 pm
Forum: Main Forum
Topic: Household mailing list
Replies: 1
Views: 2603

Household mailing list

Im just wondering if there is a specific SQL query that can be used to create a mailing list that can be used to send letters to each household rather then every patient registered from the same house. I wanted to export this into excel and mail merge a letter to each house / family

Thanks