Re: [Dhis2-users] Interoperability of ODK & DHIS2

[Matt Berg]

We've done a prototype of this which works for syncing of forms.  We didn't
tackle org ids fully which is a bit more complex.  We'd be interested in
developing a Django web bridge that would allow you to collect ona or one
of the formhub derivatives to dhis2 if there is interest.

Keen to see thiugh what 2paths comes up with.

Thanks,

Matt

On Monday, August 31, 2015, Aaron Gladders  wrote:

> Hi - we spoke with Patrick briefly but I thought I'd email the rest of the
> list too.  We've been engaged for some feasibility work linking together
> various mobile collection tools to DHIS 2 in as general a way as possible
> and not requiring IT or developers to do custom integration each time.  We
> hope to be done the first by the end of the Sept and there are tentative
> plans to continue after that.  Will try to report back if something
> fruitful comes of it, but generally it would follow the path Jason and Abda
> Anne have outlined with some sort of ETL/mapping process in the middle.
>
> Aaron
>
> On Mon, Aug 31, 2015 at 8:07 AM, Abda ANNE  > wrote:
>
>> Dear all,
>> We are currently working on similar project. We need to store in DHIS2
>> daata collected via ODK Collect.
>>
>> We are working on the following scenario :
>> ODK Collect =>ODK Aggregate => ODK2DHIS (Custom Code) => DHIS2
>>
>> We told ODK Aggregate to forward all inncoming data in JSON Format to our
>> ODK2DHIS  custom code. ODK2DHIS will match ODK fields to DHIS2 dataelement
>> and use DHIS API to submit data. Our ODK2DHIS is not ready yet, we shall
>> start implementing it very shortly. If anyone is willing to sharing his
>> custom program to transfert data from ODK to DHIS2, we will be very happy.
>>
>> ---
>> Abda Anne
>> Bamako, MALI
>>
>>
>>
>> -
>> Abda Anne
>> Bamako (Mali)
>>
>> 2015-08-31 11:13 GMT+00:00 Jason Pickering > >:
>>
>>> Hi Patrick,
>>> There is nothing really out of the box which will do this AFAIK.
>>>
>>> In the past, I have worked in projects which have aggregated the event
>>> based data, and the passed it on to DHIS2 in aggregate format with custom
>>> code,similar to what Pierre mentions.
>>>
>>> In another situation, we passed the event based data from ODK into
>>> DHIS2, again, using custom code.
>>>
>>> In both cases, there was custom code to "clean" data from ODK which
>>> might not be suitable for import into DHIS2, such as incomplete or
>>> inconsistent or duplicate form submissions.
>>>
>>> I know there have been some efforts in the past to integrate the two
>>> applications more closely, but as of now, there is nothing. But, with a bit
>>> of scripting (or even Excel!) it would not be too difficult to do this. I
>>> would however be clear from the outset if you need everything in DHIS2, as
>>> often it makes sense to aggregate and process the survey data obtained from
>>> ODK, into something which really makes more sense in DHIS2 (i.e. events or
>>> aggregate data). Working with the raw survey data should be possible now
>>> with the event modules, and with the advent of the program rules in the
>>> latest version, more complex skip logic (not as complex as ODK) is
>>> supported. So, it might be work looking at only using DHIS2 even capture
>>> for what you need, as opposed to building a custom integration layer
>>> between the two. For relatively simple surveys, it might work, but if you
>>> need very complex skip logic or ODK specific features, it might not.
>>>
>>> Regards,
>>> Jason
>>>
>>>
>>> On Mon, Aug 31, 2015 at 12:44 PM, Pierre Dane >> > wrote:
>>>
 Hi Patrick,

 I'm not aware of any existing ODK to DHIS2 interoperability modules and
 I would expect that some additional coding on the ODK side would be
 necessary to get data into a format that DHIS2 can accept. DHIS2 has a
 number of ways of accepting data via the api, so if a module can be built
 to read from ODK and transform data into json/xml/csv format (or preferably
 ADX) this can easily be ingested into DHIS2

 Pierre

 On Tue, Aug 25, 2015 at 7:59 PM, Patrick Malone > wrote:

