dhis2-devs team mailing list archive

[Adebusoye Anifalaje <busoye@xxxxxxxx>]

Thanks Lars,

This was a bit confusing because it seemed the upgrade script had been run
but there is still a Patientdatavalue table with data in it. What happens
if the database had been upgraded to 2.15 and used extensively before the
upgrade script is run. I just tried to run the upgrade script again and get
the message: ERROR: table "patientaggregatereportmembers" does not exist.

Suggestions?

Thanks.

Busoye



On 7 May 2014 15:46, Lars Helge Øverland <larshelge@xxxxxxxxx> wrote:

> Hi Busyoe,
>
> what happened here is simply that we have removed the web user interface
> in "individual records" module for capturing single events with
> registration. You will find the same functionality with a simpler and
> better user interface in the new "event capture" app.
>
> The database (or dhis service layer) does not change at all due to this,
> and is not related to aggregation queries.
>
> For upgrading between 2.14 and 2.15 you must run the upgrade script which
> you can find next to the war file on dhis2.org/downloads, direct link:
>
>
> http://www.dhis2.org/download/resources/sql/rename-patient-to-trackedentity.sql
>
> This will rename the tables from patient* to trackedentity*
>
>
>
> cheers
>
> Lars
>
>
>
>
>
>
> On Wed, May 7, 2014 at 4:25 PM, Adebusoye Anifalaje <busoye@xxxxxxxx>wrote:
>
>> Does this change mean that data entered for single event without
>> registration will be stored in the trackedentitydatavalue table instead of
>> patientdatavalue table. I am working on a single event without registration
>> program. Aggregation does not work at all for all the aggregation queries.
>> I copied the data from the patientdatavalue table to the
>> trackedentitydatavalue table and this works (crooked way to go about it but
>> experimenting). It would be useful to know which table the event capture
>> app stores data and how this might help my case.
>>
>> Can anyone advise? I have already logged an entry on the user list about
>> the requirements.
>>
>> Thanks.
>>
>> Regards,
>>
>> Busoye
>>
>> _______________________________________________
>> 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
>>
>>
>