Re: Didn't see DX and DEMO working on shrine for MCW

2018-05-01 Thread French, Tony
The IU Spoke should be back online now. Tony Tony French | Assistant Director of Technical Services [cid:CB7EA844-ABD4-4807-B128-D41CFC75BC23] 1101 West Tenth Street Indianapolis, IN, 46202 Tel 317-274-9087 | Fax: 317-274-9305 Twitter: @Regenstrief | Facebook.com/regenstriefinstitute

Indiana SHRINE down on 3/22 at 2pm

2018-03-20 Thread French, Tony
The Indiana SNOW node will be unavailable this Thursday, 3/22/2018 from 2PM - 5PM EST while we apply regular Database and Security patches. Please let me know if you have any questions. Thank you, Tony French Tony French | Interim Assistant Director of Technical Services Center for

Indiana: Server maintenance 1/11/18 2PM - 5 PM EST

2018-01-09 Thread French, Tony
The Indiana SNOW/SHRINE Node will be unavailable this Thursday, 1/11/2018 from 2PM - 5PM EST while we apply regular Database and Security patches. Please let me know if you have any questions. Thank you, Tony French Tony French | Interim Assistant Director of Technical Services Center for

Re: SNOW SHRINE status: bonus for UTSW, UTHSCSA, UMN

2017-12-12 Thread French, Tony
Indiana was applying production patches yesterday. Our node should be up and responding now. We'll have to remember to add our SHRINE partners to our downtime and maintenance window announcements. -Tony Tony French | Interim Assistant Director of Technical Services Center for Biomedical In

Re: GPC SNOW SHRINE status at LEC - 2 Weeks: gold: UTSW, KUMC; silver: MCRF; bronze: WISC, UNMC

2017-10-03 Thread French, Tony
I am actively working (over weekend, yesterday and today) on the Indiana node and hope to have the issues resolved ASAP. I just sent a question to the SHRINE listserve but perhaps someone here knows the answer: When running i2b2 and SHRINE on separate application servers, does the I2B2 server n

Re: Question on CDMv3.1 Run

2017-07-25 Thread French, Tony
results from our CDM tables while we employ conversion factors and unit changes on the associated tests. Jim From: Gpc-dev mailto:gpc-dev-boun...@listserv.kumc.edu>> on behalf of Michael Prittie mailto:mprit...@kumc.edu>> Sent: Wednesday, July 19, 201

Re: Question on CDMv3.1 Run

2017-07-25 Thread French, Tony
changes on the associated tests. Jim From: Gpc-dev mailto:gpc-dev-boun...@listserv.kumc.edu>> on behalf of Michael Prittie mailto:mprit...@kumc.edu>> Sent: Wednesday, July 19, 2017 4:19:54 PM To: French, Tony; Stoddard, Alexander; dsteg...@uwhealth.org<mailto:dste

Re: Question on CDMv3.1 Run

2017-07-19 Thread French, Tony
Related to this topic: OBSERVATION_FACT.NVAL_NUM is defined as NUMBER(18,5). However, the CDM V3.1 LAB_RESULT_CM.RESULT_NUM is defined as NUMBER(15,8). How have the sites handled this discrepancy? Or perhaps the data has largely fit without any issues? Thanks, Tony Tony French | Interim As

i2b2 shibboleth or SAML authentication

2017-06-13 Thread French, Tony
We are looking to replace our existing i2b2 authentication logic with Shibboleth or SAML authentication. I am researching existing solutions before attempting to design something from scratch but the couple of projects that I have found appear to be abandoned or out-of-date. Does anyone have

GROUSE Finder File - DOB

2017-01-25 Thread French, Tony
Should the DOB values be offset to match our I2B2 and CDM data or is it supposed to be the actual DOB? The Finder file should have all of the following fields, correct? PATIENT_NUM: Patient Identifier that aligns with our I2B2 and CDM data SSN: Social Security Number with no hy

PopMedNet MDQ with Oracle SID

2016-12-21 Thread French, Tony
Has anyone been successful at configuring the PopMedNet client to connect to Oracle using a SID, instead of a service name? I'm getting an "ORA-12514, TNS:listener does not currently know of service requested in connect descriptor" error when I attempt to use our SID for the Database value. (

Re: [gpc-informatics] #443: IU / Regenstrief Cancer Tumor Registry on babel

