dhis2-devs team mailing list archive

[riddy ndoma <riddyndoma@xxxxxxxxx>]

Hi @Hola,
Thank you for this track solution. The bottom line is that I know where to
start, I'll dig more!


2013/11/15 Ola Hodne Titlestad <olati@xxxxxxxxxx>

> Hi Riddy,
>
> Have a look in Data Administration->Scheduling. There is an option for
> Resource Tables there.
> The scheduled tasks take place at midnight every day.
> You can read more about Scheduling in the manual.
>
> Ola
> -----
>
>
>
> ----------------------------------
> Ola Hodne Titlestad (Mr)
> HISP
> Department of Informatics
> University of Oslo
>
> Mobile: +47 48069736
> Home address: Eftasåsen 68, 0687 Oslo, Norway. Googlemaps link<https://maps.google.com/maps?q=Eftas%C3%A5sen+68,+0687+Oslo,+Norge&hl=en&ie=UTF8&sll=59.893855,10.785116&sspn=0.222842,0.585709&oq=eftas%C3%A5sen+68,+0687+Oslo,+&t=h&hnear=Eftas%C3%A5sen+68,+%C3%98stensj%C3%B8,+0687+Oslo,+Norway&z=16>
>
>
> On 14 November 2013 15:28, riddy ndoma <riddyndoma@xxxxxxxxx> wrote:
>
>> Thank you to the team for your support,
>>
>> Hi @Ola, then how to ensure that the resources automatically generate
>> tables? as you have said that there is possibility to activate it!
>>
>>
>> 2013/11/14 riddy ndoma <riddyndoma@xxxxxxxxx>
>>
>>> Thank you to the team for your support,
>>>
>>> Hi @Ola, then how to ensure that the resources automatically generate
>>> tables? as you have said that there is possibility of activated!
>>>
>>>
>>> 2013/11/14 Ola Hodne Titlestad <olati@xxxxxxxxxx>
>>>
>>>> Hi Riddy,
>>>>
>>>> The resource tables are not part of the schema or data model as such,
>>>> but generated by the system (from data administration) to make it easier
>>>> for db people to make select queries for reports etc. One example is the
>>>> hierarchical listing of orgunits in the _orgunitstructure table. This table
>>>> is updated by the nightly scheduling job, if that is enabled, or manually
>>>> from Data Administration. So that table might be out of sync with the
>>>> orgunit table, if you do not make sure it is re-generated.
>>>>
>>>> The levels/hierarchy of orgunits are managed through the parent
>>>> reference in the organisationunit table.
>>>>
>>>> The orgunitlevel table is just to store labels for each level, e.g.
>>>> used in the level selector in GIS.
>>>>
>>>> Ola
>>>> ------
>>>> On 14 Nov 2013 14:54, "riddy ndoma" <riddyndoma@xxxxxxxxx> wrote:
>>>>
>>>>> It is managed from the resource table _orgunitstructure. Since
>>>>> according to the diagram you gave me the orgunitlevel table is connected
>>>>> only with the Map table
>>>>>
>>>>>
>>>>> 2013/11/14 Knut Staring <knutst@xxxxxxxxx>
>>>>>
>>>>>> One place to start is the *generated* table (resource table) called
>>>>>> _orgunitstructure
>>>>>>
>>>>>> Knut
>>>>>>
>>>>>>
>>>>>> On Thu, Nov 14, 2013 at 2:43 PM, riddy ndoma <riddyndoma@xxxxxxxxx>wrote:
>>>>>>
>>>>>>> Hello,
>>>>>>> I am trying to explore the structure of the database administrator
>>>>>>> entant that perfect mastery of queries that the GUI does not allow dhis2, I
>>>>>>> wanted to know the table that connects organisationunit table and
>>>>>>> organitlevel table?
>>>>>>>
>>>>>>> --
>>>>>>> Riddy NDOMA
>>>>>>> Software Developer
>>>>>>> *Skype:* riddyndoma, *G+:* riddyndoma, *FB:* riddy ndoma
>>>>>>> *Twitter:* riddyndoma, *LinkedIn:* riddy ndoma
>>>>>>> *Blog:* http://riddyndoma.blogspot.com/
>>>>>>>
>>>>>>> Vous servir est mon désire (Serving you is my desire)
>>>>>>>
>>>>>>> _______________________________________________
>>>>>>> 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
>>>>>> +4791880522
>>>>>> http://dhis2.org
>>>>>>
>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> Riddy NDOMA
>>>>> Software Developer
>>>>> *Skype:* riddyndoma, *G+:* riddyndoma, *FB:* riddy ndoma
>>>>> *Twitter:* riddyndoma, *LinkedIn:* riddy ndoma
>>>>> *Blog:* http://riddyndoma.blogspot.com/
>>>>>
>>>>> Vous servir est mon désire (Serving you is my desire)
>>>>>
>>>>> _______________________________________________
>>>>> 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
>>>>>
>>>>>
>>>
>>>
>>> --
>>> Riddy NDOMA
>>> Software Developer
>>> *Skype:* riddyndoma, *G+:* riddyndoma, *FB:* riddy ndoma
>>> *Twitter:* riddyndoma, *LinkedIn:* riddy ndoma
>>> *Blog:* http://riddyndoma.blogspot.com/
>>>
>>> Vous servir est mon désire (Serving you is my desire)
>>>
>>
>>
>>
>> --
>> Riddy NDOMA
>> Software Developer
>> *Skype:* riddyndoma, *G+:* riddyndoma, *FB:* riddy ndoma
>> *Twitter:* riddyndoma, *LinkedIn:* riddy ndoma
>> *Blog:* http://riddyndoma.blogspot.com/
>>
>> Vous servir est mon désire (Serving you is my desire)
>>
>
>


-- 
Riddy NDOMA
Software Developer
*Skype:* riddyndoma, *G+:* riddyndoma, *FB:* riddy ndoma
*Twitter:* riddyndoma, *LinkedIn:* riddy ndoma
*Blog:* http://riddyndoma.blogspot.com/

Vous servir est mon désire (Serving you is my desire)