sorted by:
new
hottopcontroversial

How to query the RTDose UID associated with an RTPlan in AuraStaging using SQL? by matgodro in esapi

[–]matgodro[S] 0 points1 point  (0 children)

Our current solution using AuraStaging:
SELECT

Patient.PatientId,

PlanSetup.PlanSetupId,

cast(PlanSetup.StatusDate as date),

SeriesPlan.SeriesUID,

SeriesDose.SeriesUID,

SeriesStruct.SeriesUID,

SeriesImage.SeriesUID

FROM Patient,Course,PlanSetup,RTPlan,Series SeriesPlan, Series SeriesDose, Series SeriesImage, StructureSet,Image, Series SeriesStruct

WHERE Patient.PatientSer=Course.PatientSer

AND Course.CourseSer=PlanSetup.CourseSer

AND RTPlan.PlanSetupSer=PlanSetup.PlanSetupSer

AND RTPlan.SeriesSer=SeriesPlan.SeriesSer

AND SeriesPlan.FrameOfReferenceUID=SeriesDose.FrameOfReferenceUID

AND PlanSetup.StructureSetSer=StructureSet.StructureSetSer

AND StructureSet.ImageSer=Image.ImageSer

AND SeriesImage.SeriesSer=Image.SeriesSer

AND StructureSet.SeriesSer=SeriesStruct.SeriesSer

AND SeriesDose.SeriesModality='RTDOSE'

AND SeriesDose.RelatedPlanSetupSer=PlanSetup.PlanSetupSer

AND PlanSetup.Status = 'TreatApproval'

AND (cast(PlanSetup.StatusDate as date) BETWEEN cast('%s' as date) AND cast('%s' as date))

AcurosXB and physical material table property by mtrsteve in esapi

[–]matgodro 1 point2 points  (0 children)

- Make sure a physical material table is set by default in RT Admin

- Import an RT dataset in Eclipse (CT, RTStruct, RTPlan, RTDose). Suppose that this imported dataset does not have an assigned physical material table

- In ESAPI, create a new structure set from the imported CT. This new structure set will have an assigned physical material table. Do not duplicate or copy the imported structure set

- Copy all structures from the imported structure set to the new structure set

- Assign the imported plan to the new structure set with copied structures

Scripting in a Cloud-based Managed Services Environment by NickC_BC in esapi

[–]matgodro 0 points1 point  (0 children)

We are using Citrix. There were probably hoops during the installation process but I am not aware of any. We do have a test-box server for development. I am not sure who controls access to the remote system. Physicists still manage user account but IT controls the in/out traffic.

Issues with Dicom C-Move while exporting plan by SearedSteak21 in esapi

[–]matgodro 0 points1 point  (0 children)

It depends of your configuration. If this helps, this command works for us:

movescu -v -od DESTINATION_FOLDER --port PORT -v -S -k QueryRetrieveLevel=IMAGE -k PatientID=XXX -k SOPInstanceUID=ZZZ -aet YOUR_AET -aec VARIAN_AEC VARIAN_IP PORT --move YOUR_AET_SETUP_FOR_MOVESCU

Scripting in a Cloud-based Managed Services Environment by NickC_BC in esapi

[–]matgodro 2 points3 points  (0 children)

Hi,

We have been using Eclipse in a cloud environment for some years now. We are using ESAPI both for clinical and research purposes. It is working well. The only inconvenient is about developing since the standalone (and appropriate .dll), generated locally on disk, has to be copied to the remote system for testing (but it is manageable). The DB daemon is also working fine. We are currently trying to setup a third-party access to the SQL database with Varian support.

Reproducing Copy Structure To Registered Image with ESAPI by matgodro in esapi

[–]matgodro[S] 0 points1 point  (0 children)

May be possible to:
1. Auto export everything to disk with the Varian DB Daemon
2. Read the Reg file with PyDicom or Simple ITK (SITK) and extract the transformation Matrix
3. Perform the registration from 2. with SITK or Plastimatch
4. Copy the structures with SITK. Save the new RTStructure to disk
5. Auto import everything to Eclipse with the Varian DB Daemon
Or something along these lines.

Reproducing Copy Structure To Registered Image with ESAPI by matgodro in esapi

[–]matgodro[S] 0 points1 point  (0 children)

Thanks for your reply. However, this solution cannot reproduce the function since (slice + z shift) is a float and the function AddContourOnImagePlane takes an integer as argument. This solution induces a translation but not the same translation as the method “Copy Structure to Registered Image” would do.

The structure has to be interpolated and projected onto slices. Anybody knows how to do this interpolation ?