RE: REDCap SQL scripts

[Dan Connolly]

The code that breaks down the multiple choice fields is in our "heron_staging" 
code, which isn't published the way the rest of the code is.

It's discussed briefly in the SEINE manuscript.
https://informatics.gpcnetwork.org/trac/Project/ticket/87#comment:16

Here's hoping I find time to share the relevant code soonish..

-- 
Dan


From: gpc-dev-boun...@listserv.kumc.edu [gpc-dev-boun...@listserv.kumc.edu] on 
behalf of Borromeo, Charles [ch...@pitt.edu]
Sent: Tuesday, November 04, 2014 3:25 PM
To: gpc-dev@listserv.kumc.edu
Subject: REDCap SQL scripts

Hello,
  At the PaTH CDRN we are using REDCap for our survey data and loading the
results into i2b2.  Russ Waitman directed me to your REDCap to i2b2
scripts found here: https://informatics.kumc.edu/work/browser/heron_load.
I have been tinkering with the redcap_concepts_load.sql script to meet our
PaTH needs.  It allows me to load an i2b2 concept_dimension table based on
the redcap_metadata table.  I have extracted the resulting REDCap data
from concept_dimension into an i2b2 ontology table.

My question is: how was GPC going to load the enumerated data found in the
redcap_metadata element_enum column in the i2b2 user interface?  For the
PROMIS 29 surveys, the survey contains several radio elements with 5
options like:

1, Never \n 2, Rarely \n 3, Sometimes \n 4, Often \n 5, Always

I was thinking of presenting the radio options as leaves within i2b2 like
this:

\promis29
\I felt fearful
\1, Never
\2, Rarely
\3, Sometimes
\4, Often
\5, Always

The current SQL script does not build leaves from the options.  Has GPC
given any thought to representing the radio options?

Thanks,
Chuck Borromeo
PaTH Network


___
Gpc-dev mailing list
Gpc-dev@listserv.kumc.edu
http://listserv.kumc.edu/mailman/listinfo/gpc-dev
___
Gpc-dev mailing list
Gpc-dev@listserv.kumc.edu
http://listserv.kumc.edu/mailman/listinfo/gpc-dev

Re: [gpc-informatics] #87: Deploy, document R Data Builder demo service

[GPC Informatics]

#87: Deploy, document R Data Builder demo service
--+
 Reporter:  dconnolly |   Owner:  dconnolly
 Type:  task  |  Status:  accepted
 Priority:  major |   Milestone:  data-agg1
Component:  data-sharing  |  Resolution:
 Keywords:|  Blocked By:  134, 179
 Blocking:  119   |
--+

Comment (by gkowalski):

 From the Video :

 {{{

 [root@localhost cdr2edc]# python dfbuilder.py
 /usr/local/heron_extract/deploy/test.conf
 /var/log/data_builder/2014-11-04T16\:39\:25.412647-demo.json
 Traceback (most recent call last):
   File "dfbuilder.py", line 939, in 
 _trusted_main()
   File "dfbuilder.py", line 937, in _trusted_main
 gethostname=socket.gethostname)
   File "dfbuilder.py", line 859, in main
 username = params['username']
 KeyError: 'username'
 [root@localhost cdr2edc]#

 }}}

--
Ticket URL: 

gpc-informatics 
Greater Plains Network - Informatics
___
Gpc-dev mailing list
Gpc-dev@listserv.kumc.edu
http://listserv.kumc.edu/mailman/listinfo/gpc-dev

RE: REDCap SQL scripts

[Campbell, James R]

Numeric results can simply be loaded with appropriate metadataxml as an 
enumerated list of coded options and require no additional tweaking of the 
ontology layer.  I think that the use of leaf nodes or modifiers is useful whn 
there are recurring and frequent use cases for querying only one subpopulation 
of results, but a range of codes is more difficult with the i2b2 interface and 
the enumerated code list is much more flexible at query time
Jim


From: gpc-dev-boun...@listserv.kumc.edu [gpc-dev-boun...@listserv.kumc.edu] on 
behalf of Borromeo, Charles [ch...@pitt.edu]
Sent: Tuesday, November 04, 2014 3:25 PM
To: gpc-dev@listserv.kumc.edu
Subject: REDCap SQL scripts

