CPRS Query Tool

[Akshant]

Hi,

I am trying to run CPRS Query tool on Windowns 7 (client) patform. I
have WorlVistA/GT.M Platform.

But everytime when i am trying to open CPRS query tool its crashing
and application is not opening.

I had tried it windows XP long time back and that time application was
opening.

Could you please help me in this.

Regards,
Akshant Chauhan

[David Whitten]

The CPRS query tool is a useful (if CPU intensive) GUI tool created for
HEPATITIS C reporting, which allows a clinician to find patients with particular
characteristics. The CPRS Query Tool provides users with the ability to build
custom reports and view predefined reports containing clinical information for
a select list of patients. This application is an enhancement to the Hepatitis C
registry project. The CPRS Query Tool application will assist health care
providers in following up on clinical interventions as well as providing an
aggregate view of patient information to track health care outcomes.

It was made available several years ago with patch OR*30*153.
The zip file ( OR_30_153.ZIP ) cpmtaining the manuals and executables is:
https://downloads.va.gov/files/vista/Software/VISTA_FOIA_RELEASES_BEFORE_2008/Order%20Entry-Results%20Reporting%20-%20OR/OR_30_153.ZIP

The Implementation/Installation guide is available at:
http://www.va.gov/vdl/documents/Clinical/Comp_Patient_Recrd_Sys_%28CPRS%29/or_30_153ig.pdf

The User guide is available at:
http://www.va.gov/vdl/documents/Clinical/Comp_Patient_Recrd_Sys_(CPRS)/or_30_153um.pdf

To my knowledge, the VA has not deployed Windows 7 throughout their network.
Thus the (relatively) small number of VA employees who use the CPRS Query tool
probably have not run into this issue yet.

Does anyone in the Hardhats community know if the source code for the CPRS Query
tool has been released and where to find it?

Best Regards,
David
713-870-3834

PS: Most of the information above is also available at:
http://vistapedia.net/index.php?title=CPRS_GUI_QUERY

--
http://groups.google.com/group/Hardhats
To unsubscribe, send email to Hardhats+u...@googlegroups.com

[Akshant]

Thanks David,

I have read the another link on hardhats and Tony is also facing some
issue.

Here is link for your reference.

http://groups.google.com/group/hardhats/browse_thread/thread/00fbaf5c3ea104ef

Regards,
Akshant Chauhan

On Mar 16, 8:27 pm, David Whitten <whit...@worldvista.org> wrote:
> The CPRS query tool is a useful (if CPU intensive) GUI tool created for
> HEPATITIS C reporting, which allows a clinician to find patients with
> particular
> characteristics. The CPRS Query Tool provides users with the ability to
> build
> custom reports and view predefined reports containing clinical information
> for
> a select list of patients. This application is an enhancement to the
> Hepatitis C
> registry project. The CPRS Query Tool application will assist health care
> providers in following up on clinical interventions as well as providing an
> aggregate view of patient information to track health care outcomes.
>
> It was made available several years ago with patch OR*30*153.

> The zip file ( OR_30_153.ZIP ) cpmtaining the manuals and executables is:https://downloads.va.gov/files/vista/Software/VISTA_FOIA_RELEASES_BEF...
>
> The Implementation/Installation guide is available at:http://www.va.gov/vdl/documents/Clinical/Comp_Patient_Recrd_Sys_%28CP...
>
> The User guide is available at:http://www.va.gov/vdl/documents/Clinical/Comp_Patient_Recrd_Sys_(CPRS...

>
> To my knowledge, the VA has not deployed Windows 7 throughout their network.
> Thus the (relatively) small number of VA employees who use the CPRS Query
> tool
> probably have not run into this issue yet.
>
> Does anyone in the Hardhats community know if the source code for the CPRS
> Query
> tool has been released and where to find it?
>
> Best Regards,
> David
> 713-870-3834
>
> PS: Most of the information above is also available at:http://vistapedia.net/index.php?title=CPRS_GUI_QUERY
>
>
>
> On Fri, Mar 16, 2012 at 10:55 AM, Akshant <akshant.chau...@gmail.com> wrote:
> > Hi,
>
> > I am trying to run CPRS Query tool on Windowns 7 (client) patform. I
> > have WorlVistA/GT.M Platform.
>
> > But everytime when i am trying to open CPRS query tool its crashing
> > and application is not opening.
>
> > I had tried it windows XP long time back and that time application was
> > opening.
>
> > Could you please help me in this.
>
> > Regards,
> > Akshant Chauhan
>
> > --
> >http://groups.google.com/group/Hardhats

