MG 2.0 Mass create categories ?

[markus68]

I have to create 100+ categories and want to use SQL (as I got a textfile containing the names).

Looking at the table xf_mg_category and some manually created entries there I wonder, what lftandrgtare used for and what values I would need to provide.
Can I leave breadcrumb_dataandfield_cacheempty ?
I guess I can copy the BLOB of a master-category if I want the same allowed_type ?

TIA,
-Markus

 

[markus68]

I opened a ticket for that topic and got the information that messing around with the categories-table via SQL is not recommended.
Mainly because of how the values of lftandrgtwould need to be constructed/computed.

-Markus