Transferring data from XML

You can transfer data from an XML file using XML CDSC, provided the data is stored using the UNICOM Intelligence schema. For more information, see XML DSC.

Note The XML DSC is supplied by UNICOM Intelligence for the purpose of demonstrating and testing the transfer of small volumes of data. Do not use the XML DSC in production processes; use the UNICOM Intelligence Data File CDSC instead. The XML DSC might be withdrawn in a future release of UNICOM Intelligence.

Case data that is stored in an XML file is typically used with metadata in an .mdd file. When the case data is collected using UNICOM Intelligence software, the .mdd file will typically contain versions, which record any changes to the content of the questionnaire. Typically, when the metadata changes (for example, when variables or categories are added or deleted) a new version is created and when the changes are complete, the version is locked. For more information, see Understanding versions.

In the connection string in the InputDataSource section, specify mrXmlDsc for the Data Source property. Specify the name and location of the XML file for the Location connection property and the name and location of the .mdd file for the Initial Catalog connection property:

InputDatasource(myInputDataSource, "My input data source")
  ConnectionString = "Provider=mrOleDB.Provider.2; _
    Data Source=mrXmlDsc; _
    Location=<Name and location of the XML file>; _
    Initial Catalog=<Name and location of .mdd file>"
End InputDatasource

The sample data management script called MyFirstCleaningScript.dms, which is supplied with the UNICOM Intelligence Developer Documentation Library, reads data from an XML file. See Sample DMS files.