[Dhis2-devs] Android data capture APK archives

2016-05-02 Thread Raminosoa Rabemanantsoa, Tantely
Hello everyone, I am looking for archive versions of the android data capture app APK. Could you please provide a link for a download of that? I am using DHIS2 2.19. Thanks. -- *Tantely Raminosoa* *Data Officer* Management Sciences for Health Antananarivo Madagascar Mobile: 0321180040 E-mail: t

Re: [Dhis2-devs] [Dhis2-users] Android data capture APK archives

2016-05-02 Thread Raminosoa Rabemanantsoa, Tantely
assist you if you want to use the app from Google Play, but > then we need login credentials to your DHIS2 instance so we can see what is > failing. > > Regards, > Erling > > On Mon, May 2, 2016 at 11:31 AM, Raminosoa Rabemanantsoa, Tantely < > tramino...@mikolo.org> wr

Re: [Dhis2-devs] [Dhis2-users] Android data capture APK archives

2016-05-02 Thread Raminosoa Rabemanantsoa, Tantely
llo Raminosoa, > Have you tried the one on Google Play? I think that one should work for > 2.19 > > Regards, > Erling > > On Mon, May 2, 2016 at 11:08 AM, Raminosoa Rabemanantsoa, Tantely < > tramino...@mikolo.org> wrote: > >> Hello everyone, >> >> I

Re: [Dhis2-devs] [Dhis2-users] Android data capture APK archives

2016-05-03 Thread Raminosoa Rabemanantsoa, Tantely
Level4 <- Datasets assigned. > > Regards, > Sultan Ahamar. > > On Mon, May 2, 2016 at 3:12 PM, Raminosoa Rabemanantsoa, Tantely < > tramino...@mikolo.org> wrote: > >> Thank you in advance for your support. >> >> Regards, >> Tantely. >&g

[Dhis2-devs] OrgUnit conflicts

2016-05-19 Thread Raminosoa Rabemanantsoa, Tantely
Hi All, I would like to have your advice on how to fix the following issues: - The first point is that after the creation of users who are entering data through DHIS2 data capture, each of them has the following warning (409 conflict) when logging in the web interface mentioning that the user i

Re: [Dhis2-devs] [Dhis2-users] OrgUnit conflicts

2016-05-19 Thread Raminosoa Rabemanantsoa, Tantely
Thank you Lars for those information. Regards, Tantely. On Thu, May 19, 2016 at 3:17 PM, Lars Helge Øverland wrote: > Hi Tantely, > > On Thu, May 19, 2016 at 10:40 AM, Raminosoa Rabemanantsoa, Tantely < > tramino...@mikolo.org> wrote: > >> Hi All, >> >>

Re: [Dhis2-devs] [Dhis2-users] Failure with Analytics tables update

2016-06-17 Thread Raminosoa Rabemanantsoa, Tantely
Hi All, Thank you for your points of view. I am just wondering on this disk capacity issue. We are using a cloud Amazon Web services to host the DHIS2 application. There are 80 gigabyte disk space used only by DHIS2. There are 30 gigabyte of RAM where 9 GB are for JVM and 9 GB for postgreSQL. My

Re: [Dhis2-devs] [Dhis2-users] Failure with Analytics tables update

2016-06-19 Thread Raminosoa Rabemanantsoa, Tantely
apacity. >> >> If you have plentiful physical capacity on the disk you could have a look >> at >> https://www.postgresql.org/docs/9.5/static/runtime-config-resource.html >> >> Specifically see section 18.4.2 which addresses the temp_file_limit. >> >> Als

[Dhis2-devs] DHIS2 SQL View - practical examples

2016-07-05 Thread Raminosoa Rabemanantsoa, Tantely
Hi All, I am looking for a documentation of the use of the SQL syntax to run in SQL View (table names, field names specific to DHIS2 ). I have seen for example to query organization unit, we have to select from “ou” or to use “dv” to select the datavalues. I am planning to list all the uid, code

Re: [Dhis2-devs] DHIS2 SQL View - practical examples

