Forum .LRN Q&A: bulk upload of users problem in dotLRN-2.0.3
Can you help me. It is very urgent.
I am trying to bulk upload new users in .LRN (.LRN-2.0.3) from
.LRN Site Wide Administration/Users/Bulk upload
with the following CVS file:
And I receive the following:
Bulk uploading in progress.
The database choked while trying to create the last user in the list above!
The transaction has been aborted, no users have been entered, and no e-mail notifications have been sent.
We are on 2.1 now and bulk upload is working fine. I tested your names with our bulk upload (using bogus email addresses) and did not get an error, so I have two suggestions:
1) your CSV file could have some hidden characters, so open it in Notepad and remove anything extraneous at the end of the file
2) since it's only two users, you could also create the accounts individually while you figure out what's broken with your bulk upload.
CSV file seems to be OK.
Actualy I tested just with two users before adding all faculty and students and found this problem.
I looked at Postgres server.log file also:
ERROR: ExecInsert: Fail to add null value in not null attribute username
WARNING: Error occurred while executing PL/pgSQL function acs_user__new
WARNING: line 54 at SQL statement
We are using Oracle, so perhaps it is an Oracle/Postgres difference, but someone more technical than me will have to look into it; i'm in over my head once we get past the web interface.
Is it possible to fix this bug in 2.0.3 without upgrading to 2.1?
Where can I find the soltion of this problem?