Re: [Dhis2-users] DHIS2 in Agriculture

2017-04-23 Thread Moses Marimo
even I am keen to hear about those. --- Regards, Saptarshi PURKAYASTHA, Ph.D. Assistant Professor of Health Informatics, Indiana University - Purdue University Indianapolis. On 22 April 2017 at 17:30, Moses Marimo wrote: > Dear All, > > We are in the process of implementing DHIS2 to

[Dhis2-users] DHIS2 in Agriculture

2017-04-22 Thread Moses Marimo
Dear All, We are in the process of implementing DHIS2 to collect, manage and visualise Agricultural data in Zimbabwe. The system will basically do the following tasks: 1. Track prices of all agricultural commodities (livestock products, crops, fruits, horticultural products, etc) at differ

Re: [Dhis2-users] Meta-Export from 2.19 to 2.24

2016-07-30 Thread Moses Marimo
> https://www.dhis2.org/223-upgrade > https://www.dhis2.org/224-upgrade > > -- > Morten Olav Hansen > Senior Engineer, DHIS 2 > University of Oslo > http://www.dhis2.org > > On Sat, Jul 30, 2016 at 11:12 AM, Moses Marimo wrote: > >> Thanks Morten, let me

Re: [Dhis2-users] Meta-Export from 2.19 to 2.24

2016-07-30 Thread Moses Marimo
uot; wrote: >> >>> Right link: >>> https://www.npmjs.com/package/json-lint >>> >>> On 30 Jul 2016 14:46, "Knut Staring" wrote: >>> >>>> You could use node to run it locally: >>>> https://github.com/zaach/jsonli

Re: [Dhis2-users] Meta-Export from 2.19 to 2.24

2016-07-30 Thread Moses Marimo
; On 30 Jul 2016 13:28, "Moses Marimo" wrote: > >> I am trying to import meta-data of a 2.19 deployment to a clean 2.24 >> deployment. I have a problem and I suspect there could be a problem with >> the JSON data. Its 15MB and I can not find any online JSON validator. A

[Dhis2-users] Meta-Export from 2.19 to 2.24

2016-07-29 Thread Moses Marimo
I am trying to import meta-data of a 2.19 deployment to a clean 2.24 deployment. I have a problem and I suspect there could be a problem with the JSON data. Its 15MB and I can not find any online JSON validator. Any idea how I can validate my big JSON file? Or does any one know a better way around

[Dhis2-users] Retrieve Structure of Organisation Units through Web API

2016-02-28 Thread Moses Marimo
I need to retrieve the structure of the OrganisationUnits so that If possible, I get JSON data structured from national, province, district and facility. How best can I retrieve this structured data. I need to use use it in a third party App that will eventually write back to DHIS2 Regards, Mose

Re: [Dhis2-users] Problem with attributeOptionCombo

2015-11-20 Thread Moses Marimo
match the > other. Remember that this might have huge effects on things like indicator > expressions, validation rule expressions, custom forms, etc. > > Lars > > > On Wed, Nov 18, 2015 at 9:56 AM, Moses Marimo > wrote: > >> Sorry, The import file is coming from a 2

Re: [Dhis2-users] Problem with attributeOptionCombo

2015-11-18 Thread Moses Marimo
oID column value in the Datavalue table as compared to the previous 2.14 imports. On Wed, Nov 18, 2015 at 10:42 AM, Lars Helge Ă˜verland wrote: > Hi Moses, > > > > On Mon, Nov 16, 2015 at 10:00 AM, Moses Marimo wrote: > >> I have a system that I migrated from from DHIS2

[Dhis2-users] Problem with attributeOptionCombo

2015-11-16 Thread Moses Marimo
I have a system that I migrated from from DHIS2.14 to 2.20. In the 2.14, there was no attributeOptionCombo in the export file. The Datavalue table was populated with a default value of 15 in the attributeOptionComboID column. After migrating the system, the export file from a 2.20 system now comes

Re: [Dhis2-users] After Database Restore, Analytics table empty

2015-11-10 Thread Moses Marimo
e space on the server is about 80% free space. I am using a pg_dump to backup the database on Ubuntu 14.04 LTS. On Mon, Nov 9, 2015 at 11:07 AM, Moses Marimo wrote: > * INFO 2015-11-09 10:38:24,708 Indicator group set table generated > (DefaultResourceTableService.java [taskScheduler-5]

Re: [Dhis2-users] After Database Restore, Analytics table empty

2015-11-09 Thread Moses Marimo
) * INFO 2015-11-09 10:47:14,823 [Level: INFO, category: DATAMART, time: Mon Nov 09 10:47:14 CAT 2015, message: Analytics tables updated: 00:08:54.947] (InMemoryNotifier.java [taskScheduler-5]) On Sat, Nov 7, 2015 at 10:54 AM, Lars Helge Ă˜verland wrote: > Hi Moses, > > can you please share the

Re: [Dhis2-users] After Database Restore, Analytics table empty

2015-11-06 Thread Moses Marimo
I am running DHIS2.20 on Ubuntu LTS 14.04 with Tomcat 7 On Friday, 6 November 2015, Moses Marimo wrote: > After I restored a database, analytics table is no longer being populated > even if after running Analytics, rebooting server, running analytics again. > I have checked in

[Dhis2-users] After Database Restore, Analytics table empty

2015-11-06 Thread Moses Marimo
After I restored a database, analytics table is no longer being populated even if after running Analytics, rebooting server, running analytics again. I have checked in physical datavalue table and the data is there. No error in Catalina logs. Any pointers?? -- ICT Warehouse (Pvt) Ltd - "The Sto

[Dhis2-users] Fwd: Dates in Analytics Blue Print

2015-09-08 Thread Moses Marimo
How does this blueprint work? https://blueprints.launchpad.net/dhis2/+spec/dates-in-analytics Is there a documentation to that effect? I am thinking this blue print can help me achieve the following: 1. Capture a date when an incentive was paid on a particular indicator, and display this date on a

Re: [Dhis2-users] Difference Between 2 Dates in Indocator

2015-04-24 Thread Moses Marimo
I have had problems with data elements holding dates before. In my case, all I wanted to do was display a date retrieved from a data element on a report. After much haranguing and sweating ;), I was informed that the Analytics excludes dates and string literals. This is understandable because aggre

Re: [Dhis2-users] [Dhis2-devs] Updated Data Not Reflecting On DHIS until after Midnight?

2015-04-24 Thread Moses Marimo
This is because the Analytics Tables are updated automatically at midnight. You can however, manually update the analytics Tables by going to reports and choosing Analytics and Datamart, then manually run the update. Data entered will only become available in reports after the analytics tables have

[Dhis2-users] Organisationunit table truncated after upgrade to 2.18 from 2.14

2015-04-23 Thread Moses Marimo
I upgraded from 2.14 to 2.18 and the organisationunit table was truncated. Is there anybody who has faced this problem. I tried to do a meta-data import from the backup system (2.14) but it didn't help. That table remains empty. I tried the raw approach - restoring data for that table only from the

Re: [Dhis2-users] Table exceeds max number of cells: 50000 (60756)

2014-11-27 Thread Moses Marimo
On Thu, Nov 27, 2014 at 11:49 AM, Jason Pickering < jason.p.picker...@gmail.com> wrote: > Settings->General Settings->Maximum number of analytics records > Is this setting available in 2.14. Because I can not locate it. If this setting is not available in the user interface, is there anyway to t

Re: [Dhis2-users] Table exceeds max number of cells: 50000 (60756)

2014-11-27 Thread Moses Marimo
This error is on DHIS 2.14 On Thu, Nov 27, 2014 at 11:12 AM, Moses Marimo wrote: > I get this error when I run a report which only has 7 columns and less > than 30 Facilities. What causes this error??? > > org.hisp.dhis.analytics.IllegalQueryException: Table exceeds max number

[Dhis2-users] Table exceeds max number of cells: 50000 (60756)

2014-11-27 Thread Moses Marimo
I get this error when I run a report which only has 7 columns and less than 30 Facilities. What causes this error??? org.hisp.dhis.analytics.IllegalQueryException: Table exceeds max number of cells: 5 (51792) org.hisp.dhis.analytics.data.DefaultQueryPlanner.validate(DefaultQueryPlanne

Re: [Dhis2-users] Sub-Queries in Jasper reports

2014-11-26 Thread Moses Marimo
s (January+February+March) and I guest I need a sub-query > for this. How do I go about this. > > > Regards, > > Moses Marimo > > ___ > Mailing list: https://launchpad.net/~dhis2-users > Post to : dhis2-users@lists.launchpa

Re: [Dhis2-users] Enforcing Max/Min Value on Data entry Form

2014-09-10 Thread Moses Marimo
I am sure HTML 5 attributes should help. Just go to the source of the data entry form and add min and max attributes On Wed, Sep 10, 2014 at 11:25 AM, Morina Matasi wrote: > Can I enforce Max/Min values on a data entry form. Validation is not > giving me much flexibility. I want the data entry

Re: [Dhis2-users] DHIS2.14 INSTALLATION overwriting database on startup

2014-09-02 Thread Moses Marimo
Sorry, I got it now. Spelling mistake. Thanks. On Tuesday, September 2, 2014, Moses Marimo wrote: > I have tried that. Opened the file in vim editor and made sure there are > no trailing spaces, but still, I get the same behaviour. > > > > On Tuesday, September 2, 2014, L

Re: [Dhis2-users] DHIS2.14 INSTALLATION overwriting database on startup

2014-09-02 Thread Moses Marimo
; witespaces: > > hibernate.hbm2ddl.auto = update > > Lars > > > > On Tue, Sep 2, 2014 at 10:34 AM, Moses Marimo > wrote: > >> I have a DHIS2.14 installation behaving very awkward. On startup, it >> overwrites data in all tables and fills in the default admi

[Dhis2-users] DHIS2.14 INSTALLATION overwriting database on startup

2014-09-02 Thread Moses Marimo
I have a DHIS2.14 installation behaving very awkward. On startup, it overwrites data in all tables and fills in the default admin/district data. I can confirm it's able to connect to the database because it's overwriting my restored data. Any pointers. Regards, Moses -- ICT Warehouse (Pvt) Ltd

Re: [Dhis2-users] Benchmarking the speed of Importing Data into DHIS2.14

2014-04-04 Thread Moses Marimo
Hi Moses > > 2G seems like a lot for the OS, but agree that over allocating (and the > subsequent swapping and thrashing) would certainly be harmful. Probably 1G > for the OS would be sufficient. > > Bob > > > On 4 April 2014 13:47, Moses Marimo wrote: > >>

Re: [Dhis2-users] Benchmarking the speed of Importing Data into DHIS2.14

2014-04-04 Thread Moses Marimo
many rows of > data do you have in your datavalue table? Which database are you using? > What do the logs say? What is you current CPU usage before you start the > import? > > > > > On Fri, Apr 4, 2014 at 10:52 AM, Moses Marimo wrote: > >> Thanks Jason. I have tried

Re: [Dhis2-users] Benchmarking the speed of Importing Data into DHIS2.14

2014-04-04 Thread Moses Marimo
al. We regularly import data around this size, and it > only takes a few minutes, on a much smaller virtual machine than what you > mention. > > What type of importer are you using? XML or CSV? > > Regards, > Jason > > > > On Fri, Apr 4, 2014 at 9:41 AM, Moses Marimo

[Dhis2-users] Benchmarking the speed of Importing Data into DHIS2.14

2014-04-04 Thread Moses Marimo
Dear Colleagues, I am trying to benchmark the time it takes for my users to import data into DHIS2.14, Build 13793. I know this import time also depends on the resources available on my server, BUT a little comparison would not hurt. My server has a Xeon Processor Quad-Core and the RAM is 12GB. O

[Dhis2-users] Exporting from DHIS1.4 and Importing into DHIS2

2013-09-10 Thread Moses Marimo
I have DHIS1.4 which can export XML data in DHIS2 format. However, when importing that file into DHIS2.10 running on Ubuntu 12.04 and MySQL database, I am having to select DHIS 1.4 import for it to be successful. Is this the normal behaviour? I would have thought since I am exporting the file from

Re: [Dhis2-users] MySQL and DHIS 2.12

2013-07-02 Thread Moses Marimo
ept > the password of course!). Could it be that you use the postgres dialect with > a mysql connection string? > > regards, > > Lars > > > > On Tue, Jul 2, 2013 at 4:05 PM, Moses Marimo wrote: >> >> Is there anyone with a good step by step tutorial of

[Dhis2-users] MySQL and DHIS 2.12

2013-07-02 Thread Moses Marimo
Is there anyone with a good step by step tutorial of configuring DHIS2 with MySQL. I don't seem to be getting that to work though PostgreSQL work on the same server without a problem. I keep getting this error: - INFO: Deploying web appl

Re: [Dhis2-users] Categorised Totals

2013-06-26 Thread Moses Marimo
ivot > tables but that is an issue you can address down the line. If you need any > more input, will be happy to help. > > Hope this helps. > > Best wishes, > > Busoye > > > > On 26 Jun 2013, at 10:51, Moses Marimo wrote: > >> Dear All, &g

[Dhis2-users] Categorised Totals

2013-06-26 Thread Moses Marimo
Dear All, I have a data collection form with categorised totals. The form can be viewed from this link: http://ict.co.zw/dhis2/CategorisedTotal.pdf What is the optimal way of including these totals in the data Entry Form. I could create an indicator per each total column but this can result in 4