[ckan-dev] Deleting/purging an organisation CKAN 2.1

Jason Tan jason.tan at ersa.edu.au
Tue Jun 3 00:14:33 UTC 2014


Hi David,

I've be happy to turn the "deleted" group back on, but I'm not sure what I
need to do.

I've changed it's "state" column value in the database from "deleted" to
"active" and that has not re-activated the group.
The other problem is that we actually want the name to be used for an
organisation now, not a group.
I would assume you can do this by setting the is_organization and type
columns appropriately, but I'm not sure if any other changes would need to
be made to the DB.

Because of all that I thought actually deleting might be easier, but if
someone knows the 2.1.1 schema well enough to allow me to turn the group on
and change the group to an organization, I'd be happy to do that.

Regards
Jason Tan


On 3 June 2014 04:17, David Megginson <david.megginson at megginson.com> wrote:

> CKAN doesn't like to hard-delete things. Would it make more sense to
> remove all users and datasets from the organisation manually, then just
> reassign it to new users and datasets?
>
>
> Cheers, David
>
>
> On Mon, Jun 2, 2014 at 4:17 AM, Jason Tan <jason.tan at ersa.edu.au> wrote:
>
>> Hi All,
>>
>> I'm trying to remove a deleted CKAN organisation/group from CKAN 2.1.1.
>> The reason we want to do this is because we have decided that we want to
>> use the same name/URL again, so advice on how to "turn it on" again would
>> be just as useful for now.
>>
>> I gather from these emails in a thread from Feb that I should be doing an
>> organization_purge
>> https://lists.okfn.org/pipermail/ckan-dev/2014-February/006906.html
>> https://lists.okfn.org/pipermail/ckan-dev/2014-February/006908.html
>>
>> But I can't seem to get organization purge to work with 2.1.1 (see output
>> below).
>>
>> So my questions are:
>> 1) Is the organization_purge implemented in 2.1.1?
>> 2) If it is not how do I remove an organization completely?
>> 3) Can I turn the organization back on - is it simply a matter of
>> changing  the state column of the group table from "deleted" to "active" or
>> is there more to it than this?
>>
>> Thanks and Regards
>> Jason Tan
>>
>>
>>
>>
>> organization_delete apparently works fine - I assume that is what is
>> eventually invoked when you click the delete button on the Organization
>> page as despite the fact we get a "success" message it does not actually
>> get rid of the organization /group i.e. we can go to
>> https://ckan-app-dev.green.ersa.edu.au/organization/some-university or
>> https://ckan-app-dev.green.ersa.edu.au/group/some-university and see the
>> details
>> curl --user ersackan:ersa-rdsi-ckan  -k
>> https://ckan-app-dev.green.ersa.edu.au/api/3/action/organization_delete
>> -H "X-CKAN-API-KEY: <my api key>"  -d '{"id":"some-university"}'
>> {"help": "Delete a organization.\n\n    You must be authorized to delete
>> the organization.\n\n    :param id: the name or id of the organization\n
>>  :type id: string\n\n    ", "success": true, "result": null}
>> I guess demonstrates that the general from of my curl command is correct
>> (curl's -k flag just says ignore cert problems).
>>
>>
>> However organization_purge does not work from curl
>> curl --user ersackan:ersa-rdsi-ckan  -k
>> https://ckan-app-dev.green.ersa.edu.au/api/3/action/organization_purge
>> -H "X-CKAN-API-KEY: <my api key>"  -d
>> '{"id":"91a1ae30-2928-4722-89a7-0395fedb3010"}'
>> "Bad request - Action name not known: organization_purge"[root at ckan-db-dev
>> ~]#
>>
>>
>> Or from the CLI:
>> (default)[ckan at ckan-app-dev bin]$ echo '{"id":"flinders-university"}'|
>>  /usr/lib/ckan/default/bin/paster --plugin=ckan post -c
>>  /etc/ckan/default/development.ini /api/action/organization_purge
>> No handlers could be found for logger "ckan.controllers.api"
>>
>> I
>>
>>
>>
>>
>>
>>
>>
>>
>> --
>> Jason Tan
>> Data Infrastructure Specialist, eResearch SA
>>
>> phone: +61 8 8313 2184
>> Mob: +61 407 268 270
>> email: jason.tan at ersa.edu.au
>> web: http://www.ersa.edu.au
>>
>> _______________________________________________
>> ckan-dev mailing list
>> ckan-dev at lists.okfn.org
>> https://lists.okfn.org/mailman/listinfo/ckan-dev
>> Unsubscribe: https://lists.okfn.org/mailman/options/ckan-dev
>>
>>
>
> _______________________________________________
> ckan-dev mailing list
> ckan-dev at lists.okfn.org
> https://lists.okfn.org/mailman/listinfo/ckan-dev
> Unsubscribe: https://lists.okfn.org/mailman/options/ckan-dev
>
>


-- 
Jason Tan
Data Infrastructure Specialist, eResearch SA

phone: +61 8 8313 2184
Mob: +61 407 268 270
email: jason.tan at ersa.edu.au
web: http://www.ersa.edu.au
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.okfn.org/pipermail/ckan-dev/attachments/20140603/4e46e327/attachment-0003.html>


More information about the ckan-dev mailing list