Why RO CSVI Doesn't Auto-Create Joomla Categories on Import
RO CSVI treats Joomla categories and articles as separate imports. Learn why category_path doesn't create categories automatically, sending articles to Uncategorised, and how to import categories first for proper assignment during bulk CSV imports.
Why doesn’t RO CSVI create categories automatically from category_path when importing Joomla articles? All materials end up in Uncategorised.
Import details:
- CSV fields:
category_path,title,region,bol,kvalifikatsionnaya,introtext,state,image_fulltext,image_fulltext_alt,image_fulltext_caption,image_intro,image_intro_alt,image_intro_caption - Using content template (com_content)
- Tried
category_pathvalues: Russian (e.g.,категория 1/категория2/категория 3), English test paths (e.g.,vsdfg/sdgdgd/dgdfg), numbers – none create categories
Documentation notes:
Requires title, category_path (full path like Техника/Смартфоны/Apple), alias, state, introtext, extension (com_content).
Articles import successfully but without category assignment. What am I missing for automatic category creation during bulk import?
RO CSVI doesn’t automatically create Joomla categories from the category_path field during article imports because it treats content (articles) and categories as separate components—you must import categories first using a dedicated Joomla Categories template. The category_path only assigns articles to existing categories matching the exact path (like Parent/Child/Subchild), sending mismatches to Uncategorised. To fix this, run a separate categories import beforehand, then retry your content import with fields like title, category_path, introtext, and state.
Contents
- Why RO CSVI Won’t Auto-Create Categories
- How category_path Really Works
- Step-by-Step: Import Categories First
- Setting Up Your Categories Import Template
- Content Import Best Practices
- Troubleshooting Uncategorised Articles
- Testing and Validation
- Sources
- Conclusion
Why RO CSVI Won’t Auto-Create Categories
Ever imported a bunch of Joomla articles with perfect category_path values, only to watch them pile up in Uncategorised? You’re not alone—it’s a common gotcha with RO CSVI. This tool handles Joomla content and categories as distinct imports. Articles get created or updated via the com_content template, but category_path (your full hierarchy like категория 1/категория2/категория 3) doesn’t build new categories on the fly.
Why the split? Categories need their own structure—titles, aliases, parents, custom fields, access levels. RO CSVI expects them pre-built so article assignment is fast and reliable. As the official RO CSVI extension page notes, it supports Joomla Content and Joomla Categories separately. Skip the category step, and boom—Uncategorised it is.
Think of it like building a house: you lay the foundation (categories) before hanging doors (articles). No foundation? Everything defaults to the junk drawer.
How category_path Really Works
category_path isn’t magic. It’s a simple slash-separated string matching existing category paths exactly—case-sensitive, no extras. Your tests with Russian paths, gibberish like vsdfg/sdgdgd/dgdfg, or numbers failed because those categories didn’t exist yet.
From the RO CSVI docs on category paths, it starts at the root and drills down: Top Level/Sub Level/Deep Level. But this is assignment-only. The support page on missing data spells it out: without a matching catid or category_path, you get errors or Uncategorised fallback. Your CSV has title and category_path—good start—but no categories means no match.
Quick tip: Paths ignore aliases by default; use full titles as they appear in Joomla. And state=1 ensures publishing, but categories are the blocker here.
Step-by-Step: Import Categories First
Ready to fix it? Don’t touch your article CSV yet. First, create categories.
- Go to RO CSVI > Import > New. Pick Joomla Categories template.
- Upload or paste a simple CSV:
title,parent_title(for hierarchy),alias,access,state=1.
- Example row:
категория 1,,kategoriya-1,1,1 - Nested:
категория2,категория 1,kategoriya2,1,1
- Run the import. Check Joomla > Categories—boom, structure built.
Now your article category_path like категория 1/категория2/категория 3 will snap right in. The Joomla Categories import docs confirm this handles custom fields too, once categories exist.
Takes 5 minutes. Worth it?
Setting Up Your Categories Import Template
Templates are RO CSVI’s powerhouse. For categories:
- Available fields:
title,alias,parent_title(key for nesting),description,image,params, custom fields. - In template settings: Enable Auto-generate alias if needed. Set Operation to Insert/Update.
- Custom fields? Joomla > Articles > Fields > Filter by category, create one. It’ll show in RO CSVI fields list, per Joomla Categories docs.
Your content template looks solid (category_path, introtext, images)—just sequence matters. Import categories > content.
Pro move: Export existing categories first (RO CSVI > Export > Joomla Categories) to template your CSV.
Content Import Best Practices
With categories in place, tweak your article import:
- Must-haves:
titleoralias, pluscategory_pathorcatid. Addextension=2(com_content value). - Images: Your
image_intro,image_fulltext_altetc. work fine—RO CSVI handles them. - Run settings: Preview first. Set Update on to
titleoralias. Verbose logging catches path mismatches.
Articles import fast now. But what if paths have typos? RO CSVI logs “No category found”—fix and re-run.
Troubleshooting Uncategorised Articles
Still stuck? Check these:
- Path mismatch: Exact titles? Trailing slashes? Use English test paths after real import to verify.
- Logs: RO CSVI debug mode shows “Missing required fields” if
category_pathfails. - Permissions: Categories need matching access levels.
- Multi-language? Paths per language.
Forum gripes like this VirtueMart thread echo it—subcats fail without priors. Nuke Uncategorised via SQL if needed, but prevent it upfront.
Testing and Validation
Test small: One category CSV row, one article. Verify in Joomla backend.
Export articles post-import (RO CSVI Export > Joomla Content)—category_path should match.
Scale up. You’re golden.
Sources
- RO CSVI - Joomla Extension Directory
- Joomla Categories - RO CSVI Documentation
- Joomla Categories Import - RO CSVI Documentation
- Creating the Category Path - RO CSVI Documentation
- Missing Data or Problem When Importing - RO CSVI Support
- Import Products in Sub-Category via RO CSVI Fails - VirtueMart Forum
Conclusion
RO CSVI keeps things modular: build categories separately, then assign via category_path for bulletproof imports. Miss that step, and Uncategorised awaits. Follow the two-import flow—categories first, content second—and your Joomla articles will land perfectly, every time. Scale confidently, no more headaches.