Unfortunately not. If you hear of anything please post it here...

Hi Geoff ,

thought I might throw an idea into the mix ...If you can code the database connection to push out a booked/scheduled exam in the RIS to a flat txt file then you could use OFFIS DCMTK (wlmscpfs service) to grab the output.

I havent been able to extract scheduled exams from RIS but if you can do it !!

you would basically start the DCMTK wlmscpfs service , it listens on a port (1234)
in directory dcmwlm/data/wlistdb (wlistdb=worklist database)
Within this directory (wlistdb )and each subdirectory represents an Application Entity (AE) title for the wlmscpfs. e.g. requesting an association with the AE title would allow wlmscpfs to search the worklist entities contained in theWorklist sub-directory.Worklst sub dir then contains a file with all AE title info etc)
this link pretty much explains it all

http://forum.dcmtk.org/viewtopic.php?t=1475&highlight=worklist


Rgds

FT

Hi FT,

Thanks for that, currently we are using the system that you suggest by exporting info from the database according to planned procedures. The problem with this is that it does not allow for realtime queries of past examinations or for a better query structure configuration based on particular examinations per modality. This is why I was hoping for a quick start on a MWL SCP interface that I can work with to pull queries directly from the DB.

Regards,
Geoff.

Hi Geoff ,

could you point me in the right direction regarding as you suggest exporting info from the database according to planned procedures.

I can then use OFFIS DCMTK (wlmscpfs service) to grab the output

Rgds

FT

Hi FT,

Our comapny uses it's own RIS so I will have to try and get a sample of a CC RIS database in order to be able to point you in the right direction.

Regards,
Geoff.

Hi Geoff ,

 

you could download the CCRIS installer and extract db is MS management studio on sqlexpreess  or if you have an external email I could post the db ..might be large though ;)

 

Thanx

 

FT

Hi FT,

Apologies for the delayed response - haven't been looking into this for some time now. I installed the RIS server and added an order just to get an idea of the options therein.

The obvious way to categorise your worklist results is via the modality type, so CR related studies will only go to modalities that query CR and CT studies will only go to modalities that query CT etc. In your application you can therefore query all the waiting procedures relating to the modality that is querying the worklist.

Another way (which would require extra tables and configuration) is to add a further dimension of Rooms for the procedures. For example: The hospital has an ultrasound unit in the urology department and one in the x-ray department. These departments might both be able to order the same procedure (say US Abdomen) but we want the order to appear only on the modality that it was intended for. What would happen then is one would have to select a room first (say Urology Clinic) and then the procedure that you want. When a worklist query comes from the Urology ultrasound one would then only return procedures from the US modality that were booked against the Urology room.

The second option complicates matters a bit but for a large organisation is definitely the better way to go.

Hope this helps some. Regards,
Geoff.

I'm not sure if I'm following this thread correctly.

Has someone managed to develop a script that extracts the scheduled procedures from ccRIS into some sort of file structure. If that is correct, can the person post a sample?