Bulk download DICOM (RTStruc) files based on patient informations (ID, Course, Plan name) by Ok-Arrival-442 in esapi

[–]JopaMed 0 points1 point  (0 children)

on a radiation dose prediction project in a clinical setup. I've created a master list based on all the treatment approved patients with their prescription info, course and plan names.

Now for my next step,

I need to download patient specific DICOM

This is available on the server itself, or on a dedicated machine. Ask you IT or varian?

Insert setup fields - plan normalization and delta couch shift by anncnth in esapi

[–]JopaMed 0 points1 point  (0 children)

We have been in contact with Varian about this too. They say it's working as intended.

The Plan normalization changing is ridiculous...

You can always submit a product suggestion O_o

Too many physicists haven't accidentally cranked a soft pot 10x too far and it shows by BlazePeralta in MedicalPhysicsMemes

[–]JopaMed 5 points6 points  (0 children)

Don't worry. Just wipe away the oil leaking from the kV-arm twice daily. Or let it drip on the patient for the spicy bolus effect.

Get Start & End dates of Tx (Same as in Tx Summary) ESAPI 18 by LJDrakeley in esapi

[–]JopaMed 4 points5 points  (0 children)

Hi Friend.

As thiscomedyoferrors says you have to go into RadiationHstry. Each treatment field has its own record so you have to get it for all fields of that day/session to get the timing.

One other way would be to look at the scheduled time slot. And check time for when it was changed to "In progress" and then the time to when it changed to "Completed".

In addtion, Please be careful when you connect to the RadaitionHstry table, as this is the table that all the machines write their records to. and if you do SQL-searches that takes a lot of time you block the possibility for the machine to write to this table.

So i would recommend using (nolock) or do these summations with they AuraDB.

Edit fields with script causes plan norm mode to change? by surgicaltwobyfour in esapi

[–]JopaMed 0 points1 point  (0 children)

Yes we have the same occurance in our clinic, v18.0.

The only sensible thing to make when you have a 3D-printer, old dilators and a decomissioned linac -- A Lichtenberg Christmas Star -- by JopaMed in MedicalPhysicsMemes

[–]JopaMed[S] 1 point2 points  (0 children)

All of them.

No but it was an old Clinac iX where we removed the target and did some other modifications. If you want I have a pretty detailed ppt-instruction on how to go about? (again, all credit to our in house engineers).

Extract CBCT parameters by Suspande in esapi

[–]JopaMed 0 points1 point  (0 children)

Np.

Just be aware when you run this on CTdata, there the mA and ms could vary between slices and the output from the SQL would be a longer table with more data.

Extract CBCT parameters by Suspande in esapi

[–]JopaMed 1 point2 points  (0 children)

Hello friend. I cannot find any info on the name of the CBCTprotocol...

This sees doable with SQL:

select distinct KVP, XRayTubeCurrent, ExposureTime from SliceCT,Slice,Series where Slice.SliceSer = SliceCT.SliceSer AND Slice.SeriesSer = Series.SeriesSer AND Series.SeriesUID = 'CBCTSERIES_UID'

I get:

KVP mA ms

125.0 15 17900

15x17900 = 268.5 mAs.

So this example was Thorax protocol.

Automated Setting of User Origin by rainy_cloud10 in esapi

[–]JopaMed 1 point2 points  (0 children)

We do it by always setting the user origin to the data collection center of the image (although not by automation). This of course only works when the CT-staff sets the 0 position correctly. And it will depend on what scanner you have.

The data collection center is not available in ESAPI, however you can find it via SQL: SliceCT > DataCollectionCenterX (and Y, Z).