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.bortv...@gmail.com> 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 <hann...@gmail.com>: > >> 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 <rwil...@msh.org> 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-us...@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 <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 <knu...@gmail.com> 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 <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" <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 <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 < >>> 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 <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 >>> >>> I www.giz.de >>> >>> S hannan.khan.dhaka >>> >>> B hannan-tech.blogspot.com >>> >>> >>> >>> _______________________________________________ >>> Mailing list: https://launchpad.net/~dhis2-users >>> Post to : dhis2-us...@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-devs > Post to : dhis2-devs@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp > >
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
