Reply To: Need to build an interface for XML to SQL Datadata

Reply To: Need to build an interface for XML to SQL Datadata

Home Forums NAACCR XML Standard Need to build an interface for XML to SQL Datadata Reply To: Need to build an interface for XML to SQL Datadata

#9657

Jeff,

Would you mind running a test for me? You said you were able to get your code to retrieve data values using the “byNaaccrNum” function. Could you run the loop so that you first call “byNaaccrNum” and then call “byNaaccrId”? I’m trying to narrow the problem down to support my hunch about the declarations, and need to know that all of the other functions are working as advertised.

So the pseudo-code would look like this (note that all of these calls should capture and test the return value… this is just pseudo-code for program flow):

XMLPlus_Initialize(...)
XMLPlus_OpenXmlDataFile(...)

/* while not end-of-file */
{
    XMLPlus_ReadNextPatient(...)

    XMLPlus_GetPatientTumorsCount(...)

    for (<iterate over tumors for current patient>)
    {
        XMLPlus_ReadTumor(...)

        for (<iterate list of data items you want>)
        {
             XMLPlus_GetItemDataByNaaccrNum(...)
             XMLPlus_GetItemDataByNaaccrId(...)
        }
    }
}

XMLPlus_CloseXmlDataFile(...)
XMLPlus_Exit(...)

You might even hard-code some items for this test, e.g., naaccrNum=390 and naaccrId=”dateOfDiagnosis”. Let me know what happens.

Thanks,
Kathleen

Copyright © 2018 NAACCR, Inc. All Rights Reserved | naaccr-swoosh-only See NAACCR Partners and Sponsors