In case you didn't receive notification, I've attached our scripts to ticket #644.
Thanks, Laurel From: Gpc-dev [mailto:gpc-dev-boun...@listserv.kumc.edu] On Behalf Of Dan Connolly Sent: Wednesday, April 11, 2018 11:28 AM To: Smith, Nicholas C; McNeeley, Todd Alexander; French, Tony Cc: Daryl Budine; , Subject: format for GROUSE i2b2 datamart submission from SQL Server Nick (UIOWA), Todd (MU), Tony (IU), let me know whether this makes sense to you... Please send us tab-delimited files. This is based on positive experience with data submitted by Marshfield in Aug 2017. This control file is in Oracle syntax, but I think it's a reasonably clear spec: LOAD DATA INFILE 'concept_dimension_base.dat' TRUNCATE INTO TABLE BLUEHERONDATA_MCRI.CONCEPT_DIMENSION FIELDS TERMINATED BY X'09' ( CONCEPT_PATH CHAR , CONCEPT_CD CHAR , NAME_CHAR CHAR , UPDATE_DATE timestamp 'YYYY-MM-DD HH24:MI:SS.FF', DOWNLOAD_DATE timestamp 'YYYY-MM-DD HH24:MI:SS.FF', IMPORT_DATE timestamp 'YYYY-MM-DD HH24:MI:SS.FF', SOURCESYSTEM_CD CHAR ) Aug 2017 Marshfield submission details are in https://informatics.gpcnetwork.org/trac/Project/ticket/595#comment:31<https://urldefense.proofpoint.com/v2/url?u=https-3A__informatics.gpcnetwork.org_trac_Project_ticket_595-23comment-3A31&d=DwMFAw&c=KNVzINr6WAqWApikNSnyDeOu0ck0iFwcrMz92MxUhIs&r=A2PXk2ZGVGBzoEOQMwrrboZc0kb2NWGliRjTa4b3xxXo7HiAVoZaxWlIgfPM_ia9&m=xSAc2NzswwZf4zXfXneBTv6Bffzq8szap_FFXcv0Hrs&s=rO-ix0o6vn7--Q-FzyIYXY2g-oIZke3LWjlb215g7ZI&e=> -- Dan
_______________________________________________ Gpc-dev mailing list Gpc-dev@listserv.kumc.edu http://listserv.kumc.edu/mailman/listinfo/gpc-dev
