Re: [Dhis2-users] [Dhis2-devs] TAB IN CUSTOM FORMS

2017-12-15 Thread David Muturi
Hi Stanley,
Here is a script as well to create custom tabs.


   jQuery(document).ready( function() {

  jQuery( '#tabs' ).tabs({ collapsible : true });

});




Page 1 
Page 2
Page 3



--HTML CODE--


--HTML CODE--


--HTML CODE--



rgds
David

2017-12-14 5:20 GMT+03:00 Stanley Kalyati :
> Hi John,
>
> Thank you for your responses.You really help.
>
> Now,how about collapsing sections in a custom form? How do I go about it?
>
> Thank you all once again
>
> On Dec 8, 2017 10:31 AM, "John Mukulu"  wrote:
>>
>> Hello Stanley,
>> There's a section form feature that supports tabs horizontal or vertical.
>>
>> But if it doesn't suit you, you can write your html form and use jQuery
>> tab feature so it's rendered as custom form.
>>
>> See this link
>> https://jqueryui.com/tabs/
>>
>>
>> John Francis Mukulu
>> Lead Developer, HISPTZ
>> University of Dar es salaam
>> http://hisptanzania.org/
>>
>> On Dec 8, 2017 8:38 AM, "Stanley Kalyati"  wrote:
>>>
>>> Hi all,
>>>
>>> Anyone to share how one can create custom froms with tubs?
>>>
>>> Thanks
>>>
>>> ___
>>> 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
>>>
>
> ___
> 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


[Dhis2-users] [DHIS2 Android] New Release of Dashboard Android App

2017-12-15 Thread Android Team
Dear DHIS2 Community,

We are releasing today a new version of the *Dashboard Android App*.
This version is compatible with* 2.28, 2.27 *and *2.26* and comes with the
following improvements and bugs fixed:

New features:

- 2.28 servers compatibility (https://jira.dhis2.org/browse/ACA-145)
- Provide feedback when attempting to log in offline (
https://jira.dhis2.org/browse/ACA-122)
- Show a message when trying to see a report table offline
- Show username+password in about this app section
- Allow the BB dev version and GPlay production versions coexist on the
same device

Bugfixing:

- Dashboard items disappear on screen rotation (https://jira.dhis2.org/
browse/ACA-121)
- Dashboard app: unsupported map types (https://jira.dhis2.org/
browse/ACA-114)
- Android Dashboard App - Event report tables, order of elements and
aggregate data charts (https://jira.dhis2.org/browse/ACA-61)
- Remotely added dashboard elements doesn't sync
- Remotely deleted dashboard elements doesn't sync
- When trying to login to a wrong URL, it shows credentials failure
- Crash introducing new comments to interpretations
- Refresh always taking user to the first tab
- New dashboards not ordered alphabetically like on the server
- Data being kept between different installations of the app (login
remembered)
- Progress bar stops while data is still downloading
- Rotation while on a report table shows a progress bar forever

You can install it through Google Play (Dashboard
)
or download the apk from Github (Dashboard
).

Following this link , you will find documentation
with detailed information on the functionalities included in the App and
how they behave compare to the Web. (We recommend to download the PDF file,
internal links do not work if you open them online).This document is a tool
for implementers who need to understand if the App covers their needs and
respond to their configurations of DHIS2 in the web.

Remember that all this information is also available in the Android Section
of the DHIS2 web site !

Big thanks to the teams behind the development, testing and documentation.

Best,
Marta


*Please remember to create a Jira Issue if you find a bug or you want to
propose a new functionality!*
*[Project: Maintenance of Android Apps | Component: Dashboard]*
___
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] In DHIS 2.27 Issues with deleting organisation unit

2017-12-15 Thread Jason Pickering
Hi Joseph
Thanks for sharing the script.

One thing to watch out for is the reordering of components of analytical
objects. You can see this here

in
the script I linked to in the earlier mail. If you delete an organisation
unit from say a chart, without reordering the other organisation units, it
will lead to an error when trying to load that object after the
organisation unit has been deleted.

Regards,
Jason


On Fri, Dec 15, 2017 at 9:39 AM, Joseph Chingalo 
wrote:

> Hello Jhansi Reddy Karee and All,
>
> I have work around for this by creating  SQL view  procedure for deleting
> an organisation unit in dhis 2 instance .
>
> Just kindly find attached SQL file with all procedure functions for
> delete an Organisation unit.
>
> *Steps on how to use this*
>
> *Step 1:*
>
> All you need to do edit variable for storage of all backup files as csv in
> case you want to rollback all deleted data.
> Below is variable to changes on line number 6 with path to directory for
> backup of deleted data, for instance on my case is "/tmp/data" but it must
> have readable and writable.
> " temp_dir VARCHAR := '/tmp/data'; "
>
> *Step 2:*
>
> Apply this sql file into your database
>
> *Step 3:*
>
> Create sql view and excute it.
> For instance if zs9X8YYBOnK is uid for organisation unit to be deleted
> then SQL view will be
> SELECT deleteOrganisationUnit('zs9X8YYBOnK');
>
> *Hopes might help you.*
>
>
>
>
> On Fri, Dec 15, 2017 at 10:16 AM, Jhansi Reddy Karee <
> jhans...@thoughtworks.com> wrote:
>
>> Thanks Jason,
>>
>> Since we just have data values for the organisation units (which should
>> be deleted), we are able to remove them after clearing the data associated
>> with them using /api/maintenance/dataPruning/organisationUnits API.
>>
>> Thanks,
>> Jhansi
>>
>> On Fri, Dec 15, 2017 at 11:51 AM, Jason Pickering <
>> jason.p.picker...@gmail.com> wrote:
>>
>>> It might work for you, but I am not 100% sure if that API endpoint will
>>> clear out everything. As you can  see from the SQL function, orgunits may
>>> also have other dependencies, like pivots, charts, user associations, etc.
>>> The deletion handler for orgunits may refuse to remove it,  if the object
>>> is associated with other objects.
>>>
>>> It might work in your case, but may not.
>>>
>>> Good luck,
>>> Jason
>>>
>>>
>>> On Fri, Dec 15, 2017 at 7:14 AM, Jhansi Reddy Karee <
>>> jhans...@thoughtworks.com> wrote:
>>>
 Thanks for the quick reply Jason,

 In DHIS documentation
 ,
 we came across a WEB API which can clear all the data of the organisation
 unit.

 /api/26/maintenance/dataPruning/organisationUnits/

 API Details: Data pruning will remove complete data set registrations,
 data approvals, data value audits and data values, in this case of an
 organisation unit.

 We are expecting that this API will clear all the data of the given
 organisation unit and any data/approvals of its parent organisation units
 will be untouched. Is our expectation correct?

 Do you see any problem with deleting data for the organisation unit
 using this API.

 Thanks,
 Jhansi

 On Thu, Dec 14, 2017 at 9:12 PM, Jason Pickering <
 jason.p.picker...@gmail.com> wrote:

> Hi Jhansi,
> You will also need to get rid of the data in the data value audit
> table.
>
> Here is an SQL function which might work for you.
>
> https://github.com/dhis2/dhis2-utils/blob/master/resources/s
> ql/delete_orgunit_with_data.sql
>
> Regards,
> Jason
>
>
> On Thu, Dec 14, 2017 at 2:49 PM, Jhansi Reddy Karee <
> jhans...@thoughtworks.com> wrote:
>
>> Hello Team,
>>
>>
>> In DHIS 2.27, we are not able to delete an organisation unit after
>> deleting all the data associated to it.
>>
>>
>> Following are the steps we have followed to do this:
>>
>>-
>>
>>Delete all the data associated to the organisation unit
>>-
>>
>>In Data administration app, under maintenance, we have performed
>>maintenance over “Permanently remove soft deleted data values”.
>>-
>>
>>Tried deleting the organisation unit. But, we are getting the
>>following error: Could not delete due to association with another 
>> object:
>>DataValueAudit
>>
>>
>> Please let us know if we have missed anything.
>>
>>
>> Thanks,
>>
>> Jhansi
>>
>>
>>
>> ___
>> 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

Re: [Dhis2-users] GML import doesn't work anymore - 2.27

2017-12-15 Thread Ramón José Jiménez Pomareta
Hello Morten !

Yes! Thank you for your help! I tested with the version
2.27   0ccc3522017-12-13 06:43

and it's working fine ! Thank you again !

2017-12-12 6:16 GMT+01:00 Morten Olav Hansen :

> I think this has been fixed in all versions down to 2.27, could you
> download a fresh WAR file and try again?
>
> --
> Morten Olav Hansen
> Senior Engineer, DHIS 2
> University of Oslo
> http://www.dhis2.org
>
> On Mon, Dec 11, 2017 at 11:24 PM, Ramón José Jiménez Pomareta <
> dh...@pomareta.ch> wrote:
>
>> Update: It worked on
>> Version:2.27Build revision:ebc3a16Build date:2017-07-28 06:25
>>
>> 2017-11-21 11:44 GMT+01:00 Ramón José Jiménez Pomareta > >:
>>
>>> Ok, I reported it here, maybe if you have the same issue, you can add
>>> 2.28 to the affected versions.
>>> https://jira.dhis2.org/browse/DHIS2-2521
>>>
>>> Best,
>>>
>>> 2017-11-21 10:16 GMT+01:00 Em Le Hong :
>>>
 Hi,

 I think it's a bug, last time I tried on 2.28 and it also didn't work.
 I guess we need to report to Jira
 

 Regards,

 On Tue, Nov 21, 2017 at 4:11 PM, Ramón José Jiménez Pomareta <
 dh...@pomareta.ch> wrote:

> Here's the log, sorry
>
> 2017-11-21 10:10 GMT+01:00 Ramón José Jiménez Pomareta <
> dh...@pomareta.ch>:
>
>> Hello,
>>
>> I am trying to import a GML file but the server rises some warnings
>> and one error.
>>
>>
>>
>> *Warning org.apache.xerces.jaxp.SAXParserImpl$JAXPSAXParser Property
>> 'httpwww.oracle.comxmljaxppropertiesentityExpansionLimit' is not
>> recognized.Compiler warningsWARNING 'org.apache.xerces.jaxp.SAXParserImpl
>> Property 'httpjavax.xml.XMLConstantspropertyaccessExternalDTD' is not
>> recognized.'*
>>
>>
>>
>> *ERROR 2017-11-21 095828,255 GML import failed
>> (DefaultGmlImportService.java [taskScheduler-12])java.lang.Exception GML
>> import failed during pre-processing stage.The user reecives: GML import
>> failed: GML import failed during pre-processing stage.*
>>
>> I've tried to import other GML files which worked in the past (before
>> upgrading to 2.27 774be18 2017.11.02) and they don't work neither.
>> I've tried in different instances with the same version of DHIS2.
>> (But different OS, Java...)
>>
>> Do you have any idea ?
>>
>> Thank you so much in advance !
>>
>> Ramón Jiménez Pomareta.
>>
>> PS: JIRA ticket: https://jira.dhis2.org/browse/DHIS2-2521
>>
>>
>>
>
> ___
> 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
>
>


 --
 *Em Le Hong*
 DHIS2 Implementation| *HISP Vietnam *
 em.hispviet...@gmail.com | *Skype:* em.hispviet...@gmail.com






>>>
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to : dhis2-users@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
___
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] Pharmaceutical supply chain references requested

2017-12-15 Thread Ferdie Botha
Hi everyone, I met someone interested in the DHIS2 concept applied within the 
pharmaceutical supply chain management environment (part of a global company 
having challenges within under-resourced enviroments). 

Anyone willing to share showcases?

Ferdie 

Sent from my iPhone (Please excuse any typos)
-- 


*This message and any attachments are subject to a disclaimer published at 
http://www.hisp.org/policies.html#comms_disclaimer 
.  Please read the 
disclaimer before opening any attachment or taking any other action in 
terms of this electronic transmission.  If you cannot access the 
disclaimer, kindly send an email to disclai...@hisp.org 
 and a copy will be provided to you. By replying to 
this e-mail or opening any attachment you agree to be bound by the 
provisions of the disclaimer.*

___
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] In DHIS 2.27 Issues with deleting organisation unit

2017-12-15 Thread Joseph Chingalo
Hello Jhansi Reddy Karee and All,

I have work around for this by creating  SQL view  procedure for deleting
an organisation unit in dhis 2 instance .

Just kindly find attached SQL file with all procedure functions for delete
an Organisation unit.

*Steps on how to use this*

*Step 1:*

All you need to do edit variable for storage of all backup files as csv in
case you want to rollback all deleted data.
Below is variable to changes on line number 6 with path to directory for
backup of deleted data, for instance on my case is "/tmp/data" but it must
have readable and writable.
" temp_dir VARCHAR := '/tmp/data'; "

*Step 2:*

Apply this sql file into your database

*Step 3:*

Create sql view and excute it.
For instance if zs9X8YYBOnK is uid for organisation unit to be deleted then
SQL view will be
SELECT deleteOrganisationUnit('zs9X8YYBOnK');

*Hopes might help you.*




On Fri, Dec 15, 2017 at 10:16 AM, Jhansi Reddy Karee <
jhans...@thoughtworks.com> wrote:

> Thanks Jason,
>
> Since we just have data values for the organisation units (which should be
> deleted), we are able to remove them after clearing the data associated
> with them using /api/maintenance/dataPruning/organisationUnits API.
>
> Thanks,
> Jhansi
>
> On Fri, Dec 15, 2017 at 11:51 AM, Jason Pickering <
> jason.p.picker...@gmail.com> wrote:
>
>> It might work for you, but I am not 100% sure if that API endpoint will
>> clear out everything. As you can  see from the SQL function, orgunits may
>> also have other dependencies, like pivots, charts, user associations, etc.
>> The deletion handler for orgunits may refuse to remove it,  if the object
>> is associated with other objects.
>>
>> It might work in your case, but may not.
>>
>> Good luck,
>> Jason
>>
>>
>> On Fri, Dec 15, 2017 at 7:14 AM, Jhansi Reddy Karee <
>> jhans...@thoughtworks.com> wrote:
>>
>>> Thanks for the quick reply Jason,
>>>
>>> In DHIS documentation
>>> ,
>>> we came across a WEB API which can clear all the data of the organisation
>>> unit.
>>>
>>> /api/26/maintenance/dataPruning/organisationUnits/
>>>
>>> API Details: Data pruning will remove complete data set registrations,
>>> data approvals, data value audits and data values, in this case of an
>>> organisation unit.
>>>
>>> We are expecting that this API will clear all the data of the given
>>> organisation unit and any data/approvals of its parent organisation units
>>> will be untouched. Is our expectation correct?
>>>
>>> Do you see any problem with deleting data for the organisation unit
>>> using this API.
>>>
>>> Thanks,
>>> Jhansi
>>>
>>> On Thu, Dec 14, 2017 at 9:12 PM, Jason Pickering <
>>> jason.p.picker...@gmail.com> wrote:
>>>
 Hi Jhansi,
 You will also need to get rid of the data in the data value audit
 table.

 Here is an SQL function which might work for you.

 https://github.com/dhis2/dhis2-utils/blob/master/resources/s
 ql/delete_orgunit_with_data.sql

 Regards,
 Jason


 On Thu, Dec 14, 2017 at 2:49 PM, Jhansi Reddy Karee <
 jhans...@thoughtworks.com> wrote:

> Hello Team,
>
>
> In DHIS 2.27, we are not able to delete an organisation unit after
> deleting all the data associated to it.
>
>
> Following are the steps we have followed to do this:
>
>-
>
>Delete all the data associated to the organisation unit
>-
>
>In Data administration app, under maintenance, we have performed
>maintenance over “Permanently remove soft deleted data values”.
>-
>
>Tried deleting the organisation unit. But, we are getting the
>following error: Could not delete due to association with another 
> object:
>DataValueAudit
>
>
> Please let us know if we have missed anything.
>
>
> Thanks,
>
> Jhansi
>
>
>
> ___
> 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 <076-414%2070%2049>

>>>
>>>
>>
>>
>> --
>> Jason P. Pickering
>> email: jason.p.picker...@gmail.com
>> tel:+46764147049 <+46%2076%20414%2070%2049>
>>
>
>
> ___
> 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
>
>


-- 


*Joseph Philibert Chingalo*
*+255 687 168 637*
*+255 718 922 311*
*Skype : josephchingalowebsite : http://hisptanzania.org/
*


organsaitionUnitApp.sql
Description: application/sql