Re: [Dhis2-users] [Dhis2-devs] Inactive Organisation Unit

2014-04-08 Thread Jason Pickering
hide the inactive facility in the list of facilities? > > Thanks > > > > Regards, > > Hugo > > > > *From:* Jason Pickering [mailto:jason.p.picker...@gmail.com] > *Sent:* sexta-feira, 4 de Abril de 2014 11:50 > *To:* Lars Helge Øverland > *Cc:* Wilson,Ra

Re: [Dhis2-users] [Dhis2-devs] Limit characters in Comment

2014-04-09 Thread Jason Pickering
Did you change the database field type from varchar to text? Regards, Jason On Wed, Apr 9, 2014 at 11:31 AM, channara rin wrote: > Dear Lars, > I tried to change in history.js > but when i enter longer than 360 in comment, and press "Save Comment". It > always jump: > CONSOLE > ---

Re: [Dhis2-users] [Dhis2-devs] Limit characters in Comment

2014-04-09 Thread Jason Pickering
> Best Regards, > CHANNARA > > > On Wed, Apr 9, 2014 at 4:40 PM, Jason Pickering < > jason.p.picker...@gmail.com> wrote: > >> Did you change the database field type from varchar to text? >> >> Regards, >> Jason >> >> >> >> On W

Re: [Dhis2-users] [Dhis2-devs] USERS-Password

2014-04-23 Thread Jason Pickering
This has been discussed several times on this list including most recently here, so check the archives as well. https://lists.launchpad.net/dhis2-devs/msg28635.html Regards, Jason On Wed, Apr 23, 2014 at 7:40 PM, Dan Cocos wrote: > Hi Riddy, > > The password uses the username as a salt for

Re: [Dhis2-users] runing Analytics errors.

2014-04-24 Thread Jason Pickering
Hi Emmanuel, It is not possible to have views linked directly to the resource tables, as they are dropped and regenerated each time when the analytics runs. Two options. 1) Encapsulate your view in a stored procedure. 2) Use the SQL view function of DHIS2. Both approaches have been discussed pre

Re: [Dhis2-users] Documentation for release 2.13

2014-04-26 Thread Jason Pickering
Hi Angela, We currently do not keep previous versions of the documentation, but they can be regenerated from the documentation source code. We should certainly do a better job of clearly marking the versions and what is appropriate to each release. However, in this case, there has been little chanc

Re: [Dhis2-users] Documentation for release 2.13

2014-04-26 Thread Jason Pickering
Apologies for the typos! However, in this case, there has been little change since 2.13, so the current documentation is still valid for 2.13 in this case. On 4/26/14, Jason Pickering wrote: > Hi Angela, > We currently do not keep previous versions of the documentation, but > th

Re: [Dhis2-users] Creation of bulk user.

2014-05-06 Thread Jason Pickering
Hi Hannan, This has been discussed (again) recently on this list. http://dhis-developers-list.1563109.n2.nabble.com/Password-Generation-td7590749.html#a7590750 http://dhis-developers-list.1563109.n2.nabble.com/USERS-Password-td7591703.html#a7591704 There are a few more as well in the archives if

Re: [Dhis2-users] Creation of bulk user.

2014-05-07 Thread Jason Pickering
n Wed, May 7, 2014 at 12:14 PM, Jason Pickering < > jason.p.picker...@gmail.com> wrote: > >> Hi Hannan, >> This has been discussed (again) recently on this list. >> >> >> http://dhis-developers-list.1563109.n2.nabble.com/Password-Generation-td7590749.htm

Re: [Dhis2-users] Creation of bulk user.

2014-05-07 Thread Jason Pickering
n which tools you are using to prepare the SQL for inserting them into the DHIS2 database. Regards, Jason On Wed, May 7, 2014 at 10:07 AM, Hannan Khan wrote: > No. It seems that uuid is not automatically generated. Please suggest. > > Regards > > Hannan > On May 7, 2014 1:34 PM, &

Re: [Dhis2-users] No more able to access DHIS2 after changing admin password

