Skip to main content

Tooth Numbering XDR MySQL

Michael Satterfield
Updated

ONLY FOR INTERNAL REFERENCE BY CONVERSION TECHNICIANS, DO NOT PROVIDE OUTSIDE THE ORGANIZATION

NOTE:  This only applies to XDR MySQL conversions to DICOM (Apteryx)

How to add tooth numbers to the XDR MySQL database:

Ask the customer to provide a list of the XDR layout templates that they are regularly using in XDR for sensor captures.  There should be a list of template names such as "4 bitewing / 4BWX" and "Full Mouth Series / FMX18" in XDR, and we need to know which templates in that list they were regularly using for captures in XDR.  Those specific templates will be assigned tooth numbers using these steps below.

  1. Make a backup copy of the MyXDR\Data folder. You may need to stop the MySQL service first. Then restart it after the backup is complete.

  2. Install the MySQL Workbench older version 6.3.10:  

mysql-workbench-community-6.3.10-winx64.msi

  1. Requires installing Visual C++ 2015 x64 redistributable:

    1. vc_redist.x64.exe

  2. Launch the Workbench and create a new connection to their MySQL server.  Default connection info:

    • Hostname:  Localhost

    • Port:  3310

    • Username: root

    • Password:  <REMOVED>

      XDR4.jpg

  3. Navigate to the XDRDATA database, and the LAYOUT table. Right-click the LAYOUT table and select the top 1000 rows.

    XDR5.jpg
XDR6.jpg

  1. OPTIONAL STEP:  Ask the customer which templates they regularly use to capture sensor series (e.g. FMX18, 4 Bitewing, Checkup).   Alternatively you can run this SQL query to get a count of how many layouts had a specific name:
     

SELECT layoutname, count(*)

 FROM xdrdata.exam

 group by layoutname

 order by count(*) desc


Note the names of the layouts, and the relevant ID numbers in the "ID" column above. These numbers correspond to the LAYOUTID value in the LAYOUTTILE table:

XDR7.jpg

  1. Right-click on the LAYOUTTILE table name in the list on the left, and choose Alter Table.

  2. Add a column called Teeth with datatype VARCHAR(45) and default value NULL. This could alternatively be done by running this command:
     alter table `xdrdata`.`layouttile`add column Teeth varchar (45) AFTER Orientation;

    XDR8.jpg

  3. From here you can modify each cell of the Teeth column to specify the tooth numbers for that tile. Tooth numbers should be separated by commas. For tiles that are PAs and unknown tooth numbers, leave the cell at the NULL value.

    1. Launch XDR, go to Patients > select a patient, click New Exam, and then look at the Exam list.

    2. Select one of the templates that you look at, and click Edit Layout.  This will display the capture order of the tiles (red text "XRAY 1", "XRAY 2", "XRAY 3", etc).  That order corresponds to the Rank column.

      1. NOTE:  The tile order in the Rank column usually starts at "0", while the displayed tile order in the XDR software starts at "1".

    3. Double-click on one of the "Teeth" fields and add the tooth numbers separated by commas

    4. XDR9.jpg

      These cells can also be updated using commands such as:

      UPDATE `xdrdata`.`layouttile` SET `Teeth`='1,2,3,4,5,6' WHERE `LayoutId`='2' and`Rank`='0';

  4. Once all teeth have been specified, click Apply to save the changes.

NOTE:  Use this reference for the tooth numbers to be assigned to the tiles:

Full Mouth Series / FMX18 / FMX / FMS :

XDR_FMS.png

2 Bite Wing / 2BWX / 2 VBWX :

XDR_2BW.png

4 Bite Wing / 4BWX / 4 VBWX :

XDR_4BW.png

Checkup / 4 BWX 3 PA :

XDR_Checkup.png

Pedo FMX / 2 BW 2 PA :

XDR_Ped_FMS.png