Yes, you just need to upload a .csv file to the GPC RedCap. The date columns should have 'YYYY-MM' format. That's strange how it has 3 columns per date....
Mei From: Gpc-dev [mailto:[email protected]] On Behalf Of Smith, Nicholas C Sent: Tuesday, September 05, 2017 10:22 AM To: Tamara McMahon; [email protected]; <[email protected]> Subject: RE: [External] GPC NEXT-D Table 1 request Hello, Mei: I have downloaded the .sql file and run it. Are we just supposed to upload a .csv file on to GPC RedCap of the query results? The columns in the query results of the .sql file do not match the TableFormat.pdf on RedCap. Specifically the pdf has only one column per date (YYYY-MM-DD) and the .sql query has 3 columns per date (one for year, one for month and one for day). Does it matter which format we send the results? Nick [cid:[email protected]] Nicholas C. Smith, MS Senior Database Architect Institute for Clinical & Translational Science (http://www.icts.uiowa.edu<http://www.icts.uiowa.edu/>) Email: [email protected]<mailto:[email protected]> Phone: 319-467-8173 From: Gpc-dev [mailto:[email protected]] On Behalf Of Tamara McMahon Sent: Tuesday, August 29, 2017 2:46 PM To: [email protected]<mailto:[email protected]>; <[email protected]<mailto:[email protected]>> Subject: [External] GPC NEXT-D Table 1 request All, As discussed in the Aug 29, 2017 GPC Dev meeting<https://docs.google.com/document/d/16dDncS115nkbRXQRZPUfDLie7j_y4s07-BQRNFyFloc/edit>, the NEXT-D team is requesting table 1 by Sept 5. If you cannot make this deadline, please submit when the data is available. Please submit your table 1 data for the NEXT-D study to this survey: https://redcap.gpcnetwork.org/surveys/?s=EATWF38RAP GPC Ticket #545<https://informatics.gpcnetwork.org/trac/Project/ticket/545> includes information on this request. At this time, the following sites have DROC approval to submit the data. Indiana KUMC Iowa MCW UTSW DROC review is not complete for the following sites. Please do not submit the data at this time. I will contact you once your DROC approves the request. Minnesota Missouri Nebraska These sites are not participating and can ignore this email. CMH Marshfield UTHSC-SA Wisconsin If you have any questions, please contact Mei Liu (copied) or myself. Thank you, Tamara McMahon Director, Engineering & Product Experience Medical Informatics & Enterprise Analytics University of Kansas Medical Center ________________________________ Notice: This UI Health Care e-mail (including attachments) is covered by the Electronic Communications Privacy Act, 18 U.S.C. 2510-2521 and is intended only for the use of the individual or entity to which it is addressed, and may contain information that is privileged, confidential, and exempt from disclosure under applicable law. If you are not the intended recipient, any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify the sender immediately and delete or destroy all copies of the original message and attachments thereto. Email sent to or from UI Health Care may be retained as required by law or regulation. Thank you. ________________________________
_______________________________________________ Gpc-dev mailing list [email protected] http://listserv.kumc.edu/mailman/listinfo/gpc-dev