2016-07-05 Thread Raminosoa Rabemanantsoa, Tantely
> Knut > > On Tue, Jul 5, 2016 at 9:13 AM, Raminosoa Rabemanantsoa, Tantely < > tramino...@mikolo.org> wrote: > >> Hi All, >> >> >> I am looking for a documentation of the use of the SQL syntax to run in >> SQL View (table names, field names speci

Re: [Dhis2-devs] [Dhis2-users] DHIS2 SQL View - practical examples

2016-07-05 Thread Raminosoa Rabemanantsoa, Tantely
/html/ch22s06.html > > Regards, > > Michael > > On 5 July 2016 at 04:45, Raminosoa Rabemanantsoa, Tantely < > tramino...@mikolo.org> wrote: > >> Thank you Knut for your suggestion. >> >> Regards, >> >> Tantely. >> >> On Tue, Ju

[Dhis2-devs] Questionnaires automatically un-assigned

2016-07-06 Thread Raminosoa Rabemanantsoa, Tantely
Hi All, With DHIS2 2.19, something strange is happening on the questionnaire assignation. Some organization units have a status of non-assigned questionnaire after the assignation of all questionnaires to all organisation units. That was happening three times and we are wondering what may cause t

[Dhis2-devs] Creating dropdown field

2016-07-12 Thread Raminosoa Rabemanantsoa, Tantely
Hi there, I would like to insert a field which is expecting one of the three values "yes", "no", "not applicable" within a questionnaire in DHIS2 2.19. I am asking if someone has already done something similar without using the yes/no field type. Thank you for your support. Regards, Tantely. -

Re: [Dhis2-devs] [Dhis2-users] Creating dropdown field

2016-07-12 Thread Raminosoa Rabemanantsoa, Tantely
when you create a data element choose that option set. > > Regards > > On Wed, Jul 13, 2016 at 9:11 AM, Raminosoa Rabemanantsoa, Tantely < > tramino...@mikolo.org> wrote: > >> Hi there, >> >> I would like to insert a field which is expecting one of

[Dhis2-devs] Zero reporting rates for dataset with imported data values

2016-07-13 Thread Raminosoa Rabemanantsoa, Tantely
Hi All, I have imported a large amount of data values by uploading via csv file with monthly periods of a specific dataset (with DHIS 2.19). I thought that when calculating the reporting rate of this dataset, the report should return the number of actual reports containing values that I have just

Re: [Dhis2-devs] Zero reporting rates for dataset with imported data values

2016-07-13 Thread Raminosoa Rabemanantsoa, Tantely
r a particular OU and period: >> http://dhis2.github.io/dhis2-docs/master/en/developer/html/ch01s25.html >> >> Here is more on completeness: >> >> http://www.uio.no/studier/emner/matnat/ifi/INF5761/v13/undervisningsmateriale/step-by-step-lab-instructions---completen

Re: [Dhis2-devs] Zero reporting rates for dataset with imported data values

2016-07-13 Thread Raminosoa Rabemanantsoa, Tantely
Great. Thanks! Tantely. On Wed, Jul 13, 2016 at 12:38 PM, Knut Staring wrote: > Sourceid = Organisaitonunitid. This is an unfortunate historical naming. > > Knut > > On Wed, Jul 13, 2016 at 11:19 AM, Raminosoa Rabemanantsoa, Tantely < > tramino...@mikolo.org> wrote: &g

[Dhis2-devs] Output from Orgunits and Orgunits Group

2016-07-14 Thread Raminosoa Rabemanantsoa, Tantely
Dear All, I am asking if someone has already done, in the pivot table, a single display of the list of organization units with the name of the organization unit group where they belong to. In pivot table, I have used the “select groups” in the selection mode during the selection of the organizatio

[Dhis2-devs] Disable/Enable data editing in DHIS2 dataset

2016-07-20 Thread Raminosoa Rabemanantsoa, Tantely
Hi All, Does someone have experimented disabling data editing after a certain period, let us say 2 weeks after the data entry in a dataset? Then how did you do then to allow some users do the editing of certain data values (after data quality assessments), once the editing has been disabled? Th

Re: [Dhis2-devs] Disable/Enable data editing in DHIS2 dataset

2016-07-20 Thread Raminosoa Rabemanantsoa, Tantely
days has expired, the data > set will be locked for further entry. You can set manual exceptions to this > using the lock exception functionality in data administration module. > Regards, > Jason > > > On Wed, Jul 20, 2016 at 3:03 PM, Raminosoa Rabemanantsoa, Tantely < &

[Dhis2-devs] Connect to DHIS2 with slow internet connection

2016-07-21 Thread Raminosoa Rabemanantsoa, Tantely
Hi All, I am just wondering if, in addition to the database memory tuning of DHIS2, is there an additional parameter to check in the server to allow the users of "DHIS2 data capture" to log in and download datasets and then send the entered data easily even with slow internet connection? Sometimes

[Dhis2-devs] Update datavalues / metadata from SQL

2016-07-21 Thread Raminosoa Rabemanantsoa, Tantely
Hi All, I am looking for links or documentations on interacting with DHIS2 database from the SQL Shell commands. For instance, when I would like to UPDATE, DELETE or ADD some records values, do I only run the SQL command on the "datavalue" table or also on all linked tables? Same thing when making

[Dhis2-devs] Store external spreadheet-like data in DHIS2

2016-07-25 Thread Raminosoa Rabemanantsoa, Tantely
Dear Community, I would like to use DHIS2, in addition to its classic uses (data capture, data analysis and reporting,...), to store a tabular data that is sourced from MS Excel spreadsheet (or probably from another database) without any link to organization unit, period or dataset. Would it be po

Re: [Dhis2-devs] Store external spreadheet-like data in DHIS2

2016-07-25 Thread Raminosoa Rabemanantsoa, Tantely
resources. Data stored there however will not be available for visualization or other analytics. Regards, Jason On Mon, Jul 25, 2016 at 4:43 PM, Raminosoa Rabemanantsoa, Tantely < tramino...@mikolo.org> wrote: > Dear Community, > > I would like to use DHIS2, in addition to its c

Re: [Dhis2-devs] Store external spreadheet-like data in DHIS2

2016-07-26 Thread Raminosoa Rabemanantsoa, Tantely
l the >>> metadata is in DHIS2 or if not, create them. >>> >>> Knut >>> >>> On Mon, Jul 25, 2016 at 10:23 PM, Raminosoa Rabemanantsoa, Tantely < >>> tramino...@mikolo.org> wrote: >>> >>>> Hi Jason, >>>> >>>

[Dhis2-devs] DHIS2 - Reporting rate + count of the submitted reports.

2016-07-27 Thread Raminosoa Rabemanantsoa, Tantely
Dear All, Does someone have some suggestions on having the number of submitted report as output in addition to the rate value itself? I am using the pivot table reporting rates and the option "count" and "sum" all give only the reporting rate value. Thank you for your advice. Tantely. -- *This

Re: [Dhis2-devs] [Dhis2-users] DHIS2 - Reporting rate + count of the submitted reports.

2016-07-27 Thread Raminosoa Rabemanantsoa, Tantely
our answer. Regards, Tantely. On Wed, Jul 27, 2016 at 12:39 PM, Prosper BT wrote: > Hi Raminosoa, > > Which version are you using, It a new feature in 2.24 - pivot tables, see > below > > [image: Inline image 1] > > Regards > > On Wed, Jul 27, 2016 at 10:32 AM, Rami

Re: [Dhis2-devs] [Dhis2-users] DHIS2 - Reporting rate + count of the submitted reports.

2016-07-27 Thread Raminosoa Rabemanantsoa, Tantely
Regards > > > On Wed, Jul 27, 2016, 1:00 PM Raminosoa Rabemanantsoa, Tantely < > tramino...@mikolo.org> wrote: > >> Hi Prosper, >> >> I am using DHIS2 2.19. Yes, this display is not yet integrated in the >> reporting rate from pivot table but they are al

[Dhis2-devs] Dataset Assignation programmatically

2016-08-05 Thread Raminosoa Rabemanantsoa, Tantely
Dear All, I would like to ask if someone has already experinced a batch assignation of dataset to organization units directly in DHIS2 database? I have 10 datasets to assign to a thousands of orguints (which will vary in time) and it will be time consuming if using the Data Set Assignment Editor

Re: [Dhis2-devs] Dataset Assignation programmatically

2016-08-05 Thread Raminosoa Rabemanantsoa, Tantely
cache or restart. >> >> You should also consider an upgrade, as you are a lot of versions behind >> now... >> >> Knut >> >> On Fri, Aug 5, 2016 at 11:35 AM, Raminosoa Rabemanantsoa, Tantely < >> tramino...@mikolo.org> wrote: >> >>

Re: [Dhis2-devs] Dataset Assignation programmatically

2016-08-05 Thread Raminosoa Rabemanantsoa, Tantely
to work with > the API. Have you had a look there? > > This is a good start. > > http://dhis2.github.io/dhis2-docs/2.22/en/developer/html/ch01s10.html > > > > On Fri, Aug 5, 2016 at 12:48 PM, Raminosoa Rabemanantsoa, Tantely < > tramino...@mikolo.org> wrote: >

[Dhis2-devs] Coordinates capture in DHIS2

2016-08-20 Thread Raminosoa Rabemanantsoa, Tantely
Hi All, Is there anyone using DHIS2 2.19 who already developped a form that automatically capture geographic coordinates in DHIS2? Thank you for sharing your experiences. Regards, Tantely. -- *This message and its attachments are confidential and solely for the intended recipients. If receiv

[Dhis2-devs] Groups - Tables

2016-09-11 Thread Raminosoa Rabemanantsoa, Tantely
Dear Members, I am looking for 3 database tables: 1- the table where are stored all organization units groups with the list of their members. 2- the table where are stored the datasets assigned to the organization units 3- the table where are stored the organization units assigned to all users D

Re: [Dhis2-devs] Groups - Tables

2016-09-12 Thread Raminosoa Rabemanantsoa, Tantely
manually. Its much > better to use the API. > > > Regards, > Jason > > > > On Mon, Sep 12, 2016 at 7:52 AM, Raminosoa Rabemanantsoa, Tantely < > tramino...@mikolo.org> wrote: > >> Dear Members, >> >> I am looking for 3 database tables: >>

[Dhis2-devs] DHIS2 Network Out

2016-09-12 Thread Raminosoa Rabemanantsoa, Tantely
Hi All, We are using DHIS2 2.19 and it was working really fine for several months. We have followed the HISP recommendations for the JVM parameters and the PostgreSQL memory tunning. We noticed few days ago a slow access to our DHIS2 server on Amazon from web version as well as from data capture.

Re: [Dhis2-devs] [Dhis2-users] DHIS2 Network Out

2016-09-12 Thread Raminosoa Rabemanantsoa, Tantely
cur? > > On Mon, Sep 12, 2016 at 4:37 PM, Raminosoa Rabemanantsoa, Tantely < > tramino...@mikolo.org> wrote: > >> Hi All, >> >> We are using DHIS2 2.19 and it was working really fine for several months. >> We have followed the HISP recommendations for the J

Re: [Dhis2-devs] Groups - Tables

2016-09-12 Thread Raminosoa Rabemanantsoa, Tantely
e > > 3- the table where are stored the organization units assigned to all users > > \d usermembership > > You should not really try and update these tables manually. Its much > better to use the API. > > > Regards, > Jason > > > > On Mon, Sep 12, 2016 at 7

Re: [Dhis2-devs] [Dhis2-users] DHIS2 Network Out

2016-09-13 Thread Raminosoa Rabemanantsoa, Tantely
) to tomcat > process if you have more. > Note that if you increase your postgres connections, pay attention to > memory settings you set as you can easily run out of memory too. > > Alex > > > On Mon, Sep 12, 2016 at 6:13 PM, Raminosoa Rabemanantsoa, Tantely < > tramin

