RTPlan Update Dicom TAG

Saudy · Mar 10th 2025

I am trying to update Database , dicom.sql and dicom.ini to save all radiation plan data in Sql server database all field are Null except Gantry and Collimator angle .

dicom.ini

ExportConverters = 1

ExportConverter0 = ifequal "%modality", "RTPLAN"; modifyobject "%(300A,00C3)" "%BeamName"; modifyobject "%(300A,0114)" "%Energy"; modifyobject "%(300A,011C)" "%LeafJawPositions";

Please any help

marcelvanherk · Mar 10th 2025

Hi, a radiation plan is an array of control points, that contain e.g. many gantry angles, leaf positions etc. So it is not possible to store these in a single database field. I also do not know what "modifyobject" means. And anyway anything in an exportconnverter runs after the image is stored in the database.

Marcel

Saudy · Mar 11th 2025

Hi Marcel

thank you so much , Please can you give me example for do the array for control point .

Saudy

marcelvanherk · Mar 11th 2025

Hi,

you can use Lua to read it, e.g. by starting a script for each received item:

ImportConverter0 = lua/yourfile.lua

And then e.g. there (this is for an RTSTRUCT, princliple is the same for an RTPLAN:

if Data.Modality=='RTSTRUCT' then

for i=0, #Data.StructureSetROISequence-1 do

print('*** frameofref', i, Data.StructureSetROISequence[i].ReferencedFrameOfReferenceUID)

end;

for i=0, #Data.ROIContourSequence-1 do

for j=0, #Data.ROIContourSequence[i].ContourSequence-1 do

for k=0, #Data.ROIContourSequence[i].ContourSequence[j].ContourImageSequence-1 do

print('*** r sop', i, j, k, Data.ROIContourSequence[i].ContourSequence[j].ContourImageSequence[k].ReferencedSOPInstanceUID)

end

Marcel

Saudy · Mar 12th 2025

Dear Mr.Marcel

thank you so much for your help your example code its working for save gantry and collimator only

i am tray to save MU,Energy ,X,Y ,MLC etc.. from RTPlan by this code For Dose Details

Please for your help .

Code

if Data.Modality=='RTPLAN' then

for i=0, #Data.FractionGroupSequenc-1 do
print('*** frameofref', i, Data.FractionGroupSequenc[i].FrameOfReferenceUID)
end;

for i=0, #Data.ReferencedBeamSequen-1 do
for j=0, #Data.BeamSequence[i].BeamLimitingDeviceSe-1 do
print('*** r sop', i, j, Data.BeamSequence[i].BeamLimitingDeviceSe[j].ReferencedSOPInstanceUID)
end
end

Display More

marcelvanherk · Mar 12th 2025

Hi,

you need to use the full names e.g. FractionGroupSequence

Marcel

Saudy · Mar 13th 2025

Hi,

still all value are Null except Gantry and Collimator angle

i try more time by RtPaln ,RtIMAGE but still not working

any way thank you for your help .

Code

if Data.Modality=='RTPPLAN' then

for i=0, #Data.RTDosePlan-1 do

print('*** frameofref', i, Data.RTDosePlan[i].ReferencedFrameOfReferenceUID)

end;

for i=0,#Data.FractionGroupSequenc-1 do

for j=0,#Data.FractionGroupSequenc[i].ReferencedBeamSequenc-1 do

for k=0,#Data.FractionGroupSequenc[i].BeamSequence-1 do  

for w=0,#Data.FractionGroupSequenc[i].BeamSequence[k].BeamLimitingDeviceSequenc-1 do 
 
for a=0    ,#Data.FractionGroupSequenc[i].BeamSequence[k].ControlPointSequence-1 do
for a1=0,#Data.FractionGroupSequenc[i].BeamSequence[k].ControlPointSequence[a].BeamLimitingDevicePosation-1 do
for a2=0,#Data.FractionGroupSequenc[i].BeamSequence[k].ControlPointSequence[a].BeamLimitingDevicePosation[a1].BeamLimitingDeviceSequenc-1 do 
for s=0 ,#Data.FractionGroupSequenc[i].ReferencedStructureSequenc-1 do 

print('*** r sop', i,s, #Data.FractionGroupSequenc[i].ReferencedStructureSequenc[s].ReferencedSOPInstanceUID)


end
end
end
end
end
end
end
end

Display More

marcelvanherk · Mar 13th 2025

BeamLimitingDeviceSequenc --> BeamLimitingDeviceSequence

ReferencedStructureSequenc -.> ReferencedStructureSequence

FractionGroupSequenc --> FractionGroupSequenc

Then the code may run. It should print info from the RTPLAN to the server's log window when it recieves one. The attached script shows an example script modifying tags in an rtlan. Use with care

Marcel

Saudy · Mar 15th 2025

Hi

Marcel

Please check for this Code

thank you

Code

if Data.Modality=='RTPLAN' then
 print('Processing RTPLAN for patient Name ' .. Data.PatientName .. ' PatientID=' .. Data.PatientID);
  print('Date of RTPLAN is ' .. Data.RTPlanDate);

  local i
  for i=0, #Data.FractionGroupSequence-1 do
  for j =0,#Data.FractionGroupSequence[i].ReferencedBeamSequence-1 do 
    if #Data.FractionGroupSequence[i]ReferencedBeamSequence[j].BeamMeterset then
      print('MU ' ,i,j,#Data.FractionGroupSequence[i]ReferencedBeamSequence[j].BeamMeterset);
         print('NumberOfBeams 'i,j,#Data.FractionGroupSequence[i]ReferencedBeamSequence[j].NumberOfBeams);
             else 
     print('MU for field ', i ,j,' is 0 or a nil value');
    end
  end
end 
end

Display More

[LINACDATA] ***Exportconverter0: Spawning 'lua\UpdateImage.lua' failed (argv=e:\dicomserver150e\data\524070\1.3.6.1.4.1.2452.6.1535943060.1322677368.330235017.3277645119_0001_000000_1742057454000d.dcm)

marcelvanherk · Mar 15th 2025

ImportConverter0 = lua/yourfile.lua

use a / not a \

In your code line 10 misses a .

A simple way to test this code is in the GUI - modify image (advanced)

This is the correct syntax:

Code

-- Enter Lua code to modify DICOM images here
-- E.g., Data.SeriesDescription = 'First series'
if Data.Modality=='RTPLAN' then
  print('Processing RTPLAN for patient Name ' .. Data.PatientName .. ' PatientID=' .. Data.PatientID);
  print('Date of RTPLAN is ' .. Data.RTPlanDate);

  local i
  for i=0, #Data.FractionGroupSequence-1 do
    for j=0,#Data.FractionGroupSequence[i].ReferencedBeamSequence-1 do 
      if #Data.FractionGroupSequence[i].ReferencedBeamSequence[j].BeamMeterset>0 then
        print('MU ' ,i,j,#Data.FractionGroupSequence[i].ReferencedBeamSequence[j].BeamMeterset);
        print('NumberOfBeams ',i,j,#Data.FractionGroupSequence[i].ReferencedBeamSequence[j].NumberOfBeams);
      else 
       print('MU for field ', i ,j,' is 0 or a nil value');
      end
    end
  end 
end

Display More

Or install zerobrane studio and link it to conquest (see manual)

Marcel

Saudy · Mar 17th 2025

Dear Marcel

the code is working in Conquest Server but in Database all value are Null

PACSDB] Processing RTImage for patient Name

[PACSDB] FieldSizeX i is 0and j is 0 is -90.00\0.00

[PACSDB] FieldSizeY 0and 0 is -90.00\0.00

[PACSDB] FieldSizeX i is 0and j is 1 is -80.00\80.00

[PACSDB] FieldSizeY 0and 1 is -80.00\80.00

[PACSDB] ***Truncated PatientPos from 56 to 16 chars in file: 535637\1.3.6.1.4.1.2452.6.928084557.1258562412.3879072164.17834433_0001_000002_174219170000be.dcm

[PACSDB] Written file: D:\dicomserver150\Data\535637\1.3.6.1.4.1.2452.6.928084557.1258562412.3879072164.17834433_0001_000002_174219170000be.dcm

[PACSDB] Processing RTImage for patient Name AMAT ALRAHEEM SALEH SALEH ALSMAI^^^^ PatientID=535637

[PACSDB] FieldSizeX i is 0and j is 0 is -100.00\0.00

[PACSDB] FieldSizeY 0and 0 is -100.00\0.00

[PACSDB] FieldSizeX i is 0and j is 1 is -67.50\67.50

[PACSDB] FieldSizeY 0and 1 is -67.50\67.50

[PACSDB] ***Truncated PatientPos from 56 to 16 chars in file: 535637\1.3.6.1.4.1.2452.6.928084557.1258562412.3879072164.17834433_0001_000001_174219170000bf.dcm

[PACSDB] Written file: D:\dicomserver150\Data\535637\1.3.6.1.4.1.2452.6.928084557.1258562412.3879072164.17834433_0001_000001_174219170000bf.dcm

[PACSDB] Processing RTImage for patient Name

[PACSDB] FieldSizeX i is 0and j is 0 is 0.00\90.00

[PACSDB] FieldSizeY 0and 0 is 0.00\90.00

[PACSDB] FieldSizeX i is 0and j is 1 is -80.00\80.00

[PACSDB] FieldSizeY 0and 1 is -80.00\80.00

thanks

marcelvanherk · Mar 17th 2025

Good,

You show that you read any information from a plan. Can you now explain what you actually want to achieve?

Marcel

Saudy · Mar 17th 2025

Hi Marcel

I need to save Field X , Field Y and MLC leaf position in SQL server database .

Thanks 🙏

Saudy

marcelvanherk · Mar 17th 2025

Ok,

the sql database automatically stores any non-sequence item that is listed in dicom.sql. You can maybe sort your problem by using lua to create private elements to the RTPLAN object and define these in dicom.sql so that they are written. However, as I pointed out there can be hundreds of control points so I am not sure how you would code that in a single text string. I think database fields in conquest are limited to 256 characters.

A better solution is to create a database table yourself (you can use lua to do this) and use lua sql() command to write into that and dbquery() to read.

console.bat runs a simple console where you can try any lua code. It stores the history of what you typed.

A bit of example code (from overview.lua in the distribution, it has examples for all lua functions):

sql("CREATE TABLE UserTable (CounterID varchar(99), Val integer)");

sql("INSERT INTO UserTable (CounterID,Val) VALUES ('CT',1) ON DUPLICATE KEY UPDATE Val=Val+1");

Marcel

Saudy · Mar 17th 2025

Ok Marcel I will trying thanks

RTPlan Update Dicom TAG

Participate now!

Share

Similar Threads

Conquest 1.5.0e released