I got the following error when trying to import a product property into the product extended content:
2017-06-08 07:43:34,956 [P24584/D2/T176] ERROR CMSImport.Merchello.ImportProviders.Product.ProductImportProvider - CMSImport:Product 'Product1' failed to import
System.ArgumentException: value '<PriceCollection><Prices><Price SKU = "PROD1SKU....' is too long for it's underlying datatype
at CMSImportLibrary.Helpers.PropertyValueValidator.ValidateNVarCharProperty(Object )
at CMSImportLibrary.Helpers.PropertyValueValidator.ValidateProperty(PropertyInfo propertyInfo, Object value)
at CMSImport.Merchello.ImportProviders.Product.ProductImportProvider.(ImportActions , IProduct , ProductType , Dictionary`2 , AdvancedSettingFieldOptions , PropertyInfo , Object , ImportState , Boolean& )
at CMSImport.Merchello.ImportProviders.Product.ProductImportProvider.(ImportState , ImportState , Int32 , ImportStatistics )
The property is designated a text area and the size of the string I am trying to add is 6390 characters and consists of XML which includes <, >, ", -, = and / characters.
I created a new textbox property in my document type and re-configured the import to use that and it gave the same problem.
Which property editor should I use? Please note, as I didn't make it clear in my original post, that this is a Merchello product import into a property of the extended content.
Is too long for it's underlying datatype
Hi,
I got the following error when trying to import a product property into the product extended content:
The property is designated a text area and the size of the string I am trying to add is 6390 characters and consists of XML which includes <, >, ", -, = and / characters.
Any idea why this is failing to import?
Best regards,
Steve
Hi Steve,
This message comes from the datatype. What happens if you use a different property editor?
Best,
Richard
Hi Richard,
I created a new textbox property in my document type and re-configured the import to use that and it gave the same problem.
Which property editor should I use? Please note, as I didn't make it clear in my original post, that this is a Merchello product import into a property of the extended content.
Best regards,
Steve
It is weird since extended content is stored as ntext and the property should also be ntext and kept out of validation.
Is it an environment you can share with me? If so please email [email protected].
is working on a reply...