Import CRF Data via WebService

2»

Comments

  • yogiyogi Posts: 22
    edited November 2016
    Hi Tomas,

    thanks for comment. Okay lets start with Analyse. I wrote some Facts before but here are a complete overview:

    ODM XML: Import via Openclinica runs perfectly (ODM XML see the download from Gerben, it was my example for my instance)



    User that i used in soap is "root" same i try the Import in openclinica it self. The User root has all needed rights. The instance of openclinica is only for my try to Import some data, absolutly dev instance.

    I used the tool SoapUI to try the Import via webservice. At first i try to read out some Facts (like study Name, Subjects). This works fine. Than i try to write some data to Openclinica with Soap. User is root, same like befor in the other Project to read. Same instance. I don´t if you are confirm with that tool "SoapUI". I will post here the code, how i try to Import. (see zip file)

    i get an error from SoapUI

    <importDataResponse xmlns="http://openclinica.org/ws/data/v1">
    <result>Fail</result>
    <error>Your XML is not well-formed.</error>
    </importDataResponse>



    And know the question, why is it not well formed? it is the same that i try befor in openclinica it self. And there are no Connection Problems from soapUI to Openclinica ws. And why is the Data Response vom openclinica.org :| I see this the first time in this moment. Is it possible that i try to Import to openclinica.org :D

    Thanks! Best,
    Holger
  • toskriptoskrip Posts: 240 ✭✭
    openclinica.org is just a namespace... it should be fine

    try this:
    - in ClinicalData element change MetaDataVersionOID attribute to MetaDataVersionOID="v1.0.0"
    - remove OpenClinica:StartDate attribute from the second StudyEventData occurrence
    - remove OpenClinica:Status attribute from the second StudyEventData occurrence
    - remove OpenClinica:Version attribute from the FormData in the second StudyEventData

    you may try to compact the XML (remove the tabs and other white space characters)

    best

    Tomas
  • yogiyogi Posts: 22
    Hi,

    after some very hard hours i got it. I have found the way to import Data via SOAP for me. Some of the Tag´s were wrong. I´m wondering becaus in the documentation of OC there have to be there (one ODM Tag with big letters, no CDATA Tag..). Anyway, it is working now.

    Example:
    <div class="AlignCenter"><div class="AlignLeft"><soapenv:Body>
    <v1:importRequest>
    <ODM>
    <ClinicalData StudyOID="S_ZKSJ0101_4805" MetaDataVersionOID="v1.0.0">
    <UpsertON NotStarted="true" DataEntryStarted="true" DataEntryComplete="true"/>
    <SubjectData SubjectKey="SS_TRDE0100_8348">
    <StudyEventData StudyEventOID="SE_TARC" StudyEventRepeatKey="1">
    <FormData FormOID="F_TEST_TARC1_02">
    <ItemGroupData ItemGroupOID="IG_TEST__UNGROUPED_6071" ItemGroupRepeatKey="1" TransactionType="Insert">
    <ItemData ItemOID="I_TEST__TARC_ASS_D" Value="2016-10-24"/>
    <ItemData ItemOID="I_TEST__TARC_ASS_N" Value="0001"/>
    </ItemGroupData>
    </FormData>
    </StudyEventData>
    </SubjectData>
    </ClinicalData>
    </ODM>
    </v1:importRequest>
    </soapenv:Body></div></div>
    Thanks at all and special at Gerben, because i found the way with your access tool :# B)

    Best,
    Holger
Sign In or Register to comment.