Posts by jheleniak

    Trying to create a lua file that has if statements to check data.StudyInstanceUID against a str match.



    Dragging and dropping a few hundred thousand studies. Trying to filter out some studies with import converter from even importing those studies.



    Can you use ifmatch statements like you can on a .ini import converter in a lua script?


    ifmatch "%V0020,000D","1.2.841.123456.3.167.3.123456.2*"; destroy


    If not can you use a destroy or reject image in a lua based on a if string match statement checks true?



    Thanks:thumbup:

    sure i'll send you a file


    how can i call dcmscale from import converter to save back to original file while it's incoming i used command line on file and it works but can't get it to work in importer..i am keeping same sop instance uid


    ------------ Adding image files to server -----------
    [CONQUESTSRV1] *** Importconverter0.0 error: "C:\dcmtk\bin\dcmscale.exe +un +Sxf .5 C:\dicom\data\201971\1.2.826.0.1.3680043.2.1635.0.3840606097.2836.1391005581.660_999999_000001_13910078100001.dcm C:\dicom\data\201971\1.2.826.0.1.3680043.2.1635.0.3840606097.2836.1391005581.660_999999_000001_13910078100001.dcm"
    [CONQUESTSRV1] Added file: C:\dicom\data\201971\1.2.826.0.1.3680043.2.1635.0.3840606097.2836.1391005581.660_999999_000001_13910078100001.dcm
    -----------------------------------------------------

    what im trying to do is just resize specific images so they are not 24MB
    trying ExportConverter3 = forward compressed as k1 to IR_HOST


    says it recompresses but images are still huge and not resized and seem untouched



    any other way to do with import converter or something?

    ive tried RGB MONOCHROME8 and 12



    0008,0016) SOPClassUID UI # 26 1 [1.2.840.10008.5.1.4.1.1.7]
    (0008,0018) SOPInstanceUID UI # 60 1 [1.2.826.0.1.3680043.2.1635.0.1385705735.3292.1390843953.488]
    (0008,0020) StudyDate DA # 8 1 [20140127]
    (0008,0021) SeriesDate DA # 8 1 [20140127]
    (0008,0023) ContentDate DA # 8 1 [20140127]
    (0008,0030) StudyTime TM # 6 1 [123034]
    (0008,0031) SeriesTime TM # 6 1 [123230]
    (0008,0033) ContentTime TM # 6 1 [123233]
    (0008,0050) AccessionNumber SH # 6 1 [100988]
    (0008,0060) Modality CS # 2 1 [SC]
    (0008,0064) ConversionType CS # 2 1 [SI]
    (0008,0070) Manufacturer LO # 10 1
    (0008,0080) InstitutionName LO # 0 0 []
    (0008,0090) ReferringPhysiciansName PN # 12 1
    (0008,1010) StationName SH # 0 0 []
    (0008,1030) StudyDescription LO # 20 1 ]
    (0008,103e) SeriesDescription LO # 12 1 [Paper Series]
    (0008,1040) InstitutionalDepartmentName LO # 0 0 []
    (0008,1050) PerformingPhysiciansName PN # 0 0 []
    (0008,1090) ManufacturerModelName LO # 16 1 [Dicom Printer 2 ]
    (0010,0010) PatientName PN # 16 1
    (0010,0020) PatientID LO # 6 1 [5]
    (0010,0030) PatientBirthDate DA # 8 1 []
    (0010,0040) PatientSex CS # 2 1 []
    (0018,0015) BodyPartExamined CS # 0 0 []
    (0018,1000) DeviceSerialNumber LO # 36 1 [3D2569F7-6064-323A-0003-D58378EF308F]
    (0018,1010) SecondaryCaptureDeviceID LO # 36 1 [3D2569F7-6064-323A-0003-D58378EF308F]
    (0018,1012) DateOfSecondaryCapture DA # 8 1 [20140127]
    (0018,1014) TimeOfSecondaryCapture TM # 6 1 [123216]
    (0018,1016) SecondaryCaptureDeviceManufacturer LO # 10 1
    (0018,1018) SecondaryCaptureDeviceManufactur... LO # 16 1
    (0018,1019) SecondaryCaptureDeviceSoftwareVe... LO # 10 1 [2.1.7.445 ]
    (0018,1020) SoftwareVersion LO # 10 1 [2.1.7.445 ]
    (0020,000d) StudyInstanceUID UI # 52 1 [1.3.12.2.1107.5.1.4.32568.3000000100988201401271229]
    (0020,000e) SeriesInstanceUID UI # 60 1 [1.2.826.0.1.3680043.2.1635.0.1385705735.3292.1390843950.485]
    (0020,0010) StudyID SH # 16 1 [1098914012726555]
    (0020,0011) SeriesNumber IS # 6 1 [999999]
    (0020,0013) InstanceNumber IS # 2 1 [3]
    (0020,0020) PatientOrientation CS # 4 2 [A\R]
    (0020,0060) Laterality CS # 0 0 []
    (0028,0002) SamplesPerPixel US # 2 1 [3]
    (0028,0004) PhotometricInterpretation CS # 4 1 [RGB]
    (0028,0006) PlanarConfiguration US # 2 1 [0]
    (0028,0010) Rows US # 2 1 [3305]
    (0028,0011) Columns US # 2 1 [2540]
    (0028,0100) BitsAllocated US # 2 1 [8]
    (0028,0101) BitsStored US # 2 1 [8]
    (0028,0102) HighBit US # 2 1 [7]
    (0028,0103) PixelRepresentation US # 2 1 [0]
    (0028,0106) SmallestImagePixelValue US # 2 1 [0]
    (0028,0107) LargestImagePixelValue US # 2 1 [255]

    using drop


    ------------ Adding image files to server -----------
    [CONQUESTSRV1] Connected by address: 0100007f
    [CONQUESTSRV1] Testing transfer: '1.2.840.10008.1.2' against list #0 = '1.2.840.10008.1.2'
    [CONQUESTSRV1] 0000,0002 18 UI AffectedSOPClassUID "1.2.840.10008.1.1"
    [CONQUESTSRV1] 0000,0100 2 US CommandField 48
    [CONQUESTSRV1] 0000,0110 2 US MessageID 7
    [CONQUESTSRV1] 0000,0800 2 US DataSetType 257
    [CONQUESTSRV1] 0002,0010 17 UI TransferSyntaxUID "1.2.840.10008.1.2"
    [CONQUESTSRV1] 9999,0400 108 LO ConquestConsoleComma "addimagefile:C:\\1.2.826.0.1.3680043.2.1635.0.2336235503.1308.1390930660.758_999999_000003_1390930671210e.dcm"
    [CONQUESTSRV1] Query Tables: DICOMImages
    [CONQUESTSRV1] Columns : ObjectFile, DeviceName
    [CONQUESTSRV1] Where : SOPInstanc = '1.2.826.0.1.3680043.2.1635.0.2336235503.1308.1390930668.761' AND ImagePat = ''
    [CONQUESTSRV1] Order : (null)
    [CONQUESTSRV1] Query Tables: DICOMImages
    [CONQUESTSRV1] Columns : SOPInstanc,SOPClassUI,ImageNumbe,ImageDate,ImageTime,EchoNumber,NumberOfFr,AcqDate,AcqTime,ReceivingC,AcqNumber,SliceLocat,SamplesPer,PhotoMetri,Rows,Colums,BitsStored,ImageType,ImageID,ImagePat,SeriesInst
    [CONQUESTSRV1] Where : SOPInstanc = '1.2.826.0.1.3680043.2.1635.0.2336235503.1308.1390930668.761' AND ImagePat = '
    [CONQUESTSRV1] Order : (null)
    [CONQUESTSRV1] Update Table: DICOMImages
    [CONQUESTSRV1] Updates : SOPInstanc = '1.2.826.0.1.3680043.2.1635.0.2336235503.1308.1390930668.761', SOPClassUI = '1.2.840.10008.5.1.4.1.1.7', ImageNumbe = '3', ImageDate = '20140128', ImageTime = '123747', SamplesPer = '3', PhotoMetri = 'RGB', Rows = '3297', Colums = '2535', BitsStored = '8', ImagePat = '', SeriesInst = '1.2.826.0.1.3680043.2.1635.0.2336235503.1308.1390930660.758', AccessTime = 1390931488, ObjectFile = '235566\1.2.826.0.1.3680043.2.1635.0.2336235503.1308.1390930660.758_999999_000003_13909307910000.v2', DeviceName = 'MAG0'
    [CONQUESTSRV1] Where : SOPInstanc = '1.2.826.0.1.3680043.2.1635.0.2336235503.1308.1390930668.761' AND ImagePat = ''
    [CONQUESTSRV1] Query Tables: DICOMSeries
    [CONQUESTSRV1] Columns : SeriesInst,SeriesNumb,SeriesDate,SeriesTime,SeriesDesc,Modality,PatientPos,ContrastBo,Manufactur,ModelName,BodyPartEx,ProtocolNa,StationNam,Institutio,FrameOfRef,SeriesPat,StudyInsta
    [CONQUESTSRV1] Where : SeriesInst = '1.2.826.0.1.3680043.2.1635.0.2336235503.1308.1390930660.758' AND SeriesPat = ''
    [CONQUESTSRV1] Order : (null)
    [CONQUESTSRV1] Update Table: DICOMSeries
    [CONQUESTSRV1] Updates : SeriesInst = '1.2.826.0.1.3680043.2.1635.0.2336235503.1308.1390930660.758', SeriesNumb = '999999', SeriesDate = '20140128', SeriesTime = '123740', SeriesDesc = 'Paper Series', Modality = 'SC', Manufactur = Test.', ModelName = 'Dicom Printer 2', SeriesPat = '235566', StudyInsta = '1.3.12.2.1107.5.1.4.32568.3000000101076201401281229', AccessTime = 1390931488
    [CONQUESTSRV1] Where : SeriesInst = '1.2.826.0.1.3680043.2.1635.0.2336235503.1308.1390930660.758' AND SeriesPat = ''
    [CONQUESTSRV1] Query Tables: DICOMStudies
    [CONQUESTSRV1] Columns : StudyInsta,StudyDate,StudyTime,StudyID,StudyDescr,AccessionN,ReferPhysi,PatientsAg,PatientsWe,StudyModal,PatientNam,PatientBir,PatientSex,PatientID
    [CONQUESTSRV1] Where : StudyInsta = '1.3.12.2.1107.5.1.4.32568.3000000101076201401281229'
    [CONQUESTSRV1] Order : (null)

    0 # 2 PlanarConfiguration
    (0028,0010) US 3297 # 2 Rows
    (0028,0011) US 2535 # 2 Columns
    (0028,0100) US 8 # 2 BitsAllocated
    (0028,0101) US 8 # 2 BitsStored
    (0028,0102) US 7 # 2 HighBit
    (0028,0103) US 0 # 2 PixelRepresentation
    (7fe0,0000) UL 25073694 # 4 PixelDataGroupLength
    (7fe0,0010) OW (not loaded) # 25073686 PixelData

    It'S definitely forwarding the query to the virtual server found in the ini after recompiling with changes... however the items in the other server in which the query is forwarded to doesn't seem to find the worklist entries in it's database.


    it doesn't really saying querying worklist database. almost like it's just checking for stored studies or something. if you query the other worklist server directly it does find items.



    1.4.17alpha linux with VirtualServerFor0 = WORKLIST and worklist is in its acrnema as i see the c-find get forwarded. any ideas? the other server is 1.4.17b windows server with items in it's worklist

    if you are using wado calls for thumbnails from conquest and also the native thumbnails that weasis pulls from conquest are washed out and contrasty compared to the normal wado calls to dcm4che and weasis to dcm4chee for thumbnails with no special parameters.


    the actual full dcm file ends up displaying fine in weasis or whatever but the thumbnails are harsh looking and don't represent the image well.

    I compiled 64 bit linux and figured i would give the wado bridge with virtual servers a test drive. It works great given your backend dicom servers can serve it up fast than your wado clients suck it down.


    I love the fact that if you request a transfer systax via weasis to conquest of jpeg 2000 .90 and you have it stored uncompressed on the backend, conquest will compress it on the fly during the wado request and feed a jpeg 2000 format. something that dcm4che wouldn't do for me that i wanted to utilize for weasis client.


    One thing i have question about...i want to use dgate accessible to internet clients as a wado server. i think i can pretty much protect the images via utilizing studyuid,seriesuid,objectuid requirements. however, dgate unmodified has the ability to do all kinds of things that you don't want people on the internet doing.


    Is it possible for me to edit dgate.cpp and take out the default html stuff, recompile and when someone calls the dgate alone or dgate?mode=showconfig etc etc it would show nothing?


    wondering if maybe i can just create a small patch for dgate exectuable that is accessible by the internet and leave the conquest dgate alone? make sense?


    thanks for all your efforts on conquest marcel

    I understand dangers of modifying tags without newuids. Using 1.4.16e and 1.4.16i to test. Trying to come up with some scripts that i can modify tags for when techs select the wrong patient for an exam so i can overwrite the study and not generate a new one. I would want to be able to overwrite tags such as PatientID, PatientDOB, ReferringPhysi, AccessionNum etc etc....is this script supposed to be able to accomplish this? I would be probably issuing commands from a php script or like. Also..what is the proper way to issue this command from web interface....i get a server returned 500 but it actually does process the command in the console...


    http://127.0.0.1/cgi-bin/dgate…46475.7.1331292644.921.46 set PatientID to 1234567'


    C:\dicomserver>dgate --modifystudy:123456,1.2.826.0.1.3680043.2.135.734570.57906475.7.1331292644.921.46 set PatientID to 1234567



    none of the tags ever gets changed?


    no debug
    [JHELENIAK] Connected by address: 0100007f
    [JHELENIAK] Testing transfer: '1.2.840.10008.1.2' against list #0 = '1.2.840.10008.1.2'
    [JHELENIAK] 0000,0002 18 UI AffectedSOPClassUID "1.2.840.10008.1.1"
    [JHELENIAK] 0000,0100 2 US CommandField 48
    [JHELENIAK] 0000,0110 2 US MessageID 1
    [JHELENIAK] 0000,0800 2 US DataSetType 257
    [JHELENIAK] 0002,0010 17 UI TransferSyntaxUID "1.2.840.10008.1.2"
    [JHELENIAK] 9999,0300 42 LO ConquestConsoleText "Server command sent using DGATE -- option"
    [JHELENIAK] 9999,0400 80 LO ConquestConsoleComma "modifystudy:123456,1.2.826.0.1.3680043.2.135.734570.57906475.7.1331292644.921.46"
    [JHELENIAK] Server command sent using DGATE -- option
    [JHELENIAK] Query On Image
    [JHELENIAK] Issue Query on Columns: DICOMImages.SOPInstanc, DICOMImages.ImageNumbe, DICOMImages.NumberOfFr, DICOMStudies.PatientID, DICOMStudies.StudyInsta,DICOMImages.ObjectFile,DICOMImages.DeviceName
    [JHELENIAK] Values: DICOMStudies.PatientID = '123456' and DICOMStudies.StudyInsta = '1.2.826.0.1.3680043.2.135.734570.57906475.7.1331292644.921.46' and DICOMSeries.StudyInsta = DICOMStudies.StudyInsta and DICOMImages.SeriesInst = DICOMSeries.SeriesInst
    [JHELENIAK] Tables: DICOMImages, DICOMSeries, DICOMStudies
    [JHELENIAK] Query Distinct Tables: DICOMImages, DICOMSeries, DICOMStudies
    [JHELENIAK] Columns : DICOMImages.SOPInstanc, DICOMImages.ImageNumbe, DICOMImages.NumberOfFr, DICOMStudies.PatientID, DICOMStudies.StudyInsta,DICOMImages.ObjectFile,DICOMImages.DeviceName
    [JHELENIAK] Where : DICOMStudies.PatientID = '123456' and DICOMStudies.StudyInsta = '1.2.826.0.1.3680043.2.135.734570.57906475.7.1331292644.921.46' and DICOMSeries.StudyInsta = DICOMStudies.StudyInsta and DICOMImages.SeriesInst = DICOMSeries.SeriesInst
    [JHELENIAK] Order : (null)
    [JHELENIAK] Records = 2
    [JHELENIAK] Locating file:MAG0 123456\1.2.826.0.1.3680043.2.135.734570.57906475.7.1331292644.921.47_0001_002000_1331292644000c.dcm
    [JHELENIAK] Locating file:MAG0 123456\1.2.826.0.1.3680043.2.135.734570.57906475.7.1331292644.921.47_0001_003000_1331292644000d.dcm



    with debug on



    [JHELENIAK] Connected by address: 0100007f
    [JHELENIAK] Testing transfer: '1.2.840.10008.1.2' against list #0 = '1.2.840.10008.1.2'
    [JHELENIAK] 0000,0002 18 UI AffectedSOPClassUID "1.2.840.10008.1.1"
    [JHELENIAK] 0000,0100 2 US CommandField 48
    [JHELENIAK] 0000,0110 2 US MessageID 1
    [JHELENIAK] 0000,0800 2 US DataSetType 257
    [JHELENIAK] 0002,0010 17 UI TransferSyntaxUID "1.2.840.10008.1.2"
    [JHELENIAK] 9999,0300 42 LO ConquestConsoleText "Server command sent using DGATE -- option"
    [JHELENIAK] 9999,0400 108 LO ConquestConsoleComma "modifystudy:123456,1.2.826.0.1.3680043.2.135.734570.57906475.7.1331292644.921.46,, set PatientID to 1234567"
    [JHELENIAK] Server command sent using DGATE -- option
    [JHELENIAK] Query On Image
    [JHELENIAK] Issue Query on Columns: DICOMImages.SOPInstanc, DICOMImages.ImageNumbe, DICOMImages.NumberOfFr, DICOMStudies.PatientID, DICOMStudies.StudyInsta,DICOMImages.ObjectFile,DICOMImages.DeviceName
    [JHELENIAK] Values: DICOMStudies.PatientID = '123456' and DICOMStudies.StudyInsta = '1.2.826.0.1.3680043.2.135.734570.57906475.7.1331292644.921.46' and DICOMSeries.StudyInsta = DICOMStudies.StudyInsta and DICOMImages.SeriesInst = DICOMSeries.SeriesInst
    [JHELENIAK] Tables: DICOMImages, DICOMSeries, DICOMStudies
    [JHELENIAK] Query Distinct Tables: DICOMImages, DICOMSeries, DICOMStudies
    [JHELENIAK] Columns : DICOMImages.SOPInstanc, DICOMImages.ImageNumbe, DICOMImages.NumberOfFr, DICOMStudies.PatientID, DICOMStudies.StudyInsta,DICOMImages.ObjectFile,DICOMImages.DeviceName
    [JHELENIAK] Where : DICOMStudies.PatientID = '123456' and DICOMStudies.StudyInsta = '1.2.826.0.1.3680043.2.135.734570.57906475.7.1331292644.921.46' and DICOMSeries.StudyInsta = DICOMStudies.StudyInsta and DICOMImages.SeriesInst = DICOMSeries.SeriesInst
    [JHELENIAK] Order : (null)
    [JHELENIAK] Records = 2
    [JHELENIAK] Locating file:MAG0 123456\1.2.826.0.1.3680043.2.135.734570.57906475.7.1331292644.921.47_0001_002000_1331292644000c.dcm
    [JHELENIAK] Locating file:MAG0 123456\1.2.826.0.1.3680043.2.135.734570.57906475.7.1331292644.921.47_0001_003000_1331292644000d.dcm
    [JHELENIAK] *** Importconverter-1.0 error: , set PatientID to 1234567
    [JHELENIAK] Deleting database entry for image: C:\dicomserver\Data\123456\1.2.826.0.1.3680043.2.135.734570.57906475.7.1331292644.921.47_0001_002000_1331292644000c.dcm
    [JHELENIAK] Query On Image
    [JHELENIAK] Issue Query on Columns: DICOMImages.SOPInstanc, DICOMSeries.SeriesInst, DICOMStudies.PatientID, DICOMStudies.StudyInsta
    [JHELENIAK] Values: DICOMImages.SOPInstanc = '1.2.826.0.1.3680043.2.135.734570.57906475.7.1331292644.906.44' and DICOMStudies.PatientID = '123456' and DICOMSeries.StudyInsta = DICOMStudies.StudyInsta and DICOMImages.SeriesInst = DICOMSeries.SeriesInst
    [JHELENIAK] Tables: DICOMImages, DICOMSeries, DICOMStudies
    [JHELENIAK] Query Distinct Tables: DICOMImages, DICOMSeries, DICOMStudies
    [JHELENIAK] Columns : DICOMImages.SOPInstanc, DICOMSeries.SeriesInst, DICOMStudies.PatientID, DICOMStudies.StudyInsta
    [JHELENIAK] Where : DICOMImages.SOPInstanc = '1.2.826.0.1.3680043.2.135.734570.57906475.7.1331292644.906.44' and DICOMStudies.PatientID = '123456' and DICOMSeries.StudyInsta = DICOMStudies.StudyInsta and DICOMImages.SeriesInst = DICOMSeries.SeriesInst
    [JHELENIAK] Order : (null)
    [JHELENIAK] Records = 1
    [JHELENIAK] RemoveFromPACS 1 image database entries
    [JHELENIAK] Query Tables: DICOMImages
    [JHELENIAK] Columns : ObjectFile, DeviceName
    [JHELENIAK] Where : SOPInstanc = '1.2.826.0.1.3680043.2.135.734570.57906475.7.1331292644.906.44' AND ImagePat = '123456'
    [JHELENIAK] Order : (null)
    [JHELENIAK] IOD File being removed: C:\dicomserver\Data\123456\1.2.826.0.1.3680043.2.135.734570.57906475.7.1331292644.921.47_0001_002000_1331292644000c.dcm
    [JHELENIAK] Query Tables: DICOMImages
    [JHELENIAK] Columns : DICOMImages.SopInstanc
    [JHELENIAK] Where : DICOMImages.SopInstanc = '1.2.826.0.1.3680043.2.135.734570.57906475.7.1331292644.906.44' and DICOMImages.SeriesInst = '1.2.826.0.1.3680043.2.135.734570.57906475.7.1331292644.921.47' and DICOMImages.ImagePat = '123456'
    [JHELENIAK] Order : (null)
    [JHELENIAK] Delete Record Table: DICOMImages
    [JHELENIAK] Where : DICOMImages.SopInstanc = '1.2.826.0.1.3680043.2.135.734570.57906475.7.1331292644.906.44' and DICOMImages.SeriesInst = '1.2.826.0.1.3680043.2.135.734570.57906475.7.1331292644.921.47' and DICOMImages.ImagePat = '123456'
    [JHELENIAK] Query Tables: DICOMImages
    [JHELENIAK] Columns : DICOMImages.SeriesInst
    [JHELENIAK] Where : DICOMImages.SeriesInst = '1.2.826.0.1.3680043.2.135.734570.57906475.7.1331292644.921.47' and DICOMImages.ImagePat = '123456'
    [JHELENIAK] Order : (null)
    [JHELENIAK] Query Tables: DICOMSeries
    [JHELENIAK] Columns : DICOMSeries.StudyInsta
    [JHELENIAK] Where : DICOMSeries.StudyInsta = '1.2.826.0.1.3680043.2.135.734570.57906475.7.1331292644.921.46' and DICOMSeries.SeriesPat = '123456'
    [JHELENIAK] Order : (null)
    [JHELENIAK] Query Tables: DICOMStudies
    [JHELENIAK] Columns : DICOMStudies.PatientID
    [JHELENIAK] Where : DICOMStudies.PatientID = '123456'
    [JHELENIAK] Order : (null)
    [JHELENIAK] Query Tables: DICOMImages
    [JHELENIAK] Columns : ObjectFile, DeviceName
    [JHELENIAK] Where : SOPInstanc = '1.2.826.0.1.3680043.2.135.734570.57906475.7.1331292644.906.44' AND ImagePat = '123456'
    [JHELENIAK] Order : (null)
    [JHELENIAK] FreeStore Left 11239 on C:\
    [JHELENIAK] Add to Table: DICOMImages
    [JHELENIAK] Columns: SOPInstanc, SOPClassUI, ImageNumbe, ImageDate, ImageTime, AcqDate, AcqNumber, SliceLocat, SamplesPer, PhotoMetri, Rows, Colums, BitsStored, ImageType, ImagePat, SeriesInst, AccessTime, ObjectFile, DeviceName
    [JHELENIAK] Values: '1.2.826.0.1.3680043.2.135.734570.57906475.7.1331292644.906.44', '1.2.840.10008.5.1.4.1.1.2', '2000', '19980414', '170346.000000', '19980414', ' 1', '-91.000000', '1', 'MONOCHROME2', '320', '320', '12', 'ORIGINAL\PRIMARY\AXIAL\NORMAL', '123456', '1.2.826.0.1.3680043.2.135.734570.57906475.7.1331292644.921.47', 1331294880, '123456\1.2.826.0.1.3680043.2.135.734570.57906475.7.1331292644.921.47_0001_002000_13312948860000.dcm', 'MAG0'
    [JHELENIAK] Query Tables: DICOMSeries
    [JHELENIAK] Columns : SeriesInst,SeriesNumb,SeriesDate,SeriesTime,SeriesDesc,Modality,PatientPos,ContrastBo,Manufactur,ModelName,BodyPartEx,ProtocolNa,StationNam,Institutio,FrameOfRef,SeriesPat,StudyInsta
    [JHELENIAK] Where : SeriesInst = '1.2.826.0.1.3680043.2.135.734570.57906475.7.1331292644.921.47' AND SeriesPat = '123456'
    [JHELENIAK] Order : (null)
    [JHELENIAK] Update Table: DICOMSeries
    [JHELENIAK] Updates : SeriesInst = '1.2.826.0.1.3680043.2.135.734570.57906475.7.1331292644.921.47', SeriesNumb = ' 1', SeriesDate = '19980414', SeriesTime = '170346.000000', Modality = 'CT', PatientPos = 'HFS', ContrastBo = 'NONE', Manufactur = 'Philips Medical Systems', ModelName = 'AVE1', ProtocolNa = '1', Institutio = '', FrameOfRef = '1.2.826.0.1.3680043.2.135.734570.57906475.7.1331292644.921.48', SeriesPat = '123456', StudyInsta = '1.2.826.0.1.3680043.2.135.734570.57906475.7.1331292644.921.46', AccessTime = 1331294880
    [JHELENIAK] Where : SeriesInst = '1.2.826.0.1.3680043.2.135.734570.57906475.7.1331292644.921.47' AND SeriesPat = '123456'
    [JHELENIAK] Query Tables: DICOMStudies
    [JHELENIAK] Columns : StudyInsta,StudyDate,StudyTime,StudyID,StudyDescr,AccessionN,ReferPhysi,PatientsAg,PatientsWe,StudyModal,PatientNam,PatientBir,PatientSex,PatientID
    [JHELENIAK] Where : StudyInsta = '1.2.826.0.1.3680043.2.135.734570.57906475.7.1331292644.921.46'
    [JHELENIAK] Order : (null)
    [JHELENIAK] Update Table: DICOMStudies
    [JHELENIAK] Updates : StudyInsta = '1.2.826.0.1.3680043.2.135.734570.57906475.7.1331292644.921.46', StudyDate = '19980414', StudyTime = '203538.960689', StudyID = '0009703828', StudyDescr = ' ', StudyModal = 'CT', PatientNam = 'HEAD EXP2', PatientSex = 'O', PatientID = '123456', AccessTime = 1331294880
    [JHELENIAK] Where : StudyInsta = '1.2.826.0.1.3680043.2.135.734570.57906475.7.1331292644.921.46'
    [JHELENIAK] Query Tables: DICOMPatients
    [JHELENIAK] Columns : PatientID,PatientNam,PatientBir,PatientSex
    [JHELENIAK] Where : PatientID = '123456'
    [JHELENIAK] Order : (null)
    [JHELENIAK] Update Table: DICOMPatients
    [JHELENIAK] Updates : PatientID = '123456', PatientNam = 'HEAD EXP2', PatientSex = 'O', AccessTime = 1331294880
    [JHELENIAK] Where : PatientID = '123456'
    [JHELENIAK] Modified image: C:\dicomserver\Data\123456\1.2.826.0.1.3680043.2.135.734570.57906475.7.1331292644.921.47_0001_002000_13312948860000.dcm
    [JHELENIAK] Deleting file: C:\dicomserver\Data\123456\1.2.826.0.1.3680043.2.135.734570.57906475.7.1331292644.921.47_0001_002000_1331292644000c.dcm
    [JHELENIAK] *** Importconverter-1.0 error: , set PatientID to 1234567
    [JHELENIAK] Deleting database entry for image: C:\dicomserver\Data\123456\1.2.826.0.1.3680043.2.135.734570.57906475.7.1331292644.921.47_0001_003000_1331292644000d.dcm
    [JHELENIAK] Query On Image
    [JHELENIAK] Issue Query on Columns: DICOMImages.SOPInstanc, DICOMSeries.SeriesInst, DICOMStudies.PatientID, DICOMStudies.StudyInsta
    [JHELENIAK] Values: DICOMImages.SOPInstanc = '1.2.826.0.1.3680043.2.135.734570.57906475.7.1331292644.78.49' and DICOMStudies.PatientID = '123456' and DICOMSeries.StudyInsta = DICOMStudies.StudyInsta and DICOMImages.SeriesInst = DICOMSeries.SeriesInst
    [JHELENIAK] Tables: DICOMImages, DICOMSeries, DICOMStudies
    [JHELENIAK] Query Distinct Tables: DICOMImages, DICOMSeries, DICOMStudies
    [JHELENIAK] Columns : DICOMImages.SOPInstanc, DICOMSeries.SeriesInst, DICOMStudies.PatientID, DICOMStudies.StudyInsta
    [JHELENIAK] Where : DICOMImages.SOPInstanc = '1.2.826.0.1.3680043.2.135.734570.57906475.7.1331292644.78.49' and DICOMStudies.PatientID = '123456' and DICOMSeries.StudyInsta = DICOMStudies.StudyInsta and DICOMImages.SeriesInst = DICOMSeries.SeriesInst
    [JHELENIAK] Order : (null)
    [JHELENIAK] Records = 1
    [JHELENIAK] RemoveFromPACS 1 image database entries
    [JHELENIAK] Query Tables: DICOMImages
    [JHELENIAK] Columns : ObjectFile, DeviceName
    [JHELENIAK] Where : SOPInstanc = '1.2.826.0.1.3680043.2.135.734570.57906475.7.1331292644.78.49' AND ImagePat = '123456'
    [JHELENIAK] Order : (null)
    [JHELENIAK] IOD File being removed: C:\dicomserver\Data\123456\1.2.826.0.1.3680043.2.135.734570.57906475.7.1331292644.921.47_0001_003000_1331292644000d.dcm
    [JHELENIAK] Query Tables: DICOMImages
    [JHELENIAK] Columns : DICOMImages.SopInstanc
    [JHELENIAK] Where : DICOMImages.SopInstanc = '1.2.826.0.1.3680043.2.135.734570.57906475.7.1331292644.78.49' and DICOMImages.SeriesInst = '1.2.826.0.1.3680043.2.135.734570.57906475.7.1331292644.921.47' and DICOMImages.ImagePat = '123456'
    [JHELENIAK] Order : (null)
    [JHELENIAK] Delete Record Table: DICOMImages
    [JHELENIAK] Where : DICOMImages.SopInstanc = '1.2.826.0.1.3680043.2.135.734570.57906475.7.1331292644.78.49' and DICOMImages.SeriesInst = '1.2.826.0.1.3680043.2.135.734570.57906475.7.1331292644.921.47' and DICOMImages.ImagePat = '123456'
    [JHELENIAK] Query Tables: DICOMImages
    [JHELENIAK] Columns : ObjectFile, DeviceName
    [JHELENIAK] Query Tables: DICOMSeries
    [JHELENIAK] Columns : SeriesInst,SeriesNumb,SeriesDate,SeriesTime,SeriesDesc,Modality,PatientPos,ContrastBo,Manufactur,ModelName,BodyPartEx,ProtocolNa,StationNam,Institutio,FrameOfRef,SeriesPat,StudyInsta
    [JHELENIAK] Query Tables: DICOMStudies
    [JHELENIAK] Modified image: C:\dicomserver\Data\123456\1.2.826.0.1.3680043.2.135.734570.57906475.7.1331292644.921.47_0001_003000_13312948860001.dcm
    [JHELENIAK] Connected by address: 0100007f
    [JHELENIAK] Testing transfer: '1.2.840.10008.1.2' against list #0 = '1.2.840.10008.1.2'
    [JHELENIAK] 0000,0002 18 UI AffectedSOPClassUID "1.2.840.10008.1.1"
    [JHELENIAK] 0000,0100 2 US CommandField 48
    [JHELENIAK] 0000,0110 2 US MessageID 7
    [JHELENIAK] 0000,0800 2 US DataSetType 257
    [JHELENIAK] 0002,0010 17 UI TransferSyntaxUID "1.2.840.10008.1.2"
    [JHELENIAK] 9999,0300 34 LO ConquestConsoleText "db extract for GUI of patient dbf"
    [JHELENIAK] 9999,0400 8 LO ConquestConsoleComma "extract:"
    [JHELENIAK] db extract for GUI of patient dbf
    [JHELENIAK] Create Table: XADICOMPatients
    [JHELENIAK] Columns : PatientID varchar(64), PatientNam varchar(64), PatientBir char(8) , PatientSex varchar(16), AccessTime int, qTimeStamp int, qFlags int, qSpare varchar(64)
    [JHELENIAK] Query Tables: DICOMPatients
    [JHELENIAK] Columns : PatientID, PatientNam, PatientBir, PatientSex, AccessTime, qTimeStamp, qFlags, qSpare
    [JHELENIAK] Where : (null)
    [JHELENIAK] Order : (null)
    [JHELENIAK] Add to Table: XADICOMPatients
    [JHELENIAK] Columns: PatientID, PatientNam, PatientBir, PatientSex, AccessTime, qTimeStamp, qFlags, qSpare
    [JHELENIAK] Values: '123456', 'HEAD EXP2', '', 'O', '1331294880', '', '', ''
    [JHELENIAK] Connected by address: 0100007f
    [JHELENIAK] Testing transfer: '1.2.840.10008.1.2' against list #0 = '1.2.840.10008.1.2'
    [JHELENIAK] 0000,0002 18 UI AffectedSOPClassUID "1.2.840.10008.1.1"
    [JHELENIAK] 0000,0100 2 US CommandField 48
    [JHELENIAK] 0000,0110 2 US MessageID 7
    [JHELENIAK] 0000,0800 2 US DataSetType 257
    [JHELENIAK] 0002,0010 17 UI TransferSyntaxUID "1.2.840.10008.1.2"
    [JHELENIAK] 9999,0300 38 LO ConquestConsoleText "db extract for GUI of patient: 123456"
    [JHELENIAK] 9999,0400 28 LO ConquestConsoleComma "extract:PatientID = '123456'"
    [JHELENIAK] db extract for GUI of patient: 123456
    [JHELENIAK] Create Table: XADICOMPatients
    [JHELENIAK] Columns : PatientID varchar(64), PatientNam varchar(64), PatientBir char(8) , PatientSex varchar(16), AccessTime int, qTimeStamp int, qFlags int, qSpare varchar(64)
    [JHELENIAK] Query Tables: DICOMPatients
    [JHELENIAK] Columns : PatientID, PatientNam, PatientBir, PatientSex, AccessTime, qTimeStamp, qFlags, qSpare
    [JHELENIAK] Where : (null)
    [JHELENIAK] Order : (null)
    [JHELENIAK] Add to Table: XADICOMPatients
    [JHELENIAK] Columns: PatientID, PatientNam, PatientBir, PatientSex, AccessTime, qTimeStamp, qFlags, qSpare
    [JHELENIAK] Values: '123456', 'HEAD EXP2', '', 'O', '1331294880', '', '', ''
    [JHELENIAK] Create Table: XDICOMPatients
    [JHELENIAK] Columns : PatientID varchar(64), PatientNam varchar(64), PatientBir char(8) , PatientSex varchar(16), AccessTime int, qTimeStamp int, qFlags int, qSpare varchar(64)
    [JHELENIAK] Query Tables: DICOMPatients
    [JHELENIAK] Columns : PatientID, PatientNam, PatientBir, PatientSex, AccessTime, qTimeStamp, qFlags, qSpare
    [JHELENIAK] Where : PatientID = '123456'
    [JHELENIAK] Order : (null)
    [JHELENIAK] Add to Table: XDICOMPatients
    [JHELENIAK] Columns: PatientID, PatientNam, PatientBir, PatientSex, AccessTime, qTimeStamp, qFlags, qSpare
    [JHELENIAK] Values: '123456', 'HEAD EXP2', '', 'O', '1331294880', '', '', ''
    [JHELENIAK] Create Table: XDICOMStudies
    [JHELENIAK] Columns : StudyInsta varchar(64), StudyDate char(8) , StudyTime varchar(16), StudyID varchar(16), StudyDescr varchar(64), AccessionN varchar(16), ReferPhysi varchar(64), PatientsAg varchar(16), PatientsWe varchar(16), StudyModal varchar(64), PatientNam varchar(64), PatientBir char(8) , PatientSex varchar(16), PatientID varchar(64), AccessTime int, qTimeStamp int, qFlags int, qSpare varchar(64)
    [JHELENIAK] Query Tables: DICOMStudies
    [JHELENIAK] Columns : StudyInsta, StudyDate, StudyTime, StudyID, StudyDescr, AccessionN, ReferPhysi, PatientsAg, PatientsWe, StudyModal, PatientNam, PatientBir, PatientSex, PatientID, AccessTime, qTimeStamp, qFlags, qSpare
    [JHELENIAK] Where : PatientID = '123456'
    [JHELENIAK] Order : (null)
    [JHELENIAK] Add to Table: XDICOMStudies
    [JHELENIAK] Columns: StudyInsta, StudyDate, StudyTime, StudyID, StudyDescr, AccessionN, ReferPhysi, PatientsAg, PatientsWe, StudyModal, PatientNam, PatientBir, PatientSex, PatientID, AccessTime, qTimeStamp, qFlags, qSpare
    [JHELENIAK] Values: '1.2.826.0.1.3680043.2.135.734570.57906475.7.1331292644.921.46', '19980414', '203538.960689', '0009703828', ' ', '', '', '', '', 'CT', 'HEAD EXP2', '', 'O', '123456', '1331294880', '', '', ''
    [JHELENIAK] Create Table: XDICOMSeries
    [JHELENIAK] Columns : SeriesInst varchar(64), SeriesNumb varchar(12), SeriesDate char(8) , SeriesTime varchar(16), SeriesDesc varchar(64), Modality varchar(16), PatientPos varchar(16), ContrastBo varchar(64), Manufactur varchar(64), ModelName varchar(64), BodyPartEx varchar(64), ProtocolNa varchar(64), StationNam varchar(16), Institutio varchar(64), FrameOfRef varchar(64), SeriesPat varchar(64), StudyInsta varchar(64), AccessTime int, qTimeStamp int, qFlags int, qSpare varchar(64)
    [JHELENIAK] Query Tables: DICOMSeries
    [JHELENIAK] Columns : SeriesInst, SeriesNumb, SeriesDate, SeriesTime, SeriesDesc, Modality, PatientPos, ContrastBo, Manufactur, ModelName, BodyPartEx, ProtocolNa, StationNam, Institutio, FrameOfRef, SeriesPat, StudyInsta, AccessTime, qTimeStamp, qFlags, qSpare
    [JHELENIAK] Where : SeriesPat = '123456'
    [JHELENIAK] Order : (null)
    [JHELENIAK] Add to Table: XDICOMSeries
    [JHELENIAK] Columns: SeriesInst, SeriesNumb, SeriesDate, SeriesTime, SeriesDesc, Modality, PatientPos, ContrastBo, Manufactur, ModelName, BodyPartEx, ProtocolNa, StationNam, Institutio, FrameOfRef, SeriesPat, StudyInsta, AccessTime, qTimeStamp, qFlags, qSpare
    [JHELENIAK] Values: '1.2.826.0.1.3680043.2.135.734570.57906475.7.1331292644.921.47', ' 1', '19980414', '170346.000000', '', 'CT', 'HFS', 'NONE', 'Philips Medical Systems', 'AVE1', '', '1', '', '', '1.2.826.0.1.3680043.2.135.734570.57906475.7.1331292644.921.48', '123456', '1.2.826.0.1.3680043.2.135.734570.57906475.7.1331292644.921.46', '1331294880', '', '', ''
    [JHELENIAK] Create Table: XDICOMImages
    [JHELENIAK] Columns : SOPInstanc varchar(64), SOPClassUI varchar(64), ImageNumbe varchar(12), ImageDate char(8) , ImageTime varchar(16), EchoNumber varchar(64), NumberOfFr varchar(12), AcqDate char(8) , AcqTime varchar(16), ReceivingC varchar(16), AcqNumber varchar(12), SliceLocat varchar(16), SamplesPer varchar(5), PhotoMetri varchar(16), Rows varchar(5), Colums varchar(5), BitsStored varchar(5), ImageType varchar(128), ImageID varchar(16), ImagePat varchar(64), SeriesInst varchar(64), AccessTime int, qTimeStamp int, qFlags int, qSpare varchar(64), ObjectFile varchar(255), DeviceName varchar(32)
    [JHELENIAK] Query Tables: DICOMImages
    [JHELENIAK] Columns : SOPInstanc, SOPClassUI, ImageNumbe, ImageDate, ImageTime, EchoNumber, NumberOfFr, AcqDate, AcqTime, ReceivingC, AcqNumber, SliceLocat, SamplesPer, PhotoMetri, Rows, Colums, BitsStored, ImageType, ImageID, ImagePat, SeriesInst, AccessTime, qTimeStamp, qFlags, qSpare, ObjectFile, DeviceName
    [JHELENIAK] Where : ImagePat = '123456'
    [JHELENIAK] Order : (null)
    [JHELENIAK] Add to Table: XDICOMImages
    [JHELENIAK] Columns: SOPInstanc, SOPClassUI, ImageNumbe, ImageDate, ImageTime, EchoNumber, NumberOfFr, AcqDate, AcqTime, ReceivingC, AcqNumber, SliceLocat, SamplesPer, PhotoMetri, Rows, Colums, BitsStored, ImageType, ImageID, ImagePat, SeriesInst, AccessTime, qTimeStamp, qFlags, qSpare, ObjectFile, DeviceName
    [JHELENIAK] Values: '1.2.826.0.1.3680043.2.135.734570.57906475.7.1331292644.906.44', '1.2.840.10008.5.1.4.1.1.2', '2000', '19980414', '170346.000000', '', '', '19980414', '', '', ' 1', '-91.000000', '1', 'MONOCHROME2', '320', '320', '12', 'ORIGINAL\PRIMARY\AXIAL\NORMAL', '', '123456', '1.2.826.0.1.3680043.2.135.734570.57906475.7.1331292644.921.47', '1331294880', '', '', '', '123456\1.2.826.0.1.3680043.2.135.734570.57906475.7.1331292644.921.47_0001_002000_13312948860000.dcm', 'MAG0'
    [JHELENIAK] Add to Table: XDICOMImages

    nice!


    things have been better. every now and then a connection error happens but fixes itself after 60 second timeouts and retries. once or twice a day max and sometimes not for days. Usually not having any kind of network issues when it happens which is strange.


    20111011 12:22:35 *** ExportConverter5.1: Forward failed to send DICOM image to XXXXXXX 20111011 12:22:35 *** Queue: holding processing of file C:\nradstore\data\1401-33\1.2.840.113619.2.80.975376958.21870.1318346688.1.4.1_0550_000055_1318350039c4f1.dcm 20111011 12:22:35 *** Queue: holding processing of file C:\nradstore\data\1401-33\1.2.840.113619.2.80.975376958.21870.1318346688.1.4.1_0550_000031_1318350039c4f2.dcm 20111011 12:22:35 *** Queue: holding processing of file C:\nradstore\data\1401-33\1.2.840.113619.2.80.975376958.21870.1318346688.1.4.1_0550_000037_1318350039c4f3.dcm 20111011 12:22:35 *** Queue: holding processing of file C:\nradstore\data\1401-33\1.2.840.113619.2.80.975376958.21870.1318346688.1.4.1_0550_000052_1318350039c4f4.dcm 20111011 12:22:35 *** Queue: holding processing of file C:\nradstore\data\1401-33\1.2.840.113619.2.80.975376958.21870.1318346688.1.4.1_0550_000039_1318350040c4f5.dcm 20111011 12:22:35 *** Queue: holding processing of file C:\nradstore\data\1401-33