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 >

[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. --

[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!

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

2017-10-16 Thread Raminosoa Rabemanantsoa, Tantely
ng 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 *Raminosoa

[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

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 <knu...@gmail.com> wrote: > Any messages in the browser console? > > On Sep 17, 2017 03:34, "Raminosoa Rabemanantsoa,

[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

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

2017-09-07 Thread Raminosoa Rabemanantsoa, Tantely
.java > > You would need to 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 <

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

2017-09-05 Thread Raminosoa Rabemanantsoa, Tantely
user/html/dhis2_user_ > manual_en_full.html#manage_attribute > > Regards > > Prosper Behumbiize, MPH > DHIS2 Implementation| HISP Uganda > pros...@hispuganda.org <ptb3...@gmail.com> | pros...@dhis2.org | Skype: > prospertb > > On Tue, Sep 5, 2017 at 3:00 PM, Raminosoa Rabemanantsoa,

[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

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

2017-08-07 Thread Raminosoa Rabemanantsoa, Tantely
; element ID, categoryoptioncombo 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

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

2017-08-07 Thread Raminosoa Rabemanantsoa, Tantely
ons. > > The solution 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 Rab

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

2017-07-24 Thread Raminosoa Rabemanantsoa, Tantely
; You can do it using sql 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 bas

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

2017-05-25 Thread Raminosoa Rabemanantsoa, Tantely
te that the 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] 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*

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]=false > > Regards, > Jason > > > > On Tue, Apr 11, 2017 at 3:46 PM, Raminosoa Rabemanantsoa, Tantely < > tramino...@mikolo.org> wrote: > >>

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

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

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

2017-04-07 Thread Raminosoa Rabemanantsoa, Tantely
at the national > level 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, 2

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

2017-04-05 Thread Raminosoa Rabemanantsoa, Tantely
Select what you need in the left menu >>> - Do not click "update" - instead click the small down-arrow next to >>> the update button and download as CSV >>> >>> Jan >>> >>> On 5 April 2017 at 08:32, Raminosoa Rabemanantsoa, Tantely &

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

2017-04-05 Thread Raminosoa Rabemanantsoa, Tantely
nto the report format you want. > > 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

[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

[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

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

2017-02-21 Thread Raminosoa Rabemanantsoa, Tantely
Y ou.name, ds.name; >>> >>> If you want only one row 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 >>&

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

2017-02-21 Thread Raminosoa Rabemanantsoa, Tantely
names, try (in Postgresql): >> >> 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

Re: [Dhis2-devs] SQL query for DataSets

2017-02-21 Thread Raminosoa Rabemanantsoa, Tantely
e 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

[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

[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

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

2017-02-16 Thread Raminosoa Rabemanantsoa, Tantely
com> wrote: > 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...@mi

[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] Period name based on startdate or enddate?

2017-02-15 Thread Raminosoa Rabemanantsoa, Tantely
there. > > 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 follo

[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.

[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

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] 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,

[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,

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

2017-02-07 Thread Raminosoa Rabemanantsoa, Tantely
n 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 community, >> >> I would like to output dat

[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.

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

2017-02-05 Thread Raminosoa Rabemanantsoa, Tantely
this option. > > On 3 Feb 2017 11:05, "Raminosoa Rabemanantsoa, Tantely" < > tramino...@mikolo.org> wrote: > >> Dear friends, >> >> I am trying to output data of a questionnaire (called DataSetName here) >> from SQL View for the period o

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

2017-02-05 Thread Raminosoa Rabemanantsoa, Tantely
to search through the email > 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, R

[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

[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,

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

2017-01-16 Thread Raminosoa Rabemanantsoa, Tantely
s, > > Lars > > > 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

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

2017-01-16 Thread Raminosoa Rabemanantsoa, Tantely
dditional attributes 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 >>

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

[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

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

2017-01-11 Thread Raminosoa Rabemanantsoa, Tantely
rganisationunitid, >>>> ou6.name as ou6_name, 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 _or

[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] Merge multiple orgUnits DHIS2 2.24

2017-01-10 Thread Raminosoa Rabemanantsoa, Tantely
com/dhis2/dhis2-utils/blob/master/ > 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, > Jaso

[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,

[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,

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

2016-09-21 Thread Raminosoa Rabemanantsoa, Tantely
@gmail.com > <wanjal...@gmail.com>* > *h...@health.go.ke <h...@health.go.ke>, *meunit...@gmail.com > *"HealthInformation Management - Making a World of Difference”* > > > > -- > *From:* Knut Staring <knu..

[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

[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

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

2016-09-13 Thread Raminosoa Rabemanantsoa, Tantely
llocate more memory (-Xmx7500m) 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 Rabemanant

Re: [Dhis2-devs] Groups - Tables

2016-09-12 Thread Raminosoa Rabemanantsoa, Tantely
ource > > 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-12 Thread Raminosoa Rabemanantsoa, Tantely
it re-occur? > > 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 fo

[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] 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] Groups - Tables

2016-09-12 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

[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

Re: [Dhis2-devs] Dataset Assignation programmatically

2016-08-05 Thread Raminosoa Rabemanantsoa, Tantely
examples in the documentation about how 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 < > tr

Re: [Dhis2-devs] Dataset Assignation programmatically

2016-08-05 Thread Raminosoa Rabemanantsoa, Tantely
ll have to clear the server 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> wro

[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] [Dhis2-users] DHIS2 - Reporting rate + count of the submitted reports.

2016-07-27 Thread Raminosoa Rabemanantsoa, Tantely
SQL queries with 1.19. > > 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 rat

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 <ptb3...@gmail.com> 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

[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. --

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

2016-07-26 Thread Raminosoa Rabemanantsoa, Tantely
gt; straightforward and mappable. But you will first have to make sure all the >>> metadata is in DHIS2 or if not, create them. >>> >>> Knut >>> >>> On Mon, Jul 25, 2016 at 10:23 PM, Raminosoa Rabemanantsoa, Tantely < >>> tramino...@

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

2016-07-25 Thread Raminosoa Rabemanantsoa, Tantely
HIS2 can be used to store file 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 t

[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

[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

[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?

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] 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?

[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

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 <knu...@gmail.com> wrote: > Sourceid = Organisaitonunitid. This is an unfortunate historical naming. > > Knut > > On Wed, Jul 13, 2016 at 11:19 AM, Raminosoa Rabemanantsoa, Tantely < > t

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

2016-07-13 Thread Raminosoa Rabemanantsoa, Tantely
eriale/step-by-step-lab-instructions---completeness.doc >> >> Knut >> >> On Wed, Jul 13, 2016 at 9:19 AM, Raminosoa Rabemanantsoa, Tantely < >> tramino...@mikolo.org> wrote: >> >>> Hi All, >>> >>> >>> I have imported a large am

[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

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

2016-07-13 Thread Raminosoa Rabemanantsoa, Tantely
ons Yes, No, > and NA, then 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

[Dhis2-devs] Creating dropdown field

2016-07-13 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.

[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

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

2016-07-05 Thread Raminosoa Rabemanantsoa, Tantely
is2.github.io/dhis2-docs/2.22/en/user/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, >> >> T

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

2016-07-05 Thread Raminosoa Rabemanantsoa, Tantely
Admin. > > Regards, > 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

[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,

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

2016-06-20 Thread Raminosoa Rabemanantsoa, Tantely
query due to low capacity. >> >> 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

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] 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 <l...@dhis2.org> wrote: > Hi Tantely, > > On Thu, May 19, 2016 at 10:40 AM, Raminosoa Rabemanantsoa, Tantely < > tramino...@mikolo.org> wrote: > >> Hi A

[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

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.

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

2016-05-02 Thread Raminosoa Rabemanantsoa, Tantely
s2.org> wrote: > Hello 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 everyo

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

2016-05-02 Thread Raminosoa Rabemanantsoa, Tantely
> I'm happy to 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 < > trami

[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:

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

[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

[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