> Hey all,
>
> I'm currently working for an organization that is particularly curious
> about the interoperability of ODK and DHIS 2. Does anybody have any
> experience with syncing both systems? Does moving information stored
> through ODK into DHIS 2require additional coding? If so, is that more of a
> matter of DHIS 2 accepting the information that ODK is exporting rather
> than the other way around? Any help/information would be appreciated
>
> Thanks,
>
> Pat
>
> --
> Patrick Malone
> MA, Law and Diplomacy | 

Re: [Dhis2-users] [Dhis2-devs] Changing admin password to default

[Jason Pickering]

@Alan, nice. ; )

The only other things to be sure about are

1) The admin user actually exists.
2) The admin user is not disabled.
3) The admin user is actually a super user.

If you have had a situation where someone else was in control over the
server, they may have (smartly) disabled or completely removed the "admin"
user. Otherwise, you may need to develop a more comprehensive script to
inject a user into the database if the "admin" user does not exist at all.

Regards,
Jason




On Mon, Aug 31, 2015 at 11:21 PM, Alan Ivey  wrote:

> Hi Gerald,
>
> You can create a password hash with Python and the Bcrypt library. Run
> this single command in your terminal to get a hash for *passwordGoesHere*:
>
> $ python -c 'import bcrypt; hash = bcrypt.hashpw("*passwordGoesHere*",
> bcrypt.gensalt(rounds=10, prefix=b"2a")); print(hash);'
>
> You can insert the resulting hash directly into the database for the admin
> user.
>
> Note: If you do not have the Bcrypt library in your Python installation,
> you should add it with pip. The following will install all prerequisites on
> a CentOS 6 system:
>
> $ yum install gcc libffi-devel python-devel python-pip
> $ pip install --user bcrypt
>
> Before attempting to change the admin user password in the database, visit
> the front page of a new installation to have DHIS2 generate data in the
> database for the admin user (you can do something as simple as $ curl -sL
> http://localhost:8080/). Then, you can enter the following query into the
> Postgres CLI with the DHIS2 database in use:
>
> UPDATE USERS SET password = '001122hashgoeshere221100' WHERE username =
> 'admin';
>
> Restart the application server (Tomcat) and then you should be able to log
> in with your new password *passwordGoesHere* or what you changed it to.
>
> Regards,
> Alan
>
> On Mon, Aug 31, 2015 at 11:02 AM, gerald thomas 
> wrote:
>
>> Dear all,
>> I am setting up a training server for staff and i am using dhis2 live
>> to achieve the task but i am using one of our database rather than the
>> default database. I had already used the following query to change the
>> admin password:
>>
>> UPDATE users set password = '48e8f1207baef1ef7fe478a57d19f2e5'
>> where username = 'admin';
>>
>> What am i doing which is wrong and why i can't login with username:
>> admin password: district
>>
>> --
>> Regards,
>>
>> Gerald
>>
>> ___
>> 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
>
>


-- 
Jason P. Pickering
email: jason.p.picker...@gmail.com
tel:+46764147049
___
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] [Dhis2-devs] Changing admin password to default

[Knut Staring]

Hi Alan,

Are you saying this will work also for DHIS2 versions up to and including
2.20? Or just for later versions? What is the result for "district"?

Knut

On Mon, Aug 31, 2015 at 11:21 PM, Alan Ivey  wrote:

