Resolved create category_path from single xml field

Hello Chris,

Just the plain name of the division. So I need to "create" the path somehow and "hook" the different categories into a root category. How can I do this?

The example you posted has only one node LSR_ABT. Do you have other nodes to be combined and used in category_path field? If not you can directly use division as category_path field value and that will be considered as a path with single level.

The example you posted has only one node LSR_ABT. Do you have other nodes to be combined and used in category_path field? If not you can directly use division as category_path field value and that will be considered as a path with single level.

No, unfortunately I don't have any other nodes I could draw values from. The XML file has no hierarchy built in.

That is the follow up question, and it's theoretically at the moment (because I still struggle with the very basic import process). Here's my goal:

• I import all the categories from the XML
  
• at this moment they are all "flat", so no hierarchy.
  
• I'm attach all contacts to the system via import at a second run from the same file.
  
• My client creates the hierarchy in the backend by nesting the categories in the way the company is structured
  

So far, so good.
But this import process needs to be done regularily. Is it possible to make an import, correct contact data and category names, but keep the hierarchy / nesting?
I guess that will be quite tricky.

Thanks!
Chris

Hello Chris,

But this import process needs to be done regularily. Is it possible to make an import, correct contact data and category names, but keep the hierarchy / nesting?
I guess that will be quite tricky.

Yes that is really tricky. Unless there is nested category in category_path or category ID RO CSVI will not know which category row to update. It would think the category in the import file does not exists in database and creates a new row. One thing you can do is find and replace the category_path from import file to the created hierarchy / nesting categories using Find and Replace operation in RO CSVI Multi replace plugin. Something like example in the attached screenshot. But you have to do that for all category_path which is little a too much if the categories are more. Otherwise I don't see any other way to achieve what you need.

Yes that is really tricky. Unless there is nested category in category_path or category ID RO CSVI will not know which category row to update.

I understand. Completly.
Thanks for your contribution.
Maybe there is a way to use the category ids which Joomla will create with the initial import?
I'll put the question aside for the moment and think about it after the initial import of categories and contacts. There are still a lot of steps to take to this goal.
Can I bring up the thread when I'm ready?

Hello,

Can I bring up the thread when I'm ready?

Sure you can post your questions on the same thread when you are done with initial import.