available that we
could use to fix this?
Regards
Ant Snyman
Below the table which seems to reflect an older format
column_name ordinal_position
dataelementid 1
periodid 2
sourceid 3
categoryoptioncomboid 4
value 5
storedby 6
lastupdated 7
comment 8
followup 9
attributeoptioncomboid 10
created
then it only
partially creates _dateperiodstructure_temp and stops at acertain point
and displys the error.
I had a look at the logs ... please find attachedbut the logs did not
provide any more clarity.
Has anyone experienced this before and found a solution?
Regards
*Ant Snyman*
*Cell: 0824910449*
*L
x27;s orgunitgroupmembership would
have been removed.
Any comments?
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/policies
gt;
> *Norwegian Refugee Council*
>
> www.nrc.no| Facebook <https://www.facebook.com/norwegianrefugeecouncil> |
> Twitter <https://twitter.com/nrc_norway>
>
>
>
> [image: cid:image001.png@01D348CB.BE410710]
>
>
>
>
>
>
>
> *From:* Dhis2-users [
>
>
> *From:* Dhis2-users [mailto:dhis2-users-bounces+georgi=
> logicaloutcomes@lists.launchpad.net] *On Behalf Of *Ant Snyman
> *Sent:* Tuesday, October 31, 2017 10:14 AM
> *To:* DHIS 2 Users list
> *Subject:* [Dhis2-users] Attributeoptioncombo use in indicators
>
>
>
> Dear
ble to likewise
reference a specific attributeoptioncombo within an indicator?
Thank you
*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/polic
g <https://www.dhis2.org/>
>
> _______
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@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
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
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
>>>> Mailing list: https://launchpad.net/~dhis2-users
>>>> Post to : dhis2-users@lists.launchpad.net
>>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>>> More help : https://help.launchpad.net/L
is code not a
compulsory field any more? If not compulsory, then what will be stored in
the value column of the trackedentityattributevalue and
trackedentitydatavalue tables?
Regards
*Ant Snyman*
*Cell: 0824910449*
*Landline: 028 2713242*
Health Information Systems Program - SA
--
t to : dhis2-users@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
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
Hi Henri,
I read on this forum that someone was attempting to use Kettle (Pentaho
Data Integration). I don't know whether they succeeded.
Regards
Ant Snyman
On 21 March 2016 at 18:21, henri claude moungui
wrote:
> Thank you Knut.
>
> Henri
>
>
>
>
>
> Le Lundi
p://www.who.int/neglected_diseases
>
>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help : https://help.launchpad.
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/
8308835
> E-mail: rwil...@msh.org
> Skype: wilsonrandy_us
> <http://www.msh.org/>
> Stronger health systems. Greater health impact.
> <https://www.facebook.com/ManagementSciencesForHealth>
> <https://twitter.com/MSHHealthImpact>
> <https://www.youtube.com
select the entity again,
5. Select the programstageinstance (event)
6. Add values for the dataelements
7. and click "Back"
...then the datavalues are stored.
These events are not auto-generated. So the user have to go in, create and
save the event, and then enter the values for the dataelemen
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
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
:
> 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
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
30 matches
Mail list logo
