iDentist is a patient-oriented software. This means that the core of the entire system is the patient – client. That’s why iDentist’s mainscreen always displays the list of patients. The patients list permanently located on the left side of the program’s main screen. Above this list there is a toolbar that allows you to:
Add new record
Delete a record
Sort records (ascending or descending)
Print a patient catalogue.
Over this toolbar, there is the already known search box that works as a filter for filtering the records that will be displayed in the list.
For example, if you want to list only the records of patients whose last name begins with AM, you do not have more but to write in this search box, and immediately iDentist will show in the list, only the patients whose last name begins with AM.
Every time you click on a record in the list, iDentist automatically shows the details of that record in the right panel of the screen. So simple. If you do changes in record data in the right panel, you must press the Savebutton that lays either on top or bottom edges of the right panel, to apply permanently the changes. You will find more details about adding and editing records in the next pages. The list of patients in the left panel, divides records into groups of 100 items (pages). So if you scroll down the list and you do not see the record that you want, change page by clicking on the navigation bar below the list. This is a common navigation bar and its operation is obvious. The first button of the navigation bar moves the list to show the records of the first page (the first 100 records). The last button moves the list to show the last page. For example if you have a total of 500 records in iDentist’s database, the last button of the navigation bar will move list to show records from 400 to 500. In the center of the navigation bar the page indicator shows the current page shown compared in total pages. For example an indication of 3/7 means that the list shows records of the third page in total of seven pages. The total number of records displayed under the navigation bar.
iDentist can be extended by using reports created to comply to your needs, by iReport PLUS software. You can purchase iReport PLUS software from AppStore by clicking here. iReport PLUS is the only report generator in AppStore and it is the only software that can create reports compatible with iDentist. Do not try to connect reports created with other software into iDentist, because you can loose data records. To continue with step by step instructions, in this document, we assume that the two applications iDentist and iReport PLUS are present into your system under the ~/Applications folder. We will describe how to achieve the iReport PLUS to iDentist connection bridge via an example.
Before we start the step by step instructions we must know some details about our operating system. iReport PLUS runs smoothly in OSX Snow Leopard or later. This means iReport PLUS runs without any problem up to OSX Mavericks 10.9. This is not the same with iDentist that runs in systems at least with OSX Mountain 10.7 or later. Also you must know that iDentist runs in a Sandbox environment. Sandbox may cause some confusion to the user who tries to find where the application data are stored. Due to Sandbox iDentist does not store its database into an easy accessed folder, so it is almost unaccessible by iReport PLUS. Thankfully there is a clever trick that bypasses this problem and make things better. So for the first time, before use the bridge between the two programs, we must create its foundations.
To create a link to iDentist’s database folder:
Open a Finder window and from menu choose Go->Library. To see the Library sub menu you must also press the (alt) option key.
In the Finder window just opened navigate to folder Containers and open it by double click on it. In this folder you will find a sub folder named gr. enhance.iDentist. Open it by double clicking on it. Then you’ ll see an other folder named Data. Continue by opening the folder Library and next the folder Application Support. In this folder you will see a folder named iDentist. Drag and drop this folder on the left cyan side panel of Finder’s window.
You must do this little trick only for the first time. Once the link created, iReport can reach iDentist’s database. Please continue reading this document. In the following pages there are step by step instructions on how to create and connect a custom report to iDentist application.
This document is useful to all dentists that purchased iReport PLUS to construct their own reports.
The tables are structured boxes that holds data. Each table consists by rows and columns. Rows are records. If you have 100 patients in your database. Then the Patients table has 100 rows. Every row is a collection of columns. Each column is like a small cell that contains the actual data. Every column has a name to refer to. All iDentist database structure is presented below:
Table structure for Appointments
“app_id”, record id number
“app_Date”, appointment date
“app_Patient_ID”, patient’s record id
“app_Time”, appointment time
“app_Notes”, notes on appointment
“app_Done”, indicates when the appointment is done or not – default value is 0 that means not done
“app_Date_String”, the appointment date as string
Table structure for Clinic
“cln_id”, record id number
“cln_ClinicName”, clinic name
“cln_Specialities”, clinic specialities
“cln_Address”, clinic address
“cln_ZipCode”, zip code
“cln_TaxNumber”, clinic tax number
“cln_TaxOffice”, tax office
“cln_Notes”, some notes for the clinic
“cln_email”, email address (normally an accessible to all clinic members email address)