dhis2-devs team mailing list archive

[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)
>