Updating Custom Fields in User info with the Import Users Tab

  • 4 November 2022
  • 3 replies

Userlevel 1

Hi I’m having a problem updating a few Custom Fields I created for my users. I’m using the Import template spreadsheet provided by iiQ. I am matching the iiQ users up with their ID number and omitting the first name and last name, email, usernames fields. But I’m getting this error “listed below”. I didn’t think that I need to include the users: emails, names, and usernames when updating to a Custom Field and matching just the ID numbers?

Any help you can provide would be appreciated


Ps: Is there a way to copy error information to the clipboard because I see that I might have not gotten all of it. hence the … at the end of the error code


:: Error executing Sql because 'Cannot insert the value NULL into column 'FirstName', table 'iiq-prod-sqldb.dbo.Users'; column does not allow nulls. INSERT fails.'; at jLib.Db.SqlHelper.ExecuteX(DbConnection SqlConnection, CommandType CommandType, String Command, OrderedDictionary`2 Parameters) at jLib.Db.SqlHelper.ExecuteX(CommandType CommandType, String Command, OrderedDictionary`2 Parameters) at jLib.Db.DataFramework.BaseTableRecord`1.Save[T](SqlHelper SqlHelper, T AuthorId, SaveOptions Options) at Spark.Data.BaseTableRecordImpl`1.Save[T](SqlHelper SqlHelper, T AuthorId, SaveOptions Options) in F:\Jenkins\Workspaces\ - Webdeploy\Spark.Data.Framework\BaseTableRecordImpl.cs:line 135 at Spark.Data.User.Save[T](SqlHelper SqlHelper, T AuthorId, SaveOptions Options) in F:\Jenkins\Workspaces\ - Webdeploy\Spark.Data\Tables\Users.cs:line 46 at jLib.Db.DataFramework.BaseTableCollection`4.Save[T](SqlHelper SqlHelper, T AuthorId, SaveOptions Options, Cancella...


Best answer by Kathryn Carter 17 November 2022, 20:01

View original

3 replies

Userlevel 7
Badge +10

@DKelly 430e93d tonacsd Would you be able to provide the CSV you are trying to upload or a screenshot? The error message says you have some blank columns. It would help us figure out what the problem is. 

Userlevel 1

Thank you for getting back to me, but I was able to find the problem in my CSV file/user profile setup. The Id’s that someone previously synced by hand and didn’t represent the current Id’s in our external system. I have since started to use email addresses as this tends to be more current. 

Userlevel 7
Badge +10

@DKelly 430e93d tonacsd Glad its all figured out now! 😄