[Dhis2-devs] DHIS2 2.19 Data entry unable to load DataSet

2016-09-20 Thread Raminosoa Rabemanantsoa, Tantely
Hi All, I would like to have your advice on troubleshooting these issues: -In the DHIS2 data entry web module, once an OrgUnit is selected, any DataSet could not be loaded (running loading status eternally) -In the Android data capture, the user is loading the list of OrgUnits for a very long ti

[Dhis2-devs] Interpret and troubleshoot log-ERROR

2016-09-21 Thread Raminosoa Rabemanantsoa, Tantely
Dear DHIS2 Community, I have this kind of errors (cf. attached file) which are repeating all the timein the DHIS2 log file. Could you please explain what may cause them and how to troubleshoot? The DHIS2 webapp is running fine, but we should be aware of any kind of error happening in the log file

Re: [Dhis2-devs] [Dhis2-users] Interpret and troubleshoot log-ERROR

2016-09-21 Thread Raminosoa Rabemanantsoa, Tantely
, *meunit...@gmail.com > *"HealthInformation Management - Making a World of Difference”* > > > > ---------- > *From:* Knut Staring > *To:* "Raminosoa Rabemanantsoa, Tantely" > *Cc:* DHIS 2 Users list ; DHIS 2 > Developers list > *Se

