Posts by jweste

jweste · Aug 18th 2022

Hi, Marcel

Small fixes in wado-rs e thumbnails.

I haven´t touched metadata.

About RTSTRUCT problem I can´t help you because I don´t have skills in dicom enough.

jweste · Aug 18th 2022

Quote from marcelvanherk

e.g.

delete * from DICOMImages where ImageDate>'20100101' and ImageDate<='20101231'

delete * from DICOMSeries where SeriesDate>'20100101' and SeriesDate<='20101231'

delete * from DICOMStudies where StudyDate>'20100101' and StudyDate<='20101231'

delete * from DICOMPatients where WHERE PatientID NOT IN (SELECT PatientID FROM DICOMStudies)

Untested and use with utmost care (backup first)

Marcel

Display More

Hi, Marcel,

only a small correction, delete has no '*'

delete from DICOMImages where ImageDate>'20100101' and ImageDate<='20101231'

delete from DICOMSeries where SeriesDate>'20100101' and SeriesDate<='20101231'

delete from DICOMStudies where StudyDate>'20100101' and StudyDate<='20101231'

delete from DICOMPatients where WHERE PatientID NOT IN (SELECT PatientID FROM DICOMStudies)

jweste · Aug 18th 2022

Quote from Bahti

Hi !

need help
how open SQL console

It depends on your SGBD.

Each sgbd has your tools to execute sql.

Or use a third part program to do it.

jweste · Aug 18th 2022

You can send all of them and after go reducing a half until it stops to work.

Then, you will isolate the range of tags working or not

jweste · Aug 18th 2022

Quote from marcelvanherk

With our api I assume

Marcel

Of course

jweste · Aug 17th 2022

But this one, throw error:

https://app.box.com/s/3v73ot5pq7kza140yoi10qhqia4j7pqt

jweste · Aug 17th 2022

I imported this RTSTRUCT

It doesn't throw error when showing

https://github.com/OHIF/Viewer…b05-b66f-bb91e866ea7a.zip

jweste · Aug 17th 2022

Here RTSTRUCT seems to work.

https://viewer.imaging.datacom…4368772597187099978969331

and https://viewer.imaging.datacom…6641695765332389135385095

jweste · Aug 17th 2022

Ok,

Thank you

jweste · Aug 17th 2022

Quote from marcelvanherk

Ah,

I almost always have RTSTRUCTS, if I remove them it works. The SeriesNumber issue is not the problem.

Marcel

I don't have RTSTRUCTS dicom file.

May I have one?

jweste · Aug 17th 2022

Do you restarted conquest?

Sometimes it solves the problem.

I have touched some parts.

The metadata code is:

Code

/*-------------------------QIDO API--------------------------------
study
metadata
------------------------------------------------------------------*/
router.get("/rs/studies/:studyInstanceUids/metadata", async (req, res) => {
  const StudyInstanceUID = req.params.studyInstanceUids;
  let params = StudyInstanceUID;
  const cmd = `--dolua:dofile([[${APIFOLDER}/queryfunctions.lua]]);metadata([[${CQAE}]],[[${params}]])`;
  try {
    const os = new os_func_spawn();
    const dados = await os.execCommand(cmd);
    try {
      temp = JSON.parse(dados);
    } catch (error) {
      console.log(error);
      temp = [];
    }
    res.set("Content-Type", "application/json");
    if (temp.length > 0) {
      res.send(temp);
    } else res.status(204).send(temp);
  } catch (error) {
    console.log(error);
    return res.status(400).send({
      message: "Error finding series",
    });
  }
});

Display More

Here is

pasted-from-clipboard.zip

jweste · Aug 17th 2022

I have no more errors with my datasets.

But, I have few dicom datasets

jweste · Aug 17th 2022

jweste · Aug 17th 2022

When there is an error in exec lua scrpits, sometimes I have to restart conquest.

But, no all the times

jweste · Aug 17th 2022

I have about ten patients and all are showing the images.

Testing with latest OHIF, sometimes I had an error while testing. Then, I had do restart conquest and all is ok again

jweste · Aug 17th 2022

I saw it yesterday, but I didn´t think it would be a problem

jweste · Aug 17th 2022

With the last remotemetadata, It shows the image with pat id: 0009703828 (HEAD EXP2) from conquest github folder

jweste · Aug 17th 2022

