I want to or How can I...

    I want to export the patient demographic data from MySQL to OpenOffice Calc (spreadsheet). Comma delimited file would be great for importing into Oo.


    Is this possible and does anyone have any hints for how to go about it?


    Thanks,
    Matt

    You could use the command line options to do that --query:table|fields|where|fmt|file


    dgate --query:"DICOMPatients|PatientID,PatientNam,PatientSex,PatientBir||%s,%s,%s,%s|demographics.txt"


    Data will be written to demographics.txt. A where clause can be added to limit data.

    Thanks. That worked great and pointed me in the right direction to get more info.


    dgate --query:"DICOMStudies |StudyDate, StudyModal,PatientID,PatientNam,PatientSex,PatientBir ||%s,%s,%s,%s,%s,%s |demographics.txt"


    :-)

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login