Forum OpenACS Q&A: Bulk upload of categories?

Collapse
1: Bulk upload of categories?
Posted by Brian Fenton on 03/29/13 05:46 PM
Hi all

I'm looking into doing an import of Categories. I'm just wondering has anyone any experience doing this, or code examples to share? I'm looking at the XML procs in here https://openacs.org/api-doc/procs-file-view?path=packages%2fcategories%2ftcl%2fcategory%2dxml%2dprocs%2etcl and they look pretty good, but it'd be nice to see if anyone has experience importing from CSV or other formats.

thanks
Brian

Collapse
2: Re: Bulk upload of categories? (response to 1)
Posted by Dave Bauer on 03/29/13 06:09 PM
Seems like its pretty easy to do this by CSV

Something like:

Parent Category | Subcategory

Where you can create an infinite tree of categories based on the name by just looping over the rows in a CSV.

ie: If subcategory is blank create a new top level category. Otherwise create a subcategory of the category with the matching name for parent category.

This assumes you don't have any duplicate categories anywhere in the tree.

Collapse
3: Re: Bulk upload of categories? (response to 1)
Posted by Gustaf Neumann on 03/29/13 06:40 PM
if you use xowiki, you can let xowiki to the work for you. Make an xowiki::Form, add a form-field using the category tree (e.g. atest:radio,category_tree=audience), make an instance of the form and export it. The export will contain the definitions of the categories and will import the tree on the target machine and remaps the category_ids for this form to the new values.
Collapse
4: Re: Bulk upload of categories? (response to 1)
Posted by Brian Fenton on 04/01/13 12:27 PM
Thanks for the replies, guys!