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

Export inconsistencies between XML and dat/txt formats

Dear OpenClinica developers,
We've been using OpenClinica for some time now, and are very happy with it. However, we've recently come across what seems to be a bug with exporting. When we export a dataset to txt or SPSS (dat) formats, we get all the data fields we expected. However, when we click the CDISC ODM XML 1.3 option, we get an XML file that does not include all the requested fields.
For example, uploads of the files are located at:
Tab-delimited text: http://www.bnac.net/dl/Study_scan_tab.xls
CDISC ODM XML 1.3: http://www.bnac.net/dl/Study_scanD20100625143553-0400.xml
In the tab-delimited text file, for example, the event location is available, and the first subject's location is "Georgia"
However, the word "Georgia" is not present at all in the XML version.
Any help on this would be greatly appreciated, as we'd really like to work with the XML formatted data.
Thanks!
-Mike
--
Michael Dwyer
Director of Technical Imaging Development
Buffalo Neuroimaging Analysis Center
100 High St. Buffalo NY 14203
[email protected]
(716) 859-7065

Comments

  • Paul GalvinPaul Galvin Posts: 886
    Hi Mike,

    A similar question was answered earlier Friday morning. The data collected outside of the CRFs will not be included in the standard ODM files. You need to choose the file called OpenClinica-Extension-1.3 or 1.2. This contains the standard ODM with OpenClinica extensions that will include the data like Location.

    Thanks,
    Paul

    -----------------------------------------------------------------------
    Paul J. Galvin
    Project Manager
    Akaza Research
    781-547-8425
    www.openclinica.org
    ~ OpenClinica Enterprise ~ Ask me about professional training, support, and services for OpenClinica
    ***To search the archives of the User and Developer Forums, please go to http://www.openclinica.org/page.php?pid=107***
    Sent: Friday, June 25, 2010 1:47 PM
    To: [email protected]
    Subject: [Developers] Export inconsistencies between XML and dat/txt formats

    Dear OpenClinica developers,
    We've been using OpenClinica for some time now, and are very happy with it. However, we've recently come across what seems to be a bug with exporting. When we export a dataset to txt or SPSS (dat) formats, we get all the data fields we expected. However, when we click the CDISC ODM XML 1.3 option, we get an XML file that does not include all the requested fields.
    For example, uploads of the files are located at:
    Tab-delimited text: http://www.bnac.net/dl/Study_scan_tab.xls
    CDISC ODM XML 1.3: http://www.bnac.net/dl/Study_scanD20100625143553-0400.xml
    In the tab-delimited text file, for example, the event location is available, and the first subject's location is "Georgia"
    However, the word "Georgia" is not present at all in the XML version.
    Any help on this would be greatly appreciated, as we'd really like to work with the XML formatted data.
    Thanks!
    -Mike
    --
    Michael Dwyer
    Director of Technical Imaging Development
    Buffalo Neuroimaging Analysis Center
    100 High St. Buffalo NY 14203
    [email protected]bnac.net
    (716) 859-7065
This discussion has been closed.