>>>>I have a project where I need to parse data in NTCIP XML format and INSERT it into an SQL Server database. Being very familiar with VFP, I think that VFP8 may a good tool, and have been trying to use the XMLTOCURSOR() function.
>>>>
>>>>Unfortunately, I haven't been able to get it to work. If I provide a sample XML file can anybody show me the correct syntax to open it?
>>>
>>>Hi Andrew,
>>>
>>>You wouldn't know until you post it here. :)
>>
>>Good point! In trying to post the XML inside this message I get an error about including a style in my posting.
>>
>>Is there a way to attach the file independently through this messaging interface?
>
>You cannot attach file but you can use < pre > < /pre > tags (no spaces) to wrap XML and preserve it from UT parser.

Thanks! Herewith the file...

<ntcipMessage source="amherst-qual" lat="38645000" lon="121485000" type="obs" dataTime="20030731T153150" xsi:noNamespaceSchemaLocation="http://ice.tmi.vaisala.com/ntcip.xsd">
<value name="essSurfaceStatus.1">3</value>
<value name="essSurfaceTemperature.1">360</value>
<value name="essSurfaceWaterDepth.1">4</value>
<value name="essSurfaceSalinity.1">655350</value>
<value name="essPavementTemperature.1">360</value>
<value name="essSurfaceConductivity.1">0</value>
<value name="essSurfaceFreezePoint.1">1001</value>
<value name="essSurfaceBlackIceSignal.1">0</value>
<value name="essPavementSensorError.1">2</value>
<value name="essSurfaceStatus.2">3</value>
<value name="essSurfaceTemperature.2">344</value>
<value name="essSurfaceWaterDepth.2">4</value>
<value name="essSurfaceSalinity.2">655350</value>
<value name="essPavementTemperature.2">344</value>
<value name="essSurfaceConductivity.2">0</value>
<value name="essSurfaceFreezePoint.2">1001</value>
<value name="essSurfaceBlackIceSignal.2">0</value>
<value name="essPavementSensorError.2">2</value>
<value name="essAirTemperature.1">181</value>
<value name="essAtmosphericPressure.0">10172</value>
<value name="essAvgWindDirection.0">14</value>
<value name="essAvgWindSpeed.0">19</value>
<value name="essMaxWindGustSpeed.0">43</value>
<value name="essMaxWindGustDir.0">20</value>
<value name="essRelativeHumidity.0">69</value>
<value name="essPrecipRate.0">0</value>
<value name="essSnowfallAccumRate.0">65535</value>
<value name="essPrecipitationOneHour.0">0</value>
<value name="essPrecipitationThreeHours.0">0</value>
<value name="essPrecipitationSixHours.0">0</value>
<value name="essPrecipitationTwelveHours.0">0</value>
<value name="essPrecipitation24Hours.0">0</value>
<value name="essSolarRadiation.0">65535</value>
<value name="essTotalSun.0">1441</value>
<value name="essSpotWindDirection.0">23</value>
<value name="essSpotWindSpeed.0">22</value>
<value name="essWindSituation.0">2</value>
<value name="essWetbulbTemp.0">142</value>
<value name="essDewpointTemp.0">126</value>
<value name="essMaxTemp.0">239</value>
<value name="essMinTemp.0">119</value>
<value name="essWaterDepth.0">65535</value>
<value name="essAdjacentSnowDepth.0">3001</value>
<value name="essRoadwaySnowDepth.0">3001</value>
<value name="essRoadwaySnowPackDepth.0">3001</value>
<value name="essPrecipYesNo.0">2</value>
<value name="essPrecipSituation.0">3</value>
<value name="essIceThickness.0">65535</value>
<value name="essPrecipitationStartTime.0">1059618540</value>
<value name="essPrecipitationEndTime.0">1059618600</value>
<value name="essVisibility.0">17703</value>
<value name="essVisibilitySituation.0">2</value>
<value name="essSubSurfaceTemperature.1">238</value>
<value name="essSubSurfaceMoisture.1">101</value>
<value name="essSubSurfaceSensorError.1">2</value>
<value name="essSubSurfaceTemperature.2">1001</value>
<value name="essSubSurfaceMoisture.2">101</value>
<value name="essSubSurfaceSensorError.2">2</value>
<value name="essSubSurfaceTemperature.3">1001</value>
<value name="essSubSurfaceMoisture.3">101</value>
<value name="essSubSurfaceSensorError.3">2</value>
<value name="essSubSurfaceTemperature.4">1001</value>
<value name="essSubSurfaceMoisture.4">101</value>
<value name="essSubSurfaceSensorError.4">2</value>
<value name="essSubSurfaceTemperature.5">1001</value>
<value name="essSubSurfaceMoisture.5">101</value>
<value name="essSubSurfaceSensorError.5">2</value>
<value name="essSubSurfaceTemperature.6">1001</value>
<value name="essSubSurfaceMoisture.6">101</value>
<value name="essSubSurfaceSensorError.6">2</value>
<value name="essSubSurfaceTemperature.7">1001</value>
<value name="essSubSurfaceMoisture.7">101</value>
<value name="essSubSurfaceSensorError.7">2</value>
<value name="essSubSurfaceTemperature.8">1001</value>
<value name="essSubSurfaceMoisture.8">101</value>
<value name="essSubSurfaceSensorError.8">2</value>
<value name="essSubSurfaceTemperature.9">1001</value>
<value name="essSubSurfaceMoisture.9">101</value>
<value name="essSubSurfaceSensorError.9">2</value>
<value name="essSubSurfaceTemperature.10">1001</value>
<value name="essSubSurfaceMoisture.10">101</value>
<value name="essSubSurfaceSensorError.10">2</value>
<value name="essSubSurfaceTemperature.11">1001</value>
<value name="essSubSurfaceMoisture.11">101</value>
<value name="essSubSurfaceSensorError.11">2</value>
<value name="essSubSurfaceTemperature.12">1001</value>
<value name="essSubSurfaceMoisture.12">101</value>
<value name="essSubSurfaceSensorError.12">2</value>
<value name="essSubSurfaceTemperature.13">1001</value>
<value name="essSubSurfaceMoisture.13">101</value>
<value name="essSubSurfaceSensorError.13">2</value>
<value name="essSubSurfaceTemperature.14">1001</value>
<value name="essSubSurfaceMoisture.14">101</value>
<value name="essSubSurfaceSensorError.14">2</value>
<value name="essSubSurfaceTemperature.15">1001</value>
<value name="essSubSurfaceMoisture.15">101</value>
<value name="essSubSurfaceSensorError.15">2</value>
<value name="essSubSurfaceTemperature.16">1001</value>
<value name="essSubSurfaceMoisture.16">101</value>
<value name="essSubSurfaceSensorError.16">2</value>
<value name="essSubSurfaceTemperature.17">1001</value>
<value name="essSubSurfaceMoisture.17">0</value>
<value name="essSubSurfaceSensorError.17">0</value>
<value name="essSubSurfaceTemperature.18">1001</value>
<value name="essSubSurfaceMoisture.18">0</value>
<value name="essSubSurfaceSensorError.18">0</value>
<value name="essSubSurfaceTemperature.19">1001</value>
<value name="essSubSurfaceMoisture.19">0</value>
<value name="essSubSurfaceSensorError.19">0</value>
<value name="essSubSurfaceTemperature.20">1001</value>
<value name="essSubSurfaceMoisture.20">0</value>
<value name="essSubSurfaceSensorError.20">0</value>
<value name="essSubSurfaceTemperature.21">1001</value>
<value name="essSubSurfaceMoisture.21">0</value>
<value name="essSubSurfaceSensorError.21">0</value>
</ntcipMessage>