Copied to clipboard

Flag this post as spam?

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


  • Nathan Sleigh 109 posts 353 karma points
    Oct 18, 2017 @ 16:39
    Nathan Sleigh
    0

    Error When Importing Members

    Hi Guys,

    We are seeing an error when importing members. We have a member type with maybe 20+ properties on it but whilst testing we are only importing members with and Email and Name and each time is seems to fail with the following error:

    enter image description here

    We are getting the following in the logs:

    2017-10-18 16:33:27,166 [P7376/D2/T70] ERROR CMSImportLibrary.Providers.ImportProviders.Member.MemberImportProvider - CMSImport:CMSImport: A record failed to import for alias@@#Import_email System.InvalidOperationException: Invalid attempt to call Read when reader is closed. at System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more) at System.Data.SqlClient.SqlDataReader.Read() at umbraco.DataLayer.RecordsReaderAdapter`1.Read() at umbraco.cms.businesslogic.member.Member.PopulateGroups() at umbraco.cms.businesslogic.member.Member.AddGroup(Int32 GroupId) at umbraco.MemberExtensions.AddGroup(Member member, MemberGroup group) at CMSImportLibrary.Providers.ImportProviders.Member.MemberImportProvider.ImportMembers(ImportState state, ImportStatistics importStatistics, User importAsUser) 2017-10-18 16:33:27,182 [P7376/D2/T70] INFO CMSImport.Extensions.Providers.ImportProviders.ImportProvider - CMSImport:Import finished, Records in datasource: 2, Records Added 0, Records Updated 0, Records skipped 0, Records deleted 0, Errors 2, duration 00:00:06

    We have a Pro License so it can't be down to the amount we have imported. This also happens across all of our environments, Local, Dev, Test and Staging with different dbs.

    Has anyone seen this before?

    Nathan

  • Richard Soeteman 3829 posts 11860 karma points MVP
    Oct 19, 2017 @ 05:54
    Richard Soeteman
    100

    Hi Nathan,

    The tool should have prompted that you should use the MembershipImport provider for this version of Umbraco (In V4 this will be the default provider). If not please let me know. You can download the mebershipimport provider from the downloads page https://soetemansoftware.nl/cmsimport/downloads

    Hope this helps,

    Richard

  • Nathan Sleigh 109 posts 353 karma points
    Oct 19, 2017 @ 08:16
    Nathan Sleigh
    0

    Hi Richard,

    I got no prompt but after installing the provider it seems to be working fine.

    Thanks for this.

    Nathan

Please Sign in or register to post replies

Write your reply to:

Draft