dhis2-devs team mailing list archive

[Knut Staring <knutst@xxxxxxxxx>]

Hi Moses,

Is this a test database or production? In any case, please always make sure
to take a backup of your database before doing any kind of SQL.

If you want to convert ALL the dataelements in your database to Tracker,
then this should suffice:

update dataelement set domaintype='TRACKER'

Please be aware that it will convert everything. If you first want to take
a look at which ones you want to convert, then do something like this:

select dataelementid, name, domaintype from dataelement

Knut

On Tue, Feb 23, 2016 at 9:19 AM, moses mwale <isoftcom.ic@xxxxxxxxx> wrote:

> hello
>
> someone have an idea on how to convert data Elements which are created as
> aggregates to tracker using sql at once.. please need your help
>
>
> --
> developer_lusaka_systems
>
> _______________________________________________
> 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
>
>


-- 
Knut Staring
Dept. of Informatics, University of Oslo
Norway: +4791880522
Skype: knutstar
http://dhis2.org