dhis2-users team mailing list archive

["Raminosoa Rabemanantsoa, Tantely" <traminosoa@xxxxxxxxxx>]

Thank you Knut.

Ragards,

Tantely.

On Thu, Jul 14, 2016 at 2:55 PM, Knut Staring <knutst@xxxxxxxxx> wrote:

> Hi, I am bringing this back to the list, since others can also chip in.
>
> Postgres comes with a command line tool called psql, and with a GUI app
> called PgAdmin III. I always use PgAdmin when I work locally, but usually
> just go through the command line on the server (though it is of course
> limited).
>
> As for the datamodel, the core tables for aggregate data are really all
> the ones that link to the datavalue table: dataelement, period, source
> (which links to organisationunit). Then the categoryoptioncombos is the key
> to a number of tables involved in the disaggregation.
>
> Knut
>
> On Thu, Jul 14, 2016 at 1:24 PM, Raminosoa Rabemanantsoa, Tantely <
> traminosoa@xxxxxxxxxx> wrote:
>
>> Yes, I have seen the message on the step be step upgrade process which is
>> quite straightforward. I am planning to practice the upgrade first with our
>> DHIS2 development instance. By the way, the DHIS2 that I am working on is
>> based on a postgreSQL database and I would like to have your opinion about
>> the best application (easy to use) you would recommend to connect directly
>> to the database in the server. I am familiar with SQL syntax. I am using
>> the SQL View of DHIS2 to query the database but it is very limited when
>> working with a large amount of data and in addition it is limited to the
>> SELECT command for DHIS2 2.19. I would like to be able to update the
>> metadata, data values,... with batch process directly in the database. All
>> links to a practical documenation or other knowledge resources about the
>> management of the DHIS2 database in the server side are welcome.
>>
>> Regards,
>>
>> Tantely.
>>
>> On Thu, Jul 14, 2016 at 12:03 PM, Knut Staring <knutst@xxxxxxxxx> wrote:
>>
>>> There are 4 releases per year. You don't have to follow each and every
>>> one, and it usually is prudent to wait a few weeks after each release, so
>>> that bugs can be sorted out. I suggest you move to 2.23 for now.
>>>
>>> Did you see the messages lately on how to do the upgrade step by step?
>>>
>>> Knut
>>>
>>> On Thu, Jul 14, 2016 at 10:58 AM, Raminosoa Rabemanantsoa, Tantely <
>>> traminosoa@xxxxxxxxxx> wrote:
>>>
>>>> Hi Knut,
>>>>
>>>> Thank you for your suggestion. Which version is now the most stabe to
>>>> migrate to as the version of DHIS2 is changing quickly over time?
>>>>
>>>> Regards,
>>>>
>>>> Tantely
>>>>
>>>> On Thu, Jul 14, 2016 at 11:04 AM, Knut Staring <knutst@xxxxxxxxx>
>>>> wrote:
>>>>
>>>>> Hi Tantely,
>>>>>
>>>>> I don't have an answer to this question, but would suggest you try and
>>>>> upgrade from 2.19, since that is now more than a year old, and many things
>>>>> have improved since (and people don't remember how things worked back then).
>>>>>
>>>>> Regards,
>>>>> Knut
>>>>>
>>>>> On Thu, Jul 14, 2016 at 9:54 AM, Raminosoa Rabemanantsoa, Tantely <
>>>>> traminosoa@xxxxxxxxxx> wrote:
>>>>>
>>>>>> Dear All,
>>>>>>
>>>>>> I am asking if someone has already done, in the pivot table, a single
>>>>>> display of the list of organization units with the name of the organization
>>>>>> unit group where they belong to. In pivot table, I have used the “select
>>>>>> groups” in the selection mode during the selection of the organization
>>>>>> units. The output result I get is only showing the list of the organization
>>>>>> units that belong to the selected group and there is no way to output the
>>>>>> name of the selected group itself in this result. I have tried to show the
>>>>>> organization units hierarchy in the pivot table options but it only output
>>>>>> the names of all orgunits in the hierarchy.
>>>>>>
>>>>>>
>>>>>> All suggestions are welcome. DHIS2 2.19.
>>>>>>
>>>>>>
>>>>>> Regards,
>>>>>>
>>>>>> Tantely.
>>>>>>
>>>>>> *This message and its attachments are confidential and solely for the
>>>>>> intended recipients. If received in error, please delete them and notify
>>>>>> the sender via reply e-mail immediately.*
>>>>>> _______________________________________________
>>>>>> 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
>>>>>
>>>>
>>>>
>>>>
>>>> --
>>>> *Tantely Raminosoa*
>>>> *Data Officer*
>>>> Management Sciences for Health
>>>> Antananarivo Madagascar
>>>> Mobile: 0321180040
>>>> E-mail: traminosoa@xxxxxxxxxx
>>>> Skype: traminosoa
>>>> <http://www.msh.org/>
>>>> Stronger health systems. Greater health impact.
>>>> <https://www.facebook.com/ManagementSciencesForHealth>
>>>> <https://twitter.com/MSHHealthImpact>
>>>> <https://www.youtube.com/user/MSHHealthImpact>
>>>> www.msh.org
>>>>
>>>> *This message and its attachments are confidential and solely for the
>>>> intended recipients. If received in error, please delete them and notify
>>>> the sender via reply e-mail immediately.*
>>>>
>>>
>>>
>>>
>>> --
>>> Knut Staring
>>> Dept. of Informatics, University of Oslo
>>> Norway: +4791880522
>>> Skype: knutstar
>>> http://dhis2.org
>>>
>>
>>
>>
>> *This message and its attachments are confidential and solely for the
>> intended recipients. If received in error, please delete them and notify
>> the sender via reply e-mail immediately.*
>>
>
>
>
> --
> Knut Staring
> Dept. of Informatics, University of Oslo
> Norway: +4791880522
> Skype: knutstar
> http://dhis2.org
>

-- 
*This message and its attachments are confidential and solely for the 
intended recipients. If received in error, please delete them and notify 
the sender via reply e-mail immediately.*