Hello,
  At the PaTH CDRN we are using REDCap for our survey data and loading the
results into i2b2.  Russ Waitman directed me to your REDCap to i2b2
scripts found here: https://informatics.kumc.edu/work/browser/heron_load.
I have been tinkering with the redcap_concepts_load.sql script to meet our
PaTH needs.  It allows me to load an i2b2 concept_dimension table based on
the redcap_metadata table.  I have extracted the resulting REDCap data
from concept_dimension into an i2b2 ontology table.

My question is: how was GPC going to load the enumerated data found in the
redcap_metadata element_enum column in the i2b2 user interface?  For the
PROMIS 29 surveys, the survey contains several radio elements with 5
options like:

1, Never \n 2, Rarely \n 3, Sometimes \n 4, Often \n 5, Always

I was thinking of presenting the radio options as leaves within i2b2 like
this:

\promis29
\I felt fearful
\1, Never
\2, Rarely
\3, Sometimes
\4, Often
\5, Always

The current SQL script does not build leaves from the options.  Has GPC
given any thought to representing the radio options?

Thanks,
Chuck Borromeo
PaTH Network


___
Gpc-dev mailing list
Gpc-dev@listserv.kumc.edu
http://listserv.kumc.edu/mailman/listinfo/gpc-dev

The information in this e-mail may be privileged and confidential, intended 
only for the use of the addressee(s) above. Any unauthorized use or disclosure 
of this information is prohibited. If you have received this e-mail by mistake, 
please delete it and immediately contact the sender.

___
Gpc-dev mailing list
Gpc-dev@listserv.kumc.edu
http://listserv.kumc.edu/mailman/listinfo/gpc-dev

Re: [gpc-informatics] #87: Deploy, document R Data Builder demo service

[GPC Informatics]

#87: Deploy, document R Data Builder demo service
--+
 Reporter:  dconnolly |   Owner:  dconnolly
 Type:  task  |  Status:  accepted
 Priority:  major |   Milestone:  data-agg1
Component:  data-sharing  |  Resolution:
 Keywords:|  Blocked By:  134, 179
 Blocking:  119   |
--+

