Thanks Marcel Im gonna try that solution. And post the results.
Posts by Belenlller
-
-
Yes, I was unable to make CT Work whit the Worklist.
-
Code[WL] 0032,1032 20 PN RequestingPhysician "RODRIGUEZ^ALEJANDRO " [WL] 0032,1060 40 LO RequestedProcedureDe "TOMOGRAFIA AXIAL C. DE ABDOMEN INFERIOR " [WL] Coding sequence (0032,1064), level=1[WL] 0040,0001 6 AE ScheduledStationAETi "ECLOS " [WL] 0040,0002 8 DA ScheduledProcedureSt "20200810" [WL] 0040,0003 6 TM ScheduledProcedureSt "173000" [WL] 0040,0006 20 PN ScheduledPerformingP "RODRIGUEZ^ALEJANDRO " [WL] 0040,0007 0 LO ScheduledProcedureSt (empty)[WL] 0008,0005 10 CS SpecificCharacterSet "ISO_IR 100" [WL] 0008,0050 4 SH AccessionNumber "6023" [WL] 0008,0082 0 SQ InstitutionCodeSeque Sequence Item[WL] 0010,0010 26 PN PatientName "xxxx" [WL] 0010,0020 10 LO PatientID "xxxx " [WL] 0010,0030 8 DA PatientBirthDate "xxxx" [WL] 0010,0040 2 CS PatientSex "F " [WL] 0010,0050 0 SQ PatientInsurancePlan Sequence Item[WL] 0032,1032 20 PN RequestingPhysician "RODRIGUEZ^ALEJANDRO " [WL] 0032,1060 40 LO RequestedProcedureDe "TOMOGRAFIA AXIAL C. DE ABDOMEN INFERIOR " [WL] 0032,1064 0 SQ RequestedProcedureCo Sequence Item
-
Code[WL] Issue Query on Columns: DICOMWorkList.AccessionN, DICOMWorkList.RPCSCodeVa, DICOMWorkList.RPCSCodeSc, DICOMWorkList.RPCSCodeMe, DICOMWorkList.ReferringP, DICOMWorkList.RPCSCodeVa, DICOMWorkList.RPCSCodeSc, DICOMWorkList.RPCSCodeMe, DICOMWorkList.PatientNam, DICOMWorkList.PatientID, DICOMWorkList.PatientBir, DICOMWorkList.PatientSex, DICOMWorkList.RPCSCodeVa, DICOMWorkList.RPCSCodeSc, DICOMWorkList.RPCSCodeMe, DICOMWorkList.PatientsAg, DICOMWorkList.MedicalAle, DICOMWorkList.ContrastAl, DICOMWorkList.StudyInsta, DICOMWorkList.ReqPhysici, DICOMWorkList.ReqProcDes, DICOMWorkList.RPCSCodeVa, DICOMWorkList.RPCSCodeSc, DICOMWorkList.RPCSCodeMe, DICOMWorkList.Modality, DICOMWorkList.ReqContras, DICOMWorkList.ScheduledA, DICOMWorkList.StartDate, DICOMWorkList.StartTime, DICOMWorkList.PerfPhysic, DICOMWorkList.SchedPSDes, DICOMWorkList.RPCSCodeVa, DICOMWorkList.RPCSCodeSc, DICOMWorkList.RPCSCodeMe, DICOMWorkList.SchedPSID, DICOMWorkList.SchedStati, DICOMWorkList.SchedPSLoc, DICOMWorkList.PreMedicat, DICOMWorkList.SchedPSCom, DICOMWorkList.ReqProcID, DICOMWorkList.ReqProcPri[WL] Values: DICOMWorkList.Modality = 'CT' and DICOMWorkList.ScheduledA = 'ECLOS' and DICOMWorkList.StartDate >= '20200810' and DICOMWorkList.StartDate <= '20200810'[WL] Columns : DICOMWorkList.AccessionN, DICOMWorkList.RPCSCodeVa, DICOMWorkList.RPCSCodeSc, DICOMWorkList.RPCSCodeMe, DICOMWorkList.ReferringP, DICOMWorkList.RPCSCodeVa, DICOMWorkList.RPCSCodeSc, DICOMWorkList.RPCSCodeMe, DICOMWorkList.PatientNam, DICOMWorkList.PatientID, DICOMWorkList.PatientBir, DICOMWorkList.PatientSex, DICOMWorkList.RPCSCodeVa, DICOMWorkList.RPCSCodeSc, DICOMWorkList.RPCSCodeMe, DICOMWorkList.PatientsAg, DICOMWorkList.MedicalAle, DICOMWorkList.ContrastAl, DICOMWorkList.StudyInsta, DICOMWorkList.ReqPhysici, DICOMWorkList.ReqProcDes, DICOMWorkList.RPCSCodeVa, DICOMWorkList.RPCSCodeSc, DICOMWorkList.RPCSCodeMe, DICOMWorkList.Modality, DICOMWorkList.ReqContras, DICOMWorkList.ScheduledA, DICOMWorkList.StartDate, DICOMWorkList.StartTime, DICOMWorkList.PerfPhysic, DICOMWorkList.SchedPSDes, DICOMWorkList.RPCSCodeVa, DICOMWorkList.RPCSCodeSc, DICOMWorkList.RPCSCodeMe, DICOMWorkList.SchedPSID, DICOMWorkList.SchedStati, DICOMWorkList.SchedPSLoc, DICOMWorkList.PreMedicat, DICOMWorkList.Sche
-
CT SCAN Not Working I Get this
Code -
But Fluro Works Know, I Add the folow Columns on de dicom.sql
*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, 0x1010, "PatientsAge", 16, SQL_C_CHAR, DT_STR, "PID.9" },
{ 0x0008, 0x0090, "ReferringPhysician", 64, SQL_C_CHAR, DT_STR, "---" }
{ 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" },
{ 0x0032, 0x1064, "--------", 0, SQL_C_CHAR, DT_STARTSEQUENCE, "---" },
{ 0x0008, 0x0100, "RPCSCodeValue", 8, SQL_C_CHAR, DT_STR, "---" },
{ 0x0008, 0x0102, "RPCSCodeScheme", 8, SQL_C_CHAR, DT_STR, "---" },
{ 0x0008, 0x0104, "RPCSCodeMeaning", 8, SQL_C_CHAR, DT_STR, "---" },
{ 0x0032, 0x1064, "--------", 0, SQL_C_CHAR, DT_ENDSEQUENCE, "---" },
{ 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, 0x0008, "--------", 0, SQL_C_CHAR, DT_STARTSEQUENCE, "---" },
{ 0x0008, 0x0100, "SPCSCodeValue", 8, SQL_C_CHAR, DT_STR, "---" },
{ 0x0008, 0x0102, "SPCSCodeScheme", 8, SQL_C_CHAR, DT_STR, "---" },
{ 0x0008, 0x0104, "SPCSCodeMeaning", 8, SQL_C_CHAR, DT_STR, "---" },
{ 0x0040, 0x0008, "--------", 0, SQL_C_CHAR, DT_ENDSEQUENCE, "---" },
{ 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" }
}
-
When the fluro asks the Workliste this comes out in the Log
[WL] UPACS THREAD 303: STARTED AT: Wed Aug 05 11:52:05 2020
[WL] A-ASSOCIATE-RQ Packet Dump
[WL] Calling Application Title : "FLURO "
[WL] Called Application Title : "WL "
[WL] Application Context : "1.2.840.10008.3.1.1.1", PDU length: 16384
[WL] Number of Proposed Presentation Contexts: 1
[WL] Presentation Context 0 "1.2.840.10008.5.1.4.31" 1
[WL] Server Command := 0020
[WL] Message ID := 000f
[WL] 0000,0002 22 UI AffectedSOPClassUID "1.2.840.10008.5.1.4.31"
[WL] 0000,0100 2 US CommandField 32
[WL] 0000,0110 2 US MessageID 15
[WL] 0000,0700 2 US Priority 0
[WL] 0000,0800 2 US DataSetType 258
[WL] 0002,0010 17 UI TransferSyntaxUID "1.2.840.10008.1.2"
[WL] (ModalityWorkListQuery) search level:
[WL] 0002,0010 17 UI TransferSyntaxUID "1.2.840.10008.1.2"
[WL] 0008,0050 0 SH AccessionNumber (empty)
[WL] 0008,0090 0 PN ReferringPhysicianNa (empty)
[WL] 0008,1110 0 SQ ReferencedStudySeque Sequence Item
[WL] >0008,1150 0 UI ReferencedSOPClassUI (empty)
[WL] >0008,1155 0 UI ReferencedSOPInstanc (empty)
[WL] 0008,1120 0 SQ ReferencedPatientSeq Sequence Item
[WL] >0008,1150 0 UI ReferencedSOPClassUI (empty)
[WL] >0008,1155 0 UI ReferencedSOPInstanc (empty)
[WL] 0010,0010 0 PN PatientName (empty)
[WL] 0010,0020 0 LO PatientID (empty)
[WL] 0010,0030 0 DA PatientBirthDate (empty)
[WL] 0010,0040 0 CS PatientSex (empty)
[WL] 0010,1030 0 DS PatientWeight (empty)
[WL] 0010,2000 0 LO MedicalAlerts (empty)
[WL] 0010,2110 0 LO Allergies (empty)
[WL] 0010,21c0 0 US PregnancyStatus (empty)
[WL] 0020,000d 0 UI StudyInstanceUID (empty)
[WL] 0032,1032 0 PN RequestingPhysician (empty)
[WL] 0032,1060 0 LO RequestedProcedureDe (empty)
[WL] 0032,1064 0 SQ RequestedProcedureCo Sequence Item
[WL] 0038,0010 0 LO AdmissionID (empty)
[WL] 0038,0050 0 LO SpecialNeeds (empty)
[WL] 0038,0300 0 LO CurrentPatientLocati (empty)
[WL] 0038,0500 0 LO PatientState (empty)
[WL] 0040,0100 0 SQ ScheduledProcedureSt Sequence Item
[WL] >0008,0060 0 CS Modality (empty)
[WL] >0040,0001 6 AE ScheduledStationAETi "FLURO "
[WL] >0040,0002 18 DA ScheduledProcedureSt "20200805-20200805 "
[WL] >0040,0003 0 TM ScheduledProcedureSt (empty)
[WL] >0040,0006 0 PN ScheduledPerformingP (empty)
[WL] >0040,0007 0 LO ScheduledProcedureSt (empty)
[WL] >0040,0008 0 SQ ScheduledProtocolCod Sequence Item
[WL] >0040,0009 0 SH ScheduledProcedureSt (empty)
[WL] >0040,0010 0 SH ScheduledStationName (empty)
[WL] >0040,0011 0 SH ScheduledProcedureSt (empty)
[WL] >0040,0020 0 CS ScheduledProcedureSt (empty)
[WL] 0040,1001 0 SH RequestedProcedureID (empty)
[WL] 0040,1003 0 SH RequestedProcedurePr (empty)
[WL] 0040,1004 0 LO PatientTransportArra (empty)
[WL] 0040,3001 0 LO ConfidentialityConst (empty)
[WL] Query On Modality WorkList
[WL] Queried item 0008 0090 is not in the database
[WL] Queried item 0008 1150 is not in the database
[WL] Queried item 0008 1155 is not in the database
[WL] Queried item 0008 1150 is not in the database
[WL] Queried item 0008 1155 is not in the database
[WL] Queried item 0010 1030 is not in the database
[WL] Queried item 0010 21c0 is not in the database
[WL] Queried item 0032 1064 is not in the database
[WL] Queried item 0038 0010 is not in the database
[WL] Queried item 0038 0050 is not in the database
[WL] Queried item 0038 0300 is not in the database
[WL] Queried item 0038 0500 is not in the database
[WL] Queried item 0040 0008 is not in the database
[WL] Queried item 0040 0020 is not in the database
[WL] Queried item 0040 1004 is not in the database
[WL] Queried item 0040 3001 is not in the database
[WL] 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.Modality, DICOMWorkList.ScheduledA, DICOMWorkList.StartDate, DICOMWorkList.StartTime, DICOMWorkList.PerfPhysic, DICOMWorkList.SchedPSDes, DICOMWorkList.SchedPSID, DICOMWorkList.SchedStati, DICOMWorkList.SchedPSLoc, DICOMWorkList.ReqProcID, DICOMWorkList.ReqProcPri
[WL] Values: DICOMWorkList.ScheduledA = 'FLURO' and DICOMWorkList.StartDate >= '20200805' and DICOMWorkList.StartDate <= '20200805'
[WL] Tables: DICOMWorkList
[WL] Sorting (DICOMWorkList.PatientNam) DoSort := 1
[WL] 0008,0050 4 SH AccessionNumber "1000"
[WL] Coding sequence (0008,1110), level=1
[WL] (sequence is empty)
[WL] Coding sequence (0008,1120), level=1
[WL] (sequence is empty)
[WL] 0010,0010 16 PN PatientName "Gustavo^Morales "
[WL] 0010,0020 10 LO PatientID "000001c01 "
[WL] 0010,0030 8 DA PatientBirthDate "19840308"
[WL] 0010,0040 2 CS PatientSex "M "
[WL] 0010,2000 2 LO MedicalAlerts "- "
[WL] 0010,2110 2 LO Allergies "- "
[WL] 0020,000d 0 UI StudyInstanceUID (empty)
[WL] 0032,1032 2 PN RequestingPhysician "- "
[WL] 0032,1060 22 LO RequestedProcedureDe "Fluroscopia Estomacal "
[WL] Coding sequence (0040,0100), level=1
[WL] 0008,0060 2 CS Modality "XA"
[WL] 0040,0001 6 AE ScheduledStationAETi "FLURO "
[WL] 0040,0002 8 DA ScheduledProcedureSt "20200805"
[WL] 0040,0003 6 TM ScheduledProcedureSt "131010"
[WL] 0040,0006 2 PN ScheduledPerformingP "- "
[WL] 0040,0007 2 LO ScheduledProcedureSt "- "
[WL] 0040,0009 0 SH ScheduledProcedureSt (empty)
[WL] 0040,0010 6 SH ScheduledStationName "FLURO "
[WL] 0040,0011 6 SH ScheduledProcedureSt "FLURO "
[WL] 0040,1001 0 SH RequestedProcedureID (empty)
[WL] 0040,1003 0 SH RequestedProcedurePr (empty)
[WL] Records = 1
[WL] First record of cleaned response:
[WL] 0008,0005 10 CS SpecificCharacterSet "ISO_IR 100"
[WL] 0008,0050 4 SH AccessionNumber "1000"
[WL] 0008,1110 0 SQ ReferencedStudySeque Sequence Item
[WL] 0008,1120 0 SQ ReferencedPatientSeq Sequence Item
[WL] 0010,0010 16 PN PatientName "Gustavo^Morales "
[WL] 0010,0020 10 LO PatientID "000001c01 "
[WL] 0010,0030 8 DA PatientBirthDate "19840308"
[WL] 0010,0040 2 CS PatientSex "M "
[WL] 0010,2000 2 LO MedicalAlerts "- "
[WL] 0010,2110 2 LO Allergies "- "
[WL] 0020,000d 0 UI StudyInstanceUID (empty)
[WL] 0032,1032 2 PN RequestingPhysician "- "
[WL] 0032,1060 22 LO RequestedProcedureDe "Fluroscopia Estomacal "
[WL] 0040,0100 0 SQ ScheduledProcedureSt Sequence Item
[WL] >0008,0060 2 CS Modality "XA"
[WL] >0040,0001 6 AE ScheduledStationAETi "FLURO "
[WL] >0040,0002 8 DA ScheduledProcedureSt "20200805"
[WL] >0040,0003 6 TM ScheduledProcedureSt "131010"
[WL] >0040,0006 2 PN ScheduledPerformingP "- "
[WL] >0040,0007 2 LO ScheduledProcedureSt "- "
[WL] >0040,0009 0 SH ScheduledProcedureSt (empty)
[WL] >0040,0010 6 SH ScheduledStationName "FLURO "
[WL] >0040,0011 6 SH ScheduledProcedureSt "FLURO "
[WL] 0040,1001 0 SH RequestedProcedureID (empty)
[WL] 0040,1003 0 SH RequestedProcedurePr (empty)
[WL] C-Find (Modality Work List) located 1 records
[WL] UPACS THREAD 303: ENDED AT: Wed Aug 05 11:52:05 2020
[WL] UPACS THREAD 303: TOTAL RUNNING TIME: 0 SECONDS
-
Hello, I have been studying and working a lot with conquest in the last 3 months and we have made good progress by making a Worklist that sends different data to different devices, of which we have:
- 3 Ultrasound (US)
- 2 X-Ray (DX)
- 1 Mastyography (MG)
- 1 Magnetic Resonance (RM)
- 1 Panoramic Dental (CR)
- 1 Tomography (CT)
- 1 Fluoroscopy (XA)
Most devices are receiving the Worklist data well. Except for the fluoroscopy device and the tomography device. And to be honest I don't know how to solve the problem with those 2 devices.
To make the Worklist data, I use insert in through MySQL Worklist Table. Since the clinical system is the way in which I can send the information to Conquest. I Want to share the data that Works in
each case of the modalities that I mention.
AccessionN
AccessTime
ContrastAl
MedicalAle
Modality
PatientBir
PatientID
PatientNam
PatientSex
PerfPhysic
PreMedicat
qFlags
qSpare
qTimeStamp
ReqContras
ReqPhysici
ReqProcDes
ReqProcID
ReqProcPri
SchedPSCom
SchedPSDes
SchedPSID
SchedPSLoc
SchedStati
ScheduledA
StartDate
StartTime
StudyInsta
3301
US
19470824
034935c02
Patien Name
F
CORTES^OSCAR
CORTES^OSCAR
SONOGRAFIA ABDOMINAL (SUPERIOR)
20200711
091500
3302
US
19470824
034935c02
Patien Name
F
CORTES^OSCAR
CORTES^OSCAR
SONOGRAFIA PELVICA
20200711
093000
This data works in all 3 Ultrasound.
AccessionN
AccessTime
ContrastAl
MedicalAle
Modality
PatientBir
PatientID
PatientNam
PatientSex
PerfPhysic
PreMedicat
qFlags
qSpare
qTimeStamp
ReqContras
ReqPhysici
ReqProcDes
ReqProcID
ReqProcPri
SchedPSCom
SchedPSDes
SchedPSID
SchedPSLoc
SchedStati
ScheduledA
StartDate
StartTime
StudyInsta
3327
DX
20100804
103883c06
Patient Name
F
CARA PERFILOGRAMA LATERAL AP
20200711
022500
This data works in all 2 X-Ray.
AccessionN
AccessTime
ContrastAl
MedicalAle
Modality
PatientBir
PatientID
PatientNam
PatientSex
PerfPhysic
PreMedicat
qFlags
qSpare
qTimeStamp
ReqContras
ReqPhysici
ReqProcDes
ReqProcID
ReqProcPri
SchedPSCom
SchedPSDes
SchedPSID
SchedPSLoc
SchedStati
ScheduledA
StartDate
StartTime
StudyInsta
5249
MG
19530602
077145c01
CARRILLO VELASCO^LEONOR
F
CHIQUITO^MYRNA CECILIA
CHIQUITO^MYRNA CECILIA
MAMOGRAFIA CON SONOGRAFIA
20200731
094500
This Works on the Mastyography
AccessionN
AccessTime
ContrastAl
MedicalAle
Modality
PatientBir
PatientID
PatientNam
PatientSex
PerfPhysic
PreMedicat
qFlags
qSpare
qTimeStamp
ReqContras
ReqPhysici
ReqProcDes
ReqProcID
ReqProcPri
SchedPSCom
SchedPSDes
SchedPSID
SchedPSLoc
SchedStati
ScheduledA
StartDate
StartTime
StudyInsta
3297
MR
19570128
024416c01
SAENZ DOMINGUEZ^JULIETA MARIA
F
DIAZ^BLANCA ESTHELA
DIAZ^BLANCA ESTHELA
RESONANCIA DE COLUMNA LUMBAR
WL
20200711
100200
This Works on the Magnetic Resonance
AccessionN
AccessTime
ContrastAl
MedicalAle
Modality
PatientBir
PatientID
PatientNam
PatientSex
PerfPhysic
PreMedicat
qFlags
qSpare
qTimeStamp
ReqContras
ReqPhysici
ReqProcDes
ReqProcID
ReqProcPri
SchedPSCom
SchedPSDes
SchedPSID
SchedPSLoc
SchedStati
ScheduledA
StartDate
StartTime
StudyInsta
3588
CR
19860306
128871c01
LEON ADRIANO^CYNTHIA GUADALUPE
F
PANORAMICA (ORTHOPANTOGRAFIA)
WL
20200714
052600
This Works on the Panoramic Dental
But I cannot make the information visible on the tomography and on the fluoroscope.
On CT I Use this
AccessionN
AccessTime
ContrastAl
MedicalAle
Modality
PatientBir
PatientID
PatientNam
PatientSex
PerfPhysic
PreMedicat
qFlags
qSpare
qTimeStamp
ReqContras
ReqPhysici
ReqProcDes
ReqProcID
ReqProcPri
SchedPSCom
SchedPSDes
SchedPSID
SchedPSLoc
SchedStati
ScheduledA
StartDate
StartTime
StudyInsta
3337
190001
CT
19310830
003120c02
FIGUEROA BENCOMO^ALICIA
F
190001
ABDOMEN AP DECUBITO (SIMPLE DE ABDOMEN)
WL
20200712
190000
I have tried to enter different values. But at the moment I put ScheduledA without value, the computer shows a successful connection.
But when I put the WL value it gives me errors, some saying syntax error and others saying that NULL values are not accepted. Also the same problem on 1 Fluoroscopy (XA)
This is my Dicom.ini
# This file contains configuration information for the DICOM server
# Do not edit unless you know what you are doing
[sscscp]
MicroPACS = sscscp
# Network configuration: server name and TCP/IP port#
MyACRNema = Wl
TCPPort = 104
# Host, database, username and password for database
SQLHost = localhost
SQLServer = conquest
Username = root
Password = 112233Az@
MySql = 1
DoubleBackSlashToDB = 1
UseEscapeStringConstants = 0
# Configure server
ImportExportDragAndDrop = 1
ZipTime = 05:
UIDPrefix = 1.2.826.0.1.3680043.2.135.737598.53612758
EnableComputedFields = 1
EnableReadAheadThread = 1
PatientQuerySortOrder =
StudyQuerySortOrder =
SeriesQuerySortOrder =
ImageQuerySortOrder =
EnableComputedFields = 1
IndexDBF = 1
PackDBF = 0
LongQueryDBF = 1000
TCPIPTimeOut = 300
FailHoldOff = 60
RetryDelay = 100
RetryForwardFailed = 0
ImportExportDragAndDrop = 0
QueueSize = 128
WorkListMode = 1
WorkListReturnsISO_IR_100 = 1
DebugLevel = 5
Prefetcher = 0
LRUSort =
AllowTruncate =
DecompressNon16BitsJpeg = 1
UseBuiltInDecompressor = 1
IgnoreOutOfMemoryErrors = 0
PadAEWithZeros = 0
FileNameSyntax = 4
# Importconverters
ImportConverters = 1
ImportConverter0 = ifequal "%u","DCMSND"; compression as
UTF8ToDB = 1
UTF8FromDB = 1
# Configuration of compression for incoming images and archival
DroppedFileCompression = uj
IncomingCompression = uj
ArchiveCompression = as
# For debug information
PACSName = WL
OperatorConsole = 127.0.0.1
DebugLevel = 5
# Configuration of disk(s) to store images
MAGDeviceFullThreshHold = 30
MAGDevices = 1
MAGDevice0 = C:\dicomserver\conquestdicomserver\data\
#LUA
[lua]
ModalityWorklistQueryResultConverter0 = Data.StudyInstanceUID = genuid()
[lua]
Association=local AE,IP,P,C= get_amap(1); if Association.Caller==AE and Association.ConnectedIP~=IP then servercommand('put_amap:'..AE..','..Association.ConnectedIP..','..P..','..C) end
[lua]
ModalityWorkListQueryResultConverter0 = Data.ReferencedStudySequence = nil; Data.ReferencedPatientSequence = nil;
[lua]
ModalityWorkListQueryResultConverter0 = Data.ReferencedStudySequence = nil; Data.ReferencedPatientSequence = nil; Data.TransferSyntaxUID = '1.2.840.10008.1.2'
[lua]
QueryWorklistConverter0 = Data.ScheduledProcedureStep[1].ScheduledProcedureStepTime = ''
Could you give me suggestions or recommendations? Thanks to all
-
Quote
I already put that part on. In fact I originally put Conques and only US worked. Then I put that code and I put it in the start of the MySQL with Lua. And it works fine. But in a CR Dental I found this document with specifications and I want to see what I do in that situation.
-
Quote
In the last weeks I implemented a series of tools for a small hospital. Previously they had the iQRIS/PACS tool, but due to a budget they had to change to cheaper technologies. Now I implement Osirix MD for the visualization of studies through its web viewer. And we have a RIS system, and I have sent data through pasting code to MySQL tables successfully to different modalities. The Hospital has. US, XA, CR, DX, CT, RM, MG. I already managed to send a work list to DX, MG, US and MG. But I don't know how to start adding correct TAGS, scripts, or configurations data for XA, CT, MR. I have read a lot in the forums and mainly the responses of Marcel Vanherk. But the truth, I don't know what should be the first steps and the best ways to achieve my mission, I hope you can help me. I have seen that this community is very large and friendly. And I hope in the future also to be able to do something to help the community. Thank You All. And I Keep reading the forum. (Sorry bad English Im From México)