dhis2-users team mailing list archive

["Wilson,Randy" <rwilson@xxxxxxx>]

Hi Hannan,

I think you should try Kenneth’s java application.  We created 40,000 users (community health workers with their phone numbers and orgunit link) and assigned them all passwords using the app.  I think Kenneth has put in a User interface that lets you specify the server address, DHIS-2 instance or database, etc…

Kenneth could you send Hannan a sample csv file (just 10 records or so) along with your application, so he can test it out.  I think it is sufficiently generic.

He sent a link to it in an earlier response.  This file is quite big – 54 meg - Kenneth, can it be shrunk a bit more?

If you have java on your Windows computer you should be able to run it as follows:

Java –jar user_importer.jar

Randy

From: Dhis2-users [mailto:dhis2-users-bounces+rwilson=msh.org@xxxxxxxxxxxxxxxxxxx] On Behalf Of Hannan Khan
Sent: Thursday, May 08, 2014 1:09 PM
To: Lars Helge Øverland
Cc: dhis2-users@xxxxxxxxxxxxxxxxxxx; DHIS 2 developers
Subject: Re: [Dhis2-users] Creation of bulk user.

Hi Lars

Thanks. Yes restarting tomcat can generate the blank UID.

UID is a indexed field so I cannot create more than one user in one go. Is there any solution?

Regards

Hannan

On Wed, May 7, 2014 at 2:38 PM, Lars Helge Øverland <larshelge@xxxxxxxxx<mailto:larshelge@xxxxxxxxx>> wrote:
Hi,

it is correct that missing UIDs will be generated on system startup.

I think what is being referred to here is dhis UID and not an UUID. There are ways to generate dhis UIDs through the web api but it's just much simpler to restart tomcat.

regards,

Lars


On Wed, May 7, 2014 at 10:19 AM, Knut Staring <knutst@xxxxxxxxx<mailto:knutst@xxxxxxxxx>> wrote:
The easiest is to restart DHIS2 (Tomcat)

On Wed, May 7, 2014 at 10:14 AM, Jason Pickering <jason.p.pickering@xxxxxxxxx<mailto:jason.p.pickering@xxxxxxxxx>> wrote:
If it is blank then the database will regenerate it automatically when you restart (I think. This is what happens with other objects which have a uuid). That is the easiest way.

If you are preparing SQL for injection of the users and you want to pregenerate them, you can use which ever tool you are using to generate the SQL to provide you UUIDs as well. Postgresql's uuid-ossp package, R's "uuid" package, or the system command "uuid" on Linux are all ways of getting them. I am sure they can be done easily in Java or other languages. So, it really depends on which tools you are using to prepare the SQL for inserting them into the DHIS2 database.

Regards,
Jason


On Wed, May 7, 2014 at 10:07 AM, Hannan Khan <hannank@xxxxxxxxx<mailto:hannank@xxxxxxxxx>> wrote:

No. It seems that uuid is not automatically generated. Please suggest.

Regards

Hannan
On May 7, 2014 1:34 PM, "Jason Pickering" <jason.p.pickering@xxxxxxxxx<mailto:jason.p.pickering@xxxxxxxxx>> wrote:
The UUID will be generated automatically, so no need to worry about it.

Regards,
Jason


On Wed, May 7, 2014 at 9:29 AM, Hannan Khan <hannank@xxxxxxxxx<mailto:hannank@xxxxxxxxx>> wrote:
Thanks Jason. Password issues are there and we are trying with that but what about the UUID?

Regards

Hannan

On Wed, May 7, 2014 at 12:14 PM, Jason Pickering <jason.p.pickering@xxxxxxxxx<mailto:jason.p.pickering@xxxxxxxxx>> wrote:
Hi Hannan,
This has been discussed (again) recently on this list.

http://dhis-developers-list.1563109.n2.nabble.com/Password-Generation-td7590749.html#a7590750

http://dhis-developers-list.1563109.n2.nabble.com/USERS-Password-td7591703.html#a7591704

There are a few more as well in the archives if you dig a bit.

Regards,
Jason


On Wed, May 7, 2014 at 8:10 AM, Hannan Khan <hannank@xxxxxxxxx<mailto:hannank@xxxxxxxxx>> wrote:
Dear Experts

We are in a need of creating bulk users (8000) and org unit assignment. I created script for testing but facing problem populating password and UUID. Please advice how can I do that?

I try to update password using crypt function and gen_salt function but the length of the password are different and doesn't working. Please advise.

Regards

Hannan Khan
--------------------------------------------------
Senior Technical Advisor - Health Information Systems
Health Sector
Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH
House10/A, Road 90, Gulshan 2, Dhaka 1212, Bangladesh

T +880-2- 8816459, 8816412 ext 118
F +88 02 8813 875<tel:%2B88%2002%208813%20875>
M+88 01819<tel:01819> 239 241
M+88 01534<tel:01534> 312 066
E hannan.khan@xxxxxx<mailto:hannan.khan@xxxxxx>
I   www.giz.de<http://www.giz.de>
S hannan.khan.dhaka
B hannan-tech.blogspot.com<http://hannan-tech.blogspot.com>

_______________________________________________
Mailing list: https://launchpad.net/~dhis2-users
Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx<mailto:dhis2-users@xxxxxxxxxxxxxxxxxxx>
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp







--
Knut Staring
Dept. of Informatics, University of Oslo
+4791880522<tel:%2B4791880522>
http://dhis2.org