dhis2-devs team mailing list archive

[Calle Hedberg <calle.hedberg@xxxxxxxxx>]

Bret,

you have two options:

1.
For LARGE once-off bulk imports (more than 50K cases), consider using
Kettle or similar

2.
For smaller bulk imports that might have to be repeated, I would insert
cases one by one using API calls. A bit slow, but you can in general manage
5-10,000 cases per day - depending on server performance etc, of course.

regards
Calle

On 14 May 2018 at 13:04, Bret Watson <bret@xxxxxxxx> wrote:

> 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
> >
> > *******************************************
> >
> >
>



-- 

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

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

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