Home
The Toolkit for Online Communities
17705 Community Members, 0 members online, 3746 visitors today
Log In Register
OpenACS Home : Forums : .LRN Q&A : bulk upload of users problem in dotLRN-2.0.3

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

Icon of envelope Request notifications

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.

Collapse
Posted by Deirdre Kane on
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

Collapse
Posted by Volin Karagiozov on
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

Collapse
Posted by Deirdre Kane on
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

Collapse
Posted by Tracy Adams on
It was a bug fixed in 2.1 alpha.
Collapse
Posted by Volin Karagiozov on
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

Collapse
Posted by Volin Karagiozov on
Thank you very much to all of you for the help!

Many greetings from AUBG - Bulgaria.

Volin