> > To unsubscribe, send email to Hardhats+u...@googlegroups.com- Hide quoted text -
>
> - Show quoted text -

[Akshant]

Over to above.

We have XWB1_1P40PG RPC Broker 1.1 on the workstation.

-Akshant

On Mar 16, 9:35 pm, Akshant <akshant.chau...@gmail.com> wrote:
> Thanks David,
>
> I have read the another link on hardhats and Tony is also facing some
> issue.
>
> Here is link for your reference.
>

> http://groups.google.com/group/hardhats/browse_thread/thread/00fbaf5c...

> > > To unsubscribe, send email to Hardhats+unsubscr...@googlegroups.com- Hide quoted text -
>
> > - Show quoted text -- Hide quoted text -

[tony2468]

It's definitely not a Windows 7 issue -- my sense is that it's hanging
whilst trying to connect to the VistA server. I've tried this on a
fresh install of VistA using Windows XP and had no luck, and have
tried different servers.

I think it will require looking at RPC calls and making sense of
those, in order to figure out why it isn't connecting. I have tried
but couldn't quite make sense of the logs.

If anyone else could give it it a go, let us know!

Tony

[David Whitten]

I seem to recall that some of the old Delphi code uses the Old RPC Broker (call-back) protocol instead of the new (non-callback) protocol.

The call-back protocol has problems with NAT routing and non-routable addresses.

Perhaps you need to test when running the old RPC Broker on a port ?

To unsubscribe, send email to Hardhats+u...@googlegroups.com

[Sanchu Shanmugam]

Akshant

This cant be a Windows 7 issue as I am running on Windows 7 OS for long time & could able to work with Query tool without any issues.

Should be to do with Server Patching or your network restriction.

Regards

Sanchu S

[tony2468]

Hi Sanchu,

You *have* been able to run the Query Tool?

Are you running Astronaut VistA or WorldVistA EHR? (I've tried both
and could get the Query Tool to work with neither)

Did you do any initial set-up to get the Query Tool to proceed to the
log-on prompt (i.e. not hang)?

I have tried running it on two different servers (one local, one
remote) and had no luck -- even though CPRS and other components
worked just fine.

Tony

On Mar 18, 7:43 am, Sanchu Shanmugam <sanchu.shanmu...@gmail.com>
wrote:

> Akshant
>
> This cant be a Windows 7 issue as I am running on Windows 7 OS for long
> time & could able to work with Query tool without any issues.
>
> Should be to do with Server Patching or your network restriction.
>
> Regards
> Sanchu S
>

> On Sat, Mar 17, 2012 at 9:17 PM, David Whitten <whit...@worldvista.org>wrote:
>
>
>
>
>
>
>
> > I seem to recall that some of the old Delphi code uses the Old RPC Broker
> > (call-back) protocol instead of the new (non-callback) protocol.
> > The call-back protocol has problems with NAT routing and non-routable
> > addresses.
> > Perhaps you need to test when running the old RPC Broker on a port ?

[Sanchu Shanmugam]

Hi Tony

Yes, We could get the CPRS Query Tool running on WorldVistA EHR. 

I dont think we faced any such issues, however, We did some customization for a customer requirement..

Help me with,

CPRS Tool version

Broker version

What is your network setup

Server Version

Regards

Sanchu S

OHUM Healthcare

[David Whitten]

Following up on my own e-mail, I was encouraged by the search for the
Delphi code for
the FileMan Delphi Components found on Medsphere's shadow of the VA's server, so
I searched and found a copy in this location:

http://mirrors.medsphere.org/pub/downloads.va.gov/files/FOIA/Software/VistA_FOIA_Historical_Files/VISTA_FOIA_RELEASES_BEFORE_2008/OR-Order%20Entry-Results%20Reporting/Programs/

Specifically, the file:
[ ] Hep_c.zip 05-May-2005 20:00 122K

has the CPRS Query source code. (I think it was a written in a rather
old Delphi version, however)

Best Wishes:
David Whitten
713-870-3834

PS: again, thank you for Medsphere and their work making code
available that the VA has made available in the past.

[Syed]

CPRS Query tool data is inaccurate . I recommend don't use it. I have
experience with this and did lot of testing. Only way to make it work
is to make patient lists and maintain it. It is not practical unless
you are using it with in VA setting.
-Syed