> Hi Gerald,
>
> You can create a password hash with Python and the Bcrypt library. Run
> this single command in your terminal to get a hash for *passwordGoesHere*:
>
> $ python -c 'import bcrypt; hash = bcrypt.hashpw("*passwordGoesHere*",
> bcrypt.gensalt(rounds=10, prefix=b"2a")); print(hash);'
>
> You can insert the resulting hash directly into the database for the admin
> user.
>
> Note: If you do not have the Bcrypt library in your Python installation,
> you should add it with pip. The following will install all prerequisites on
> a CentOS 6 system:
>
> $ yum install gcc libffi-devel python-devel python-pip
> $ pip install --user bcrypt
>
> Before attempting to change the admin user password in the database, visit
> the front page of a new installation to have DHIS2 generate data in the
> database for the admin user (you can do something as simple as $ curl -sL
> http://localhost:8080/). Then, you can enter the following query into the
> Postgres CLI with the DHIS2 database in use:
>
> UPDATE USERS SET password = '001122hashgoeshere221100' WHERE username =
> 'admin';
>
> Restart the application server (Tomcat) and then you should be able to log
> in with your new password *passwordGoesHere* or what you changed it to.
>
> Regards,
> Alan
>
> On Mon, Aug 31, 2015 at 11:02 AM, gerald thomas 
> wrote:
>
>> Dear all,
>> I am setting up a training server for staff and i am using dhis2 live
>> to achieve the task but i am using one of our database rather than the
>> default database. I had already used the following query to change the
>> admin password:
>>
>> UPDATE users set password = '48e8f1207baef1ef7fe478a57d19f2e5'
>> where username = 'admin';
>>
>> What am i doing which is wrong and why i can't login with username:
>> admin password: district
>>
>> --
>> Regards,
>>
>> Gerald
>>
>> ___
>> 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
>
>


-- 
Knut Staring
Dept. of Informatics, University of Oslo
Norway: +4791880522
Skype: knutstar
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] Functionality of the Complete button in Data Entry

[Knut Staring]

Hi Rae,

The data are saved regardless, but clicking the button allows you to
indicate that you are indeed done filling in data, even though it might
look as though some data are missing - because you actually have nothing to
report. This is also related to the question of whether to require people
to report zero  (0) - and whether that is significantly different from not
reporting anything (NULL).

Others can complete the picture.

Knut

On Tue, Sep 1, 2015 at 10:42 PM, Rae Li  wrote:

> Hello DHIS 2 Team!
>
> I am not sure what exactly the functionality is of the Complete button in
> Data Entry. From what I have read in the DHIS 2 User-Manual, I understood
> that the Complete button is a subjective approach to calculating
> completeness, meaning that the data will be saved even if I do NOT click
> the Complete button after entering the data.
>
> Could you please provide me with more detailed explanation of the Complete
> button if I did not understand its functionality correctly?
>
> Thank you for your time addressing my question!
>
> Best,
> Rae
>
> --
> Ruiyi (Rae) Li
> Mailman School of Public Health
> Columbia University
>
> ___
> 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
Norway: +4791880522
Skype: knutstar
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

[Dhis2-users] Functionality of the Complete button in Data Entry

[Rae Li]

Hello DHIS 2 Team!

I am not sure what exactly the functionality is of the Complete button in
Data Entry. From what I have read in the DHIS 2 User-Manual, I understood
that the Complete button is a subjective approach to calculating
completeness, meaning that the data will be saved even if I do NOT click
the Complete button after entering the data.

Could you please provide me with more detailed explanation of the Complete
button if I did not understand its functionality correctly?

Thank you for your time addressing my question!

Best,
Rae

-- 
Ruiyi (Rae) Li
Mailman School of Public Health
Columbia University
___
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] [Dhis2-devs] Changing admin password to default

[gerald thomas]

Dear Alan,
Thanks very much

Regards,
Gerald
On Aug 31, 2015 9:22 PM, "Alan Ivey"  wrote:

> Hi Gerald,
>
> You can create a password hash with Python and the Bcrypt library. Run
> this single command in your terminal to get a hash for *passwordGoesHere*:
>
> $ python -c 'import bcrypt; hash = bcrypt.hashpw("*passwordGoesHere*",
> bcrypt.gensalt(rounds=10, prefix=b"2a")); print(hash);'
>
> You can insert the resulting hash directly into the database for the admin
> user.
>
> Note: If you do not have the Bcrypt library in your Python installation,
> you should add it with pip. The following will install all prerequisites on
> a CentOS 6 system:
>
> $ yum install gcc libffi-devel python-devel python-pip
> $ pip install --user bcrypt
>
> Before attempting to change the admin user password in the database, visit
> the front page of a new installation to have DHIS2 generate data in the
> database for the admin user (you can do something as simple as $ curl -sL
> http://localhost:8080/). Then, you can enter the following query into the
> Postgres CLI with the DHIS2 database in use:
>
> UPDATE USERS SET password = '001122hashgoeshere221100' WHERE username =
> 'admin';
>
> Restart the application server (Tomcat) and then you should be able to log
> in with your new password *passwordGoesHere* or what you changed it to.
>
> Regards,
> Alan
>
> On Mon, Aug 31, 2015 at 11:02 AM, gerald thomas 
> wrote:
>
>> Dear all,
>> I am setting up a training server for staff and i am using dhis2 live
>> to achieve the task but i am using one of our database rather than the
>> default database. I had already used the following query to change the
>> admin password:
>>
>> UPDATE users set password = '48e8f1207baef1ef7fe478a57d19f2e5'
>> where username = 'admin';
>>
>> What am i doing which is wrong and why i can't login with username:
>> admin password: district
>>
>> --
>> Regards,
>>
>> Gerald
>>
>> ___
>> 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-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] (no subject)

[Amina Abba Gana]

Hello,

My organisation is running a community ART project where have mobile teams
move from point to point within the community. I would like to know if
there's a way we can use dhis2 to track these teams and collect daily
reports as the move from point to point by automatically recording the GPS
coordinates while having the team enter data using dhis2 mobile.

Thanks

On 1 September 2015 at 10:31, Amina Abba Gana  wrote:

> Hello,
>
> My organisation is running a community ART project where have mobile teams
> move from point to point within the community.
>
___
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] (no subject)

[Amina Abba Gana]

Hello,

My organisation is running a community ART project where have mobile teams
move from point to point within the community.
___
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] [Dhis2-devs] Changing admin password to default

[Halvdan Grelland]

For the record: Starting in 2.21 we only accept bcrypt password hashes.
Anything else will fail.

Beginning in 2.17 we started hot-swapping every user logging in with the
old scheme (md5) to the new one (bcrypt) on login. Even though they work in
2.20 I strongly suggest using bcrypt hashes for this reason as well as the
obvious security improvement.

As it seems you've experienced, changing the password in the DB at runtime
will not work (application memory will hold the old one). If you need to
force a password swap you will need to change the password in the db before
you start the server.

2015-09-01 9:53 GMT+02:00 gerald thomas :

> Dear Alan,
> Thanks very much
>
> Regards,
> Gerald
> On Aug 31, 2015 9:22 PM, "Alan Ivey"  wrote:
>
>> Hi Gerald,
>>
>> You can create a password hash with Python and the Bcrypt library. Run
>> this single command in your terminal to get a hash for *passwordGoesHere*
>> :
>>
>> $ python -c 'import bcrypt; hash = bcrypt.hashpw("*passwordGoesHere*",
>> bcrypt.gensalt(rounds=10, prefix=b"2a")); print(hash);'
>>
>> You can insert the resulting hash directly into the database for the
>> admin user.
>>
>> Note: If you do not have the Bcrypt library in your Python installation,
>> you should add it with pip. The following will install all prerequisites on
>> a CentOS 6 system:
>>
>> $ yum install gcc libffi-devel python-devel python-pip
>> $ pip install --user bcrypt
>>
>> Before attempting to change the admin user password in the database,
>> visit the front page of a new installation to have DHIS2 generate data in
>> the database for the admin user (you can do something as simple as $
>> curl -sL http://localhost:8080/). Then, you can enter the following
>> query into the Postgres CLI with the DHIS2 database in use:
>>
>> UPDATE USERS SET password = '001122hashgoeshere221100' WHERE username =
>> 'admin';
>>
>> Restart the application server (Tomcat) and then you should be able to
>> log in with your new password *passwordGoesHere* or what you changed it
>> to.
>>
>> Regards,
>> Alan
>>
>> On Mon, Aug 31, 2015 at 11:02 AM, gerald thomas 
>> wrote:
>>
>>> Dear all,
>>> I am setting up a training server for staff and i am using dhis2 live
>>> to achieve the task but i am using one of our database rather than the
>>> default database. I had already used the following query to change the
>>> admin password:
>>>
>>> UPDATE users set password = '48e8f1207baef1ef7fe478a57d19f2e5'
>>> where username = 'admin';
>>>
>>> What am i doing which is wrong and why i can't login with username:
>>> admin password: district
>>>
>>> --
>>> Regards,
>>>
>>> Gerald
>>>
>>> ___
>>> 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-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp