Skip to main content

Dentrix Imaging Center (SQL Server)

Michael Satterfield
Updated

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

NOTE: This is for the Microsoft SQL Server database version of Dentrix Imaging Center

NOTE:  Convert to XrayVision first, then to DICOM

Unzip two converter folders:

  1. Converter-ascend-to-XV

  2. Converter-XV-to-DICOM

  • First, convert Dentrix Ascend to a blank XrayVision (Apteryx Imaging) database

    1. Use the empty \patients\ folder in the converter directory as the blank database

  • Then convert the Apteryx Imaging (XV) database to DICOM

Run ALL of these steps for BOTH the INITIAL AND FINAL conversions:

  1. Make a new "Dentrix Imaging Center" folder inside the converter-ascend-to-XV folder

  2. Make these subfolders inside the "Dentrix Imaging Center" folder: patient, exam, examimage

  3. From the Start Menu, launch SQL Server Management Studio, connect to the RCI_DATA instance

  4. Right-click the RealCloud database, go to Tasks > Export Data

  5. Export each of these tables as TXT files with TAB delimiting:  patient, exam, examimage

    1. For example, for patient table exported to patient.txt:

      image-20250421-180003.png
image-20250421-180019.pngimage-20250421-180029.pngimage-20250421-180042.png

  1. Import each TXT file into Excel, and select "Do not detect data type" during import

  2. Export each Excel sheet as a CSV (comma-delimited) file:  patient.csv, exam.csv, examimage.csv

    1. NOTE: Open each CSV in Notepad and delete the first row "Column1, Column2, Column3…" so that the header row "PatientID…" is the first row.

  3. Transfer CSV files into each of the patient/exam/examimage folders created above

  4. Launch converter-ascend-to-XV, select convert to Apteryx Imaging database, and choose the blank "patients" database.

  5. Select Dentrix Ascend for the database to convert

    1. Data path: converter-ascend-to-XV\Dentrix Imaging Center

    2. Image path: ..\DENTRIX\Common\Imaging Center

  6. After converting from Ascend to XV, then run converter-XV-to-DICOM and convert the \patients\ folder created above into DICOM format, destination path:  converter-XV-to-DICOM\Apteryx-Images

NOTE:  For final conversion, do NOT reuse any of the old CSV files from the initial conversion. You will need to re-export all of the latest table data to new CSV files.