[Kevin Toppenberg]

Syed,

I don't have any experience with this application, but I am intrigued.  Are you saying that the query tool only searches among an existing patient lists?  And are these lists the same type of lists that make up teams etc?

If so, then what may be needed is a good list manager.  We just finished a project that allows sending form letters to lists of patients.   But we left it to others to derive the lists.

Kevin

[tony2468]

In response to Sanchu's earlier e-mail, the versions we are using are
as follows:

CPRS Tool version: 1.026.69, TMG customisation 2.0 (9.3.2010)
Broker version:
Server version: WorldVistA EHR/VOE 1.0

I'm not sure how to find the broker version -- could you advise?

Thanks!

Tony

[tony2468]

I am keen to see the CPRS Query Tool working, and will have to learn
more about patient lists.

Our main goal, though, is to be able to extract information from
VistA, such as:
* Number of patients seen by month by setting (e.g. ward versus
outpatient)
* Conditions treated (ICD9 code)
* Demographics (e.g. average age)

If CPRS Query Tool isn't the right option, does anyone have any advice
on how to extract this from VistA?

Thanks!

Tony

On Mar 19, 11:45 pm, Kevin Toppenberg <kdt...@gmail.com> wrote:

[Akshant]

I tried to open CPRS query tool where firewall is not enabled between
server and client machine and its working fine.

But when we are using this tool where firewall is enabled and we have
open port 9230 between server and client network. This tool is not
working.

What i have analyzed this tool is opening dynamically port instead on
9230 and which is not open in firewall.

Please let me know if this is correct that CPRS query tool open the
dynamic port on running.

Regards,
Akshant




On Mar 20, 12:20 pm, tony2468 <tony.j.pe...@googlemail.com> wrote:
> I am keen to see theCPRSQueryToolworking, and will have to learn

> more about patient lists.
>
> Our main goal, though, is to be able to extract information from
> VistA, such as:
> * Number of patients seen by month by setting (e.g. ward versus
> outpatient)
> * Conditions treated (ICD9 code)
> * Demographics (e.g. average age)
>

> IfCPRSQueryToolisn't the right option, does anyone have any advice

> on how to extract this from VistA?
>
> Thanks!
>
> Tony
>
> On Mar 19, 11:45 pm, Kevin Toppenberg <kdt...@gmail.com> wrote:
>
>
>
> > Syed,
>
> > I don't have any experience with this application, but I am intrigued.  Are

> > you saying that thequerytoolonly searches among an existing patient

> > lists?  And are these lists the same type of lists that make up teams etc?
>
> > If so, then what may be needed is a good list manager.  We just finished a
> > project that allows sending form letters to lists of patients.   But we
> > left it to others to derive the lists.
>
> > Kevin
>
> > On Monday, March 19, 2012 5:18:36 PM UTC-4, Syed wrote:
>

> > >CPRSQuerytooldata is inaccurate . I recommend don't use it. I have

> > > experience with this and did lot of testing. Only way to make it work
> > > is to make patient lists and maintain it. It is not practical unless
> > > you are using it with in VA setting.
> > > -Syed
>
> > > On Mar 16, 7:55 am, Akshant <akshant.chau...@gmail.com> wrote:
> > > > Hi,
>

> > > > I am trying to runCPRSQuerytoolon Windowns 7 (client) patform. I
> > > > have WorlVistA/GT.M Platform.
>
> > > > But everytime when i am trying to openCPRSquerytoolits crashing

> > > > and application is not opening.
>
> > > > I had tried it windows XP long time back and that time application was
> > > > opening.
>
> > > > Could you please help me in this.
>
> > > > Regards,

> > > > Akshant Chauhan- Hide quoted text -

[David Whitten]

On Wed, Mar 21, 2012 at 9:27 AM, Akshant <akshant...@gmail.com> wrote:

I tried to open CPRS query tool where firewall is not enabled between
server and client machine and its working fine.

But when we are using this tool where firewall is enabled and we have
open port 9230 between server and client network. This tool is not
working.

What i have analyzed this tool is opening dynamically port instead on
9230 and which is not open in firewall.

Please let me know if this is correct that CPRS query tool open the
dynamic port on running.

Regards,
Akshant

If your analysis is that a port is being opened dynamically, then you have

evidence that I was right that the CPRS query tool is using the old call back

RPC broker.   Basically, for security, the old method of the RPC broker connection

was that your client PC would contact the RPC broker on a known port number.

