How to export File Paths

[Joey]

from the dcm4chee-web3 interface I can see the File Paths to the DICOM files.

Is it somehow possible to export these File Paths in combination with the Patient ID?

Thanks for any input!

[dtc...@gmail.com]

I don't think this can be done from the dcm4chee-web3 interface, can't think of any twiddle incantation that would work either, though it's certainly possible using a database query.

MySQL might go as follows (keeping in mind there are dozens of different ways to do this depending on your requirements):

mysql> select pat.pat_id "Patient ID", f.filepath "File Path" from study st join patient pat on st.patient_fk = pat.pk join series se on se.study_fk = st.pk join instance inst on inst.series_fk = se.pk join files f on f.instance_fk = inst.pk where st.study_iuid = "<INSERT YOUR STUDY UID HERE>";

Sample output would be:

+------------+----------------------------------------+

| Patient ID | File Path                              |

+------------+----------------------------------------+

| AA10720954 | 2017/4/26/5/E228D71A/6A5916FA/0D35143F |

| AA10720954 | 2017/4/26/5/E228D71A/6A5916FA/807E0B13 |

| AA10720954 | 2017/4/26/5/E228D71A/6A5916FA/9D77BCB7 |

| AA10720954 | 2017/4/26/5/E228D71A/6A5916FA/DED1233A |

+------------+----------------------------------------+

You might also want to prefix the file path with the archive mount point or directory.

[Joey]

Thank you! most appreciated :-)

I will see if I can turn this into some kind of script, it has been a tedious task to export patients manually.