We hope you'll join us for our 4/23 webinar on using data tables to apply reference ranges and AE codes in OC4. For more information and to register, visit https://register.gotowebinar.com/register/2882170018956684555

Re: [OpenClinica] sunbaghdad sent you a message

lindsay.stevenslindsay.stevens Posts: 404 ✭✭✭
edited October 2016 via Email in General Discussion
Hi @sunbaghdad,

The integration moves lab results entered in LabKey over to OpenClinica, so
we can more easily include that information in reports involving clinical
data.

I did it using a Python script, which calls the (very comprehensive) LabKey
API to retrieve JSON data, maps the data to OpenClinica items, and calls
the OpenClinica SOAP API to schedule events / insert data, using [0].

This script is then run every night as a scheduled task on a server. Data
mapping failures, or other problems, are written to log files for the
project team to review and resolve.

If scripting isn't your thing, or you need something user facing, LabKey
has a rather nice data extraction interface where you can save and export
datasets in a range of formats, such as CSV. You could then use the
DataUploader tool [1] to map and import this to OpenClinica (not sure if
[1] handles repeat visits yet, otherwise there's ODIN [2] or the Access
Data Uploader [3], or the built in XML import UI).

I'm not certain about moving data from OpenClinica to LabKey, but it would
be a similar story - use the OC REST API (or extracts, or datamart) to
retrieve data from OC, and load into LabKey with a script or via the
website user interface.

So I guess like many clinical software system integrations, it's not
exactly plug and play :) if you have any other questions feel free to ask.

Best regards,
Lindsay

[0] https://github.com/lindsay-stevens/openclinica_scripts (see readme on
"webservices")
[1] https://github.com/thehyve/Open-Clinica-Data-Uploader
[2] https://community.openclinica.com/extension/odin
[3] https://community.openclinica.com/extension/ocdataimporter

On 17 Oct 2016 5:29 am, "sunbaghdad"
wrote:

OpenClinica https://forums.openclinica.com/



sunbaghdad sent you a message



Dear Lindsay,



I have read that your are using LabKey to connect with OpenClinica, can you
please tell me how did you do that ?

Or what tools do I need to make it happen ?



Sincerely,
Sign In or Register to comment.