Sign in Register
Copied to clipboard

Flag this post as spam?

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


  • Owain Williams 480 posts 1412 karma points MVP 6x c-trib
    Mar 27, 2015 @ 10:59
    Owain Williams
    0

    Error while importing data for property '', datasource record

    Using CMSImport

    Hi

    Im running Umbraco 7.2.4 and CMSImport 3.1.1 Free edition. 

    I'm trying to import from SQL server database to Articulate Blog 1.0.7

    The SQL statement I use is:

    SELECT cpv.id, cpv.ContentItemRecord_id, tpr.Title, bpr.Text, 'Owain' as Author, LEFT ( bpr.Text, 100) As Excert, cpv.CreatedUtc, cpv.PublishedUtc, cpv.ModifiedUtc
    FROM orcharduser.Common_CommonPartVersionRecord AS cpv, orcharduser.Title_TitlePartRecord AS tpr, orcharduser.Common_BodyPartRecord AS bpr
    WHERE cpv.ContentItemRecord_ID = tpr.ContentItemRecord_id 
    AND cpv.ContentItemRecord_ID = bpr.ContentItemRecord_ID 
    AND cpv.id = tpr.id 
    AND cpv.id = bpr.id 
    AND PublishedUtc = (SELECT MAX(PublishedUtc) 
    FROM orcharduser.Common_CommonPartVersionRecord bpr
    WHERE cpv.ContentItemRecord_id = bpr.ContentItemRecord_id) 
    ORDER BY cpv.PublishedUtc ASC;

     

    I then map everything up to a rich text post start the import, the problem is, I get the following error messages.

     

    Import Finished

    00:00:05
    156
    0
    156
    The following errors occured

    Error while importing data for property '', datasource record Title = 'First entry - what have I done!', Error :The best overloaded method match for 'Umbraco.Core.Models.ContentBase.SetPropertyValue(string, string)' has some invalid arguments 
    Error while importing data for property '', datasource record Title = 'About me', Error :The best overloaded method match for 'Umbraco.Core.Models.ContentBase.SetPropertyValue(string, string)' has some invalid arguments 
    Error while importing data for property '', datasource record Title = 'Welcome', Error :The best overloaded method match for 'Umbraco.Core.Models.ContentBase.SetPropertyValue(string, string)' has some invalid arguments 
    Error while importing data for property '', datasource record Title = 'Kit', Error :The best overloaded method match for 'Umbraco.Core.Models.ContentBase.SetPropertyValue(string, string)' has some invalid arguments 
    Error while importing data for property '', datasource record Title = 'Welcome', Error :The best overloaded method match for 'Umbraco.Core.Models.ContentBase.SetPropertyValue(string, string)' has some invalid arguments 
    Error while importing data for property '', datasource record Title = 'Amanda O'Neill', Error :The best overloaded method match for 'Umbraco.Core.Models.ContentBase.SetPropertyValue(string, string)' has some invalid arguments 
    Error while importing data for property '', datasource record Title = 'Your Bio Here?', Error :The best overloaded method match for 'Umbraco.Core.Models.ContentBase.SetPropertyValue(string, string)' has some invalid arguments 
    Error while importing data for property '', datasource record Title = 'Welcome to Owain's Blog', Error :The best overloaded method match for 'Umbraco.Core.Models.ContentBase.SetPropertyValue(string, string)' has some invalid arguments 
    Error while importing data for property '', datasource record Title = 'Contact', Error :The best overloaded method match for 'Umbraco.Core.Models.ContentBase.SetPropertyValue(string, string)' has some invalid arguments 
    Error while importing data for property '', datasource record Title = 'First race on a track', Error :The best overloaded method match for 'Umbraco.Core.Models.ContentBase.SetPropertyValue(string, string)' has some invalid arguments 
    Error while importing data for property '', datasource record Title = 'On starters orders.....', Error :The best overloaded method match for 'Umbraco.Core.Models.ContentBase.SetPropertyValue(string, string)' has some invalid arguments 
    Error while importing data for property '', datasource record Title = 'Its dark out there!', Error :The best overloaded method match for 'Umbraco.Core.Models.ContentBase.SetPropertyValue(string, string)' has some invalid arguments 
    Error while importing data for property '', datasource record Title = 'A race of two halves', Error :The best overloaded method match for 'Umbraco.Core.Models.ContentBase.SetPropertyValue(string, string)' has some invalid arguments 
    Error while importing data for property '', datasource record Title = 'The road to improvement', Error :The best overloaded method match for 'Umbraco.Core.Models.ContentBase.SetPropertyValue(string, string)' has some invalid arguments 

    The same error for every post. I've checked the logs but I just make any sense from it. 

    Can anyone help me please. 

    Thanks,

    Owain.

     

    Copy Link
  • Richard Soeteman 4035 posts 12842 karma points MVP
    Mar 27, 2015 @ 11:15
    Richard Soeteman
    0

    HI Owain,

    I think it's because of a property you've mapped to. Could it be that Articulate has some special property editors?

    Best to try on "normal" documents first to see if it works.

    Best,

    Richard

    Copy Link
  • Owain Williams 480 posts 1412 karma points MVP 6x c-trib
    Mar 27, 2015 @ 16:55
    Owain Williams
    0

    It seems to be a problem with the Title, I'll maybe post on the articulate section and see if anyone can spot the issue. 

    Thanks,

    Copy Link
  • Chris Houston 535 posts 980 karma points MVP admin c-trib
    Apr 01, 2015 @ 14:33
    Chris Houston
    0

    For anyone else who reads this post:

    This is the same issue as: https://our.umbraco.org/projects/starter-kits/articulate/discussions/63700-BlogMlImporter-Error

    Copy Link
Please Sign in or register to post replies

Write your reply to:

Draft