[Dhis2-devs] Merge orgUnits DHIS2 2.24

2017-01-09 Thread Raminosoa Rabemanantsoa, Tantely
Dear community, I do not find the way to merge multiple orgUnits into a single one in DHIS2 2.24. Do you have suggestions on doing this manually or via web API? Best, Tantely. -- *This message and its attachments are confidential and solely for the intended recipients. If received in error, p

[Dhis2-devs] Merge multiple orgUnits DHIS2 2.24

2017-01-09 Thread Raminosoa Rabemanantsoa, Tantely
Dear community, Do you find the way to merge multiple orgUnits into a single one in DHIS2 2.24. Do you have suggestions on doing this manually or via web API? Best, Tantely. -- *This message and its attachments are confidential and solely for the intended recipients. If received in error, ple

Re: [Dhis2-devs] [Dhis2-users] Merge multiple orgUnits DHIS2 2.24

2017-01-10 Thread Raminosoa Rabemanantsoa, Tantely
gt; resources/sql/delete_site_with_data.sql > > You may need to make some changes to these scripts to suit your version, > but we have used them on a few different production systems with success. > > Hope this helps. > > Regards, > Jason > > > On Tue, Jan 10, 2017 a

[Dhis2-devs] SQL View to output all levels of orgUnits

2017-01-10 Thread Raminosoa Rabemanantsoa, Tantely
Dear Community, I am trying to output a list of all the orgUnits from the SQLView (DHIS2 2.24). I would like to have all the information of all the levels of the orgUnits for each of the 6 levels implemented. I would like to have a result in the following form: orgUnitName (level6), orgUnitName

Re: [Dhis2-devs] [Dhis2-users] SQL View to output all levels of orgUnits

2017-01-11 Thread Raminosoa Rabemanantsoa, Tantely
ou6.shortname as ou6_shortnamme, ou6.uid as >>>> ou6_uid, ou6.code as ou6_code, ou6.organisationunitid as >>>> ou6_organisationunitid >>>> FROM organisationunit ou >>>> INNER JOIN _orgunitstructure ous ON ou.organisationunitid = >>>> ous.organisationuniti

[Dhis2-devs] Integrating additional fields of information for organization units

2017-01-16 Thread Raminosoa Rabemanantsoa, Tantely
Dear Community, While managing information related to organization units, I would like to integrate additional information concerning the orgUnit other than those that are already proposed by DHIS2 (Name, Short name, Code, Description, Opening date, Closed Date, Comment, URL…). Do you know how to

Re: [Dhis2-devs] [Dhis2-users] Integrating additional fields of information for organization units

2017-01-16 Thread Raminosoa Rabemanantsoa, Tantely
Thank you Jason, got it! Tantely. On Mon, Jan 16, 2017 at 3:21 PM, Jason Pickering < jason.p.picker...@gmail.com> wrote: > https://docs.dhis2.org/master/en/user/html/manage_attribute.html > > On Mon, Jan 16, 2017 at 1:17 PM, Raminosoa Rabemanantsoa, Tantely < > tramino

Re: [Dhis2-devs] [Dhis2-users] Integrating additional fields of information for organization units

