Bulk Insert categories?

[xanin]

Is there a way to bulk insert categories? Can I do this via the DB directly if not in the admin interface?
Basically I've got a few hundred possible categories, its a fairly shallow tree, but I really don't want to type them all (currently have them all in a spreadsheet produced by someone else).

 

[tajhay]

Its gonna be a pain to view the items having to traverse through different categories man. Think about consolidating the categories if possible. If its gonna be a pain to type that id hate to think how you would be creating those items.

Utilise tags and prefixes if possible.

 

[Bob]

If you know what you are doing, yes, you can insert category data directly into the category table, however, you need to make sure all the required fields get the appropriate data (you can look at the Category DataWriter for that information). You'll also have to run the Category Rebuilds after so that the Nested Set values are properly set.

 

[xanin]

If you know what you are doing, yes, you can insert category data directly into the category table, however, you need to make sure all the required fields get the appropriate data (you can look at the Category DataWriter for that information). You'll also have to run the Category Rebuilds after so that the Nested Set values are properly set.

Splendid, thanks.