dhis2-devs team mailing list archive

[Knut Staring <knutst@xxxxxxxxx>]

For Mysql,  i think you could do this in postgres first,  then do a
metadata export to mysql and finally use sql to bring over the generated
passwords.
On 9 May 2014 10:52, "Kenneth Børtveit" <kenneth.bortveit@xxxxxxxxx> wrote:

> 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 <hannank@xxxxxxxxx>:
>
>> 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 <rwilson@xxxxxxx> 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.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>
>>> 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> wrote:
>>>
>>> The easiest is to restart DHIS2 (Tomcat)
>>>
>>>
>>>
>>> On Wed, May 7, 2014 at 10:14 AM, Jason Pickering <
>>> 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> 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>
>>> 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> 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> 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> 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.khan@xxxxxx
>>>
>>> I   www.giz.de
>>>
>>> S hannan.khan.dhaka
>>>
>>> B hannan-tech.blogspot.com
>>>
>>>
>>>
>>> _______________________________________________
>>> Mailing list: https://launchpad.net/~dhis2-users
>>> Post to     : 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
>>>
>>> http://dhis2.org
>>>
>>>
>>>
>>>
>>>
>>
>>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>