Re: [Dhis2-devs] Arranging data entry in data capture app

[Jason Pickering]

Hi Blake,

Just use a section form and order them as you like. This of course will
require that you can  use a section form.

Otherwise, you would need to implement a custom form and order then there.

Regards,
Jason


On Mon, Feb 6, 2017 at 1:24 PM, Blake Hansen  wrote:

> Dear Devs,
>
> I am trying to rearrange the order of data elements and category options
> as they appear in the tabularised form of the data capture app - aggregate
> form.
> I expected them to load based on alphabetical order of the data element
> name, and as such gave them numbering at the beginning of the name ‘005,
> 010, etc…’ However the order the data elements in the app adopt in the
> aggregate form seems not to respect this. How do I arrange the order of the
> data elements in the form, please?
>
> With thanks,
> Blake
>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-devs@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Jason P. Pickering
email: jason.p.picker...@gmail.com
tel:+46764147049
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] Exporting/importing User meta-data

[Morten Olav Hansen]

Hi Calle

Would you mind filing a bug in Jira? easier to track it that way

-- 
Morten Olav Hansen
Senior Engineer, DHIS 2
University of Oslo
http://www.dhis2.org

On Mon, Feb 6, 2017 at 6:53 AM, Calle Hedberg 
wrote:

> Hi,
>
> I tried to export "Users" meta-data in 2.24 earlier this evening, and then
> import it into another slightly different version of the same instance
> (when logged in as superuser).
>
> Every single user was ignored during import, and every single one had an
> import summary error message like the one below.
>
> Anybody able to figure out what's blocking the import in this case? I do
> see the ""teiSearchOrganisationUnits":"[]" } is not allowed to grant
> users access to user role" sections which looks like some kind of error,
> but I don't know what that section actually means.
>
> (I later tried to export and import "Users" meta-data in the same 2.25
> instance - that worked without a hitch).
>
> Regards
> Calle
>
> Validation Violations: [ErrorReport{message=User {"id":"0",
> "uid":"V0643n3eCBk", "code":"null", "created":"Tue May 03 15:44:05 CAT
> 2016", "lastUpdated":"Tue May 03 15:44:05 CAT 2016", "surname":"User",
> "firstName":"Demo", "email":"null", "phoneNumber":"null",
> "jobTitle":"null", "introduction":"null", "gender":"null",
> "birthday":"null", "nationality":"null", "employer":"null",
> "education":"null", "interests":"null", "languages":"null",
> "lastCheckedInterpretations":"null", 
> "userCredentials":"{"username":"Demo_User",
> "openId":"null", "password":"$2a$10$CNhU7EJFD5X53qDd/
> F6DyuyVH99JUoWEX6vLFUWC7k4rL7SUzb.kG", "passwordLastUpdated":"Tue May 03
> 15:44:04 CAT 2016", "userAuthorityGroups":"[{"class":"class
> org.hisp.dhis.user.UserAuthorityGroup", "id":"0", "uid":"aWAMSmyKe4b",
> "code":"null", "name":"Data capturer - Event", "created":"Thu Jun 25
> 09:06:05 CAT 2015", "lastUpdated":"Wed Dec 21 09:20:24 CAT 2016" },
> {"class":"class org.hisp.dhis.user.UserAuthorityGroup", "id":"0",
> "uid":"tnNVBu5cxxZ", "code":"null", "name":"Dashboard", "created":"Thu Jul
> 23 17:18:16 CAT 2015", "lastUpdated":"Mon Jun 20 08:59:15 CAT 2016" }]",
> "lastLogin":"Tue May 03 15:44:04 CAT 2016", "restoreToken":"null",
> "restoreCode":"null", "restoreExpiry":"null", "selfRegistered":"false",
> "disabled":"false" }", "groups":"[]", "organisationUnits":"[{"class":"class
> org.hisp.dhis.organisationunit.OrganisationUnit", "id":"0",
> "uid":"kWi0HuwZ68H", "code":"null", "name":"Ministry of Health and Social
> Services", "created":"Mon Aug 10 08:57:03 CAT 2015", "lastUpdated":"Thu Jun
> 16 11:53:40 CAT 2016" }]", "dataViewOrganisationUnits":"[{"class":"class
> org.hisp.dhis.organisationunit.OrganisationUnit", "id":"0",
> "uid":"kWi0HuwZ68H", "code":"null", "name":"Ministry of Health and Social
> Services", "created":"Mon Aug 10 08:57:03 CAT 2015", "lastUpdated":"Thu Jun
> 16 11:53:40 CAT 2016" }]" "teiSearchOrganisationUnits":"[]" } is not
> allowed to grant users access to user role {"class":"class
> org.hisp.dhis.user.UserAuthorityGroup", "id":"60273",
> "uid":"ckj7ljweNzk", "code":"null", "name":"User Managed Groups",
> "created":"2015-06-24 17:05:03.418", "lastUpdated":"2016-06-15
> 15:45:57.802" }., errorCode=E3003, mainKlass=class 
> org.hisp.dhis.user.UserAuthorityGroup,
> errorKlass=null, value=null}, ErrorReport{message=User {"id":"0",
> "uid":"V0643n3eCBk", "code":"null", "created":"Tue May 03 15:44:05 CAT
> 2016", "lastUpdated":"Tue May 03 15:44:05 CAT 2016", "surname":"User",
> "firstName":"Demo", "email":"null", "phoneNumber":"null",
> "jobTitle":"null", "introduction":"null", "gender":"null",
> "birthday":"null", "nationality":"null", "employer":"null",
> "education":"null", "interests":"null", "languages":"null",
> "lastCheckedInterpretations":"null", 
> "userCredentials":"{"username":"Demo_User",
> "openId":"null", "password":"$2a$10$CNhU7EJFD5X53qDd/
> F6DyuyVH99JUoWEX6vLFUWC7k4rL7SUzb.kG", "passwordLastUpdated":"Tue May 03
> 15:44:04 CAT 2016", "userAuthorityGroups":"[{"class":"class
> org.hisp.dhis.user.UserAuthorityGroup", "id":"0", "uid":"aWAMSmyKe4b",
> "code":"null", "name":"Data capturer - Event", "created":"Thu Jun 25
> 09:06:05 CAT 2015", "lastUpdated":"Wed Dec 21 09:20:24 CAT 2016" },
> {"class":"class org.hisp.dhis.user.UserAuthorityGroup", "id":"0",
> "uid":"tnNVBu5cxxZ", "code":"null", "name":"Dashboard", "created":"Thu Jul
> 23 17:18:16 CAT 2015", "lastUpdated":"Mon Jun 20 08:59:15 CAT 2016" }]",
> "lastLogin":"Tue May 03 15:44:04 CAT 2016", "restoreToken":"null",
> "restoreCode":"null", "restoreExpiry":"null", "selfRegistered":"false",
> "disabled":"false" }", "groups":"[]", "organisationUnits":"[{"class":"class
> org.hisp.dhis.organisationunit.OrganisationUnit", "id":"0",
> "uid":"kWi0HuwZ68H", "code":"null", "name":"Ministry of Health and Social
> Services", "created":"Mon Aug 10 08:57:03 CAT 2015", "lastUpdated":"Thu Jun
> 16 11:53:40 CAT 2016" }]", "dataViewOrganisationUnits":"[{"class":"class
> 

[Dhis2-devs] Arranging data entry in data capture app

[Blake Hansen]

Dear Devs,

I am trying to rearrange the order of data elements and category options as 
they appear in the tabularised form of the data capture app - aggregate form.
I expected them to load based on alphabetical order of the data element name, 
and as such gave them numbering at the beginning of the name ‘005, 010, etc…’ 
However the order the data elements in the app adopt in the aggregate form 
seems not to respect this. How do I arrange the order of the data elements in 
the form, please?

With thanks,
Blake

___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

[Dhis2-devs] Exporting/importing User meta-data

[Calle Hedberg]

Hi,

I tried to export "Users" meta-data in 2.24 earlier this evening, and then
import it into another slightly different version of the same instance
(when logged in as superuser).

Every single user was ignored during import, and every single one had an
import summary error message like the one below.

Anybody able to figure out what's blocking the import in this case? I do
see the ""teiSearchOrganisationUnits":"[]" } is not allowed to grant users
access to user role" sections which looks like some kind of error, but I
don't know what that section actually means.

(I later tried to export and import "Users" meta-data in the same 2.25
instance - that worked without a hitch).

Regards
Calle

Validation Violations: [ErrorReport{message=User {"id":"0",
"uid":"V0643n3eCBk", "code":"null", "created":"Tue May 03 15:44:05 CAT
2016", "lastUpdated":"Tue May 03 15:44:05 CAT 2016", "surname":"User",
"firstName":"Demo", "email":"null", "phoneNumber":"null",
"jobTitle":"null", "introduction":"null", "gender":"null",
"birthday":"null", "nationality":"null", "employer":"null",
"education":"null", "interests":"null", "languages":"null",
"lastCheckedInterpretations":"null",
"userCredentials":"{"username":"Demo_User", "openId":"null",
"password":"$2a$10$CNhU7EJFD5X53qDd/F6DyuyVH99JUoWEX6vLFUWC7k4rL7SUzb.kG",
"passwordLastUpdated":"Tue May 03 15:44:04 CAT 2016",
"userAuthorityGroups":"[{"class":"class
org.hisp.dhis.user.UserAuthorityGroup", "id":"0", "uid":"aWAMSmyKe4b",
"code":"null", "name":"Data capturer - Event", "created":"Thu Jun 25
09:06:05 CAT 2015", "lastUpdated":"Wed Dec 21 09:20:24 CAT 2016" },
{"class":"class org.hisp.dhis.user.UserAuthorityGroup", "id":"0",
"uid":"tnNVBu5cxxZ", "code":"null", "name":"Dashboard", "created":"Thu Jul
23 17:18:16 CAT 2015", "lastUpdated":"Mon Jun 20 08:59:15 CAT 2016" }]",
"lastLogin":"Tue May 03 15:44:04 CAT 2016", "restoreToken":"null",
"restoreCode":"null", "restoreExpiry":"null", "selfRegistered":"false",
"disabled":"false" }", "groups":"[]", "organisationUnits":"[{"class":"class
org.hisp.dhis.organisationunit.OrganisationUnit", "id":"0",
"uid":"kWi0HuwZ68H", "code":"null", "name":"Ministry of Health and Social
Services", "created":"Mon Aug 10 08:57:03 CAT 2015", "lastUpdated":"Thu Jun
16 11:53:40 CAT 2016" }]", "dataViewOrganisationUnits":"[{"class":"class
org.hisp.dhis.organisationunit.OrganisationUnit", "id":"0",
"uid":"kWi0HuwZ68H", "code":"null", "name":"Ministry of Health and Social
Services", "created":"Mon Aug 10 08:57:03 CAT 2015", "lastUpdated":"Thu Jun
16 11:53:40 CAT 2016" }]" "teiSearchOrganisationUnits":"[]" } is not
allowed to grant users access to user role {"class":"class
org.hisp.dhis.user.UserAuthorityGroup", "id":"60273", "uid":"ckj7ljweNzk",
"code":"null", "name":"User Managed Groups", "created":"2015-06-24
17:05:03.418", "lastUpdated":"2016-06-15 15:45:57.802" }., errorCode=E3003,
mainKlass=class org.hisp.dhis.user.UserAuthorityGroup, errorKlass=null,
value=null}, ErrorReport{message=User {"id":"0", "uid":"V0643n3eCBk",
"code":"null", "created":"Tue May 03 15:44:05 CAT 2016", "lastUpdated":"Tue
May 03 15:44:05 CAT 2016", "surname":"User", "firstName":"Demo",
"email":"null", "phoneNumber":"null", "jobTitle":"null",
"introduction":"null", "gender":"null", "birthday":"null",
"nationality":"null", "employer":"null", "education":"null",
"interests":"null", "languages":"null",
"lastCheckedInterpretations":"null",
"userCredentials":"{"username":"Demo_User", "openId":"null",
"password":"$2a$10$CNhU7EJFD5X53qDd/F6DyuyVH99JUoWEX6vLFUWC7k4rL7SUzb.kG",
"passwordLastUpdated":"Tue May 03 15:44:04 CAT 2016",
"userAuthorityGroups":"[{"class":"class
org.hisp.dhis.user.UserAuthorityGroup", "id":"0", "uid":"aWAMSmyKe4b",
"code":"null", "name":"Data capturer - Event", "created":"Thu Jun 25
09:06:05 CAT 2015", "lastUpdated":"Wed Dec 21 09:20:24 CAT 2016" },
{"class":"class org.hisp.dhis.user.UserAuthorityGroup", "id":"0",
"uid":"tnNVBu5cxxZ", "code":"null", "name":"Dashboard", "created":"Thu Jul
23 17:18:16 CAT 2015", "lastUpdated":"Mon Jun 20 08:59:15 CAT 2016" }]",
"lastLogin":"Tue May 03 15:44:04 CAT 2016", "restoreToken":"null",
"restoreCode":"null", "restoreExpiry":"null", "selfRegistered":"false",
"disabled":"false" }", "groups":"[]", "organisationUnits":"[{"class":"class
org.hisp.dhis.organisationunit.OrganisationUnit", "id":"0",
"uid":"kWi0HuwZ68H", "code":"null", "name":"Ministry of Health and Social
Services", "created":"Mon Aug 10 08:57:03 CAT 2015", "lastUpdated":"Thu Jun
16 11:53:40 CAT 2016" }]", "dataViewOrganisationUnits":"[{"class":"class
org.hisp.dhis.organisationunit.OrganisationUnit", "id":"0",
"uid":"kWi0HuwZ68H", "code":"null", "name":"Ministry of Health and Social
Services", "created":"Mon Aug 10 08:57:03 CAT 2015", "lastUpdated":"Thu Jun
16 11:53:40 CAT 2016" }]" "teiSearchOrganisationUnits":"[]" } is not
allowed to grant users access to user role {"class":"class
org.hisp.dhis.user.UserAuthorityGroup", "id":"60260", "uid":"qVea8y6GIok",
"code":"null", 

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

[Raminosoa Rabemanantsoa, Tantely]

Thank you John for the information.

Kind Regards,

Tantely.

On Sun, Feb 5, 2017 at 6:47 PM, John Mukulu  wrote:

> Hello Raminosoa,
>
> Analytics supports generation of query based on data, period and orgunit
> selection. You can use pivot table, select your periods, orgunits and
> 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 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 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, pe.enddate,
>> coc.categoryoptioncomboname, dv.value from datavalue dv inner join
>> organisationunit ou on (dv.sourceid=ou.organisationunitid) inner join
>> dataelement de on (dv.dataelementid=de.dataelementid) inner join period
>> pe on (pe.startdate='2016-09-01') inner join _categoryoptioncomboname coc
>> on (dv.categoryoptioncomboid=coc.categoryoptioncomboid) where
>> (dv.dataelementid in (select dataelementid from datasetmembers where
>> datasetid in (select datasetid from dataset where name='DataSetName')));
>>
>> If I would like to output data from indicator tables, on which table in
>> DHIS2 should I base the select query?
>>
>> Thank you for your support!
>>
>> Kind Regards,
>>
>> Tantely.
>>
>> *This message and its attachments are confidential and solely for the
>> intended recipients. If received in error, please delete them and notify
>> the sender via reply e-mail immediately.*
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to : dhis2-us...@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>

-- 
*This message and its attachments are confidential and solely for the 
intended recipients. If received in error, please delete them and notify 
the sender via reply e-mail immediately.*
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

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

[John Mukulu]

Hello Raminosoa,

Analytics supports generation of query based on data, period and orgunit
selection. You can use pivot table, select your periods, orgunits and
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 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 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, pe.enddate,
> coc.categoryoptioncomboname, dv.value from datavalue dv inner join
> organisationunit ou on (dv.sourceid=ou.organisationunitid) inner join
> dataelement de on (dv.dataelementid=de.dataelementid) inner join period
> pe on (pe.startdate='2016-09-01') inner join _categoryoptioncomboname coc
> on (dv.categoryoptioncomboid=coc.categoryoptioncomboid) where
> (dv.dataelementid in (select dataelementid from datasetmembers where
> datasetid in (select datasetid from dataset where name='DataSetName')));
>
> If I would like to output data from indicator tables, on which table in
> DHIS2 should I base the select query?
>
> Thank you for your support!
>
> Kind Regards,
>
> Tantely.
>
> *This message and its attachments are confidential and solely for the
> intended recipients. If received in error, please delete them and notify
> the sender via reply e-mail immediately.*
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-us...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] [Dhis2-users] Response was not a WebMessage with the expected format

[Antonia I-PRO]

Sorry, I want to say that I don't have this problem. 

> Il giorno 05 feb 2017, alle ore 13:23, Antonia - Pro  ha 
> scritto:
> 
> Hi Stanley,
> actually I use this build of the 2.25
> Version: 2.25 Build revision: da6a2df Build date: 2017-02-02 06:43  
> and I have this problem. I add and remove OrgUnits from the groups without 
> any problem.
> 
> Try to upgrade to the latest build of 2.25
> Regards,
> antonia
> 
> 2017-02-05 11:51 GMT+01:00 Calle Hedberg :
>> Stanley,
>> 
>> 1. You can use api calls to add or remove OUs from groups.
>> 
>> 2. You can use SQL scripts to do the same
>> 
>> 3. If your instance is on localhost - permanently or temporarily - you can 
>> use e.g. MS Access via ODBC to populate the OrgUnitGroupMember table. The 
>> table itself is simple - just two fields - so it's easy to manipulate.
>> 
>> That table is regrettably not part of meta-data export/import, so you cannot 
>> e.g. dump out a CSV file and then manipulate that before importing it again. 
>> I've written a JIRA issue for this - DHIS2-658
>> 
>> Regards
>> Calle
>> 
>>> On 5 February 2017 at 12:36, Stanley Kalyati  wrote:
>>> Thanks Calle.
>>> 
>>> I hope the dev team will work on it soon as i am stuck now.
>>> 
>>> Stanley
>>> 
 On Feb 5, 2017 12:34 PM, "Calle Hedberg"  wrote:
 Hi
 
 It's a (serious) bug - reported on JIRA DHIS2-570 on the 25th January.
 
 Nothing's been done about it so far, most likely due to the rush to 
 finalise 2.26. It's probably a simple bug to fix since allocating OUs to 
 groups worked in previous versions.
 
 Regards
 calle
 
> On 5 February 2017 at 12:21, Stanley Kalyati  wrote:
> I am using DHIS2 2.25 and when i want to add a Facility to a particular 
> group,am getting the above message.What does that mean and if there is 
> someone who can help out.
> 
> I cant add facilities to any groups.
> 
> Stanley
> 
> ___
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-devs@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
 
 
 
 -- 
 ***
 
 Calle Hedberg
 
 46D Alma Road, 7700 Rosebank, SOUTH AFRICA
 
 Tel/fax (home): +27-21-685-6472
 
 Cell: +27-82-853-5352
 
 Iridium SatPhone: +8816-315-19119
 
 Email: calle.hedb...@gmail.com
 
 Skype: calle_hedberg
 
 ***
 
>> 
>> 
>> 
>> -- 
>> ***
>> 
>> Calle Hedberg
>> 
>> 46D Alma Road, 7700 Rosebank, SOUTH AFRICA
>> 
>> Tel/fax (home): +27-21-685-6472
>> 
>> Cell: +27-82-853-5352
>> 
>> Iridium SatPhone: +8816-315-19119
>> 
>> Email: calle.hedb...@gmail.com
>> 
>> Skype: calle_hedberg
>> 
>> ***
>> 
>> 
>> 
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to : dhis2-us...@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
> 
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] [Dhis2-users] Response was not a WebMessage with the expected format

[Antonia - Pro]

Hi Stanley,
actually I use this build of the 2.25
Version: 2.25 Build revision: *da6a2df Build date: 2017-02-02* 06:43
and I have this problem. I add and remove OrgUnits from the groups without
any problem.

Try to upgrade to the latest build of 2.25
Regards,
antonia

2017-02-05 11:51 GMT+01:00 Calle Hedberg :

> Stanley,
>
> 1. You can use api calls to add or remove OUs from groups.
>
> 2. You can use SQL scripts to do the same
>
> 3. If your instance is on localhost - permanently or temporarily - you can
> use e.g. MS Access via ODBC to populate the OrgUnitGroupMember table. The
> table itself is simple - just two fields - so it's easy to manipulate.
>
> That table is regrettably not part of meta-data export/import, so you
> cannot e.g. dump out a CSV file and then manipulate that before importing
> it again. I've written a JIRA issue for this - DHIS2-658
>
> Regards
> Calle
>
> On 5 February 2017 at 12:36, Stanley Kalyati  wrote:
>
>> Thanks Calle.
>>
>> I hope the dev team will work on it soon as i am stuck now.
>>
>> Stanley
>>
>> On Feb 5, 2017 12:34 PM, "Calle Hedberg"  wrote:
>>
>>> Hi
>>>
>>> It's a (serious) bug - reported on JIRA DHIS2-570 on the 25th January.
>>>
>>> Nothing's been done about it so far, most likely due to the rush to
>>> finalise 2.26. It's probably a simple bug to fix since allocating OUs to
>>> groups worked in previous versions.
>>>
>>> Regards
>>> calle
>>>
>>> On 5 February 2017 at 12:21, Stanley Kalyati  wrote:
>>>
 I am using DHIS2 2.25 and when i want to add a Facility to a particular
 group,am getting the above message.What does that mean and if there is
 someone who can help out.

 I cant add facilities to any groups.

 Stanley

 ___
 Mailing list: https://launchpad.net/~dhis2-devs
 Post to : dhis2-devs@lists.launchpad.net
 Unsubscribe : https://launchpad.net/~dhis2-devs
 More help   : https://help.launchpad.net/ListHelp


>>>
>>>
>>> --
>>>
>>> ***
>>>
>>> Calle Hedberg
>>>
>>> 46D Alma Road, 7700 Rosebank, SOUTH AFRICA
>>>
>>> Tel/fax (home): +27-21-685-6472 <+27%2021%20685%206472>
>>>
>>> Cell: +27-82-853-5352 <+27%2082%20853%205352>
>>>
>>> Iridium SatPhone: +8816-315-19119 <+881%206%20315%2019119>
>>>
>>> Email: calle.hedb...@gmail.com
>>>
>>> Skype: calle_hedberg
>>>
>>> ***
>>>
>>>
>
>
> --
>
> ***
>
> Calle Hedberg
>
> 46D Alma Road, 7700 Rosebank, SOUTH AFRICA
>
> Tel/fax (home): +27-21-685-6472 <+27%2021%20685%206472>
>
> Cell: +27-82-853-5352 <+27%2082%20853%205352>
>
> Iridium SatPhone: +8816-315-19119 <+881%206%20315%2019119>
>
> Email: calle.hedb...@gmail.com
>
> Skype: calle_hedberg
>
> ***
>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-us...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] Response was not a WebMessage with the expected format

[Calle Hedberg]

Stanley,

1. You can use api calls to add or remove OUs from groups.

2. You can use SQL scripts to do the same

3. If your instance is on localhost - permanently or temporarily - you can
use e.g. MS Access via ODBC to populate the OrgUnitGroupMember table. The
table itself is simple - just two fields - so it's easy to manipulate.

That table is regrettably not part of meta-data export/import, so you
cannot e.g. dump out a CSV file and then manipulate that before importing
it again. I've written a JIRA issue for this - DHIS2-658

Regards
Calle

On 5 February 2017 at 12:36, Stanley Kalyati  wrote:

> Thanks Calle.
>
> I hope the dev team will work on it soon as i am stuck now.
>
> Stanley
>
> On Feb 5, 2017 12:34 PM, "Calle Hedberg"  wrote:
>
>> Hi
>>
>> It's a (serious) bug - reported on JIRA DHIS2-570 on the 25th January.
>>
>> Nothing's been done about it so far, most likely due to the rush to
>> finalise 2.26. It's probably a simple bug to fix since allocating OUs to
>> groups worked in previous versions.
>>
>> Regards
>> calle
>>
>> On 5 February 2017 at 12:21, Stanley Kalyati  wrote:
>>
>>> I am using DHIS2 2.25 and when i want to add a Facility to a particular
>>> group,am getting the above message.What does that mean and if there is
>>> someone who can help out.
>>>
>>> I cant add facilities to any groups.
>>>
>>> Stanley
>>>
>>> ___
>>> Mailing list: https://launchpad.net/~dhis2-devs
>>> Post to : dhis2-devs@lists.launchpad.net
>>> Unsubscribe : https://launchpad.net/~dhis2-devs
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>>
>>
>>
>> --
>>
>> ***
>>
>> Calle Hedberg
>>
>> 46D Alma Road, 7700 Rosebank, SOUTH AFRICA
>>
>> Tel/fax (home): +27-21-685-6472 <+27%2021%20685%206472>
>>
>> Cell: +27-82-853-5352 <+27%2082%20853%205352>
>>
>> Iridium SatPhone: +8816-315-19119 <+881%206%20315%2019119>
>>
>> Email: calle.hedb...@gmail.com
>>
>> Skype: calle_hedberg
>>
>> ***
>>
>>


-- 

***

Calle Hedberg

46D Alma Road, 7700 Rosebank, SOUTH AFRICA

Tel/fax (home): +27-21-685-6472

Cell: +27-82-853-5352

Iridium SatPhone: +8816-315-19119

Email: calle.hedb...@gmail.com

Skype: calle_hedberg

***
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] Response was not a WebMessage with the expected format

[Stanley Kalyati]

Thanks Calle.

I hope the dev team will work on it soon as i am stuck now.

Stanley

On Feb 5, 2017 12:34 PM, "Calle Hedberg"  wrote:

> Hi
>
> It's a (serious) bug - reported on JIRA DHIS2-570 on the 25th January.
>
> Nothing's been done about it so far, most likely due to the rush to
> finalise 2.26. It's probably a simple bug to fix since allocating OUs to
> groups worked in previous versions.
>
> Regards
> calle
>
> On 5 February 2017 at 12:21, Stanley Kalyati  wrote:
>
>> I am using DHIS2 2.25 and when i want to add a Facility to a particular
>> group,am getting the above message.What does that mean and if there is
>> someone who can help out.
>>
>> I cant add facilities to any groups.
>>
>> Stanley
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to : dhis2-devs@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
>
> --
>
> ***
>
> Calle Hedberg
>
> 46D Alma Road, 7700 Rosebank, SOUTH AFRICA
>
> Tel/fax (home): +27-21-685-6472 <+27%2021%20685%206472>
>
> Cell: +27-82-853-5352 <+27%2082%20853%205352>
>
> Iridium SatPhone: +8816-315-19119 <+881%206%20315%2019119>
>
> Email: calle.hedb...@gmail.com
>
> Skype: calle_hedberg
>
> ***
>
>
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] Response was not a WebMessage with the expected format

[Calle Hedberg]

Hi

It's a (serious) bug - reported on JIRA DHIS2-570 on the 25th January.

Nothing's been done about it so far, most likely due to the rush to
finalise 2.26. It's probably a simple bug to fix since allocating OUs to
groups worked in previous versions.

Regards
calle

On 5 February 2017 at 12:21, Stanley Kalyati  wrote:

> I am using DHIS2 2.25 and when i want to add a Facility to a particular
> group,am getting the above message.What does that mean and if there is
> someone who can help out.
>
> I cant add facilities to any groups.
>
> Stanley
>
> ___
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-devs@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 

***

Calle Hedberg

46D Alma Road, 7700 Rosebank, SOUTH AFRICA

Tel/fax (home): +27-21-685-6472

Cell: +27-82-853-5352

Iridium SatPhone: +8816-315-19119

Email: calle.hedb...@gmail.com

Skype: calle_hedberg

***
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

[Dhis2-devs] Response was not a WebMessage with the expected format

[Stanley Kalyati]

I am using DHIS2 2.25 and when i want to add a Facility to a particular
group,am getting the above message.What does that mean and if there is
someone who can help out.

I cant add facilities to any groups.

Stanley
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

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

[Raminosoa Rabemanantsoa, Tantely]

Dear Jason,

Thank you for this information. I will adapt the calculations from
dataElements then. It is a bit hard to output from the analytics as we need
the values of specific indicators of all the lowest level of orgUnits
across all periods, so we need to split the queries into orgUnits / periods.

With Kind Regards,

Tantely.

Le 5 févr. 2017 10:26 AM, "Jason Pickering"  a
écrit :

> Hi Tantley,
> This is not really so straightforward with SQL as far as I know, as
> indicators are calculated "on-the-fly" from the "analytics_***" tables.
> They are never persisted in the database, so you would need a means to
> parse the syntax of the indicator, and make the calculation from that. I
> seem to recall that someone had done something a while back with
> materializing indicators, so you might want 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, Raminosoa Rabemanantsoa, Tantely <
> tramino...@mikolo.org> wrote:
>
>> 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 and its attachments are confidential and solely for the
>> intended recipients. If received in error, please delete them and notify
>> the sender via reply e-mail immediately.*
>> ___
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to : dhis2-devs@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
>
> --
> Jason P. Pickering
> email: jason.p.picker...@gmail.com
> tel:+46764147049 <+46%2076%20414%2070%2049>
>

-- 
*This message and its attachments are confidential and solely for the 
intended recipients. If received in error, please delete them and notify 
the sender via reply e-mail immediately.*
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] Assigning tracked entity attribute to Program - display in list OFF

[Calle Hedberg]

Elmarie,

Thanks for the clarification (why things like that is not outlined in the
User manual is, well...). And yes, I can use a validation rule, but I
wanted to know if there was another way...

Regards
Calle

On 5 February 2017 at 10:04, Elmarie Claasen  wrote:

> Hi Calle,
>
> The display in list option when ert to yes means that when you search for
> a TEI that specific field displays in the list.
>
> Can you not use program rules to hide that field on the capture screen
> when e.g. Enrollment date is not null?
>
> Elmarie
>
> On 05 Feb 2017 02:35, "Calle Hedberg"  wrote:
>
>> Hi
>>
>> I would like to assign one tracked entity attribute to a program, but
>> with that specific attribute NOT appearing in the attribute list during
>> Tracker Capture. (NOTE: my only reason for including this "hidden"
>> attribute is that program notifications cannot access data element values,
>> so I'm using an ASSIGN validation rule to "copy" a needed data element
>> value into this attribute so it can be used as part of the notification
>> template).
>>
>> My assumption was that unticking the "Display in List" setting would do
>> this, but it has no effect whatsoever - the specific attribute still appear
>> in the data capture standard form and you can capture data the usual way.
>> This is 2.25, latest build.
>>
>> 1. IS there another way to have "hide" an attribute in a program?
>>
>> 2. Does anybody know what that "Display in List" setting actually DO?
>> What "list" does it refer to?
>>
>> (the user manual does not go beyond the "add attributes and make sure one
>> of them has been set to Display in List" level - there's no explanations or
>> examples what the settings actually do).
>>
>> Regards
>> Calle
>>
>> ***
>>
>> Calle Hedberg
>>
>> 46D Alma Road, 7700 Rosebank, SOUTH AFRICA
>>
>> Tel/fax (home): +27-21-685-6472 <+27%2021%20685%206472>
>>
>> Cell: +27-82-853-5352 <+27%2082%20853%205352>
>>
>> Iridium SatPhone: +8816-315-19119 <+881%206%20315%2019119>
>>
>> Email: calle.hedb...@gmail.com
>>
>> Skype: calle_hedberg
>>
>> ***
>>
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to : dhis2-devs@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
> *This message and any attachments are subject to a disclaimer published at
> http://www.hisp.org/policies.html#comms_disclaimer
> .  Please read the
> disclaimer before opening any attachment or taking any other action in
> terms of this electronic transmission.  If you cannot access the
> disclaimer, kindly send an email to disclai...@hisp.org
>  and a copy will be provided to you. By replying to
> this e-mail or opening any attachment you agree to be bound by the
> provisions of the disclaimer.*
>



-- 

***

Calle Hedberg

46D Alma Road, 7700 Rosebank, SOUTH AFRICA

Tel/fax (home): +27-21-685-6472

Cell: +27-82-853-5352

Iridium SatPhone: +8816-315-19119

Email: calle.hedb...@gmail.com

Skype: calle_hedberg

***
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] Assigning tracked entity attribute to Program - display in list OFF

[Elmarie Claasen]

Hi Calle,

The display in list option when ert to yes means that when you search for a
TEI that specific field displays in the list.

Can you not use program rules to hide that field on the capture screen when
e.g. Enrollment date is not null?

Elmarie

On 05 Feb 2017 02:35, "Calle Hedberg"  wrote:

> Hi
>
> I would like to assign one tracked entity attribute to a program, but with
> that specific attribute NOT appearing in the attribute list during Tracker
> Capture. (NOTE: my only reason for including this "hidden" attribute is
> that program notifications cannot access data element values, so I'm using
> an ASSIGN validation rule to "copy" a needed data element value into this
> attribute so it can be used as part of the notification template).
>
> My assumption was that unticking the "Display in List" setting would do
> this, but it has no effect whatsoever - the specific attribute still appear
> in the data capture standard form and you can capture data the usual way.
> This is 2.25, latest build.
>
> 1. IS there another way to have "hide" an attribute in a program?
>
> 2. Does anybody know what that "Display in List" setting actually DO? What
> "list" does it refer to?
>
> (the user manual does not go beyond the "add attributes and make sure one
> of them has been set to Display in List" level - there's no explanations or
> examples what the settings actually do).
>
> Regards
> Calle
>
> ***
>
> Calle Hedberg
>
> 46D Alma Road, 7700 Rosebank, SOUTH AFRICA
>
> Tel/fax (home): +27-21-685-6472 <+27%2021%20685%206472>
>
> Cell: +27-82-853-5352 <+27%2082%20853%205352>
>
> Iridium SatPhone: +8816-315-19119 <+881%206%20315%2019119>
>
> Email: calle.hedb...@gmail.com
>
> Skype: calle_hedberg
>
> ***
>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-devs@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>

-- 


*This message and any attachments are subject to a disclaimer published at 
http://www.hisp.org/policies.html#comms_disclaimer 
.  Please read the 
disclaimer before opening any attachment or taking any other action in 
terms of this electronic transmission.  If you cannot access the 
disclaimer, kindly send an email to disclai...@hisp.org 
 and a copy will be provided to you. By replying to 
this e-mail or opening any attachment you agree to be bound by the 
provisions of the disclaimer.*
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp