Hi
First i wold like to ask is there any possibility to use tcp/ip hl7 between conquest and any RIS/HIS system
Second;What am I doing wrong with that modality worklist. Example
1. this is my dicom.sql file
*WorkList*
{
{ 0x0010, 0x0010, "PatientName", 64, SQL_C_CHAR, DT_STR, "PID.5" },
{ 0x0010, 0x0020, "PatientID", 64, SQL_C_CHAR, DT_STR, "PID.2" },
{ 0x0010, 0x1000, "OtherPatientID", 64, SQL_C_CHAR, DT_STR, "PID.3" },
{ 0x0010, 0x0030, "PatientBirthDate", 8, SQL_C_DATE, DT_DATE, "PID.7" },
{ 0x0010, 0x0040, "PatientSex", 16, SQL_C_CHAR, DT_STR, "PID.8" },
{ 0x0010, 0x1010, "PatientsAge", 16, SQL_C_CHAR, DT_STR, "PID.9" },
{ 0x0010, 0x2154, "PatientPhone", 40, SQL_C_CHAR, DT_STR, "PID.13" },
{ 0x0008, 0x0050, "AccessionNumber", 16, SQL_C_CHAR, DT_STR, "OBR.3" },
{ 0x0040, 0x0009, "SchedPSID", 16, SQL_C_CHAR, DT_STR, "OBR.4" },
{ 0x0040, 0x1001, "ReqProcID", 16, SQL_C_CHAR, DT_STR, "OBR.31" },
{ 0x0032, 0x1060, "ReqProcDescription", 64, 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" },
{ 0x0008, 0x0060, "Modality", 16, SQL_C_CHAR, DT_STR, "OBR.21" },
{ 0x0032, 0x1032, "ReqPhysician", 64, SQL_C_CHAR, DT_STR, "OBR.16" },
{ 0x0040, 0x0001, "ScheduledAE", 16, SQL_C_CHAR, DT_STR, "OBR.19" },
{ 0x0040, 0x0010, "SchedStationName", 16, SQL_C_CHAR, DT_STR, "OBR.24" },
{ 0x0040, 0x0400, "SchedPSComments", 64, SQL_C_CHAR, DT_STR, "OBR.36" },
{ 0x0008, 0x1030, "StudyDescription", 64, SQL_C_CHAR, DT_STR, "MSH.18" },
{ 0x0008, 0x0005, "SpecificChar", 16, SQL_C_CHAR, DT_STR, "MSH.20" },
{ 0x0008, 0x0090, "ReqPhyNames", 64, SQL_C_CHAR, DT_STR, "PV1.8" },
{ 0x0020, 0x000d, "StudyInstanceUID", 64, SQL_C_CHAR, DT_UI, "---" },
{ 0x0040, 0x0006, "PerfPhysician", 64, SQL_C_CHAR, DT_STR, "---" },
{ 0x0040, 0x0007, "SchedPSDescription", 64, SQL_C_CHAR, DT_STR, "---" },
{ 0x0040, 0x1003, "ReqProcPriority", 16, SQL_C_CHAR, DT_STR, "OBR.27" }
}
almost all data are inside
this is my conquest log after import hl7 file
------------ Adding image files to server -----------
[LUKASZC] HL7 item: MSH.0, contents: MSH
[LUKASZC] HL7 item: MSH.1, contents: ^~\&
[LUKASZC] HL7 item: MSH.1.0, contents:
[LUKASZC] HL7 item: MSH.1.1, contents:
[LUKASZC] HL7 item: MSH.1.2, contents: \&
[LUKASZC] HL7 item: MSH.1.END, contents:
[LUKASZC] HL7 item: MSH.2, contents: wsz
[LUKASZC] HL7 item: MSH.3, contents: wsz
[LUKASZC] HL7 item: MSH.4, contents: lukaszc
[LUKASZC] HL7 item: MSH.5, contents: lukaszc
[LUKASZC] HL7 item: MSH.6, contents: 201404301100
[LUKASZC] HL7 item: MSH.6.DATE, contents: 20140430
[LUKASZC] HL7 item: MSH.6.TIME, contents: 1100
[LUKASZC] HL7 item: MSH.7, contents:
[LUKASZC] HL7 item: MSH.8, contents: ORM^001
[LUKASZC] HL7 item: MSH.8.0, contents: ORM
[LUKASZC] HL7 item: MSH.8.1, contents: 001
[LUKASZC] HL7 item: MSH.8.END, contents:
[LUKASZC] HL7 item: MSH.9, contents: 1
[LUKASZC] HL7 item: MSH.10, contents: P
[LUKASZC] HL7 item: MSH.11, contents: 2.0.0
[LUKASZC] HL7 item: MSH.12, contents:
[LUKASZC] HL7 item: MSH.13, contents:
[LUKASZC] HL7 item: MSH.14, contents:
[LUKASZC] HL7 item: MSH.15, contents:
[LUKASZC] HL7 item: MSH.16, contents:
[LUKASZC] HL7 item: MSH.17, contents:
[LUKASZC] HL7 item: MSH.18, contents: badanie klatki
[LUKASZC] HL7 item: MSH.19, contents: ISO_IR_101
[LUKASZC] HL7 item: EOS, contents:
[LUKASZC] HL7 item: PID.0, contents: PID_IR_101
[LUKASZC] HL7 item: PID.1, contents: 82042514
[LUKASZC] HL7 item: PID.2, contents: 1
[LUKASZC] HL7 item: PID.3, contents: 82042514
[LUKASZC] HL7 item: PID.4, contents: 82042514
[LUKASZC] HL7 item: PID.5, contents: Nxxxxx Pxxxxxx
[LUKASZC] HL7 item: PID.6, contents:
[LUKASZC] HL7 item: PID.7, contents: 19820425
[LUKASZC] HL7 item: PID.7.DATE, contents: 19820425
[LUKASZC] HL7 item: PID.7.TIME, contents:
[LUKASZC] HL7 item: PID.8, contents: M
[LUKASZC] HL7 item: PID.9, contents: 32Y
[LUKASZC] HL7 item: PID.10, contents: 111
[LUKASZC] HL7 item: PID.11, contents: 186
[LUKASZC] HL7 item: PID.12, contents: POL
[LUKASZC] HL7 item: PID.13, contents: 111222333
[LUKASZC] HL7 item: PID.14, contents: 5
[LUKASZC] HL7 item: PID.15, contents: polski
[LUKASZC] HL7 item: PID.16, contents: v
[LUKASZC] HL7 item: PID.17, contents: mazowieckie
[LUKASZC] HL7 item: PID.18, contents: 123123123123
[LUKASZC] HL7 item: PID.19, contents: n
[LUKASZC] HL7 item: PID.20, contents: 321321321321
[LUKASZC] HL7 item: PID.21, contents:
[LUKASZC] HL7 item: PID.22, contents: WHE
[LUKASZC] HL7 item: PID.23, contents:
[LUKASZC] HL7 item: PID.24, contents:
[LUKASZC] HL7 item: PID.25, contents:
[LUKASZC] HL7 item: PID.26, contents:
[LUKASZC] HL7 item: EOS, contents:
[LUKASZC] HL7 item: PV1.0, contents: PV1
[LUKASZC] HL7 item: PV1.1, contents:
[LUKASZC] HL7 item: PV1.2, contents:
[LUKASZC] HL7 item: PV1.3, contents:
[LUKASZC] HL7 item: PV1.4, contents:
[LUKASZC] HL7 item: PV1.5, contents:
[LUKASZC] HL7 item: PV1.6, contents:
[LUKASZC] HL7 item: PV1.7, contents:
[LUKASZC] HL7 item: PV1.8, contents:
[LUKASZC] HL7 item: PV1.9, contents:
[LUKASZC] HL7 item: PV1.10, contents:
[LUKASZC] HL7 item: PV1.11, contents:
[LUKASZC] HL7 item: PV1.12, contents:
[LUKASZC] HL7 item: PV1.13, contents:
[LUKASZC] HL7 item: PV1.14, contents:
[LUKASZC] HL7 item: PV1.15, contents: 1
[LUKASZC] HL7 item: PV1.16, contents:
[LUKASZC] HL7 item: PV1.17, contents:
[LUKASZC] HL7 item: PV1.18, contents:
[LUKASZC] HL7 item: PV1.19, contents:
[LUKASZC] HL7 item: PV1.20, contents:
[LUKASZC] HL7 item: PV1.21, contents:
[LUKASZC] HL7 item: PV1.22, contents:
[LUKASZC] HL7 item: PV1.23, contents:
[LUKASZC] HL7 item: EOS, contents:
[LUKASZC] HL7 item: ORC.0, contents: ORC
[LUKASZC] HL7 item: ORC.1, contents:
[LUKASZC] HL7 item: ORC.2, contents:
[LUKASZC] HL7 item: ORC.3, contents: 82042514
[LUKASZC] HL7 item: ORC.4, contents:
[LUKASZC] HL7 item: ORC.5, contents:
[LUKASZC] HL7 item: ORC.6, contents:
[LUKASZC] HL7 item: ORC.7, contents:
[LUKASZC] HL7 item: ORC.8, contents:
[LUKASZC] HL7 item: ORC.9, contents: 201404301100
[LUKASZC] HL7 item: ORC.9.DATE, contents: 20140430
[LUKASZC] HL7 item: ORC.9.TIME, contents: 1100
[LUKASZC] HL7 item: ORC.10, contents:
[LUKASZC] HL7 item: ORC.11, contents:
[LUKASZC] HL7 item: ORC.12, contents:
[LUKASZC] HL7 item: ORC.13, contents:
[LUKASZC] HL7 item: ORC.14, contents:
[LUKASZC] HL7 item: ORC.15, contents: 201404301100529400
[LUKASZC] HL7 item: ORC.15.DATE, contents: 20140430
[LUKASZC] HL7 item: ORC.15.TIME, contents: 1100529400
[LUKASZC] HL7 item: EOS, contents:
[LUKASZC] HL7 item: OBR.0, contents: OBR0529400
[LUKASZC] HL7 item: OBR.1, contents:
[LUKASZC] HL7 item: OBR.2, contents:
[LUKASZC] HL7 item: OBR.3, contents: 1
[LUKASZC] HL7 item: OBR.4, contents:
[LUKASZC] HL7 item: OBR.5, contents:
[LUKASZC] HL7 item: OBR.6, contents: 201404301100529400
[LUKASZC] HL7 item: OBR.6.DATE, contents: 20140430
[LUKASZC] HL7 item: OBR.6.TIME, contents: 1100529400
[LUKASZC] HL7 item: OBR.7, contents: 2014043010111524
[LUKASZC] HL7 item: OBR.7.DATE, contents: 20140430
[LUKASZC] HL7 item: OBR.7.TIME, contents: 10111524
[LUKASZC] HL7 item: OBR.8, contents: 100131
[LUKASZC] HL7 item: OBR.8.DATE, contents: 100131
[LUKASZC] HL7 item: OBR.8.TIME, contents:
[LUKASZC] HL7 item: OBR.9, contents:
[LUKASZC] HL7 item: OBR.10, contents:
[LUKASZC] HL7 item: OBR.11, contents:
[LUKASZC] HL7 item: OBR.12, contents:
[LUKASZC] HL7 item: OBR.13, contents:
[LUKASZC] HL7 item: OBR.14, contents:
[LUKASZC] HL7 item: OBR.15, contents:
[LUKASZC] HL7 item: OBR.16, contents: Kijoch
[LUKASZC] HL7 item: OBR.17, contents:
[LUKASZC] HL7 item: OBR.18, contents:
[LUKASZC] HL7 item: OBR.19, contents: crlcl2
[LUKASZC] HL7 item: OBR.20, contents: 1.2.826.0.1.9876.2.404.20051230.2313529400
[LUKASZC] HL7 item: OBR.21, contents: CR
[LUKASZC] HL7 item: OBR.22, contents:
[LUKASZC] HL7 item: OBR.22.DATE, contents:
[LUKASZC] HL7 item: OBR.22.TIME, contents:
[LUKASZC] HL7 item: OBR.23, contents:
[LUKASZC] HL7 item: OBR.24, contents: crlcl2
[LUKASZC] HL7 item: OBR.25, contents:
[LUKASZC] HL7 item: OBR.26, contents:
[LUKASZC] HL7 item: OBR.27, contents: ReqProcPriority27
[LUKASZC] HL7 item: OBR.28, contents:
[LUKASZC] HL7 item: OBR.29, contents:
[LUKASZC] HL7 item: OBR.30, contents:
[LUKASZC] HL7 item: OBR.31, contents: 88 dupa
[LUKASZC] HL7 item: OBR.32, contents:
[LUKASZC] HL7 item: EOS, contents:
[LUKASZC] HL7 item: EOS, contents:
[LUKASZC] HL7 item: EOM, contents:
[LUKASZC] Entering modality worklist fields: SpecificCh,PatientID,OtherPatie,PatientNam,PatientBir,PatientSex,PatientsAg,PatientPho,AccessionN,SchedPSID,StartDate,StartTime,ReqPhysici,ScheduledA,Modality,SchedStati,ReqProcPri
[LUKASZC] [AddImageFile] loaded HL7 file: E:\dicomserver1417\sample.hl7
when i tray to get modality worklist on CR console i get whose errors:
[LUKASZC] UPACS THREAD 194: STARTED AT: Wed Apr 30 14:47:14 2014
[LUKASZC] A-ASSOCIATE-RQ Packet Dump
[LUKASZC] Calling Application Title : "CRLCL2 "
[LUKASZC] Called Application Title : "LUKASZC "
[LUKASZC] Application Context : "1.2.840.10008.3.1.1.1", PDU length: 32768
[LUKASZC] Number of Proposed Presentation Contexts: 1
[LUKASZC] Presentation Context 0 "1.2.840.10008.5.1.4.31" 1
[LUKASZC] Server Command := 0020
[LUKASZC] Message ID := 0083
[LUKASZC] (ModalityWorkListQuery) search level:
[LUKASZC] Query On Modality WorkList
[LUKASZC] Queried item 0008 1030 is not in the database
[LUKASZC] Queried item 0008 1150 is not in the database
[LUKASZC] Queried item 0008 1155 is not in the database
[LUKASZC] Queried item 0008 1150 is not in the database
[LUKASZC] Queried item 0008 1155 is not in the database
[LUKASZC] Queried item 0009 0010 is not in the database
[LUKASZC] Queried item 0009 1090 is not in the database
[LUKASZC] Queried item 0010 2160 is not in the database
[LUKASZC] Queried item 0010 21b0 is not in the database
[LUKASZC] Queried item 0010 21c0 is not in the database
[LUKASZC] Queried item 0010 4000 is not in the database
[LUKASZC] Queried item 0020 0010 is not in the database
[LUKASZC] Queried item 0032 1033 is not in the database
[LUKASZC] Queried item 0008 0100 is not in the database
[LUKASZC] Queried item 0008 0102 is not in the database
[LUKASZC] Queried item 0008 0103 is not in the database
[LUKASZC] Queried item 0008 0104 is not in the database
[LUKASZC] Queried item 0038 0500 is not in the database
[LUKASZC] Queried item 0008 0100 is not in the database
[LUKASZC] Queried item 0008 0102 is not in the database
[LUKASZC] Queried item 0008 0103 is not in the database
[LUKASZC] Queried item 0008 0104 is not in the database
[LUKASZC] Queried item 0040 1010 is not in the database
[LUKASZC] Queried item 0040 2009 is not in the database
[LUKASZC] Queried item 2000 0010 is not in the database
[LUKASZC] Issue Query on Columns: DICOMWorkList.SpecificCh, DICOMWorkList.AccessionN, DICOMWorkList.ReqPhyName, DICOMWorkList.PatientNam, DICOMWorkList.PatientID, DICOMWorkList.PatientBir, DICOMWorkList.PatientSex, DICOMWorkList.OtherPatie, DICOMWorkList.StudyInsta, DICOMWorkList.ReqPhysici, DICOMWorkList.ReqProcDes, DICOMWorkList.Modality, DICOMWorkList.ScheduledA, DICOMWorkList.StartDate, DICOMWorkList.StartTime, DICOMWorkList.PerfPhysic, DICOMWorkList.SchedPSDes, DICOMWorkList.SchedPSID, DICOMWorkList.ReqProcID
[LUKASZC] Values: DICOMWorkList.SpecificCh = E'ISO_IR 101' and DICOMWorkList.Modality = E'CR' and DICOMWorkList.ScheduledA = E'CRLCL2' and DICOMWorkList.StartDate = E'20140430'
[LUKASZC] Tables: DICOMWorkList
[LUKASZC] Sorting (DICOMWorkList.PatientNam) DoSort := 1
[LUKASZC] Records = 0
[LUKASZC] C-Find (Modality Work List) located 0 records
[LUKASZC] UPACS THREAD 194: ENDED AT: Wed Apr 30 14:47:14 2014
[LUKASZC] UPACS THREAD 194: TOTAL RUNNING TIME: 0 SECONDS
I use tags from this dicom conformance statement for FUJI CR CONSOLE
https://www.fujifilmusa.com/pr…s/pdf/index/fcr_dicom.pdf
Thanks for any suggestions