Posts by mrudiansyah

    Hi,


    apparently you have a syntax error in dicom.sql; Can you post 'show database layout' and you whole dicom.sql.


    Marcel

    Hi Marcel



    *WorkList*

    {

    { 0x0008, 0x0050, "AccessionNumber", 16, SQL_C_CHAR, DT_STR, "OBR.3" },

    { 0x0010, 0x0020, "PatientID", 64, SQL_C_CHAR, DT_STR, "PID.4" },

    { 0x0010, 0x0010, "PatientName", 64, SQL_C_CHAR, DT_STR, "PID.5" },

    { 0x0010, 0x0030, "PatientBirthDate", 8, SQL_C_DATE, DT_DATE, "PID.7" },

    { 0x0010, 0x0040, "PatientSex", 16, SQL_C_CHAR, DT_STR, "PID.8" },


    { 0x0010, 0x2000, "MedicalAlerts", 64, SQL_C_CHAR, DT_STR, "---" },

    { 0x0010, 0x2110, "ContrastAllergies", 64, SQL_C_CHAR, DT_STR, "---" },

    { 0x0020, 0x000d, "StudyInstanceUID", 64, SQL_C_CHAR, DT_UI, "---" },

    { 0x0032, 0x1032, "ReqPhysician", 64, SQL_C_CHAR, DT_STR, "OBR.16" },

    { 0x0032, 0x1060, "ReqProcDescription", 64, SQL_C_CHAR, DT_STR, "OBR.4.1" },


    { 0x0008, 0x0090, "ReferringPhysician", 64, SQL_C_CHAR, DT_STR, "---" },

    { 0x0008, 0x1060, "ReadingPhysician", 64, SQL_C_CHAR, DT_STR, "---" },

    { 0x0008, 0x1070, "Operator", 64, SQL_C_CHAR, DT_STR, "---" },

    { 0x0008, 0x1040, "DepartmentName", 64, SQL_C_CHAR, DT_STR, "---" },

    { 0x0040, 0x0100, "--------", 0, SQL_C_CHAR, DT_STARTSEQUENCE, "---" },

    { 0x0008, 0x0060, "Modality", 16, SQL_C_CHAR, DT_STR, "OBR.21" },

    { 0x0032, 0x1070, "ReqContrastAgent", 64, SQL_C_CHAR, DT_STR, "---" },

    { 0x0040, 0x0001, "ScheduledAE", 16, SQL_C_CHAR, DT_STR, "---" },

    { 0x0040, 0x0002, "StartDate", 8, SQL_C_DATE, DT_DATE, "OBR.7.DATE" },

    { 0x0040, 0x0003, "StartTime", 16, SQL_C_CHAR, DT_TIME, "OBR.7.TIME" },

    { 0x0040, 0x0006, "PerfPhysician", 64, SQL_C_CHAR, DT_STR, "---" },

    { 0x0040, 0x0007, "SchedPSDescription", 64, SQL_C_CHAR, DT_STR, "---" },

    { 0x0040, 0x0009, "SchedPSID", 16, SQL_C_CHAR, DT_STR, "OBR.4" },

    { 0x0040, 0x0010, "SchedStationName", 16, SQL_C_CHAR, DT_STR, "OBR.24" },

    { 0x0040, 0x0011, "SchedPSLocation", 16, SQL_C_CHAR, DT_STR, "---" },

    { 0x0040, 0x0012, "PreMedication", 64, SQL_C_CHAR, DT_STR, "---" },

    { 0x0040, 0x0400, "SchedPSComments", 64, SQL_C_CHAR, DT_STR, "---" },

    { 0x0040, 0x0100, "---------", 0, SQL_C_CHAR, DT_ENDSEQUENCE, "---" },


    { 0x0040, 0x1001, "ReqProcID", 16, SQL_C_CHAR, DT_STR, "OBR.4.0" },

    { 0x0040, 0x1003, "ReqProcPriority", 16, SQL_C_CHAR, DT_STR, "OBR.27" }

    }




    Rudiansyah

    Hi,


    can you look the conquest log in debug mode? It lists what items are queried and the reply.


    Marcel

    Hi Marcel


    server status


    [DICOMSERVER] UPACS THREAD 56: STARTED AT: Wed Jul 31 01:35:02 2019

    [DICOMSERVER] A-ASSOCIATE-RQ Packet Dump

    [DICOMSERVER] Calling Application Title : "GEHC "

    [DICOMSERVER] Called Application Title : "DICOMSERVER "

    [DICOMSERVER] Application Context : "1.2.840.10008.3.1.1.1", PDU length: 16352

    [DICOMSERVER] Number of Proposed Presentation Contexts: 1

    [DICOMSERVER] Presentation Context 0 "1.2.840.10008.5.1.4.31" 1

    [DICOMSERVER] Server Command := 0020

    [DICOMSERVER] Message ID := 0033

    [DICOMSERVER] 0000,0002 22 UI AffectedSOPClassUID "1.2.840.10008.5.1.4.31"

    [DICOMSERVER] 0000,0100 2 US CommandField 32

    [DICOMSERVER] 0000,0110 2 US MessageID 51

    [DICOMSERVER] 0000,0700 2 US Priority 0

    [DICOMSERVER] 0000,0800 2 US DataSetType 0

    [DICOMSERVER] 0002,0010 19 UI TransferSyntaxUID "1.2.840.10008.1.2.2"

    [DICOMSERVER] (ModalityWorkListQuery) search level:

    [DICOMSERVER] Query On Modality WorkList

    [DICOMSERVER] Queried item 0008 0005 is not in the database

    [DICOMSERVER] Queried item 0008 0020 is not in the database

    [DICOMSERVER] Queried item 0008 0030 is not in the database

    [DICOMSERVER] Queried item 0008 0090 is not in the database

    [DICOMSERVER] Queried item 0008 1030 is not in the database

    [DICOMSERVER] Queried item 0008 1060 is not in the database

    [DICOMSERVER] Queried item 0008 1070 is not in the database

    [DICOMSERVER] Queried item 0008 1150 is not in the database

    [DICOMSERVER] Queried item 0008 1155 is not in the database

    [DICOMSERVER] Queried item 0008 1150 is not in the database

    [DICOMSERVER] Queried item 0008 1155 is not in the database

    [DICOMSERVER] Queried item 0010 0021 is not in the database

    [DICOMSERVER] Queried item 0010 1000 is not in the database

    [DICOMSERVER] Queried item 0010 1010 is not in the database

    [DICOMSERVER] Queried item 0010 1020 is not in the database

    [DICOMSERVER] Queried item 0010 1030 is not in the database

    [DICOMSERVER] Queried item 0010 21b0 is not in the database

    [DICOMSERVER] Queried item 0010 21c0 is not in the database

    [DICOMSERVER] Queried item 0032 1064 is not in the database

    [DICOMSERVER] Queried item 0038 0010 is not in the database

    [DICOMSERVER] Queried item 0038 0011 is not in the database

    [DICOMSERVER] Queried item 0038 0050 is not in the database

    [DICOMSERVER] Queried item 0038 0300 is not in the database

    [DICOMSERVER] Queried item 0038 0500 is not in the database

    [DICOMSERVER] Queried item 0008 0100 is not in the database

    [DICOMSERVER] Queried item 0008 0102 is not in the database

    [DICOMSERVER] Queried item 0008 0103 is not in the database

    [DICOMSERVER] Queried item 0008 0104 is not in the database

    [DICOMSERVER] Queried item 0040 0020 is not in the database

    [DICOMSERVER] Queried item 0040 3001 is not in the database

    [DICOMSERVER] Queried item 0040 2016 is not in the database

    [DICOMSERVER] Queried item 0040 2017 is not in the database

    [DICOMSERVER] Issue Query on Columns: DICOMWorkList.AccessionN, DICOMWorkList.PatientNam, DICOMWorkList.PatientID, DICOMWorkList.PatientBir, DICOMWorkList.PatientSex, DICOMWorkList.MedicalAle, DICOMWorkList.ContrastAl, DICOMWorkList.StudyInsta, DICOMWorkList.ReqPhysici, DICOMWorkList.ReqProcDes, DICOMWorkList.ReqContras, DICOMWorkList.Modality, DICOMWorkList.ScheduledA, DICOMWorkList.StartDate, DICOMWorkList.StartTime, DICOMWorkList.PerfPhysic, DICOMWorkList.SchedPSDes, DICOMWorkList.SchedPSID, DICOMWorkList.PreMedicat, DICOMWorkList.ReqProcID

    [DICOMSERVER] Values: DICOMWorkList.Modality = E'MR' and DICOMWorkList.StartDate = E'20190730'

    [DICOMSERVER] Tables: DICOMWorkList

    [DICOMSERVER] Sorting (DICOMWorkList.PatientNam) DoSort := 1

    [DICOMSERVER] 0008,0050 6 SH AccessionNumber "111111"

    [DICOMSERVER] Coding sequence (0008,1110), level=1

    [DICOMSERVER] (sequence is empty)

    [DICOMSERVER] Coding sequence (0008,1120), level=1

    [DICOMSERVER] (sequence is empty)

    [DICOMSERVER] 0010,0010 6 PN PatientName "TEST, "

    [DICOMSERVER] 0010,0020 6 LO PatientID "222222"

    [DICOMSERVER] 0010,0030 8 DA PatientBirthDate "19781229"

    [DICOMSERVER] 0010,0040 2 CS PatientSex "M "

    [DICOMSERVER] 0010,2000 0 LO MedicalAlerts (empty)

    [DICOMSERVER] 0010,2110 0 LO Allergies (empty)

    [DICOMSERVER] 0020,000d 18 UI StudyInstanceUID "1.2.3.4.123456789"

    [DICOMSERVER] 0032,1032 8 PN RequestingPhysician "CEMPAKA "

    [DICOMSERVER] 0032,1060 10 LO RequestedProcedureDe "MRI THORAX"

    [DICOMSERVER] 0032,1070 0 LO RequestedContrastAge (empty)

    [DICOMSERVER] Coding sequence (0040,0100), level=1

    [DICOMSERVER] 0008,0060 2 CS Modality "MR"

    [DICOMSERVER] 0040,0001 0 AE ScheduledStationAETi (empty)

    [DICOMSERVER] 0040,0002 8 DA ScheduledProcedureSt "20190730"

    [DICOMSERVER] 0040,0003 6 TM ScheduledProcedureSt "120000"

    [DICOMSERVER] 0040,0006 0 PN ScheduledPerformingP (empty)

    [DICOMSERVER] 0040,0007 10 LO ScheduledProcedureSt "MRI THORAX"

    [DICOMSERVER] Coding sequence (0040,0008), level=2

    [DICOMSERVER] (sequence is empty)

    [DICOMSERVER] 0040,0009 0 SH ScheduledProcedureSt (empty)

    [DICOMSERVER] 0040,0012 0 LO PreMedication (empty)

    [DICOMSERVER] 0040,1001 0 SH RequestedProcedureID (empty)

    [DICOMSERVER] Records = 1

    [DICOMSERVER] C-Find (Modality Work List) located 1 records

    [DICOMSERVER] UPACS THREAD 56: ENDED AT: Wed Jul 31 01:35:02 2019

    [DICOMSERVER] UPACS THREAD 56: TOTAL RUNNING TIME: 0 SECONDS



    Regards

    Rudiansyah

    Hi marcell


    how add dicom tag in table dicomworklist?

    we add in dicom.sql

    { 0x0008, 0x0090, "ReferringPhysician", 64, SQL_C_CHAR, DT_STR, "---" },

    { 0x0008, 0x1060, "ReadingPhysician", 64, SQL_C_CHAR, DT_STR, "---" },

    { 0x0008, 0x1070, "Operator", 64, SQL_C_CHAR, DT_STR, "---" },


    but in server status, modalati can't get.


    [DICOMSERVER] 0010,0010 4 PN PatientName "TEST"

    [DICOMSERVER] 0010,0020 4 LO PatientID "212 "

    [DICOMSERVER] 0010,0030 8 DA PatientBirthDate "19800323"

    [DICOMSERVER] 0010,0040 2 CS PatientSex "F "

    [DICOMSERVER] 0010,2000 0 LO MedicalAlerts (empty)

    [DICOMSERVER] 0010,2110 0 LO Allergies (empty)

    [DICOMSERVER] 0020,000d 14 UI StudyInstanceUID "1.2.1234.56789"

    [DICOMSERVER] 0032,1032 0 PN RequestingPhysician (empty)

    [DICOMSERVER] 0032,1060 0 LO RequestedProcedureDe (empty)

    [DICOMSERVER] 0032,1070 0 LO RequestedContrastAge (empty)

    [DICOMSERVER] Coding sequence (0040,0100), level=1

    [DICOMSERVER] 0008,0060 2 CS Modality "MR"

    [DICOMSERVER] 0040,0001 0 AE ScheduledStationAETi (empty)

    [DICOMSERVER] 0040,0002 8 DA ScheduledProcedureSt "20190730"

    [DICOMSERVER] 0040,0003 6 TM ScheduledProcedureSt "120000"

    [DICOMSERVER] 0040,0006 0 PN ScheduledPerformingP (empty)

    [DICOMSERVER] 0040,0007 0 LO ScheduledProcedureSt (empty)

    [DICOMSERVER] Coding sequence (0040,0008), level=2

    [DICOMSERVER] (sequence is empty)

    [DICOMSERVER] 0040,0009 0 SH ScheduledProcedureSt (empty)

    [DICOMSERVER] 0040,0012 0 LO PreMedication (empty)

    [DICOMSERVER] 0040,1001 0 SH RequestedProcedureID (empty)

    [DICOMSERVER] Records = 1

    [DICOMSERVER] C-Find (Modality Work List) located 1 records


    regards

    Rudiansyah

    Hi Marcel


    we have any problem


    [lua]
    Importconverter0 = dofile('fujiprima.lua')


    but operatorname not have table dicomstudies, i am need operatorsname


    i was create in dicom.sql
    { 0x0008, 0x1070, "OperatorsName", 64, SQL_C_CHAR, DT_STR },


    in file fujiprima.lua


    if Data.Manufacturer == 'FUJI PHOTO FILM Co., ltd.' then
    sql("UPDATE dicomstudies SET operatorsn='%Data.PatientComments' WHERE dicomstudies.studyInsta='%Data.StudyInstanceUID'");
    end


    log not problem, but field operatornam is empty


    can you help me? i am need operatorsnam



    Regards
    Rudiin dicom.sql

    Hi, Marcel


    I problem again, but connect from DR Siemens.
    I think success this worklist conquest, but database worklist no visible in DR Siemens


    [PACSRSPMI] Values: DICOMWorkList.Modality = E'CR'
    [PACSRSPMI] Tables: DICOMWorkList
    [PACSRSPMI] Sorting (DICOMWorkList.PatientNam) DoSort := 1
    [PACSRSPMI] Query Distinct Tables: DICOMWorkList
    [PACSRSPMI] Columns : DICOMWorkList.AccessionN, DICOMWorkList.PatientNam, DICOMWorkList.PatientID, DICOMWorkList.PatientBir, DICOMWorkList.PatientSex, DICOMWorkList.MedicalAle, DICOMWorkList.ContrastAl, DICOMWorkList.StudyInsta, DICOMWorkList.ReqPhysici, DICOMWorkList.ReqProcDes, DICOMWorkList.Modality, DICOMWorkList.ReqContras, DICOMWorkList.ScheduledA, DICOMWorkList.StartDate, DICOMWorkList.StartTime, DICOMWorkList.PerfPhysic, DICOMWorkList.SchedPSDes, DICOMWorkList.SchedPSID, DICOMWorkList.SchedPSLoc, DICOMWorkList.PreMedicat, DICOMWorkList.ReqProcID, DICOMWorkList.ReqProcPri
    [PACSRSPMI] Where : DICOMWorkList.Modality = E'CR'
    [PACSRSPMI] Order : DICOMWorkList.PatientNam
    [PACSRSPMI] 0008,0050 10 SH AccessionNumber "123456789 "
    [PACSRSPMI] Coding sequence (0008,1110), level=1
    [PACSRSPMI] (sequence is empty)
    [PACSRSPMI] Coding sequence (0008,1120), level=1
    [PACSRSPMI] (sequence is empty)
    [PACSRSPMI] 0010,0010 14 PN PatientName "----"
    [PACSRSPMI] 0010,0020 10 LO PatientID "R1608.0501"
    [PACSRSPMI] 0010,0030 8 DA PatientBirthDate "19781229"
    [PACSRSPMI] 0010,0040 2 CS PatientSex "M "
    [PACSRSPMI] 0010,2000 0 LO MedicalAlerts (empty)
    [PACSRSPMI] 0010,2110 0 LO Allergies (empty)
    [PACSRSPMI] 0020,000d 0 UI StudyInstanceUID (empty)
    [PACSRSPMI] 0032,1032 14 PN RequestingPhysician "dr. And Lomata"
    [PACSRSPMI] 0032,1060 0 LO RequestedProcedureDe (empty)
    [PACSRSPMI] Coding sequence (0032,1064), level=1
    [PACSRSPMI] (sequence is empty)
    [PACSRSPMI] Coding sequence (0040,0100), level=1
    [PACSRSPMI] 0008,0060 2 CS Modality "CR"
    [PACSRSPMI] 0032,1070 0 LO RequestedContrastAge (empty)
    [PACSRSPMI] 0040,0001 0 AE ScheduledStationAETi (empty)
    [PACSRSPMI] 0040,0002 8 DA ScheduledProcedureSt "20160802"
    [PACSRSPMI] 0040,0003 6 TM ScheduledProcedureSt "010000"
    [PACSRSPMI] 0040,0006 0 PN ScheduledPerformingP (empty)
    [PACSRSPMI] 0040,0007 0 LO ScheduledProcedureSt (empty)
    [PACSRSPMI] Coding sequence (0040,0008), level=2
    [PACSRSPMI] (sequence is empty)
    [PACSRSPMI] 0040,0009 0 SH ScheduledProcedureSt (empty)
    [PACSRSPMI] 0040,0011 0 SH ScheduledProcedureSt (empty)
    [PACSRSPMI] 0040,0012 0 LO PreMedication (empty)
    [PACSRSPMI] 0040,1001 0 SH RequestedProcedureID (empty)
    [PACSRSPMI] 0040,1003 0 SH RequestedProcedurePr (empty)
    [PACSRSPMI] 0008,0050 10 SH AccessionNumber "4423123123"
    [PACSRSPMI] Coding sequence (0008,1110), level=1
    [PACSRSPMI] (sequence is empty)
    [PACSRSPMI] Coding sequence (0008,1120), level=1
    [PACSRSPMI] (sequence is empty)
    [PACSRSPMI] 0010,0010 18 PN PatientName "...."
    [PACSRSPMI] 0010,0020 10 LO PatientID "C1608.0010"
    [PACSRSPMI] 0010,0030 8 DA PatientBirthDate "19781229"
    [PACSRSPMI] 0010,0040 2 CS PatientSex "M "
    [PACSRSPMI] 0010,2000 0 LO MedicalAlerts (empty)
    [PACSRSPMI] 0010,2110 0 LO Allergies (empty)
    [PACSRSPMI] 0020,000d 0 UI StudyInstanceUID (empty)
    [PACSRSPMI] 0032,1032 16 PN RequestingPhysician "dr. Ari Soetoto "
    [PACSRSPMI] 0032,1060 0 LO RequestedProcedureDe (empty)
    [PACSRSPMI] Coding sequence (0032,1064), level=1
    [PACSRSPMI] (sequence is empty)
    [PACSRSPMI] Coding sequence (0040,0100), level=1
    [PACSRSPMI] 0008,0060 2 CS Modality "CR"
    [PACSRSPMI] 0032,1070 0 LO RequestedContrastAge (empty)
    [PACSRSPMI] 0040,0001 0 AE ScheduledStationAETi (empty)
    [PACSRSPMI] 0040,0002 8 DA ScheduledProcedureSt "20160802"
    [PACSRSPMI] 0040,0003 6 TM ScheduledProcedureSt "010000"
    [PACSRSPMI] 0040,0006 0 PN ScheduledPerformingP (empty)
    [PACSRSPMI] 0040,0007 0 LO ScheduledProcedureSt (empty)
    [PACSRSPMI] Coding sequence (0040,0008), level=2
    [PACSRSPMI] (sequence is empty)
    [PACSRSPMI] 0040,0009 0 SH ScheduledProcedureSt (empty)
    [PACSRSPMI] 0040,0011 0 SH ScheduledProcedureSt (empty)
    [PACSRSPMI] 0040,0012 0 LO PreMedication (empty)
    [PACSRSPMI] 0040,1001 0 SH RequestedProcedureID (empty)
    [PACSRSPMI] 0040,1003 0 SH RequestedProcedurePr (empty)
    [PACSRSPMI] Records = 2
    [PACSRSPMI] First record of cleaned response:
    [PACSRSPMI] 0008,0005 10 CS SpecificCharacterSet "ISO_IR 100"
    [PACSRSPMI] 0008,0050 10 SH AccessionNumber "123456789 "
    [PACSRSPMI] 0008,1110 0 SQ ReferencedStudySeque Sequence Item
    [PACSRSPMI] 0008,1120 0 SQ ReferencedPatientSeq Sequence Item
    [PACSRSPMI] 0010,0010 14 PN PatientName "...."
    [PACSRSPMI] 0010,0020 10 LO PatientID "R1608.0501"
    [PACSRSPMI] 0010,0030 8 DA PatientBirthDate "19781229"
    [PACSRSPMI] 0010,0040 2 CS PatientSex "M "
    [PACSRSPMI] 0010,2000 0 LO MedicalAlerts (empty)
    [PACSRSPMI] 0010,2110 0 LO Allergies (empty)
    [PACSRSPMI] 0020,000d 0 UI StudyInstanceUID (empty)
    [PACSRSPMI] 0032,1032 14 PN RequestingPhysician "dr. And Lomata"
    [PACSRSPMI] 0032,1060 0 LO RequestedProcedureDe (empty)
    [PACSRSPMI] 0032,1064 0 SQ RequestedProcedureCo Sequence Item
    [PACSRSPMI] 0040,0100 0 SQ ScheduledProcedureSt Sequence Item
    [PACSRSPMI] >0008,0060 2 CS Modality "CR"
    [PACSRSPMI] >0032,1070 0 LO RequestedContrastAge (empty)
    [PACSRSPMI] >0040,0001 0 AE ScheduledStationAETi (empty)
    [PACSRSPMI] >0040,0002 8 DA ScheduledProcedureSt "20160802"
    [PACSRSPMI] >0040,0003 6 TM ScheduledProcedureSt "010000"
    [PACSRSPMI] >0040,0006 0 PN ScheduledPerformingP (empty)
    [PACSRSPMI] >0040,0007 0 LO ScheduledProcedureSt (empty)
    [PACSRSPMI] >0040,0008 0 SQ ScheduledProtocolCod Sequence Item
    [PACSRSPMI] >0040,0009 0 SH ScheduledProcedureSt (empty)
    [PACSRSPMI] >0040,0011 0 SH ScheduledProcedureSt (empty)
    [PACSRSPMI] >0040,0012 0 LO PreMedication (empty)
    [PACSRSPMI] 0040,1001 0 SH RequestedProcedureID (empty)
    [PACSRSPMI] 0040,1003 0 SH RequestedProcedurePr (empty)
    [PACSRSPMI] C-Find (Modality Work List) located 2 records
    [PACSRSPMI] UPACS THREAD 117: ENDED AT: Tue Aug 02 15:55:16 2016
    [PACSRSPMI] UPACS THREAD 117: TOTAL RUNNING TIME: 0 SECONDS


    Thanks for any suggestions

    Hi, Marcell



    how do I add a hard disk as a storage further, if the of storage has previously been full?


    schematic:
    if MAG0 < 100MB then storage MAG1
    if MAG1 < 100MB then storage MAG2
    if MAG2 < 100MB then storage MAG3
    if MAG3 < 100MB then storage MAG4
    if MAG4 < 100MB then storage MAG5
    if MAG5 < 100MB then storage MAG6
    if MAG6 < 100MB then storage MAG7
    if MAG7 < 100MB then storage MAG8
    if MAG8 < 100MB then storage MAG9


    thank's Marcel