How to bulk / mass add Weblink categories and items - Joomla! Forum - community, help and support

using joomla 3.7.2 weblinks component.

in weblinks, need add 50 categories, , 50 subcategories = approx 2,500 total subcategories.
each category , subcategory gets different name, nice able add categories , subcategories in bulk.

does know how this? without requiring scripting or mysql queries. thx.

it seems joomla content batch feature moving , copying things, not creating new items in batch mode. ditto j2xml.

you can directly in database without mysql queries.

use phpmyadmin (import/export csv) , spreadsheet:

• create 1 category , 1 subcategory in weblinks.
• use phpmyadmin export csv option add column headers
• open csv file spreadsheet
• use last 2 records have created 'template' new (sub)categories want create.
• you can use formulas create different category names.
• export newly created rows csv
• in phpmyadmin can import csv data.