Re: [Dhis2-users] Login for

2015-12-02 Thread Lars Helge Øverland
Hi Aluka, first I would say we should define what "using a data set" specifically means. I think your best shot is to write an SQL view . regards, Lars On Thu, Dec 3, 2015 at 5:29 AM, Aluka Terpase wrote: > Dear All > >

Re: [Dhis2-users] New way to share DHIS2 templates and tools

2015-12-02 Thread Patrick Tendayi Huni
Good Morning; I am looking for DHIS2 expertise in Zimbabwe urgently, Anyone within quick reach please reply to my email.. -- Patrick Tendayi Huni Managing Consultant Maxim Consulting Services (Pvt) Ltd 88 Crowhill Road, Quinnington, Harare Tel: +263 774 686 621 | 0718 686 621 ___

[Dhis2-users] Login for

2015-12-02 Thread Aluka Terpase
Dear All We have dhis2 with over 10 thousand users. How can I get a sense of the number people logged in using a particular data set. I have looked at the data administration>Data statistics but only a summary of users logged in Users logged in Number Last hour 8 Today 17 Last 2

Re: [Dhis2-users] MySQL for DHIS

2015-12-02 Thread Smith, Rebecca A.
Thanks Iuri and Lars! This is very helpful. -Original Message- From: Iuri Fanti [mailto:iuri.fa...@gmail.com] Sent: Wednesday, December 02, 2015 12:24 PM To: Lars Helge Øverland Cc: Smith, Rebecca A.; dhis2-users@lists.launchpad.net Subject: Re: [Dhis2-users] MySQL for DHIS Hi, we tried

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

2015-12-02 Thread Uwe Wahser
I feared this would be the answer, although I had hopes, since there is no unique key on those attributes in the db-table.It would help, if I was able to identify in the api response for CategoryOptionCombos, which CategoryOption came from which Category in that combination. Is there any way to g

Re: [Dhis2-users] MySQL for DHIS

2015-12-02 Thread Iuri Fanti
Hi, we tried to use MySQL, but it didn't work when we had to use OptionsSet values in DataElements for single events without registration. The OptionSet resulted empty, evidently because of some problem fetching data from MySQL. Iuri 2015-12-02 17:14 GMT+01:00 Lars Helge Øverland : > Hi Rebecca,

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

2015-12-02 Thread Lars Helge Øverland
On Wed, Dec 2, 2015 at 6:01 PM, Uwe Wahser wrote: > That's cheating :-D > > > True > What do you think of the option of just updating all the obsolete values > to 0 and have them eliminated by DHIS2 (I assume that 0-Values are being > eliminated unless I block this in the settings)? > > > It is

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

2015-12-02 Thread Uwe Wahser
That's cheating :-DWhat do you think of the option of just updating all the obsolete values to 0 and have them eliminated by DHIS2 (I assume that 0-Values are being eliminated unless I block this in the settings)?UweLars Helge Øverland hat am 2. Dezember 2015 um 17:49 geschrieben:Hi Uwe,you are

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

2015-12-02 Thread Lars Helge Øverland
Hi Uwe, the reason for having "global" uniqueness on category options is to simplify synchronization between systems and for uniformity between DHIS objects (codes are unique across all "identifiable objects"). I agree that it could be convenient to have uniqueness-within-category. That also provi

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

2015-12-02 Thread Lars Helge Øverland
Hi Uwe, you are right in that we do not support bulk deletion through the Web API. The main reason is that we want to avert disaster by someone doing it by mistake or through malicious activity. However we are getting an increasing number of requests for this so we will consider it. An effective

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

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

Re: [Dhis2-users] MySQL for DHIS

2015-12-02 Thread Lars Helge Øverland
Hi Rebecca, in order to use MySQL there is nothing else you need to do (beyond changing the database connection config properties like you say). Now MySQL is far less tested with DHIS 2 compared to Postgres so you are more likely to come across bugs and upgrade issues on MySQL. There is also a f

[Dhis2-users] MySQL for DHIS

2015-12-02 Thread Smith, Rebecca A.
Hi all, We have a partner who would strongly prefer to use MySQL instead of Postgres as the DHIS 2.21 database. The DHIS documentation notes that MySQL can be used but doesn't give much detail beyond the connection strings. Does anyone in this group have experience with using MySQL for DHIS? Ha

Re: [Dhis2-users] [Dhis2-devs] meta-data translations in analysis apps in 2.21

2015-12-02 Thread Victor Garcia
Wow! I am so happy to read this :-). Really very great news. Thanks to the team!! On 2 December 2015 at 13:02, Marta Vila wrote: > great news > > big thanks to the team!!! > > On 1 December 2015 at 21:18, Lars Helge Øverland > wrote: >> >> Hi, >> >> due to high demand we have added and back-por

Re: [Dhis2-users] [Dhis2-devs] meta-data translations in analysis apps in 2.21

2015-12-02 Thread Marta Vila
great news big thanks to the team!!! On 1 December 2015 at 21:18, Lars Helge Øverland wrote: > Hi, > > due to high demand we have added and back-ported support for translations > of meta-data in analysis apps in version 2.21. This means that if you > download the latest 2.21 from dhis2.org/down

[Dhis2-users] delete tracked entity instance

2015-12-02 Thread Abdul karim Jaafar
Dears, I want to ask you about delete tracked entity instance if data entry make something wrong in tracked entity instance he need to delete it, Or want to edit incident date after save it. Regards, ___ Mailing list: https://launchpad.n

