Re: [Dhis2-users] Integration of Electronic Tuberculosis Management (eTBM) with DHIS2

2017-02-27 Thread Uwe Wahser
Dear Julhas, we are doing something like that (on the aggregate level) in a datawarehouse setting without 0-values, where we have to update whole datasets every night. Basically we download all data with kettle, compare the differences to the incoming data, and then push only changed values b

Re: [Dhis2-users] PostgreSQL-9.5 failed to boot-up at restart of Linux server

2017-01-25 Thread Uwe Wahser
Hi Gerald, we did the upgrade while upgrading to Ubuntu 16.04 and everything starts normally. But you have to manually migrate your 9.3 databases into the 9.5 format - did you do that? These were the bash commands I recorded back then (at your own risk, no guarantee - do backups and all that f

Re: [Dhis2-users] how to set "scheduling automated aggregation"

2017-01-10 Thread Uwe Wahser
Dear Channara, if you want to run aggregations at your own intervals you can trigger them via the web-api /api/25/resourceTables/analytics, e.g. with curl in a cron-job. (I am using a step in kettle after loading data). https://ci.dhis2.org/docs/2.25/en/developer/html/dhis2_developer_manual_ful

Re: [Dhis2-users] API 2.25: Return Full Property Set

2016-12-22 Thread uwe wahser
ut properties with null values. https://google.github.io/styleguide/jsoncstyleguide.xml The only work around: 1. Try using xml format ( if ok with U) 2. You will need to take back missing properties within your codes ( probably your previous work around) On Dec 16, 2016 15:33, &qu

Re: [Dhis2-users] API 2.25: Return Full Property Set

2016-12-16 Thread Uwe Wahser
ey do not exist, as it could drastically increase the size of the payload. That is why they are not included, except where not null. [image: Inline image 1] On Fri, Dec 16, 2016 at 10:41 AM, Uwe Wahser wrote: Hi Jason, simple example: https://play.dhis2.org/demo/api/organisationUnits.json? pa

Re: [Dhis2-users] API 2.25: Return Full Property Set

2016-12-16 Thread Uwe Wahser
hat am 16. Dezember 2016 um > 12:05 geschrieben: > > > Hi Uwe, > Could you give a specific example from the demo server with an API call, > and what is not working as you expect? > > Regards, > Jason > > > On Fri, Dec 16, 2016 at 8:48 AM, Uwe Wahser wrote: &g

Re: [Dhis2-users] API 2.25: Return Full Property Set

2016-12-15 Thread Uwe Wahser
Sorry, on a closer look it only seems to work for empty collections. Properties of the object itself (e.g. email, comments of organizationUnits) are still left out. The floor is open again for other suggestions :-) Regards, Uwe > Uwe Wahser hat am 16. Dezember 2016 um 10:24 geschrie

Re: [Dhis2-users] API 2.25: Return Full Property Set

2016-12-15 Thread Uwe Wahser
6. Dezember 2016 um > 10:13 geschrieben: > > > Hi Uwe > Have a look here > > https://ci.dhis2.org/docs/master/en/developer/html/webapi_metadata_field_filter.html > > and specifically the use of the ?fields=:all paramater. > > Regards, > Jason > > > On Fr

[Dhis2-users] API 2.25: Return Full Property Set

2016-12-15 Thread Uwe Wahser
Dear all, I am having a bit of an issue when querying metadata from the api in json format and further processing them in kettle (Pentaho DI): DHIS2 only returns those properties in the json-package that are not NULL. However, the json converter in kettle needs the full property-set in order to

Re: [Dhis2-users] API: dataSets.dataElements

2016-11-04 Thread Uwe Wahser
a cleaner implementation to have the > api reflect the actual underlying changed model. Not sure. > > > > > > On 3 November 2016 at 14:21, Michael Mwebaze > wrote: > > > Thanks Uwe, > > > > I have been trying to figure this out as well. > > &

Re: [Dhis2-users] API: dataSets.dataElements

2016-11-03 Thread Uwe Wahser
just found the answer myself: it has to be https://play.dhis2.org/demo/api/dataSets/N4fIX1HL3TQ.json?paging=false&fields=dataSetElements[dataElement[id,code,name]] the other question remains: why cant I use the old syntax by adding 24 or 23 to the url? Regards, Uwe --- > Uwe Wahser h

[Dhis2-users] API: dataSets.dataElements

2016-11-02 Thread Uwe Wahser
Dear all, I am a bit confused about the api in 2.25. Before, I was able to list dataElements of a given dataSet via https://play.dhis2.org/demo/api/dataSets/N4fIX1HL3TQ.json?paging=false&fields=dataElements[id,code,name] As I understand from the manual, this has changed to https://play.dhis2.org