The PC would send the RPC broker its own IP address.

Then the RPC broker on the server would start a proxy M job on the server 

The proxy M job would create a new outgoing connection from the server to the

client using the IP address information sent originally by the client.

All communication between the Client application (such as CPRSChart)

and the server would then be handled on the new connection. 

The client application would send REMOTE PROCEDURE (File #8994) entry

names to the server-side proxy with parameter values.

The server-side proxy would look up the actual M code to run from the File,

add the parameter name for the result to be stored to the first of the call, and

collect the values of the parameters sent by the client over the TCP/IP connection

into local variables and use indirection (run time lazy evaluation) to call 

the tag and routine (entry-reference) specified.   After that subroutine finished,

the M proxy program would look at the type of entry in the REMOTE PROCEDURE

file, and transmit the resulting values from the result parameter back over the

TCP/IP connection to the Client application.

This process of invoking Remote Procedure Calls continues.

Eventually, the client would send a request to close the RPC connection and 

the proxy would execute a HALT, freeing an M job slot.

 

David Whitten

PS: this is recorded at 

http://www.vistapedia.net/index.php?title=RPC_Calls

[Akshant]

Thanks David for such good information.

Do we have any NEW CPRS tool available on internet which supports new
RPC method.

Regards,
Akshant Chauhan

On Mar 21, 7:14 pm, David Whitten <whit...@worldvista.org> wrote:

> PS: this is recorded athttp://www.vistapedia.net/index.php?title=RPC_Calls

> > To unsubscribe, send email to Hardhats+u...@googlegroups.com- Hide quoted text -
>
> - Show quoted text -- Hide quoted text -

[David Whitten]

To my knowledge, the CPRS query tool has not been updated.
It is up to the community to find the resources to update it to the
new client-side
broker code (which I assume is built into the exe much like CPRSChart.exe )
or to the shared broker as an external executable (which I think BCMA now does).

As a stopgap, can you declare both the server and client in some kind
of "safe zone"
that allows the two to open ports and communicate over them ?

David

[Sidney SEO]

Does anyone have the CPRS query tool source code?

- Sid Tarason

[David Whitten]

There is a log of GUI source code at:

http://opensourcevista.net:8888/NancysVistAServer/GUI-Source-Code/

The MailMan GUI is at:

http://opensourcevista.net:8888/NancysVistAServer/GUI_Mailman/

The CPRS QUERY source code is at 

http://mirrors.medsphere.org/pub/downloads.va.gov/files/FOIA/Software/VistA_FOIA_Historical_Files/VISTA_FOIA_RELEASES_BEFORE_2008/OR-Order%20Entry-Results%20Reporting/Programs/

and called  Hep_c.zip

This is because the original use of the CPRS Query tool was to create Patient Lists that collected

patients which had Hepatitis C.  I don't know of any update to that code.

[tony2468]

I found the following guide on the VA site about using the Query Tool
that others might find of interest (see in particular page 59 in the
document):

http://www.va.gov/vdl/documents/Clinical/Care_Management/orrcum.pdf

Will anyone get a chance to look more closely at the source code to
better understand what's happening with the RPC calls?
(Unfortunately, my programming skills are quite limited!).

Thanks!

Tony

On Mar 22, 5:18 pm, David Whitten <whit...@worldvista.org> wrote:
> There is a log of GUI source code at:http://opensourcevista.net:8888/NancysVistAServer/GUI-Source-Code/
>
> The MailMan GUI is at:
>
> http://opensourcevista.net:8888/NancysVistAServer/GUI_Mailman/
>

> The CPRS QUERY source code is athttp://mirrors.medsphere.org/pub/downloads.va.gov/files/FOIA/Software...

>
> and called  Hep_c.zip
>
> This is because the original use of the CPRS Query tool was to create
> Patient Lists that collected
> patients which had Hepatitis C.  I don't know of any update to that code.
>
>
>
> On Thu, Mar 22, 2012 at 10:47 AM, Sidney SEO <seosid...@gmail.com> wrote:
> > Does anyone have the CPRS query tool source code?
>
> > - Sid Tarason
>

> > On Thu, Mar 22, 2012 at 10:34 AM, David Whitten <whit...@worldvista.org>wrote:
>
> >> To my knowledge, the CPRS query tool has not been updated.
> >> It is up to the community to find the resources to update it to the
> >> new client-side
> >> broker code (which I assume is built into the exe much like CPRSChart.exe
> >> )
> >> or to the shared broker as an external executable (which I think BCMA now
> >> does).
>
> >> As a stopgap, can you declare both the server and client in some kind
> >> of "safe zone"
> >> that allows the two to open ports and communicate over them ?
>
> >> David
>

> >> On Thu, Mar 22, 2012 at 5:41 AM, Akshant <akshant.chau...@gmail.com>

> >> >> > To unsubscribe, send email to Hardhats+unsubscr...@googlegroups.com-Hide quoted text -

[tony2468]

Hi All,

I was just curious to see if anyone had a chance to look at the source
code for the CPRS Query Tool to make sense of the broker issue?

I look forward to any news you might have!

Tony

On Apr 3, 11:11 am, tony2468 <tony.j.pe...@googlemail.com> wrote:
> I found the following guide on the VA site about using theQueryTool
> that others might find of interest (see in particular page 59 in the
> document):
>
> http://www.va.gov/vdl/documents/Clinical/Care_Management/orrcum.pdf
>
> Will anyone get a chance to look more closely at the source code to
> better understand what's happening with the RPC calls?
> (Unfortunately, my programming skills are quite limited!).
>
> Thanks!
>
> Tony
>
> On Mar 22, 5:18 pm, David Whitten <whit...@worldvista.org> wrote:
>
>
>
> > There is a log of GUI source code at:http://opensourcevista.net:8888/NancysVistAServer/GUI-Source-Code/
>
> > The MailMan GUI is at:
>
> >http://opensourcevista.net:8888/NancysVistAServer/GUI_Mailman/
>

> > The CPRSQUERYsource code is athttp://mirrors.medsphere.org/pub/downloads.va.gov/files/FOIA/Software...
>
> > and called  Hep_c.zip
>
> > This is because the original use of the CPRSQuerytoolwas to create

> > Patient Lists that collected
> > patients which had Hepatitis C.  I don't know of any update to that code.
>
> > On Thu, Mar 22, 2012 at 10:47 AM, Sidney SEO <seosid...@gmail.com> wrote:

> > > Does anyone have the CPRSquerytoolsource code?

>
> > > - Sid Tarason
>
> > > On Thu, Mar 22, 2012 at 10:34 AM, David Whitten <whit...@worldvista.org>wrote:
>

> > >> To my knowledge, the CPRSquerytoolhas not been updated.

> > >> It is up to the community to find the resources to update it to the
> > >> new client-side
> > >> broker code (which I assume is built into the exe much like CPRSChart.exe
> > >> )
> > >> or to the shared broker as an external executable (which I think BCMA now
> > >> does).
>
> > >> As a stopgap, can you declare both the server and client in some kind
> > >> of "safe zone"
> > >> that allows the two to open ports and communicate over them ?
>
> > >> David
>
> > >> On Thu, Mar 22, 2012 at 5:41 AM, Akshant <akshant.chau...@gmail.com>
> > >> wrote:
> > >> > Thanks David for such good information.
>

> > >> > Do we have any NEW CPRStoolavailable on internet which supports new

> > >> > RPC method.
>
> > >> > Regards,
> > >> > Akshant Chauhan
>
> > >> > On Mar 21, 7:14 pm, David Whitten <whit...@worldvista.org> wrote:
> > >> >> On Wed, Mar 21, 2012 at 9:27 AM, Akshant <akshant.chau...@gmail.com>
> > >> wrote:

> > >> >> > I tried to open CPRSquerytoolwhere firewall is not enabled between

> > >> >> > server and client machine and its working fine.
>

> > >> >> > But when we are using thistoolwhere firewall is enabled and we have
> > >> >> > open port 9230 between server and client network. Thistoolis not
> > >> >> > working.
>
> > >> >> > What i have analyzed thistoolis opening dynamically port instead on

> > >> >> > 9230 and which is not open in firewall.
>

> > >> >> > Please let me know if this is correct that CPRSquerytoolopen the

> > >> >> > dynamic port on running.
>
> > >> >> > Regards,
> > >> >> > Akshant
>
> > >> >> If your analysis is that a port is being opened dynamically, then you
> > >> have

> > >> >> evidence that I was right that the CPRSquerytoolis using the old

> > > To unsubscribe, send email to Hardhats+unsubscr...@googlegroups.com- Hide quoted text -

[Kevin Toppenberg]

I've got too many irons in the fire to jump into this project, as much as I would like to.

Sorry,

Kevin