[Dhis2-devs] printing report to .doc

is there a way that i can edit the print button to be able to print word docs in standard html report -- developer_lusaka_systems ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://laun

[Dhis2-devs] Data set combination

Is it possible to combine under a single Data set a dataElement with a combination Sex(male-female) and a dataElement with default combination? -- developer_lusaka_systems ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@list

[Dhis2-devs] Tracker capture continuously loading meta data

am trying to load a new tracker capture but its just continuously loading without displaying anything. Am using 2.24. What could cause this -- developer ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Uns

[Dhis2-devs] (no subject)

hello someone have an idea on how to convert data Elements which are created as aggregates to tracker using sql at once.. please need your help -- developer_lusaka_systems ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@li

[Dhis2-devs] data entry form no complete button

yebo i need help my custom design data entry form has no complete, incomplete and validate buttons. any help -- developer_lusaka_systems ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : http

[Dhis2-devs] Apk

I downloaded an event capture android app after installing and trying to login I receive this error: Error .java.net.ssl.SSLprotocolExeception: SSL handshake aborted: ssl=0x6cfd6148: failure in SSL library, usually a protocol error Error: 140770FC:SSL routines: SSL23_GET_SERVER_HELLO: unknown prot

[Dhis2-devs] Reset to original org unit

I accidentally gave admin admin user, user by organisation specific districts removed it from parent org. How do i set it back to have parent org units? ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsub

[Dhis2-devs] connecting to play.dhis2.org fails using event capture

which address do i use to connect to the play.dhis2.org/dev using event capture apk app. is it possible? -- developer_lusaka_systems ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://l

[Dhis2-devs] Error 503

*HTTP ERROR*: problem accessin/.reason: service unavailable How do i solve this one when am using dhis2 live? -- developer_lusaka_systems ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : ht

[Dhis2-devs] conflict

when capturing data using event capture android app i get that error. where am i going wrong -- developer_lusaka_systems ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/

[Dhis2-devs] merging facilities (org-units) without losing data

Hey devs is it possible to merge facilities without losing data, some admin accidentally created other duplicates units into the system. anyone knows how its done? developer_lusaka_systems ___ Mailing list: https://launchpad.net/~dhis2-devs Post to :

Re: [Dhis2-devs] merging facilities (org-units) without losing data

up of the database and then do this with an sql >> script, just changing the sourceid (the database internal referent to the >> organisationunitid) in the datavalues table. But you may get blocked if the >> same period has been filled for both, in which case you may want to do a >

[Dhis2-devs] connect to dhis2 live db

How do i achieve connection to dhis2 live database using pgadmin postgreSQL thanks -- developer_lusaka_systems ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-d

Re: [Dhis2-devs] connect to dhis2 live db

Thank you very much. let me have a try. On Tue, Jan 23, 2018 at 12:52 AM, Knut Staring wrote: > For Dhis live, the dhis.conf file is in the conf folder, and you don't > need to set up DHIS_HOME > > On Jan 22, 2018 11:43, "Stian Sandvold" wrote: > >> Hi Mose

Re: [Dhis2-devs] merging facilities (org-units) without losing data

have attached a datavalue table and 1 duplicate orgunit to be merged. please help me. On Mon, Jan 8, 2018 at 8:26 PM, moses mwale wrote: > Thanks very much, allow me to go through and implement the given knowledge > > On Sun, Jan 7, 2018 at 11:29 PM, Jason Pickering < > jason.p.pick

Re: [Dhis2-devs] merging facilities (org-units) without losing data

to figure out how to handle that > yourself! > > Hope that helps to clarify and good luck! > > Regards, > Jason Pickering > > > > > > On Thu, Jan 25, 2018 at 5:30 AM, moses mwale > wrote: > >> Hey Jason And Knut, thanks for the information, i have been try

Re: [Dhis2-devs] merging facilities (org-units) without losing data

Am using psql. see attached if its correct loading procedure. On Fri, Jan 26, 2018 at 2:42 AM, Knut Staring wrote: > Just run everything in your PgAdmin SQL interface. > > On Thu, Jan 25, 2018 at 1:22 PM, moses mwale > wrote: > >> okay nice thanks, is it to load user-defin

Re: [Dhis2-devs] merging facilities (org-units) without losing data

wrote: > That looks correct. > > It is of course worth saying, that you should not attempt to perform this > procedure on your production system, unless you have thoroughly tested it > in a development environment! > > Regards, > Jason > > > > On Thu, Jan

Re: [Dhis2-devs] merging facilities (org-units) without losing data

> Stay safe. > > On 25 January 2018 at 13:05, moses mwale wrote: > > This is live (Production) db created a backup. if something goes wrong > will > > revert. But the function itself doesnt affect anything right? what am > going > > to write now will i guess b

Re: [Dhis2-devs] merging facilities (org-units) without losing data

exist LINE 1: SELECT merge_organisationunits(37442, 24872 ,SUM); ^ That's the error i receive, what is wrong? thanks in advance. On Thu, Jan 25, 2018 at 3:32 PM, moses mwale wrote: > Thanks all you are really help i appreciate so much.

Re: [Dhis2-devs] merging facilities (org-units) without losing data

te: > Hi Moses, > > You need to use the UID of the organisation unit not their integer ID. > > You need to place string literals in single quotes. > > So, it should be something like > > SELECT merge_organisationunits('foo', 'bar' ,'SUM'); >

Re: [Dhis2-devs] merging facilities (org-units) without losing data

Thanks very much it has worked just analyzing the data now. You a savior. On Mon, Jan 29, 2018 at 1:20 PM, moses mwale wrote: > Alright thanks Jason on it. > > On Mon, Jan 29, 2018 at 1:10 PM, Jason Pickering < > jason.p.picker...@gmail.com> wrote: > >> Hi Mose

Re: [Dhis2-devs] merging facilities (org-units) without losing data

dhis2/dhis2-utils/commit/0b5026c70c6f0117dad83c7215ca89395f271f18>. > Maybe you can try again with this new version and see if it works? > > Regards, > Jason > > > On Mon, Jan 29, 2018 at 11:25 AM, moses mwale > wrote: > >> wow some major progress i thought it was special

[Dhis2-devs] Event reports does not retrieve dates

Hey Please help i have created a program for event capture and with data elements (Tracker). i can capture dates like start and end dates. Under section i have checked show in reports. But when i run event reports i the date column in emty, everything else is showing. Am using Dhis2 version 2.26

[Dhis2-devs] Date issue after upgrading dhis2 version

I have a problem with dates after an upgrade to a new version of dhis2 2.28 from version 2.26, 2.27. An Event Captured with dates seen but after running Analytics and running Event Reports for that particular Event dates are missing. Until a new Date Element is created e.g seen in the image (Date_1

[Dhis2-devs] program stage deletion

How do i delete the program stage instance of a program? i dont see any option of deleting. -- developer_lusaka_systems ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/

[Dhis2-devs] indicators gives total and average in total

my indicator type is sum but on pivot reports gives both sum and average. what could be the problem. kindly see attached. -- developer_lusaka_systems ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubs

[Dhis2-devs] indicators suming up as average in total

please can someone help me, my indicators are suming up as Average instead of Sum please help -- developer_lusaka_systems ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.ne

[Dhis2-devs] SEVERE: Failed to start connector [Connector[HTTP/1.1-auto-1]]

blank page i see this error in catalina.log SEVERE: Failed to start connector [Connector[HTTP/1.1-auto-1]] org.apache.catalina.LifecycleException: Failed to start component [Connector[HTTP/1.1-auto-1]] at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:153) at org.apache.ca

[Dhis2-devs] could not execute statement

when creating programes and deleting data elemnts i get this error *could not execute statement* Catalina.out gives these issues pleease help * INFO 2018-06-06 19:38:41,761 (moses) Updating 1 object(s) of type Program (DefaultObjectBundleService.java [http-bio-8080-exec-33]) * WARN 2018-06-06

[Dhis2-devs] Tracker capture not showing Attributes to be entered

I am trying to create a tracker capture program, when am done to test it the attributes i created under profile cant be seen, when i try to save and continue i see error Error Form is empty, please fill at least one but there is nothing to fill, where am i going wrong am using 2.29 i have gone

[Dhis2-devs] data write

The link between user roles and data sets/programs have been replaced by the new "data write" sharing levels. Somebody to make make me understand what that statement mean and how to achieve it please thanks -- developer_lusaka_systems ___ Mailing li

Re: [Dhis2-devs] data write

Regards, > Knut > > On Thu, Jun 7, 2018 at 2:16 PM moses mwale wrote: > >> The link between user roles and data sets/programs have been replaced by >> the new "data write" sharing levels. >> >> >> Somebody to make make me understand wh

[Dhis2-devs] calculating totals in custom designed form

Hello people i need to show totals in the custom form datasets of 3 data elements ART month 1, 2 and 3. So another column will be for total, but how do i calculate the total of these data elements as the data is being captured? developer_lusaka_systems _

Re: [Dhis2-devs] calculating totals in custom designed form

; In the Custom form design page, place the Total on the page design. It'll > now be calculating the totals on the fly as data is entered. > > Regards > > > On Tue, Jun 26, 2018, 9:32 PM moses mwale wrote: > >> Hello people i need to show totals in the custom form da

[Dhis2-devs] (no subject)

Hey All i was upgrading from 2.8 to 2.9 but i see this error and my app cant start on test environment. Oct 15, 2018 12:33:03 PM org.apache.catalina.startup.VersionLoggerListener log INFO: Server version:Apache Tomcat/7.0.68 (Ubuntu) Oct 15, 2018 12:33:03 PM org.apache.catalina.startup.V

[Dhis2-devs] startup error upgrade from 2.28 to 2.29

whenever i upgrade from 2.28 to 2.29 i see error below * INFO 2018-10-25 15:11:29,932 'system-process' create org.hisp.dhis.scheduling.JobConfiguration, name: Analytics, uid: rIxDo7LeidU (AuditLogUtil.java [localhost-startStop-1]) * ERROR 2018-10-25 15:11:29,940 Could not map job type '[resourceT

Re: [Dhis2-devs] startup error upgrade from 2.28 to 2.29

]) > * INFO 2018-10-25 15:11:30,546 'system-process' create > org.hisp.dhis.scheduling.JobConfiguration, name: PushAnalysis: > PNhbOVQfNzv, uid: qAS36jVFphT (AuditLogUtil.java [localhost-startStop-1]) > > > On Thu, Oct 25, 2018 at 3:39 PM moses mwa

[Dhis2-devs] Clear analytics tables

I have a test database which every time I import and connect a dhis2 instance automatically starts analytics and loads data. I don’t need that data it’s old, how do I clear this data from the database? Which table hold a that data I want to clear it. -- developer_lusaka_systems ___

Re: [Dhis2-devs] [Dhis2-users] postgresql version 9.6 required for dhis version 2.31

Sorry just to interject, so dhis2 does not work with Postgres 9.5? On Wed, 31 Oct 2018 at 9:58 AM, Bjørn Sandvik wrote: > Hi, > > PostGIS requirement is 2.2 or later. > AFAIK, this will still be the case for 2.31. > > Regards, > Bjørn > > -- > Bjørn Sandvik > GIS developer, DHIS 2 > University o

Re: [Dhis2-devs] Duplicate Key Error

Can you share the full log. On Tue, 30 Oct 2018 at 1:22 PM, gerald thomas wrote: > Dear All, > It had been awhile now that we had been noticing this error in our log: > > Caused by: org.postgresql.util.PSQLException: ERROR: duplicate key value > violates unique constraint "datavalue_pkey" > De

Re: [Dhis2-devs] Empty DHIS2 database

Hey Houssan Just connect DHIS to an empty Database, it will auto create empty tables on its own. On Wed, 14 Nov 2018 at 8:47 AM, Houssam Chammaa wrote: > Greetings > > Please note that I have installed a new DHIS2 server and I have download > the Postgres Database from DHIS2 website and I find

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

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

[Dhis2-devs] Pivot tables or event reports

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] Pivot tables or event reports

gt; > > [image: Inline image 1] > > regards, > > Lars > > On Tue, Sep 1, 2015 at 1:14 PM, moses mwale wrote: > >> Hello, is it possible that fact sheets (Pivot tables or event reports) >> can be converted into word or excel? >> >>

[Dhis2-devs] Pivot Tables (ReportTable) to Standard Report HTML report format

Hello All, am keenly interested to learn how to convert Pivot Tables (ReportTable) to Standard Report HTML report format. I know how to do that from event report to standard report html report format, How can I arrange indicators, period which are connected to 2 Organization Units? Am used to the

[Dhis2-devs] HTML Chart Standard report

Hello DHIS2 Neds may any one in here show me how I can create standard reports html based in chart format? I know how to from Events, pivot etc. to html standard tables, but to charts am missing out, any help. ___ Mailing list: https://launchpad.net/~dhi

[Dhis2-devs] Where do I place the metadata file when uploading

hello, Where do I place or put the metadata file when uploading, when using curl. curl -H "Content-type: Application/xml" -u admin:district -d @ metaData.xml "http://localhost:8082/api/metaData"; -X POST -v ___ Mailing list: https://launchpad.net/~dhis2

[Dhis2-devs] Error 415 UNSUPPORTED_MEDIA_TYPE

Am trying to create a new dataElement using CSV format. this is what am getting. curl --data-binary @dataElements.csv "localhost:8082/api/dataElements" -H "Content-Type:application/csv" -u admin:district -v * Trying ::1... * Connected to localhost (::1) port 8082 (#0) * Server auth using Basic

[Dhis2-devs] (no subject)

Hello Devs, when uploading data using a csv format which is shown below. how do I include a category combination e.g. gender name,uid,code,shortname,description,formname,domaintype,type,numbertype,texttype,aggregationoperator,categorycombo,url,zero "undergoing HIV testing",,"x3,"undergoing HIV tes

[Dhis2-devs] Uploading Data values

Hello Devs how do I upload data Values into DHIS2 using csv format? ___ 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/L

[Dhis2-devs] uploading dataValues with category combo

hello how do I upload dataValues connected to category combo. any reference? ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launch

[Dhis2-devs] Converted tables to charts but API link fails generate image

The Charts i have just converted from tables cannot be generated as images, the API link clicked has to generate an image to be downloaded. but for these links it gives this error_ HTTP Status 500 - -- *type* Exception report *message* *description* *The server encou

[Dhis2-devs] Importing meta-data from dhis2 v2.20 from dhis2 v2.18 error

hello Devs I am finding difficulties Importing meta-data from dhis2 v2.20 from dhis2 v2.18 it gives error, what is the solution? ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchp

[Dhis2-devs] Manually creating periods

Is there a way of setting manually periods in dhis2. I see I can select automatically in a data set. how do I create my own period and use them? developer_lusaka_systems ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists