Skip to main content

Dentrix Imaging Center (PostgreSQL version)

Michael Satterfield
Updated

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

NOTE: This is for the PostgreSQL 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.  In Start Menu try to find Imaging Center Configuration tool, and launch it, or try to run this EXE: "C:\Program Files (x86)\Dentrix Imaging Center\CONFIG\DTXIC Configuration.exe

  4. Click Show Password to see the SQL database password. Copy this password to Notepad.

    image-20251029-153549.png

  5. Search for pgAdmin in the Start Menu. If pgAdmin is not installed, then install the latest version of pgAdmin4 from www.pgadmin.org

  6. Launch pgAdmin, go to the Object Explorer on the left, and choose the PostgreSQL 16 server:

    image-20251029-153634.png

  7. It will prompt for the password to connect to the server.  Enter the password copied from step #2 above.

  8. Within the object explorer, navigate to Databases > realcloud > Schemas > Tables

  9. Right-click on the exam table, and go to Import/Export Data

  10. On the Options tab, enable Header. For the Delimiter, choose [tab].

    image-20251029-153654.png

  11. On the General tab, choose Export, choose "csv" for the format, specify the filename exam.TXT and save it to the folder Dentrix Imaging Center\exam\

  12. Repeat steps 9-11 for the examimage and patient tables, saving to the examimage and patient folders.

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

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

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

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

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

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