Re: [Dhis2-users] Detailed Meta-Data Export in 2.25

2016-10-31 Thread Uwe Wahser
Dear all, that's actually how they do it in other systems in the commercial sector, mainly used to forward changes from development to productive systems: 1 - you first select the type of object for the export (dashboard, map, chart, whatever ...) 2 - then you get a list of possible objects to se

Re: [Dhis2-users] 25 hours in completing Analytic

2016-10-19 Thread Uwe Wahser
Hi Neeraj, not sure about the relevance of this detail: when I upgraded from 9.4 to 9.5 I found out that there was a postgres parameter (wal_buffers) removed from the current DHIS2 implementer's guide (relating to 9.5), which was still in there up to 2.24 (relating to 9.4). Also I had the feeling

Re: [Dhis2-users] long period of analytics

2016-10-12 Thread Uwe Wahser
also I > noticed that analytic period increase when I add new category options to > attribute categories. > > > > Any idea? > > > > From: Knut Staring [mailto:knu...@gmail.com] > Sent: Wednesday, October 12, 2016 3:35 PM > To: Uwe Wahser > Cc: Abdul karim

Re: [Dhis2-users] long period of analytics

2016-10-12 Thread Uwe Wahser
comboname: 437689 rows > > You would seem to have an extraordinary number of category combos. Is this > correct? > > On Wed, Oct 12, 2016, 14:35 Knut Staring wrote: > > > Maybe also test an upgrade? > > > > On 12 Oct 2016 14:22, "Uwe Wahser" wrote:

Re: [Dhis2-users] long period of analytics

2016-10-12 Thread Uwe Wahser
Hi Abdul, I saw that you posted this already a few months ago - without success, as it seems. So let me just take a lucky guess, of what else you could try (that's what I'd try): - in catalina.out, can you identify a specific phase of the analytics run where most of the time is spent or is everyt

[Dhis2-users] 2.24: Link to Implementors Manual broken?

2016-09-19 Thread Uwe Wahser
Dear all, I can't access the 2.24 implementors guide from the dhis2 documentation page (404 Error) - this error comes for both html-links and the pdf. The other 2.24 links seem to work. Is it being updated or is it broken? Regards, Uwe ___ Mailing lis

Re: [Dhis2-users] API: Getting all sub-ordinate organisationUnits from a root

2016-08-11 Thread Uwe Wahser
gt; > > To get descendants (not ancestors), I think you can use > https://play.dhis2.org/dev/api/organisationUnits/O6uvpzGd5pu?fields=id,name&; > *includeDescendants=true*&paging=false > > On Wed, Aug 10, 2016 at 7:51 PM, Uwe Wahser wrote: > > > I think that&

Re: [Dhis2-users] API: Getting all sub-ordinate organisationUnits from a root

2016-08-10 Thread Uwe Wahser
look at the path property? probably you can use > something like ?filter=path:^like:/uid1/uid2/uid3/ to get all ancestors of > a particular org unit > > -- > Morten Olav Hansen > Senior Engineer, DHIS 2 > University of Oslo > http://www.dhis2.org > > On Wed, Au

Re: [Dhis2-users] API: Getting all sub-ordinate organisationUnits from a root

2016-08-10 Thread Uwe Wahser
hat am 10. August 2016 um 18:33 > geschrieben: > > > Dear Uwe, > > api/organisationUnits.json?paging=false&fields=id,name,children[id,name,children[id,name,children[id,name]]] > > Note the inside children[id,name] > > Alex > > On Wed, Aug 10, 2016

[Dhis2-users] API: Getting all sub-ordinate organisationUnits from a root

2016-08-10 Thread Uwe Wahser
Dear all, is there a way to read a certain organisation with all its ancestors on all/specific lower levels via api? Something like the "children" parameter in the dataValueSets api for the organisationUnits api would be helpful ... The alternative would be looping down the hierarchy level by lev

Re: [Dhis2-users] [Dhis2-devs] Default Dashboard map providers

2016-07-14 Thread Uwe Wahser
Confirming this: when updating the favorites, my maps are set back to Google Streets, which I used when creating the map favorites (current version is 2.23, Browser Mozilla). Regards, Uwe > Frank Carrubba hat am 14. Juli 2016 um 18:30 > geschrieben: > > > Hey Dan, > > Thank you for the reply,

Re: [Dhis2-users] [Dhis2-devs] Creation of CategoryOptionCombinations

2016-06-08 Thread Uwe Wahser
e going to be > filled, unless you really have a TON of data. > > Regards, > Jason > > > > On Wed, Jun 8, 2016 at 2:36 PM, Uwe Wahser wrote: > > > Hi Jason, > > > > importing aggregate date into data-sets (see my reply to Lars yesterday > > ev

Re: [Dhis2-users] [Dhis2-devs] Creation of CategoryOptionCombinations

2016-06-08 Thread Uwe Wahser
> >> > 2.24) introducing versioned web-api, so that endpoint importer will be > >> > available until 2.26 (we will support 3 versions). In 2.24, the same > >> > endpoint is available at /api/24/metadata. > >> > > >> > If you are using cURL, or another utilit

Re: [Dhis2-users] Creation of CategoryOptionCombinations

2016-06-08 Thread Uwe Wahser
(we will support 3 versions). In 2.24, the same > > > endpoint is available at /api/24/metadata. > > > > > > If you are using cURL, or another utility.. the import part would be the > > > same, but the UI in 2.23 can not be used, as it's hardcoded to le

Re: [Dhis2-users] Creation of CategoryOptionCombinations

2016-06-07 Thread Uwe Wahser
n not be used, as it's hardcoded to legacy > importer. > > -- > Morten Olav Hansen > Senior Engineer, DHIS 2 > University of Oslo > http://www.dhis2.org > > On Tue, Jun 7, 2016 at 11:25 PM, Uwe Wahser wrote: > > > Hi Morten, > > > > no, i didn'

Re: [Dhis2-users] [Dhis2-devs] Creation of CategoryOptionCombinations

2016-06-07 Thread Uwe Wahser
ersions). In 2.24, the same > > endpoint is available at /api/24/metadata. > > > > If you are using cURL, or another utility.. the import part would be the > > same, but the UI in 2.23 can not be used, as it's hardcoded to legacy > > importer. > > > > --

Re: [Dhis2-users] Creation of CategoryOptionCombinations

2016-06-07 Thread Uwe Wahser
in 2.23 > > On Tuesday, 7 June 2016, Uwe Wahser wrote: > > > Dear devs, > > > > I am experiencing problems when handling category combinations. Our > > protoype > > with 5 dimensions went through the process of generating > > categoryOptionCombinations

[Dhis2-users] Creation of CategoryOptionCombinations

2016-06-07 Thread Uwe Wahser
Dear devs, I am experiencing problems when handling category combinations. Our protoype with 5 dimensions went through the process of generating categoryOptionCombinations (~20.000 records) quite well. 7 dimensions (~400.000) worked as well, although it took a very long time. Now we defined the n

Re: [Dhis2-users] CSV-Import of Organisation unit

2016-06-06 Thread Uwe Wahser
84992,-3.63045]" Regards, Uwe > Diao Diallo hat am 6. Juni 2016 um 19:06 geschrieben: > > > Thanks for your help, but one more detail if i put longitude and latitude > in one single field what will be their separator? > > Thanks again. > > Diao > >

Re: [Dhis2-users] CSV-Import of Organisation unit

2016-06-06 Thread Uwe Wahser
One more thing: latitude and longitude are a string in one single field and have to be accompanied by the feature type. Please compare the import definition from the manual: http://dhis2.github.io/dhis2-docs/2.22/en/developer/html/dhis2_developer_manual_full.html#d4967e995 Good luck! Uwe >

Re: [Dhis2-users] CSV-Import of Organisation unit

2016-06-06 Thread Uwe Wahser
Hi Diao, when importing csv, you have to specify all columns from the interface up to the coordinates with empty fields(,,,): name,uid,code,parentuid,shortname,description,uuid,openingdate,closeddate,comment,feature type,coordinates Your csv is being interpreted as longitude being the description

Re: [Dhis2-users] CSV-Import of Category Options

2016-06-04 Thread uwe wahser
rty to use in analytics" under profile > user settings to control rendering of meta-data in the left side panel. On Thu, Jun 2, 2016 at 11:51 AM, Uwe Wahser <mailto:u...@wahser.de>> wrote: I tried import for category options and that seems to work. However - I can&#x

Re: [Dhis2-users] CSV-Import of Category Options

2016-06-02 Thread Uwe Wahser
chrieben: > > > On Thu, Jun 2, 2016 at 10:27 AM, Uwe Wahser wrote: > > > Sounds good, thank you! What would be the CSV-format? Just another column > > at > > the end? > > > > > Yes, after code. Updated docs now. > > > > > Are the ShortNam

Re: [Dhis2-users] CSV-Import of Category Options

2016-06-02 Thread Uwe Wahser
a fix now in trunk and 2.23 that enables import of short > names for the following objects: > > Category option, data element group, organisation unit group, category > option group. > > regards, > > Lars > > > > On Thu, Jun 2, 2016 at 3:21 AM, Uwe Wahser

