31 Dec 2018: Thank you to our knowledgeable and friendly forums users for another great year. We are aware of the uptick in spam accounts and are doing our best to ban these at first sight. Thank you for your patience!

Import CRF Data via WebService

2»

Comments

  • yogiyogi Posts: 25
    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: 267 ✭✭✭
    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: 25
    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.