Hi, Marcel
I'd like to use dgate command to delete images older than 3 years of all patients.
I'd like to delete only the dicom images with the condition above, not the patients.
How could I use dgate command line to do it?
Regards,
Luiz
Hi, Marcel
I'd like to use dgate command to delete images older than 3 years of all patients.
I'd like to delete only the dicom images with the condition above, not the patients.
How could I use dgate command line to do it?
Regards,
Luiz
in multiple steps, e.g.
dgate --deletestudies:19000101-20093112
dgate --deletestudies:20100101-20103112
etc
dgate --deletestudies:20180101-20181028
be careful!
Marcel
Wait to start a new one when the first is done. Deleting a year's worth can take a long time. So maybe do it in smaller steps.
Thanks Marcel, I will try.
Is possible I get a list of fullpath of the dicom images that will be deleted?
I'd like to generate a text file list with fullpath of the files that will be deleted, such as I can check them before.
If yes, could you show me how to do it?
Regards,Luiz
Hi Luiz,
If you want do this, you will need to use lua scripting. Download zerobrane studio and run the conquest install script.
There is a command dicomquery that can be used to list the files (you can query on filename)
There is a command dicomdelete that you can pass the same query.
Marcel
Hi, I downloaded zerobanestudio and I i installed the lua install script
In this script, How can I list the the complete dicom images filepath found?
Hi,
like this (this list can be very long):
Marcel
Hi !
need you help
I deleted images incorrectly (I deleted dicom files from the folder where they were) .
how to delete the patients id (very many id numbers) from the database now
dgate --deletestudies: date(range) this command does not delete the patients id from database
Is a full regeneration an option?
Marcel
?
nooo
how delete id patients in date(range)
Ok,
Which version are you on?
you can use console.bat or "dgate --lua:" to execute lua scripts that execute normal sql commands
e.g. sql([[delete from DICOMimages where ImagePat like '1%']])
or dgata --lua:"sql([[delete from DICOMimages where ImagePat like '1%']])"
or use your favorite database console.
Best backup the database before you start....
Marcel
Just looked, only with lua you can do what you ask.
q = DicomObject:new(); q.StudyDate='20110101-20111231; q=StudyInstanceUID=''; q.SeriesInstanceUID=''; q.SOPInstanceUID=''; newdicomdelete(q, true)
Use with utmost care, The true in the statement means it processes the database only.
Backup first!
Marcel
Display MoreJust looked, only with lua you can do what you ask.
q = DicomObject:new(); q.StudyDate='20110101-20111231; q=StudyInstanceUID=''; q.SeriesInstanceUID=''; q.SOPInstanceUID=''; newdicomdelete(q, true)
Use with utmost care, The true in the statement means it processes the database only.
Backup first!
Marcel
Sorry I am wrong, that would not do it!
I can potentially create a version that can.
Marcel
Hm, not sure now (lots of old code);
try:
q = DicomObject:new(); q.StudyDate='20110101-20111231; q=StudyInstanceUID=''; q.SeriesInstanceUID=''; q.SOPInstanceUID=''; dicomdelete(q)
Marcel
No; sorry - you need to use sql or I need to create an updated version.
Hi !
I have
Hi,
and what database?
Marcel
SQL Server 2019 Developer
Don’t have an account yet? Register yourself now and be a part of our community!