dhis2-devs team mailing list archive

[Calle Hedberg <calle.hedberg@xxxxxxxxx>]

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

*******************************************