2016-10-05 Thread French, Tony
If the data is loaded and I have access to view the tables, I can poke around and see if I can find any obvious issues. -Tony On 10/5/16, 5:04 PM, "GPC Informatics" wrote: >#443: IU / Regenstrief Cancer Tumor Registry on babel >--+

Re: NAACCR ETL

2016-08-11 Thread French, Tony
KUMC folks: I’m trying to use the babel SQL IDE to download the structure and data for who.topo, t_item, tcode and t_section, as mentioned below, but the downloaded files are empty. Is there another way to get a copy of those tables? The loading scripts also rely on tables such as who.topo; y

NAACCR ETL

2016-08-11 Thread French, Tony
Does https://informatics.gpcnetwork.org/trac/Project/wiki/NAACCR_ETL still reflect the latest information/version for running the NAACCR load, including summary of treatment? Also, could someone please confirm that the ETL is compatible with NAACCR ver. 15 Thanks, -Tony __

RE: DataBuilder installation instructions

2016-07-09 Thread French, Tony
[mailto:dconno...@kumc.edu] Sent: Thursday, July 07, 2016 12:11 PM To: French, Tony; GPC-DEV@LISTSERV.KUMC.EDU Subject: RE: DataBuilder installation instructions That's pretty much the main installation documentation, still. And that it is out of date is a known problem: * #335: proble

RE: DataBuilder installation instructions

2016-07-07 Thread French, Tony
Indiana would participate. From: Campbell, James R [mailto:campb...@unmc.edu] Sent: Thursday, July 07, 2016 4:12 PM To: Dan Connolly Cc: Phillip Reeder; French, Tony; GPC-DEV@LISTSERV.KUMC.EDU Subject: Re: DataBuilder installation instructions UNMC would participate James R. Campbell MD campb

DataBuilder installation instructions

2016-07-07 Thread French, Tony
We are working on getting DataBuilder installed in our environment. I found the BuilderSaga article for installing it into an i2b2 demo VM. Is that the best guide to reference for installing it into an actual working environmen

GitHub

2016-06-13 Thread French, Tony
KUMC folks, Could you please verify that I have access to the appropriate GitHub sites mentioned in ticket #463? I'm specifically looking for the NAACR ETL. I am able to see three repositories under https://github.com/kumc-bmi, does that sound correct or should there be more? My GitHub profi

RE: [gpc-informatics] #473: PCORnet CDMv3 SAS prep-to-research Readiness

2016-04-18 Thread French, Tony
Indiana first submitted the Diagnostic Query on 4/13 without ENROLLMET or VITAL data: Enrollment - As an HIE based repository, we do not have insurance data and were unaware of the agreed upon GPC algorithm for calculating enrollments. VITAL - Was not previously mapped in i2b

RE: SAS views for CDM v3 data characterization query

2016-04-13 Thread French, Tony
ahead and post our diagnostic query results now and hopefully post the characterization results by the end of the week. We'll then circle back to correct the 12/24 hour format later , if needed. --Tony From: Michael Prittie [mailto:mprit...@kumc.edu] Sent: Wednesday, April 13, 2016 2:01

RE: SAS views for CDM v3 data characterization query

2016-04-13 Thread French, Tony
Michael and all, We are stuck on the _TIME column conversions. We are using Oracle and have those columns defined as varchar2(5) based on the RDBMS specs. We have chosen to run SAS directly against Oracle, at least for now. However, we are unclear on how to map the varchar2(5) columns to a f

Re: gpc_terms --> pcornet_terms mapping

2016-03-11 Thread French, Tony
Just trying to follow the various threads... what are the differences between gpc-pcorenet-cdm and i2p-transform projects? Am I wrong in thinking that they are just two different approaches to converting the GPC i2b2 structure to the PCORNet CDM? Was the gpc-pcorenet-cdm approach taken by the

gpc_terms --> pcornet_terms mapping

2016-03-10 Thread French, Tony
Is there a mapping file to go between the GPC and PCORNet ontologies? The SCILHS code includes a mapping between the SCILHS terms and PCORNet, but I know both have slight differences from the GPC terms. I have been reviewing gpc-pcorenet-cdm/pcori_to_gpc.csv but I immediately notice that it d

Babel

2016-01-13 Thread French, Tony
We are able to login to Babel (i2b2) but are not seeing any of the ontologies. Not a big deal at the moement but wanted to make sure the KUMC folks are aware if they aren’t else wise performing maintenance. Thanks, Tony Tony French | Systems Engineer - RPG Team Lead [cid:BD5D9E5E-D273-