- XML or SQL error: Error converting data type nvarchar to float.
It happens when I try to import an XML file containing informtion on products.
Here is an example of a procuct in the XML file.
<Product>
<ProductID>1080103804-1</ProductID>
<ProductLanguageID>LANG1</ProductLanguageID>
<ProductVariantID />
<ProductGroupID>Handel</ProductGroupID>
<ProductNumber></ProductNumber>
<ProductName>Choice Nøglekort " Icebar"</ProductName>
<ProductShortDescription>Choice Nøglekort " Icebar"</ProductShortDescription>
<ProductLongDescription>Kasser a. 2.000 stk.</ProductLongDescription>
<ProductImageSmall></ProductImageSmall>
<ProductImageMedium></ProductImageMedium>
<ProductImageLarge></ProductImageLarge>
<ProductLink1></ProductLink1>
<ProductLink2></ProductLink2>
<ProductPrice>0.30</ProductPrice>
<ProductStock>0</ProductStock>
<ProductWeight>0.00</ProductWeight>
<ProductVolume>0</ProductVolume>
<ProductManufacturerID />
<ProductActive>True</ProductActive>
<ProductPeriodID />
</Product>