Great, Marcel,

In remotemetadata(ae, level, st), is the level param equal to "IMAGE" all the time?

I ask it because the level param is not been used in the function?

jweste · Aug 17th 2022

Thanks,

I did the next.

In this line, how I can save a frame to jpg?

Code

x:Script('save frame '..oframe..' to '..outfile)

is this syntax ok:

Code

x:Script('save jpg frame '..oframe..' to '..outfile)

Code

function remotethumbs(ae, level, studyuid, serieuid, instuid, frame)
  local remotecode = 
[[
local oframe=']]..frame..[[';  
local ae=']]..ae..[[';
local level=']]..level..[[';
q=DicomObject:new()
q.SeriesInstanceUID=']]..serieuid..[['
q.StudyInstanceUID=']]..studyuid..[['
q.SOPInstanceUID=']]..instuid..[['
q.QueryRetrieveLevel=level
q["9999,0c00"]='ImageNumber' -- database field name to sort
r=dicomquery(AE, 'IMAGE', q)
n=math.floor(#r/2)
-- generate thumbnail
x=DicomObject:new()
outfile = tempfile('.jpg')
x:Read(':'..r[n].SOPInstanceUID)
if (oframe) then
    x:Script('save frame '..oframe..' to '..outfile)
else 
    x:script('save jpg to '..outfile)
end    
returnfile = outfile
]]
b=servercommand('lua:'..remotecode,'binary')
io.write(b or '')
end;
function thumbs(server,studyuid, serieuid, instuid, frame)
  local ae = server or servercommand('get_param:MyACRNema')
  b=remotethumbs(ae,'IMAGE',studyuid, serieuid, instuid, frame);
  io.write(b)
end

Display More

jweste · Aug 17th 2022

I have started thumbnails, and I´m trying to adapt your metadata function to that. But I dont´t have weasis to test.

Code

function remotethumbs(ae, level, st, sr)
  local remotecode = 
[[
  local ae=']]..ae..[[';
  local level=']]..level..[[';
  local q2=DicomObject:new();
  q2.QueryRetrieveLevel=level
  q2.SeriesInstanceUID=']]..sr..[['
  q2.StudyInstanceUID=']]..st..[['
  q2.InstanceNumber=''
  q2.Rows=''
  q2.Columns=''
  q2.PatientID=''
  q2.PatientName=''
  q2.SOPInstanceUID=''
  q2.NumberOfFrames=''
  q2.BitsStored=''
  q2.SamplesPerPixel=''
  q2.SOPClassUID=''
  q2.SliceLocation=''
  q2.Modality=''
  q2.FrameOfReferenceUID=''
  q2.PatientPosition=''
  local r = dicomquery(ae, level, q2)
  local d = DicomObject:new()
  d:Read(':'..r[0].SOPInstanceUID)
  for i=0, #r-1 do 
    r[i].WindowCenter=d.WindowCenter 
    r[i].WindowWidth=d.WindowWidth
    r[i].RescaleIntercept=d.RescaleIntercept
    r[i].RescaleSlope=d.RescaleSlope
    r[i].HighBit=d.HighBit
    r[i].PixelRepresentation=d.PixelRepresentation
    r[i].BitsAllocated=d.BitsAllocated
    r[i].PixelSpacing=d.PixelSpacing
    r[i].PhotometricInterpretation = d.PhotometricInterpretation
    r[i].ImageOrientationPatient = d.ImageOrientationPatient
    r[i].ImagePositionPatient = d.ImagePositionPatient
    r[i].SliceThickness = d.SliceThickness
  end
  r = r:Serialize(true,false,true)
  local s=tempfile('txt') local f=io.open(s, "wb") f:write(r) returnfile=s f:close()
]]
 local f = servercommand('lua:'..remotecode)
 return f
end;
function thumbs(server, st,sr)
  local ae = server or servercommand('get_param:MyACRNema')
  b=remotethumbs(ae, 'IMAGE', st,sr);
  io.write(b)
end

Display More

Code

/*-------------------------DICOM objects (Thumbnail)--------------------------------
// /studies/{study}/series/{series}/thumbnail
http://localhost:3002/api/dicom/rs/studies/2.16.840.1.113669.632.20.121711.10000161048/1.3.46.670589.11.17521.5.0.3124.2008081915302126599/thumbnail
-----------------------------------------------------------------------------------------*/
router.get("/rs/studies/:study/:series/thumbnail", async (req, res) => {
  const studyUID = req.params.study;
  const seriesUID = req.params.series;
  console.log(req.params);
  if (!studyUID || !seriesUID) {
    return res.status(400).send("Invalid studyUID, serieUID or objectUID.");
  }
  const cmd = `--dolua:dofile([[${APIFOLDER}/queryfunctions.lua]]);thumbs([[${CQAE}]],[[${studyUID}]],[[${seriesUID}]])`;
  try {
    const os = new os_func_spawn();
    const dados = await os.execCommand(cmd);
    try {
      temp = JSON.parse(dados);
    } catch (error) {
      console.log(error);
      temp = [];
    }
    res.set("Content-Type", "application/json");
    if (temp.length > 0) {
      res.send(temp);
    } else res.status(204).send(temp);
  } catch (error) {
    console.log(error);
    return res.status(400).send({
      message: "Error finding series",
    });
  }
});
/*-------------------------DICOM objects (Thumbnail)--------------------------------
/studies/{study}/series/{series}/instances/{instance}/thumbnail
-----------------------------------------------------------------------------------------*/
// http://localhost:3002/api/dicom/rs/studies/1.3.46.670589.5.2.10.2156913941.892665384.993397/series/1.3.46.670589.5.2.10.2156913941.892665339.860724/thumbnail?viewport=256%2C256
router.get(
  "/rs/studies/:study/:series/instances/:instance/thumbnail",
  async (req, res) => {
    const query = url.parse(req.url, true).query || {};
    const studyUID = req.params.study;
    const seriesUID = req.params.series;
    const objectUID = req.params.instance;
    const requestType = "";
    const contentType = "image/jpeg";
    const rows = "0";
    const columns = "0";
    const windowCenter = "0";
    const windowWidth = "0";
    const frameNumber = "0";
    const transferSyntax = "";
    const anonymize = "";
    const annotation = "";
    const imageQuality = 100;
    const charset = "";
    const presentationUID = "";
    const { viewport: region = "" } = query;
    if (!studyUID || !seriesUID || !objectUID) {
      return res.status(400).send("Invalid studyUID, serieUID or objectUID.");
    }
    t =
      "{ studyUID=" +
      `'${studyUID}',` +
      "seriesUID=" +
      `'${seriesUID}',` +
      "objectUID=" +
      `'${objectUID}',` +
      "requestType=" +
      `'${requestType}',` +
      "contentType=" +
      `'${contentType}',` +
      "rows=" +
      `'${rows}',` +
      "columns=" +
      `'${columns}',` +
      "region=" +
      `'${region}',` +
      "windowCenter=" +
      `'${windowCenter}',` +
      "windowWidth=" +
      `'${windowWidth}',` +
      "frameNumber=" +
      `'${frameNumber}',` +
      "transferSyntax=" +
      `'${transferSyntax}',` +
      "anonymize=" +
      `'${anonymize}',` +
      "annotation=" +
      `'${annotation}',` +
      "imageQuality=" +
      `'${imageQuality}',` +
      "charset=" +
      `'${charset}',` +
      "presentationUID=" +
      `'${presentationUID}'` +
      "}";
    const cmd = `--dolua:dofile([[${APIFOLDER}/queryfunctions.lua]]);wadouri([[${t}]])`;
    exec(
      `${dgateExBin}  "${cmd}" `,
      { encoding: "binary", maxBuffer: MAX_BUFFER, cwd: APIFOLDER },
      function (error, stdout, stderr) {
        if (stderr) {
          console.log("erro", stderr);
          return res.status(400).send({
            message: "Error finding slice.",
          });
        } else {
          // const nulbuf = new Uint8Array([0x00]);
          // const newBuffer = Buffer.concat([
          //   Buffer.from(stdout, "binary"),
          //   nulbuf,
          // ]);
          res.set("Content-Type", contentType); // contentType
          res.end(Buffer.from(stdout, "binary"));
        }
      }
    );
  }
);

Display More

Posts by jweste

Web server

Deleting old dicom images

Deleting old dicom images

Web server

Web server

Web server

Web server

Web server

Web server

Web server

Web server

Web server

Web server

Web server

Web server

Web server

Web server

Web server

Web server

Web server