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.hedb...@gmail.com> 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 <b...@ticm.com> 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@lists.launchpad.net >> 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.hedb...@gmail.com > > Skype: calle_hedberg > > ******************************************* > > _______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
