Forum .LRN Q&A: bulk upload of users problem in dotLRN-2.0.3

1: bulk upload of users problem in dotLRN-2.0.3

Posted by Volin Karagiozov on 08/19/04 12:00 PM

Hi,

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:

first_names,last_name,email,id,type,access_level,guest
Daehwan,Kim,dkim@aubg.bg,,professor,full,f
Valentin,Iliev,viliev@aubg.bg,,professor,full,f

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.

2: Re: bulk upload of users problem in dotLRN-2.0.3 (response to 1)

Posted by Deirdre Kane on 08/19/04 12:55 PM

Volin,

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.

DeeDee

3: Re: bulk upload of users problem in dotLRN-2.0.3 (response to 2)

Posted by Volin Karagiozov on 08/19/04 02:11 PM

Thank you DeeDee,

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

Volin

4: Re: bulk upload of users problem in dotLRN-2.0.3 (response to 1)

Posted by Deirdre Kane on 08/19/04 02:24 PM

Volin,

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.

DeeDee

5: Re: bulk upload of users problem in dotLRN-2.0.3 (response to 1)

Posted by Tracy Adams on 08/19/04 03:08 PM

It was a bug fixed in 2.1 alpha.

6: Re: bulk upload of users problem in dotLRN-2.0.3 (response to 5)

Posted by Volin Karagiozov on 08/19/04 05:15 PM

Thanks Tracy,

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?

Volin

7: Re: bulk upload of users problem in dotLRN-2.0.3 (response to 6)

Posted by Rocael Hernández Rizzardini on 08/19/04 05:38 PM

yes, just replace the related file with the new one at the branch oacs-5-1.
http://cvs.openacs.org/cvs/openacs-4/packages/dotlrn/www/admin/users-bulk-upload-2.tcl?rev=1.11.2.1.4.1&only_with_tag=oacs-5-1&view=auto

8: Re: bulk upload of users problem in dotLRN-2.0.3 (response to 7)

Posted by Volin Karagiozov on 08/19/04 05:53 PM

Thank you very much to all of you for the help!

Many greetings from AUBG - Bulgaria.

Volin