Re: [Dhis2-users] user Authorities

2015-12-02 Thread Abyot Gizaw
Hi, This should work - http://ci.dhis2.org/job/dhis2-2.21/94/artifact/dhis-2/dhis-web/dhis-web-portal/target/dhis.war --- Thank you, Abyot. On Wed, Dec 2, 2015 at 11:16 AM, Oliver Munyao wrote: > Hi Abyot, > > Can you please share the .war file build download link > > On Wed, Dec 2, 2015 a

Re: [Dhis2-users] user Authorities

2015-12-02 Thread Abyot Gizaw
Hi Prosper, What problem do we have in 2.20? The fix is for a problem that happened just because individual records was removed. We don't need this fix for 2.20 --- Thank you, Abyot. On Wed, Dec 2, 2015 at 11:04 AM, Prosper BT wrote: > Hi Abyot, > > Can you backport the fix also to 2.20? > >

Re: [Dhis2-users] user Authorities

2015-12-02 Thread Prosper BT
Hi Abyot, Can you backport the fix also to 2.20? Regards On Wed, Dec 2, 2015 at 12:58 PM, Abyot Gizaw wrote: > You need to wait for at least half an hour to get the latest war file ... > just make sure you have revision 20935. > > > --- > Thank you, > Abyot. > > On Wed, Dec 2, 2015 at 10:50 AM

Re: [Dhis2-users] user Authorities

2015-12-02 Thread Nami Ghadri
Ok thanks again From: Abyot Gizaw [mailto:aby...@gmail.com] Sent: Wednesday, December 2, 2015 11:58 AM To: Nami Ghadri Cc: omun...@gmail.com; DHIS 2 Users list Subject: Re: [Dhis2-users] user Authorities You need to wait for at least half an hour to get the latest war file ... just m

Re: [Dhis2-users] user Authorities

2015-12-02 Thread Abyot Gizaw
You need to wait for at least half an hour to get the latest war file ... just make sure you have revision 20935. --- Thank you, Abyot. On Wed, Dec 2, 2015 at 10:50 AM, Nami Ghadri wrote: > I think it’s not there yet > > > > Kindly advice > > > > Regards, > > > > > > *From:* Dhis2-users [mailt

Re: [Dhis2-users] user Authorities

2015-12-02 Thread Nami Ghadri
I think it’s not there yet Kindly advice Regards, From: Dhis2-users [mailto:dhis2-users-bounces+nami_ghadri=hotmail@lists.launchpad.net] On Behalf Of Nami Ghadri Sent: Wednesday, December 2, 2015 11:46 AM To: 'Abyot Gizaw' ; omun...@gmail.com Cc: 'DHIS 2 Users list' Subject:

Re: [Dhis2-users] user Authorities

2015-12-02 Thread Abyot Gizaw
Hi Nami, Munyao, Just now we made a small fix regarding authorities - please go for revision 20935 of 2.21. --- Thank you, Abyot. On Wed, Dec 2, 2015 at 10:18 AM, Nami Ghadri wrote: > Dear Abyot, > > > > As I told you I could’t find the bellow in the Authorities filed but what > I did is addi

Re: [Dhis2-users] user Authorities

2015-12-02 Thread Nami Ghadri
That’s great thanks for information Regards, From: Abyot Gizaw [mailto:aby...@gmail.com] Sent: Wednesday, December 2, 2015 11:44 AM To: Nami Ghadri ; omun...@gmail.com Cc: DHIS 2 Users list Subject: Re: [Dhis2-users] user Authorities Hi Nami, Munyao, Just now we made a small fi

Re: [Dhis2-users] user Authorities

2015-12-02 Thread Nami Ghadri
Dear Abyot, As I told you I could’t find the bellow in the Authorities filed but what I did is adding the following in database: The 475569 is my userroleid which I created insert into userroleauthorities(userroleid,authority) values(475569,'F_PROGRAM_UNENROLLMENT'); insert into userro

Re: [Dhis2-users] user Authorities

2015-12-02 Thread Nami Ghadri
Dear Abyot, I can’t find the following in the Authorities: - Add/Update Tracked Entity Instance - Delete Tracked Entity Instance - Program Enrollment - Program Un-enrollment Pleas advice From: Dhis2-users [mailto:dhis2-users-bounces+nami_ghadri=hotmail@l

Re: [Dhis2-users] user Authorities

2015-12-02 Thread Nami Ghadri
Hello abyot, I am using 2.21 latest revision , I created new user role , and I will try what u sent me Thanks for replay From: Abyot Gizaw [mailto:aby...@gmail.com] Sent: Wednesday, December 2, 2015 10:11 AM To: Nami Ghadri Cc: DHIS 2 Users list Subject: Re: [Dhis2-users] use

Re: [Dhis2-users] user Authorities

2015-12-02 Thread Abyot Gizaw
Hi Nami, Which version of DHIS2 are you using? and what are the user roles you assigned? In addition to assigning program to your user, below are the authorities you need for tracker apps. *Event Capture* Add/Update Tracked Entity Data Value Delete Tracked Entity Data Value *Tracker Capture*

Re: [Dhis2-users] MySQL to Postgres Conversion

2015-12-02 Thread Knut Staring
I think I would probably rather try doing meta data and data exports and imports, rather than direct conversions. Knut On Wed, Dec 2, 2015 at 11:19 AM, Morten Olav Hansen wrote: > Hi Hari > > I'm not sure exactly what needs to make the move successful, but did you > try and have a look at the l