Dear All, Thanks you very for your help and help me a lot to create a a java class that can read excel file and create a bulk user at a time. i will add that class soon here.
Thanks Best Regards On Fri, May 9, 2014 at 3:51 PM, Morten Olav Hansen <morte...@gmail.com>wrote: > Just wanted to mention that we are now planing to add this functionality > to 2.16, it will work as /api/users today (allows creating one user with > password etc), but will support bulk import of users + passwords through > our meta-data import (/api/metadata), there will be no export of passwords, > but we will allow creating of users with password, and also updating, you > can send passwords as plaintext, and it will be hashed on the server > (please use https for this) > > -- > Morten > > > On Fri, May 9, 2014 at 11:44 AM, Knut Staring <knu...@gmail.com> wrote: > >> 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-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 < >>>>> 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-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-devs >>> Post to : dhis2-d...@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-d...@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-d...@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp > > -- *Fatema Uddin* ---------------------------------------- *Technical Advisor HIS* Priority Area Health Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH House10/A, Road 90, Gulshan 2, Dhaka 1212, Bangladesh *Office location:* Room # 304, Shshid Dr.Milan Bhavan, Management Information System, Directorate General of Health Services of MoHFW, Mohakhali, Dhaka-1212, Bangladesh Phone: +880 2 881 64 59 Fax: +880 2 881 38 75
_______________________________________________ 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
