[Dhis2-devs] Update OrgUnit Attributes via WebAPI
Hi All
Could some please confirm the endpoint to use to update an orgUnit
attribute value {orgUnit.attributeValues} in 2.20. A pointer to the
documentation if available or a quick example would be highly appreciated.
Regards
Farai Mutero
___
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
[Dhis2-devs] Detect password expiry via WebAPI
Hi All Which WebAPI end-point can one use to check when a users password is set to expire? Regards -- Farai Mutero ___ 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
Re: [Dhis2-devs] Detect password expiry via WebAPI
Hi Stian Thank you very much, it works!! Regards Farai On Tue, Jul 18, 2017 at 11:56 AM, Stian Sandvold wrote: > Hi Farai, > > You can use the /api/users endpoint to get information about password > expiry. > > The expiry is based on time after last password change, and not set to a > certain date of expiry, so when you use this endpoint you only get the last > time the password was updated, so you need to calculate yourself when the > password actually expires. > > The following query will return the property you want for a given user: > ?fields=userCredentials[passwordLastUpdated] > > On Tue, Jul 18, 2017 at 11:48 AM, Farai Mutero wrote: > >> Hi All >> >> Which WebAPI end-point can one use to check when a users password is set >> to expire? >> >> Regards >> >> -- >> Farai Mutero >> >> >> ___ >> 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 >> >> > > > -- > Stian Sandvold > Software developer, DHIS2 > University of Oslo > http://www.dhis2.org > -- Farai Mutero ___ 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
[Dhis2-devs] WebAPI : New way to assign an orgUnit to an orgUnitGroup?
Hi All
In older versions of DHIS (pre 2.26), one could assign an OrgUnitGroup to
an OrgUnit using the following Ajax call:
var posturl = base + 'api/organisationUnitGroups/' + ouGroupUID +
'/organisationUnits/' + ouUID + '.json';
$.ajax({
url: posturl,
type: "PUT",
dataType: "text",
contentType: "application/json; charset=utf-8",
async: false,
success: function (response) {
console.log("OrgUnit Group update successful");
}
});
Now on 2.27 the WebAPI returns the following response:
{"httpStatus":"Method Not
Allowed","httpStatusCode":405,"status":"ERROR","message":"Request method
'PUT' not supported"}
So what is the solution to achieve the above goal in 2.27?
Regards
--
Farai Mutero
___
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
Re: [Dhis2-devs] Error creating user account 2.27
Hi Sam
I'm also experiencing exactly the same issue. I following this story keenly
to find a solution to this bug.
Version:2.27Build revision:0a49a22Build date:2017-08-10 06:25
Regards
Farai Mutero
On Tue, Aug 15, 2017 at 6:01 AM, Sam Kasozi wrote:
> I am trying to create an account in a 2.27 instance, but the system just
> hangs.
>
> Version:2.27Build revision:6685265Build date:2017-06-07 06:38
>
> Below is the console message I am getting and wondering if this had
> happened before.
>
>
> // 20170815082703
> // http://localhost:8080/dhis/api/account/password?password=Dhis2017!
>
> {
> "httpStatus": "Internal Server Error",
> "httpStatusCode": 500,
> "status": "ERROR",
> "message": "java.lang.String cannot be cast to java.lang.Integer"
> }
>
>
> Sam Kasozi
> +256 788-993-565
> Skype: sam.kasoziug
>
> ___
> 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
>
>
--
Farai Mutero
___
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
[Dhis2-devs] Request For WebAPI DataStore Documentation
Hi All Could someone please share links to the WebAPI documentation on using the "api/dataStore/" endpoint? Regards -- Farai Mutero ___ 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
Re: [Dhis2-devs] Request For WebAPI DataStore Documentation
Thanks Jason and Stian for the prompt response. Much appreciated. Regards Farai On Mon, Aug 28, 2017 at 1:10 PM, Jason Pickering < jason.p.picker...@gmail.com> wrote: > https://docs.dhis2.org/master/en/developer/html/webapi_data_store.html > > On Mon, Aug 28, 2017 at 12:55 PM, Farai Mutero wrote: > >> Hi All >> >> Could someone please share links to the WebAPI documentation on using the >> "api/dataStore/" endpoint? >> >> Regards >> >> -- >> Farai Mutero >> >> >> ___ >> 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 >> >> > > > -- > Jason P. Pickering > email: jason.p.picker...@gmail.com > tel:+46764147049 <+46%2076%20414%2070%2049> > -- Farai Mutero ___ 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
[Dhis2-devs] How to bypass login page in dhis2 app
Hi Team When developing a standard dhis2 app. How do you get it to load up the home page in any browser without being forced to login first especially in a browser that does not have an existing login session running? Regards -- Farai Mutero ___ 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
[Dhis2-devs] FIlter Orgunits Using Date Fields
Hi Devs How does one filter for orgunits from the "api/organisationUnits/" endPoint using the *lastUpdated* or *created* date fields? A working example of the Web API call would be highly appreciated. Regards -- Farai Mutero ___ 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
[Dhis2-devs] Update User Password Via Web API
Hi All
We are looking at automating the process of resetting of a user's password
when the password expires I'm trying to update the user password via the
WebAPI. I carefully prepare the payload as dictated by the documentation
and the API sends back a response as below that the user has been updated,
but the password does not change, the old password still works even after
providing a new one in the payload. How can I solve this problem?
{"importParams":{"importMode":"COMMIT","identifier":"UID","preheatMode":"REFERENCE","importStrategy":"UPDATE","atomicMode":"ALL","mergeMode":"REPLACE","flushMode":"AUTO","skipSharing":false,"skipValidation":false,"username":"Farai_Mutero"},"status":"OK","typeReports":[{"klass":"org.hisp.dhis.user.User","stats":{"created":0,"updated":1,"deleted":0,"ignored":0,"total":1},"objectReports":[{"klass":"org.hisp.dhis.user.User","index":0,"uid":"ogzPPGeR3je"}]}],"stats":{"created":0,"updated":1,"deleted":0,"ignored":0,"total":1}}
--
Farai Mutero
___
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
Re: [Dhis2-devs] Update User Password Via Web API
Hi Morten
Yes absolutely. This is the payload that I'm sending :
{
"id": "ogzPPGeR3je",
"name": "Joe Soap",
"displayName": "Joe Soap",
"surname": "Soap",
"firstName": "Joe",
"userCredentials": {
"id": "l0LtVrLx9rn",
"username": "",
"password":"Password@1#",
"userInfo": {
"id": "ogzPPGeR3je"
},
"user": {
"id": "sYPA2WEAwF8"
},
"userRoles":[
{
"id":"oxkpIDF5yNe"
},
{
"id":"V3pb8xpnDnM"
},
{
"id":"B1cxBsDczWI"
},
{
"id":"saLI2pdSaI7"
},
{
"id":"XaVXiwNYTvf"
},
{
"id":"VyFlshFvGlW"
},
{
"id":"pqV3wvWzg3Z"
}
],
"userAccesses":[
]
},
"userGroups": [
{
"id": "BTQxAAEIjyJ"
},
{
"id": "lWaxJV3AWIo"
}
],
"organisationUnits":[
{
"id":"JLA7wl59oN3"
}
],
"dataViewOrganisationUnits":[
{
"id":"JLA7wl59oN3"
}
],
"attributeValues": [
{
"lastUpdated": "2017-10-12T12:26:20.700",
"created": "2017-10-12T12:26:20.695",
"value": "BRO001",
"attribute": {
"id": "bLr1v9A0XaW"
}
},
{
"lastUpdated": "2017-10-12T12:26:20.697",
"created": "2017-10-12T12:26:20.695",
"value": "Monitoring and Evaluation",
"attribute": {
"id": "EkBIN7Ow26B"
}
},
{
"lastUpdated": "2017-10-12T12:26:20.700",
"created": "2017-10-12T12:26:20.695",
"value": "6008110043087",
"attribute": {
"id": "w8br4js83bo"
}
},
{
"lastUpdated": "2018-01-22T12:36:08.156",
"created": "2018-01-22T12:36:08.153",
"value": "-- Select --",
"attribute": {
"id": "bCNA5mqP6Az"
}
}
]
}
The summary response I get after posting the payload is :
{"importParams":{"importMode":"COMMIT","identifier":"UID","preheatMode":"REFERENCE","importStrategy":"UPDATE","atomicMode":"ALL","mergeMode":"REPLACE","flushMode":"AUTO","skipSharing":false,"skipValidation":false,"username":"Farai_Mutero"},"status":"OK","typeReports":[{"klass":"org.hisp.dhis.user.User","stats":{"created":0,"updated":1,"deleted":0,"ignored":0,"total":1},"objectReports":[{"klass":"org.hisp.dhis.user.User","index":0,"uid":"ogzPPGeR3je"}]}],"stats":{"created":0,"updated":1,"deleted":0,"ignored":0,"total":1}}
On Mon, Mar 26, 2018 at 5:14 PM, Morten Olav Hansen
wrote:
> What you provide here is just the summary report...
>
> To change a password, you need to add "password" field to the
> "userCredentials" part of the payload... are you doing that?
>
> --
> Morten Olav Hansen
> Senior Engineer, DHIS 2
> University of Oslo
> http://www.dhis2.org
>
> On Mon, Mar 26, 2018 at 6:25 PM, Farai Mutero wrote:
>
>> Hi All
>>
>> We are looking at automating the process of resetting of a user's
>> password when the password expires I'm trying to update the user password
>> via the WebAPI. I carefully prepare the payload as dictated by the
>> documentation and the API sends back a response as below that the user has
>> been updated, but the password does not change, the old password still
>> works even after providing a new one in the payload. How can I solve this
>> problem?
>>
>> {"importParams":{"importMode":"COMMIT","identifier":"UID","p
>> reheatMode":"REFERENCE","importStrategy":"UPDATE","atomicMod
>> e":"ALL","mergeMode":"REPLACE","flushMode":"AUTO","skipShari
>> ng":false,"skipValidation":false,"username":"Farai_
>> Mutero"},"status":"OK","typeReports":[{"klass":"org.
>> hisp.dhis.user.User","stats":{"created":0,"updated":1,"
>> deleted":0,"ignored":0,"total":1},"objectReports":[{"klass":
>> "org.hisp.dhis.user.User","index":0,"uid":"ogzPPGeR3je"}]
>> }],"stats":{"created":0,"updated":1,"deleted":0,"ignored":0,"total":1}}
>>
>> --
>> Farai Mutero
>>
>>
>> ___
>> 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
>>
>>
>
--
Farai Mutero
___
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
[Dhis2-devs] Updating multiple events via the WebAPI
Hi Team The DHIS2 Developer documentation discusses here <https://docs.dhis2.org/master/en/developer/html/webapi_tracker_api.html#webapi_events>, the ability to POST multiple events to the Web API in a single payload, which is absolutely useful. Is this feature also available for updating existing events via a PUT request, In DHIS2 2.27 and later? Regards -- Farai Mutero ___ 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
[Dhis2-devs] Event Date location
Hi Guys
Quick and easy question for you: When you upload an event payload into
DHIS2 via the Web-API (payload example shown below), in which table in the
database is the event date stored?
{
"program": "eBAyeGv0exc",
"orgUnit": "DiszpKrYNg8",
"eventDate": "2013-05-17",
"status": "COMPLETED",
"storedBy": "admin",
"coordinate": {
"latitude": "59.8",
"longitude": "10.9"
},
"dataValues": [
{ "dataElement": "qrur9Dvnyt5", "value": "22" },
{ "dataElement": "oZg33kd9taw", "value": "Male" },
{ "dataElement": "msodh3rEMJa", "value": "2013-05-18" }
]
}
Regards
--
Farai Mutero
___
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
[Dhis2-devs] User Account Registration via the Web API
Hi Guys I have been informed that it's now possible to register users via the Web API using the User Account Invitation process and in the process provide a default password such that the registered users don't have to reply on email? Can someone please confirm this for me? I understand Jason Pickering presented this functionality recently in Livingstone, Zambia. The User Account Invitation process I'm referring to is documented here: https://www.dhis2.org/doc/snapshot/en/developer/html/ch01s30.html#d5e3951 Regards -- Farai Mutero ___ 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
Re: [Dhis2-devs] User Account Registration via the Web API
Hi Jason Excellent. Thank you very much Jason! I'm answered clearly. Regards Farai On Thu, Jun 25, 2015 at 10:19 AM, Jason Pickering < jason.p.picker...@gmail.com> wrote: > Hi Farai, > > It is possible, but let me explain it a bit more clearly. There are > essentially three ways to do create users. > > 1) Allow users to self-register. > > 2) Send a user an invite. This allows them to specify their > username/password and is considered to be more secure, as the password is > never transmitted over insecure means. This method is described in detail > in the link which you provided. > > 3) Create users with pre-defined username and password. This can be done > with XML/JSON through the metadata API. You can follow the example ofhere > https://apps.dhis2.org/demo/api/users/oXD88WWSQpR to know how the payload > should be structured. > The property "password" should contain the clear-text password of the > user, and should be a child of the "userCredentials" node. > Once you create the XML/JSON payload as you like, then you can post this > to /api/metaData. > > Hope this helps. > > Best regards, > Jason > > > > On Thu, Jun 25, 2015 at 9:39 AM, Farai Mutero wrote: > >> Hi Guys >> >> I have been informed that it's now possible to register users via the Web >> API using the User Account Invitation process and in the process provide a >> default password such that the registered users don't have to reply on >> email? >> >> Can someone please confirm this for me? I understand Jason Pickering >> presented this functionality recently in Livingstone, Zambia. The User >> Account Invitation process I'm referring to is documented here: >> https://www.dhis2.org/doc/snapshot/en/developer/html/ch01s30.html#d5e3951 >> >> Regards >> >> -- >> Farai Mutero >> >> >> ___ >> 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 >> >> > > > -- > Jason P. Pickering > email: jason.p.picker...@gmail.com > tel:+46764147049 > -- Farai Mutero ___ 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
[Dhis2-devs] Error Posting DataValueSet payload to DHIS2 via Web API
Hi All
I'm trying to upload a dataValueSet payload to DHIS2. The payload structure
is as follows:
{
- "dataSet":"uokZhuVwx5F",
- "completeDate":"2014-06-29",
- "period":"201406",
- "orgUnit":"G4uL7kaWCqS",
- "dataValues":[
1. {
- "dataElement":"N1p2C3w2X2u",
- "value":"1",
- "storedBy":"Farai_Mutero"
}
]
}
The curl command I'm using to post is structured as follows:
curl -d @{local_path}\dataValues.json "http://{ip_address}/api/dataValueSets";
-H "Content-Type:application/json" -u admin:district -v
I have verified the accuracy of the UIDs in the payload and they are
correct. However the error message returned from DHIS2 is as follows:
{"status":"ERROR","description":"The import process failed: Failed to
create
statement","importCount":{"imported":0,"updated":0,"ignored":0,"deleted":0}}
The DHIS2 server version I'm posting to is:
Version:2.19Build revision:16781Build date:2015-05-18 23:21
Can someone please enlighten me on what the error may be?
Regards
--
Farai Mutero
___
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
[Dhis2-devs] Importing Validation Rules through the Web API
Hi Guys Could anyone please be kind enough to share the steps to import Validation Rules through the Web API? Please also provide a sample url and possibly a template csv file (if necessary). Your assistance will be much appreciated. Regards -- Farai Mutero ___ 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
Re: [Dhis2-devs] Importing Validation Rules through the Web API
Thanks Lars and Ranga for the info. Now I'm clear.
Regards
Farai
On Mon, Jul 15, 2013 at 9:03 PM, Lars Helge Øverland wrote:
> Hi Farai,
>
> the meta-data import process is documented here:
>
> http://www.dhis2.org/doc/snapshot/en/user/html/ch25s05.html
>
> First, you need to construct your XML (or possibly JSON), something like
> this:
>
>
> http://dhis2.org/schema/dxf/2.0";
> created="2013-07-15T18:54:37.575+">
>
> lastUpdated="2011-12-24T11:24:22.817+" id="B3cosSOA63b">
> absoluteless_than_or_equal_to
>
> #{pEOVd4Z3TAS.Prlt0C1RF0s}
> People asked at Penta3 if Exclusive
> breastfeeding, <1 year Fixed[33.292]
> true
>
> lastUpdated="2013-03-15T16:32:25.814+" id="pEOVd4Z3TAS"/>
>
>
>
> #{n6aMJNLdvep.Prlt0C1RF0s}
> Penta3, <1 year Fixed[25.292]
> true
>
> created="2012-11-05T11:56:39.621+"
> lastUpdated="2013-03-15T16:32:25.950+" id="n6aMJNLdvep"/>
>
>
> MonthlyQuestion asked at
> Penta3 vs number of Penta3
>
>
>
>
>
>
> Please note the wrapper element. After that you can POST your
> xml to the metaData web api resource with something like this if using curl
> and naming the file metaData.xml:
>
> curl -H "Content-Type: application/xml" -u admin:district -d @metaData.xml
> "http://your-server-url/api/metaData"; -X POST
>
>
> regards,
>
> Lars
>
>
>
>
>
>
>
>
>
>
> On Thu, Jun 27, 2013 at 5:25 PM, Farai Mutero wrote:
>
>> Hi Guys
>>
>> Could anyone please be kind enough to share the steps to import
>> Validation Rules through the Web API? Please also provide a sample url and
>> possibly a template csv file (if necessary).
>>
>> Your assistance will be much appreciated.
>>
>> Regards
>> --
>> Farai Mutero
>>
>>
>> ___
>> 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
>>
>>
>
--
Farai Mutero
___
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
[Dhis2-devs] Error when importing DHIS1.4 data file.
Current user:admin Version:2.13-SNAPSHOT Build revision:11315 Build date:2013-07-03 05:02 Hi All I'm importing a DHIS1.4 data file into DHIS2 and I'm getting the following error in my log file. Any idea what might be causing the error. Please see my log file details below : * INFO 15:25:40,813 All startup routines done (DefaultStartupRoutineExecutor.java [Thread-2]) * INFO 15:25:53,436 Lifecycle: server started (TrayApp.java [Thread-2]) * INFO 15:26:43,808 Login success for user: 'admin', ip: '0:0:0:0:0:0:0:1' (DefaultUserAuditService.java [8790081@qtp-18379432-0]) * INFO 15:27:46,273 Internal process started (AbstractStatementInternalProcess.java [Thread-20]) * ERROR 15:28:11,581 Internal process failed (AbstractStatementInternalProcess.java [Thread-20]) java.lang.RuntimeException: Query for Object failed at org.hisp.dhis.importexport.dhis14.file.query.IbatisQueryManager.queryForObject(IbatisQueryManager.java:79) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:198) at $Proxy130.queryForObject(Unknown Source) at org.hisp.dhis.importexport.dhis14.file.importer.DefaultDhis14FileImportService.verifyImportFile(DefaultDhis14FileImportService.java:788) at org.hisp.dhis.importexport.dhis14.file.importer.DefaultDhis14FileImportService.importData(DefaultDhis14FileImportService.java:256) at org.hisp.dhis.importexport.ImportInternalProcess.executeStatements(ImportInternalProcess.java:89) at org.hisp.dhis.system.process.AbstractStatementInternalProcess.execute(AbstractStatementInternalProcess.java:103) at org.hisp.dhis.system.process.AbstractStatementInternalProcess.execute(AbstractStatementInternalProcess.java:40) at org.amplecode.cave.process.ProcessExecutor.run(ProcessExecutor.java:125) at java.lang.Thread.run(Unknown Source) Caused by: java.sql.SQLException: Error: executeQueryForObject returned too many results. at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForObject(GeneralStatement.java:108) at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:561) at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:536) at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForObject(SqlMapSessionImpl.java:93) at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForObject(SqlMapClientImpl.java:70) at org.hisp.dhis.importexport.dhis14.file.query.IbatisQueryManager.queryForObject(IbatisQueryManager.java:69) ... 14 more Regards -- Farai Mutero ___ 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
Re: [Dhis2-devs] Error when importing DHIS1.4 data file.
Wow, thank you so much Lars. Will import a couple of DHIS 1.4 data files and let you know how it goes. Thanks Jason for the input. On Fri, Jul 19, 2013 at 7:47 PM, Lars Helge Øverland wrote: > Hi Farai, > > I think I have found and fixed the bug in trunk and 2.12 in r 11453. > > You can get it from dhis2.org/downloads in 30 min or build the source > yourself. > > Let us know if this fixes your problem. > > Lars > > > > On Fri, Jul 19, 2013 at 3:57 PM, Farai Mutero wrote: > >> Current user:admin Version:2.13-SNAPSHOT Build revision:11315 Build >> date:2013-07-03 05:02 >> >> Hi All >> >> I'm importing a DHIS1.4 data file into DHIS2 and I'm getting the >> following error in my log file. Any idea what might be causing the error. >> Please see my log file details below : >> >> * INFO 15:25:40,813 All startup routines done >> (DefaultStartupRoutineExecutor.java [Thread-2]) >> * INFO 15:25:53,436 Lifecycle: server started (TrayApp.java [Thread-2]) >> * INFO 15:26:43,808 Login success for user: 'admin', ip: >> '0:0:0:0:0:0:0:1' (DefaultUserAuditService.java [8790081@qtp-18379432-0]) >> * INFO 15:27:46,273 Internal process started >> (AbstractStatementInternalProcess.java [Thread-20]) >> * ERROR 15:28:11,581 Internal process failed >> (AbstractStatementInternalProcess.java [Thread-20]) >> java.lang.RuntimeException: Query for Object failed >> at >> org.hisp.dhis.importexport.dhis14.file.query.IbatisQueryManager.queryForObject(IbatisQueryManager.java:79) >> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >> at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) >> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) >> at java.lang.reflect.Method.invoke(Unknown Source) >> at >> org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317) >> at >> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:198) >> at $Proxy130.queryForObject(Unknown Source) >> at >> org.hisp.dhis.importexport.dhis14.file.importer.DefaultDhis14FileImportService.verifyImportFile(DefaultDhis14FileImportService.java:788) >> at >> org.hisp.dhis.importexport.dhis14.file.importer.DefaultDhis14FileImportService.importData(DefaultDhis14FileImportService.java:256) >> at >> org.hisp.dhis.importexport.ImportInternalProcess.executeStatements(ImportInternalProcess.java:89) >> at >> org.hisp.dhis.system.process.AbstractStatementInternalProcess.execute(AbstractStatementInternalProcess.java:103) >> at >> org.hisp.dhis.system.process.AbstractStatementInternalProcess.execute(AbstractStatementInternalProcess.java:40) >> at >> org.amplecode.cave.process.ProcessExecutor.run(ProcessExecutor.java:125) >> at java.lang.Thread.run(Unknown Source) >> Caused by: java.sql.SQLException: Error: executeQueryForObject returned >> too many results. >> at >> com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForObject(GeneralStatement.java:108) >> at >> com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:561) >> at >> com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:536) >> at >> com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForObject(SqlMapSessionImpl.java:93) >> at >> com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForObject(SqlMapClientImpl.java:70) >> at >> org.hisp.dhis.importexport.dhis14.file.query.IbatisQueryManager.queryForObject(IbatisQueryManager.java:69) >> ... 14 more >> >> Regards >> >> -- >> Farai Mutero >> >> >> ___ >> 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 >> >> > -- Farai Mutero ___ 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
[Dhis2-devs] Web API Pivot Table Layout
Hi Guys I'm using the Web API to design an html report displaying pivot tables. How do I adjust my url call so that the pivot table rendered can display in the same way it was designed. Using the DHIS2 demo for example, if I use the url http://apps.dhis2.org/demo/api/analytics.html?dimension=dx:Jtf34kNZhzP;cYeuwXTCPkU;fbfJHSPpUQD;hfdmMSPBgLG&dimension=ou:USER_ORGUNIT_CHILDREN&dimension=pe:THIS_YEAR I get this view : [image: Inline image 1] Yet I would like the Pivot Table to have a layout like this : [image: Inline image 2] Regards -- Farai Mutero -- Farai Mutero <><>___ 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
Re: [Dhis2-devs] Web API Pivot Table Layout
Thanks Jan for the feedback. Noted. The following querystring parameters *" tableLayout=true&columns=dx;ou&rows=pe"* found in the Web API documentation just provided what I was looking for : api/analytics.html?dimension=dx:fbfJHSPpUQD;cYeuwXTCPkU&dimension=pe:2012Q1;2012Q2&dimension=ou:O6uvpzGd5pu*&tableLayout=true&columns=dx;ou&rows=pe* One more question : If I setup a chart using the Data Visualizer and I have saved it as "favourite", how do I call that chart favourite from my html report passing a dynamic org unit parameter to it? Regards Farai On Wed, Jul 24, 2013 at 7:38 PM, Jan Henrik Øverland < janhenrik.overl...@gmail.com> wrote: > Hi Farai, such layout is produced by the pivot tables client, so you > cannot get it directly from the server. > > > On Wed, Jul 24, 2013 at 6:44 PM, Farai Mutero wrote: > >> Hi Guys >> >> I'm using the Web API to design an html report displaying pivot tables. >> How do I adjust my url call so that the pivot table rendered can display in >> the same way it was designed. >> >> Using the DHIS2 demo for example, if I use the url >> http://apps.dhis2.org/demo/api/analytics.html?dimension=dx:Jtf34kNZhzP;cYeuwXTCPkU;fbfJHSPpUQD;hfdmMSPBgLG&dimension=ou:USER_ORGUNIT_CHILDREN&dimension=pe:THIS_YEAR >> I >> get this view : >> >> [image: Inline image 1] >> >> Yet I would like the Pivot Table to have a layout like this : >> >> [image: Inline image 2] >> >> Regards >> >> >> -- >> Farai Mutero >> >> >> >> >> -- >> Farai Mutero >> >> >> ___ >> 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 >> >> > -- Farai Mutero <><>___ 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
Re: [Dhis2-devs] Web API Pivot Table Layout
So that means I can't pass dynamic uid parameters then? Such a facility would have greatly assisted me to quickly create my html report leveraging off the charts already created and saved as favourites in the Data Visualizer. I would only need to dynamically pass the uid to it and get the relevant result. Now looks like I will have to reconstruct the charts from scratch? On Wed, Jul 24, 2013 at 8:42 PM, Knut Staring wrote: > Sorry, I misread your question a bit. In your case, you can only pass > width and height if you wish to work with stored charts, like this: > http://apps.dhis2.org/demo/api/charts/UlfTKWZWV4u/data?width=300&height=400 > > > On Wed, Jul 24, 2013 at 8:35 PM, Knut Staring wrote: > >> Hi Farai, >> >> If you look in the second table on this page, you will see that there is >> a dynamic parameter called ou: >> http://apps.dhis2.org/demo/api/charts/UlfTKWZWV4u >> >> >> On Wed, Jul 24, 2013 at 8:07 PM, Farai Mutero wrote: >> >>> Thanks Jan for the feedback. Noted. >>> >>> The following querystring parameters *" >>> tableLayout=true&columns=dx;ou&rows=pe"* found in the Web API >>> documentation just provided what I was looking for : >>> >>> api/analytics.html?dimension=dx:fbfJHSPpUQD;cYeuwXTCPkU&dimension=pe:2012Q1;2012Q2&dimension=ou:O6uvpzGd5pu*&tableLayout=true&columns=dx;ou&rows=pe* >>> >>> One more question : If I setup a chart using the Data Visualizer and I >>> have saved it as "favourite", how do I call that chart favourite from my >>> html report passing a dynamic org unit parameter to it? >>> >>> Regards >>> >>> Farai >>> >>> On Wed, Jul 24, 2013 at 7:38 PM, Jan Henrik Øverland < >>> janhenrik.overl...@gmail.com> wrote: >>> >>>> Hi Farai, such layout is produced by the pivot tables client, so you >>>> cannot get it directly from the server. >>>> >>>> >>>> On Wed, Jul 24, 2013 at 6:44 PM, Farai Mutero wrote: >>>> >>>>> Hi Guys >>>>> >>>>> I'm using the Web API to design an html report displaying pivot >>>>> tables. How do I adjust my url call so that the pivot table rendered can >>>>> display in the same way it was designed. >>>>> >>>>> Using the DHIS2 demo for example, if I use the url >>>>> http://apps.dhis2.org/demo/api/analytics.html?dimension=dx:Jtf34kNZhzP;cYeuwXTCPkU;fbfJHSPpUQD;hfdmMSPBgLG&dimension=ou:USER_ORGUNIT_CHILDREN&dimension=pe:THIS_YEAR >>>>> I >>>>> get this view : >>>>> >>>>> [image: Inline image 1] >>>>> >>>>> Yet I would like the Pivot Table to have a layout like this : >>>>> >>>>> [image: Inline image 2] >>>>> >>>>> Regards >>>>> >>>>> >>>>> -- >>>>> Farai Mutero >>>>> >>>>> >>>>> >>>>> >>>>> -- >>>>> Farai Mutero >>>>> >>>>> >>>>> ___ >>>>> 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 >>>>> >>>>> >>>> >>> >>> >>> -- >>> Farai Mutero >>> >>> >>> ___ >>> 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 >>> >>> >> >> >> -- >> Knut Staring >> Dept. of Informatics, University of Oslo >> +4791880522 >> http://dhis2.org >> > > > > -- > Knut Staring > Dept. of Informatics, University of Oslo > +4791880522 > http://dhis2.org > -- Farai Mutero <><>___ 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
[Dhis2-devs] Uploaded Resource Location
Hi Guys If I upload a picture (be a .png or .jpg) as a resource in DHIS2, in which sub folder is it saved in as I need to give that particular folder write permissions in Ubuntu? Regards -- Farai Mutero ___ 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
Re: [Dhis2-devs] Uploaded Resource Location
Thanks Knut. Sorted! On Thu, Jul 25, 2013 at 12:50 PM, Knut Staring wrote: > Hi, I think these get stored in a "documents" folder in your DHIS2_HOME > directory (i.e. next to hibernate.properties) > > > On Thu, Jul 25, 2013 at 12:13 PM, Farai Mutero wrote: > >> Hi Guys >> >> If I upload a picture (be a .png or .jpg) as a resource in DHIS2, in >> which sub folder is it saved in as I need to give that particular folder >> write permissions in Ubuntu? >> >> Regards >> >> -- >> Farai Mutero >> >> >> ___ >> 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 >> >> > > > -- > Knut Staring > Dept. of Informatics, University of Oslo > +4791880522 > http://dhis2.org > -- Farai Mutero ___ 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
[Dhis2-devs] DHIS2 Portal Demo Pages Broken
Hi Guys I see the following pages on the DHIS2 Portal Demo site are broken. What could be the problem? http://apps.dhis2.org/portal/chart.html http://apps.dhis2.org/portal/carousel.html http://apps.dhis2.org/portal/table.html Regards -- Farai Mutero ___ 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
Re: [Dhis2-devs] Web API Pivot Table Layout
Hi Lars Does the ou parameter for the chart resource accept multiple ou_ids or a parent ou ids? The charts I'm seeking to create will in most cases display multiple facilities in a single chart. Is there a work around at the moment that I can use to create a template chart and then pass dynamic parameters to it to generate multiple charts for many facilities? Your assistance would be greatly appreciated as I'm pretty much stuck at the moment. Regards Farai On Thu, Jul 25, 2013 at 7:02 PM, Knut Staring wrote: > That's great - I thought they were not supported for the stored charts, >> because I tried a bit and did not see any difference. Could you provide an >> example URL for the demo? >> > > > On Thu, Jul 25, 2013 at 6:19 PM, Lars Helge Øverland > wrote: > >> Hi Farai, the following parameters are supported for the chart resource: >> >> ou= >> pe= >> date= >> >> >> Need to include this in the docs. >> >> Lars >> >> > > > -- > 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 > > -- Farai Mutero ___ 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
[Dhis2-devs] Data Element Category Combinations
Hi All I've been taking a closer look at the object model for Categories and Category Combinations in Postgresql. While putting together the object model I noticed that the *categoryoptioncombo* table* *is not dependent on any other table in the database, yet contains critical values that are also referenced in the *datavalue* table. My questions is, why *categoryoptioncombos? *Why link a datavalue table row to a *categoryoptioncomboid* instead of a* dataelementcategoryoptionid*? Regards -- Farai Mutero ___ 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
[Dhis2-devs] Error When Creating User via Web API
Hi Guys
I'm trying to create a user in DHIS2 via the Web API *providing a
predefined username and password*, I have prepared a test payload to test
against the DHIS2 Sierra Leone demo, but I'm not winning. I wonder if you
can assist. The payload contents is as follows (all UIDs in the payload are
from the Sierra Leone demo):
curl -X POST -d @user_registration_payload.json "
https://apps.dhis2.org/demo/api/users/"; -H "Content-Type:application/json"
-u admin:district -v
{
"name": "Farai_Mutero",
"displayName": "Farai Mutero",
"surname": "Mutero",
"firstName": "Farai",
"phoneNumber": "+27011022033",
"email":"fa...@hisp.org",
"employer": "HISP",
"userCredentials":
{
"name": "Farai_Mutero",
"password": "FaraiMutero1",
"userRoles": [ {
"id": "Ql6Gew7eaX6"
} ]
},
"organisationUnits": [ {
"id": "ImspTQPwCqd"
} ],
"userGroups": [ {
"id": "Iqfwd3j2qe5"
} ]
}
The response I get is as follows:
* Trying 129.240.64.5...
* Connected to apps.dhis2.org (129.240.64.5) port 443 (#0)
* successfully set certificate verify locations:
* CAfile: C:\Users\Farai
Mut\AppData\Local\Apps\cURL\bin\curl-ca-bundle.crt
CApath: none
* TLSv1.2, TLS handshake, Client hello (1):
* TLSv1.2, TLS handshake, Server hello (2):
* TLSv1.2, TLS handshake, CERT (11):
* TLSv1.2, TLS handshake, Server finished (14):
* TLSv1.2, TLS handshake, Client key exchange (16):
* TLSv1.2, TLS change cipher, Client hello (1):
* TLSv1.2, TLS handshake, Finished (20):
* TLSv1.2, TLS change cipher, Client hello (1):
* TLSv1.2, TLS handshake, Finished (20):
* SSL connection using TLSv1.2 / AES256-SHA256
* Server certificate:
*subject: serialNumber=KoK/SuBIjHQ/RNfXzQHywx35u9n186L/;
OU=GT73263644; OU=See www.rapidssl.com/resources/cps (c)14; OU=Do
main Control Validated - RapidSSL(R); CN=apps.dhis2.org
*start date: 2014-06-15 15:19:59 GMT
*expire date: 2017-06-18 07:45:20 GMT
*subjectAltName: apps.dhis2.org matched
*issuer: C=US; O=GeoTrust, Inc.; CN=RapidSSL CA
*SSL certificate verify ok.
* Server auth using Basic with user 'admin'
> POST /demo/api/users/ HTTP/1.1
> Authorization: Basic YWRtaW46ZGlzdHJpY3Q=
> User-Agent: curl/7.40.0
> Host: apps.dhis2.org
> Accept: */*
> Content-Type:application/json
> Content-Length: 420
>
* upload completely sent off: 420 out of 420 bytes
< HTTP/1.1 500 Internal Server Error
< Date: Wed, 12 Aug 2015 12:37:52 GMT
< X-XSS-Protection: 1; mode=block
< X-Frame-Options: DENY
< X-Content-Type-Options: nosniff
< Set-Cookie: JSESSIONID=3133D6950BF0788C1C0B9CE701F7F005; Path=/demo/;
Secure; HttpOnly
< Content-Type: text/html;charset=utf-8
< Content-Language: en
< Vary: cookie
< Connection: close
< Transfer-Encoding: chunked
<
Apache Tomcat/7.0.63 - Error report<!--H1
{font-family:Tahoma,Arial,sans-serif;color:white;backg
round-color:#525D76;font-size:22px;} H2
{font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:16px;}
H3
{font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:14px;}
BODY {font-family:Tahoma,Arial,sans
-serif;color:black;background-color:white;} B
{font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;}
P {font-
family:Tahoma,Arial,sans-serif;background:white;color:black;font-size:12px;}A
{color : black;}A.name {color : black;}HR {color : #
525D76;}--> HTTP Status 500 - Request processing
failed; nested exception is java.lang.NullPointerExcepti
ontype Exception
reportmessage Request processing failed; nested ex
ception is java.lang.NullPointerExceptiondescription
The server encountered an internal error that prevented
it from fulfilling this request.exception
org.springframework.web.util.NestedServletException: Request proc
essing failed; nested exception is java.lang.NullPointerException
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:979)
org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:869)
javax.servlet.http.HttpServlet.service(HttpServlet.java:650)
org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:843)
javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)
org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:118)
org.springframework.security.web
Re: [Dhis2-devs] Error When Creating User via Web API
Hey Mark
Thank you very much for the advise. Now my payload posts successfully! I
guess a fresh pair of eyes always helps! Thanks Morten for the tip.
Regards
Farai
On Mon, Aug 17, 2015 at 10:37 AM, Morten Olav Hansen
wrote:
> You can also skip name and displayName, as these are auto-generated..
>
> --
> Morten
>
> On Mon, Aug 17, 2015 at 3:29 PM, Mark Polak wrote:
>
>> Hey Farai,
>>
>> So close! :)
>>
>> In the userCredentials object you have set a name property.
>>
>> "name": "Farai_Mutero",
>>
>> But there is no such property on that object. It is the username you want
>> to set. Then your call will work.
>>
>> "username": "Farai_Mutero",
>>
>> I'll paste the whole structure below.
>>
>> Regards,
>>
>> Mark
>>
>> {
>> "name": "Farai_Mutero",
>> "displayName": "Farai Mutero",
>> "surname": "Mutero",
>> "firstName": "Farai",
>> "phoneNumber": "+27011022033",
>> "email":"fa...@hisp.org",
>> "employer": "HISP",
>> "userCredentials":
>> {
>> "username": "Farai_Mutero",
>> "password": "FaraiMutero1",
>> "userRoles": [ {
>> "id": "Ql6Gew7eaX6"
>> } ]
>> },
>> "organisationUnits": [ {
>> "id": "ImspTQPwCqd"
>> } ],
>> "userGroups": [ {
>> "id": "Iqfwd3j2qe5"
>> } ]
>> }
>>
>> On Sun, Aug 16, 2015 at 9:13 AM, Farai Mutero wrote:
>>
>>> Hi Guys
>>>
>>> I'm trying to create a user in DHIS2 via the Web API *providing a
>>> predefined username and password*, I have prepared a test payload to
>>> test against the DHIS2 Sierra Leone demo, but I'm not winning. I wonder if
>>> you can assist. The payload contents is as follows (all UIDs in the payload
>>> are from the Sierra Leone demo):
>>>
>>> curl -X POST -d @user_registration_payload.json "
>>> https://apps.dhis2.org/demo/api/users/"; -H "Content-Type:application/json"
>>> -u admin:district -v
>>>
>>> {
>>> "name": "Farai_Mutero",
>>> "displayName": "Farai Mutero",
>>> "surname": "Mutero",
>>> "firstName": "Farai",
>>> "phoneNumber": "+27011022033",
>>> "email":"fa...@hisp.org",
>>> "employer": "HISP",
>>> "userCredentials":
>>> {
>>>
>>> "name": "Farai_Mutero",
>>> "password": "FaraiMutero1",
>>> "userRoles": [ {
>>> "id": "Ql6Gew7eaX6"
>>> } ]
>>> },
>>> "organisationUnits": [ {
>>> "id": "ImspTQPwCqd"
>>> } ],
>>> "userGroups": [ {
>>> "id": "Iqfwd3j2qe5"
>>> } ]
>>> }
>>>
>>> The response I get is as follows:
>>>
>>> * Trying 129.240.64.5...
>>> * Connected to apps.dhis2.org (129.240.64.5) port 443 (#0)
>>> * successfully set certificate verify locations:
>>> * CAfile: C:\Users\Farai
>>> Mut\AppData\Local\Apps\cURL\bin\curl-ca-bundle.crt
>>> CApath: none
>>> * TLSv1.2, TLS handshake, Client hello (1):
>>> * TLSv1.2, TLS handshake, Server hello (2):
>>> * TLSv1.2, TLS handshake, CERT (11):
>>> * TLSv1.2, TLS handshake, Server finished (14):
>>> * TLSv1.2, TLS handshake, Client key exchange (16):
>>> * TLSv1.2, TLS change cipher, Client hello (1):
>>> * TLSv1.2, TLS handshake, Finished (20):
>>> * TLSv1.2, TLS change cipher, Client hello (1):
>>> * TLSv1.2, TLS handshake, Finished (20):
>>> * SSL connection using TLSv1.2 / AES256-SHA256
>>> * Server certificate:
>>> *subject: serialNumber=KoK/SuBIjHQ/RNfXzQHywx35u9n186L/;
>>> OU=GT73263644; OU=See www.rapidssl.com/resources/cps (c)14; OU=Do
>>> main Control Validated - RapidSSL(R); CN=apps.dhis2.org
>>> *start date: 2014-06-15 15:19:59 GMT
>>
[Dhis2-devs] Recieving DHIS2 Messages In email client of choice
Hi All I'm working on sending and receiving DHIS2 messages via the Web API based on the documentation here: https://www.dhis2.org/doc/snapshot/en/developer/html/ch01s20.html and I would like the message recipients to be able to view received messages in an email client of their choice e.g Microsoft Outlook. The following has already been done: - Email Settings have already been setup on the DHIS2 instance in question and is working correctly. - All DHIS2 Users have a valid email address associated with them, How do I go about doing this as the documentation does not specify? Thanks -- Farai Mutero ___ 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
[Dhis2-devs] Enabling email access for registered users via Web API
Hi All DHIS2 has a very useful User Settings feature that allows one to set whether a user would like to receive email and SMS message notifcations from DHIS2. How do I go about enabling / disabling such settings for a registered user via the Web API? I'm running on DHIS2 2.19. See screenshot below: [image: Inline image 1] Regards -- Farai Mutero ___ 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
Re: [Dhis2-devs] Enabling email access for registered users via Web API
Thanks Dan and Pierre for the advise, much appreciated. On Thu, Nov 12, 2015 at 11:16 PM, Pierre Dane wrote: > if there is no existing API endpoint (which there might be) you could use > a parameterized sqlview calling a function which updates the user table > directly > > > On Thursday, 12 November 2015, Farai Mutero wrote: > >> Hi All >> >> DHIS2 has a very useful User Settings feature that allows one to set >> whether a user would like to receive email and SMS message notifcations >> from DHIS2. >> >> How do I go about enabling / disabling such settings for a registered >> user via the Web API? I'm running on DHIS2 2.19. See screenshot below: >> >> [image: Inline image 1] >> >> Regards >> -- >> Farai Mutero >> >> > > -- > Pierre Dane > > Development Manager > Jembi Health Systems > > -- Farai Mutero ___ 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
[Dhis2-devs] Web-API Related Authorities
Hi Guys Which user security authority or combination or authorities can one use to create a User Role that gives associated users access to the Web API only and nothing else. Regards -- Farai Mutero ___ 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
[Dhis2-devs] DHIS2 Portal Demo Page broken
Hi Guys It seems like DHIS2 Portal page is broken (charts, tables and maps not rendering). Could you kindly assist? https://apps.dhis2.org/portal/ Regards -- Farai Mutero ___ 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
Re: [Dhis2-devs] MERRY CHRISTMAS
Thanks Guy Merry Christmas to you too! Its good to know that at least one person is not hard at work on DHIS2 on Chrstmas. . .lol Regards Farai On Thu, Dec 25, 2014 at 9:01 AM, Guy Ekani wrote: > > *JUST TO WISH A DELIGHTFUL MERRY CHRISTMAS TO ALL DHIS2 USERs AND > DEVELOPERs !* > > = > EKANI Guy > Cameroon > > > > > ___ > 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 > > -- Farai Mutero ___ 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
[Dhis2-devs] Tracked Entity Instance Creation And Enrollment Payload Example
Hi Guys I'm working on capturing some tracker data through the Web-API and I'm using the documentation here https://www.dhis2.org/doc/snapshot/en/developer/html/ch01s37.html The payload example provided in the documentation for creating a TrackedEntityInstance (in Json) is as follows: -- Farai Mutero ___ 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
Re: [Dhis2-devs] Tracked Entity Instance Creation And Enrollment Payload Example
Hi Guys (Thanks Morten for the quick reply, sent out the mail too early)
I’m working on capturing some tracker data (multiple events with
registration) into DHIS2 via the Web API and I’m using the documentation
here : https://www.dhis2.org/doc/snapshot/en/developer/html/ch01s37.html.
The payload example provided in the documentation (In Json) is as follows:
{
"trackedEntity": "tracked-entity-id",
"orgUnit": "org-unit-id",
"attributes": [ {
"attribute": "attribute-id",
"value": "attribute-value"
} ]
}
I’m looking for an xml example of the same? Could you kindly assist?
I’m also looking for an xml example payload for enrolling the newly Tracked
Entity Instance. The Json example provided in the documentation is as
follows:
{
"trackedEntityInstance": "ZRyCnJ1qUXS",
"program": "S8uo8AlvYMz",
"dateOfEnrollment": "2013-09-17",
"dateOfIncident": "2013-09-17"
}
I’m looking for the xml example of the same. Could you kindly assist?
Regards
*Farai Mutero*
Software Development Team
*Health Information Systems Program (HISP) - SA
--*
Email: fa...@hisp.org
Cell: +27 84 554 8849
Skype: fmutero
Website: http://hispsa.org
On Wed, Feb 25, 2015 at 2:07 PM, Morten Olav Hansen
wrote:
> I think you left something out? Also include any errors
>
>
> On Wednesday, February 25, 2015, Farai Mutero wrote:
>
>> Hi Guys
>>
>> I'm working on capturing some tracker data through the Web-API and I'm
>> using the documentation here
>> https://www.dhis2.org/doc/snapshot/en/developer/html/ch01s37.html
>>
>> The payload example provided in the documentation for creating a
>> TrackedEntityInstance (in Json) is as follows:
>>
>>
>> --
>> Farai Mutero
>>
>>
>
> --
> --
> Morten
>
>
--
Farai Mutero
___
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
Re: [Dhis2-devs] Metadata filtering in API no longer working?
Thanks Knut for raising this question. Now I no longer have to hard code
the root OU UID so as to render the full OU hierarchy in my apps.
On Wed, Jun 11, 2014 at 9:07 AM, Knut Staring wrote:
> Thanks!
>
> I now did this, which also works:
>
> var url = dhis_api_base
> +'organisationUnits.json?userDataViewFallback=true';
> $.getJSON( url, function( json ) {
> console.dir(json.organisationUnits[0].name + ' has UID ' +
> json.organisationUnits[0].id);
> });
>
>
> On Wed, Jun 11, 2014 at 9:03 AM, Morten Olav Hansen
> wrote:
>
>>
>> On Wed, Jun 11, 2014 at 8:50 AM, Knut Staring wrote:
>>
>>> $.getJSON( url, function( json ) {
>>> console.dir(json);
>>> });
>>>
>>
>> $.ajax({
>> url: URL,
>> dataType: 'json'
>> }).done(function(data) {
>> $.each(data.organisationUnits, function(idx) {
>> console.log("root" + idx + ": " + this.id);
>> })
>> });
>>
>> Something like that could work, it returns an array of orgUnits
>>
>> --
>> Morten
>>
>
>
>
> --
> 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
>
>
--
Farai Mutero
___
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
[Dhis2-devs] Adding new OU via Web API
Hi Guys I'm working on an (web-api driven) Javascript app which should perform the following tasks: 1) Clone an existing OrgUnit 2) Create a new OU based on the cloned one, so as to automatically inherit important shared attributes like OU parent, organisationUnitGroups and dataSets. How do I go about it or can someone please point me to the right documention. N.B: I have the option of setting up a Curl driven server-based web service to facilitate the development of this functionality. Regards -- Farai Mutero ___ 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
[Dhis2-devs] Displaying tomcat logs in DHIS2
Hi Guys How does one pull or display tomcat log contents via the Web API? Regards -- Farai Mutero ___ 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
Re: [Dhis2-devs] Displaying tomcat logs in DHIS2
Hi Jason Great, thanks for the link. Will check it out. Regards Farai On Mon, Jun 23, 2014 at 4:29 PM, Jason Pickering < jason.p.picker...@gmail.com> wrote: > Hi Farai, > This is not supported from the DHIS2 WebAPI. The Tomcat manager or PSI > Probe (https://code.google.com/p/psi-probe/) might give you what you need > however. > > Regards, > Jason > > > > > On Mon, Jun 23, 2014 at 4:10 PM, Farai Mutero wrote: > >> Hi Guys >> >> How does one pull or display tomcat log contents via the Web API? >> >> Regards >> >> -- >> Farai Mutero >> >> >> ___ >> 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 >> >> > -- Farai Mutero ___ 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
Re: [Dhis2-devs] [Dhis2-users] API shifted from HTML to XML?
>>>>>> Is this intentional? >>>>>>>> >>>>>>>> -- >>>>>>>> Knut Staring >>>>>>>> Dept. of Informatics, University of Oslo >>>>>>>> +4791880522 >>>>>>>> http://dhis2.org >>>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> -- >>>>>>> Knut Staring >>>>>>> Dept. of Informatics, University of Oslo >>>>>>> +4791880522 >>>>>>> http://dhis2.org >>>>>>> >>>>>>> ___ >>>>>>> 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-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-users >> Post to : dhis2-us...@lists.launchpad.net >> Unsubscribe : https://launchpad.net/~dhis2-users >> More help : https://help.launchpad.net/ListHelp >> >> > > ___ > 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 > > -- Farai Mutero ___ 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
Re: [Dhis2-devs] [Dhis2-users] API shifted from HTML to XML?
Ok, great stuff. Thanks Morten! On Mon, Jul 14, 2014 at 8:07 PM, Morten Olav Hansen wrote: > Accessing the API is just as simple as before, we never defaulted to a > JSON browsable API before. What we did, is to remove the old (and outdated) > HTML rendering. For app developer, there should be no difference (unless > you were parsing the HTML, but I hope you didn't). JSON is just as > supported as before, using either an extension (.json) or using the accept > header (application/json). For your app, there should be no difference. > > For browsing, we will provide an app shortly after release. > > -- > Morten > > > On Tue, Jul 15, 2014 at 12:23 AM, Farai Mutero wrote: > >> Hi Guys >> >> I must say, seconding what Knut has pointed out, I'm a bit worried by >> this development especially from a rapid app development perspective. I for >> one, am totally reliant on the json Web-API resources and interact with >> them on a day-to-day basis. So if accessing web-api *json* resources is >> becoming increasingly harder, what's the alternative for app developers? >> I'm sorry guys for being ridiculous, but please help me out? >> >> Regards >> >> Farai >> >> >> On Mon, Jul 14, 2014 at 10:36 AM, Bob Jolliffe >> wrote: >> >>> Much though I have to love json, this does seem to be a case where >>> maintaining an xml stylesheet is the cleanest separation of form and >>> content. >>> >>> What about adding an xml processing instruction to the xml like: >>> >>> >> href="/dxf2html.xsl"?> >>> ... >>> >>> >>> This will have no effect on consuming the xml normally (except for >>> making it one line longer) but will allow a browser to render it nicely. >>> >>> Of course dxf2html.xsl would have to be maintained. It could be >>> provided by an app. Or the whole url could be just a system setting. Then >>> if the setting exists the processing instruction is emitted, if not then >>> its not. Or there is a basic functionality which can be overridden by an >>> app ... >>> >>> >>> On 14 July 2014 05:19, Morten Olav Hansen wrote: >>> >>>> Of course we could do that, but that would take away part of the >>>> restfulness of the API. I don't think we should change the way our links >>>> works, just because a plugin supports making http://* into real links. >>>> I understand that it is a bit harder to browse the API right now, but that >>>> should be fixed soon. We don't have to wait for 2.17 to be released for >>>> this, it could easily live as an external app, it shouldn't take long to >>>> develop something like that. >>>> >>>> -- >>>> Morten >>>> >>>> >>>> On Mon, Jul 14, 2014 at 11:06 AM, Knut Staring >>>> wrote: >>>> >>>>> So you can't just add .json to these links? >>>>> >>>>> >>>>> On Mon, Jul 14, 2014 at 6:04 AM, Morten Olav Hansen < >>>>> morte...@gmail.com> wrote: >>>>> >>>>>> We do expose JSON as the default, if you send header "Accept: */*" >>>>>> that would return a JSON result. Problem is that the browser is usually >>>>>> sending something like "Accept: text/html, application/xml, ." so >>>>>> since >>>>>> it has no match for text/html, it will go to application/xml. >>>>>> >>>>>> We are hoping to provide an API browser app for 2.17. >>>>>> >>>>>> -- >>>>>> Morten >>>>>> >>>>>> >>>>>> On Mon, Jul 14, 2014 at 7:25 AM, Knut Staring >>>>>> wrote: >>>>>> >>>>>>> A shortcut to making an app would be if we exposed .json by default >>>>>>> instead of XML: >>>>>>> >>>>>>> https://apps.dhis2.org/dev/api/resources.json has nicely clickable >>>>>>> links if the user has something like JSONView installed: >>>>>>> >>>>>>> https://chrome.google.com/webstore/detail/jsonview/chklaanhfefbnpoihckbnefhakgolnmc >>>>>>> >>>>>>> Knut >>>>>>> >>>>>>> >>>>>>> On Sun, Jul 13, 2014 at 8:18 PM, Lars Helge Øverland < >>&
[Dhis2-devs] Disabling validation in attributes
Hi Guys Version:2.15Build revision:15175Build date:2014-06-26 02:05 Is it possible to disable field validation in Data Element and Indicator attributes? We are just having a problem that we cant manually edit some dataelements because of the validation kicks-in even on fields what we dont have values at hand. See screenshot below: [image: Inline image 1] -- Farai Mutero ___ 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
Re: [Dhis2-devs] Developer manual
Hi Jason This a most welcome development which will definitely revolutionize Web API driven web development. One issue which I recommend you to note would be: There have been so many changes in the Web API from 2.14 to 2.16 from the perspective of building apps on top of dhis2 such that there is always the risk of apps breaking when the underlying dhis2 backend is upgraded. So not sure how easy it will be to deal with such challenges in the upcoming manual. Maybe some tips and tricks (relevant to the dhis2 version in use) will suffice. Hi there. Based on some good feedback last week during the Oslo DHIS2 Academy, I have made a first cut of a developer manual. As I see it, this basically involves slicing out all of the stuff really aimed more at developers (and in some cases implementers) and less so, users. The chapter on the WebAPI is being constantly expanded by the core developers, but in many cases, far exceeds the level of information required by most users. Some of the developers/implementers which I spoke with last week wanted more information in the developers manual. So, I think moving the really technical stuff to a dedicated developer manual would be a good idea, and allow even more detailed technical stuff to be written, without necessarily addressing the needs of the users. I have , for the time being, left the sections (Technical architecture, Web API, Apps, and the appendix on R) in the main manual, but I think (depending on feedback from the community) that we can slice these out of the main user manual, and put them in a dedicated developer document. Thoughts? Regards, Jason ___ 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
[Dhis2-devs] Clearing DHIS2 cache via the Web API
Hi Guys Is there any way to clear the DHIS2 cache using the Web API? Regards -- Farai Mutero ___ 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
Re: [Dhis2-devs] Clearing DHIS2 cache via the Web API
Thanks a lot Knut. Much appreciated! On Sun, Oct 5, 2014 at 5:43 PM, Knut Staring wrote: > Not the same thing of course, but wanted to also mention this new tutorial: > https://www.dhis2.org/tutorials/how-to-really-clear-browser-cache > > Knut > > On Sun, Oct 5, 2014 at 5:41 PM, Knut Staring wrote: > >> https://www.dhis2.org/doc/snapshot/en/user/html/ch32s25.html >> >> On Sun, Oct 5, 2014 at 5:08 PM, Farai Mutero wrote: >> >>> Hi Guys >>> >>> Is there any way to clear the DHIS2 cache using the Web API? >>> >>> Regards >>> >>> -- >>> Farai Mutero >>> >>> >>> ___ >>> 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 >>> >>> >> >> >> -- >> Knut Staring >> Dept. of Informatics, University of Oslo >> +4791880522 >> Skype: knutstar >> http://dhis2.org >> > > > > -- > Knut Staring > Dept. of Informatics, University of Oslo > +4791880522 > Skype: knutstar > http://dhis2.org > -- Farai Mutero ___ 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
