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

OpenClinica Data Export

I'm waiting for OpenClinica data export more as two hours now :-(
O.K. - I export more CRF (about 200 variables for 28 patients in SPSS format) at once, but why not !!!
Last time the export for 20 patent happened after one hour :-(
It's really terrible ...
My question for developers:
Are you using any "Cartesian Product" SQL queries ? It's an only reason how to explain such troubles with data export ..
My question for users:
Is there ANYBODY using OpenClinica for live study as we do right now?
Or are you ALL playing with data entry forms only ?
Maybe you have a better experience - please write it here, I looking for your tips how to do my job better :-(
Sorry, but I need really to export our data :-(
Karel Beber
statistician
A-Pharma, Prague
P.S. Please don't write me that I have to to run a pg_data_warehouse.sql query - I know it. We run this query regularly ...

Comments

  • pmarplespmarples Posts: 10
    Hi Karel
    It is my understanding that a near future version of OpenClinica will address these issues by redesigning the datamart.
    We also use the forms for live study and have had a few that are taking exceptionally long to extract. You could try to access the data directly from SQL.
    Pamela Marples
    Medical Informatics Specialist
    Email: [email protected]



    -----Original Message-----
    Sent: Wednesday, June 25, 2008 3:21 PM
    To: [email protected]
    Subject: [Users] OpenClinica Data Export
    Hi all,
    I'm waiting for OpenClinica data export more as two hours now :-(
    O.K. - I export more CRF (about 200 variables for 28 patients in SPSS format) at once, but why not !!!
    Last time the export for 20 patent happened after one hour :-(
    It's really terrible ...
    My question for developers:
    Are you using any "Cartesian Product" SQL queries ? It's an only reason how to explain such troubles with data export ..
    My question for users:
    Is there ANYBODY using OpenClinica for live study as we do right now?
    Or are you ALL playing with data entry forms only ?
    Maybe you have a better experience - please write it here, I looking for your tips how to do my job better :-(
    Sorry, but I need really to export our data :-(
    Karel Beber
    statistician
    A-Pharma, Prague
    P.S. Please don't write me that I have to to run a pg_data_warehouse.sql query - I know it. We run this query regularly ...
This discussion has been closed.