Copied to clipboard

Flag this post as spam?

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


  • Merijn van Mourik 58 posts 128 karma points
    Feb 07, 2013 @ 10:25
    Merijn van Mourik
    0

    Excel importing fails on particular field

    This is what I get in the log when importing field 'metaDescription'. It's just a normal textstring field:

    Error while importing data for property 'metaDescription', datasource record Name = 'walibi holland', Error :The best overloaded method match for 'Umbraco.Core.Models.ContentBase.SetPropertyValue(string, string)' has some invalid arguments 
    Error while importing data for property 'metaDescription', datasource record Name = 'dolfinarium', Error :The best overloaded method match for 'Umbraco.Core.Models.ContentBase.SetPropertyValue(string, string)' has some invalid arguments 
    Error while importing data for property 'metaDescription', datasource record Name = 'skidome', Error :The best overloaded method match for 'Umbraco.Core.Models.ContentBase.SetPropertyValue(string, string)' has some invalid arguments 
    Error while importing data for property 'metaDescription', datasource record Name = 'thermen holiday', Error :The best overloaded method match for 'Umbraco.Core.Models.ContentBase.SetPropertyValue(string, string)' has some invalid arguments 
    Error while importing data for property 'metaDescription', datasource record Name = 'dierenpark emmen', Error :The best overloaded method match for 'Umbraco.Core.Models.ContentBase.SetPropertyValue(string, string)' has some invalid arguments 
    Error while importing data for property 'metaDescription', datasource record Name = 'dutch water dreams', Error :The best overloaded method match for 'Umbraco.Core.Models.ContentBase.SetPropertyValue(string, string)' has some invalid arguments 
    Error while importing data for property 'metaDescription', datasource record Name = 'safaripark beekse bergen', Error :The best overloaded method match for 'Umbraco.Core.Models.ContentBase.SetPropertyValue(string, string)' has some invalid arguments 

    This is the log:

    CMSImport: A record failed to import for aliasmetaDescription error:Microsoft.CSharp.RuntimeBinder.RuntimeBinderException: The best overloaded method match for 'Umbraco.Core.Models.ContentBase.SetPropertyValue(string, string)' has some invalid arguments
       at CallSite.Target(Closure , CallSite , Object , String , Object )
       at System.Dynamic.UpdateDelegates.UpdateAndExecuteVoid3[T0,T1,T2](CallSite site, T0 arg0, T1 arg1, T2 arg2)
       at Umbraco.Core.Models.ContentBase.SetValue(String propertyTypeAlias, Object value)
       at umbraco.cms.businesslogic.web.Document.Save()
       at CMSImportLibrary.Import.ContentImporter.(ImportState , User , ImportStatistics , String , Int32 , String )
    2013-02-07 10:11:31,398 [9] INFO  umbraco.BusinessLogic.Log - [Thread 60] Redirected log call (please use Umbraco.Core.Logging.LogHelper instead of umbraco.BusinessLogic.Log) | Type: Error | User: 0 | NodeId: 0 | Comment: CMSImport: A record failed to import for aliasmetaDescription error:Microsoft.CSharp.RuntimeBinder.RuntimeBinderException: The best overloaded method match for 'Umbraco.Core.Models.ContentBase.SetPropertyValue(string, string)' has some invalid arguments
       at CallSite.Target(Closure , CallSite , Object , String , Object )
       at System.Dynamic.UpdateDelegates.UpdateAndExecuteVoid3[T0,T1,T2](CallSite site, T0 arg0, T1 arg1, T2 arg2)
       at Umbraco.Core.Models.ContentBase.SetValue(String propertyTypeAlias, Object value)
       at umbraco.cms.businesslogic.web.Document.Save()
       at CMSImportLibrary.Import.ContentImporter.(ImportState , User , ImportStatistics , String , Int32 , String )
    2013-02-07 10:11:31,461 [9] INFO  umbraco.BusinessLogic.Log - [Thread 54] Redirected log call (please use Umbraco.Core.Logging.LogHelper instead of umbraco.BusinessLogic.Log) | Type: Error | User: 0 | NodeId: 0 | Comment: CMSImport: A record failed to import for aliasmetaDescription error:Microsoft.CSharp.RuntimeBinder.RuntimeBinderException: The best overloaded method match for 'Umbraco.Core.Models.ContentBase.SetPropertyValue(string, string)' has some invalid arguments
       at CallSite.Target(Closure , CallSite , Object , String , Object )
       at System.Dynamic.UpdateDelegates.UpdateAndExecuteVoid3[T0,T1,T2](CallSite site, T0 arg0, T1 arg1, T2 arg2)
       at Umbraco.Core.Models.ContentBase.SetValue(String propertyTypeAlias, Object value)
       at umbraco.cms.businesslogic.web.Document.Save()
       at CMSImportLibrary.Import.ContentImporter.(ImportState , User , ImportStatistics , String , Int32 , String )
    2013-02-07 10:11:31,463 [9] INFO  umbraco.BusinessLogic.Log - [Thread 29] Redirected log call (please use Umbraco.Core.Logging.LogHelper instead of umbraco.BusinessLogic.Log) | Type: Custom | User: 0 | NodeId: 0 | Comment: Import DatasourceAlias:Excel file ended

     

     

  • Richard Soeteman 4049 posts 12922 karma points MVP 2x
    Feb 07, 2013 @ 10:30
    Richard Soeteman
    0

    Wow,

    I think you just found a compatibility issue in the Legacy API of Umbraco., What is the datatype of the MetaData property?

    Thanks,

    Richard

  • Richard Soeteman 4049 posts 12922 karma points MVP 2x
    Feb 07, 2013 @ 10:32
    Richard Soeteman
    0

    Oh Stupid question was that Merijn, could it be a null value?

  • Merijn van Mourik 58 posts 128 karma points
    Feb 07, 2013 @ 14:03
    Merijn van Mourik
    0

    Many times stupid questions are very helpfull in getting to the cause of issues. And if it brings a smile on my face it is ok too.  Maybe the CMSImport is the real 'unittest' for the core!

    To answer your question. In my import excelsheet every field has value, so no null values visible yet.

  • Richard Soeteman 4049 posts 12922 karma points MVP 2x
    Feb 07, 2013 @ 14:10
    Richard Soeteman
    0

    The weird thing is that I try myself now on CMSImport 2.3.1 in combination with Umbraco V6 and can't reproduce it. Did you set some advanced options? Would love to know what is going on so either I can fix it or add a bug report..

  • Merijn van Mourik 58 posts 128 karma points
    Feb 07, 2013 @ 14:12
    Merijn van Mourik
    0

    I will drop you a mail with the copy of my sources and db. And of course the excelsheet we are looking at.

Please Sign in or register to post replies

Write your reply to:

Draft