[SPT/CWIS] importing users

[Christopher Beck]

Thanks for the suggestion.  I found a work-around by specifying in the 
SPT-UserImportComplete.php file the specific privileges that I wanted 
every user to have.

Chris

Quoting Christian Gutierrez <chesstrian at gmail.com>:

> Sorry, i think that my suggestion does not works because the fields in the
> table APUserPrivileges is not null, so maybe you can install phpmyadmin to
> manage yours DB, you can export your DB again and try import to new
> database.
>
> On Thu, May 22, 2008 at 1:32 PM, Christian Gutierrez <chesstrian at gmail.com>
> wrote:
>
>> Hi, you should write ... VALUES ('5', '') ...
>>
>> Tell me that it works.
>>
>>
>> On Wed, May 21, 2008 at 8:50 PM, Christopher Beck <cbeck at emory.edu> wrote:
>>
>>> When I go to import users, I get the following error message:
>>>
>>> SQL Statement: INSERT INTO APUserPrivileges (UserId, Privilege) VALUES
>>> ('5', )
>>> SQL Error: You have an error in your SQL syntax; check the manual that
>>> corresponds to your MySQL server version for the right syntax to use
>>> near ')' at line 1
>>>
>>> CWIS seems to import the rest of the information, but doesn't import
>>> the privileges.
>>>
>>> A related question.  Can I specify a custom privilege flag that I have
>>> created when I import users or for new users when they register?
>>>
>>> Thanks,
>>> Chris
>>>
>>> Dr. Christopher Beck
>>> Department of Biology
>>> Emory University
>>> 1510 Clifton Rd.
>>> Atlanta, GA 30322
>>>
>>> Email:  christopher.beck at emory.edu
>>> Phone:  404-712-9012
>>> FAX:  404-727-2880
>>>
>>> _______________________________________________
>>> SPT-CWIS-Users mailing list
>>> SPT-CWIS-Users at scout.wisc.edu
>>> http://www.scout.wisc.edu/mailman/listinfo/spt-cwis-users
>>>
>>
>>
>>
>> --
>> Chesstrian!!!
>
>
>
>
> --
> Chesstrian!!!
>



Dr. Christopher Beck
Department of Biology
Emory University
1510 Clifton Rd.
Atlanta, GA 30322

Email:  christopher.beck at emory.edu
Phone:  404-712-9012
FAX:  404-727-2880