dhis2-users team mailing list archive

[Kevin Bolger <kevin.bolger@xxxxxxxxx>]

Hi Folks,

I have an eventChart that I have saved as a favorite and added to my
dashboard.
The chart uses a daily period that I would like to update each night so
that the chart always showing the current (today's) data.

I'm using a python script to get the current chart's json
(/api/eventCharts/QkBhkdqb8FU.json?fields=:owner), I then update the period
value and upload (with a 'put' request) the updated json payload back via
(/api/eventCharts/QkBhkdqb8FU.json)

The payload I put seems to have the correct data and structure, the put
request response and content looks good:
<Response [200]>
{"httpStatus":"OK","httpStatusCode":200,"status":"OK","response":{"responseType"
:"ObjectReport","uid":"QkBhkdqb8FU","klass":"org.hisp.dhis.eventchart.EventChart
"}}

When I refresh the "/api/eventCharts/QkBhkdqb8FU.json?fields=:owner" link
many of the necessary fields to define the chart selections seem to have
been overwritten or the values lost.

I tried to use the request.paste() function in python but I get the
following error:
<Response [500]>
{"httpStatus":"Internal Server
Error","httpStatusCode":500,"status":"ERROR","message":"object references
an unsaved transient instance - save the transient instance before
flushing: org.hisp.dhis.program.Program"}

Below is the JSON from the original get, then the updated payload that I
'put' and finally what the server shows after the put.

*Original: (periods is set to "20170130"*
{"lastUpdated":"2017-01-31T15:32:25.206","id":"QkBhkdqb8FU","created":"2017-01-31T15:32:25.206","name":"MLC
Family Planning Months of Stock on
Hand","showData":true,"baseLineValue":6.0,"publicAccess":"rw------","userOrganisationUnitChildren":false,"type":"BAR","hideEmptyRows":false,"userOrganisationUnit":false,"hideNaData":false,"regressionType":"NONE","completedOnly":false,"sortOrder":1,"collapseDataDimensions":false,"aggregationType":"SUM","userOrganisationUnitGrandChildren":false,"hideSubtitle":false,"outputType":"EVENT","hideLegend":false,"externalAccess":false,"targetLineLabel":"Max","targetLineValue":12.0,"baseLineLabel":"Min","hideTitle":false,"rangeAxisMaxValue":40.0,"program":{"id":"YScaWpjOOnI"},"dataElementValueDimension":{"id":"XDtOsbxXNZq"},"relativePeriods":{"thisYear":false,"quartersLastYear":false,"last52Weeks":false,"thisWeek":false,"lastMonth":false,"monthsThisYear":false,"last2SixMonths":false,"thisQuarter":false,"last12Months":false,"last5FinancialYears":false,"thisSixMonth":false,"lastQuarter":false,"thisFinancialYear":false,"last4Weeks":false,"last3Months":false,"thisMonth":false,"last5Years":false,"last6BiMonths":false,"lastFinancialYear":false,"last6Months":false,"quartersThisYear":false,"monthsLastYear":false,"lastWeek":false,"thisBimonth":false,"lastBimonth":false,"lastSixMonth":false,"lastYear":false,"last12Weeks":false,"last4Quarters":false},"programStage":{"id":"VgrIh62C2gl"},"user":{"id":"RFlgWX4JP8J"},"attributeDimensions":[],"translations":[],"filterDimensions":["ou"],"organisationUnitGroups":[],"itemOrganisationUnitGroups":[],"userGroupAccesses":[],"programIndicatorDimensions":[],"columnDimensions":["pe"],"organisationUnitLevels":[],"dataElementDimensions":[{"dataElement":{"id":"tnY9kPc9jTh"}}],"periods":[{"id":"20170130"}],"organisationUnits":[{"id":"mS1oRZYQ41i"}],"rowDimensions":["tnY9kPc9jTh"]}

*Updated JSON with periods set to "20170131" - as desired*
{"hideLegend": false, "baseLineLabel": "Min", "filterDimensions": ["ou"],
"outputType": "EVENT", "hideEmptyRows": false, "periods": [{"id":
"20170131"}], "userGroupAccesses": [], "completedOnly": false,
"programIndicatorDimensions": [], "attributeDimensions": [], "id":
"QkBhkdqb8FU", "userOrganisationUnitChildren": false, "columnDimensions":
["pe"], "rowDimensions": ["tnY9kPc9jTh"], "program": {"id": "YScaWpjOOnI"},
"sortOrder": 1, "targetLineLabel": "Max", "type": "BAR", "hideSubtitle":
false, "organisationUnitGroups": [], "publicAccess": "rw------",
"translations": [], "userOrganisationUnit": false, "lastUpdated":
"2017-01-31T15:32:25.206", "organisationUnitLevels": [], "hideNaData":
false, "userOrganisationUnitGrandChildren": false,
"dataElementValueDimension": {"id": "XDtOsbxXNZq"}, "baseLineValue": 6.0,
"rangeAxisMaxValue": 40.0, "dataElementDimensions": [{"dataElement": {"id":
"tnY9kPc9jTh"}}], "showData": true, "targetLineValue": 12.0,
"regressionType": "NONE", "programStage": {"id": "VgrIh62C2gl"}, "name":
"MLC Family Planning Months of Stock on Hand", "created":
"2017-01-31T15:32:25.206", "externalAccess": false, "hideTitle": false,
"itemOrganisationUnitGroups": [], "relativePeriods": {"lastMonth": false,
"thisMonth": false, "last6BiMonths": false, "last5FinancialYears": false,
"lastYear": false, "thisYear": false, "thisWeek": false, "monthsLastYear":
false, "last4Weeks": false, "quartersThisYear": false, "lastBimonth":
false, "last2SixMonths": false, "last12Months": false, "lastQuarter":
false, "last52Weeks": false, "lastWeek": false, "lastSixMonth": false,
"thisSixMonth": false, "thisFinancialYear": false, "last4Quarters": false,
"lastFinancialYear": false, "thisBimonth": false, "last12Weeks": false,
"last6Months": false, "last5Years": false, "quartersLastYear": false,
"thisQuarter": false, "last3Months": false, "monthsThisYear": false},
"organisationUnits": [{"id": "mS1oRZYQ41i"}], "aggregationType": "SUM",
"collapseDataDimensions": false, "user": {"id": "RFlgWX4JP8J"}}

*JSON on the server after the request.put() *
{"lastUpdated":"2017-01-31T15:50:29.694","id":"QkBhkdqb8FU","created":"2017-01-31T15:32:25.206","name":"MLC
Family Planning Months of Stock on
Hand","showData":true,"baseLineValue":6.0,"publicAccess":"rw------","userOrganisationUnitChildren":false,"type":"BAR","hideEmptyRows":false,"userOrganisationUnit":false,"hideNaData":false,"regressionType":"NONE","completedOnly":false,"sortOrder":1,"collapseDataDimensions":false,"aggregationType":"SUM","userOrganisationUnitGrandChildren":false,"hideSubtitle":false,"outputType":"EVENT","hideLegend":false,"externalAccess":false,"targetLineLabel":"Max","targetLineValue":12.0,"baseLineLabel":"Min","hideTitle":false,"rangeAxisMaxValue":40.0,"program":{"id":"YScaWpjOOnI"},"dataElementValueDimension":{"id":"XDtOsbxXNZq"},"programStage":{"id":"VgrIh62C2gl"},"user":{"id":"RFlgWX4JP8J"},"attributeDimensions":[],"translations":[],"filterDimensions":[],"organisationUnitGroups":[],"itemOrganisationUnitGroups":[],"userGroupAccesses":[],"programIndicatorDimensions":[],"columnDimensions":[],"organisationUnitLevels":[],"dataElementDimensions":[],"periods":[],"organisationUnits":[],"rowDimensions":[]}