dhis2-users team mailing list archive

[Jason Pickering <jason.p.pickering@xxxxxxxxx>]

Just load the script in your database and execute it with

SELECT * FROM delete_site_with_data('tPR9B5xETb');

Regards,
Jason

On Thu, Oct 11, 2018 at 4:08 PM Walusiku Muyunda <jomuwalu@xxxxxxxxx> wrote:

> Hi Jason,
>
> Please help with syntax for this line:
> EXECUTE 'SELECT organisationunitid from organisationunit where uid =
> 'tPR9B5xETb'''' ||   $1  || ''''  INTO organisationunitid; Is this where I
> need to specify the uid?
>
> Thanks.
>
> *Walusiku J. Muyunda*
>
>
> *Cell: +260967006614Cell: +260971000614*
> *Cell: +260953063387*
>
> *"We have heaven to win and hell to shun, our lives testify better!"
> <http://wildvoices.blogspot.com/>*
>
>
> On Thu, Oct 11, 2018 at 1:10 PM Walusiku Muyunda <jomuwalu@xxxxxxxxx>
> wrote:
>
>> Thank you Jason, this will be very helpful. Am using v2.28 and hope the
>> script will run without complaints.
>>
>> Regards.
>>
>>
>> *Walusiku J. Muyunda*
>>
>>
>> *Cell: +260967006614Cell: +260971000614*
>> *Cell: +260953063387*
>>
>> *"We have heaven to win and hell to shun, our lives testify better!"
>> <http://wildvoices.blogspot.com/>*
>>
>>
>> On Thu, Oct 11, 2018 at 12:12 PM Jason Pickering <
>> jason.p.pickering@xxxxxxxxx> wrote:
>>
>>> Hi there!
>>>
>>> You can have a look here
>>> https://github.com/dhis2/dhis2-utils/blob/master/resources/sql/delete_orgunit_with_data.sql
>>>
>>> which will delete the site and all object associated with it. You should
>>> supply the UID of the orgunit you wish to delete as a paramater to the
>>> Postgresql function.
>>>
>>> You may also need to update the script to suit the version of DHIS2 you
>>> are running.
>>>
>>> As usual, be sure to test this on a development database first!
>>>
>>> Best regards,
>>> Jason
>>>
>>>
>>> On Thu, Oct 11, 2018 at 10:49 AM Walusiku Muyunda <jomuwalu@xxxxxxxxx>
>>> wrote:
>>>
>>>> Dear All,
>>>>
>>>> Is there there anyone with a script to disassociate an Orgunit from all
>>>> associated programs or data sets so I can be able to delete it from within
>>>> DHIS2?
>>>>
>>>> Thank you.
>>>>
>>>>
>>>>
>>>> *Walusiku J. Muyunda*
>>>>
>>>>
>>>> *Cell: +260967006614Cell: +260971000614*
>>>> *Cell: +260953063387*
>>>>
>>>> *"We have heaven to win and hell to shun, our lives testify better!"
>>>> <http://wildvoices.blogspot.com/>*
>>>> _______________________________________________
>>>> Mailing list: https://launchpad.net/~dhis2-users
>>>> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
>>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>>> More help   : https://help.launchpad.net/ListHelp
>>>>
>>>
>>>
>>> --
>>> Jason P. Pickering
>>> email: jason.p.pickering@xxxxxxxxx
>>> tel:+46764147049
>>>
>>

-- 
Jason P. Pickering
email: jason.p.pickering@xxxxxxxxx
tel:+46764147049