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