2017-01-16 Thread Raminosoa Rabemanantsoa, Tantely
for orgunits > > On Jan 16, 2017 1:18 PM, "Raminosoa Rabemanantsoa, Tantely" < > tramino...@mikolo.org> wrote: > >> Dear Community, >> >> >> While managing information related to organization units, I would like to >> integrate additional in

Re: [Dhis2-devs] [Dhis2-users] Integrating additional fields of information for organization units

2017-01-16 Thread Raminosoa Rabemanantsoa, Tantely
t; > On Mon, Jan 16, 2017 at 1:51 PM, Raminosoa Rabemanantsoa, Tantely < > tramino...@mikolo.org> wrote: > >> I have created the attributes and assign them to Organization Units at >> the moment of creation. I do not see them yet when editing Organization >>

[Dhis2-devs] Table for SQL query for Indicators

2017-02-02 Thread Raminosoa Rabemanantsoa, Tantely
Dear friends, I am trying to output data of a questionnaire (called DataSetName here) from SQL View for the period of September 2016 from data values using the following code: select dv.sourceid as organisationunitid, ou.name, ou.shortname, ou.code as CodeAC, de.name as intitule, pe.startdate,

[Dhis2-devs] Tables for SQL queries -- indicators

2017-02-04 Thread Raminosoa Rabemanantsoa, Tantely
Dear DHIS2 Users, I would like to run SQL to query indicators values through SQL View. On which tables should I query from if for the dataelements, the SQL queries are based on dataValues (dv) table? I am using DHIS2 2.24 Thank you for your support! Kind Regards, Tantely. -- *This message an

Re: [Dhis2-devs] Tables for SQL queries -- indicators

2017-02-05 Thread Raminosoa Rabemanantsoa, Tantely
> archive of this list to see if you can find more information. > > The easier way, by far however, would be the use the analytics API, and > let DHIS2 do the calculation for you. > > Regards, > Jason > > > On Sun, Feb 5, 2017 at 9:34 AM, Raminosoa Rabemanantsoa, Tantely < >

Re: [Dhis2-devs] [Dhis2-users] Table for SQL query for Indicators

2017-02-05 Thread Raminosoa Rabemanantsoa, Tantely
> indicators and use download option under advanced menu to download the > query. > > I can't recall, but I think support for generation sql query even for > indicators was added either in 2.23, 2.24 or 2.25 so you could also try to > explore this option. > > On 3 Feb 2017

[Dhis2-devs] Generate data output

2017-02-07 Thread Raminosoa Rabemanantsoa, Tantely
Dear community, I would like to output data in a tabular format (data elements in columns, orgUnits and periods per row) at the lowest level of orgUnits. In which way should I do that as data in text format could not be displayed through pivot table? Thank you for your support! Regards. Tantely

Re: [Dhis2-devs] [Dhis2-users] Generate data output

2017-02-07 Thread Raminosoa Rabemanantsoa, Tantely
ion=ou:YuQRtpLP10I&outputIdScheme=NAME > > You can also use the startDate and endDate params for more flexibility. > > regards, > > Lars > > > > On Tue, Feb 7, 2017 at 6:41 PM, Raminosoa Rabemanantsoa, Tantely < > tramino...@mikolo.org> wrote: > >> Dear comm

[Dhis2-devs] Output Raw Data in a matrix format -- DHIS2 2.24

2017-02-13 Thread Raminosoa Rabemanantsoa, Tantely
Dear Community, With DHIS2 2.24, I am trying to output raw data in a matrix format. I have used SQL View to output the data. Data values table is presented as following: *orgUnit UID, dataElement1, Value, Period* *orgUnit UID, dataElement2, Value, Period* *orgUnit UID, dataElement3, Value,

[Dhis2-devs] Output Raw Data in a matrix format -- DHIS2 2.24

2017-02-14 Thread Raminosoa Rabemanantsoa, Tantely
Dear Community, With DHIS2 2.24, I am trying to output raw data in a matrix format. I have used SQL View to output the data. Data values table is presented as following: *orgUnit UID, dataElement1, Value, Period* *orgUnit UID, dataElement2, Value, Period* *orgUnit UID, dataElement3, Value,

Re: [Dhis2-devs] Output Raw Data in a matrix format -- DHIS2 2.24

2017-02-14 Thread Raminosoa Rabemanantsoa, Tantely
rg/docs/9.5/static/tablefunc.html > > Regards, > Jason > > > On Tue, Feb 14, 2017 at 9:37 AM, Raminosoa Rabemanantsoa, Tantely < > tramino...@mikolo.org> wrote: > >> Dear Community, >> >> >> With DHIS2 2.24, I am trying to outpu

[Dhis2-devs] Unassigned dataSet -- pivot table

2017-02-15 Thread Raminosoa Rabemanantsoa, Tantely
Dear Community, I would like to ask the question for dataSet that we do not assign no more to any organization units, how to make them available in pivot table for analysis? I am using DHIS2 2.24. Thank you for your support. Kind Regards, Tantely. -- *This message and its attachments are c

[Dhis2-devs] Period name based on startdate or enddate?

