Sign in Register
Go to solution
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
    0

    "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'

    Copy Link
  • Richard Soeteman 4046 posts 12899 karma points MVP 2x
    Jan 19, 2017 @ 07:13
    Richard Soeteman
    100

    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.

    Best,

    Richard

    Copy Link
  • Marcin Zajkowski 112 posts 585 karma points MVP 7x c-trib
    Oct 06, 2017 @ 22:16
    Marcin Zajkowski
    0

    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 :)

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

    Richard,

    Thanks, that worked.

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

    Copy Link
Please Sign in or register to post replies

Write your reply to:

Draft