2014-05-13 Thread Jason Pickering
Hi Kader, Please check the archives here ( https://lists.launchpad.net/dhis2-devs/msg25167.html) where I describe a possible solution. This will only work if you still have the admin user, otherwise, you will need to generate an encrypted password through some of the methods described in the archiv

Re: [Dhis2-users] No more able to access DHIS2 after changing admin password

2014-05-13 Thread Jason Pickering
d what caused the disappearance of the role > when I changed the default password. > > Thanks again. > > Best regards, > Kader > > > > 2014-05-13 20:48 GMT+03:00 Jason Pickering : > > Hi Kader, >> Please check the archives here ( >> https://lists.laun

Re: [Dhis2-users] Displaying categories combination in report

2014-05-14 Thread Jason Pickering
If no data elements are showing at all, be sure your data elements belong to a data element group, and that this group is part of a group set. Regards, Jason On Wed, May 14, 2014 at 10:46 AM, Kader Irchad Barry wrote: > Hello, > > I would like to access to the different data elements categori

Re: [Dhis2-users] Importing Organization Units from another system

2014-06-03 Thread Jason Pickering
Hi Laura, It is tough to say what is going on without more information. You may want to allow the system to generate the UID for you (which is described here http://www.dhis2.org/doc/snapshot/en/user/html/ch30s25.html) as it must follow a valid specification. Please include the XML which you cre

Re: [Dhis2-users] Has anyone used DHIS2 for Animal Health

2014-06-18 Thread Jason Pickering
Humans are animals too. :) Seriously though, we looked at the use of DHIS2 here in Zambia to replace the current system used for veterinary surveillance, and it seemed to be possible. No concrete work has yet to be done however. There were some challenges with the reporting/organsiational hierar

Re: [Dhis2-users] Sharing Pivot Table details between DHIS instances

2014-06-19 Thread Jason Pickering
I would think the best way to go about this would be to have a common meta-data repository. It would seem to be quite a bit of effort to try and map metadata definitions between different instances, but the usual approach here would be to have a "master" instance, which other "slave" instances woul

Re: [Dhis2-users] several links in api/resources pointing to the same ("dimensions") url

2014-07-06 Thread Jason Pickering
Hi Lavi, It is not intentional and has been fixed in a later version. Bug report is here https://bugs.launchpad.net/dhis2/+bug/1216825 Best regards, Jason On Sun, Jul 6, 2014 at 1:36 PM, Lavi Shpigelman wrote: > Hi. > I noticed that in in version 2.15 (and also in version 2.13), some of th

Re: [Dhis2-users] [Dhis2-devs] Data import to a Dataset linked to a combination of categories

2014-07-22 Thread Jason Pickering
One possible solution is to simply transform your data directly to a form which can be imported directly into the database itself. If you are doing a one off or supervised data import, it should be relatively simple to transform the data to import to SQL and inject it directly, while this feature

Re: [Dhis2-users] Error prune period

2014-07-30 Thread Jason Pickering
Hi Channara, It will help if you could send the output of the console when you execute the command, along with the usual (DHIS2 version, Java version, OS). Best regards, Jason On Thu, Jul 31, 2014 at 4:50 AM, wrote: > Hi all developers, > when I go to services→maintenance, then I checked ru

Re: [Dhis2-users] Error prune period

2014-07-30 Thread Jason Pickering
database, clear your DHIS2 cache and try again. Best regards, Jason On Thu, Jul 31, 2014 at 6:33 AM, wrote: > HI Jason, > I am using > -DHIS2 v2.16 > -Build revision: 16253 > -Java version: jre7 > -Database: PostgreSQL > -OS: windows 8 > plz check attached file

Re: [Dhis2-users] Error prune period

2014-07-31 Thread Jason Pickering
Java version: jre7 > -Database: PostgreSQL > -OS: windows 8 > > thank you > channara > *From:* channara rin > *Sent:* ‎Thursday‎, ‎July‎ ‎31‎, ‎2014 ‎12‎:‎37‎ ‎Evening > *To:* Jason Pickering > > *Cc:* DHIS 2 Users list , DHIS 2 > Developers list > > Here is the err

Re: [Dhis2-users] Quick way to add missing ISO weeks going back to 2011?

2014-08-05 Thread Jason Pickering
Hi Randy, I see Bob just replied but was about to send this and will go ahead, but would wait for a more authoritative answer. Here is an R script which I have used in the past. It is very basic and does not take into account weeks which might already exist. It simply creates a lot of INSERT stat

Re: [Dhis2-users] Quick way to add missing ISO weeks going back to 2011?

2014-08-05 Thread Jason Pickering
t; other use? >>> 2. Its very easy to create duplicate periods which is not nice. >>> Probably we should consider placing a uniqueness constraint on >>> periodtype+startdate >>> >> >> To answer my own question, different versions of dhis have treat

Re: [Dhis2-users] Creating indicator with non-numeric values

2014-08-06 Thread Jason Pickering
Hi Nayeem, One approach if you are using aggregate data collection, would be to create three separate questions using Boolean data elements. 1) Sterilized delivery set not available 2) Sterilized delivery set available but not ready for use 3) Sterilized delivery set available and ready for use O

Re: [Dhis2-users] [Dhis2-devs] API resources navigation

2014-08-26 Thread Jason Pickering
There are a number of extensions to Chrome which help with this. I personally use "XMLTree" although this is not an endorsement of this plugin. You can search the Chrome store for many such add-ons. Best regards, Jason On Mon, Aug 25, 2014 at 9:14 PM, Brajesh Murari wrote: > Dear Maheed, > >

Re: [Dhis2-users] [Dhis2-devs] API resources navigation

2014-08-26 Thread Jason Pickering
This is also possible with XMLTree, but you must enable it as an option in the extension settings. Either way, they both pretty much get the job done. :) Regards, Jason On Tue, Aug 26, 2014 at 12:11 PM, Lars Helge Øverland wrote: > Another one that allows you to click on the links are XV: >

Re: [Dhis2-users] [Dhis2-devs] Email in user account

2014-09-01 Thread Jason Pickering
Just be sure "Send notification to completing user" is set to "Yes" in the dataset. Regards, Jason On Mon, Sep 1, 2014 at 10:20 AM, wrote: > Hi all, > I wonder, The “Email” in user account when we registered, Can the DHIS2 > can send Email notification to those Email after they entry data in

Re: [Dhis2-users] [Dhis2-devs] Email in user account

2014-09-01 Thread Jason Pickering
Then the user needs to set their personal email, and message delivery needs to be enabled via email in their settings. Regards, Jason On Mon, Sep 1, 2014 at 11:11 AM, wrote: > YES, that function just send mail for using inside DHIS2. but doesn’t > send to personal Email. > > *

Re: [Dhis2-users] [Dhis2-devs] Email in user account

2014-09-01 Thread Jason Pickering
settings. > > Regards, > Jason > > > > On Mon, Sep 1, 2014 at 11:11 AM, wrote: > >> YES, that function just send mail for using inside DHIS2. but doesn’t >> send to personal Email. >> >> *From:* Jason Pickering >> *Sent:* ‎Monday‎, ‎Septembe

[Dhis2-users] IMPORTANT: Vulnerability discovered in DHIS2 version 2.16 and some versions of trunk.

2014-09-01 Thread Jason Pickering
further on this issues, once we have had time to determine the extent of the problem, as well as to confirm a final fix. If you have any questions about this mail, please do not hesitate to ask! Best regards, Jason Pickering ___ Mailing list: https://launc

Re: [Dhis2-users] [Dhis2-devs] Auto-calculated data in entry forms

2014-09-01 Thread Jason Pickering
Hi Robin, You can simply use an indicator to do this. In case you have not seen it, we have extensive documentation on the use of indicators here https://www.dhis2.org/doc/snapshot/en/user/html/ch13.html#indicator_maintenance It should also be possible to calculate the value from other data, no

Re: [Dhis2-users] WebAPI resource - SQLview missing

2014-09-06 Thread Jason Pickering
Hi Sam, Do you mean that you do not see any views in an empty database, or that you are unable to access the "SQL View" functionality through the "Data administration" dialog? Regards, Jason On Sun, Sep 7, 2014 at 8:14 AM, Sam Kasozi wrote: > Hi all, I see the SQLview resource on the demo ser

Re: [Dhis2-users] WebAPI resource - SQLview missing

2014-09-07 Thread Jason Pickering
Uganda | GHSI - Uganda MOH - PH Emergency Operation Center > +256 757 662752 | +256 788 993565 | kaso...@gmail.com | Skype: > sam.kasoziug > > > On Sun, Sep 7, 2014 at 9:41 AM, Jason Pickering < > jason.p.picker...@gmail.com> wrote: > >> Hi Sam, >> Do you mean that y

Re: [Dhis2-users] [Dhis2-devs] 2.16 dashboard language changed

2014-09-08 Thread Jason Pickering
Hi Fatema, I am not sure what revision you are using, but I just made a change to 2.16 this morning which might account for this, but I do not think so. Are you sure you cannot change your locale back to English? It can be a bit difficult, if it is appearing in Arabic, but choose "Profile" (the p

Re: [Dhis2-users] [Dhis2-devs] 2.16 dashboard language changed

2014-09-09 Thread Jason Pickering
n >> application. >> >> Could anyone tell me please which database table affect by it. >> >> I need that table name. >> >> Thanks >> >> On Mon, Sep 8, 2014 at 6:19 PM, Jason Pickering < >> jason.p.picker...@gmail.com> wrote: >> >&g

Re: [Dhis2-users] Data Entry Screen Fails to Load Data Set

2014-09-09 Thread Jason Pickering
Try clearing the browser cache completely. Also send any messages from the tomcat logs. If you see nothing, press F12 in your browser if you are using Chrome and look for any Java Script error there. Regards, Jason -- Sent from my mobile On Sep 10, 2014 7:49 AM, "Morina Matasi" wrote: > The Se

Re: [Dhis2-users] [Dhis2-devs] DHIS2 - Indicator calculation over dimensions

2014-09-10 Thread Jason Pickering
Hi Robin, It has been a discussed, and certainly not a bug. See a related thread here (https://lists.launchpad.net/dhis2-devs/msg27571.html) for a similar discussion on validation rules. It is essentially the same as indicators. What you will have to do is to create seperate indicator for each and

Re: [Dhis2-users] [Dhis2-devs] dhis 2.16 upgrade notes

2014-09-10 Thread Jason Pickering
Hi Sumudu, I looked through your log, and it looks like you are using an older build of 2.16 which is subject to a potentially very serious security flaw. This issue was disclosed on the DHIS2 developer and user list last week out last week and a fix has been committed by the developers. You woul

Re: [Dhis2-users] [Dhis2-devs] DHIS2 - Indicator calculation over dimensions

2014-09-11 Thread Jason Pickering
ated value > exists? With existing I don't mean NULL or zero, but rather not defined > (the dimension does not exist). > > > > Robin > > > > *From:* Jason Pickering [mailto:jason.p.picker...@gmail.com > ] > *Sent:* 10 September 2014 17:55 > *To:* Rob

Re: [Dhis2-users] [Dhis2-devs] DHIS2 - Indicator calculation over dimensions

2014-09-11 Thread Jason Pickering
calculation power in > DHIS2 I'd say: > > > > 1. Use aggregated value when no disaggregated value exists (such as > for population in the previous example). > > 2. Aggregation operators (sum, average,...) should be defined per > custom category an

Re: [Dhis2-users] [Dhis2-devs] DHIS2 - Indicator calculation over dimensions

2014-09-16 Thread Jason Pickering
rs > than others (our project is in forest management). > > > > Have a nice day, > > > > Robin > > > > *From:* Jason Pickering [mailto:jason.p.picker...@gmail.com] > *Sent:* 11 September 2014 19:00 > > *To:* Robin Martens > *Cc:* Lars Helge Øverland;

Re: [Dhis2-users] GIS shapefiles integration / info about names of feature members

2014-09-26 Thread Jason Pickering
Are you sure you have a DBF file attached to this shape file which actually contains the names of the elements in the shape file? It needs to be in the same directory as the .shp and .shx file. Regards, Jason On Fri, Sep 26, 2014 at 10:35 AM, Kader Irchad Barry wrote: > Hello, > > I am followi

Re: [Dhis2-users] GIS shapefiles integration / info about names of feature members

2014-09-26 Thread Jason Pickering
>>> >>> Yes, the .dbf files are in the same directory as the .shp and .shx ones. >>> I even tried to open these .dbf files with a text editor and I can see all >>> the information regarding the feature members inside. >>> >>> @Knut: I made a se

Re: [Dhis2-users] Add Period : Five-Yearly or quinquennial

2014-09-26 Thread Jason Pickering
Hi Guy, Can be done, but quite a bit of work. Have look in the source code at dhis2\dhis-2\dhis-api\src\main\java\org\hisp\dhis\period which will give you an idea of how to implement new period types. Regards, Jason On Fri, Sep 26, 2014 at 6:00 PM, Guy Ekani wrote: > Hello Everyone, > > is i

Re: [Dhis2-users] Add Period : Five-Yearly or quinquennial

2014-09-26 Thread Jason Pickering
, Jason On Fri, Sep 26, 2014 at 6:37 PM, Guy Ekani wrote: > Thank u Jason, > > But, I do not have the source code, there is no other way? > > Sincerely, > > = > Guy > > > > > > > > Le Vendredi 26 septembre 2014 17h24, Jason Pi

Re: [Dhis2-users] Add Period : Five-Yearly or quinquennial

2014-09-26 Thread Jason Pickering
ign a form to retrieve the data for > a quiquennial census (Period type : 2001-2005 and 2006-2010) > > = > Guy > > > > > > > Le Vendredi 26 septembre 2014 17h39, Jason Pickering < > jason.p.picker...@gmail.com> a écrit : > > &g

Re: [Dhis2-users] corrupted data elements

2014-10-03 Thread Jason Pickering
If you know the UID of the data element (which seems to be the case here) , can't you just delete it directly from the database? Be sure to refresh your cache afterwards. DELETE FROM dataelement where uid = 'yAuhfSERVSA'; You might have some other constraints which you may need to get rid of one

Re: [Dhis2-users] [Dhis2-devs] DHIS2 - Indicator calculation over dimensions

2014-10-05 Thread Jason Pickering
> > *Regards,* > > *Dapo Adejumo* > > *+2348033683677 <%2B2348033683677>* > > *Skype : dapojorge* > > > > *From:* Dhis2-devs [mailto:dhis2-devs-bounces+dapo_adejumo= > yahoo@lists.launchpad.net] *On Behalf Of *Jason Pickering > *Sent:* 16 S

Re: [Dhis2-users] [Dhis2-devs] dhis2 system administration list

2014-10-09 Thread Jason Pickering
Hi Bob, I see the need, but am a bit concerned about establishing another mailing list. You can see from the dev list, that there are A LOT of non-dev topics already. Some of these are implementation issues, some end-user support, and a small smattering of Java jabberwocky. The dev list has sort of

Re: [Dhis2-users] [Dhis2-devs] how to delete data value

2014-10-14 Thread Jason Pickering
Hi Channara, There is no easy way to do this through the user interface, However, you can run the following SQL statement if you want to delete all of your data. -WARNING If you execute these statements, you will delete all of your data, irrevocably, so be sure you have a back up in case y

Re: [Dhis2-users] Encrypt the hibernate.properties file in dhis-live

2014-10-22 Thread Jason Pickering
It is not possible. Since dhis-live is meant to be run on a stand-alone system, why would you need to encrypt it? Are you looking to protect this from other users who have access to the local system itself? Best thing (on Windows) would to be sure the directory is owned by the user who is executing

Re: [Dhis2-users] Empty Data set report

2014-10-24 Thread Jason Pickering
Hi Guy, You may want to have a look at the documenation here https://www.dhis2.org/doc/snapshot/en/user/html/ch20s16.html Best regards, Jason On Fri, Oct 24, 2014 at 10:25 AM, Guy Ekani wrote: > Thanks John, > > I resolved the issue by running Analytics tables update, How can i do it > automa

Re: [Dhis2-users] data collection system using mobile phones and dhis

2014-10-28 Thread Jason Pickering
Hi Henri, There are many different platforms which have their various advantages and and disadvantages. Riddy mentioned SMS, but we have used the J2ME solution for several years in Zambia, and it has worked and scaled to several thousand users very well. There are other options such as the web-ba

Re: [Dhis2-users] [Dhis2-devs] Confusing Use license on dhis2 website

2014-11-02 Thread Jason Pickering
The major difference between the BSD and LGPL (which is not what the terms we are discussing here) is the BSD license is somewhat more permissive. It basically states here is the source code, do what you want with it, but we make no warranties whatsoever. If people want to take the DHIS2 source cod

Re: [Dhis2-users] HTML Documentation Hiperlink issue

2014-11-03 Thread Jason Pickering
Hi Andrew, I have seen this in the past, and seems to be related to some cache (somewhere). The links in the documentation are updated dynamically, each time we build the documents, so if an old copy of the docs is floating around in a cache someplace, you may see this. Could you provide the exact

Re: [Dhis2-users] Dear all

2014-11-12 Thread Jason Pickering
Hi Joao, You can check the completeness of your data by dataset, using the pivot table/GIS/data visualizer apps. Just look for the section "Reporting rates". You can also use the reporting rate summary in "Reports". The data browser module in "Data administration" can also be helpful. All of thes

[Dhis2-users] Updates/housekeeping to the DHIS2 translation server

2014-11-20 Thread Jason Pickering
can read more about how to localize DHIS2 in the documentation <https://www.dhis2.org/doc/snapshot/en/implementer/html/ch19.html>. Regards, Jason Pickering ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchp

Re: [Dhis2-users] where to translating the map and pivot module ?

2014-11-25 Thread Jason Pickering
Hi Easy, If you are using the offline translation tool, it may not work for you, but you can easily edit the i18n_app.property files directly inside each app. Otherwise, as Lars says,we can help you to setup the translation server, so that you/your translation team can do the translation, and the

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

2014-11-27 Thread Jason Pickering
How many data elements/indicators do you have? This might explain the error. Basically, there is a restriction put into place to prevent DHIS2 from returning "too much" data to the browser, and to prevent anyone from completely bring the system to its knees with a very large request for data. Try t

Re: [Dhis2-users] data visualizer

2014-12-04 Thread Jason Pickering
Did you run the analytics? On Dec 4, 2014 2:22 PM, "Nami Ghadri" wrote: > Hello, > > > > I made > > -data element > > -data set > > -assigned to an organization unit > > -entered data into data entry for data element > > -tried to use data visualizer but it

Re: [Dhis2-users] data visualizer

2014-12-04 Thread Jason Pickering
Depending on your cache settings, you may need to clear your browser cache as well, as the "old" values may still be cached locally. Regards, Jason On Thu, Dec 4, 2014 at 3:06 PM, Nami Ghadri wrote: > I just did now > > > > > > From: Jason Pickering [mailto:jaso

Re: [Dhis2-users] data visualizer

2014-12-04 Thread Jason Pickering
cess again. Regards, Jason On Thu, Dec 4, 2014 at 3:12 PM, Nami Ghadri wrote: > It gave the new data that I entered > > > > But for other new data element visualizer won’t work > > > > Any ideas > > > > Thanks > > > > > > *From:* Jason Picker

Re: [Dhis2-users] Data elements not available for insertion on custom forms

2014-12-04 Thread Jason Pickering
I would start by looking in your JavaScript console for any error message which you might have there and posting here. You can also include your Tomcat logs which might reveal what is going on. Do you have any non-ASCII characters in your data element names? Regards, Jason On Thu, Dec 4, 2014 a

Re: [Dhis2-users] Data elements not available for insertion on custom forms

2014-12-04 Thread Jason Pickering
> function)620531d66a.js?sid=35906:1 > w.__twb__620531d66a.ready620531d66a.js?sid=35906:1 (anonymous > function)620531d66a.js?sid=35906:1 (anonymous function) > loader.js?client=wc:384 Resource interpreted as Script but transferred > with MIME type text/html: " > https

Re: [Dhis2-users] Help with DSH2 config.

2014-12-05 Thread Jason Pickering
Are you sure you are connected to the Internet? maven needs to download a lot of components, so be sure you are on a fast line. Alternatively, you can always get the latest build from https://apps.dhis2.org/ci/. Regards Jason On Dec 5, 2014 2:58 PM, "Norberto Banze" wrote: > I am following the s

Re: [Dhis2-users] import fails

2014-12-05 Thread Jason Pickering
Hi Simon, I think you will need a later version of DHIS2. Try and see if it works on the demo server. See here for more info. https://lists.launchpad.net/dhis2-devs/msg30073.html Regards, Jason Can anyone help with import error. I am getting *An exception occurred* Sorry! The system failed t

Re: [Dhis2-users] [Dhis2-devs] DHIS2 Validation

2014-12-08 Thread Jason Pickering
Yes, agree, that it works. Usually, these issues have to do with missing data. If data is missing, the validation rule will be skipped entirely by default. >From the docs... When editing an expression, check the setting skip for missing values to > require that all data element values in the expr

Re: [Dhis2-users] Missing data

2014-12-17 Thread Jason Pickering
If you cannot see the data in the data entry forms, you may have a problem, otherwise, maybe you can try running the analytics? Regards, Jason On Wed, Dec 17, 2014 at 1:53 PM, riddy ndoma wrote: > > Hi Gerald, > What do you mean by information are not reflecting? can you explain > please!! > >

Re: [Dhis2-users] [Dhis2-devs] Creating Sync between Linode(External Server) and Local Server

2014-12-18 Thread Jason Pickering
One way of solving the problem of backups and disk space, is to push your backups to Amazon Glacier. That way, you can be sure that you have a "secure" offsite backup some place. Once it is on Glacier, then you can download the backup to your backup machine. From a security standpoint, it might be

Re: [Dhis2-users] inport meta data to option set

2014-12-18 Thread Jason Pickering
Hi Simon I think Knut is right. You must have a code, and it must be unique across all options (not only the ones in the option set you are importing). Regards, Jason On Dec 19, 2014 6:02 AM, "Knut Staring" wrote: > I think maybe you have to have something in the code field > On 19 Dec 2014 02

Re: [Dhis2-users] Export dataset to a new computer

2014-12-20 Thread Jason Pickering
Easiest and most complete method would be to dump your local database and copy to and restore on the other computer. Regards Jason -- Sent from my mobile On Dec 20, 2014 5:03 PM, "Norberto Banze" wrote: > Great. Thanks > > Hugs > > > Sent from Samsung Mobile > > > Original message

Re: [Dhis2-users] Epi week in DHIS2

2014-12-26 Thread Jason Pickering
Hi Raheel, There are many different definitions of what an Epi Week actually is. Could you be more specific? Right now, weeks are implemented as ISO weeks, beginning on Monday and ending on Sunday. Regards, Jason On Dec 25, 2014 9:39 PM, "Raheel Ayaz" wrote: > Hi all, > > Is there any chance to

Re: [Dhis2-users] Epi week in DHIS2

2014-12-26 Thread Jason Pickering
m Thanks and best regards, Raheel On Fri, Dec 26, 2014 at 1:50 PM, Jason Pickering < jason.p.picker...@gmail.com> wrote: > Hi Raheel, > There are many different definitions of what an Epi Week actually is. > Could you be more specific? Right now, weeks are implemented as ISO week

Re: [Dhis2-users] [Dhis2-devs] DHIS2 database tables

2014-12-30 Thread Jason Pickering
Hi Simon, There is not much really in terms of documenting what each and every table does, but you can build the db schema (a bit out of data) from the documentation branch. Simply execute mvn -f db-pom.xml clean package This will produce an HTML file which links all of the tables and relationsh

Re: [Dhis2-users] [Dhis2-devs] DHIS2 database tables

2014-12-30 Thread Jason Pickering
s > > > > *Regards* > > *Simon Muyambo* > > > > > > *From:* Jason Pickering [mailto:jason.p.picker...@gmail.com] > *Sent:* 30 December 2014 13:11 > *To:* Simon Muyambo > *Cc:* dhis2-devs; DHIS 2 Users list > *Subject:* Re: [Dhis2-devs] [Dhis2-users] DH

Re: [Dhis2-users] [Dhis2-devs] delete data from org unit

2015-01-08 Thread Jason Pickering
Jo Joao, You can try.. DELETE FROM datavalue_audit where sourceid = ??? DELETE FROM datavalue where sourceid = which should delete all aggregate data for the orgunit with sourceid equal to Obviously, you should be careful with any delete statement, and always make a backup of you data

Re: [Dhis2-users] dhis 2.17 Password Algorithm

2015-01-12 Thread Jason Pickering
regards, Jason Pickering On Mon, Jan 12, 2015 at 8:05 AM, Jason Phillips wrote: > Hi all, > > > > A happy New Year to everyone, and may 2015 be a happy, healthy and > prosperous year for us all! > > > > I know related questions have been asked in the past, but I t

Re: [Dhis2-users] capture events dhis-live 2.17

2015-01-13 Thread Jason Pickering
Hi Simon, I assume this message was to me? :) We will need more information such as 1) Output of the server logs when the operation occurs. 2) Any output from the browser (press F12 to see the JavaScript console) It could potentially be an issue with DHIS2 live, but hard to tell without this e

Re: [Dhis2-users] Combination of categories issue

2015-01-14 Thread Jason Pickering
Hi Enmanuel Just to confirm,you mean that you have 41860 category option combos? This does seem rather extreme. I am not sure if it so much a system issue,but this sounds like an extreme use of the category combination design pattern. Could you explain a bit more about what you are modelling with

Re: [Dhis2-users] [Dhis2-devs] cumulative data in Data Visualizer and Pilot Table

2015-01-21 Thread Jason Pickering
One potentially tricky thing to keep in mind here is the problem of missing data, i.e. if the facility does not report for a month, or they report a zero and the data element is zero insignificant. Normally in time-series data, the "last observation would be carried forward" (LOCF). The spec does n

Re: [Dhis2-users] [Dhis2-devs] cumulative data in Data Visualizer and Pilot Table

2015-01-22 Thread Jason Pickering
t months - the idea was > always that using regression analysis to insert missing values was a > last resort which only could/should be available after several months > (i.e. after all other avenues to get the missing data are exhausted). > > regards > Calle > > On 21/01/2015,

Re: [Dhis2-users] [Dhis2-devs] Problem of importing Element Data

2015-01-30 Thread Jason Pickering
Hi Carlos, You must follow the specification of CSV import exactly, otherwise, it will fail for sure. https://www.dhis2.org/doc/snapshot/en/user/html/ch20.html#d5e2798 Note that the column headers do not matter, rather the order of the columns. Also, you should use UIDs instead of the internal id

Re: [Dhis2-users] Linode hosting-dhis2

2015-02-02 Thread Jason Pickering
Hi Norberto, Did you read the documentation? https://www.dhis2.org/doc/snapshot/en/implementer/html/ch08.html You may also want to use the dhis2-tools package if you are using Ubuntu. https://www.dhis2.org/doc/snapshot/en/implementer/html/ch20.html Regards, Jason On Mon, Feb 2, 2015 at 2:15 P

Re: [Dhis2-users] Version Determination - in Db?

2015-02-05 Thread Jason Pickering
No, not in the DB, but it is available through the API https://www.dhis2.org/doc/snapshot/en/developer/html/ch01s26.html#d5e3487 Regards, Jason On Thu, Feb 5, 2015 at 1:51 PM, Jason Phillips wrote: > Hi all, > > > > Quick question: is there a place in the DHIS2 database where one can > determ

Re: [Dhis2-users] [Dhis2-devs] DHIS name change

2015-02-08 Thread Jason Pickering
Hi Simon, It has been talked about, but remember since DHIS 2 is open source (as well as the documentation), you can conceivably call it whatever you like, even modifying the documentation as well to suit. As has been pointed out on the list before, the acronym is a bit like IBM, who do a lot more

Re: [Dhis2-users] referencing org units in a program stage

2015-02-08 Thread Jason Pickering
Hi Simon, In one instance I helped out with, I created a script to populate the optionvalue table directly with SQL. with data from the organisationunit table. Not really that "standard", as the API could be used. I was not sure if the API would support the optionset property the "sort" attribute,

Re: [Dhis2-users] [Dhis2-devs] DHIS2 - Error message when saving event report as favorite

2015-02-09 Thread Jason Pickering
Hi Robin, It is very difficult to see in this screen shot. Maybe you can copy and paste the text here so that the developers might be able to read what the actual error is? Best regards, Jason On Mon, Feb 9, 2015 at 2:52 PM, Robin Martens wrote: >Dear all, > > We're getting the following

Re: [Dhis2-users] Problem with XML data import

2015-02-24 Thread Jason Pickering
It can be hard to tell.We need much better information here as the log reports are pretty useless. You should probably gather all of your data element ids and check them one by one against whether they are available before attempting an import. This can be done through the API and scripted of cour

Re: [Dhis2-users] Problem with XML data import

2015-02-24 Thread Jason Pickering
edayo > > > Sent from my BlackBerry 10 smartphone. > *From: *Knut Staring > *Sent: *Wednesday, 25 February 2015 07:12 > *To: *Dayo Adeyomoye > *Cc: *Jason Pickering; dhis2-users@lists.launchpad.net > *Subject: *Re: [Dhis2-users] Problem with XML data import > > Thanks,

Re: [Dhis2-users] Issue with Program Stages

2015-03-05 Thread Jason Pickering
Hi Abyot, I took a look at Nick's database, and for some reason, there are programstages which are missing a program. This seems (strangely) to be possible, as the programid in programstage is NULLABLE. Any idea about how this may have happened? Regards, Jason On Thu, Mar 5, 2015 at 9:22 AM, Aby

Re: [Dhis2-users] Issue with Program Stages

2015-03-05 Thread Jason Pickering
ation of the tables. Or > probably, a program is deleted through the UI but the process somehow > failed to remove programstage... but I don't know. > > > --- > Thank you, > Abyot. > > On Thu, Mar 5, 2015 at 9:28 AM, Jason Pickering < > jason.p.picker...@gmail.c

Re: [Dhis2-users] Problem after removing favorites and upgrading

2015-03-08 Thread Jason Pickering
This column was removed at a certain point in time (active on organisationunit). Looks like a downgrade problem to me? Regards, Jason On Sun, Mar 8, 2015 at 3:57 PM, Knut Staring wrote: > I had a database running fine under a 2.17-SNAPSHOT, but wanted to clean > out all favorites (maps, pivots

Re: [Dhis2-users] [Dhis2-devs] Problem while entering dates

2015-03-09 Thread Jason Pickering
Hi Seid, This was a bug reported some time back, but which may have been fixed in subsequent versions. Any chance you can upgrade to 2.18, or at least maybe reproduce the bug on the demo server (apps.dhis2.org/demo) to see if it is still there? Regards, Jason On Mon, Mar 9, 2015 at 7:43 AM, Se

Re: [Dhis2-users] [Dhis2-devs] Problem while entering dates

2015-03-09 Thread Jason Pickering
Here was the bug I mentioned https://bugs.launchpad.net/dhis2/+bug/1300614 Again, not sure it has been fixed. Does not look like it from the bug report. On Mon, Mar 9, 2015 at 8:57 AM, Jason Pickering wrote: > Hi Seid, > > This was a bug reported some time back, but which may have b

Re: [Dhis2-users] Restore a large PostgreSQL dump

2015-03-11 Thread Jason Pickering
Easiest way is to not dump the analytics tables at all. They can be regenerated by running the analytics process once you have restores your database without these tables. Regards, Jason On Mar 11, 2015 5:31 PM, "Ngoni Manika" wrote: > Hi team > > > > I am having a challenge on restoring a pos

Re: [Dhis2-users] [Dhis2-devs] DHIS2 - Validations on GPS coordinates

2015-03-16 Thread Jason Pickering
Hi Robin, I think what Abyot means is that general validation would be something like saying that you could setup a bounding box for the area which you know you are going to receive coordinates. For instance, if the countries latitude is between -18 and -25 degrees, you could setup a rule to ensur

Re: [Dhis2-users] Eliminating data

2015-03-26 Thread Jason Pickering
Hi Joao, It depends on your exact needs, but take a look at the "datavalue" table. Something like DELETE FROM datavalue where sourceid = X and periodid = Y; X should be replaced by the organisationunitid from the organisationunit table for the orgunit you want. Y should be replaced by the part

Re: [Dhis2-users] Eliminating data

2015-03-26 Thread Jason Pickering
out. Regards, Jason On Thu, Mar 26, 2015 at 8:50 AM, Joao Mazuze wrote: > Hi Jason, > > I think I will need also to specify the dataset as I don´t want to delete > data in all the datasets. > > > > Kind regards > > > > *From:* Jason Pickering [mailto:ja

Re: [Dhis2-users] [Dhis2-devs] DHIS2 - Communication error "0" when generating pivot table

2015-03-27 Thread Jason Pickering
Hi Robin, I think this is caused by the reverse proxy (nginx) timing out before Tomcat can actually return a response. You might need to have a smaller (or less complex) table , increase the speed of the machine or database server, or have a look at how to increase the timeout for nginx, for insta

Re: [Dhis2-users] Generating Monthly Indicators

2015-03-29 Thread Jason Pickering
Hi Baakai, Once you have annualized all the indicators which you need to, the effect of caching should resolve itself after the cache expires, which is usually 6AM the next day. What Lars meant was, that if you need to immediately check your results, you should disable caching on the server. Othe

  1   2   3   4   5   6   7   8   >