Re: [Dhis2-devs] Retrieve previous month data value of a particular element and put it in current month data entry screen

2015-09-01 Thread Lars Helge Øverland
Hi Julhas, per today your best option is to implement this using javascript i.e. in the custom form, where you retrieve this data from the dataValueSets Web API resource. Web API Docs: https://www.dhis2.org/doc/snapshot/en/developer/html/ch01s11.html#d5e1433 Scripts in custom forms / callbacks d

Re: [Dhis2-devs] Retrieve previous month data value of a particular element and put it in current month data entry screen

2015-09-01 Thread Julhas Sujan
Thank you very much.I have written an API and added in the data entry editor as: jQuery( document ).ready( function() { $.get(" http://103.247.238.67:80

Re: [Dhis2-devs] Retrieve previous month data value of a particular element and put it in current month data entry screen

2015-09-01 Thread Lars Helge Øverland
The data entry module is still using custom endpoints and not the Web API, so you will have to live with the difference for now. Longer term we are working on migrating all web requests to the Web API. On Tue, Sep 1, 2015 at 9:32 AM, Julhas Sujan wrote: > Thank you very much.I have written an A

[Dhis2-devs] CORS VS Service Layer Access

2015-09-01 Thread Greg Rowles
Hi Devs Does anyone know if there are plans or even if its possible to support service layer access requests from external applications? E.g. pulling a custom HTML report from the Sierra Leone instance from my web application (similar to CORS but more like cross origin service sharing). I'm sure t

Re: [Dhis2-devs] Retrieve previous month data value of a particular element and put it in current month data entry screen

2015-09-01 Thread Julhas Sujan
Ok. Thank you very much. On Tue, Sep 1, 2015 at 1:34 PM, Lars Helge Øverland wrote: > > The data entry module is still using custom endpoints and not the Web API, > so you will have to live with the difference for now. > > Longer term we are working on migrating all web requests to the Web API.

[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 19920: minor fix, add color/colorSet to MetaData class for export

2015-09-01 Thread noreply
revno: 19920 committer: Morten Olav Hansen branch nick: dhis2 timestamp: Tue 2015-09-01 14:37:41 +0700 message: minor fix, add color/colorSet to MetaData class for export modified: dhis-2/dhis-services/dhis-service-dxf2/src/main/jav

Re: [Dhis2-devs] CORS VS Service Layer Access

2015-09-01 Thread Lars Helge Øverland
Hi Greg, we have OAuth2 authentication support which is intended for this use-case: https://www.dhis2.org/doc/snapshot/en/developer/html/ch01s02.html#d5e75 regards, Lars On Tue, Sep 1, 2015 at 9:36 AM, Greg Rowles wrote: > Hi Devs > > Does anyone know if there are plans or even if its possi

[Dhis2-devs] Problem log-in

2015-09-01 Thread channara rin
Hi all dhis2, Can you help me what is problem login page, i can't log in with admin account. What should i do? [image: Inline image 1] ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://l

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

2015-09-01 Thread 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 = bcry

Re: [Dhis2-devs] Problem log-in

2015-09-01 Thread Morten Olav Hansen
Hi That error message just means wrong password.. bad credentials -- Morten On Tue, Sep 1, 2015 at 2:51 PM, channara rin wrote: > Hi all dhis2, > Can you help me what is problem login page, i can't log in with admin > account. What should i do? > [image: Inline image 1] > > > _

Re: [Dhis2-devs] Problem log-in

2015-09-01 Thread Knut Staring
What has changed since the last time? Do you have another account with superuSer privileges? On Sep 1, 2015 9:59 AM, "channara rin" wrote: > Hi all dhis2, > Can you help me what is problem login page, i can't log in with admin > account. What should i do? > [image: Inline image 1] > > > _

Re: [Dhis2-devs] Problem log-in

2015-09-01 Thread channara rin
But it still display log-in page. On Tue, Sep 1, 2015 at 3:13 PM, channara rin wrote: > Hi Morten, > I go to database schema and change value of attribute: "Password" to > value:"*$2a$10$iig96L.lNFPYgt9Go0bJGuJ2A5Sdqid17wV/xwEHlq.cCDYXdGFG2* > "="district" > > > On Tue, Sep 1, 2015 at 2:55 PM, M

Re: [Dhis2-devs] Problem log-in

2015-09-01 Thread channara rin
Hi Morten, I go to database schema and change value of attribute: "Password" to value:" *$2a$10$iig96L.lNFPYgt9Go0bJGuJ2A5Sdqid17wV/xwEHlq.cCDYXdGFG2*"="district" On Tue, Sep 1, 2015 at 2:55 PM, Morten Olav Hansen wrote: > Hi > > That error message just means wrong password.. bad credentials >

Re: [Dhis2-devs] Problem log-in

2015-09-01 Thread channara rin
No! i don't have any account more. On Tue, Sep 1, 2015 at 3:13 PM, channara rin wrote: > But it still display log-in page. > > On Tue, Sep 1, 2015 at 3:13 PM, channara rin > wrote: > >> Hi Morten, >> I go to database schema and change value of attribute: "Password" to >> value:"*$2a$10$iig96L.l

Re: [Dhis2-devs] Problem log-in

2015-09-01 Thread Lars Helge Øverland
Hi Channara, do this to set password to district for user admin: update users set password='$2a$10$wjLPViry3bkYEcjwGRqnYO1bT2Kl.ZY0kO.fwFDfMX53hitfx5.3C' where username='admin'; Then restart tomcat to make sure the application cache is cleared. Then log in with admin/district. regards, Lars

Re: [Dhis2-devs] Problem log-in

2015-09-01 Thread channara rin
Yes, now it work fine thank Lars, Morten On Tue, Sep 1, 2015 at 3:23 PM, Lars Helge Øverland wrote: > Hi Channara, > > do this to set password to district for user admin: > > update users set > password='$2a$10$wjLPViry3bkYEcjwGRqnYO1bT2Kl.ZY0kO.fwFDfMX53hitfx5.3C' > where username='admin'; > >

Re: [Dhis2-devs] Problem log-in

2015-09-01 Thread Knut Staring
Excellent. However, why is this different from the password discussed in Gerald's thread with Alan and Jason? $2a$10$iig96L.lNFPYgt9Go0bJGuJ2A5Sdqid17wV/xwEHlq.cCDYXdGFG2 $2a$10$wjLPViry3bkYEcjwGRqnYO1bT2Kl.ZY0kO.fwFDfMX53hitfx5.3C Knut On Tue, Sep 1, 2015 at 11:00 AM, channara rin wrote: > Ye

[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 19921: Analytics tables. Making sure to ignore duplicate analytics tables. Might happen for non-iso cale...

2015-09-01 Thread noreply
revno: 19921 committer: Lars Helge Overland branch nick: dhis2 timestamp: Tue 2015-09-01 11:22:27 +0200 message: Analytics tables. Making sure to ignore duplicate analytics tables. Might happen for non-iso calendars. modified: dhis

[Dhis2-devs] Weird cache issue

2015-09-01 Thread Calle Hedberg
Hi I've got a baffling problem (presumably related to some kind of caching): 1. yesterday I updated various data records using pgremote, including data set names. We restarted tomcat after the updates. 2. I've also cleared my browser cache, the DHIS2 cache, updated resource tables, etc. 3. When

Re: [Dhis2-devs] Weird cache issue

2015-09-01 Thread Lars Helge Øverland
Hi Calle, perhaps you did not update the data set short names? Lars On Tue, Sep 1, 2015 at 11:50 AM, Calle Hedberg wrote: > Hi > > I've got a baffling problem (presumably related to some kind of caching): > > 1. yesterday I updated various data records using pgremote, including data > set name

[Dhis2-devs] Convert Excel to xml and to json

2015-09-01 Thread channara rin
Hi all DHIS2, Do you know how to convert Excel tracker list to xml and to json that enable import into DHIS2 system? [image: Inline image 1] thank you CHANNARA ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.

Re: [Dhis2-devs] Problem log-in

2015-09-01 Thread Halvdan Grelland
They should be different. Bcrypt (or any sane pw hashing scheme for that matter) uses a random salt per run (which is embedded in the resulting string). 2015-09-01 11:06 GMT+02:00 Knut Staring : > Excellent. However, why is this different from the password discussed in > Gerald's thread with Alan

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

2015-09-01 Thread 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

[Dhis2-devs] Pivot or event report (Facts Sheets) into word

2015-09-01 Thread moses mwale
Hello, is it possible that fact sheets (Pivot tables or event reports) can be converted into word or excel? ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs Mo

Re: [Dhis2-devs] Weird cache issue

2015-09-01 Thread Calle Hedberg
Lars, Nope - all data set names and short names are the same. It's just weird, and I don't like inexplicable things happening to a database When you run data integrity - WHERE are those queries fetching data from? Are the integrity queries running against the database itself, or some kind of

[Dhis2-devs] Pivot tables or event reports

2015-09-01 Thread moses mwale
Hello, is it possible that fact sheets (Pivot tables or event reports) can be converted into word or excel? ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs Mo

Re: [Dhis2-devs] Convert Excel to xml and to json

2015-09-01 Thread Alex Tumwesigye
Dear Channara, The simplest way is to map this excel to a temp table in postgres, then use postgres json functionality to format the data from the temp table to a json format directly. You may need a function to update each event with a uid for tracking so that you don't send duplicates. Alex

Re: [Dhis2-devs] Weird cache issue

2015-09-01 Thread Jason Pickering
Hi Calle, It is very difficult to say much without knowing what SQL it was you executed. In general, use of the API or UI is usually much safer. Do you have any sort of cache in front of your DHIS2 instance? Can you confirm from the database that the names were actually changed? Regards, Jason

Re: [Dhis2-devs] Convert Excel to xml and to json

2015-09-01 Thread Knut Staring
Dear Channara, Please avoid posting ANY information about individual people on this list. Knut On Tue, Sep 1, 2015 at 12:02 PM, channara rin wrote: > Hi all DHIS2, > Do you know how to convert Excel tracker list to xml and to json that > enable import into DHIS2 system? > > [image: Inline imag

Re: [Dhis2-devs] Weird cache issue

2015-09-01 Thread Calle Hedberg
Jason I was not executing any custom sql - I'm running the Data Administration -> Data Integrity process checks. My reference to the sql queries being run relates to my ASSUMPTION that the Data Integrity checks are a series of SQL queries - but maybe not, maybe the integrity checks are a series o

Re: [Dhis2-devs] Convert Excel to xml and to json

2015-09-01 Thread Jason Pickering
Hi Channara, Good to know this is fake data. Anyway, did you have a look here at the docs ? I think you would need quite a few scripts for this. You would need to properly encode and escape the Khmer text to UTF-8, format the DOB

[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 19922: Introduced attribute type category combo to programs. This will be used to tage events of a given...

2015-09-01 Thread noreply
revno: 19922 committer: Abyot Asalefew Gizaw branch nick: dhis2 timestamp: Tue 2015-09-01 16:28:36 +0200 message: Introduced attribute type category combo to programs. This will be used to tage events of a given program based on diffe

Re: [Dhis2-devs] Weird cache issue

2015-09-01 Thread Halvdan Grelland
Calle, I'm pretty sure Jason was referring to whatever you were doing to update the records (your point #1 in original email) which was not, as far as I can understand, using the UI or the web-api. I am not familiar with "pgremote" but am assuming it's some kind of postgres connector allowing you t

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

2015-09-01 Thread 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

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

2015-09-01 Thread 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

Re: [Dhis2-devs] Weird cache issue

2015-09-01 Thread Calle Hedberg
Halvdan, Ah, OK, and not - I was not using any queries, I simply updated the Data Set names directly in the table. As I've said - the weird thing is that all those new names immediately showed up in the UI data set list, but the old names are still appearing wherever the Data Integrity process th

[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 19923: adds persisted valuetype (vtype), old types are still present for now, does not expose type/textt...

2015-09-01 Thread noreply
revno: 19923 committer: Morten Olav Hansen branch nick: dhis2 timestamp: Wed 2015-09-02 12:15:31 +0700 message: adds persisted valuetype (vtype), old types are still present for now, does not expose type/texttype/numbertype in the web

[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 19924: Minor fix

2015-09-01 Thread noreply
revno: 19924 committer: Morten Olav Hansen branch nick: dhis2 timestamp: Wed 2015-09-02 12:19:09 +0700 message: Minor fix modified: dhis-2/dhis-services/dhis-service-core/src/main/java/org/hisp/dhis/startup/TableAlteror.java -- lp

[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 19925: support de.valueType mergeWith

2015-09-01 Thread noreply
revno: 19925 committer: Morten Olav Hansen branch nick: dhis2 timestamp: Wed 2015-09-02 12:21:56 +0700 message: support de.valueType mergeWith modified: dhis-2/dhis-api/src/main/java/org/hisp/dhis/dataelement/DataElement.java -- lp

[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 19926: update DefaultDataEntryFormService to use ValueType

2015-09-01 Thread noreply
revno: 19926 committer: Morten Olav Hansen branch nick: dhis2 timestamp: Wed 2015-09-02 12:26:25 +0700 message: update DefaultDataEntryFormService to use ValueType modified: dhis-2/dhis-services/dhis-service-core/src/main/java/org/h

[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 19927: use ValueType in MinMaxOutlierAnalysisService

2015-09-01 Thread noreply
revno: 19927 committer: Morten Olav Hansen branch nick: dhis2 timestamp: Wed 2015-09-02 12:31:37 +0700 message: use ValueType in MinMaxOutlierAnalysisService modified: dhis-2/dhis-services/dhis-service-core/src/main/java/org/hisp/dh

[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 19928: minor fix, ignore two tests in schema/query-service which are now invalid (since we don't expose ...

2015-09-01 Thread noreply
revno: 19928 committer: Morten Olav Hansen branch nick: dhis2 timestamp: Wed 2015-09-02 13:04:09 +0700 message: minor fix, ignore two tests in schema/query-service which are now invalid (since we don't expose type/numberType in web-ap