[Dhis2-users] CSV-Import of Category Options

2016-06-02 Thread Uwe Wahser
Dear all, category options can take a short name (in addition to name and code) in the Maintenance GUI. However, the csv-format description in the developers manual (1.11.6. Other objects) only gives the option to import name and code, but not the short name. Is that a problem of the manual, or d

Re: [Dhis2-users] Option, option set and dataelement

2016-05-27 Thread Uwe Wahser
Hi Lars, can you kindly verify your explanation about uniqueness of option codes? It would be great if they hadn't to be unique system-wide, but I just tested it on snapshot, and it seems to me that option codes codes must still be unique. Which is in fact not really interesting: this way you can

Re: [Dhis2-users] [Dhis2-devs] catalina logline "Data value import done"

2016-05-25 Thread Uwe Wahser
> Lars > > > On Wed, May 25, 2016 at 2:44 PM, Uwe Wahser wrote: > > > Dear devs, > > > > would it be a big thing to extend the catalina logline "Data value import > > done" > > with the number of values deleted? Currently there is only total

[Dhis2-users] catalina logline "Data value import done"

2016-05-25 Thread Uwe Wahser
Dear devs, would it be a big thing to extend the catalina logline "Data value import done" with the number of values deleted? Currently there is only total, import and update. Batch delete was only introduced recently, that might be the reason why this value is missing. Thanks a lot, Uwe __

Re: [Dhis2-users] 2nd Try: GIS: Filters on Categories

2016-05-20 Thread Uwe Wahser
road map for 2.24 or 2.25, issue here: > > https://github.com/dhis2/dhis2-gis/issues/43 > > regards, > > Lars > > > > On Fri, May 20, 2016 at 12:03 PM, Uwe Wahser wrote: > > > Sorry, I have to post this again, but this is getting a bit of an issue

[Dhis2-users] 2nd Try: GIS: Filters on Categories

2016-05-20 Thread Uwe Wahser
restriction as the use of user-defined dimensions becomes obsolete. Thanks for any hints, Uwe --- Uwe Wahser Thu, 12 May 2016 00:27:07 -0700 Dear all, I am just doing some tests on maps and am a bit confused about filtering: I can't seem to find a way to filter data on categ

Re: [Dhis2-users] Longer frequency on Data Sets

2016-05-12 Thread Uwe Wahser
Dear Terence & DEVs, maybe this can be merged into a blueprint I filed a while ago with encouragement from Lars? https://blueprints.launchpad.net/dhis2/+spec/enhance-date-filter Regards, Uwe --- > Terence Scott hat am 12. Mai 2016 um 10:48 > geschrieben: > > > Dear All > > I am currently

Re: [Dhis2-users] Longer frequency on Data Sets

2016-05-12 Thread Uwe Wahser
le. Together, we can #EndRabiesNow. > Visit EndRabiesNow.org & sign the pledge > <https://endrabiesnow.org/take-action>. > > On Thu, May 12, 2016 at 10:13 AM, Uwe Wahser wrote: > > > Dear Terence & DEVs, > > > > maybe this can be merged into a blueprin

[Dhis2-users] GIS: Filters on Categories

2016-05-12 Thread Uwe Wahser
Dear all, I am just doing some tests on maps and am a bit confused about filtering: I can't seem to find a way to filter data on categories/dimensions other than period and org unit, as I can in pivot tables and visualizer. If this is not possible, that would pose a big problem to my data models,

Re: [Dhis2-users] [Dhis2-devs] Program data into dataset

2016-05-09 Thread Uwe Wahser
Hi Pramil & Lars, actually I think that Pramil is adressing a very valid problem. In my current understanding of DHIS2 I wouldn't be able to propose any better solution than using Lars' analysis api and an external tool (php, r, kettle etc) to read the results and fill them into the datasets. How

Re: [Dhis2-users] [Dhis2-devs] Digit group separator in pivot table - what should the default value be?

2016-05-03 Thread Uwe Wahser
Good point: actually it's not only the digit group for pivot table, but rather [digit group, decimal point, default number of decimals] for any [input, output, import and export] that should be defined in the systems settings. But I fear that the implications on the coding will be much bigger than

Re: [Dhis2-users] dhis 2.23 upgrade

2016-04-26 Thread Uwe Wahser
confirming point 1 on demo and snapshot (Firefox 45.0.2 under Windows 7) Regards, Uwe > Seleman Ally hat am 26. April 2016 um 11:09 > geschrieben: > > > Hi Lars, thanks guys for remarkable job. > > Sorry for jumping to the negative side. I just tried the version 2.23. some > functionalities

[Dhis2-users] Jasper Reports Version in DHIS2.About page

2016-04-13 Thread Uwe Wahser
Dear all, the user manual mentions in "19.4.2.11. Some final guidelines" the need to synchronize the version of the Jasper Report Designer (iReport / Jasper Studio) to the DHIS2 Jasper engine. The information is said to be found on the About page of DHIS2. However, it does not seem to be there. Ha

Re: [Dhis2-users] ETL process with DHIS2

2016-03-24 Thread Uwe Wahser
HI Henri, sorry for for chipping in late, I am on vaccation. We are using kettle for extracting data into DHIS2 as a prototype for a datawarehouse in a corporate setting. A few of Aarons points on Talend apply for kettle as well. Things can get tricky, but that is partly because of the nature of d

Re: [Dhis2-users] Analytics errror

2016-03-13 Thread uwe wahser
Hi Marco, did you clear the cache? (App Browser Cache Cleaner & App Data Administration - Cache Statistics) Hope that helps, Uwe --- Am 13.03.2016 um 17:06 schrieb Marko David Garcia: Hello all. The analytics process finish fine, but doesn't load any values. Dhis version: 2.21 Buil revisio

Re: [Dhis2-users] one to many relation ability- tracker module

2016-03-09 Thread Uwe Wahser
Hi Markus and Abyott, without knowing Hariris use-case I think that he is touching an interesting point about mapping relational data models into the tracker-module. Am I actually able to create relations as in a relational DBMS? Extending Hariris case, could he actually record a patient having mu

Re: [Dhis2-users] [Dhis2-devs] Category combinations are not being generated properly

2016-03-02 Thread Uwe Wahser
Hi Sultan, I have seen this in our system and suppose it comes from old dataValues, that were loaded /entered before I added a new category into an existing categoryCombination. The old values were still coded on the old categoryOptionCombinations where the new category was missing. I assume that

Re: [Dhis2-users] API-Response from api/dataValueSets

2016-02-12 Thread Uwe Wahser
I just saw that Bob already filed a very useful Blueprint for something like this in 2014 (https://blueprints.launchpad.net/dhis2/+spec/detailed-import-summary) Has there any work been done on this so far, as the check for future dates obviously does something like this? > Uwe Wahser hat am

[Dhis2-users] API-Response from api/setDataValues

2016-02-11 Thread Uwe Wahser
Dear all, when importing dataValues into DHIS2 via api/setDataValues I get a certain number of values that are being ignored. Is there a api-parameter that can give me a more detailed feedback in the response than just the number of ignored values? I remember that I always got an error-message w

Re: [Dhis2-users] Disaggregation and Filtering of dates in Pivot-Tables

2016-02-08 Thread Uwe Wahser
ot;Last X days", but it > could of course be added. > > Maybe you can file a blue-print? > > Regards, > Jason > > > On Mon, Feb 8, 2016 at 1:28 PM, Uwe Wahser wrote: > > > Dear all, > > > > in our installation we store dataValues wit

[Dhis2-users] Disaggregation and Filtering of dates in Pivot-Tables

2016-02-08 Thread Uwe Wahser
Dear all, in our installation we store dataValues with a daily granularity. Now I want to create a pivot table which displays all dataValues for all the days of the current or last week or month. I want to do this only once with a relative time-period filter (not by selecting the single dates ever

Re: [Dhis2-users] Importing Org Units

2016-02-07 Thread Uwe Wahser
Hi Alistairs, you can import org-units in csv format as described here: http://dhis2.github.io/dhis2-docs/master/en/developer/html/ch01s11.html#d5e995 If you specify the UIDs, please be aware to use only NumChars without spaces etc. [A-Za-z0-9] starting with a Char. Length is exactly 11 chars, no

Re: [Dhis2-users] Importing DHS survey data in DHIS

2016-02-02 Thread Uwe Wahser
is going to be faster to produce dxf > > style categoryoptioncombos as that is closest to the way the data gets > > stored. I am going to speed up the adx import code, but will still > > always be slower :-) > > > > On 2 February 2016 at 20:07, uwe wahser wrote:

Re: [Dhis2-users] Importing DHS survey data in DHIS

2016-02-02 Thread uwe wahser
re. Regards Jason On Tue, Feb 2, 2016, 17:04 Uwe Wahser mailto:u...@wahser.de>> wrote: Hi Jason, thanks for sharing the links. As I can see on a quick glance, you are also experimenting with the ADX-api - did you observe any s

Re: [Dhis2-users] Importing DHS survey data in DHIS

2016-02-02 Thread uwe wahser
least with far more data. I image that with household surveys, it would be a matter of < 100 indicators for < 200 orgunits for 2-3 periods, i.e. a fraction of what you are dealing with! Olav 31. jan. 2016 kl. 09.29 skrev uwe wahser mailto:u...@wahser.de>>:

Re: [Dhis2-users] Importing DHS survey data in DHIS

2016-02-02 Thread Uwe Wahser
e working on > >> sounds quite a bit more complicated, and not least with far more data. I > >> image that with household surveys, it would be a matter of < 100 indicators > >> for < 200 orgunits for 2-3 periods, i.e. a fraction of what you are dealing > >> with

Re: [Dhis2-users] Importing DHS survey data in DHIS

2016-02-02 Thread Uwe Wahser
s, i.e. a fraction of what you are dealing > > with! > > > > Olav > > > > > > > > > > > > > > 31. jan. 2016 kl. 09.29 skrev uwe wahser : > > > > Hi Olav & Randy, > > > > I am currently banging on kettle (aka Pentaho DI

Re: [Dhis2-users] Importing DHS survey data in DHIS

2016-01-31 Thread uwe wahser
Hi Olav & Randy, I am currently banging on kettle (aka Pentaho DI) to extract data from a source-system (SQL-ERP in our case) into DHIS2 dataSets in json format. In our current test-scenario (2 dataElements in a dataSet with a categoryCombination of 5 categories) we are currently updating ca.

Re: [Dhis2-users] How to disaggregate percent indicator by gender

2016-01-26 Thread Uwe Wahser
If I understand correctly, this still wouldn't make the categoryCombinations on dataSets accessible. I'd prefer a filter function on categories in the indicator-editor. This would be more flexible and allow for a free combination of categories to be filtered without creating an abundance of unused

Re: [Dhis2-users] Nightly Batch-Jobs

2016-01-25 Thread Uwe Wahser
this task is ran (or if it is ran at > all) this is not in place yet but will be more flexible in future versions. > As said, though, it really should not affect your use case at all. > > Hope that answers your question. Thanks for reporting! > > Halvdan Grelland, DHIS 2 Core d

[Dhis2-users] Nightly Batch-Jobs

2016-01-25 Thread Uwe Wahser
Dear all, since we are doing nightly data-loads into DHIS2 with a 3rd party ETL-tool, we are obliged to control the DHIS2 background jobs as much as possible via api to avoid conflicts with the loading processes. Although I turned of all of the batch-functionalities in Maintenance-Scheduling, the

[Dhis2-users] Filters and re-usability for Indicators

2016-01-22 Thread Uwe Wahser
Dear all, in my current approach for feeding DHIS2 with data from a source system, I rely heavily on Categories / CategoryCombinations as dimensions for a DataSet (E.g. DataElement: NumberOfBalls, Dimension: Color of Balls[red,blue,green]). From a data-modelling perspective this is much more flexi

Re: [Dhis2-users] dhis version 2.22 is released

2016-01-19 Thread uwe wahser
Wooopeee! Batch-delete! Works fine - thanks a lot! Uwe Am 16.01.2016 um 01:02 schrieb Lars Helge Øverland: Hi all, DHIS version 2.22 is out with a lot of great new features and improvements. Log in with admin/district on the demo system. Data elements and

Re: [Dhis2-users] yoda says: daylight savings time gap it has

2016-01-14 Thread Uwe Wahser
Hi Morten, I applied the new build and it works. Just copied the war-file in and ran the analytics again - now reloading needed. Thanks a lot (also to Jason) - another example of the speedy problem solving cycle in Oslo :-) Regards, Uwe --- > Morten Olav Hansen hat am 14. Januar 2016 um 14:3

[Dhis2-users] yoda says: daylight savings time gap it has

2016-01-13 Thread Uwe Wahser
Dear all, happy new year and success for your projects, especially for those that are focusing on DHIS2! I am experiencing a yoda error when running the analytics table update (See below excerpt from java-dump). I saw the error earlier when trying to delete the analytics tables, but now (after st

Re: [Dhis2-users] Unit Level

2016-01-11 Thread Uwe Wahser
Hi Charles, if you add a new unit as child to a unit on the lowest level, DHIS2 will create the new level automatically. You'll just have to give it a name in the level-editor. Greetings, Uwe --- > charles waka hat am 11. Januar 2016 um 09:00 geschrieben: > > > Hi DHIS2 users, > > I want to

Re: [Dhis2-users] Org unit is being unassigned after edit

2016-01-04 Thread uwe wahser
Just to support: I saw the same in 2.21 Am 31.12.2015 um 07:31 schrieb Hannan Khan: Dear All Happy new year. Sorry to disturb you all during this holidays, but this is urgent. When ever we are editing orgunit, correct the spelling, code etc., all it data sets are become unassigned. so we ha

Re: [Dhis2-users] Category Option Combo

2015-12-23 Thread Uwe Wahser
Hi Nami, did you check catalina.out for error messages pointing at memory shortages? Just guessing ... Uwe > Nami Ghadri hat am 23. Dezember 2015 um 09:30 > geschrieben: > > > Hi Lars, > > > > In the maintenance when I preform maintenance to “Update category option > combinations” it kee

[Dhis2-users] iReports vs Jaspersoft Studio

2015-12-21 Thread Uwe Wahser
Dear all, according to the user manual, Jaspersofts iReport is the suggested tool for creating formatted reports to integrate into DHIS2 standard reporting. According to the iReports website (http://community.jaspersoft.com/project/ireport-designer), Jaspersoft is about to replace iReports with

Re: [Dhis2-users] [Dhis2-devs] Changed CSV-Format for OrgUnits

2015-12-18 Thread Uwe Wahser
ml> , so that > several the "predefined options" changed: > > Feature typeNoNONE | MULTI_POLYGON | POLYGON | POINT | SYMBOLGeospatial > feature type. > > > In general, uids must be 11 alphanumerics, letter first. Please have a look > at that link, try again and l

Re: [Dhis2-users] [Dhis2-devs] Changed CSV-Format for OrgUnits

2015-12-17 Thread Uwe Wahser
umns - you can drop > > anything at the end, but must include extra commas if you have blank > > columns in between relevant columns. > > > > 2. All UIDs must be 11 characters, and starting with a letter (NOT a > > digit). > > > > Regards > > Calle > &

Re: [Dhis2-users] Changed CSV-Format for OrgUnits

2015-12-16 Thread Uwe Wahser
update inline > Uwe Wahser hat am 17. Dezember 2015 um 06:23 geschrieben: > > > Dear all, > > according to a previous post on the users list there have obviously been > changes > in the CSV-format for importing OrgUnits. Some have been documented, others &

[Dhis2-users] Changed CSV-Format for OrgUnits

2015-12-16 Thread Uwe Wahser
Dear all, according to a previous post on the users list there have obviously been changes in the CSV-format for importing OrgUnits. Some have been documented, others not (or might be bugs): - feature format seems to be mandatory now. I don't know whether that makes sense, if it does, please indi

Re: [Dhis2-users] API: Mass-deleting data values

2015-12-10 Thread uwe wahser
's much harder to correct. It might be worthwhile to rethink this security feature. Regards, Uwe Am 02.12.2015 um 20:12 schrieb Lars Helge Øverland: On Wed, Dec 2, 2015 at 6:01 PM, Uwe Wahser <mailto:u...@wahser.de>> wrote: That's cheating :-D True What do

Re: [Dhis2-users] Use of Periods

2015-12-10 Thread uwe wahser
eselecting the years, the years will be inserted on the left list into the quarters. This is quite confusing for the user and a source of error when having long value lists. Regards, Uwe > Lars Helge Øverland mailto:larshe...@gmail.com>> hat am 3. Dezember 2015 um 15:27 >

Re: [Dhis2-users] API - update dataElement definitions

2015-12-07 Thread Uwe Wahser
/metaData > endpoint. If using XML you must wrap your payload in in that > case. > > https://www.dhis2.org/doc/snapshot/en/developer/html/ch01s06.html > > regards, > > Lars > > > > > > > > On Mon, Dec 7, 2015 at 8:24 AM, Uwe Wahser wrote:

[Dhis2-users] API - update dataElement definitions

2015-12-06 Thread Uwe Wahser
Dear all, I am currently trying to change properties of existing DataElements via api (esp. zeroIsSignificant). From the documentation I understand that I have to read all significant metadata of the existing DataElement, change my property and then push everything back via POST or PUT methods on

Re: [Dhis2-users] Use of Periods

2015-12-03 Thread Uwe Wahser
ther categories have a check box for selecting all possible values - is there a reason, that this is not possible for periods? If no, can I file a blueprint? Regards, Uwe > Lars Helge Øverland hat am 3. Dezember 2015 um 15:27 > geschrieben: > > > On Thu, Dec 3, 2015 at 3:20 PM

Re: [Dhis2-users] Use of Periods

2015-12-03 Thread Uwe Wahser
rt (as part of a regular > dataValueSet), you can format your date (as e.g. 19850401) and import as > routine data. > > > > regards, > > Lars > > > > > > > > > On Thu, Dec 3, 2015 at 2:31 PM, Uwe Wahser wrote: > > > Dear all,

[Dhis2-users] Use of Periods

2015-12-03 Thread Uwe Wahser
Dear all, I understand that the period-dimension for data entry and analysis traditionally comes from the reporting periods, along which routine summary reports are entered into the system. In our setting, where we want to load aggregated data from relational data base systems into DHIS2 data-set

Re: [Dhis2-users] CategoryOptions: Unique Codes and Names

2015-12-02 Thread Uwe Wahser
up a better solution. On 30 November 2015 at 11:04, Uwe Wahser <u...@wahser.de> wrote: > Dear all, > > > as far as I see CategoryOptions right now, codes and short names of > CategoryOptions must be defined globally unique. If I want to code > gender-male as “M”, I cannot co

Re: [Dhis2-users] API: Mass-deleting data values

2015-12-02 Thread Uwe Wahser
is to simply use a SQL statement to accomplish it. Is that an option for you?regards,LarsOn Wed, Dec 2, 2015 at 5:44 PM, Uwe Wahser <u...@wahser.de> wrote:Dear all,currently I am looking at ways of deleting larger amounts of DataValues based on their dimensions OrgUnit, Period, Data

[Dhis2-users] API: Mass-deleting data values

2015-12-02 Thread Uwe Wahser
Dear all,currently I am looking at ways of deleting larger amounts of DataValues based on their dimensions OrgUnit, Period, DataElement AND AttributeOptionCombination. the main purpose is to invalidate old values on AttributeOptionCombinations, which no there are no more values in an updated sour

[Dhis2-users] CategoryOptions: Unique Codes and Names

2015-11-30 Thread Uwe Wahser
Dear all,as far as I see CategoryOptions right now, codes and short names of CategoryOptions must be defined globally unique. If I want to code gender-male as “M”, I cannot code another “M” for approach-multilateral. In the same way, numbered codes are also not possible for multiple categories, u

[Dhis2-users] CategoryOptionCombos: Confusing behavior with shared options

2015-11-30 Thread Uwe Wahser
Dear all, this might be a result of me misunderstanding the concept of CategoryCombos and CategoryOptionCombos, but this is strange: when I share options between two categories which are members of the same CategoryCombo, the generation of CategoryOptionCombos seems to produce funny results. I ju

Re: [Dhis2-users] API for reading categoryOptions per categoryOptionCombo

2015-11-25 Thread uwe wahser
elge Øverland wrote: Hi Uwe, try using field filtering like this: https://play.dhis2.org/demo/api/categoryCombos/O4VaNks6tta.json?fields=id,categoryOptionCombos[categoryOptions[id,code,name]] Docs here. regards, Lars On Wed, Nov 25, 2015 at 10:52 AM, Uwe Wahser wrote: Dear all, I a

[Dhis2-users] API for reading categoryOptions per categoryOptionCombo

2015-11-25 Thread Uwe Wahser
Dear all,I am experimenting with the DHIS2-api within the context of loading bigger amounts of external data into a DHIS2 dataSet. At on point I need the codes of all categoryOptions involved in all categoryOptionCombos of a categoryCombo of a dataSet in order to join them against the codes in my

Re: [Dhis2-users] dataValues api still functioning?

2015-11-19 Thread uwe wahser
to add this header to the request (in curl): -H "Accept:text/plain" regards, Lars On Wed, Nov 18, 2015 at 3:47 PM, Uwe Wahser mailto:u...@wahser.de>> wrote: Dear all, I tried to use the dataValues resource to delete single values

[Dhis2-users] dataValues api still functioning?

2015-11-18 Thread Uwe Wahser
stics not acceptable according to the request “accept” headers." I get the same response when running the example from the developers manual directly against the demo-server. Version: DHIS 2.21 on standard Ubuntu 14.04 with Oracle Java 8 - the log is attached. Thanks, UweC:\Users\Uwe Wahser&g

Re: [Dhis2-users] Easy way to import indicators into new database

2015-10-12 Thread uwe wahser
sorry, this got cut off by the web-mailer - next try: Wouldn't it be good to have a repository of standard and best practice indicators, data elements, classifications and data-sets per health-program as down-loadable packages for easy import into a fresh DHIS2 installation? In my maybe naive

Re: [Dhis2-users] Easy way to import indicators into new database

2015-10-12 Thread Uwe Wahser
Hi Arthur,sorry, no indicators from my side. I'd just like to use the occasion to advocate again the idea of maintaining a content repository for DHIS2, which would have been handy in your case:Wouldn't it be good to have a repository of standard and best practice indicators, data elements and>Th

Re: [Dhis2-users] [Dhis2-devs] Fiscal quarters crossing calendar years

2015-09-03 Thread Uwe Wahser
Good morning Seid,I don't have to much experience with DHIS2 itself, but would it be a solution for you to use your own attributes for reporting periods when entering data?I have seen this in other BI systems, where they'd think of a reporting period not as something that has to be derived from a