2017-02-15 Thread Raminosoa Rabemanantsoa, Tantely
DearCommunity, We are running SQL code to output data from the SQL View module. We get the following table for an organization unit accross multiple periods containing results with *startdate* and *enddate*. We have set up the period to "*Monthly*". In order to output the Period name (i.e. Januar

Re: [Dhis2-devs] Period name based on startdate or enddate?

2017-02-15 Thread Raminosoa Rabemanantsoa, Tantely
gt; > Regards, > Jason > > > On Thu, Feb 16, 2017 at 8:36 AM, Raminosoa Rabemanantsoa, Tantely < > tramino...@mikolo.org> wrote: > >> DearCommunity, >> >> We are running SQL code to output data from the SQL View module. We get >> the following

[Dhis2-devs] Unassigned dataSet -- pivot table

2017-02-16 Thread Raminosoa Rabemanantsoa, Tantely
Dear Community, I would like to ask the question for dataSets that we do not assign no more to any organization units, how to make them available in pivot table for analysis? I am using DHIS2 2.24. Thank you for your support. Kind Regards, Tantely. -- *This message and its attachments are

Re: [Dhis2-devs] [Dhis2-users] Unassigned dataSet -- pivot table

2017-02-16 Thread Raminosoa Rabemanantsoa, Tantely
Hi Tantely, > > Sorry, but if you don't assign them, then you don't have any data anymore? > You still want to look at the historical data in Pivots? > > Knut > > On Thu, Feb 16, 2017 at 2:12 PM, Raminosoa Rabemanantsoa, Tantely < > tramino...@mikolo.org> wrote:

[Dhis2-devs] SQL query for DataSets

2017-02-21 Thread Raminosoa Rabemanantsoa, Tantely
Dear Community, I am trying to pull out the list of all orgUnits and the name of the questionnaire assigned to each of them via SQL View. In which table should I base the SQL query in order to have the list of dataSet assigned to an orgUnit? Regards, Tantely. -- *This message and its attachmen

[Dhis2-devs] SQL query for DataSets

2017-02-21 Thread Raminosoa Rabemanantsoa, Tantely
Dear Community, I am trying to pull out the list of all orgUnits and the name of the questionnaire assigned to each of them via SQL View. In which table should I base the SQL query in order to have the list of dataSet assigned to an orgUnit? Regards, Tantely. -- *This message and its attachmen

Re: [Dhis2-devs] SQL query for DataSets

2017-02-21 Thread Raminosoa Rabemanantsoa, Tantely
ce dss ON dss.datasetid = ds.datasetid > JOIN organisationunit ou ON ou.organisationunitid = dss.sourceid > GROUP BY ou.name > ORDER BY ou.name; > > Cheers, > Jim > > > On Tue, Feb 21, 2017 at 12:53 PM, Raminosoa Rabemanantsoa, Tantely < > tramino...@mikolo.org> wrote: > >

Re: [Dhis2-devs] [Dhis2-users] SQL query for DataSets

2017-02-21 Thread Raminosoa Rabemanantsoa, Tantely
SELECT ou.name AS orgunit, string_agg(ds.name, ' | ' ORDER BY ds.name) >> AS datasets >> FROM dataset ds >> JOIN datasetsource dss ON dss.datasetid = ds.datasetid >> JOIN organisationunit ou ON ou.organisationunitid = dss.sourceid >> GROUP BY ou.na

Re: [Dhis2-devs] [Dhis2-users] SQL query for DataSets

2017-02-21 Thread Raminosoa Rabemanantsoa, Tantely
ow per orgUnit and a column that concatenates all >>> assigned dataset names, try (in Postgresql): >>> >>> SELECT ou.name AS orgunit, string_agg(ds.name, ' | ' ORDER BY ds.name) >>> AS datasets >>> FROM dataset ds >>> JOIN dataset

[Dhis2-devs] Lock dataset for past data entry

2017-03-16 Thread Raminosoa Rabemanantsoa, Tantely
Dear Community, I am trying to use the "Expiry days" parameter in order to lock the dataset for further entry, with DHIS2 2.24. I have put a value of 60 in order to have the dataset unlocked for the 2 last months. But the dataset is still open for data entry for all periods. Could anyone give a ha

[Dhis2-devs] Lock dataset for data entry

2017-03-16 Thread Raminosoa Rabemanantsoa, Tantely
Dear Community, While editing dataSet, I am giving the "Expiry days" value in order to lock the dataset for further entry, with DHIS2 2.24. I have put a value of 60 in order to have the dataset unlocked for the 2 last months. But the dataset is still open for data entry for all periods. Did I do w

Re: [Dhis2-devs] Problem loading pivot table results

2017-04-04 Thread Raminosoa Rabemanantsoa, Tantely
ant. > > Regards > Calle > > On 3 April 2017 at 13:05, Raminosoa Rabemanantsoa, Tantely < > tramino...@mikolo.org> wrote: > >> Dear DHIS2 community, >> >> >> We are using DHIS2 2.24. When we are running pivot table and are using >> some indic

Re: [Dhis2-devs] [Dhis2-users] Problem loading pivot table results

2017-04-05 Thread Raminosoa Rabemanantsoa, Tantely
6 AM, Jan Henrik Øverland >> wrote: >> >>> Hi Tantely, >>> >>> You can dump larger chunks of data by doing the following: >>> >>> - Open the pivot tables app >>> - Select what you need in the left menu >>> - Do not click &qu

Re: [Dhis2-devs] Filtering Pivot Table Results (before Results Export)

2017-04-07 Thread Raminosoa Rabemanantsoa, Tantely
evel if you would like to include facilities from the entire country. > > > [image: Inline image 3] > > > This will render the actual org units from that group in your pivot table. > > regards, > > Lars > > > > > > On Thu, Apr 6, 2017 at 5:38 PM, Raminos

Re: [Dhis2-devs] [Dhis2-users] DHIS2 users list from SQL View

2017-04-11 Thread Raminosoa Rabemanantsoa, Tantely
il, >>> >>> "public".userinfo.phonenumber, >>> >>> "public".users.lastlogin, >>> >>> "public".users.created, >>> >>> "public".users.disabled, >>> >>> "

Re: [Dhis2-devs] [Dhis2-users] DHIS2 users list from SQL View

2017-04-11 Thread Raminosoa Rabemanantsoa, Tantely
> surname,email,userCredentials[username,lastLogin,created, > disabled,userRoles[id,name]],organisationUnits[id,name]&paging=false > > Regards, > Jason > > > > On Tue, Apr 11, 2017 at 3:46 PM, Raminosoa Rabemanantsoa, Tantely < > tramino...@mikolo.org> wrote:

[Dhis2-devs] Setting "zeroissignificant" column from csv file import does not work -- DHIS2 2.25

2017-05-25 Thread Raminosoa Rabemanantsoa, Tantely
Dear DHIS2 community, When doing data elements upload from csv file (both add new or edit existing) we are using the following csv file structure: *Name, uid, code, shortname, description, formname, domaintype, valuetype, aggregationtype, **zeroissignificant* The last field is set to *true* f

Re: [Dhis2-devs] Setting "zeroissignificant" column from csv file import does not work -- DHIS2 2.25

2017-05-25 Thread Raminosoa Rabemanantsoa, Tantely
created helps not to update all dataelements, you can choose > any other filter e.g a starting string. > > Alex > > > On Thursday, May 25, 2017, Raminosoa Rabemanantsoa, Tantely < > tramino...@mikolo.org> wrote: > >> Dear DHIS2 community, >> >> &g

[Dhis2-devs] DHIS2 crashes during login

2016-03-21 Thread Raminosoa Rabemanantsoa, Tantely
Hello everyone, I am a new user of DHIS2. I am working with a DHIS2 application that has already been installed last year inside an Amazon cloud web server. The version that we have is DHIS2 2.19. The Tomcat version is 1.7. All the data elements, organization unit and questionnaires have been in

[Dhis2-devs] ERRORS reported by the log file

2016-04-25 Thread Raminosoa Rabemanantsoa, Tantely
Dear All, I would like to ask your support in ordre to fix the following errors: *ERROR 1* I have created a list of data entry users to use the android data capture app. When they are accessing their account through the DHIS2 web interface, the server is returning a pop-up message mentioning “

Re: [Dhis2-devs] [Dhis2-users] ERRORS reported by the log file

2016-04-25 Thread Raminosoa Rabemanantsoa, Tantely
Dear Morten, Thank you for your answer. For ERROR 1: I have made an SQL select (in DHIS2) to find the the orgunit with the mentioned uid but it does not appear in the list. It is something strange as all the organisation units are listed in the query output. For ERROR 2: It does not happen for a

[Dhis2-devs] Delete data values based on dataset -- DHIS2 2.25

2017-07-24 Thread Raminosoa Rabemanantsoa, Tantely
Hello everyone, I need to delete data values based on some datasets and each corresponding completeness. I can delete all the data values by importing “null” data from csv format, but with this, the completeness do not change. My question is what is the simplest way to do the data values deletion

Re: [Dhis2-devs] [Dhis2-users] Delete data values based on dataset -- DHIS2 2.25

2017-07-24 Thread Raminosoa Rabemanantsoa, Tantely
script if you have access to the database. > > > Kind regards > Djibril > > On 24 Jul 2017 16:33, "Raminosoa Rabemanantsoa, Tantely" < > tramino...@mikolo.org> wrote: > > Hello everyone, > > > I need to delete data values based on some datasets a

Re: [Dhis2-devs] Defining Compulsory Data Element Unsuccessfull

2017-08-07 Thread Raminosoa Rabemanantsoa, Tantely
on is to create another DE with the compulsory attribute and > remove the previous one from the Dataset. > But you might need to trade with the data that was previously entered > using the DE. > > Regards > > On Aug 7, 2017 6:32 PM, "Raminosoa Rabemanantsoa, Tantely" <

Re: [Dhis2-devs] Defining Compulsory Data Element Unsuccessfull

2017-08-07 Thread Raminosoa Rabemanantsoa, Tantely
oncombo and attributeoptioncombo of both the old > and new DEs. > The easiest work around for me would be to export the data to CSV and > import into the new DE. > > Regards > > On Aug 7, 2017 7:03 PM, "Raminosoa Rabemanantsoa, Tantely" < > tramino...@mikolo.org

[Dhis2-devs] Create additional customized OrgUnits attributes

2017-09-05 Thread Raminosoa Rabemanantsoa, Tantely
Dear DHIS2 Community, While managing OrgUnit (Add, Edit), we have the following fields appearing on the edition form (using DHIS2 2.25): Parent organisation unit Name (*) Short name (*) Code Description Opening date (*) Closed date Comment URL Contact person Address Email Phone numb

Re: [Dhis2-devs] [Dhis2-users] Create additional customized OrgUnits attributes

2017-09-05 Thread Raminosoa Rabemanantsoa, Tantely
l#manage_attribute > > Regards > > Prosper Behumbiize, MPH > DHIS2 Implementation| HISP Uganda > pros...@hispuganda.org | pros...@dhis2.org | Skype: > prospertb > > On Tue, Sep 5, 2017 at 3:00 PM, Raminosoa Rabemanantsoa, Tantely < > tramino...@mikolo.org> wro

[Dhis2-devs] Setting up an yearly period: Yearly September

2017-09-07 Thread Raminosoa Rabemanantsoa, Tantely
Dear DHIS2 Community, Is there a way to create a new group for the data agregation period ? In DHIS2, there is already the following period option: Financial Oct: Financial year period beginning on October 1st and ending on September 30st of the calendar next year. I would like to set up a ne

Re: [Dhis2-devs] Setting up an yearly period: Yearly September

2017-09-07 Thread Raminosoa Rabemanantsoa, Tantely
add a new period type to add the period you want. All > analysis apps would probably also require changes here as well. > > Regards, > Jason > > > > > On Thu, Sep 7, 2017 at 2:02 PM, Raminosoa Rabemanantsoa, Tantely < > tramino...@mikolo.org> wrote: > >> &

[Dhis2-devs] Could not drill down a parent OrgUnit -- DHIS2 2.25

2017-09-16 Thread Raminosoa Rabemanantsoa, Tantely
Dear Community, Do you know the possible cause for a parent OrgUnit with which we could not drill down to access to the lowest OrgUnit in the data entry app (could not unfold the plus sign)? When looking at the OrgUnit maintenance, all ancestors, the parent itself and the lowest level OrgUnits s

Re: [Dhis2-devs] Could not drill down a parent OrgUnit -- DHIS2 2.25

2017-09-16 Thread Raminosoa Rabemanantsoa, Tantely
data capture. I have also checked the Data Integrity app but there is any anomaly. Regards, Tantely. On Sun, Sep 17, 2017 at 5:08 AM, Knut Staring wrote: > Any messages in the browser console? > > On Sep 17, 2017 03:34, "Raminosoa Rabemanantsoa, Tantely" < > tra

[Dhis2-devs] Troubleshoot DHIS2 Admin account -- DHIS2 2.25

2017-10-15 Thread Raminosoa Rabemanantsoa, Tantely
Dear Community, I would like to have some advice to troubleshoot the account where the orgunits at lower level (inside red rectangle) are displayed at the same hierarchy as the higher level. The two accounts have admin access to DHIS2 (2.25). There are some illustrations of the Maintenance (Organi

Re: [Dhis2-devs] [Dhis2-users] Troubleshoot DHIS2 Admin account -- DHIS2 2.25

2017-10-16 Thread Raminosoa Rabemanantsoa, Tantely
lecting the > organization units from their profiles and assign them only to the top > level. Clean cache and see if this helps. > > > > Georgi > > > > *From:* Dhis2-users [mailto:dhis2-users-bounces+georgi= > logicaloutcomes@lists.launchpad.net] *On Behalf Of *Rami

[Dhis2-devs] Reset DataSet completeness to 0 (incomplete)

2017-11-21 Thread Raminosoa Rabemanantsoa, Tantely
Dear DHIS2 community, I would like to ask if there is a way to reset report completeness to 0 (zero) in a bulk manner for some group of OrgUnit, via SQLView or Web API, if we know the Orgunit uid, period and DataSet uid to reset? I am using DHIS2 2.25. Thank you already for your suggestions! Reg

[Dhis2-devs] Reset DataSet completeness to zero - DHIS2 2.25

2017-11-21 Thread Raminosoa Rabemanantsoa, Tantely
Dear DHIS2 community, I would like to ask if there is a way to reset report completeness to 0 (zero) in a bulk manner for some group of OrgUnit, via SQLView or Web API? We know the Orgunit uid, period and DataSet uid to reset. Thank you already for your suggestions! Regards, Tantely. -- *This

Re: [Dhis2-devs] Reset DataSet completeness to zero - DHIS2 2.25

2017-11-22 Thread Raminosoa Rabemanantsoa, Tantely
> attributeoptioncomboid | integer | not null > > > Otherwise, use the API for this as described here: > > https://docs.dhis2.org/master/en/developer/html/webapi_complete_data_set_ > registrations.html#webapi_uncompleting_data_sets > > Regards, > Jason >