Copied to clipboard

Flag this post as spam?

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

  • David Pipkin 3 posts 83 karma points
    Jan 18, 2017 @ 16:13
    David Pipkin

    "CustomID" Error when importing records

    I'm using CMSImport 3.6 on Umbraco 7.1.4 to import a simple CSV file into a Sql Server 2012 database and I'm getting the following error on all rows it tries to import:

    Error :Invalid column name 'CustomId'

  • Richard Soeteman 3722 posts 11521 karma points MVP
    Jan 19, 2017 @ 07:13
    Richard Soeteman

    Hi David,

    That error should not happen on SQL Server. Was an old bug in the update script.

    If you add the column CustomId nvarchar 250 (Allow null) to the table cmsimportrelation all should be good.

    Sorry for the hassle.



  • Marcin Zajkowski 97 posts 558 karma points MVP 2x c-trib
    Oct 06, 2017 @ 22:16
    Marcin Zajkowski

    Hi Richard,

    you need to update scripts in the manual installation guide in documentation. I found the same problem today and it was because I've added columns using the script in the docs which don't have this column.

    Hope it will help for anyone else installing CMS Import manually :)

  • David Pipkin 3 posts 83 karma points
    Jan 19, 2017 @ 14:00
    David Pipkin


    Thanks, that worked.

    I was close... I added the column to the CMSImportState table...

Please Sign in or register to post replies

Write your reply to: