Re: [Dhis2-users] Creation of bulk user.

2014-05-09 Thread Kenneth Børtveit
Alright. Are you using postgres? If not, this will not work.

1.
Select the by pressing the select button.

2.
In this case, the firstname and surname is in the csv file. Surname in the
first column, 0, and firstname in the second column, 1. Select the csv
radio button and the right column. Probably already selected.

3.
The username can be made by a combination of the firstname and lastname,
then select split+count. If some are equal, numbers will be added.

4.
The random password should just create a random password.
!This is not secure random, just a random string from java!

5.
One needs to enter the right database connection parameters in order to
load user roles and orgunits. Or one can use organization unit id or code
from the database. The id can be found in the database, codes are usually
made manually in DHIS2. We used the codes from the csv file to assign
orgunits, column 19.

6. Enter the correct database parameters.

7. Exclude incomplete users will not create users that are missing some of
the information.

8. Make csv of imported users, creates a csv file with the usernames and
passwords.

9. Make csv of incomplete records creates a csv file with the users that
are missing data.

10. The files can be found in the same directory as the selected file.

Let me know if there are any trouble.



2014-05-09 7:00 GMT+02:00 Hannan Khan :

> Thanks Randy
>
> We are trying with Kenneth's Java application; if we have the sample csv
> file it will be very help full for us.
>
> Dear Kenneth
>
> Can you please send me a sample CSV file.
>
> Regards
>
> Hannan
>
>
> On Thu, May 8, 2014 at 6:58 PM, Wilson,Randy  wrote:
>
>>  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@lists.launchpad.net] *On Behalf Of *Hannan Khan
>> *Sent:* Thursday, May 08, 2014 1:09 PM
>> *To:* Lars Helge Øverland
>> *Cc:* dhis2-users@lists.launchpad.net; 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 
>> 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  wrote:
>>
>> The easiest is to restart DHIS2 (Tomcat)
>>
>>
>>
>> On Wed, May 7, 2014 at 10:14 AM, Jason Pickering <
>> jason.p.picker...@gmail.com> 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, i

Re: [Dhis2-users] Creation of bulk user.

2014-05-08 Thread Hannan Khan
Thanks Randy

We are trying with Kenneth's Java application; if we have the sample csv
file it will be very help full for us.

Dear Kenneth

Can you please send me a sample CSV file.

Regards

Hannan


On Thu, May 8, 2014 at 6:58 PM, Wilson,Randy  wrote:

>  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@lists.launchpad.net] *On Behalf Of *Hannan Khan
> *Sent:* Thursday, May 08, 2014 1:09 PM
> *To:* Lars Helge Øverland
> *Cc:* dhis2-users@lists.launchpad.net; 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 
> 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  wrote:
>
> The easiest is to restart DHIS2 (Tomcat)
>
>
>
> On Wed, May 7, 2014 at 10:14 AM, Jason Pickering <
> jason.p.picker...@gmail.com> 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  wrote:
>
> No. It seems that uuid is not automatically generated. Please suggest.
>
> Regards
>
> Hannan
>
> On May 7, 2014 1:34 PM, "Jason Pickering" 
> 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  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.picker...@gmail.com> 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  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
&g

Re: [Dhis2-users] Creation of bulk user.

2014-05-08 Thread Wilson,Randy
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@lists.launchpad.net] On Behalf Of 
Hannan Khan
Sent: Thursday, May 08, 2014 1:09 PM
To: Lars Helge Øverland
Cc: dhis2-users@lists.launchpad.net; 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 
mailto:larshe...@gmail.com>> 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 
mailto:knu...@gmail.com>> wrote:
The easiest is to restart DHIS2 (Tomcat)

On Wed, May 7, 2014 at 10:14 AM, Jason Pickering 
mailto:jason.p.picker...@gmail.com>> 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 
mailto:hann...@gmail.com>> wrote:

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

Regards

Hannan
On May 7, 2014 1:34 PM, "Jason Pickering" 
mailto:jason.p.picker...@gmail.com>> 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 
mailto:hann...@gmail.com>> 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 
mailto:jason.p.picker...@gmail.com>> 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 
mailto:hann...@gmail.com>> 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
M+88 01819 239 241
M+88 01534 312 066
E hannan.k...@giz.de<mailto:hannan.k...@giz.de>
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@lists.launchpad.net<mailto:dhis2-users@lists.launchpad.net>
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp







--
Knut Staring
Dept. of Informatics, University of Oslo
+4791880522
http://dhis2.org


___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp


Re: [Dhis2-users] Creation of bulk user.

2014-05-08 Thread Hannan Khan
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 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  wrote:
>
>> The easiest is to restart DHIS2 (Tomcat)
>>
>>
>> On Wed, May 7, 2014 at 10:14 AM, Jason Pickering <
>> jason.p.picker...@gmail.com> 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  wrote:
>>>
 No. It seems that uuid is not automatically generated. Please suggest.

 Regards

 Hannan
 On May 7, 2014 1:34 PM, "Jason Pickering" 
 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  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.picker...@gmail.com> 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 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

 M+88 01819 239 241

 M+88 01534 312 066
 E hannan.k...@giz.de

 I   www.giz.de

 S hannan.khan.dhaka

 B hannan-tech.blogspot.com

 ___
 Mailing list: https://launchpad.net/~dhis2-users
 Post to : dhis2-users@lists.launchpad.net
 Unsubscribe : https://launchpad.net/~dhis2-users
 More help   : https://help.launchpad.net/ListHelp


>>>
>>
>
>>>
>>
>>
>> --
>> Knut Staring
>> Dept. of Informatics, University of Oslo
>> +4791880522
>> http://dhis2.org
>>
>
>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp


Re: [Dhis2-users] Creation of bulk user.

2014-05-07 Thread Lars Helge Øverland
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  wrote:

> The easiest is to restart DHIS2 (Tomcat)
>
>
> On Wed, May 7, 2014 at 10:14 AM, Jason Pickering <
> jason.p.picker...@gmail.com> 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  wrote:
>>
>>> No. It seems that uuid is not automatically generated. Please suggest.
>>>
>>> Regards
>>>
>>> Hannan
>>> On May 7, 2014 1:34 PM, "Jason Pickering" 
>>> 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  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.picker...@gmail.com> 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 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
>>>
>>> M+88 01819 239 241
>>>
>>> M+88 01534 312 066
>>> E hannan.k...@giz.de
>>>
>>> I   www.giz.de
>>>
>>> S hannan.khan.dhaka
>>>
>>> B hannan-tech.blogspot.com
>>>
>>> ___
>>> Mailing list: https://launchpad.net/~dhis2-users
>>> Post to : dhis2-users@lists.launchpad.net
>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>>
>>
>

>>
>
>
> --
> Knut Staring
> Dept. of Informatics, University of Oslo
> +4791880522
> http://dhis2.org
>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp


Re: [Dhis2-users] Creation of bulk user.

2014-05-07 Thread Hannan Khan
No. It seems that uuid is not automatically generated. Please suggest.

Regards

Hannan
On May 7, 2014 1:34 PM, "Jason Pickering" 
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  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.picker...@gmail.com> 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  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

 M+88 01819 239 241

 M+88 01534 312 066
 E hannan.k...@giz.de

 I   www.giz.de

 S hannan.khan.dhaka

 B hannan-tech.blogspot.com

 ___
 Mailing list: https://launchpad.net/~dhis2-users
 Post to : dhis2-users@lists.launchpad.net
 Unsubscribe : https://launchpad.net/~dhis2-users
 More help   : https://help.launchpad.net/ListHelp


>>>
>>
>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp


Re: [Dhis2-users] Creation of bulk user.

2014-05-07 Thread Knut Staring
The easiest is to restart DHIS2 (Tomcat)


