Posts by marcelvanherk

marcelvanherk · Sep 17th 2009

Hi,

Use filenamesyntax = 10 in dicom.ini

Marcel

marcelvanherk · Sep 17th 2009

Hi,

some archives are quite picky ;->>>

Marcel

marcelvanherk · Sep 17th 2009

Hi,

can you show what happens on the sending side? And maybe with debug logging. That would make it easier to track the problem.

Marcel

marcelvanherk · Sep 17th 2009

Hi,

can you summarize what happens with excerpts from the logs?

Marcel

marcelvanherk · Sep 17th 2009

Hi,

I do not know. Show me the error message on the server.

Marcel

marcelvanherk · Sep 17th 2009

Hi,

maybe: the image database stores object file names with \ for windows paths and / for linux paths. This is the only difference. If you would store images without a path, it would work.

Marcel

marcelvanherk · Sep 16th 2009

Hi,

can you provide detailed debug logging around the time of the simulated problem?

Marcel

marcelvanherk · Sep 16th 2009

Hi,

It defitively is. There is a working? make script in 1.4.15alpha.

Marcek

marcelvanherk · Sep 16th 2009

Hi,

Try 1.4.15alpha.

Marcel

marcelvanherk · Sep 15th 2009

Hi,

if you double click on the label, query switches to UID mode. Do you see that?

Marcel

marcelvanherk · Sep 14th 2009

Hi,

have a look in Management - Database maintenance plans

This should be set to reindex weekly

And right click the database - properties - Data files

here is the option to autogrow the database

Marcel

marcelvanherk · Sep 13th 2009

I will put it there!

Marcel

marcelvanherk · Sep 13th 2009

Hi,

Try:

Importconverter0 = ifempty "%V0010,0020"; destroy

Marcel

marcelvanherk · Sep 13th 2009

Hi,

ImportConverter0 = newuids

Marcel

marcelvanherk · Sep 13th 2009

Hi,

what version of mssql?

Marcel

marcelvanherk · Sep 13th 2009

Hi,

what exactly did you use as export converter?

Marcel

marcelvanherk · Sep 9th 2009

Hi,

That seems to be the correct address..

Marcel

marcelvanherk · Sep 6th 2009

Hi,

off course, if the data is not yet in the server, you can use an ExportConverter with as many tags as you like:

ExportConverter = 1
ExportConverter0 = append "%V0010,0010[tab]%Vxxxx,yyyy%n" to summary.file

If you want a tab separated file, you will have to enter the tabs into dicom,ini as hard tabs, there is not alias character for a tab yet.

If the data is in the server you can use an updated dicom.sql with items for dose awareness. If you edit or replace your dicom.sql YOU ALWAYS HAVE TO REGERENERATE THE DATABASE. Failure to do so, will cripple the server.

The below definition is denormalized for dbaseIII use.

You can then use your favorite database tool or even the (terse) dgate --query command to query the database.

Marcel

Code

*Patient*
{
	{ 0x0010, 0x0020, "PatientID", 64, SQL_C_CHAR, DT_STR },
	{ 0x0010, 0x0010, "PatientName", 64, SQL_C_CHAR, DT_STR },
        { 0x0010, 0x0030, "PatientBirthDate", 8, SQL_C_DATE, DT_DATE },
	{ 0x0010, 0x0040, "PatientSex", 16, SQL_C_CHAR, DT_STR }
}


*Study*
{
	{ 0x0020, 0x000d, "StudyInstanceUID", 64, SQL_C_CHAR, DT_UI },
	{ 0x0008, 0x0020, "StudyDate", 8, SQL_C_DATE, DT_DATE },
	{ 0x0008, 0x0030, "StudyTime", 16, SQL_C_CHAR, DT_TIME },
	{ 0x0020, 0x0010, "StudyID", 16, SQL_C_CHAR, DT_STR },
	{ 0x0008, 0x1030, "StudyDescription", 64, SQL_C_CHAR, DT_STR },
	{ 0x0008, 0x0050, "AccessionNumber", 16, SQL_C_CHAR, DT_STR },


	{ 0x0008, 0x0090, "ReferPhysician", 64, SQL_C_CHAR, DT_STR },
 	{ 0x0032, 0x1032, "ReqPhysician",       64, SQL_C_CHAR, DT_STR },
	{ 0x0008, 0x0080, "Institution", 64, SQL_C_CHAR, DT_STR },
	{ 0x0008, 0x1040, "Department", 64, SQL_C_CHAR, DT_STR },


	{ 0x0010, 0x1010, "PatientsAge", 16, SQL_C_CHAR, DT_STR },
	{ 0x0010, 0x1030, "PatientsWeight", 16, SQL_C_CHAR, DT_STR },
	{ 0x0008, 0x0061, "StudyModality", 64, SQL_C_CHAR, DT_MSTR },


	{ 0x0010, 0x0010, "PatientName", 64, SQL_C_CHAR, DT_STR },
        { 0x0010, 0x0030, "PatientBirthDate", 8, SQL_C_DATE, DT_DATE },
	{ 0x0010, 0x0040, "PatientSex", 16, SQL_C_CHAR, DT_STR }


	{ 0x0010, 0x0020, "PatientID", 64, SQL_C_CHAR, DT_STR }
}


