Thursday, November 20, 2008 ..:: Forums ::.. Register  Login
 Forums Minimize
SearchForum Home
     
  Mainstream Forums  Bugs  Import users fa...
 Import users failes with error PORTAL_ONLY cannot be NULL
 
jmannix
3 posts
Joined
7/8/2008

Import users failes with error PORTAL_ONLY cannot be NULL
Posted: 16 Jul 08 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.
support
2094 posts
1st
Joined
1/3/2006

Re: Import users failes with error PORTAL_ONLY cannot be NULL
Posted: 16 Jul 08 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;

 

  Mainstream Forums  Bugs  Import users fa...

Forum Home  Search       

Copyright (c) 2006-2008 SplendidCRM Software, Inc. All Rights Reserved.   Terms Of Use  Privacy Statement
DotNetNuke® is copyright 2002-2008 by Perpetual Motion Interactive Systems Inc.
SplendidCRM and SplendidCRM Software are trademarks of SplendidCRM Software, Inc. SugarCRM is a trademark of SugarCRM Inc. in the United States, the European Union and other countries. All other trademarks used in this web site are the property of their respective owners.