dhis2-devs team mailing list archive

[Bret Watson <bret@xxxxxxxx>]

So to expand on this...

I think we have somewhere around five tables, how do I carry IDs from
one table to another? I need to link the ingredients of substance to
the caller's substance and then to an individual call within the case
somehow :)

Thanks
Bret

On 14 May 2018 at 18:38, Calle Hedberg <calle.hedberg@xxxxxxxxx> wrote:
> Bret,
>
> A few points;
>
> 1.
> You need to clarify what your organisational hierarchy will be - it is one
> of the anchor dimensions in the DHIS. What is your "end" or 'leaf" type of
> orgunit? Health facility or suspected poison site? (restaurant, landfill,
> etc).
>
> 2.
> Do you intend to track poison cases over time (multiple events?) on a
> regular basis? If yes, Tracker will probably fit best even if you have
> limited tracked entity registration nformation to begin with. If no, I would
> use Tracker without registration (single event reporting).
>
> 3.
> Single events can be exported/imported via CSV - tracker data cannot,
> regrettable. We use Pentaho Kettle for bulk importing of tracker data. With
> tracker data, you have to populate multiple tables in sequence, with each
> step returning id values that are used in subsequent tables
> - the trackedentityinstance table (registration)
> - the programinstance table (enrollment)
> - the trackedentityattributevalue table (enrollment details)
> - the programstageinstance table (stage/event registration)
> - the trackedentitydatavalue table (stage/event details)
>
> Best regards from Freetown, Sierra Leone
> Calle
>
>
> On 14 May 2018 at 11:47, Bret Watson <bret@xxxxxxxx> wrote:
>>
>> I was referred to this list for the below question... :) Can anyone help?
>> Thanks
>>
>>
>> Subject: tracker question and applicability/hack
>>
>> Hi all,
>> we are hoping to use DHIS2 as an analytics backend for our poison
>> information centre application...
>>
>> What we are capturing are cases, normally the patient is not well
>> identified, but we plan to track the case itself as these normally
>> have a reasonably well defined exposure location and can have a
>> defined guid. Often they are a single event, but they can become many
>> events over a period of time. They are very useful for public health
>> in this form as they can be used to detect poisoning clusters for
>> investigation (poor restaurant hygiene, heavy metals contamination,
>> nerve agents etc)
>>
>> We'd like to push them into DHIS2 as tracker items, but are wondering
>> how exactly to work around tracker expectation of tracking events
>> within a program/program stage?
>>
>> Also for testing and migrations we'd like to be able to bulk load data
>> via csv, but is it possible to bulk load the tracked entities via csv
>> as well?
>>
>> Thanks in advance
>>
>> _______________________________________________
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>> 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.hedberg@xxxxxxxxx
>
> Skype: calle_hedberg
>
> *******************************************
>
>