*Series*
{
	{ 0x0020, 0x000e, "SeriesInstanceUID", 64, SQL_C_CHAR, DT_UI },
	{ 0x0020, 0x0011, "SeriesNumber", 12, SQL_C_CHAR, DT_STR },
	{ 0x0008, 0x0021, "SeriesDate", 8, SQL_C_DATE, DT_DATE },
	{ 0x0008, 0x0031, "SeriesTime", 16, SQL_C_CHAR, DT_TIME },
	{ 0x0008, 0x103e, "SeriesDescription", 64, SQL_C_CHAR, DT_STR },
	{ 0x0008, 0x0060, "Modality", 16, SQL_C_CHAR, DT_STR },
	{ 0x0018, 0x5100, "PatientPosition", 16, SQL_C_CHAR, DT_STR },
	{ 0x0018, 0x0010, "ContrastBolusAgent", 64, SQL_C_CHAR, DT_STR },
	{ 0x0008, 0x0070, "Manufacturer", 64, SQL_C_CHAR, DT_STR },
	{ 0x0008, 0x1090, "ModelName", 64, SQL_C_CHAR, DT_STR },
	{ 0x0018, 0x0015, "BodyPartExamined", 64, SQL_C_CHAR, DT_STR },
	{ 0x0018, 0x1030, "ProtocolName", 64, SQL_C_CHAR, DT_STR },
	{ 0x0008, 0x1010, "StationName", 16, SQL_C_CHAR, DT_STR },
	{ 0x0008, 0x0080, "Institution", 64, SQL_C_CHAR, DT_STR },
	{ 0x0020, 0x0052, "FrameOfReferenceUID", 64, SQL_C_CHAR, DT_UI },
	{ 0x0010, 0x0020, "SeriesPat", 64, SQL_C_CHAR, DT_STR },


	{ 0x0010, 0x0010, "PatientName", 64, SQL_C_CHAR, DT_STR },
        { 0x0010, 0x0030, "PatientBirthDate", 8, SQL_C_DATE, DT_DATE },
	{ 0x0010, 0x0040, "PatientSex", 16, SQL_C_CHAR, DT_STR }


	{ 0x0008, 0x0020, "StudyDate", 8, SQL_C_DATE, DT_DATE },
	{ 0x0008, 0x0030, "StudyTime", 16, SQL_C_CHAR, DT_TIME },
	{ 0x0020, 0x0010, "StudyID", 16, SQL_C_CHAR, DT_STR },
	{ 0x0008, 0x1030, "StudyDescription", 64, SQL_C_CHAR, DT_STR },


	{ 0x0008, 0x0090, "ReferPhysician", 64, SQL_C_CHAR, DT_STR },
 	{ 0x0032, 0x1032, "ReqPhysician",       64, SQL_C_CHAR, DT_STR },
	{ 0x0008, 0x1040, "Department", 64, SQL_C_CHAR, DT_STR },


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


*Image*
{
	{ 0x0008, 0x0018, "SOPInstanceUID", 64, SQL_C_CHAR, DT_UI },
	{ 0x0008, 0x0016, "SOPClassUID", 64, SQL_C_CHAR, DT_UI },
	{ 0x0020, 0x0013, "ImageNumber", 12, SQL_C_CHAR, DT_STR },
	{ 0x0008, 0x0023, "ImageDate", 8, SQL_C_DATE, DT_DATE },
	{ 0x0008, 0x0033, "ImageTime", 16, SQL_C_CHAR, DT_TIME },
	{ 0x0018, 0x0086, "EchoNumber", 64, SQL_C_CHAR, DT_MSTR },
	{ 0x0028, 0x0008, "NumberOfFrames", 12, SQL_C_CHAR, DT_STR },
	{ 0x0008, 0x0022, "AcqDate", 8, SQL_C_DATE, DT_DATE },
	{ 0x0008, 0x0032, "AcqTime", 16, SQL_C_CHAR, DT_TIME },
	{ 0x0018, 0x1250, "ReceivingCoil", 16, SQL_C_CHAR, DT_STR },
	{ 0x0020, 0x0012, "AcqNumber", 12, SQL_C_CHAR, DT_STR },
	{ 0x0020, 0x1041, "SliceLocation", 16, SQL_C_CHAR, DT_STR },
	{ 0x0028, 0x0002, "SamplesPerPixel", 5, SQL_C_CHAR, DT_UINT16 },
	{ 0x0028, 0x0004, "PhotoMetricInterpretation", 16, SQL_C_CHAR, DT_STR },
	{ 0x0028, 0x0010, "Rows", 5, SQL_C_CHAR, DT_UINT16 },
	{ 0x0028, 0x0011, "Colums", 5, SQL_C_CHAR, DT_UINT16 },
	{ 0x0028, 0x0101, "BitsStored", 5, SQL_C_CHAR, DT_UINT16 },
	{ 0x0008, 0x0008, "ImageType", 128, SQL_C_CHAR, DT_MSTR },
	{ 0x0054, 0x0400, "ImageID", 16, SQL_C_CHAR, DT_STR },
	{ 0x0010, 0x0020, "ImagePat", 64, SQL_C_CHAR, DT_STR },


	{ 0x0018, 0x0050, "SliceThickness", 16, SQL_C_CHAR, DT_STR },
	{ 0x0018, 0x0060, "KVP", 16, SQL_C_CHAR, DT_STR },
	{ 0x0018, 0x0072, "EffectiveDuration", 16, SQL_C_CHAR, DT_STR },
	{ 0x0018, 0x0090, "DataCollectionDiameter", 16, SQL_C_CHAR, DT_STR },
	{ 0x0018, 0x1150, "ExposureTime", 16, SQL_C_CHAR, DT_STR },
	{ 0x0018, 0x1151, "XRayTubeCurrent", 16, SQL_C_CHAR, DT_STR },
	{ 0x0018, 0x1152, "Exposure", 16, SQL_C_CHAR, DT_STR },
	{ 0x0018, 0x1153, "ExposureMuas", 16, SQL_C_CHAR, DT_STR },
	{ 0x0018, 0x1154, "AvgPulseWidth", 16, SQL_C_CHAR, DT_STR },
	{ 0x0018, 0x1155, "RadiationSetting", 16, SQL_C_CHAR, DT_STR },
	{ 0x0018, 0x115a, "RadiationMode", 16, SQL_C_CHAR, DT_STR },
	{ 0x0018, 0x1170, "GeneratorPower", 16, SQL_C_CHAR, DT_STR },
	{ 0x0018, 0x1181, "CollimationType", 16, SQL_C_CHAR, DT_STR },
	{ 0x0018, 0x1302, "ScanLength", 16, SQL_C_CHAR, DT_STR },
	{ 0x0018, 0x9311, "SpiralPitchFactor", 16, SQL_C_CHAR, DT_STR },
	{ 0x0018, 0x9306, "SingleCollimationWidth", 16, SQL_C_CHAR, DT_STR },
	{ 0x0018, 0x9307, "TotalCollimationWidth", 16, SQL_C_CHAR, DT_STR },
	{ 0x0018, 0x9323, "ExposureModulationType", 16, SQL_C_CHAR, DT_STR },
	{ 0x0018, 0x9305, "RevolutionTime", 16, SQL_C_CHAR, DT_STR },
	{ 0x0020, 0x0032, "ImagePositionPatient", 64, SQL_C_CHAR, DT_STR },


	{ 0x0018, 0x0015, "BodyPartExamined", 64, SQL_C_CHAR, DT_STR },
	{ 0x0018, 0x1030, "ProtocolName", 64, SQL_C_CHAR, DT_STR },
	{ 0x0008, 0x0070, "Manufacturer", 64, SQL_C_CHAR, DT_STR },
	{ 0x0008, 0x1090, "ModelName", 64, SQL_C_CHAR, DT_STR },
	{ 0x0008, 0x0090, "ReferPhysician", 64, SQL_C_CHAR, DT_STR },
 	{ 0x0032, 0x1032, "ReqPhysician",       64, SQL_C_CHAR, DT_STR },
	{ 0x0008, 0x0080, "Institution", 64, SQL_C_CHAR, DT_STR },
	{ 0x0008, 0x1040, "Department", 64, SQL_C_CHAR, DT_STR },
	{ 0x0018, 0x0010, "ContrastBolusAgent", 64, SQL_C_CHAR, DT_STR },


	{ 0x0010, 0x0010, "PatientName", 64, SQL_C_CHAR, DT_STR },
        { 0x0010, 0x0030, "PatientBirthDate", 8, SQL_C_DATE, DT_DATE },
	{ 0x0010, 0x0040, "PatientSex", 16, SQL_C_CHAR, DT_STR }


	{ 0x0020, 0x000d, "StudyInstanceUID", 64, SQL_C_CHAR, DT_UI },
	{ 0x0008, 0x0020, "StudyDate", 8, SQL_C_DATE, DT_DATE },
	{ 0x0008, 0x0030, "StudyTime", 16, SQL_C_CHAR, DT_TIME },
	{ 0x0020, 0x0010, "StudyID", 16, SQL_C_CHAR, DT_STR },
	{ 0x0008, 0x1030, "StudyDescription", 64, SQL_C_CHAR, DT_STR },


	{ 0x0020, 0x0011, "SeriesNumber", 12, SQL_C_CHAR, DT_STR },
	{ 0x0008, 0x0021, "SeriesDate", 8, SQL_C_DATE, DT_DATE },
	{ 0x0008, 0x0031, "SeriesTime", 16, SQL_C_CHAR, DT_TIME },
	{ 0x0008, 0x103e, "SeriesDescription", 64, SQL_C_CHAR, DT_STR },
	{ 0x0008, 0x0060, "Modality", 16, SQL_C_CHAR, DT_STR },
	{ 0x0018, 0x5100, "PatientPosition", 16, SQL_C_CHAR, DT_STR },
	{ 0x0020, 0x0052, "FrameOfReferenceUID", 64, SQL_C_CHAR, DT_UI },


	{ 0x0020, 0x000e, "SeriesInstanceUID", 64, SQL_C_CHAR, DT_UI }
}


*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" },


 	{ 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 }
}

Display More

marcelvanherk · Sep 3rd 2009

Hi,

you should probably write your own small monitor program that runs "dgate --addimagefile:filename" for every file it finds (this is what drag and drop uses) and then deletes the file.

Marcel

marcelvanherk · Sep 3rd 2009

Hi,

if the information is in the database, you could query it in different ways. But if it is not, you are stuck. I would edit the database definition and regenerate it. Is this for a patient dose estimation project? I have a modified dicom.sql for that.

Marcel

Posts by marcelvanherk

USB Drive

DICOM Move Error:Remote DICOM error

Missing image

Missing image

ClearCanvas unable to pull from Conquest

USB Drive

Missing image

Is it possible now to run ConQuest under Linux using MySQL?

Anonymization

DICOM Move Error:Remote DICOM error

Willl probably lose my job over this...

Reject empty Patient ID

Reject empty Patient ID

Anonymization

Willl probably lose my job over this...

Dump dicom info to an excel file

institution

Dump dicom info to an excel file

Import From Folder

Dump dicom info to an excel file