Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Steve Borg 28 posts 99 karma points
    Jun 08, 2017 @ 06:57
    Steve Borg
    0

    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:

    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.

    Any idea why this is failing to import?

    Best regards,

    Steve

  • Richard Soeteman 3828 posts 11859 karma points MVP
    Jun 08, 2017 @ 08:48
    Richard Soeteman
    0

    Hi Steve,

    This message comes from the datatype. What happens if you use a different property editor?

    Best,

    Richard

  • Steve Borg 28 posts 99 karma points
    Jun 08, 2017 @ 16:02
    Steve Borg
    0

    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

  • Richard Soeteman 3828 posts 11859 karma points MVP
    Jun 09, 2017 @ 06:48
    Richard Soeteman
    0

    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 support@soetemansoftware.nl.

Please Sign in or register to post replies

Write your reply to:

Draft