g them? Do these "duplicates" add to the database
overheads/performance degradation?
Best Regards
*Ant Snyman*
*Cell: 0824910449*
*Landline: 028 2713242*
Health Information Systems Program - SA
--
*This message and any attachments are subject to a disclaimer published
at
g <https://www.dhis2.org/>
>
> _______
> 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/L
a few different “enum” exceptions in the
> dhis.log file.
>
>
>
> OrganisationUnit
>
> String
>
> Property `url` requires a valid URL, was given `7.02149,4.76539`.
>
>
>
>
>
> Many Thanks in Advance,
>
>
>
> -Stephen
>
> _______
m
> FROM
> (SELECT * ,
> generate_subscripts(arr.path,1) AS rn
> FROM
> (SELECT organisationunitid,
> string_to_array(substring(path
> FROM 2), '/') AS path
> FROM organisationunit) arr) x) y ON y.elem = ou.uid) z
> GROUP BY organisationunitid;
>
> Regards,
> Jason
&
I should also add that by changing the where clause you can use this
code for any level, for example if you change it to:
where ous.level = 6 you will only get the structure for your level 6
orgunits
Regards
Ant Snyman
On 11 January 2017 at 07:05, Ant Snyman wrote:
> Hi Tantely,
>
Hi Tantely,
Try the code below. I normally exclude OU1 in the list because that is
generally the country code and just makes the report even more wide.
Regards
Ant Snyman
SELECT ous.level,
ou2.name as ou2_name, ou2.shortname as ou2_shortnamme, ou2.uid as ou2_uid,
ou2.code as ou2_code, ou2
, "channara rin" wrote:
>
>> Note thank you
>>
>> On Fri, Nov 18, 2016 at 2:20 PM, Ant Snyman wrote:
>>
>>> Yes you are right. Some sql scripts you can run from the UI (SQLVIEWS -
>>> data administration) but you cannot update or delete using
sts in the
datavalueaudit table. Something like "select * from datavalueaudit where
dataelementid = .. ".
Regards
Ant Snyman
On 18 November 2016 at 09:10, channara rin wrote:
> ohh,i see...
> but sql script can only run on server? cannot from client side?
>
> On Fri, Nov
Ant Snyman
On 18 November 2016 at 06:38, channara rin wrote:
> yes,
> my DE use cate-combo and group.
> so after remove group, i can delete?
>
>
> On Fri, Nov 18, 2016 at 11:30 AM, Prosper BT wrote:
>
>> Hi Channara,
>>
>> Did you assign it an option set
>>>> 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/L
Hi Markus,
Sorry I cleared all the cache's inside DHIS2 (statistics, browser,
application) but now I cleared the cache in Chrome...and now it works.
Thanks.
Regards
Ant
On 20 June 2016 at 16:15, Ant Snyman wrote:
> Hi Markus,
> Thanks for the feedback. I checked on play.dhis2.org t
To manage notifications about this bug go to:
> https://bugs.launchpad.net/dhis2/+bug/1593574/+subscriptions
>
--
*Ant Snyman*
*Cell: 0824910449*
*Landline: 028 2713242*
Health Information Systems Program - SA
--
*This message and any attachments are subject to a disclaimer publis
** Attachment added: "Browser Console pg 1.PNG"
https://bugs.launchpad.net/dhis2/+bug/1593574/+attachment/4685531/+files/Browser%20Console%20pg%201.PNG
--
You received this bug notification because you are a member of DHIS 2
developers, which is subscribed to DHIS.
https://bugs.launchpad.net/
** Attachment added: "Browser Console pg 3.PNG"
https://bugs.launchpad.net/dhis2/+bug/1593574/+attachment/4685534/+files/Browser%20Console%20pg%203.PNG
--
You received this bug notification because you are a member of DHIS 2
developers, which is subscribed to DHIS.
https://bugs.launchpad.net/
** Attachment added: "Browser Console pg 2.PNG"
https://bugs.launchpad.net/dhis2/+bug/1593574/+attachment/4685533/+files/Browser%20Console%20pg%202.PNG
--
You received this bug notification because you are a member of DHIS 2
developers, which is subscribed to DHIS.
https://bugs.launchpad.net/
And on our own tracker program attached is the Browser Development Tools
Screen.
** Attachment added: "Browser - Development Tools own tracker.PNG"
https://bugs.launchpad.net/dhis2/+bug/1593574/+attachment/4685527/+files/Browser%20-%20Development%20Tools%20own%20tracker.PNG
--
You received t
On play.dhis2.org/dev I can still replicate the problem with TB program.
Attached is the Browser Development Tools Screen for this:
** Attachment added: "Browser - Development Tools.PNG"
https://bugs.launchpad.net/dhis2/+bug/1593574/+attachment/4685517/+files/Browser%20-%20Development%20Tools
The event page is shown with the "Training" block under "Tabular Data Entry"
highlighted in blue, but nothing happens after that. Markus Bekken replicated
this issue on play, and this morning I was also able to replicate it. Since
then Alex has posted a workaround - I don't know whether the work
t to : dhis2-us...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help : https://help.launchpad.net/ListHelp
>
>
--
*Ant Snyman*
*Cell: 0824910449*
*Landline: 028 2713242*
Health Information Systems Program - SA
--
*This message and any
Public bug reported:
After upgrading to 2.23 build 22982 the tracker program completes the
registration, but on the programstage data entry screen the system just
hangs. This can be replicated on play.dhis2.org.
** Affects: dhis2
Importance: Undecided
Status: New
--
You received t
gned one new source port in increasing
order from the range of ephemeral ports(Its range is defined in file
/proc/sys/net/ipv4/ip_local_port_range). So at one point of time, it may
use the same source port as used for destination (if destination port is
also in the range of ephemeral ports).
*Ant Snyman*
*C
** Also affects: ubuntu
Importance: Undecided
Status: New
--
You received this bug notification because you are a member of DHIS 2
developers, which is subscribed to DHIS.
https://bugs.launchpad.net/bugs/1514693
Title:
Tracker Event Date changes to previous day on refresh
Status in
Public bug reported:
I posted a complete description of the bug (with the subject "Issue with
tracker - is it a feature or a bug?") on dhis2_devs with screen shots
from Sierra Leone. I also demonstrated this to Ola and Markus while in
Livingstone, Zambia and they confirmed that this is a bug (not
Hi Jason,
Nothing wrong with your eyesight!! I owe you a beer. Thanks, the 001 was
the issue.
Regards
Ant
On 27 October 2015 at 09:28, Ant Snyman wrote:
> Hi Jason, thanks for your response. This is what I used:
>
> insert into usersetting
> values
> (21527, 'keyMess
787000
>
> The first one should be when a user wishes to receive email, the second
> for when they do not. ( I think)
>
> Is this what your table looks like?
>
> Regards,
> Jason
>
>
> On Tue, Oct 27, 2015 at 8:19 AM, Knut Staring wrote:
>
>> Did you als
Where else in the database is the user flagged to receive email
notifications?
Regards
*Ant Snyman*
*Cell: 0824910449*
*Landline: 028 2713242*
Health Information Systems Program - SA
--
*This message and any attachments are subject to a disclaimer published at
http://www.hisp.org/
a.
And this is as much input as I can give with the information you have
provided.
Regards
Regards
Ant Snyman
On 23 August 2015 at 18:36, gerald thomas wrote:
> Juan,
> Thanks for your response but we are not using custom forms for data entry.
>
> Regards,
> Gerald
> On A
Thank you for your response. I have sorted out the problem and it was
neither cache nor browser related.
Regards
Ant Snyman
On 16 August 2015 at 09:15, Aanyo Melo AHIAGNO wrote:
> Hello
>
> Can you try, to do the something on the another browser ???
>
> AHIAGNO Aanyo
> HISP
:
> Hi Ant,
>
> after doing SQL against a running DHIS 2 instance you might want to go to
> data admin > cache statistics > clear cache. This since the cache might
> become stale unknowingly as a result of direct SQL queries.
>
> regards,
>
> Lars
>
>
> On
aight away because the "orphaned organisationunits" integrity check
always reports the name of the offending org unit, and never the uids.
But thanks for responding...
Regards
Ant
On 16 August 2015 at 08:41, Ant Snyman wrote:
> Thanks Lars or your response.
>
> Yes I did c
I cleared analytics, re-generated resource tables, cleared cache
and cache statistics and re-ran integrity checksthose org unit uids are
still appearing as "orphaned organisation units".
>From which table(s) is the integrity check picking these org units up from?
Thanks
*Ant Snyma
31 matches
Mail list logo