Comment (by gkowalski):

 Next Step failed :
 {{{
 [root@localhost deploy]# make -f i2b2_vm_deploy.mk
 request1=/var/log/data_builder/queue/2014-11-04T16\:39\:25.443684-demo.json
 i2b2_vm_deploy.mk:100: *** target pattern contains no `%'.  Stop.
 [root@localhost deploy]# cat
 /var/log/data_builder/queue/2014-11-04T16\:39\:25.443684-demo.json
 {"username": "demo", "filename": "endotest", "label": "Endocrine
 disor@13:50:45 [11-4-2014] [demo] [PATIENTSET_5]", "patient_set": 5,
 "concepts": {"keys": ["i2b2_DIAG\\i2b2\\Diagnoses\\Endocrine disorders
 (240-259)\\"], "names": ["Endocrine disorders"]}}[root@localhost deploy]#
 }}}

--
Ticket URL: 

gpc-informatics 
Greater Plains Network - Informatics
___
Gpc-dev mailing list
Gpc-dev@listserv.kumc.edu
http://listserv.kumc.edu/mailman/listinfo/gpc-dev

Re: [gpc-informatics] #87: Deploy, document R Data Builder demo service

[GPC Informatics]

#87: Deploy, document R Data Builder demo service
--+
 Reporter:  dconnolly |   Owner:  dconnolly
 Type:  task  |  Status:  accepted
 Priority:  major |   Milestone:  data-agg1
Component:  data-sharing  |  Resolution:
 Keywords:|  Blocked By:  134, 179
 Blocking:  119   |
--+

Comment (by gkowalski):

 Got it ,

 Removed the line :

  exports.animation_addr = (  "js-
 i2b2/cells/plugins/fsm/KaplanMeierStat/assets/icefish2.gif");

 from /var/www/html/webclient/js-
 i2b2/cells/plugins/fsm/DFBuilder/tool_widgets_orig.js

 and it worked .

--
Ticket URL: 

gpc-informatics 
Greater Plains Network - Informatics
___
Gpc-dev mailing list
Gpc-dev@listserv.kumc.edu
http://listserv.kumc.edu/mailman/listinfo/gpc-dev

REDCap SQL scripts

[Borromeo, Charles]

Hello,
  At the PaTH CDRN we are using REDCap for our survey data and loading the
results into i2b2.  Russ Waitman directed me to your REDCap to i2b2
scripts found here: https://informatics.kumc.edu/work/browser/heron_load.
I have been tinkering with the redcap_concepts_load.sql script to meet our
PaTH needs.  It allows me to load an i2b2 concept_dimension table based on
the redcap_metadata table.  I have extracted the resulting REDCap data
from concept_dimension into an i2b2 ontology table.

My question is: how was GPC going to load the enumerated data found in the
redcap_metadata element_enum column in the i2b2 user interface?  For the
PROMIS 29 surveys, the survey contains several radio elements with 5
options like:

1, Never \n 2, Rarely \n 3, Sometimes \n 4, Often \n 5, Always

I was thinking of presenting the radio options as leaves within i2b2 like
this:

\promis29
\I felt fearful
\1, Never
\2, Rarely
\3, Sometimes
\4, Often
\5, Always

The current SQL script does not build leaves from the options.  Has GPC
given any thought to representing the radio options?

Thanks,
Chuck Borromeo
PaTH Network


___
Gpc-dev mailing list
Gpc-dev@listserv.kumc.edu
http://listserv.kumc.edu/mailman/listinfo/gpc-dev

Re: [gpc-informatics] #87: Deploy, document R Data Builder demo service

[GPC Informatics]

#87: Deploy, document R Data Builder demo service
--+
 Reporter:  dconnolly |   Owner:  dconnolly
 Type:  task  |  Status:  accepted
 Priority:  major |   Milestone:  data-agg1
Component:  data-sharing  |  Resolution:
 Keywords:|  Blocked By:  134, 179
 Blocking:  119   |
--+

Comment (by dconnolly):

 Replying to [comment:59 gkowalski]:
 > Really  webclient.d.ts ? not webclient.d.js ?

 part of an exploration into [http://www.typescriptlang.org/ typescript].
 Probably dead code now.

--
Ticket URL: 

gpc-informatics 
Greater Plains Network - Informatics
___
Gpc-dev mailing list
Gpc-dev@listserv.kumc.edu
http://listserv.kumc.edu/mailman/listinfo/gpc-dev

Re: [gpc-informatics] #87: Deploy, document R Data Builder demo service

[GPC Informatics]

#87: Deploy, document R Data Builder demo service
--+
 Reporter:  dconnolly |   Owner:  dconnolly
 Type:  task  |  Status:  accepted
 Priority:  major |   Milestone:  data-agg1
Component:  data-sharing  |  Resolution:
 Keywords:|  Blocked By:  134, 179
 Blocking:  119   |
--+

Comment (by dconnolly):

 Replying to [comment:58 gkowalski]:
 > Hmmm .  Missing the entire KaplanMeierStat directory :

 `KaplanMeierStat` was never really relevant to this data builder stuff;
 it's is a separate project now. See ticket:134#comment:5

--
Ticket URL: 

gpc-informatics 
Greater Plains Network - Informatics
___
Gpc-dev mailing list
Gpc-dev@listserv.kumc.edu
http://listserv.kumc.edu/mailman/listinfo/gpc-dev

Re: [gpc-informatics] #87: Deploy, document R Data Builder demo service

[GPC Informatics]

#87: Deploy, document R Data Builder demo service
--+
 Reporter:  dconnolly |   Owner:  dconnolly
 Type:  task  |  Status:  accepted
 Priority:  major |   Milestone:  data-agg1
Component:  data-sharing  |  Resolution:
 Keywords:|  Blocked By:  134, 179
 Blocking:  119   |
--+

Comment (by gkowalski):

 Really  webclient.d.ts ? not webclient.d.js ?

--
Ticket URL: 

gpc-informatics 
Greater Plains Network - Informatics
___
Gpc-dev mailing list
Gpc-dev@listserv.kumc.edu
http://listserv.kumc.edu/mailman/listinfo/gpc-dev

Re: [gpc-informatics] #87: Deploy, document R Data Builder demo service

[GPC Informatics]

#87: Deploy, document R Data Builder demo service
--+
 Reporter:  dconnolly |   Owner:  dconnolly
 Type:  task  |  Status:  accepted
 Priority:  major |   Milestone:  data-agg1
Component:  data-sharing  |  Resolution:
 Keywords:|  Blocked By:  134, 179
 Blocking:  119   |
--+

Comment (by gkowalski):

 Hmmm .  Missing the entire KaplanMeierStat directory :
 {{{
 [root@localhost DFBuilder]# pwd
 /var/www/html/webclient/js-i2b2/cells/plugins/fsm/DFBuilder
 [root@localhost DFBuilder]# ls -l
 total 28
 drwxr-xr-x 2 root root 4096 Nov  4 13:30 assets
 -rw-r--r-- 1 root root  505 Nov  3 12:30 cell_config_data.js
 -rw-r--r-- 1 root root 5436 Nov  3 12:30 DFBuilder_ctrlr.js
 -rw-r--r-- 1 root root 6390 Nov  3 12:30 tool_widgets.js
 -rw-r--r-- 1 root root  381 Nov  3 12:30 webclient.d.ts
 [root@localhost DFBuilder]#
 }}}

 And in the assets :
 {{{
 [root@localhost DFBuilder]# ls -l assets/
 total 8
 -rw-r--r-- 1 root root 2790 Nov  3 12:30 dfb_ui.html
 -rw-r--r-- 1 root root 3854 Nov  3 12:30 tools.css
 [root@localhost DFBuilder]#
 }}}

--
Ticket URL: 

gpc-informatics 
Greater Plains Network - Informatics
___
Gpc-dev mailing list
Gpc-dev@listserv.kumc.edu
http://listserv.kumc.edu/mailman/listinfo/gpc-dev

Re: [gpc-informatics] #87: Deploy, document R Data Builder demo service

[GPC Informatics]

#87: Deploy, document R Data Builder demo service
--+
 Reporter:  dconnolly |   Owner:  dconnolly
 Type:  task  |  Status:  accepted
 Priority:  major |   Milestone:  data-agg1
Component:  data-sharing  |  Resolution:
 Keywords:|  Blocked By:  134, 179
 Blocking:  119   |
--+

Comment (by gkowalski):

 Replying to [comment:55 dconnolly]:
 > Replying to [comment:52 gkowalski]:
 > > Past step 5 , had to edit the /var/lib/pgsql/9.1/data/pg_hba.conf to
 add a local entry
 >
 > Strange!
 >
 > I wonder why I didn't have to do that. You'd think that we were running
 **exactly** the same bits. You're definitely running i2b2vmware-1703a.zip
 Version: 1.7.03a?

 Yes , only difference is I'm running it on my Mac as the native OS and
 using VMWare Fusion . I didn't have to install a second Network adapter ,
 the first was able to get to the internet and download the required
 packages.

 Sure I'm using the same heron_extract.zip that you used ? I assume so . I
 may try a fresh install again , this time with the pg_hba.conf mod first
 before the installation .

--
Ticket URL: 

gpc-informatics 
Greater Plains Network - Informatics
___
Gpc-dev mailing list
Gpc-dev@listserv.kumc.edu
http://listserv.kumc.edu/mailman/listinfo/gpc-dev

Re: [gpc-informatics] #87: Deploy, document R Data Builder demo service

[GPC Informatics]

#87: Deploy, document R Data Builder demo service
--+
 Reporter:  dconnolly |   Owner:  dconnolly
 Type:  task  |  Status:  accepted
 Priority:  major |   Milestone:  data-agg1
Component:  data-sharing  |  Resolution:
 Keywords:|  Blocked By:  134, 179
 Blocking:  119   |
--+

Comment (by dconnolly):

 Replying to [comment:54 gkowalski]:
 > ... assets/icefish2.gif ...
 > 404 Not Found

 That shouldn't matter.

 You can put some image there if you like, but the lack of it shouldn't
 stop anything from working.

--
Ticket URL: 

gpc-informatics 
Greater Plains Network - Informatics
___
Gpc-dev mailing list
Gpc-dev@listserv.kumc.edu
http://listserv.kumc.edu/mailman/listinfo/gpc-dev

Re: [gpc-informatics] #87: Deploy, document R Data Builder demo service

[GPC Informatics]

#87: Deploy, document R Data Builder demo service
--+
 Reporter:  dconnolly |   Owner:  dconnolly
 Type:  task  |  Status:  accepted
 Priority:  major |   Milestone:  data-agg1
Component:  data-sharing  |  Resolution:
 Keywords:|  Blocked By:  134, 179
 Blocking:  119   |
--+

Comment (by dconnolly):

 Replying to [comment:52 gkowalski]:
 > Past step 5 , had to edit the /var/lib/pgsql/9.1/data/pg_hba.conf to add
 a local entry

 Strange!

 I wonder why I didn't have to do that. You'd think that we were running
 **exactly** the same bits. You're definitely running i2b2vmware-1703a.zip
 Version: 1.7.03a?

--
Ticket URL: 

gpc-informatics 
Greater Plains Network - Informatics
___
Gpc-dev mailing list
Gpc-dev@listserv.kumc.edu
http://listserv.kumc.edu/mailman/listinfo/gpc-dev

Re: [gpc-informatics] #87: Deploy, document R Data Builder demo service

[GPC Informatics]

#87: Deploy, document R Data Builder demo service
--+
 Reporter:  dconnolly |   Owner:  dconnolly
 Type:  task  |  Status:  accepted
 Priority:  major |   Milestone:  data-agg1
Component:  data-sharing  |  Resolution:
 Keywords:|  Blocked By:  134, 179
 Blocking:  119   |
--+

Comment (by gkowalski):

 OK , opened up the dev tools in chrome to see if I could see a better
 error on the post
 Request is wierd :

 http://192.168.116.144/webclient/js-
 i2b2/cells/plugins/fsm/KaplanMeierStat/assets/icefish2.gif

 Response :
 {{{
 
 
 404 Not Found
 
 Not Found
 The requested URL /webclient/js-
 i2b2/cells/plugins/fsm/KaplanMeierStat/assets/icefish2.gif was not found
 on this server.
 
 Apache/2.2.15 (CentOS) Server at 192.168.116.144 Port
 80
 
 }}}

--
Ticket URL: 

gpc-informatics 
Greater Plains Network - Informatics
___
Gpc-dev mailing list
Gpc-dev@listserv.kumc.edu
http://listserv.kumc.edu/mailman/listinfo/gpc-dev

PRO common measures as REDCap survey(s)

[Dan Connolly]

I rendered the common measures as two surveys:


  *   Adult
  *   Pediatric

It would probably make more sense as one survey with branching logic, but I'm 
not feeling that dedicated.

For reference:

  *   The PCORnet Patient reported Outcomes (PRO) Common Measures Working Group 
(CMWG) September 
23, 2014
  *   
pro_scrape.py
 e1859a65e231

--
Dan

___
Gpc-dev mailing list
Gpc-dev@listserv.kumc.edu
http://listserv.kumc.edu/mailman/listinfo/gpc-dev

Re: [gpc-informatics] #87: Deploy, document R Data Builder demo service

[GPC Informatics]

#87: Deploy, document R Data Builder demo service
--+
 Reporter:  dconnolly |   Owner:  dconnolly
 Type:  task  |  Status:  accepted
 Priority:  major |   Milestone:  data-agg1
Component:  data-sharing  |  Resolution:
 Keywords:|  Blocked By:  134, 179
 Blocking:  119   |
--+

Comment (by gkowalski):

 Well I rau the query on Endocrine like the demo video showed and it didn't
 work.  I didn't get the Job queued message , but rather a broken link (
 See broken-link.png image attachment  ) .

 I don't see the JSON file in the queue dir to process  :

 [root@localhost heron]# ls -l /var/log/data_builder/queue/
 total 0
 [root@localhost heron]#

 Also No errors in the server.log jboss file, just normal stuff  :

 {{{
 14:50:47,494 INFO  [edu.harvard.i2b2.crc.dao.OracleDAOFactory]
 (Thread-138) Using datasource java:/QueryToolDemoDS
 14:50:47,546 INFO  [stdout] (Thread-138) panel accuracy scale100
 14:50:47,547 INFO
 
[edu.harvard.i2b2.crc.dao.setfinder.querybuilder.temporal.TemporalPanelConceptItem]
 (Thread-138) Item value constrain sql [Ljava.lang.String;@a9cc99
 14:50:47,547 INFO  [stdout] (Thread-138) insert into QUERY_GLOBAL_TEMP
 (patient_num, panel_count)
 14:50:47,552 INFO  [stdout] (Thread-138) with t as (
 14:50:47,553 INFO  [stdout] (Thread-138)  select  f.patient_num
 14:50:47,553 INFO  [stdout] (Thread-138) from public.observation_fact f
 14:50:47,553 INFO  [stdout] (Thread-138) where
 14:50:47,554 INFO  [stdout] (Thread-138) f.concept_cd IN (select
 concept_cd from  public.concept_dimension   where concept_path LIKE
 '\\i2b2\\Diagnoses\\Endocrine disorders (240-259)\\%')
 14:50:47,554 INFO  [stdout] (Thread-138) group by  f.patient_num
 14:50:47,554 INFO  [stdout] (Thread-138)  )
 14:50:47,555 INFO  [stdout] (Thread-138) select  t.patient_num, 0 as
 panel_count  from t
 14:50:47,559 INFO  [stdout] (Thread-138) <*>
 14:50:47,559 INFO  [stdout] (Thread-138)  insert into DX (  patient_num
 ) select * from ( select distinct  patient_num  from QUERY_GLOBAL_TEMP
 where panel_count = 0 ) q
 14:50:47,561 INFO  [edu.harvard.i2b2.crc.dao.DataSourceLookupHelper]
 (Thread-138) Located DataSource for hiveId=[i2b2demo] projectId=[/Demo/]
 and ownerId =[@]
 14:50:47,562 INFO  [edu.harvard.i2b2.crc.dao.OracleDAOFactory]
 (Thread-138) Using datasource java:/QueryToolDemoDS
 14:50:47,641 INFO  [edu.harvard.i2b2.crc.dao.DataSourceLookupHelper]
 (Thread-138) Located DataSource for hiveId=[i2b2demo] projectId=[/Demo/]
 and ownerId =[@]
 14:50
 }}}


 But when I look in that directory I don't see an output file , not sure
 where the timeline_3.db came from but you had one of those also  :

 [root@localhost heron]# pwd
 /home/demo/heron
 [root@localhost heron]# ls -ltr
 total 128
 -rw-r--r-- 1 root root 126976 Nov  4 14:19 timeline_3.db
 [root@localhost heron]#

--
Ticket URL: 

gpc-informatics 
Greater Plains Network - Informatics
___
Gpc-dev mailing list
Gpc-dev@listserv.kumc.edu
http://listserv.kumc.edu/mailman/listinfo/gpc-dev

Re: [gpc-informatics] #87: Deploy, document R Data Builder demo service

[GPC Informatics]

#87: Deploy, document R Data Builder demo service
--+
 Reporter:  dconnolly |   Owner:  dconnolly
 Type:  task  |  Status:  accepted
 Priority:  major |   Milestone:  data-agg1
Component:  data-sharing  |  Resolution:
 Keywords:|  Blocked By:  134, 179
 Blocking:  119   |
--+

Comment (by gkowalski):

 Past step 5 , had to edit the /var/lib/pgsql/9.1/data/pg_hba.conf to add a
 local entry :

 {{{
 # TYPE  DATABASEUSERADDRESS METHOD
 local   all all trust
 hostall all 127.0.0.1/32trust
 hostall all 192.0.0.0/32trust
 hostall all 0.0.0.0/0   trust
 hostall all 141.0.0.0/32trust
 hostall all ::1/128 ident
 }}}

--
Ticket URL: 

gpc-informatics 
Greater Plains Network - Informatics
___
Gpc-dev mailing list
Gpc-dev@listserv.kumc.edu
http://listserv.kumc.edu/mailman/listinfo/gpc-dev

Re: [gpc-informatics] #87: Deploy, document R Data Builder demo service

[GPC Informatics]

#87: Deploy, document R Data Builder demo service
--+
 Reporter:  dconnolly |   Owner:  dconnolly
 Type:  task  |  Status:  accepted
 Priority:  major |   Milestone:  data-agg1
Component:  data-sharing  |  Resolution:
 Keywords:|  Blocked By:  134, 179
 Blocking:  119   |
--+

Comment (by gkowalski):

 My default ./var/lib/pgsql/9.1/data/pg_hba.conf file reads :
 {{{
 # TYPE  DATABASEUSERADDRESS METHOD
 hostall all 127.0.0.1/32trust
 hostall all 192.0.0.0/32trust
 hostall all 0.0.0.0/0   trust
 hostall all 141.0.0.0/32trust
 hostall all ::1/128 ident
 }}}

--
Ticket URL: 

gpc-informatics 
Greater Plains Network - Informatics
___
Gpc-dev mailing list
Gpc-dev@listserv.kumc.edu
http://listserv.kumc.edu/mailman/listinfo/gpc-dev

Re: [gpc-informatics] #87: Deploy, document R Data Builder demo service

[GPC Informatics]

#87: Deploy, document R Data Builder demo service
--+
 Reporter:  dconnolly |   Owner:  dconnolly
 Type:  task  |  Status:  accepted
 Priority:  major |   Milestone:  data-agg1
Component:  data-sharing  |  Resolution:
 Keywords:|  Blocked By:  134, 179
 Blocking:  119   |
--+

Comment (by gkowalski):

 Well I got to step 5 and received the error ( See
 ScreenShot_11_4_install_fail.png  attachment ) . I can connect to it from
 my native OS with pgadmin3 tool so the database is running correctly. I'm
 connecting as user postgres

--
Ticket URL: 

gpc-informatics 
Greater Plains Network - Informatics
___
Gpc-dev mailing list
Gpc-dev@listserv.kumc.edu
http://listserv.kumc.edu/mailman/listinfo/gpc-dev

RE: Agenda for the gpc-dev call today from Jim McClay

[Bos, Angela]

Started the agenda google doc

https://docs.google.com/document/d/1i6gXeOHTo_hy8scgN_qeqtCu2KnghTXHU6mrdS-r8lM/edit?usp=sharing


From: gpc-dev-boun...@listserv.kumc.edu 
[mailto:gpc-dev-boun...@listserv.kumc.edu] On Behalf Of Nathan Graham
Sent: Tuesday, November 04, 2014 10:39 AM
To: GPC-DEV@LISTSERV.KUMC.EDU
Subject: Agenda for the gpc-dev call today from Jim McClay

All,

Here is the agenda for the call gpc-dev call today that Jim McClay sent out Tue 
11/4/2014 8:43 AM.  gpc-dev wasn't 
in the copy list, but I think it's reasonably clear based on the e-mail 
discussion that he intended for it to be distributed to the group.

> 1)Patient Generated Information according to PCORI
> 2)Our proposal to PCORI dated 7-9-14
> 3)Survey of network capabilities
> 4)Next steps.
>
> Link to PCORI PRO Task Force Slides 
> https://pcornet.centraldesktop.com/taskforces/file/31721898/
___
Gpc-dev mailing list
Gpc-dev@listserv.kumc.edu
http://listserv.kumc.edu/mailman/listinfo/gpc-dev

Minor adjustment needed for QA query?

[Nadkarni, Prakash]

I just noticed that the initial query to identify active patients may have to 
be modified slightly - you also need to check that all of the patients are 
still alive. (One or more of them may have died recently, and they would still 
meet the criterion of 2+ visits over 3 years separated by 30+ days. - with our 
own data, there are about 200 patients less once the "alive" criterion is added.

Nathan Graham suggested that I use GPC-DEV to raise the issue.
Prakash




Notice: This UI Health Care e-mail (including attachments) is covered by the 
Electronic Communications Privacy Act, 18 U.S.C. 2510-2521, is confidential and 
may be legally privileged.  If you are not the intended recipient, you are 
hereby notified that any retention, dissemination, distribution, or copying of 
this communication is strictly prohibited.  Please reply to the sender that you 
have received the message in error, then delete it.  Thank you.

___
Gpc-dev mailing list
Gpc-dev@listserv.kumc.edu
http://listserv.kumc.edu/mailman/listinfo/gpc-dev

RE: Agenda for the gpc-dev call today from Jim McClay

[Bos, Angela]

I am getting an authorization error when I try to view the slides.


Angela Bos
Clinical Informatics Research Division
Department of Epidemiology and Biostatistics
UT Health Science Center at San Antonio
Phone: (210) 562-4074




From: gpc-dev-boun...@listserv.kumc.edu 
[mailto:gpc-dev-boun...@listserv.kumc.edu] On Behalf Of Nathan Graham
Sent: Tuesday, November 04, 2014 10:39 AM
To: GPC-DEV@LISTSERV.KUMC.EDU
Subject: Agenda for the gpc-dev call today from Jim McClay

All,

Here is the agenda for the call gpc-dev call today that Jim McClay sent out Tue 
11/4/2014 8:43 AM.  gpc-dev wasn't 
in the copy list, but I think it's reasonably clear based on the e-mail 
discussion that he intended for it to be distributed to the group.

> 1)Patient Generated Information according to PCORI
> 2)Our proposal to PCORI dated 7-9-14
> 3)Survey of network capabilities
> 4)Next steps.
>
> Link to PCORI PRO Task Force Slides 
> https://pcornet.centraldesktop.com/taskforces/file/31721898/
___
Gpc-dev mailing list
Gpc-dev@listserv.kumc.edu
http://listserv.kumc.edu/mailman/listinfo/gpc-dev

Agenda for the gpc-dev call today from Jim McClay

[Nathan Graham]

All,

Here is the agenda for the call gpc-dev call today that Jim McClay sent out Tue 
11/4/2014 8:43 AM.  gpc-dev wasn't 
in the copy list, but I think it's reasonably clear based on the e-mail 
discussion that he intended for it to be distributed to the group.

> 1)Patient Generated Information according to PCORI
> 2)Our proposal to PCORI dated 7-9-14
> 3)Survey of network capabilities
> 4)Next steps.
>
> Link to PCORI PRO Task Force Slides 
> https://pcornet.centraldesktop.com/taskforces/file/31721898/
___
Gpc-dev mailing list
Gpc-dev@listserv.kumc.edu
http://listserv.kumc.edu/mailman/listinfo/gpc-dev

Re: QA query text and sample output

[Tom Mish]

Thanks Alex,

A quick view of this makes me think that everything looks good with what 
you've got. I think in terms of anonymity, we  were keeping the actual 
results off of the gpc-dev list.


-TM


On 11/4/2014 9:45 AM, Alex Bokov wrote:
Here are the results from UTHSCSA except Q16 and Q17 which are still 
running.


I had to do some edits to the script to improve performance and 
correct assumptions about site-specific naming practices, and will 
send that out too once I have time to document it.


On 10/23/2014 02:58 PM, Debbie Yoshihara wrote:

Hi,

Here's the queries I ran at UW-Madison and some sample output.
The sample output is for example only and does not reflect reality.
If you haven't run the queries yet, for Q5, if you could reverse the
ordering of number of occurrences and score range that would be
great because then all the queries have the count, then the text.
If not, no worries, we will look at the data and switch the results when
we enter then into the database.

 Debbie




___
Gpc-dev mailing list
Gpc-dev@listserv.kumc.edu
http://listserv.kumc.edu/mailman/listinfo/gpc-dev


___
Gpc-dev mailing list
Gpc-dev@listserv.kumc.edu
http://listserv.kumc.edu/mailman/listinfo/gpc-dev

Re: QA query text and sample output

[Alex Bokov]

Here are the results from UTHSCSA except Q16 and Q17 which are still 
running.


I had to do some edits to the script to improve performance and correct 
assumptions about site-specific naming practices, and will send that out 
too once I have time to document it.


On 10/23/2014 02:58 PM, Debbie Yoshihara wrote:

Hi,

Here's the queries I ran at UW-Madison and some sample output.
The sample output is for example only and does not reflect reality.
If you haven't run the queries yet, for Q5, if you could reverse the
ordering of number of occurrences and score range that would be
great because then all the queries have the count, then the text.
If not, no worries, we will look at the data and switch the results when
we enter then into the database.

 Debbie




UTHSCSA_QA.xls
Description: application/msexcel
___
Gpc-dev mailing list
Gpc-dev@listserv.kumc.edu
http://listserv.kumc.edu/mailman/listinfo/gpc-dev