On Wed, May 7, 2014 at 10:14 AM, Jason Pickering <
jason.p.picker...@gmail.com> 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  wrote:
>
>> No. It seems that uuid is not automatically generated. Please suggest.
>>
>> Regards
>>
>> Hannan
>> On May 7, 2014 1:34 PM, "Jason Pickering" 
>> 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  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.picker...@gmail.com> 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 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
>>
>> M+88 01819 239 241
>>
>> M+88 01534 312 066
>> E hannan.k...@giz.de
>>
>> I   www.giz.de
>>
>> S hannan.khan.dhaka
>>
>> B hannan-tech.blogspot.com
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to : dhis2-users@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>

>>>
>


-- 
Knut Staring
Dept. of Informatics, University of Oslo
+4791880522
http://dhis2.org
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp


Re: [Dhis2-users] Creation of bulk user.

2014-05-07 Thread Jason Pickering
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  wrote:

> No. It seems that uuid is not automatically generated. Please suggest.
>
> Regards
>
> Hannan
> On May 7, 2014 1:34 PM, "Jason Pickering" 
> 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  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.picker...@gmail.com> 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  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
>
> M+88 01819 239 241
>
> M+88 01534 312 066
> E hannan.k...@giz.de
>
> I   www.giz.de
>
> S hannan.khan.dhaka
>
> B hannan-tech.blogspot.com
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>

>>>
>>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp


Re: [Dhis2-users] Creation of bulk user.

2014-05-07 Thread Jason Pickering
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  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.picker...@gmail.com> 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  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
>>>
>>> M+88 01819 239 241
>>>
>>> M+88 01534 312 066
>>> E hannan.k...@giz.de
>>>
>>> I   www.giz.de
>>>
>>> S hannan.khan.dhaka
>>>
>>> B hannan-tech.blogspot.com
>>>
>>> ___
>>> Mailing list: https://launchpad.net/~dhis2-users
>>> Post to : dhis2-users@lists.launchpad.net
>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>>
>>
>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp


Re: [Dhis2-users] Creation of bulk user.

2014-05-07 Thread Hannan Khan
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.picker...@gmail.com> 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  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
>>
>> M+88 01819 239 241
>>
>> M+88 01534 312 066
>> E hannan.k...@giz.de
>>
>> I   www.giz.de
>>
>> S hannan.khan.dhaka
>>
>> B hannan-tech.blogspot.com
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to : dhis2-users@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp


Re: [Dhis2-users] Creation of bulk user.

2014-05-06 Thread Brajesh Murari
Dear Mr. Khan

length of the password should not be an issue in creating bulk users in 

DHIS2,if and only if it does't violet any validation checks, like

1. Password should start with Capital letter.
2. Password should contains at least one neumaric character.
3. Password length should not be less than 8 alpha neumaric characters.
4. Password length should not be greater than . ! etc.

There might be n number of ways one can create user in DHIS2. 
But if you are using authentic user creation process, than that 

should not make any issue in bull users creation.


We are not that much sure, which approach you are following in 

creating more than one users in DHIS2 in your personal script. 

 
Regards
Brajesh Murari 


P please consider the environment before printing this email
On Wednesday, 7 May 2014 11:40 AM, Hannan Khan  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
M+88
01819 239 241
M+88
01534 312 066
E hannan.k...@giz.de
I   www.giz.de
S hannan.khan.dhaka
B hannan-tech.blogspot.com
___
Mailing list: https://launchpad.net/~dhis2-users
Post to     : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp


Re: [Dhis2-users] Creation of bulk user.

2014-05-06 Thread Jason Pickering
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  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
>
> M+88 01819 239 241
>
> M+88 01534 312 066
> E hannan.k...@giz.de
>
> I   www.giz.de
>
> S hannan.khan.dhaka
>
> B hannan-tech.blogspot.com
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp


[Dhis2-users] Creation of bulk user.

2014-05-06 Thread Hannan Khan
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

M+88 01819 239 241

M+88 01534 312 066
E hannan.k...@giz.de

I   www.giz.de

S hannan.khan.dhaka

B hannan-tech.blogspot.com
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp