Forums

 
ForumForumMainstream Foru...Mainstream Foru...BugsBugsImport users failes with error PORTAL_ONLY cannot be NULLImport users failes with error PORTAL_ONLY cannot be NULL
Previous Previous
 
Next Next
New Post
 7/16/2008 10:55 AM
 
We are trying to import a table of users from a CSV file. When we run the import every row fails with an error saying that the field PORTAL_ONLY cannot be NULL. This field does not appear to be passed into the stored procedure spUSERS_Import so it looks like there is a bug in this stored procedure.
New Post
 7/16/2008 12:44 PM
 

The field is there, but it must not be assigned a value.

I really don't see a reason why the field is not allowed to be null.  Your best bet is to remove the requirement in the database using the following SQL code:

alter table USERS alter column PORTAL_ONLY bit null;

 

Previous Previous
 
Next Next
ForumForumMainstream Foru...Mainstream Foru...BugsBugsImport users failes with error PORTAL_ONLY cannot be NULLImport users failes with error PORTAL_ONLY cannot be NULL