Hi,
I am trying to 'harvest' some additional dicom tags to readout additional information from the dicom objects.
I did this by editing the dicom.sql file and adding some additonal items (see below).
This works nicely, after re-initialising and restarting, there are additional columns in the table wich are also filled !!
However : the dicom send action does not work anymore and gives the following error :
**************
[LOCALPACS] Presentation Context 2 "1.2.840.10008.5.1.4.1.2.3.2" 1
[LOCALPACS] C-Move Destination: "CONQUESTSRV2 "
[LOCALPACS] *** ERROR: column dicomseries.imageposit does not exist LINE 1: ...OMStudies.StudyInsta and DICOMImages.ImagePosit = DICOMSerie... ^
[LOCALPACS] C-Move (StudyRoot)
[LOCALPACS] UPACS THREAD 541: ENDED AT: Tue Jun 16 10:46:19 2015
***********
what am I doing wrong ???
Thanks in advance !
René Monshouwer
An tail of the *Image* part of the dicom.sql file:
-----------------------------------------------
ORIGINAL dicom.sql
---------------------
{ 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 },
{ 0x0020, 0x000e, "SeriesInstanceUID", 64, SQL_C_CHAR, DT_UI }
}
-----------------------------------------------
Changed dicom.sqlsql
------------------
{ 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 },
{ 0x0020, 0x0037, "ImageOrientationPatient", 256, SQL_C_CHAR, DT_STR },
{ 0x0008, 0x0060, "Modality", 256, SQL_C_CHAR, DT_STR },
{ 0x0008, 0x103e, "SeriesDescription", 256, SQL_C_CHAR, DT_STR },
{ 0x0020, 0x000e, "SeriesInstanceUID", 64, SQL_C_CHAR, DT_UI }
{ 0x0020, 0x0032, "ImagePositionPatient", 256, SQL_C_CHAR, DT_STR },